Issue With Application-Bus-Time-Subtract

2010-08-04 Thread Prashanth Bhagawat
Hi All,

We have an issue with Application-Bus-Time-Subtract command after migrating 
custom application from 6.3server to 7.5 server, this process command fails 
when there is a negative offset value passed as parameter into it. This works 
perfectly on 6.3 server, has any one faced this issue.  Is there a work around 
for this?

6.3 Filter Log Entry
FLTR TID: 006151 RPC ID: 001607 Queue: Fast   Client-RPC: 
390620USER: arsadm   
Application-Bus-Time-Subtract 1270072800 -5 4 KGAA_5x24 KGAA_5x24
FLTR TID: 006151 RPC ID: 001607 Queue: Fast   Client-RPC: 
390620USER: arsadm   Exit code: 
0  Value: 1270072800
FLTR TID: 006151 RPC ID: 001607 Queue: Fast   Client-RPC: 
390620USER: arsadm   Rottermin 
(536870928) = 04/01/10 00:00:00

7.5 Filter Log Entry
FLTR TID: 1087424832 RPC ID: 103404 Queue: Fast   Client-RPC: 
390620USER: aradmin  
   Application-Bus-Time-Subtract 1279058400 -5 4 KGAA_5x24 KGAA_5x24
FLTR TID: 1087424832 RPC ID: 103404 Queue: Fast   Client-RPC: 
390620USER: aradmin  
   Exit code: 1  Value:
FLTR TID: 1087424832 RPC ID: 103404 Queue: Fast   Client-RPC: 
390620USER: aradmin 
Command requires appropriate parameters
FLTR TID: 1087424832 RPC ID: 103404 Queue: Fast   Client-RPC: 
390620USER: aradmin    Error 
while performing filter action: Error 4567
FLTR TID: 1087424832 RPC ID: 103404 Queue: Fast   Client-RPC: 
390620USER: aradmin    Filter 
BMT:AGZ-501-SubmitIntoGAU: No enabled error

6.3 server is on patch 021
7.5 server  is on Patch 003 200909200825
Application was migrated using armigrator 7.5 patch003

Regards,
Prashanth Bhagawat



This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: WebServiceSoapClient class (ARERR 9130)-Resolved

2010-07-20 Thread Prashanth Bhagawat
Hi All,

This issue is resolved after applying the resolution given in 
'KM-00012192'. Thanks a lot!

Regards,

Prashanth

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Gajanan Swami
Sent: Tuesday, July 20, 2010 10:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: WebServiceSoapClient class (ARERR 9130)

Here you go...

You can refer 'KM-00012192' for same.

Regards,
Gajanan

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Prashanth Bhagawat
Sent: Friday, July 16, 2010 7:21 AM
To: arslist@ARSLIST.ORG
Subject: WebServiceSoapClient class (ARERR 9130)

**
Hi All,

We are noticing the below mentioned error message when we restart remedy 
service in arerror.log

Can't locate the WebServiceSoapClient class (ARERR 9130)

I could find the attached KB article but is of no help how can I proceed in 
debugging this further


Regards,

Prashanth


This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information. If you have received it in 
error, please notify the sender immediately and delete the original. Any other 
use of the email by you is prohibited.
_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_

DISCLAIMER:
This e-mail and any attached files may contain confidential and/or privileged 
material for the sole use of the intended recipient. Any review, use, 
distribution or disclosure by others is strictly prohibited. If you are not the 
intended recipient (or authorized to receive this e-mail for the recipient), 
you may not review, copy or distribute this message. Please contact the sender 
by reply e-mail and delete all copies of this message: Fujitsu Consulting India 
Pvt Limited

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_


This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Connection Time out While Consuming Web service

2010-07-19 Thread Prashanth Bhagawat
Hi All,

We have written a filter set field action to consume an external web service. 
When that filter is fired we are getting Timeout error.

Error message from filter log is as below:

FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 
620 USER: yellarth error when running a web service
FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 
620 USER: yellarth; nested exception is:
java.net.ConnectException: Connection timed out
FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 
620 USER: yellarth  Error while performing filter action: Error 9130
FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 
620 USER: yellarth  Filter PMT: SDO_100sm_SolveDirectOutputCal

