Unable to run data builds reading/writing to SQL Server:Timeout expired, SQLSTATE = HYT00, ERROR = 0

Troubleshooting

Problem

Databuilds reading and writing to Microsoft SQL Server database fail intermittently with Timeout expired, SQLSTATE = HYT00, ERROR = 0

Symptom

DS-DBMS-E400: UDA driver reported the following on connection 'ALIAS_00BFA13C':

DMS-E-GENERAL, A general exception has occurred during operation 'tables'.
DMS-E-RDS_OLEDB, The OLE DB provider has returned the following error:
HRESULT: E_FAIL
Microsoft OLE DB Provider for SQL Server
Timeout expired
SQLSTATE = HYT00, ERROR = 0

[PROGRESS - 23:25:08] Build 'E_Account_Target_Account' Failed
databuild -- failed (01-Feb-2006 23:25:08)

DS-DBMS-E400: UDA driver reported the following on connection 'ALIAS_00BFA13C':

DMS-E-GENERAL, A general exception has occurred during operation 'detach database'.
DMS-E-RDS_OLEDB, The OLE DB provider has returned the following error:
HRESULT: DB_E_OBJECTOPEN
Microsoft OLE DB Provider for SQL Server
Object was open.

Resolving The Problem

Increase the Query time-out parameter (default 600 seconds) for the server in the SQL Server Enterprise Manager.

Steps:In SQL Server Enterprise Manager:

1. Select the server

2. Right-click Properties.

3. In the Connections tab, adjust the Query time-out parameter.

4. Click OK.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Component":"Data Manager","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2.0;7.1;8.1","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DecisionStream","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS7M3Y","label":"Cognos Performance Applications"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Production","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

1039087

Was this topic helpful?

Document Information

Modified date:
28 November 2022

UID

swg21371513

Tips