Skip to main content

Data Import

Data import errors

1 author17 articles
Error: 'Orchestrate Data Flow import has failed...Execution Timeout Expired...' when importing Task Relations
Duplicate key error when saving item attribute valuesThis article covers an issue where saving item attribute values fails due to a duplicate key error. As this problem requires assistance from Support, we explain how to contact them…
Error: 'Cannot insert duplicate key row in object dbo.orc_TaskRelations with unique index'
Duplicate key error in orc_TaskKPIs tableThis article explains an issue where a duplicate key error occurs in Task KPIs, preventing data from being saved. It outlines when the error may appear and provides guidance on…
Error: 'Cannot continue the execution because the session is in the kill state'
Error: 'Execution timeout expired' due to temp Obsolete Orders table
Order cannot be imported due to zero quantityThis article covers an issue where an Orchestrate Data Flow import fails because an order contains a line with a zero quantity. As this problem requires assistance from Support, we…
Duplicate key error in affected attribute valuesThis article covers an issue where saving attribute values fails due to a duplicate key error. As this problem requires assistance from Support, we explain how to contact them and…
Random tasks or works orders changes to completed automatically after an data import or CSV import
Error: 'Divide by zero error encountered'
Error: 'Execution timeout expired' when running Merge_Tasks stored procedure
Error: 'Data source name not found and no default driver specified'
Error: 'Object reference not set to an instance of an object' whilst running a data import
Error: 'Column ColumnName does not all DBNull value' when importing from CSV file
Error: 'The ConnectionString property has not been initalised'
Error: ' Missing CustomerOrderItemID 123456.00 for CustomerOrderCode CUST1 Cannot insert the value NULL into column'
Error: 'Merge Tasks: Unknown Order Code 123456'