In one active link we are querying a view created by AR Server - in another we are trying to query a table created by AR Server - and in another we are trying to query a table created in the database by us that resides in the realm of the Aradmin user.
Regards; Norm _____ From: Joe Martin D'Souza [via ARS (Action Request System)] [mailto:[email protected]] Sent: Thursday, June 02, 2011 01:57 PM To: Dignard, Norman Subject: Re: Direct SQL issue What are you trying to query using this Direct SQL? An internal table or view from the AR System database? Or an external DB link? I see an ORA-03113: end-of-file on communication channel on two process ID's both in your arerror as well as SQL log. This error is a generic communication error in Oracle between the Oracle client and the database server.. Joe -----Original Message----- From: NormD Sent: Thursday, June 02, 2011 1:38 PM Newsgroups: public.remedy.arsystem.general To: [hidden email] Subject: Direct SQL issue 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,C540 000083,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,C540 000083,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 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _____ If you reply to this email, your message will be added to the discussion below: http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-issue- tp6432163p6432233.html To unsubscribe from Direct SQL issue, click here <http://ars-action-request-system.1093659.n2.nabble.com/template/NamlSer vlet.jtp?macro=unsubscribe_by_code&node=6432163&code=ZGlnbmFybkBOQVZDQU5 BREEuQ0F8NjQzMjE2M3wxOTQ2MjEyNzIy> . -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Direct-SQL-issue-tp6432163p6444912.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"
