Problem connecting to livecache after installing SCM 5.1

[Former Member]

This is a new installation on Windows 2003 x64 / MSSQL 2005.

SCM and LiveCache running on the same server.

The problem occured initially in transaction LC10, selecting the

database connection LCA and clicking livecache:monitoring end with a

timeout error:

Name and Server : SLQ - pmichsapbw56

DBMRFC Function : DBM_CONNECT

Error : Connect timeout

Error Message : Could not connect within 25 seconds

The configuration of passwords has been checked on the livecache DB by

connecting with database manager.

Going to transaction DB59 for connection test. the DBMRFC server is

started and the connection test gives the following result:

1. Connect. test with "dbmcli db_state"

Successful

2. Connect. test with command mode "dbmrfc db_state"

Successful

3. Connect. test with session mode "dbmrfc db_state"

Unsuccessful

dbm_system_error

Name and Server : SLQ - pmichsapbw56

DBMRFC Function : DBM_CONNECT

Error : Connect timeout

Error Message : Could not connect within 25 seconds

4. Connect. test with "native SQL" ( LCA )

Successful

If DBMRFC server is restarted, testing the RFC SAPDB_DBM_DAEMON from

transaction SM59 is working correctly.

Then I tried again the test of connection LCA from DB59 and it fails.

I did the same test restarting DBMRFC server with trace (from

transaction db59).

Here is the trace from dev_rfc.trc:

• ERROR file opened at 20080725 165905 W. Europe Dayli, SAP-REL 700,0,9 RFC-VER 3 756683 MT-SL

T:15320 ======> CPIC-CALL: 'SAP_CMACCPTP'

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR illegal parameter value ( function=SAP_CMACCPTP /

parameter=handle / value=1844 )

TIME Fri Jul 25 16:59:05 2008

RELEASE 700

COMPONENT CPIC (TCP/IP) with Unicode

VERSION 3

RC 769

MODULE r3cpic.c

LINE 9449

COUNTER 7

T:15320 Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1737

T:15320 ---> RFC MESSAGE/ERROR : 104

• RFC_ERROR_SYSTEM_FAILURE

• CPIC-CALL: 'SAP_CMACCPTP'

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR illegal parameter value ( function=SAP_CMACCPTP /

parameter=handle / value=1844 )

TIME Fri Jul 25 16:59:05 2008

RELEASE 700

COMPONENT CPIC (TCP/IP) with Unicode

VERSION 3

RC 769

MODULE r3cpic.c

LINE 9449

COUNTER 7

T:15320 <* RfcDispatch : returns 1:RFC_FAILURE

• ERROR file opened at 20080725 165933 W. Europe Dayli, SAP-REL 700,0,9 RFC-VER 3 756683 MT-SL

T:14772 ======> CPIC-CALL: 'SAP_CMACCPTP'

LOCATION CPIC (TCP/IP) on local host with Unicode

ERROR illegal parameter value ( function=SAP_CMACCPTP /

parameter=handle / value=1848 )

TIME Fri Jul 25 16:59:33 2008

RELEASE 700

COMPONENT CPIC (TCP/IP) with Unicode

VERSION 3

RC 769

MODULE r3cpic.c

LINE 9449

COUNTER 9

T:14772 Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1737

T:14772 <* RfcDispatch : returns 1:RFC_FAILURE

here is the trace from dev_rfc0:

• Trace file opened at 20080725 165913 W. Europe Daylight Time, SAP-REL 700,0,133 RFC-VER U 3 938770 MT-SL

======> CPIC-CALL: 'ThSAPCMRCV' : cmRc=17 thRc=474

Connection deleted by administrator

ABAP Programm: SAPLSADC (Transaction: )

Called function module: DBM_CONNECT

User: SBARRAUD (Client: 000)

Destination: SAPDB_DBM_DAEMON (handle: 2, 06522294, {2D5A5ADD-E47B-F1F9-83F5-001E0BE9FFAA})

SERVER> RFC Server Session (handle: 1, 06521294, {2D5A5ADD-992F-F152-83F5-001E0BE9FFAA})

SERVER> Caller host:

SERVER> Caller transaction code: DB59 (Caller Program: SAPLSADC)

SERVER> Called function module: DBM_CONNECT_PUR

Error RFCIO_ERROR_SYSERROR in abrfcpic.c : 3295

CPIC-CALL: 'ThSAPCMRCV' : cmRc=17 thRc=474

Connection deleted by administrator

Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1817

Here is the version of what has been installed:

Configuration:

SAP_BASIS 700 0014 SAPKB70014 SAP Basis Component

SAP_ABA 700 0014 SAPKA70014 Cross-Application

Component

ST-PI 2005_1_700 0006 SAPKITLQI6 SAP Solution

Tools Plug-In

PI_BASIS 2006_1_700 0004 SAPKIPYM04 Basis Plug-In

(PI_BASIS) 2006_1_700

SAP_BW 700 0016 SAPKW70016 SAP NetWeaver BI 7.0

