Sign Up for Training |
Jet Global Company Site
Community
Downloads
Training
Submit a Request
Give Feedback

Error: Timeout Expired


Symptoms

During the Deploy and Execute process, an error such one of the following is displayed:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Error during Data Processing for Table: Value Entry at: Business Unit

or

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Stored Procedure: [dbo].[usp_NAVSource_dbo_Value Entry_Clean]

 

Cause

It is possible that the Command Timeout is set to a level which is shorter than the amount of time that it takes to transfer and cleanse the data.

Resolution

The command timeout should be set to zero for the:

  • data source
  • staging database
  • data warehouse databases
  1. Changing the Command Timeout on the Data Source

    To set the command timeout for the data source, navigate to the data source at the bottom of the data tab, right click the data source name (ie: NAV, GP, AX, etc.) and select Edit SQL Provider.

    Change the Command Timeout to 0 and click OK

     

    If a Timeout Warning window appears, click No to keep the value as 0.

  2. Changing the Command Timeout for the Staging Database

    To change the Command Timeout for the staging database, navigate to the staging database (ie: JetNavStage, JetAxStage, JetGpStage, etc.) underneath the Business Unit node on the Data tab. Right click the staging database and select Edit Staging Database.

    Change the Command Timeout to 0 and click OK.

  3. Changing the Command Timeout for the Data Warehouse

    To change the Command Timeout for the data warehouse, navigate to the data warehouse (ie: JetNavDwh, JetAxDwh, JetGpDwh, etc.) underneath the Data Warehouse node on the Data tab. Right click the data warehouse and select Edit Data Warehouse.


    Change the Command Timeout to 0 and click OK.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments