I try to import the data but receive the following error message:
Orchestrate Data Flow Import has failed. The detailed information is as follows:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
INSERT INTO wf.orctmp_Orders (OrderCategoryID
,OrderCode
,OrderDescription
,OrderStatusDescription
,Quantity
)
SELECT 0
,v.OrderCode
,v.OrderDescription
,'Complete'
,v.Quantity
FROM wf.View_WorksOrdersNotImported v
WHERE OrderStatus < 40;
I am trying to export the data but the following error message generates:-
Orchestrate has failed to export data into the staging database. The detailed error message is as below:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The functionality has been enhanced in Orchestrate version 7.80. Please upgrade to this version or above.
The database server must have at least 8gb of RAM to handle the performance of Orchestrate and mass data import. Please refer to the Orchestrate Hardware guide.
If the server has sufficient memory RAM, please reboot the database SQL server, making sure everybody is logged out of the Orchestrate and the ERP system.
Freeing up disk space may also resolves this error. Shrink the log files of any SQL databases that are too large. Please complete the following steps on SQL management studio:
Backup database
Right-click database name folder
Select tasks
Select shrink
Select files
Select file type: log
Reorganise pages before releasing unused space: shrink file to: e.g. 100 MB.
If any of the above solutions do not resolve the issue, please raise a new case online and reference the title of this article.