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
> 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
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
