(Error: BOMGR 0060) IDispatch error # 109 Connection or SQL sentence error
Hi all members
BO version: BO 6.5
My client is facing following error in Infoview all of sudden for last 2 weeks while viewing the published reports in an Infoview.
BusinessObjects server process raised an automation exception. (Error: BOMGR 0060) IDispatch error # 109 Connection or SQL sentence error.
(DA0005): [Exception: DBD, ORA-12154:
TNS:could not resolve the connect identifier specified State: N/A] The following data providers have not been successfully refreshed:
SQL 1 with XYZ. (DMA0007): (BSSBUWSIT0001.xxxxxx.com)
(returned by function Refreshing Document
Following is the wording of my client
"it comes to all reports, only few run smoothly, and if we restart the server it goes immediately otherwise it takes some time to get disappearu2026"
Kindly any member guide me for the resolution of this problem.
Thanks in advance
Edited by: izhar ahmed on Sep 29, 2008 12:03 PM