LTRC to MaxDB using DB connection.

[Former Member]

Hi Gurus,

I hope you can help with a user and permission problem in MaxDB. Let me explain....

We are trying to set up an LTRC replication to an ABAP system from an AS Java system running on MAXDB 7.8. I have created a new user for this purpose OPIREAD in the MaxDB system, and assigned the DBA attribute.

In the ABAP system DBCO the connection is configured correctly and the dbclient is functioning ok, we installed the correct executables and set the correct parameters.

When I test the connection using ADBC_TEST_CONNECTION everything is ok.

When we attempt to replicate tables we are facing errors.

"No Columns found for table <domain>.<table name>"

I suspect we have problems with the user OPIREAD to access the schema SAP<SID>DB

Please could someone offer advice?

Many Thanks.

MB

[JamesZ]

Dear MB,

Can you show me with the configuration screenshot of DBCON?

Also please upload the screenshot of the error.

Best regards,
James

[Former Member]

Hi James,

thanks for replying.

the configuration screenshot of DBCON is here:

The error is:

Message text

-------------------------------------------------------------------------

The following error messages occurred on: 29.06.2015 13:24:03

No columns found for table SAPPO1DB.BC_IV_DC_EVNT

Database connection: PO1

-------------------------------------------------------------------------

I suspect the user OPIREAD doesn't have correct access to Schema SAPPO1DB (AS Java database on MaxDB)

Question is how to give this access? Attempting grant using SUPERDBA is not successful.

I do not have SAPPO1DB user's password and so reluctantly I may need to reset that and also reconfigure the XUSER entries. This is a risk to the running Java System.

Any ideas?

[JamesZ]

Please narrow down this problem via testing below:

log on maxdb server and execute command:

dbmcli -d <dbsid> -u OPIREAD,<password>
sql_connect OPIREAD,<password>
sql_execute select * from SAPPO1DB.BC_IV_DC_EVNT

[Former Member]

Hi James,

the result is:

Error Executing 'select * from SAPPO1DB.BC_IV_DC_EVNT' [-4004] (at 15): Unknown table name or unknown schema:BC_IV_DC_EVNT

Thanks.

[JamesZ]

Are you sure schema SAPPO1DB or table BC_IV_DC_EVNT are existing?

Can you run the same query via user superdba?

[Former Member]

Hi James,

I get the exact same problem with SUPERDBA.

The user SAPPO1DB exists, but objects owned by this user are seemingly not accessible.

The table object is taken from an implementation guide, and I am not certain that it definitely exists within the SAPPO1DB schema.

The MaxDB system is a standard install of AS Java 7.31 - so perhaps we can switch table to get something that should be in the schema, to figure out whether user/schema or object access is the problem.

Is there a standard AS Java table we could choose to test?

Best regards,

Mark.

[JamesZ]

You can check if the table exists in the database on earth via below command:

dbmcli -d <dbsid> -u superdba,<password>

sql_connect superdba,<password>
sql_execute select schemaname, owner, tablename from domain.tables where

upper(tablename)='BC_IV_DC_EVNT'.

Sorry I am not familiar with java application, so I do not know any java table...

[Former Member]

Hi James,

thanks again for your continued assistance.

Statement 'select schemaname, owner, tablename from domain.tables where upper(tablename)='BC_IV_DC_EVNT'' successfully executed in 780 ms  - No result

I'll repeat this with a table known to be in the SAPPO1DB schema and post here.

[Former Member]

According to SAPNote

892294 - Enhanced support for non-ABAP database in BRCONNECT 7.00

There should be the tables SDBAH & SDBAR in the Java Schema SAP<SID>DB.

I tried this and it looks like it is schema access that is missing rather than tables:

select schemaname, owner, tablename from domain.tables where upper(tablename)='SDBAH' successfully executed in 12 ms  - No result

[JamesZ]

still it looks like there is no such tables in maxdb database. Maybe you can create your own table in java database and do the testing?

[Former Member]

Hi James,

we solved this issue (and now facing the next one )

We were able to get the correct passwords for the Schema user and Control user from the installation files: KEYDB.XML and CONTROL.XML with the help of SAP Support.

I located the files and forwarded them as an attachment to my incident.

Once we have these credentials in our DBCO then everthing on the database side is working fine.

We now have a different problem with generated tables in LTRC system having incorrect field lengths compared to corresponding MaxDB tables. We have an incident open with LTRC component.

Thanks for the assistance.

Mark.