Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.The statement has been terminated.The wait operation timed out

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated. The wait operation timed out.

Error:

Enabling index \’I_66434STAGINGIDX\’.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
*** Error importing database:Could not import package.
Error SQL72016: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
Error SQL72045: Script execution error.  The executed script:
/*
Data is bulk loaded at this point in deployment execution
*/

Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
The wait operation timed out

Normally I used to use the below command :

cd C:Program Files (x86)Microsoft SQL Server140DACbin

SqlPackage.exe /a:import /sf:K:UATUATbackup.bacpac /tsn:localhost /tdn:AxDB /p:CommandTimeout=1200

Solution:

Just update the CommandTimeout=2000

SqlPackage.exe /a:import /sf:K:UATUATbackup.bacpac /tsn:localhost /tdn:AxDB /p:CommandTimeout=2000

It worked!

Happy DB Restoring!

Thanks & Regards,
Mail ID: pandit.umesh@hotmail.com
Skype ID: pandit.umesh

2 thoughts on “Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.The statement has been terminated.The wait operation timed out

Leave a Reply

Your email address will not be published. Required fields are marked *