runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data

Former Member — Tue, 31 Dec 2013 07:39:20 GMT

Hi Experts,

We are facing a short dump while a batch job is being run (custom program, ran in job ). the run time error

'The error 3113 occurred in the current database connection "DEFAULT". "" DBIF_DSQL2_SQL_ERROR

occurs' at the following point in a native selects statement,

exec sql performing append_table.

select l.qualification, **********point where dump occured*********

l.individual_id,

l.emp_no,

to_char(l.start_date, 'YYYYMMDD'),

to_char(l.end_date, 'YYYYMMDD'),

l.action,

l.posted_to_host,

to_char(l.time_stamp, 'YYYYMMDDHH24MISS')

into :inrec

from prorad.sap_qualifications@sapr3.lsapinss l ( L in small actually )

where l.posted_to_host = 'N'

and to_char(l.start_date, 'YYYYMMDD') > '19980101'

endexec.

the select query retrieves data from "prorad.sap_qualifications@sapr3.lsapinss" ,

Is it any other server, is it due to connection probelem with the that server ? As its' bit old statement, what we undestood is that they are retrieving data from the above URL (Which might be a different server). Will basis give us input regarding the connection ?

Please find the attached dump details.Please let us know if any more details are required.

Please help us regarding the same. Thanks a Lot in advance.

Re: runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data

nabheetscn — Tue, 31 Dec 2013 08:06:59 GMT

Hi Rinki

If you study the dump its looks like connection was lost. Please get in touch with your administrator to understand more details for the same

Nabheet

Re: runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data

Former Member — Wed, 01 Jan 2014 07:47:38 GMT

Hi nabheet,

Thanks for your response.

We already did the same and ran againbut as it was bit frequent so thought if some other reason might be there.

topic Re: runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data in Application Development and Automation Discussions

runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data

Re: runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data

Re: runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data