Web Intelligence | 'processDPCommandsEx' API Error| 4.2 SP5 | BEx | Multiple Data Sources

[#1]

Hi All,

Working on 4.2 SP5 environment.

Have a Webi report based on multiple data sources which is BEx. Prompts are merged.

When trying to refresh this report getting 'processDPCommandsEx' API Error with below description.

'An internal error occurred while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270) (Error: INF )'

Still if tried to refresh report then get below error

An internal error occurred while calling 'getSessionInfosEx' API. (Error: ERR_WIS_30270) (Error: INF ) 

Do understand that these are generic error and also checked Q&A's and blogs for this kind of error but nothing worked so far.

Tried

1. to run the same report from Rich Client but got the same error.
2. Purging data sources and running but still got an error

If I try to run all queries one by one then it does not generate any error but when

try to run all query once it creates an error message.

Please let me know if you have any solution for this kind of case.

Regards,

SK

[denis_konovalov]

If report is based on multiple sources and all of then are Bex -- most likely source of the error is in BW, so you should look there.
If it happens in WRC as well as BILP -- this is report design or query design issue. maybe you're getting Bex limitation as well.

[TomNather]

What if they are NOT BEX queries?

[denis_konovalov]

Then it needs to be investigated