Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQLServer]Invalid column name 'TABLEENTRIESID132'. Native error: 207 [Microsoft][ODBC SQL Server Driver][SQLServer]The cursor was not declared. Native error: 16945

When attempting to import subsidiary information in Consolidation Management within General Ledger, the following error is received for multiple subsidiary databases: Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQLServer]Invalid column name 'TABLEENTRIESID132'.
Native error: 207
[Microsoft][ODBC SQL Server Driver][SQLServer]The cursor was not declared.
Native error: 16945
1.  Log into the Consolidated database.
2.  Go to Consolidation Maps>> open the affected database>> Validate and Save.
3.  Import subsidiary file.

Steps to Duplicate

1. In the subsidiary database > General Ledger, click Administration
2. Click Create Consolidation Export File
3. Select Account Activity from the Export file type drop down
4. Browse to a file path and name your file
5. Click Create now.
6.  File>> Exit and Sign out
7.  Log into the Consolidated database
8.  Select ‘Import subsidiary information>> open a new parameter>> and select the created file from the subsidiary database>> Import Now**
**Note: Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQLServer]Invalid column name 'TABLEENTRIESID132'.
Native error: 207
[Microsoft][ODBC SQL Server Driver][SQLServer]The cursor was not declared.
Native error: 16945

Was this article helpful?