ODBC issues on WebI reports

[Former Member]

Experts,

The following error message I get when I run the report for the first time however after couple of iterations (re-run) the reports it works fine.

"

The following database error occurred: [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

"

Would you know the possible causes of this error ?

Technical details:

Running on 64bit Machine, Windows Server 2012R2

ODBC connection / system DSN. - created on server.

64 bit , Driver: SQL Server

SAP BO 4.1

Universe: *.unv

WebI report.

Cheers

[sateesh_kumar1]

Hi ,

Check whether communication is breaking between the BOBJ server and SQL server .

you may need to get Network admin help to resolve this issue .

You could provide ODBC traces to network team 

https://support.microsoft.com/en-us/kb/274551

Thanks

[Former Member]

Hi Sateesh,

Appreciate for the suggestion.

Is there any other alternative ?

Thanks,

[Former Member]

Hi,

Select the option 'Disconnect after each transaction' in the connection of the universe and then observe the behavior.

Regards,

Adil Raj