on 09-11-2008 9:22 AM
Error during SQL execution: (DA0003): Exception DBD, [Microsoft][ODBC SQL Server Driver] Timeoutexpired state: HYT00]
Not too much information on this. We have no limit on the SQL server side, we've increase the timeout value on the universes 10 fold but this is clearly not the value causing this error. Any ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Allen,
Error:
Errors: "Error during SQL Execution: [DA0003]" and "Exception DBD, [Microsoft][ODBC SQL Server Driver]Timeout expiredState:HYT00" when executing long-running queries in BusinessObjects.
CONFIGURATION
BusinessObjects 6.5 and XIR2
MS SQL Server 2000
SYMPTOMS:
You execute a long-running query in BusinessObjects. After some time you receive the following errors:
Error during SQL Execution: [DA0003]
Exception DBD, [Microsoft][ODBC SQL Server Driver]Timeout expiredState:HYT00
CAUSE:
A default timeout in the ODBC configuration occurs before the query is completed.
RESOLUTION:
Here are the steps to follow:
1.Navigate to the following folder:
<Installation_Path>\dataAccess\RDBMS\connectionServer\odbc
2.Open the "odbc.sbo" file in a text editor.
3.Locate the following section:
<DataBase Active="Yes" Name="MS SQL Server 2000">
4.In this section add the following line:
<Parameter Name="Query TimeOut Available">No</Parameter>
5.Save the file and exit the editor.
Please revert in case of any further queries.
Regards,
Deepti Bajpai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Allen,
What is the exact version of Business Objects version you are using at your end?
Regards,
Deepti Bajpai
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.