Unable to execute a query using DBMGUI/DBMCLI

[vipin_muthukattil]

I am trying to execute the below query after I logged on to the liveCache with the SQL Studio/dbmcli as the liveCache user, and executed the following command.

I get the below error stating that the Table is invalid.

query : Sql_execute SELECT count(*) from "/SAPAPO/ORDKEY" where simid = '<noted VRSIOID>'

LCA>ERR= -24988

ERR_SQL: SQL error

-3009,Invalid table n

Name and Server : LCA - fmskb0lc.fm.intel.com

DBMRFC Function : DBM_EXECUTE

Command : sql_execute SELECT count(*) from SAPLCA./SAPAPO/ORDKEY

Error : DBM Error

Return Code : -24988

Error Message : ERR_SQL: SQL error

-3009,Invalid table n

-3009,Invalid table name

Actually I am trying to follow the note # 1383947 where it asks to run the above query. I understand I can get the result from SE16 but trying to find out why the above query doesn't work from both DBGUI & DBMCLI.

Thanks

[lbreddemann]

Would you mind to

a) use a proper SQL tool like sqlcli, SQL Studio or Database Studio

and

b) logon as the schema user that actually owns the table?

regards,

Lars

[Former Member]

Think you have to put the schema in front of the table name..

Kind regards,

Mark

[vipin_muthukattil]

Mark,

I tried to prefix the schema (SAPLCA) to the Table name with no luck. It gives the same error as mentioned earlier.

query I executed by prefixing schema: Sql_execute SELECT count(*) from "SAPLCA"."/SAPAPO/ORDKEY" where simid = <>

I am able to execute the below query fine though.

sql_execute select * from users which return results.

I am trying to check on how to figure out the owner of the liveCache application table /SAPAPO/ORDKEY inorder to run the query by prefixing the owner of the application table. I found from below link that Natlia has suggested the same.

Please let me know if you could guide me on how to check the owner of LC Table /SAPAPO/ORDKEY which then might help in executing the query I wanted to execute.

Thanks

Vipin

[Former Member]

Perhaps you can try using sqlcli..

Kind regards,

Mark