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.