On our windows box we found that applying the following change to the registry fixed our issues. Don't know if it is applicable, but we were seeing similar errors when this got out of whack.
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g\NSL_LANG=AMERICAN_AM ERICA.AL32UTF8 ~Jim From: Leonard Neely - FOJ [mailto:lne...@focusonjobs.com] Sent: Tuesday, March 16, 2010 12:28 PM Subject: Re: AR Server starts with errors after upgrade of Oracle client from 10.2.0 to 10.2.0.4 ** Thanks Mark. As you mentioned, It appears to be related to the known issue with the Oracle Client 10.2.0.4 as documented in SW00333862. Though the article offers a workaround, in our case, a decision was made to downgrade the client back to 10.2.0.1, which was on our original build and is known to work. Thanks! Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Walters, Mark Sent: Monday, March 15, 2010 9:42 AM To: arslist@ARSLIST.ORG Subject: Re: AR Server starts with errors after upgrade of Oracle client from 10.2.0 to 10.2.0.4 ** Do you have some localised views of this form installed on Unicode server? If so it sounds like defect SW00333862. Try the following workaround; *) start the server with the older client and open the SRS:ServiceRequestConsole form in the admin tool. *) Save the background graphic image from the Default Admin View to disk (Form, Current View, Properties, Appearance, Save to Disk) and then delete it from all the other views and save them. *) restart the server with the updated client - hopefully without errors *) open the form again and add the background image back to each view and save. *) restart to confirm the errors are not present. Mark From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Neely, Leonard Sent: 15 March 2010 00:24 To: arslist@ARSLIST.ORG Subject: AR Server starts with errors after upgrade of Oracle client from 10.2.0 to 10.2.0.4 ** Hi Listers, We are having issues getting arserver to successfully start after having patched the Oracle Client to level 10.2.0.4. Has anybody experienced any issues in this area? The error message we are seeing on startup are: Thu Mar 11 12:38:41 2010 390600 : Missing data in the SQL database (propList format -- 34\20\4\7\enduser\162\2\7\164\2\0\165\2\0\166\4\8\0xe5dfd4\167\9\2\29642 6\ffd8ffe000104a46494600010100000100010000ffdb00430001010101010101010101 0101010101010101010101010101010101010101010101010101010101 (ARERR 556) Thu Mar 11 12:38:41 2010 SRS:ServiceRequestConsole Thu Mar 11 12:39:04 2010 390600 : Form does not exist on server (ARERR 303) Thu Mar 11 12:39:04 2010 390600 : Error in definition for an active link (ARERR 399)... Then a long list of subsequent errors from workflow that can't see the "SRS:ServiceRequestConsole" form. After startup, logging into the User Tool produces an error (Can't generate Application List) on the Home Page, and no navigation links are present. Other forms can be accessed, as long as the form does not contain an Application List field. Environment: (Test) Hardware: sun4v OS: SunOS 5.10 Server Language: en_US;UTF-8 Database Version: Oracle 10.2.0.4.0 - 64bit ARS: 7.1.00 Patch 007 ITSM: 7.0.3 Patch 008 Notes: * We have three (3) app servers which point to the db instance mentioned above. * Two (2) of the servers (running the 10.2.0 client) work fine and start without errors. * Only the server running the 10.2.0.4 client has the issues. o If we roll back the client on this server to 10.2.0, it also works fine. * Our requirements call for the oracle client to be at 10.2.0.4 so we need to resolve this issue, then apply to the other two servers. Any feedback would be greatly appreciated. Leonard Neely Column Technologies _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"