4.7 Homogeneous System copy - Backup & Restore Method

[Former Member]

Hi,

I am doing Homogeneous system copy of SAP 4.7 in win2003 & SQL2000. I followed Note :551915 & used user_restore script. My SAP server is not starting. I am attaching the log file of dev_w2. Please guide me

<<

-

---

trc file: "dev_w2", trc level: 1, release: "620"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Tue Jun 02 20:02:43 2009

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\DV1\SYS\exe\run\dbmssslib.dll' ...

B Library 'C:\usr\sap\DV1\SYS\exe\run\dbmssslib.dll' loaded

B Version of 'C:\usr\sap\DV1\SYS\exe\run\dbmssslib.dll' is "620.02", patchlevel (0.235)

B New connection 0 created

M systemid 560 (PC with Windows NT)

M relno 6200

M patchlevel 0

M patchno 251

M intno 20020600

M pid 1452

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 2 1452) [dpxxdisp.c 1016]

I MtxInit: -2 0 0

X

X Tue Jun 02 20:02:44 2009

X EmInit: MmSetImplementation( 2 ).

X <ES> client 2 initializing ....

X Using implementation std

M <EsNT> Memory Reset enabled as NT default

X ES initialized.

M

M Tue Jun 02 20:02:45 2009

M calling db_connect ...

C SQLOLEDB Provider Release:08.10.3959

C Shared cache sizes: header 52 bytes, 10000 names (13360000 bytes), 1000 dynamic statements (5436000 bytes), total 18796052 bytes

C Using shared procedure name cache initialized by another process.

C Thank You for using the SLOLEDB-interface

C Connected to db server : [adapsap47], dbname: DV1, dbuser: dv1

C Using dynamic link library 'C:\usr\sap\DV1\SYS\exe\run\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 235

C patchcomment MSSQL: STRING_BAD_REF on NULL-lob-access (412757)

B Connection 0 opened

B Wp Hdl ConName ConId ConState TX PRM RCT Date Time DBHost

B 000 000 R/3 000000000 ACTIVE NO YES NO 20090602 200245 ADAPSAP47

C The IRow interface is supported by this OLEDB provider

C ParamStmtExec: line 22924. hr: 0x80040e37 Invalid object name 'SVERS'.

C HandleOledbError [ParamStmtExec,line 22924]: Error/Message: (err 208, sev 16), Invalid object name 'SVERS'.

C ParamStmtExec failed. HR 80040e37 DBSL retcode 103. stmt: [SELECT VERSION AS c FROM SVERS ]

C DbSlRead - Error 103 (dbcode 208) on open

C DbSlRead - <##Y2ADAPSAP4dv100000014520000000001200245>

C DbSlRead - Error 103 (dbcode 208) on fetch

C DbSlRead - <##Y2ADAPSAP4dv100000014520000000001200245>

B ***LOG BZA=> table SVERS does not exist on database [dblink#1 @ 1292] [dblink 1292 ]

M ***LOG R19=> tskh_init, db_connect ( DB-Connect 004096) [thxxhead.c 1098]

M in_ThErrHandle: 1

M *** ERROR => tskh_init: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 8277]

M

M Info for wp 2

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

M *****************************************************************************

M *

M * LOCATION SAP-Server adapsap47_DV1_00 on host adapsap47 (wp 2)

M * ERROR tskh_init: db_connect

M *

M * TIME Tue Jun 02 20:02:45 2009

M * RELEASE 620

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 8408

M * COUNTER 1

M *

M *****************************************************************************

M

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >SAP-Trace buffer write< for event BEFORE_DUMP

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 672]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 235]

M Entering ThSetStatError

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 2 1452) [dpnttool.c 345]

>>

Regards,

Srinivas

[markus_doehr2]

> -

---

> trc file: "dev_w2", trc level: 1, release: "620"

> -

---

You should REALLY update your kernel. The version you use is several years old and no more supported.

Read Note 803429 - Desupport 6.20 kernel

How did you execute the script?

Markus

[Former Member]

Hi,

Do we need to apply new license after Homogeneous system copy. My previous server license is still valid. But, the Hardware key is different.

I am getting syntax error pop-up when login into the SAP. I am able to access the transaction when

Syntax error in program : SAPLSMTR_NAVIGATION_MODULES

in include : LSMTR_NAVIGATION_MODULES03

in line : 212

Last changes by : SAP

Author : SAP

"..." is not expected.

Please can anyone guide me in this. Also, Do we need to do any post installation steps after system copy?.

Regards,

Srinivas.P

[Former Member]

Yes Srinivas,

You will have to apply for a new license

and there are many post installation activities that need to be carried out after system copy

Refer to note 151603,this will tell you all the post installation steps to be carried out

Rohit

[Former Member]

Hi,

The Languages(Chinese,Japanese,Korean) Installed on the source system(Non- Unicode) are not reflecting in the target system(Non- Unicode) after Homogeneous system copy.

Can you please guide whether we have to do Unicode conversion for this /Is their any way for activating the languages. I Executed the report RSCPINST and tried to activate the languages after doing stimulation and copying zcsa/installed_languages =13CDEFIJLMNOPQRSTVZ to the instance profile.

Regards,

Srinivas

[markus_doehr2]

> The Languages(Chinese,Japanese,Korean) Installed on the source system(Non- Unicode) are not reflecting in the target system(Non- Unicode) after Homogeneous system copy.

Can you tell us what you mean with "not reflecting"? All the content is in the database so if you copied that, it's definitely there.

> Can you please guide whether we have to do Unicode conversion for this /Is their any way for activating the languages. I Executed the report RSCPINST and tried to activate the languages after doing stimulation and copying zcsa/installed_languages =13CDEFIJLMNOPQRSTVZ to the instance profile.

...and you did a restart of the instance after you changed that parameter?

Markus

[Former Member]

Hi Markus,

Thanks for the reply!

I am not able to login with the Chinese,Japanese,Korean languages.Yes, I restart the Instance.

Regards,

Srinivas.P

[markus_doehr2]

> I am not able to login with the Chinese,Japanese,Korean languages.Yes, I restart the Instance.

What error message do you get? "Not being able" can mean so much...

If you want help, you have to exactly specify what problem you face, not just "it's not working" or "I'm not able to..".

Markus

[Former Member]

Hi Markus,

When i am trying to login with Language chinese (ZH)

I am getting this error "Language Environment cannot be configured for language 1"

Regards,

Srinivas

[markus_doehr2]

> When i am trying to login with Language chinese (ZH)

> I am getting this error "Language Environment cannot be configured for language 1"

Do you have the chinese operating system locales installed on that server?

Markus

[Former Member]

Hi All,

Thanks for quick help. I Installed locales and the issue was resolved

Regards,

Srinivas.P

[Former Member]

Is this really the name and schema of the DB your connecting to:

Connected to db server : [adapsap47], dbname: DV1, dbuser: dv1

The system seems to connect to the DB engine but can't find the object DV1.dv1.SVERS.

Sven

[Former Member]

Hi Sven,

Thanks for the reply. Yeah, I am connecting to db server: adapsap47 ; dbname: DV1; dbuser : dv1

Regards,

Srinivas

[andreas_herzog]

LOG BZA=> table SVERS does not exist on database

^^ are you sure all import processes (r3load) ended succesfully?

please have a look at all r3load import logs...

somehow SVERS is not found and that points to a possible import failure (meaning not all import processes were succesful)...

GreetZ, AH

[Former Member]

Or you can use the Query Analyzer:

use DV1

go

setuser 'dv1'

go

select * from SVERS;

Getting any results?

Sven

[Former Member]

Sven,

I am getting output as invalid object.when executing the following Query.

use DV1

go

setuser 'dv1'

go

select * from SVERS;

But, when using the following query i am getting it as version : 620

use DV1

go

setuser 'dv1'

go

select * from dv1.SVERS;

Regards,

Srinivas.P

[clas_hortien]

Hello,

the login you are using is part of the sysadmin serverrole. For the SAP system you have to remove it from this role. The login <sid> have to member of the bulkadmin, dbcreator and serveradmin role, but NOT of the sysadmin role.

The root cause for the problem is, that when you are member of the sysadmin role, your default schema is dbo and not <sid>. Thats why you can't find the table SVERS (as it is not part of the dbo schema) but the table sid.SVERS.

Best regards

Clas

[Former Member]

Sven & Clas,

Thanks for the quick reply & Great help. My SAP server is started and the issue was resolved.

Regards,

Srinivas.P