Data Import
Data import errors.
By Charnjit1 author29 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'
- Error: 'Cannot insert duplicate key in object TaskSecondaryResourceGroups'
- Error: 'Execution Timeout Expired' when running sales order items merge
- Track Order Quantity unticks automatically for some works orders and tasks after running a data import
- Error: 'Please ensure that no duplicate tasks are being imported'
- Error: 'Has invalid ItemCode' or 'ITEM1 has invalid ItemCode ITEM2'
- How to find which SQL views are being used in the Data Flow to import the data
- Error: 'Invalid OrderCode 123456.00 for Order Attribute or ORDERNUMBER has invalid OrderStatusDescription 10'
- Error: 'Violation of UNIQUE KEY constraint UQ_Orc_TableName. Cannot insert duplicate key in object dbo.Orc_TableName'
- The task quantity shrinks as the works order is booked in
- Error: 'The merge statement attempted to UPDATE or DELETE the same row more than once. Refine the ON clause'
- Cannot import works order additional attribute figures
- Error: 'Cannot insert the value NULL into column AttribID table'