SAP Knowledge Base Article - Preview

3581440 - SAP shadow instance cannot be started properly with error "Invalid column name: DBSQLTIMESTMP" in the phase ACT_UPG

Symptom

  • The following error is reported in SUM(Software Update Manager) UI in the upgrade phase ACT_UPG. 

=========

WARNING: Unlocking system failed with 'RFC login to system <SID> ashost <hostname> nr <instance No.> gwhost <hostname> gwservice sapgw<instance No.> failed with code 1 key RFC_COMMUNICATION_FAILURE: 
LOCATION    CPIC (TCP/IP) on local host with Unicode
ERROR       partner '<IP address>:33<nn>' not reached
=========

  • Meanwhile, the error message below is reported in work process log, such as dev_w0, in the work folder of shadow instance.

=========

B  dbprotocol: table logging switched on for all clients
C  *** ERROR =>   prepare() of C_0003, rc=1, rcSQL=260
 [dbsdbsql.cpp 2699]
C  *** ERROR => PREPARE C_0003 on connection 0, rc=260
 [dbslsdb.cpp  8247]
C  SQLCODE    : 260
C  SQLERRTEXT : invalid column name: DBSQLTIMESTMP: line 1 col 231 (at pos 230)
C  sc_p=7fc20ddeac20,no=3,idc_p=7fc20de13d60,con=0,hit=0,cnt=1,act=1,slen=306,smax=512,#vars=1,stmt=7fc20e116850,#tabs=1,tables=DDNTT                         
C  prepared=0,lastPrepareTime=,nativeSQL=0,ignoreStmtId=0
C  stmtid = <10/DDNTT                                   /1/01020304050607>
C  SELECT VERSION , UUID , CRTIMESTMP , ABTIMESTMP , DYTIMESTMP ,       FLDCNT, TABLENGTH, KEYCNT, KEYL\
C  ENGTH, CLIENTPOS, TABTYPE,       TABFORM, REFNAME, HFLAG, BUFSTATE, BUFPARM, ALIGN,       POINTERLG,\
C   UNICODELG, COMPCNT, LEAFCNT, DBSQLTIMESTMP,       ADD_DATA, FIELDS_DATA FROM  "DDNTT"  WHERE TABNAM\
C  E =  ?;
A  RABAX in run level 0
A  RABAX in unknown environment: task_type=0, run level=0, rabax state=40000000 ztta_task_type=0

=========


Read more...

Environment

SAP ABAP System

Keywords

rec/client, OFF, Table logging, ACT_UPG, DBSQLTIMESTMP, DDNTT , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-CUS-TOL-ALO , Activity Log , 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.