SAP Knowledge Base Article - Preview

3404590 - Unable to migrate FC data source after version upgrade - Error "invalid column name 'ID' "

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.