System copy

[Former Member]

Hi Guys,

While performing system copy I got this error:

sapparam: sapargv( argc, argv) has not been called.

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

hostname\sapmnt\<SID>\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100320103807

hostname\sapmnt\<SID>\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#20 $ SAP

hostname\sapmnt\<SID>\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 UNICODE

Compiled Aug 23 2009 23:42:38

hostname\sapmnt\<SID>\SYS\exe\uc\NTAMD64\R3load.exe -testconnect

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 99

hostname\sapmnt\<SID>\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

hostname\sapmnt\<SID>\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100320103813

OS: win2k3 server

Enviroment :Distributed

DB: MSSQL 2005

I am running system copy through administrator with option *use current domain" . I am able to execute R3load -testconnect on CI manually but the error above comes when I executed the same on DB server.

Please guide how to rectify it.

Regards,

Mridul

[Former Member]

Problem solved with the help of SAP consultation.

[Former Member]

Hi Mridul,

I am facing same error.

What was the solution provided by SAP consultation?

BR,

Samuli

[Former Member]

Hi Samuli,

Please set environmental variable MSSQL_FORCEOLEDB=1 in your database instance.

Please let me know if your problem get solved.

Regards,

Miridul

[markus_doehr2]

> I am running system copy through administrator with option *use current domain" . I am able to execute R3load -testconnect on CI manually but the error above comes when I executed the same on DB server.

Can you execute

R3load -testconnect

as <sid>adm on the database server?

Markus

[Former Member]

Hi Markus,

I am getting the same error with <sid>adm too.

rgds,

Mridul

[markus_doehr2]

Do you get any entries in the Windows event log?

Markus

[Former Member]

Please correct me if I am wrong, I checkd out the event viewer and there were logs in System and Application field only, other field do not have any log, I checked it for <sid>adm.

rgds,

Mridul

[markus_doehr2]

Well - you get any error listed in them?

Markus

[Former Member]

I didn'y get any error as such but there was a file info concerned with MSSQL

Event Type: Information

Event Source: MSSQL$WE6

Event Category: (2)

Event ID: 15281

Date: 3/22/2010

Time: 2:46:45 AM

User: DEV\SAPServiceWE6

Computer: WSS-SEA-AXDB1

Description:

SQL Server blocked access to procedure 'dbo.sp_get_sqlagent_properties' of component 'Agent XPs' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs', see "Surface Area Configuration" in SQL Server Books Online.

And the error that was there I don't think is of our concern:

Event Type: Error

Event Source: Report Server Windows Service (JIRA)

Event Category: Startup/Shutdown

Event ID: 117

Date: 3/22/2010

Time: 2:02:06 AM

User: N/A

Computer: WSS-SEA-AXDB1

Description:

The report server database is an invalid version.

rgds,

Mridul

[markus_doehr2]

Is your SQL Agent service running and set to "automatic"?

Markus

[Former Member]

yes

[markus_doehr2]

I'm sorry, I can't help you further. I'd open an OSS call and let someone check directly on your system.

Markus

[Former Member]

thanks for ur effort, just wanna know one thing more will this issue will affect the source system running in future

Regards,

Mridul

[markus_doehr2]

> thanks for ur effort, just wanna know one thing more will this issue will affect the source system running in future

We don't know yet what the issue is. And keep in mind that the SAP system runs under user "SAPService<SID>", not under <sid>adm.

Is this Windows 2008?

Markus

[Former Member]

Hi Makrus,

The issue is described completely in my first msg...

OS : Windows 2003 server 64 bit

I faced this error while performing system copy step on source system through sapinst( ECC6.0 SR2) using DB independent method on my DB server.

Note: The enviroment is distributed.

I will really appreciate if you can help.

Regards,

Mridul

[Former Member]

Dear Friend

Is your issue resolved?

From which system are you running sapinst.

Regards

Mohammed