Getting 'processDPCommandsEx' API error while creating report in Web Intelligence BO 4.1
My Universe is designed using BO 4.1 Information Design Tool (IDT) using Multisource connection -MySQL connection.
I have two data sources in my Universe. If I create query in IDT using objects from both data sources then it is working fine but as soon as I create report using Web Intelligence (BI Launchpad), I am getting error message- "An Internal error occurred while calling 'processDPCommandsEx' API. (Error-ERR_WIS_30270) (WIS 30270)"
I am getting the same error while creating report using Webi Rich client also with the same universe.
Has somebody experienced the same issue? Please help.
Carly Thomas replied
Check this KBA 1790312:
It's specific to multisource Universe when at least once source is MySQL.
If that doesn't work for you - could you check the following:
When you get the error in BILaunchPad, is the WebI server restarting? You can see if the PID has changed in either the CMC or the Task Manager.
How many rows of data are you pulling back?
Are you using any Drill Filters or Input Controls in the report? If yes, can you remove those and try a query filter just to test to see if it comes back without error?
I hope that helps,