Dispatcher not working in the new system - PRD cloneing

[Former Member]

Hi,

Our development system got crashed and unfortunately we do not have recent backup. Hence we have planned to build the DEV environment from PRD system.

Below is the sequence we performed.

1. We have created new system from production system using clone method
2. In the new system we have changed the IP address and Host name
   1. Hostname : MUM-SAPDEVNEW
3. Changed the env variables
4. Changed the application profile
   1. Default profile
   2. Start profile
   3. Instance profile
5. Change values in the host file

After starting the application in the new system the dispatcher is not coming up and work process 4 is running to connect to DB and ended with error.

Is there anything we need to change in the DB level ?

OS : Win 2003

DB: Mssql 2003

``````````````````````````````````````````````````````````

Work process 4 - Error

```````````````````````````````````````````````````````````

M  rdisp/reinitialize_code_page ::0 -> 0

M  icm/accept_remote_trace_level ::0 -> 0

M  rdisp/no_hooks_for_sqlbreak ::0 -> 0

M  CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

C  Using Provider SQLNCLI

C  OpenOledbConnection: line 22822. hr: 0x8000ffff An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C  sloledb.cpp [OpenOledbConnection,line 22822]: Error/Message: (err 0, sev 0), An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

C  Procname: [OpenOledbConnection - no proc]

C  sloledb.cpp [OpenOledbConnection,line 22822]: Error/Message: (err 10054, sev 0), Communication link failure

C  Procname: [OpenOledbConnection - no proc]

C  sloledb.cpp [OpenOledbConnection,line 22822]: Error/Message: (err 10054, sev 0), TCP Provider: An existing connection was forcibly closed by the remote host.

C  Procname: [OpenOledbConnection - no proc]

C  sloledb.cpp [OpenOledbConnection,line 22822]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C  Procname: [OpenOledbConnection - no proc]

C  Using Provider SQLNCLI

C  The IRow interface is supported by this OLEDB provider

S  *** init spool environment

S  initialize debug system

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Log: Disp_disp

````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````

MBUF state PREPARED

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1025]

Tue Aug 04 14:12:39 2015

MBUF state ACTIVE

*** ERROR => DpRqNoWpHandle: SHUTDOWN request from wp_id 9 received [dpxxdisp.c   4521]

DpHalt: shutdown server >MUM-SAPDEVNEW_PQN_00                    < (normal)

DpModState: change server state from STARTING to SHUTDOWN

Stop work processes...

Tue Aug 04 14:12:40 2015

SoftCancel request for T1 U2 M0 received from DISPATCHER

SoftCancel request for T19 U20 M0 received from DISPATCHER

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~``

Tue Aug 04 14:13:00 2015

*** ERROR => DpWpKill(3508, SIGUSR2): kill failed [dpxxtool.c   2467]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~```

Log :

[Former Member]

Dear Zri,

Using clone method in MSSQL database Account privileges and Remote connection will not change.

Please use SWPM to built the system .

Regards,

Nilesh

[former_member182657]

Hi,

1. We have created new system from production system using clone method

Instead of cloning you need to perform homogeneous system copy methods as well as you can do system redirect restore procedure if you've consistent backup of PRD system (With the help of your backup solution at your end ) to built fresh DEV system.

Regards,

[former_member202590]

Hi,

In these kind of cases, the best way to go about is either

take export of the source system (PRD in your case) and install the new DEV with that export

Or

Install a completely new Dev system and then restore the backup of the existing PRD system.

You can choose the option you are more comfortable with

AC

[Sriram2009]

Hi

2. In the new system we have changed the IP address and Host name

Hostname : MUM-SAPDEVNEW

After change the host name of PRD to Dev SAP will not start. You have to perform the Homogeneous system copy or Client copy Export /Import method from PRD to Dev. Clone method may not work.

Regards

SS