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

[Former Member]

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]

hello ,

i hope u created system object ,connecter details , but onething u have to do , user mapping , if u done good , than one more thing u have to connect bi system u have to fill WAS server details , and that its server details , its server details are not mandetary , WAS server details is mandetary , please do that ,

i hope it will work.

Thanks & Regards,

Suresh