Connection or SQL Sentence Error (DA0005)

[Former Member]

Some of our users experience this problem when running BO reports. The report will run fine 1-2 times, then the 3rd time the report stalls and we get the following message in a pop-up window: Connection or SQL Sentence Error (DA0005) Detail: Exception: CS, unexpected behavior.

The reports run fine on the full client BO load, but error out on the ZABO install. We run BO 6.5 SP4.

I am just trying to get a feel if this is a BO problem or related to a database (we run Oracle & Teradata) or possibly a network issue. It happens to ZABO users on-site as well as remote connected users.

Would anyone know what the error code means?

Thanks, Christine

[Former Member]

Hi Christine,

The following solution might help you to resolve the issue.

Create a registry key called "ReceiveTimeout" and set it to your preferred browser timeout and mail this to all your users. Users can then double click on the file you create to update their registry automatically without opening the registry editor.

Follow these steps:

1. Run regedit and browse to:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings.

2. Create a new DWORD and name it ReceiveTimeout. ReceiveTimeout=(<seconds>*1000), so if you require a timeout of 15 minutes, then you should enter a value for ReceiveTimeout as 900000.

Regards,

Sarbhjeet Kaur

[Former Member]

You need to make sure that the connectivity (middleware) is defined exactly the same way on your BOBJ server as it is defined on the local pcs.

ZABO uses the connectivity information from the server. I am sure it is connectivity issue.

Kashif