This website is not affiliated with, sponsored by, or approved by SAP AG.

DBCON connection fail in backgroup job

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

DBCON connection fail in backgroup job

Postby bpandey1959 » Fri May 31, 2013 4:23 am

Dear Friends,

I have made one DBCON connection to fetch data from MS Sql. and one ABAP program scheduled in background.
While execution of background job it is getting fail. At the same time when it successed in foreground mod.
Dump of ST22 is appended below for your reference:

Internal session terminated with a runtime error DBIF_DSQL2_CONNECTERR"
What can you do?
Check the data required to establish the connection via Native
SQL (EXEC SQL). The identifier "XXXX" describes this data. It is possible
that too many connections have been opened. The maximum number of
active database connects for each work process is currently 16. For
further information on the error, see the system log.
I have test the connection of DBCON through SAP standard program ADBC_TEST_CONNECTION and found ok.

Please help in the matter.
Regards,
Bhagawati Pandey
bpandey1959
 
Posts: 2
Joined: Fri May 31, 2013 3:47 am

Re: DBCON connection fail in backgroup job

Postby Snowy » Mon Jun 03, 2013 10:41 pm

investigate dev_w* for the work process number that failed.
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28767
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535


Return to Basis

Who is online

Users browsing this forum: No registered users and 8 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.