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