LCA03 dump - table MATRIXINDEXTAB does not exist

[Former Member]

ERROR:

During the post-installation steps of LiveCache, we experience a short-dump:

DBIF_RSQL_TABLE_KNOWN

LMMRP01U66

SAPLMMRP01

MMRP_LC_MATRIX_IND_TAB_MODIFY

Where it attempts to:

INSERT INTO matrixindextab... (the connection is LCA)

Where the table does not exist.

This is definitely the case, as when I run:

sql_execute select * from matrixindextab

From DBMCLI on the LC Server, the table is not found.

SITUATION

-

---

We have just installed SCM 7.0 SR1 and LiveCache 7.7.

There are two servers:

dpd

---

SCM ABAP Stack

SCM Java Stack

LiveCache Client

dcd

---

LiveCache Server

RESOLUTION

-

---

What can be done to resolve this?

In LC10, we have defined LCA, LDA + LEA in the interface.

LiveCache Monitoring connects successfully for all 3 of these.

We have just stopped and restarted LC, but still no luck (probably due to the fact that a simple restart wouldn't create this table).

Is there a reason why it is looking for this table MATRIXINDEXTAB?

Many thanks in advance for any assistance.

Alistair Crawshaw

[adrian_dorn · Accepted solution]

This sounds like you have forgotten to initialize the liveCache after the installation.

Initializating the liveCache should fix the problem.

[Former Member]

Forgot to close the question in the post above.

[former_member229109]

Hello Ali Crawshaw,

thank you for the update. It's not recommended to copy the replied given in the SAP messages in the forum, you could give the reference to the SAP message by number in future.

The solution given to you has the SAP reference links and SAP notes numbers, which could be accessed only by SAP customers.

Best regards, Natalia Khlopina

[Former Member]

Thanks i can solve my problem

[Former Member]

This issue is now fixed and LC is now running successfully (the MATRIXINDEXTAB error is no longer shown).

The error was also raised on OSS, and the steps outlined below were followed. Following this, LC started successfully.

Alistair Crawshaw

-

---

1.

Please review the note:

1224106 Setting the indicator showing client is liveCache-releva

Run the report /SAPAPO/OM_NON_LC_RELEVANT_CLT and check if you have

the liveCache relevant client and active Planning version in this

client.

3. Please review the note:

640107 Using program /sapapo/delete_lc_anchors in APO 3.0 or higher

and check if you have the report /sapapo/delete_lc_anchors as

post-initialization report for the LCA connection settings.

Did you run the liveCache initialization in /nLC10 using LCA connection?

The SCM 7.0 liveCache installation guide has been updated on the

SAP Service Marketplace at following path:

http://service.sap.com/instguides

-> Installation & Upgrade Guides

-> SAP Business Suite Applications

-> SAP SCM

-> SAP SCM Server

-> Using SAP SCM 7.0 Server

-> Installation Guides

On the SCM systems always the report /SAPAPO/DELETE_LC_ANCHORS has

to be used as a follow-up report of the liveCache initialization.

Did you run the liveCache initialization in LC10 after as post

installation step in LC10 and what report is set as a follow-up

report of the liveCache initialization for LCA connection on

production system?

Thank you & best regards, Natalia Khlopina

Development Support liveCache/MAXDB/SAPDB/liveCache Appl.

SAP Labs, Palo Alto, CA (USA)

[Former Member]

Thanks Adrian.

Could you be a little more specific about how to initialise LiveCache?

We restarted it via LC10, but was wondering what else we should try.

I found some references to the command "lcinit" elsewhere in the forums

e.g.

lcinit dcd restart (where dcd is the LC SID)

but the command "lcinit" was not found.

Sorry that the questions are pretty basic - I'm pretty new to the basis side of things.

Alistair

[adrian_dorn]

Hello Alistair,

check Natalia's comments in this old topic:

Regards, Adrian