cancel
Showing results for 
Search instead for 
Did you mean: 

Database error -901 at OPC

Former Member
0 Kudos

Hi SAP Gurus,

We are running Data load (data load to InfoPackage) job from Process chain daily. Around once or twice a month the job is filing with error occur in source system. In source system error is "Database error -901 at OPC".

Here is error log from SM21:

Database error -901 at OPC

> SQL system error. MSGID= Job=186933/SCP54/WP20

Database error -901

Detail log in first error is:

Module nam Line Table Name Field Name

dbds       398  -901       OPC

If I restart job it finished fine. It might not fail for few days. Work process change every time. We check IBM AS400 side, no error.

Thanks in advance for help.

Accepted Solutions (0)

Answers (2)

Answers (2)

brian_quigley
Explorer
0 Kudos

Hi,

There will be more information on the error in the OS level job log for the work process the error occured in.

Note 116192 explains how to use WRKJOB to find it :

  1. WRKJOB JOB(<qualified job name>)
Former Member
0 Kudos

Hi Brian and Volker,

Sorry for late reply. Please find OS job log below.

The job failed again with same error:

01:06:08 BTC  021 100 RFC_SERVICE BY  2 Database error -901 at OPC

01:06:08 BTC  021 100 RFC_SERVICE BY  0 > SQL system error. MSGID= Job=188483/SCP54/WP21

  01:06:08 BTC 021 100 RFC_SERVICE BY  1 Database error -901

OS job log for WP21:

C  sqlcode: -901

C  sqlerrd[2]: 0

C  sqlerrd[4]: 0

C  sqlerrml: 11, sqlerrmc:

C  C3D7C6FF0F400  0003

C  *** ERROR => ds_dbsl_funs.beg_read returned 99.

[dbdssl.cpp   751]

C  {root-id=53F97E8BA480A794001C0A86E01}_{conn-id=00000000000000000000000000000000}_0

C  Database error. DBSL return code 99 

B  ***LOG BY2=> sql error -901       performing OPC        [dbds         398]

B  ***LOG BY0=> SQL system error. MSGID= Job=188483/SCP54/WP21 [dbds         398]

B  ***LOG BY1=> sql error -901       [dbacds       1496]

dorothea_stein
Participant
0 Kudos

Hi,

the messages you are posting are also taken from the SAP system (syslog, developer trace), they only show the SQL0901 error itself.

In order to see the error that caused the SQL0901, please log on to the IBM i at OS level and use the command Brian posted above, or directly

DSPJOBLOG JOB(188483/SCP54/WP21)

The last three or four messages prior to the SQL0901 will be relevant.

If that job (188483/SCP54/WP21) does not exist anymore, you can get the job in which the error occured from the SAP logs you cited above.

Best regards,

Dorothea

volker_gldenpfennig
Active Participant
0 Kudos

Hi,

interesting would be, what else in the joblog can be found ...in general sql0901 is an OS bug ... based on the full joblog, we can find out if this was an issue from IBM or on your tables.

Regards,

Volker Gueldenpfennig, consolut international ag

Former Member
0 Kudos

Please see full error message below. I checked source object was not beeeing edited when file was loading.

Error message:

Error message from the source system

Diagnosis

An error occurred in the source system.

System Response

Caller 09 contains an error message.

Further analysis:

The error occurred in Extractor .

Refer to the error message.

Procedure

How you remove the error depends on the error message.

Note

If the source system is a Client Workstation, then it is possible that the file that you wanted to load was being edited at the time of the data request. Make sure that the file is in the specified directory, that it is not being processed at the moment, and restart the request.

Former Member
0 Kudos

Here is job log:

In end log:  With Status      Ended with errors

Error was sent around 4:31

04:29:55Job started
04:29:56Step 001 started (program RSPROCESS, variant &32, user ID MOTE)
04:29:56Start process LOADING Z_4XV6Z8052BNMG8OVJ9ICYQO02 in run 4YWTRTYFPKGD1T2CE7N07YW3M of chain ZSCM
04:29:57Data saved successfully
04:30:00Start InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02
04:30:02InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 created request R_4YWBQLTPUPMK1V7LSWSP69OG2
04:30:02InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 Started In Process Chain ZSCM; Generated Request: R_4YWBQLTPUPMK1V7LSWSP
04:30:02InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 Started In Process Chain ZSCM; Generated Request: R_4YWBQLTPUPMK1V7LSWSP
04:30:02Job finished
madasamy_arunachalam
Active Participant
0 Kudos

Hi

There is an OSS note for SQL error 901, check the possible cause based on this note  47435 - AS/400: error analysis for SQL0901

Also, can you check trace file (or attach it here),  for background work process which had above issue ?, dev_wX may have some interesting details ?

regards

Swami

volker_gldenpfennig
Active Participant
0 Kudos

Hi,

we are not asking for the SAP joblog, but for the OS joblog as Brian already stated ... and we would need the information for the WP in the source system, as the problem arises there ...

Regards,

Volker Gueldenpfennig, consolut international ag