on 08-18-2014 5:40 PM
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.
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 :
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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]
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Here is job log:
In end log: With Status Ended with errors
Error was sent around 4:31
04:29:55 | Job started |
04:29:56 | Step 001 started (program RSPROCESS, variant &32, user ID MOTE) |
04:29:56 | Start process LOADING Z_4XV6Z8052BNMG8OVJ9ICYQO02 in run 4YWTRTYFPKGD1T2CE7N07YW3M of chain ZSCM |
04:29:57 | Data saved successfully |
04:30:00 | Start InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 |
04:30:02 | InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 created request R_4YWBQLTPUPMK1V7LSWSP69OG2 |
04:30:02 | InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 Started In Process Chain ZSCM; Generated Request: R_4YWBQLTPUPMK1V7LSWSP |
04:30:02 | InfoPackage Z_4XV6Z8052BNMG8OVJ9ICYQO02 Started In Process Chain ZSCM; Generated Request: R_4YWBQLTPUPMK1V7LSWSP |
04:30:02 | Job finished |
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
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.