2178099 - ERKRS/CE4KEY fields missing from COEP/ COEJ/ CECOEP/ CECOEJ

-During a client copy (or extension of CI_COBL structure or upgrade) there are errors on COEP, COEJ, CECOEP or CECOEJ indicating that the tables are inconsistent. After checking the tables in SE11 there are errors indicating that fields ERKRS and CE4KEY exist in the database but not in the SAP data dictionary:

• "ERKRS does not exist ERKRS 82 NVARCHAR 4"
• "CE4KEY does not exist CE4KEY 83 NVARCHAR 10"

 

-Logs for client copy failure can be accessed in SCC3. The log looks like this:

"Copy canceled; restart required
Message no. TA349
Diagnosis
The main client copy process has been canceled at least once.
System Response
The copy cancelled itself after copying the tables, because the cancellation lost information needed to complete the copy."

-Also, in ST22, short dump is generated as below:

"Category ABAP programming error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program SAPLSCCR
Application Component BC-CTS-CCO
Date and Time :
Short Text
SQL error "SQL code: -10802" occurred while accessing table "CECOEJ".
What happened?
Database error text: "SQL message: Invalid numeric value for parameter/column
(167) source type NVARCHAR, target type DECIMAL"

-Missing Tables

Transaction Dbacockpit-> Diagnostics->Missing Tables and Indexes show that there are missing tables CECOEP CECOEJ in the system.

-SCC9N, SCCLN (new client copy) might raise the error as below:

"SQL Exception: SQL code: 330; SQL message: cannot use duplicate synonym name: CECOEJ: line 1"

Error Message Statements for Table CECOEJ could not be executed.

Read more...

• Controlling and Profitability Analysis (COPA)
• SAP enhancement package for SAP ERP 6.0
• SAP enhancement package for SAP ERP, version for SAP HANA
• SAP S/4HANA Finance
• SAP S/4HANA

SAP S/4HANA Finance all versions ; SAP S/4HANA, on-premise edition 1511 ; SAP Screen Personas 3.0 ; SAP enhancement package for SAP ERP all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

COPA, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, COEP, COEJ, RKE_HDB_EXTEND_COEX, client copy, inconsistency, SQL Error [406], SAP DBTech JDBC: [406]: INSERT, UPDATE and UPSERT are disallowed on the generated field , KBA , db02 , CO-PA , Profitability Analysis , CO-OM , Overhead Cost Controlling , BC-CTS-CCO , Client Copy (For ByD issues select BC-TLM-CP) , How To