Error: "Cannot find column -26" when testing data source query
Article ID: 374794
Updated On:
Products
Issue/Introduction
You created a data source of type File System IW for importing an Excel (.xls or .xlsx) workbook. While creating a data source query, you click the Test Query button to preview the data to be extracted from the workbook and then click the Run button, which returns the following error message:
Your request failed. Click 'OK' to close this window or 'Refresh' to refresh the page. Try again or contact the site administrator.
Status: 500
StatusText: Internal Server Error
Error: Cannot find column -26.
Error ID: <error-ID>
NOTE: the Error ID displayed in the console is unique to your environment.
Environment
Version : 6.x
Component : Integration Wizard
Cause
This is caused by a limitation in the method used to convert Excel workbooks (specifically, XLS and XLSX files) that contain 27 or more columns.
Resolution
This will be fixed in a future release of ICA.
As a workaround, save a copy of the workbook as a comma- or tab-delimited file (.csv or .txt) for use with your data source query. These file formats are not affected by the limitation described in the Cause section of this article.
Additional Information
The error is also logged in the RiskFabric server log (w3wp_RiskFabric.<yyyyMMdd>.log) along with its accompanying stack trace. The following is an example:
2024-08-15 13:21:32,586 [95:ERROR] https://<hostname-or-IP>/api/LinkedServer/TestLinkedServerQuery?_dc=1723728092504
System.IndexOutOfRangeException: Cannot find column -26.
The log file is located on the application (IIS) server in the following path:
%SystemDrive%\ProgramData\BayDynamics\Logs
The error is also captured in ICA's relational database. Using the following query, replace <error-ID> with the error ID displayed in the console and execute the query in SQL Server Management Studio (SSMS) to return the error message details:
SELECT Detail FROM RiskFabric.dbo.Log_Client WITH (NOLOCK) WHERE LogClientID = <error-ID>;
Feedback
