Error in while using Query in BI SQL EDITOR to retrive values from MAXDB
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