-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
The main client copy process has been canceled at least once.
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
ABAP Program SAPLSCCR
Application Component BC-CTS-CCO
Date and Time :
SQL error "SQL code: -10802" occurred while accessing table "CECOEJ".
Database error text: "SQL message: Invalid numeric value for parameter/column
(167) source type NVARCHAR, target type DECIMAL"
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.
- 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
COPA, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, COEP, COEJ, RKE_HDB_EXTEND_COEX, client copy, inconsistency, SQL Error , SAP DBTech JDBC: : 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
About this pageThis 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.