Symptom
Migration of datasource failed after upgrade with the error message "invalid column name 'ID' ".
The migration logs shows the below traces:
11-13-23 21:30:17 PID=9872 THD=1940 USR=noUser MSG=0 INFO application.migration.plugin - TechnicalDocusersMigrationService - Clean invalid ct_document.id_tech_userdoc 11-13-23 21:30:17 PID=9872 THD=1940 USR=noUser MSG=0 DEBUG system.database.schema - Database Name : MICROSOFT SQL SERVER 11-13-23 21:30:17 PID=9872 THD=1940 USR=noUser MSG=0 DEBUG system.database.command.dml - [Request 4390] - Begin query execution - DELETE FROM ct_docuser WHERE ID NOT IN (SELECT MAX(ID) FROM ct_docuser GROUP BY doc_id, user_id) 11-13-23 21:30:17 PID=9872 THD=1940 USR=noUser MSG=10027 ERROR system.database - Invalid column name 'ID'.
Read more...
Environment
- SAP Financial Consolidation 10.1
- MICROSOFT SQL SERVER
Product
SAP Financial Consolidation 10.1
Keywords
migration , datasource , Invalid column 'ID' , collation , case-insensitive (CI) , case-sensitive (CS) , upper case , lower case , FC , SQL , KBA , EPM-BFC-PSI , Performance, Stability, Installation , 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.
SAP Knowledge Base Article - Preview