Error whille refreshing the Report from BI Launch Pad with data connectivity Microsoft Sql Server.

[nithesh]

Hi All,

Greetings!!

I had created the reports by establishing the Relational Connection (i.e.) Microsoft Sql Server 2017 and designed the Universe. I faced this issue so I had created DSN with 32 bit and 64 Bit on Server and the issue got resolved. I can able to access the Reports from Web Intelligence Rich Client.

But I am unable to refresh and access the same reports from BI launch pad and facing same error.

Please find the attached Error screenshot.

Could you please let me know.

Please reach me. (i.e.).

Thank you.

[ayman_salem]

screenshot is missing

[nithesh]

Attached Error Screen shot.

[denis_konovalov]

Personal information has been removed.

Please review rules of engagement and do not post you phone numbers or personal emails.

[denis_konovalov]

your SQL driver on the server is not working. Either those libraries are missing or not accessible.
You are comparing windows machine with webi rich client that uses local drivers and bilaunchpad which will be using sql server drivers on your *nix host. It is not a valid comparison.

Fix sql connectivity on your server, then report will work in bilaunchpad.
Things to check :
ENV variables , like LD_LIBRARY_PATH, ODBCINI etc
presence and valid install of sql server drivers on server. (you need to use native tools to test connection)

[nithesh]

Thanks for the information Denis.

I will be checking libraries are missing or don't have access on Server End.

Thank You.

[former_member209323]

Hi Madhu,

Would need more info

I do not see the screenshot attached. What is the exact error message?

What is the BO Server version and the client version?

Are other reports based on different connection and universe working?

Are you accessing the report with Administrator or different user?

Regards,

Shreejith

[nithesh]

Hi Shreejith,

Greetings!!

Please find the below details:

SAP Business Objects 4.2 SP6.

Build: 14.2.6.2839
Version: 4.2 Support Pack 6.

The Relational connection and the universe is working fine and its successful.. I can able to execute the reports from Webintelligence Rich Client. But facing the Error from BI Launch Pad.

I tried to access the reports with a user and with Administrator also still the same Error.

Error Message:

The following database error occurred: (CS) "DBDriver failed to load : /bo_install/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64/libdbd_mssql.so (Could not load module /bo_install/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64/libdbd_mssql.so.
Dependent module libodbc.a(odbc.so) could not be loaded.
Could not load module libodbc.a(odbc.so).
System error: No such file or directory

Could not load

module /bo_install/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64/libdbd_mssql.so.
Dependent module /bo_install/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64/libdbd_mssql.so could not be loaded.)" . For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF ).

Please suggest.

Thank You.

[nithesh]

Hi Salem,

Greetings!!

I had defined same DSN on the server. The issue existing only from BI launch Pad.

I am able to execute the same reports from WebIntelligence Rich Client. but unable to from BI launch Pad. Please suggest.

Thank You.

[ayman_salem]

after defining the DSN on the BI Server, have you test it on the BI server?

[ayman_salem]

you should define the same DSN on the BI Server