SAP Knowledge Base Article - Preview

3663630 - Error "FOR UPDATE IGNORE LOCKED clause is not supported" occurs during upgrade in SUM

Symptom

The follow error occurs in the upgrade phase "DOWNCONF_DTTRANS" in SUM(Software Update Manager)

A2EESUPG 819 SQL Exception with SQLCode 7: feature not supported: FOR UPDATE IGNORE LOCKED clause is not supported
A2EESUPG 819 SQL Exception with SQLCode 7: feature not supported: FOR UPDATE IGNORE LOCKED clause is not supported

The similar error can be reported in other upgrade phases.

Error message in the following pattern can be found in work process log file.

C  *** ERROR => PREPARE on connection 0, rc=7
C  SQLCODE    : 7
C  SQLERRTEXT : feature not supported: FOR UPDATE IGNORE LOCKED clause is not supported:
C  prepared=0,lastPrepareTime=,nativeSQL=1,ignoreStmtId=0
C  SELECT tabname FROM "PUTTB_SHD" WHERE TABNAME = 'T77HAP_BUT_T' FOR UPDATE IGNORE LOCKED;
B  ***LOG BY2=> sql error 7 performing OPC 
B  ***LOG BY0=> feature not supported: FOR UPDATE IGNORE LOCKED clause is not supported: line 
A  TH VERBOSE LEVEL FULL


Read more...

Environment

SAP ABAP System

SAP HANA Database

Product

ABAP platform all versions

Keywords

SUM, UPGRADE, HANA DB, HDB, IGNORE LOCKED, , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , HAN-DB , SAP HANA Database , 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.