The error message from arjavaplugin.log file is as below:

2010-07-19 08:36:52,754 ERROR [pool-2-thread-4] 
com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - 
ARSYS.ARF.WEBSERVICEjava.net.ConnectException: Connection timed out
AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode:
 faultString: java.net.ConnectException: Connection timed out
 faultActor:
 faultNode:
 faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: 
Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:525)
at 
com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:550)
at 
com.sun.net.ssl.internal.ssl.SSLSocketImpl.lt;initgt;(SSLSocketImpl.java:353)
at 
com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:71)
at 
org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:92)
at 
org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191)
at 
org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404)
at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138)
at 
org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
at org.apache.axis.client.Call.invoke(Call.java:2767)
at org.apache.axis.client.Call.invoke(Call.java:1910)
at com.bmc.arsys.ws.client.WebServiceSoapClient.call(Unknown Source)
at com.bmc.arsys.ws.plugin.WSPlugin.filterAPICall(Unknown Source)
at 
com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository.ARFilterApiCall(Unknown
 Source)
at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_5(Unknown Source)
at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_4(Unknown Source)
at 
com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source)
at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source)
at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source)
at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown 
Source)
at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown 
Source)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

ar.conf settings is as bellow:
Server-Plugin-Alias: ARSYSTEM.ARF.WEBSERVICE ARSYSTEM.ARF.WEBSERVICE 
servername:

ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/arapi75.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/log4j-1.2.14.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/arapiext75.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/arregistryplugin75.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/websvcjava75.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/WSRegistryAPI7.5.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/bin/commons-logging-1.0.4.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/api/lib/ardoc75.jar
ARF-Java-Class-Path: /opt/bmc/ARSystem/bin/wsdl4j.jar

Plugin-Log-Level: 100

How to debug this issue?, we have noticed this on our new environment 7.5 where 
we have migrated our application from 6.3 environment, we are using the same 
wsdls in new environment too.

Regards,
Prashanth Bhagawat



This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender

Re: ARS 6.3/Oracle 9 -to- ARS 7.5/Oracle 11g

2010-07-18 Thread Prashanth Bhagawat
Hi Tripathi,



If it's mentioned in the product manual about the compatibility, then its there 
for some reason, you might or might not get problems while installation.



We were trying something similar upgrading 6.3/9i  upgrade database to 10g 
upgrade ARS 6.3 to 7.1upgrade 7.1 to 7.5, but up-gradation failed while 
going to 7.5, 10g upgrade should not take more time so don't skip any steps in 
your up gradation activity. Go through the release notes or installation guides 
of ARS for each version and document the steps that you need to take care for 
ARS up-gradation as well as database specific settings you need to do and then 
start up-gradation.



Few things that you need to take care is that no duplicate user profile entries 
in user form

If there are any customizations done on user and group forms then you will have 
issues with the views of the user and group forms once you upgrade to 7.1



You are attempting an ITSM up-gradation or custom application, if it is set of 
custom applications then you can think of migration from 6.3 to 7.5 using 
remedy migrator directly, all you need is setup of your new 7.5 environment.



Regards,



Prashanth Bhagawat







-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi
Sent: Saturday, July 17, 2010 12:18 AM
To: arslist@ARSLIST.ORG
Subject: ARS 6.3/Oracle 9 -to- ARS 7.5/Oracle 11g



Hi all,

To make the above switch, I am planning to first upgrade to Oracle 10g, then 
upgrade ARS to 7.5, then upgrade Oracle to 11g.



The key fact being that Oracle 11g is not supported by ARs 6.3, but Oracle 10g 
is supported by both ARS 6.3 and ARS 7.5.



The lazy in me is trying to find out if I can somehow skip 10g. To do so, I 
would have to try ARS 7.5 with Oracle 9, or ARS 6.3 with Oracle 11g. I know 
these are not supported combinations, but it doesn't mean I can't have them 
(especially for the duration of the upgrade work). Anybody done it?



ARS (both 6.3 and future 7.5) and Oracle 9 are in Solaris. Oracle 10g, 11g will 
be in Linux.



Thanks in advance.









