Select form table /SAPAPO/ORDMAP fails

[Former Member]

Hi,

I'm performing a system copy of an SCM system. The procedure includes executing the following select statement in the MaxDB database:

"select LOGSYS… from "SAPR3"."/SAPAPO/ORDMAP…"

The command failed due to the following error "Base table not found;-4004 POS(16) Unknown table name:/SAPAPO/ORDMAP"

I looked at dba_tables and found that the table's owner is SAPLCA, I tried also the above statement using this owner, but it didn't work either.

Selecting from some of the SYS tables is working, but none of the tables which belong to SAPLCA (according to dba_tables table) worked.

Can anyone please help to find out the content of /SAPAPO/ORDMAP?

Thanks,

Shiri.

[former_member229109]

Hello Shiri,

I saw that the similar question was posted in the opened the OSS message 558872/2006 on queue BC-DB-LCA. Correct?

As you are using liveCache & APO, you are SAP customer, and I would like to recommend you to work with SAP support in the message 558872/2006, or, if it's NOT your message, open the new one for SAP on queue BC-DB-LCA or 'BC-DB-LVC'.

If you are performing the Homogenous liveCache copy using backup/restore procedure, please review the SAP notes 457425 & 877203.

-> run the SQL statement as DBA user ( default :'SUPERDBA' ) & check that 'SAPLCA' user is listed: select * from domain.users

[ you could use the SQLSTUDIO, logon as superdba user, or dbmcli tool:

dbmcli -d <LCSID> -u <control>,<control>

dbmcli on <LCSID>>sql_connect superdba,admin

dbmcli on <LCSID>>sql_execute select * from domain.users

...

dbmcli on <LCSID>>exit

]

-> Run the SQL statement as SAPLCA user ::

select * from tables where owner='SAPLCA'

[ you could use the SQLSTUDIO, logon as SAPLCA user, or dbmcli tool:

dbmcli -d <LCSID> -u <control>,<control>

dbmcli on <LCSID>>sql_connect saplca,<pwd>

dbmcli on <LCSID>>sql_execute select * from tables where owner='SAPLCA'

...

dbmcli on <LCSID>>exit

]

-> Run the SQL statement as SAPLCA user ::

select LOGSYS, count(*) from "SAPLCA"."/SAPAPO/ORDMAP" group

by logsys

[ you could use the SQLSTUDIO, logon as SAPLCA user, or dbmcli tool:

dbmcli -d <LCSID> -u <control>,<control>

dbmcli on <LCSID>>sql_connect saplca,<pwd>

dbmcli on <LCSID>>sql_execute select LOGSYS, count(*) from "SAPLCA"."/SAPAPO/ORDMAP" group

by logsys

...

dbmcli on <LCSID>>exit

]

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia,

Thanks for your detailed answer.

Shiri.

[former_member229109]

Hello Shiri,

you are welcome.

Regards, Natalia Khlopina