Error while trying activate planning area

[vijaykumar_swaminathan]

Hi APO Gurus,

I am faced with a problem of not being able to activate a planning area although my live cache is operational. This is a fresh installation of APO and when I view the Model (000) and Active Version (000) I see the message at the bottom saying - "Live Cache is not available" although my Live Cache is active and operational

Further, when I tried to activate the PA I got an error message Internal Error [/sapapo/OM_TS_CHANGE_TG].

I get a dump with the following message on trying to save the active version with changes

Runtime Errors DBIF_RSQL_TABLE_UNKNOWN

Date and Time 03.04.2009 11:39:44

Short text

A table is unknown or does not exist.

What happened?

Error in the ABAP Application Program

The current ABAP program "/SAPAPO/SAPLDM_LC_SQL" had to be terminated because

it has

come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

Error analysis

A table is referred to in an SAP Open SQL statement that either does not

exist or is unknown to the ABAP Data Dictionary.

The table involved is "/SAPAPO/ORDKEY " or another table accessed in the

statement.

How to correct the error

Probably the only way to eliminate the error is to correct the program.

-

Please check the entries in the system log (Transaction SM21).

Internal call code.........: "[RSQL/OPEN//SAPAPO/ORDKEY ]"

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_TABLE_UNKNOWN" " "

"/SAPAPO/SAPLDM_LC_SQL" or "/SAPAPO/LDM_LC_SQLU12"

"/SAPAPO/OM_ORDKEY_SELECT_SIMID"

Your inputs will be of great help

Regards,

Vijay Swaminathan

[Former Member · Accepted solution]

Hi Vijay,

Please check SAP notes 1095255, 376231, 853375, 730283, 492172

Regards

R. Senthil Mareeswaran.

[vijaykumar_swaminathan · Accepted solution]

Hi Senthil,

Thank you for your quick response, but I guess I should have provided more information. My SCM version is 5.1 and my Database is Oracle. So the notes that you specified should already be in my service pack.

SCM 5.1

DBMServer Version: 7.7.02 Build 008-123-149-275

OS: Windows 2003 Server

Live Cache Version: KERNEL 7.7.02 BUILD 008-123-149-275

Regards,

Vijay Swaminathan

[tibor_nagy]

Dear Vijay Swaminathan,

The short dumps with error DBIF_RSQL_TABLE_UNKNOWN have occured because the two important SQL tables /SAPAPO/ORDKEY and /SAPAPO/ORDMAP were missing in liveCache.

This problem has occured because liveCache has not been initialized correctly.

To rectify the problem please initialize the liveCache with transaction LC10. After liveCache is initialized successfully the two required SQL tables will be created in liveCache by the report /SAPAPO/DELETE_LC_ANCHORS that has been specified as liveCache init follow up report (see transaction LC10 > button 'Integration' > tab 'Administration report').

Please also ensure that the checks indicated in the second tab of transaction /SAPAPO/OM13 shows green lights.

This should solve the problem.

Regards,

Tibor