runtime error DBIF_DSQL2_SQL_ERROR [error code 3113]while fectching data

[Former Member]

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.

[nabheetscn]

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

[Former Member]

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.