___

UNSUBSCRIBE or access ARSlist Archives at www.arslist.org

attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are




This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Re: Remedy Email Notification Subject Line is Blank*Resolved*

2010-07-18 Thread Prashanth Bhagawat
Hi All,

This issue is resolved, as suggested in the arlist I added public permissions 
to Subject field on one of our custom email messages form (IMPT Messages) after 
this change I was able to see subject line in the ar system email messages 
form, am sure this was not a permission issue since I was able to display the 
subject line content using a message action in the filter just before the 
notify action.

Not to worry much about permissions, this work around has fixed the problem 
right now. So thanks a lot for Arslist community members.

Regards,
Prashanth Bhagawat

From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Arner, Todd
Sent: Friday, July 16, 2010 7:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Email Notification Subject Line is Blank

Is it possible that the subject field is set to Display Only? I have ran into 
problems pushing data to an email from a display only field... Just a thought.

Todd Arner


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Prashanth Bhagawat
Sent: Friday, July 16, 2010 1:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Email Notification Subject Line is Blank
** --
Hi Thad,

There is no filter which is clearing the subject line, and permission isn't an 
issue to, it has got similar permission to that of the body which is getting 
set on AR system email messages form.

Br,

Prashanth


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Thad Esser
Sent: Thursday, July 15, 2010 8:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Email Notification Subject Line is Blank

** Prasanth,

If permissions aren't the issue, maybe phasing is.  As notify actions are phase 
3 actions, could there be any other workflow resetting the subject before the 
notify actually happens?

One other unlikely thing to check is the execution order of your filters.  
Filters with the same execution order could fire in any order.  By migrating to 
a new server you change the modified date (which is the not-quite-so-random 
piece of how they fire), and that could change the order in which they fire 
such that the notify happens before the set fields.

Good luck,
Thad
On Thu, Jul 15, 2010 at 5:00 AM, Terry Bootsma 
tboot...@objectpath.commailto:tboot...@objectpath.com wrote:
** Change the permission of the field which you are copying to the subject in 
the ARSystem Email Messages form to public (ie. the source field) .  You 
should find this will work...  Had the same issue here a few days ago.

Terry


On Jul 15, 2010, 
prashanth.bhaga...@accenture.commailto:prashanth.bhaga...@accenture.com 
wrote:
**
Hi All,

we got an issue related to email notification , subject line of the email 
generated in ar system email messages is blank. we have custom built 
applications, there is IPMT email messages a custom built email notification 
form where we store all the emails generated there first then a filter on this 
form has got notify action which reads subject, body and user related 
information from this form as current value and creates entries in AR system 
email messages form, all the field values are there for the email created in 
arsystem email messages form except for subject line. i can see subject inITPMT 
email message form where notify action reads the data.

When i add  $subject$ in a message action of the filter before the notify 
action message shows the email subject value, but after notify action subject 
line is blank in email messages form.

I did few of the below mentioned tasks to check if these resolves the issue but 
no help
1. I recreated the field on custom built IPMT email messages form
2. resaved the filter with notify action- no use
3. Removed $subject$ from the notify action of the filter ie it was blank and 
remedy defaulted the value to AR System Notification
4. Included a core field in the subject ex. assigned to and the value of the 
assigned to was pushed into ar system email messages form which was strange.
This issue we have observed during the testing of migrated application, ie we 
have migrated remedy 6.3 application into 7.5 server. This works fine in 6.3 
system, we have used remedy migrator to migrate the application.
Has any one faced this issue before?
What could have gone wrong? How can i debug this since filter log will not 
indicate something that has gone wrong in notify action of the filter?


Regards,
Prashanth




This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information. If you have received it in 
error, please notify the sender immediately and delete the original. Any other 
use of the email by you is prohibited.
_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_
_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com

Re: Remedy Email Notification Subject Line is Blank

2010-07-16 Thread Prashanth Bhagawat
Hi Thad,

There is no filter which is clearing the subject line, and permission isn't an 
issue to, it has got similar permission to that of the body which is getting 
set on AR system email messages form.

Br,

Prashanth


From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Thad Esser
Sent: Thursday, July 15, 2010 8:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Email Notification Subject Line is Blank

