Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in while using Query in BI SQL EDITOR to retrive values from MAXDB

HI all,

I'm using EP 7.0 and SP 15.

I am trying to customize portal activity report.For that I decided to access portal database MAXDB (for access portal activity report tables).So, I created BI JDBC System for portal database, system connection test is successfull.

In Visual Composer I used that same system in the SQL Editor(BI) and display all the tables in the MAXDB. If i enter any sql query like (select * from wcr_userpageusage) and while validate that query its showing Error: [-4004] (at 15) display the unknown table name.while RUNning that query Error1 unable to execute query or XML returned result contain query execute failed

But i use that same System in Bi Integartion wizard display all the tables and retrieve the information correctly.

But this application working fine in EP 7.0 and SP 13 but i imported same VC application in SP 15 i'm facing the above problem.

what is the problem.. anyone tell me to achieve this.

Thanks and regards

Thillai J

Former Member
Not what you were looking for? View more on this topic or Ask a question