Troubleshooting
Troubleshooting guide for the Run Crystal Report tool
Last Updated: August 3, 2022Summary This article is intended to be used as a troubleshooting guide for errors that arise from the use of the Run Crystal Report tool in a task. Error returned from Crystal Reports – (0x80020009) Cause 1: A parameter required by the report has not been mapped within the Run Crystal Report tool. Solution 1:...
MS Reporting Services Report tool only processing one record in a recordset
Last Updated: July 1, 2022Symptom The MS Reporting Services Report step is only producing one report even though a recordset with multiple rows has been passed. Cause A ‘Looping’ function has not been used. This function tells the report tool to generate a report for each row of a recordset, after a row has been processed and a report...
Run Microsoft Reporting Services Tool – Fails with “ExecutionNotFoundException” at task runtime
Last Updated: July 1, 2022Symptom Unable to save a Microsoft Reporting Services Report when using a ‘Save File’ step. The following error occurs: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution gwp42y55mesyqzb4accp3pur has expired or cannot be found Cause Using Windows Integrated Authentication where the Report Server is not local to the TaskCentre server host. Note: Setting task impersonation will not make the...
Filter Data: RowsProcessed property does not reflect the number of filtered rows.
Last Updated: August 3, 2022Symptom The Filter Data step’s RowsProcessed property does not reflect the number of filtered rows. Please follow the below link for a similar symptom encountered with the RowCount property of the Database Query: Database Query RowCount Property Cause Many ODBC drivers and OLEDB provider do not return a row count to the task environment. Instead,...
Call Stored Procedure step fails at task runtime with error 0x80040e21
Last Updated: July 1, 2022Symptom When a task contains a Call Stored Procedure step that accepts parameter values, it may fail at runtime with the following error: 0x80040e21 Cause Occurs when the parameter value can’t be converted into the specified data type. For example, if a stored procedure requires a parameter type of DBTIMESTAMP and you pass it a...
Running a SAP HANA stored procedure errors with: ‘Unterminated quoted identifier’
Last Updated: July 1, 2022Symptom Running a SAP HANA stored procedure produces the following error: .. [HDBODBC32] Syntax error or access violation; 257 sql syntax error: unterminated quoted identifier.. Cause The error occurs when SAP HANA identifiers are not enclosed in double quote (“) characters. The SAP HANA ODBC layer requires that procedures are identified with double quotes, and...
Updating oracle stored procedure with > 32 KB fails with ‘the operation failed 0x80040e14’
Last Updated: July 1, 2022Symptom Updating an Oracle stored procedure using the Call Stored Procedure (OLEDB) tool returns the following error code: the operation failed 0x80040e14 Cause The underlying error is ‘ORA-01460: unimplemented or unreasonable conversion requested’. This is caused by binding more than 32KB data to a stored procedure parameter when using the Oracle OLEDB Provider. Resolution Add...
Database Query: RowCount property not reflecting the amount of rows produced by a recordset
Last Updated: August 3, 2022Symptom The Database query step’s RowCount property does not reflect the number of rows returned by the query. It may contain a value such as -1, or 0 (zero) in place of the expected number of rows. Please follow the below link for a similar symptom encountered with the RowsProcessed property of the Filter Data:...
Global ODBC connection test fails with error 0x80040154
Last Updated: July 4, 2022Symptom When you click the Test button after creating an ODBC connection it fails with the following error code: 0x80040154 Cause Caused by the Microsoft Data Access objects not being registered. Resolution Register the dao350 and dao360 dlls found in C:\Program Files\Common Files\Microsoft Shared\DAO\ with the RegSvr32 utility.
Unable to query a SAP HANA database: Driver error – 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet
Last Updated: July 1, 2022Symptom Unable to query a SAP HANA database, the following error occurs: Driver error - 10808 [HODBC32] Feature (SCROLLABLE RESULT) not implemented yet Cause The SAP HANA ODBC layer does not support scrollable cursors. Resolution Go to the global configuration properties for the SAP HANA ODBC connection via: Manage -> Tools -> Input -> Database...