** Prasanth,

If permissions aren't the issue, maybe phasing is.  As notify actions are phase 
3 actions, could there be any other workflow resetting the subject before the 
notify actually happens?

One other unlikely thing to check is the execution order of your filters.  
Filters with the same execution order could fire in any order.  By migrating to 
a new server you change the modified date (which is the not-quite-so-random 
piece of how they fire), and that could change the order in which they fire 
such that the notify happens before the set fields.

Good luck,
Thad
On Thu, Jul 15, 2010 at 5:00 AM, Terry Bootsma 
tboot...@objectpath.commailto:tboot...@objectpath.com wrote:
** Change the permission of the field which you are copying to the subject in 
the ARSystem Email Messages form to public (ie. the source field) .  You 
should find this will work...  Had the same issue here a few days ago.

Terry



On Jul 15, 2010, 
prashanth.bhaga...@accenture.commailto:prashanth.bhaga...@accenture.com 
wrote:
**
Hi All,

we got an issue related to email notification , subject line of the email 
generated in ar system email messages is blank. we have custom built 
applications, there is IPMT email messages a custom built email notification 
form where we store all the emails generated there first then a filter on this 
form has got notify action which reads subject, body and user related 
information from this form as current value and creates entries in AR system 
email messages form, all the field values are there for the email created in 
arsystem email messages form except for subject line. i can see subject inITPMT 
email message form where notify action reads the data.

When i add  $subject$ in a message action of the filter before the notify 
action message shows the email subject value, but after notify action subject 
line is blank in email messages form.

I did few of the below mentioned tasks to check if these resolves the issue but 
no help
1. I recreated the field on custom built IPMT email messages form
2. resaved the filter with notify action- no use
3. Removed $subject$ from the notify action of the filter ie it was blank and 
remedy defaulted the value to AR System Notification
4. Included a core field in the subject ex. assigned to and the value of the 
assigned to was pushed into ar system email messages form which was strange.
This issue we have observed during the testing of migrated application, ie we 
have migrated remedy 6.3 application into 7.5 server. This works fine in 6.3 
system, we have used remedy migrator to migrate the application.
Has any one faced this issue before?
What could have gone wrong? How can i debug this since filter log will not 
indicate something that has gone wrong in notify action of the filter?


Regards,
Prashanth




This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information. If you have received it in 
error, please notify the sender immediately and delete the original. Any other 
use of the email by you is prohibited.
_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_
_attend WWRUG10 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers 
Are_

_attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_


This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


WebServiceSoapClient class (ARERR 9130)

2010-07-16 Thread Prashanth Bhagawat
Hi All,

We are noticing the below mentioned error message when we restart remedy 
service in arerror.log

Can't locate the WebServiceSoapClient class (ARERR 9130)

I could find the attached KB article but is of no help how can I proceed in 
debugging this further


Regards,

Prashanth



This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Remedy Email Notification Subject Line is Blank

2010-07-15 Thread Prashanth Bhagawat
Hi All,

we got an issue related to email notification , subject line of the email 
generated in ar system email messages is blank. we have custom built 
applications, there is IPMT email messages a custom built email notification 
form where we store all the emails generated there first then a filter on this 
form has got notify action which reads subject, body and user related 
information from this form as current value and creates entries in AR system 
email messages form, all the field values are there for the email created in 
arsystem email messages form except for subject line. i can see subject inITPMT 
email message form where notify action reads the data.

When i add  $subject$ in a message action of the filter before the notify 
action message shows the email subject value, but after notify action subject 
line is blank in email messages form.

I did few of the below mentioned tasks to check if these resolves the issue but 
no help
1. I recreated the field on custom built IPMT email messages form
2. resaved the filter with notify action- no use
3. Removed $subject$ from the notify action of the filter ie it was blank and 
remedy defaulted the value to AR System Notification
4. Included a core field in the subject ex. assigned to and the value of the 
assigned to was pushed into ar system email messages form which was strange.
This issue we have observed during the testing of migrated application, ie we 
have migrated remedy 6.3 application into 7.5 server. This works fine in 6.3 
system, we have used remedy migrator to migrate the application.
Has any one faced this issue before?
What could have gone wrong? How can i debug this since filter log will not 
indicate something that has gone wrong in notify action of the filter?


