Skip to Content
avatar image
Former Member

Error in while accessing 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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Nov 12, 2008 at 06:31 PM

    This is very likely not a MaxDB problem, but a question of setting up the connection in visual composer.

    Do you get the same error, when running the statement in SQL Studio / DB Studio / sqlcli ?

    regards,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Thillai J,

      1) According your information, the owner of the application tables is SAP<SID>DB. As you know, the SAP Standard User for MAXDB Databases in Java EE systems is SAP<SID>DB. The user is the database administrator for the SAP system with the ID <SID> (database user of class DBA).

      Please see the information & documents in the MAXDB Library at the link :

      http://maxdb.sap.com/doc/7_7/default.htm

      A) SAP MaxDB Security Guide

      < Authorizations -> Defining Clear Authorizations for Users>

      B) Tutorials -> SQL Tutorial -> Authorization

      < -> Database Users and Their Privileges >.

      C) Tutorials -> Reference -> SQL Reference Manual -> Authorization

      < see the list of SQL statements for authorization & more details/examples >

      2) Users may only implement SQL statements on database objects for which they have been granted privileges. When a user creates a database object, this user then automatically becomes the owner of the database object, and is granted all privileges for this database object. The owner of an object can grant privileges for this database object to other users; the database systems does

      not grant any privileges implicitly. Other users can only grant privileges for a database object when they themselves have been granted these privileges and have permission to grant these to other users. If the database user SAPW11DB is the owner of the tables WCR*, then the user SAPW11DB could grant any privileges to the table WCR_USERFIRSTLOGON, for example,

      to another database User using GRANT Statement ( see at 1) -> B) & C)).

      3) Small example:

      • Create the database user TEST. Connect to the database as user SAPW11DB, for example,

      using SQLStudio, and run the statement:

      CREATE USER TEST PASSWORD test STANDARD NOT EXCLUSIVE DEFAULTCODE UNICODE

      • Grant Privileges to the user TEST. Connect to the database as user SAPW11DB, for example, using SQLStudio, and run the statement:

      GRANT SELECT ON "SAPW11DB"."WCR_USERFIRSTLOGON" TO TEST

      • Check tha the privileges granted. Connect to the database as user SAPW11DB, for example,

      using SQLStudio, and run the statement:

      SELECT * FROM DOMAIN.TABLEPRIVILEGES WHERE schemaname = 'SAPW11DB' AND tablename = 'WCR_USERFIRSTLOGON'

      • More examples given in the document "Database Users and Their Privileges" < See reference in 1) -> B) >

      4) Are you SAP customer? If you SAP customer, you could create the OSS message and discuss in more details our problem with MAXDB support.

      5) You wrote above:

      "2) sql_execute select owner from tables where tablename = 'wcr_userpageusage'

      OUTPUT: ERR-24988,ERR_SQL: SQL error

      100,Row not found"

      Run:

      sql_execute select owner from tables where tablename = 'WCR_USERPAGEUSAGE'

      Thank you and best regards, Natalia Khlopina