BD87 idoc inbound error for message type HRMD_A

Hello there,

I am getting below error while fetching Inbound idoc in tcode BD87, see log below from ST22

Short text
    An SQL error occurred when executing Native SQL.
What happened?
    The error "-10328" occurred in the current database connection "LCA".
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.

How to correct the error
    Database error text........: "Mismatch of number of stream members for
     parameter (3) (application 6, database 9)."
    Database error code........: "-10328"
    Triggering SQL statement...: "EXECUTE PROCEDURE "SIM_SIMSESSION_CONTROL""
    Internal call code.........: "[DBDS/NEW DSQL]"
    Please check the entries in the system log (Transaction SM21).

    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_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"
    "/SAPAPO/SAPLOM_CORE" or "/SAPAPO/LOM_COREU07"
    "SIMSCTRL_EXEC_COM"

    If you cannot solve the problem yourself and want to send an error
    notification to SAP, include the following information:

    1. The description of the current problem (short dump)

       To save the description, choose "System->List->Save->Local File
    (Unconverted)".

    2. Corresponding system log
   Display the system log by calling transaction SM21.
   Restrict the time interval to 10 minutes before and five minutes
after the short dump. Then choose "System->List->Save->Local File
(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP
program: The source code of the program
   In the editor, choose "Utilities->More
Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which
actions and input led to the error.

The exception must either be prevented, caught within proedure
"SIMSCTRL_EXEC_COM" "(FORM)", or its possible occurrence must be declared in
 the

Do we need SAP_APO in order to install LiveCache?

We have below landsacpe

- SAP ECC 6 EHP4 with SQL server 2005 S BACKEND

-LCAPPS Component release 2005_700 with SP

SAPKIBHD05.

- We dont have SAP_APO component

-SAP LiveCache system have MAXDB 7.7.04.29 as backend.

- Live cache client is installed on same SAP ECC system where we have SAP ECC EHP4 system.

any suggestion how to resolve it?

Mani

SAP Managed Tags:
SAP MaxDB

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)


> Hello there,
>  I am getting below error  while fetching Inbound idoc in tcode BD87, see log below from ST22
> Do we need SAP_APO in order to install LiveCache?

Totally, yes.

Without APO there's just one use for liveCache and that would be a standalone enqueue server (very rare scenario!).


> We have below landsacpe
> - SAP ECC 6 EHP4 with SQL server 2005 S BACKEND
> -LCAPPS Component release 2005_700 with SP 
> SAPKIBHD05.
> - We dont have SAP_APO component
> -SAP LiveCache system have MAXDB 7.7.04.29 as backend.

No, liveCache doesn't have MaxDB as a "backend". liveCache is MaxDB plus a set of C++-callable in-process functions/methods that allow the complex manipulation of non-relational data.

There's no way to separate the liveCache-features from the MaxDB kernel.


> - Live cache client is installed on same SAP ECC system where we have SAP ECC EHP4 system.
Doesn't matter. To the NetWeaver-stack liveCache behaves like any other database as a server.
> any suggestion how to resolve it?

Sure, do this the right way and get more information on the technology used here first!

