We are getting error on opening BI 4.1 web intelligence report on rich client but can open via BI Launch pad.
An internal error occured while calling ‘openDocument’ API.(Error_WIS_30270)(WIS 30270)
While editing the connection for the universe, it throws error like invalid database.
The driver for the database is also seemed to be in place because we can create odbc connection without issue.
Please advise
On the client machine on ODBC properties, we can see driver SQL server version as 6.0.1.7601.17514 and filename shown as SQLSRV32.DLL.
It means the 32 client is installed. Is it right?
The exact error we can see is:-
An internal error occured while calling ‘openDocument’ API.(Error_WIS_30270)(WIS 30270)
Yes, C:\Windows\SysWOW64\odbcad32.exe is the correct ODBC tool. WRC is 32-bit; you need to use a 32-bit DSN with it. You also need them on the BI server(s) to use the IDT/UDT.
Create a local DSN (on the machine you are using WRC on) pointing to the data source using the 32-bit odbcad32.exe (the one you found in c:\windows\System32). There should be an identical 32-bit one on the BI server(s); if not, create it. This is in addition to the 64-bit one that is already there. They all should have the same name. Make sure the connection in your universe is successfully using the DSN. Publish the universe and test the WRC.
We verified that odbc data sources are present on BO server by invoking odbcad32 in both C:\Windows\System32 and C:\windows\sysWOW64.
The same odbc data sources were created on WRC machine too.
Still, when we go to view the report in WRC, it throws this error.
‘The action cannot be performed.(WIS 30650)’.
The same webi report opens and refreshes well in BI launch pad.
It appears you are not the only one with this issue. Check your patch level and the level of your client tools - could be out of synch. Consider SP03 or a higher patch level.
The BO Server OS version is Windows 2008 R2
Webi Rich client version machine OS version is Windows 7 SP1 32 bit
DB version is MS SQL server 2012
BO version is BO 4.2 SP2.
To reiterate the fact, the moment the webi report is clicked for open in webi rich client tool installed on seperate machine, it throws the error.
Please suggest which log file would be helpful in the logging folder of BO server.
i used to fine the latest log and see through the log to find if there is any clue.
in this case , u should find the trace log on local machine.
however , u have to turn on the trace log function on server.
u can find the whole guide on sap web site about how to turn on the trace.
(there is a serial of notes about how to do xxxx . u just search the key words:how to xxxxxx , it should work)
besides , try to open or modify the report on web , either html model or java model to see if there is the same problem.