Regards,
Prashanth



This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


Importing 6.3 Deff to 7.5 Using 7.5 Dev Studio.

2010-06-10 Thread Prashanth Bhagawat
Hi,

I need some Clarification on my query, what's the impact of importing forms 
from 6.3 ARS server to 7.5 ARS server.


 1.  I would export a form definition created in 6.3 using admin tool and 
import that to 7.5 server using developer studio. Will there be an impact on 
the imported form on ARS 7.5 server ever
 2.  would this create a problem if there is data in that
 3.  when I was testing this Dev studio gave me a message while importing 
Definition file does not specify a character set Developer studio will use 
local machine character set to import what does this means?

Basically am checking for the possibility of migrating a couple of forms with 
work flow which were developed in 6.3 server into 7.5 server without using 
migratory, but by just definition import and export.

Has any one tried this and encountered any issues?

Thanks,

Prashanth


This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are


ARS 7.5 upgrade Failure from ARS 7.1

2010-06-08 Thread Prashanth Bhagawat
Hi All,

I need help on debugging the ARS 7.5 upgrade failure from ARS 7.1, before that 
let me give a brief description of the approach that's being used for upgrade.

Task: upgrade remedy ARS 6.3 to 7.5 and database from oracle 9i to 10g, with 
custom built applications.


Approach: Install ARS 6.3 ,Oracle 9i P2 on Local Server, Import aradmin schema 
from production database dump to ARS 6.3 Oracle 9i local server,

  Upgrade database 9i to 10g,

  Upgrade ARS from 6.3 to 7.1,

  Upgrade ARS from 7.1 to 7.5,

  Finally again do a data import of aradmin schema from the 
local server database dump to the test server where there ARS 7.5 is already 
installed with Oracle 10g database.





Current Status: Upgrade to ARS 7.1 was successful with only one issue of 
duplicate views for group and user form due to customizations done on these 
form, customized views were copied to the proper view and old views were 
deleted, after which 7.1 upgrade was a success with stable server and stable 
applications without any errors.


Upgrade Failure: Upgrade of ARS 7.1 to ARS 7.5 Failed, all the pre-requisite 
before upgrade was followed with out missing any steps still the up gradation 
failed due to below mentioned errors. Has any one faced this problem, how to 
fix this up gradation failure, any hint or suggestion to fix this will be of 
great help!

Error: error from arinstall.log

{Description=[ARServerManageUpgradeDatabaseBusinessTask.description],Progress=[25],Detail=[ARServerManageUpgradeDatabaseBusinessTask.generateDatabaseSchema]}
(Jun 08 2010 12:43:48.901 PM 
+0530),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask,
  LOG EVENT {Description=[[SQLERROR] [DESCRIPTION] Failed to upgrade the 
database schema],Detail=[[SQLERRORCODE]=17068 [SQLMESSAGE]=Invalid argument(s) 
in

call[SQLSTATEMENT]=]}
(Jun 08 2010 12:43:48.901 PM 
+0530),SEVERE,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerOracleManageUpgradeDatabaseTask,
  THROWABLE EVENT {Description=[Failed to upgrade the database schema]},
  Throwable=[java.sql.SQLException: Invalid argument(s) in call
  oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:119)
  oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:115)
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:221)
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:293)
  oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:574)
  
oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:7054)
  
com.bmc.install.utility.database.io.DatabaseModelJDBCReader.readIndexes(DatabaseModelJDBCReader.java:1002)
  
com.bmc.install.utility.database.io.DatabaseModelJDBCReader.readSchemaTables(DatabaseModelJDBCReader.java:522)
  
com.bmc.install.utility.database.io.DatabaseModelJDBCReader.readSchema(DatabaseModelJDBCReader.java:316)



Environment information of local server:

OS: Windows XP service Pack 2[ professional]

Oracle 10g

ARS 7.5 patch 3



Regards,



Prashanth





This message is for the designated recipient only and may contain privileged, 
proprietary, or otherwise private information.  If you have received it in 
error, please notify the sender immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are