IOne of our developers noticed that when we change an active link that makes use of the DIRECT SQL option and then try the code we get the attached arerr_90. We get around this issue by removing the sql portion of the link on the server and re-creating it in the developer studio and then we no longer get this issue.
They noticed this when they modified an active link with a direct sql call on development. It worked fine on development, but after importing this link to test server they got the arerr 90 message when they tried to run the update. It is not local to one computer as others have come across this difficulty. Anyone have any suggestions on this? ************************************************** arerror.log Thu May 05 10:36:31 2011 390635 : The SQL database operation failed. (ARERR 552) Thu May 05 10:36:31 2011 ORA-03113: end-of-file on communication channel Process ID: 6044 Session ID: 14 Serial number: 21652 Thu May 05 10:37:04 2011 390635 : The SQL database operation failed. (ARERR 552) Thu May 05 10:37:04 2011 ORA-03113: end-of-file on communication channel Process ID: 5928 Session ID: 248 Serial number: 13475 api.log > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:31.6610 */+GLCO > ARGetListContainer -- changed since Wed Dec 31 19:00:00 1969 from Mid-tier > (protocol 18) at IP address 127.0.0.1 <API > <TID: 0000005776> <RPC ID: 0000060353> <Queue: Fast > <Client-RPC: 390620 > <USER: howatts > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:31.6610 */-GLCO > OK <API > <TID: 0000004492> <RPC ID: 0000060352> <Queue: List > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:31.6610 */-GLE > OK <API > <TID: 0000005396> <RPC ID: 0000060324> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:32.2540 */-GLEWF > FAIL ARERROR: 552 ... ... <API > <TID: 0000004196> <RPC ID: 0000060474> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:57.6120 */+GSF ARGetField -- schema AR System Email Messages fieldId 1 from E-mail Engine (protocol 18) at IP address 10.128.34.12 <API > <TID: 0000004196> <RPC ID: 0000060474> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:57.6120 */-GSF > OK <API > <TID: 0000005396> <RPC ID: 0000060475> <Queue: List > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:57.6120 */+GLE ARGetListEntry -- schema AR System Email Messages from E-mail Engine (protocol 18) at IP address 10.128.34.12 <API > <TID: 0000005396> <RPC ID: 0000060475> <Queue: List > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:57.6120 */-GLE > OK <API > <TID: 0000004492> <RPC ID: 0000060476> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.0930 */+GLEWF ARGetListEntryWithFields -- schema NESAWeb:View:Folders:FolderPermissions from Mid-tier (protocol 18) at IP address 127.0.0.1 <API > <TID: 0000004492> <RPC ID: 0000060476> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.0930 */-GLEWF > OK <API > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.1080 */+GLEWF ARGetListEntryWithFields -- schema J030:J031:LCM from Mid-tier (protocol 18) at IP address 127.0.0.1 <API > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.1060 */-GLEWF > FAIL ARERROR: 552 <API > <TID: 0000005776> <RPC ID: 0000060478> <Queue: Fast > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.4970 */+GSI ARGetServerInfo -- as user Remedy Application Service from Application Command Dispatcher (protocol 18) at IP address 10.128.34.12 arfiler.log J030:J031:LCM:P001:J016 - 032069|000000000971460|U007444|U007444|DEPEND000449020|J016-283492 <FLTR> <TID: 0000004492> <RPC ID: 0000060287> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:24.1500 */ End of filter processing (phase 1) -- Operation - GET on J030:J031:LCM:P001:J016 - 032069|000000000971460|U007444|U007444|DEPEND000449020|J016-283492 <FLTR> <TID: 0000004196> <RPC ID: 0000060325> <Queue: Fast > <Client-RPC: 390620 > <USER: howatts > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:29.0220 */ Start filter processing (phase 1) -- Operation - CREATE on DASHBOARD_ACCESS_AUDIT - <NULL> <FLTR> <TID: 0000004196> <RPC ID: 0000060325> <Queue: Fast > <Client-RPC: 390620 > <USER: howatts > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:29.0220 */ End of filter processing (phase 1) -- Operation - CREATE on DASHBOARD_ACCESS_AUDIT - <NULL> <FLTR> <TID: 0000005776> <RPC ID: 0000060388> <Queue: Fast > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:42.9190 */ Start filter processing (phase 1) -- Operation - GET on J030 Personal Groupings - 032389 <FLTR> <TID: 0000005776> <RPC ID: 0000060388> <Queue: Fast > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:42.9190 */ End of filter processing (phase 1) -- Operation - GET on J030 Personal Groupings - 032389 plugin.log <PLGN> <TID: 005148> <RPC ID: 0000000197> <Queue: ARDBC > <Client-RPC: 390695> /* Thu May 05 2011 10:35:26.4700 */-GE OK <PLGN> <TID: 005148> <RPC ID: 0000000198> <Queue: ARDBC > <Client-RPC: 390695> /* Thu May 05 2011 10:35:26.4700 */+CT ARDBCCommitTransaction -- vendor REMEDY.ARDBC.SERVER.ADMINISTRATION <PLGN> <TID: 005148> <RPC ID: 0000000198> <Queue: ARDBC > <Client-RPC: 390695> /* Thu May 05 2011 10:35:26.4700 */-CT OK <PLGN> <TID: 005148> <RPC ID: 0000000199> <Queue: ARDBC > <Client-RPC: 390695> /* Thu May 05 2011 10:37:15.3190 */+GLEWF ARDBCGetListEntryWithFields -- vendor REMEDY.ARDBC.SERVER.ADMINISTRATION table Server Info Form <PLGN> <TID: 005148> <RPC ID: 0000000199> <Queue: ARDBC > <Client-RPC: 390695> /* Thu May 05 2011 10:37:15.3190 */<REMEDY.ARDBC.SERVER.ADMINISTRATION> <FINEST> ARDBCGetListEntryWithFields Start arsql.log <SQL > <TID: 0000005776> <RPC ID: 0000060344> <Queue: Fast > <Client-RPC: 390620 > <USER: howatts > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:30.7240 */SELECT lastChanged FROM arschema WHERE (schemaId = 2662) <SQL > <TID: 0000005776> <RPC ID: 0000060344> <Queue: Fast > <Client-RPC: 390620 > <USER: howatts > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:30.7240 */OK <SQL > <TID: 0000005396> <RPC ID: 0000060324> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:31.2240 */*** ERROR *** ORA-03113: end-of-file on communication channel Process ID: 6044 Session ID: 14 Serial number: 21652 <SQL > <TID: 0000004492> <RPC ID: 0000060349> <Queue: List > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:31.4730 */SELECT T1584.C1,C18092,C18090,C18099,C18083 FROM T1584 WHERE ((T1584.C18093 = 'AG001B7840C680_PHCRgG7TqAwYI0A') AND (T1584.C18098 = 1) AND (T1584.C18092 = 0)) ORDER BY 1 ASC <SQL > <TID: 0000004492> <RPC ID: 0000060349> <Queue: List > <Client-RPC: 390620 > <USER: Remedy Application Service > <Overlay-Group: 1 > /* Thu May 05 2011 10:36:31.4730 */OK <SQL > <TID: 0000004492> <RPC ID: 0000060476> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.0930 */SELECT T2407.C1,C60032,C60042 FROM T2407 WHERE (T2407.C1 = '030690') ORDER BY 1 ASC <SQL > <TID: 0000004492> <RPC ID: 0000060476> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.0930 */OK <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.1080 */SELECT * FROM ( SELECT T2696.C1,C536870914,C540000079,C2118520001,C540000013,C8,C540000085,C540000083,C536878220,C536870916,C536870926 FROM T2696 WHERE ((T2696.C536870913 = 'RSIT 1.14.2') AND (T2696.C2 = 'taylorl')) ORDER BY 1 ASC ) WHERE ROWNUM <= 1001 <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.1400 */OK <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:05.0910 */*** ERROR *** ORA-03113: end-of-file on communication channel Process ID: 5928 Session ID: 248 Serial number: 13475 <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.0910 */COMMIT WORK RELEASE <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.0910 */CONNECT ARAdmin <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.1060 */SELECT VALUE from V$NLS_PARAMETERS where PARAMETER = 'NLS_LENGTH_SEMANTICS' <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.1060 */OK .... ... <SQL > <TID: 0000004492> <RPC ID: 0000060476> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.0930 */SELECT T2407.C1,C60032,C60042 FROM T2407 WHERE (T2407.C1 = '030690') ORDER BY 1 ASC <SQL > <TID: 0000004492> <RPC ID: 0000060476> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.0930 */OK <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.1080 */SELECT * FROM ( SELECT T2696.C1,C536870914,C540000079,C2118520001,C540000013,C8,C540000085,C540000083,C536878220,C536870916,C536870926 FROM T2696 WHERE ((T2696.C536870913 = 'RSIT 1.14.2') AND (T2696.C2 = 'taylorl')) ORDER BY 1 ASC ) WHERE ROWNUM <= 1001 <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:03.1400 */OK <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:05.0910 */*** ERROR *** ORA-03113: end-of-file on communication channel Process ID: 5928 Session ID: 248 Serial number: 13475 <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.0910 */COMMIT WORK RELEASE <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.0910 */CONNECT ARAdmin <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.1060 */SELECT VALUE from V$NLS_PARAMETERS where PARAMETER = 'NLS_LENGTH_SEMANTICS' <SQL > <TID: 0000005396> <RPC ID: 0000060477> <Queue: List > <Client-RPC: 390620 > <USER: dignarn > <Overlay-Group: 1 > /* Thu May 05 2011 10:37:06.1060 */OK Debugger ReturnCode: ERROR Status List : 1 items Status Struct : Message type : ERROR Message number : 90 Message: Cannot establish a network connection to the AR System server Appended: localhost : RPC: Rpcbind failure - RPC: Unable to receive -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-issue-tp6432163p6432163.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