SAP_AP 700 0012 SAPKNA7012 SAP Application

Platform 7.00

LCAPPS 2006_700 0004 SAPK-70004INLCAPPS LC

Applications 2006_700

EA-IPPE 400 0008 SAPKGPID08 SAP iPPE (EA-IPPE) 400

SCEMSRV 510 0006 SAPK-51006INSCEMSRV SCEMSRV 5.1

SCM 510 0005 SAPKY51005 Supply Chain Management

5.1

SCMBPLUS 510 0005 SAPK-51005INSCMBPLUS SCM Basis PLUS

5.1

SCMEWM 510 0005 SAPK-51005INSCMEWM Extended

Warehouse Management 5.1

SCMSNC 510 0005 SAPK-51005INSCMSNC SCMSNC 5.1

SCM_BASIS 510 0008 SAPK-51008INSCMBASIS SCM Basis 5.1

QIE 200 0005 SAPK-20005INQIE Quality Inspection

Engine 2.00

BI_CONT 703 0006 SAPKIBIIP6 Business Intelligence

Content

ST-A/PI 01K_SCM500 0000 - Application

Servicetools for SCM 500/510

LCA database connection definition:

-

-

---

Server Name

Host

Check Result

DBMRFC Release

DBMCLI Release

Kernel Release

Kernel Patch

DBSL Release

DBSL Patch

SQLDBC Runtime

-

-

---

|pmichsapbw56_SCQ_00|pmichsapbw56| |7.7.02.08

|7.7.02.08 |700_REL |133 |700.08 |133

7.6.01.15

Thanks in advance for you help.

Stéphane Barraud.

[Former Member]

Problem is solved.

Cause: Named-Pipes protocol was not activated for the MS SQL DB instance.

Thanks to all !

Stéphane Barraud

[former_member229109]

Hello Jaswant Purba,

I think that you posted your information in the wrong thread.

If you have problems with the liveCache please create the OSS ticket

Or if you have the general question about liveCache/liveCache application, please create the new thread.

Thank you and best regards, Natalia Khlopina

*******

Hello Stéphane,

Thank you for the update with the solution to the posted problem.

Good to know, that hint helped you to go in the right direction to identify the problem.

Regards, Natalia Khlopina

[Former Member]

Natalia,

Thanks for your answer.

The tp test is not running very fast and I applied note 208632 on my system.

I still get the same error.

I opened OSS ticket #0000625428.

Thanks,

Stéphane

[Former Member]

Hi

This did not make a difference that where your live cache installed. I write down all the configuration steps.

Please go through once again to make sure you did not miss anything. This is an example so change your values accordingly

regards

Jaswant

-

---

Reference u2013 Use Live Cache Installation Document for more detailed description

Install SCM(Application for which you have to install and configure Live cache)

- login to SCM/BW client with user DDIC

- call LC10 and create logical connections LDA and LCA.

LC u2013Name: LC1

Server: hwi022

DBM-user CONTROL

Password CONTROL

Important!!!

Change default SAPR3 to SAPLC1 and enter the chosen password during installation

Only for connection LCA enter administration report

Integration  Administration Report  in field Fllw-up Procg of section Initialize liveCache Add /SAPAPO/DELETE_LC_ANCHORS  save & Go back to previous Menu

Click Live Cache Moitoring ButtonAdministration (Left Pane)Operating (doubleclick)  Administration (Top Menu)  Initialize Live cache

or

Administration-> Initialize LiveCache

- call SM37 and verify that all batchjobs of report SAPAPO/DELETE_LC_ANCHORS finished successfully.

There must be two jobs for the BW client called PEGAREA_LC_CLIENT_<CLIENT> and RESOURCE_LC_CLIENT_<CLIENT>

- Restart system

- create new user TEST / INITIAL in client 000 (copy of user DDIC)

- login to client 000 with user TEST and change the password to EMPASS

- call SM59 and create RFC destination <SAPSID>CLNT100 with the

following parameters:

- add new client 100 with transactions SCC4, SCCL (profile SAP_UCSV, source client 000, source client user 000) and SCC3 (details see below)

- set DEFAULT profile parameter: login/system_client = 100

- stop and restart system

- login to client 100 with user TEST

- call transaction SM30 and create new logical system <SAPSID>CLNT100 in view V_TBDLS

- with transaction SCC4 assign logical system <SAPSID>CLNT100 to client 100 and change client role to 'Production'

- call transaction RSA1

Test Livecache with transaction /n/sapapo/om03

[former_member229109]

Hello Stéphane,

1) You are SAP customer => I recommend you to create the OSS ticket on this issue.

2) As hint, please check if the tp test will take long time to run.

Run it in /nstms transaction or run report RSTPTEST in /nse38.

Or run command :

tp connect is the SCM database name.

If the connection test is running slow, please check the SAP note ::

208632 TCP/IP network protocol for MSSQ

Thank you and best regards, Natalia Khlopina