As LJ points out, if the AR server was issuing the SQL it would be inside the API call. However, this is a vendor form backed by an ARDBC plugin, and it is this that is doing the actual data fetching. You’ll need to see what debug options are available for the plugin or, failing that, at the remote database end itself.
Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: 18 March 2015 16:19 To: arslist@ARSLIST.ORG Subject: Re: How to find SQL query while querying a vendor form ** Saurabh, If it was there, I would expect it to be between these two lines /* Wed /Mar 18 2015 07:28:08.4525 */+GLEWFARDBCGetListEntryWithFields – vendor CROOM.ARDBC.POSTGRE table ORB:asset_display /* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/ but it's not there...you can try changing the logging level from whatever it is right now to Debug, restart the plugins, and try again to see if CROOM put debug statements into the log so you can see that sort of data....but I don't know if it was done or not. On Wed, Mar 18, 2015 at 9:45 AM, MalviyaSaurabh <malviya.saurab...@gmail.com<mailto:malviya.saurab...@gmail.com>> wrote: i All, An active link is defined on a display-only form, its set field action is querying a vendor form using the EXTERNAL operator. From the extract of the below plugin log I can see its failing when tryin to query ORB:asset_display form. I am getting an error like shown below: /Database error: could not receive data from server: Error 0 while trying to execute SQL statement: SELECT CAST("element_id" as varchar(15)) as PriKey, A."asset_hostname" as COL0, A."asset_labelname" as COL1, A."asset_operation_status" as COL2, A."asset_s (ARERR 10502)/ I would like to know about the full SQL query which is queried at the external database. Can anybody point out from which log I might be able to fetch our this full query ?? Enabling SQL log is not helping me. ARDBCGetEntry – vendor CROOM.ARDBC.POSTGRE table ORB:project_display entry 512991 <PLGN> <TID: 000020> <RPC ID: 0000102723> <Queue: ARDBC > <Client-RPC: 390695> /* Wed Mar 18 2015 07:28:07.9915 */-GE OK <PLGN> <TID: 000020> <RPC ID: 0000102724> <Queue: ARDBC > <Client-RPC: 390695> /* Wed Mar 18 2015 07:28:07.9921 */+CT ARDBCCommitTransaction – vendor CROOM.ARDBC.POSTGRE <PLGN> <TID: 000020> <RPC ID: 0000102724> <Queue: ARDBC > <Client-RPC: 390695> /* Wed Mar 18 2015 07:28:07.9927 */-CT OK <PLGN> <TID: 000020> <RPC ID: 0000102725> <Queue: ARDBC > <Client-RPC: 390695> /* Wed /Mar 18 2015 07:28:08.4525 */+GLEWF ARDBCGetListEntryWithFields – vendor CROOM.ARDBC.POSTGRE table ORB:asset_display <PLGN> <TID: 000020> <RPC ID: 0000102725> <Queue: ARDBC > <Client-RPC: 390695> /* Wed Mar 18 2015 07:28:08.8188 */-GLEWF FAIL/ <PLGN> <TID: 000020> <RPC ID: 0000102726> <Queue: ARDBC > <Client-RPC: 390695> /* Wed Mar 18 2015 07:28:08.8199 */+RT ARDBCRollbackTransaction – vendor CROOM.ARDBC.POSTGRE <PLGN> <TID: 000020> <RPC ID: 0000102726> <Queue: ARDBC > <Client-RPC: 390695> /* Wed Mar 18 2015 07:28:08.8556 */-RT FAIL Regards, Saurabh -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/How-to-find-SQL-query-while-querying-a-vendor-form-tp121104.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> "Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_ BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