Start with [https://www.sdn.sap.com/irj/sdn/livecache] and the linked documents.

regards,

Lars

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I installed a standalone server and i need it only for SAP HR (specifically Idoc processing in SAP HR Human capital management module). But i am getting error while running ibound idoc process.

So Do i still need SAP_APO component?

I installed SAP MAxDB and LiveCache buid using Installation master DVD for SAP ERP. So i think i followed the right method as specified in installation guide.

Secondly can you help me something specific to my problem in coding form?

i tried in LC10, using LCA monitoring i am not able to run SQLDBC trace under

LCA >> LiveCache Monitoring >> Tools

but i am not able to execute the same, is it a error or we need to configure something?

Operational status is active green light, below is file status.

KNLMSG	KnlMsg	1.098.697	28.01.2011	06:59:55	Database Messages	ASCII
KNLMSGARC	KnlMsgArchive	8.192	28.01.2011	06:59:50	Database Errors	ASCII
KNLMSGOLD	KnlMsg.old	342.663	28.01.2011	06:59:50	Database Messages (OLD)	ASCII
KNLTRC	knltrace	6.209.536	28.01.2011	06:59:56	Database Trace (Raw/Binary)	BINARY
BACKHIST	dbm.knl	570	10.01.2011	06:18:41	Backup History	ASCII
DBMPRT	dbm.prt	133.843	29.01.2011	11:41:27	Database Manager Log File	ASCII
DBMPAHI	L00.pah	214.225	10.01.2011	06:18:16	Database Parameter History	ASCII
LCINIT	lcinit.log	15.299	28.01.2011	07:00:00	LiveCache Initialisation	ASCII
LCINITCMD	lcinit.bat	3.047	28.10.2008	14:45:51	LiveCache Initialisation Script	ASCII
LCINITHIS	lcinit.his	46.742	28.01.2011	07:00:00	LiveCache Initialisation History	ASCII
INSTPRT	dbm.ins	863.981	10.01.2011	06:18:47	Installation Log File	ASCII
DIAGDIR	File	0	10.01.2011	06:18:18	Diagnose History	DIRECTORY
ANALYZER	analyzer	0	29.01.2011	00:00:36	DB Analyzer File	DIRECTORY
LCTRC#init.his	lcinit.his	46.742	28.01.2011	07:00:00	LiveCache Trace (ASCII)	ASCII
LCTRC#init.log	lcinit.log	15.299	28.01.2011	07:00:00	LiveCache Trace (ASCII)	ASCII
LCTRC#_apo_version.txt	lc_apo_version.txt	164	28.01.2011	07:00:00	LiveCache Trace (ASCII)	ASCII

any clue whats wrong?

Mani

> I installed a standalone server and i need it only for SAP HR (specifically Idoc processing in SAP HR Human capital management module). But i am getting error while running ibound idoc process. > So Do i still need SAP_APO component? I never heard of this specific scenario for liveCache usage in the past 7 years working in SAP support on the liveCache component. Might be useful if you provide some more details (documentation, notes, links) that describe this usage scenario. In any case you will need to have a liveCache version that is compatible to your application ABAP coding. The error message you posted indicates that your liveCache version does not fit your application version (or vice versa). > I installed SAP MAxDB and LiveCache buid using Installation master DVD for SAP ERP. So i think i followed the right method as specified in installation guide. Be precise, please. Which installation guide? There are hundreds of them - not THE installation guide. > Secondly can you help me something specific to my problem in coding form? Already did. > i tried in LC10, using LCA monitoring i am not able to run SQLDBC trace under > LCA >> LiveCache Monitoring >> Tools > but i am not able to execute the same, is it a error or we need to configure something? Well, the liveCache needs to be integrated into the LC10. You'd do this in transaction SM59 - but as you've followed an installation guide, this would have been covered in it... > Operational status is active green light, below is file status. > >

KNLMSG	KnlMsg	1.098.697	28.01.2011	06:59:55	Database Messages	ASCII
> KNLMSGARC	KnlMsgArchive	8.192	28.01.2011	06:59:50	Database Errors	ASCII
> KNLMSGOLD	KnlMsg.old	342.663	28.01.2011	06:59:50	Database Messages (OLD)	ASCII
> KNLTRC	knltrace	6.209.536	28.01.2011	06:59:56	Database Trace (Raw/Binary)	BINARY
> BACKHIST	dbm.knl	570	10.01.2011	06:18:41	Backup History	ASCII
> DBMPRT	dbm.prt	133.843	29.01.2011	11:41:27	Database Manager Log File	ASCII
> DBMPAHI	L00.pah	214.225	10.01.2011	06:18:16	Database Parameter History	ASCII
> LCINIT	lcinit.log	15.299	28.01.2011	07:00:00	LiveCache Initialisation	ASCII
> LCINITCMD	lcinit.bat	3.047	28.10.2008	14:45:51	LiveCache Initialisation Script	ASCII
> LCINITHIS	lcinit.his	46.742	28.01.2011	07:00:00	LiveCache Initialisation History	ASCII
> INSTPRT	dbm.ins	863.981	10.01.2011	06:18:47	Installation Log File	ASCII
> DIAGDIR	File	0	10.01.2011	06:18:18	Diagnose History	DIRECTORY
> ANALYZER	analyzer	0	29.01.2011	00:00:36	DB Analyzer File	DIRECTORY
> LCTRC#init.his	lcinit.his	46.742	28.01.2011	07:00:00	LiveCache Trace (ASCII)	ASCII
> LCTRC#init.log	lcinit.log	15.299	28.01.2011	07:00:00	LiveCache Trace (ASCII)	ASCII
> LCTRC#_apo_version.txt	lc_apo_version.txt	164	28.01.2011	07:00:00	LiveCache Trace (ASCII)	ASCII

> any clue whats wrong?

> Mani

The only thing this tells us is: the liveCache instance itself apparently comes up and writes out the standard log files.

That's it.

As I already tried to explain, the problem seems to be the dependence between your application and the liveCache version.

Usually I'd recommend to open a support message for this, but the colleagues would (hopefully) ask the same questions as I did.

regards,

Lars

Documentation followed is here

Installation & Upgrade Guides >> SAP NetWeaver >>SAP NetWeaver 7.0

(2004s) >> Installation >> Installation - Standalone Engines (on righ

tside down) >> Installation - SAP liveCache Technology Win - NW 7.0

EHP 1.

I found LiveCache related livecache build from here

The SCM 5.0 liveCache is supported for our system.

We have currently LCAPPS 2005_700 SP5 on our ERP system.

We installed SCM 5.0 LCA Build 13 and Patch Level 005, SAP Note

1089914, was releasedwith LCAPPS_2005_700: SP5. As SCM 5.0

LCA/liveCache are downward

compatible.

I read in documentation to setup SM59 but was not successful; this might be reason if necessary for which i need to create RFC destination. itried to create from SAP ERP system to same ERP system but i think it doesnt make sense to create from ERP to ERP system. but the documentation doesnt specify how to create from ERP to Livecache system?

Mani

Hello Mani,

1. Please create the LCA connection using LC10 -> set LCA, click integration, then set the settings as pointed in the liveCache installation guide. Then Save. After that go LC10 -> liveCache:monitoring using LCA connection.

Restart the liveCache in LC10.

I recommend you to update the LCA/liveCache - SAP Note 1479219.

2. As you are SAP customer I recommend you to create the SAP message and get SAP support.

Component - "BC-DB-LCA"

Thank you and best regards, Natalia Khlopina

i opened up a message with SAP and they asked me to re-install LiveCache version 7.6 i had Version: 7.7.04.29.

Now i uninstalled my Version: 7.7.04.29. can anybody validate my action items if i am doing it right

1. Download build 50.13 PL 005 from http://www.sdn.sap.com/irj/bpx/livecache?rid=/webcontent/uuid/4043c215-9b20-2a10-c6b7-c7f2dbfb49a5. [original link is broken] (LCAPPS_2005_700: SP05 SCM 5.0: SP11)

2. uncar the file donwloaded in step 1 and install MAXDB server and client using SDBSETUP.exe from extracted .SAR file.

3. install liveCache server using master DVD? if yes which DVD i need to use remember i have ECC6 EHP4 as the main system with SAP HR . So should i use Master DVD of ECC6 EHP4 installation (i hv IDES installation) along with Livecache DVD from same ERP location ocation or SCM5.0 master DVD(51032419_13) along with Livecache DVD (51032259_13)from same SCM 5.0 location (My Company's Application Components>>SAP SCM>> SAP SCM 5.0).

4. Then install Livecache client on SAP ERP system where i have ERP EHP4 system.

5. configure RFC connection from SAP ERP system to same ERP system within same client or should i create RFC destination to Livecache system from my ERP system? there is no mention in the documentation from which system to which system.

6. configure LC10, create LCA, LDA and LEA integration.

7. Initialize LCA

8. and now it should work.

9. do i need to have SAP_APO component? or it can work also without sap_apo software component.

Many thanks

Mani

hello,

1. "We have currently LCAPPS 2005_700 SP5 on our system"

=> The SCM 5.0 liveCache is supported for our system.

Use the SCM 5.0 liveCache installation DVD.

2. " configure RFC connection from SAP ERP system to same ERP system within same client or should i create RFC destination to Livecache system from my ERP system? there is no mention in the documentation from which system to which system."

??? Please give the link to the document you referenced ?

When you created the LCA connection & access to the liveCache via LC10 the two TCP/IP links SAPDB_DBM (default) and SAPDB_DBM_DAEMON are then generated automatically. And you can run a simple function test for the TCP/IP link SAPDB_DBM by selecting "Check link" in transaction SM59.

You should not change them manualy to avoid additional problems with connection to liveCache.

In addition to the known DBMCLI program, the DBMRFC program is used to communicate with the DBM server.

Regards. Natalia Khlopina

I am following below installation guide

Service Market Place >> Installation & Upgrade Guides >>SAP NetWeaver >> SAP NetWeaver 7.0 (2004s) >>Installation - SAP liveCache Technology Win - NW 7.0 EHP 1

section 5.1.1 and note number 305634.

Mani

Hello Mani,

as you saw in the note SAP Note No. 305634 and liveCache installation guide, at this step you asked to create the RFC connections in /nsm59 for the liveCache relevant clients to be able to use the liveCache across clients. See more details in the SAP Note No. 305634.

How many liveCache relevant clients are you planning to have?

Regards, Natalia Khlopina

i will be using LiveCache only for one client so do i need to use this option at all?

I am reinstalling livecache 7.6 using following DVDs

51032259_13 - Livecache dvd

51032419_13 - master dvd

from SCM5.0 dvds.

Mani

Ask a Question

Top Q&A Solution Author

User

Count