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 ONE Support launchpad (Login required).

Search for additional results

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