SAP Knowledge Base Article - Preview

2427330 - SUM upgrade fails in phase TR_PATCH_STATUS_UPGRADE SQL code: 9997

Symptom

During an SAP system upgrade, you get the errors below in the SAPup.log

CURRENTPHASE MAIN_NEWBAS/SUBMOD_UPSTAT/TR_PATCH_STATUS_UPGRADE           
 
...started at 20170209091913                                                                                                       

# Using phase log file 'PATCHSYNC.LOG'.                                                                                            

...finished at 20170209091936 with status ABORTED.                                                                                 

# Error message set: 'RFC error system <SID> nr 92 function 'SPAM_SET_STATUS' failed with code 4 key :
SQL error SQL code: 9997 occurred while accessing'
...begin dialog at 20170209092242   

In the SAP system, there is a shortdump produced in ST22

DBSQL_SQL_ERROR
SQL error "SQL code: 9997" occurred while accessing table "PCL2".

In the developer trace of the workprocess the errors below are observed

Token:       ?                                                                 

*** ERROR => ReparseDBSLTokens Failed                                          
 
[dbsldb4.cpp  3507]                                                              

Statement is:                                                                  
     
SELECT COUNT_BIG(*) FROM ( SELECT 1 FROM PCL2 WHERE CLIENT =  AND         
       
RELID =  FETCH FIRST  ROWS ONLY ) AS T                                   
 
*** ERROR => DbSlPrepare96: print_call_wMerge failed                           
 
[dbsldb4.cpp  16508]                                                             
                                                                                

Thu Feb  9 08:50:44:946 2017                                                    

***LOG BY4=> sql error 9997   performing PRE on table PCL2 [dbdbslst     4602] 

***LOG BY0=> ERROR: Syntax : ? :  [dbdbslst     4602]                                         


Read more...

Environment

SAP on IBM i

Keywords

System copy, AS400, OS400, iSeries, System i , KBA , BC-INS-AS4 , Installation and Upgrade AS/400 , BC-OP-AS4 , IBM AS/400 , BC-DB-DB4 , DB2 for AS/400 , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.