Skip to Content
0
Jun 01, 2011 at 11:27 AM

Unable to execute a query using DBMGUI/DBMCLI

114 Views

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