Error during DatabaseCopy using SAP tools for SQL Server (v7.12)

[Former Member]

I'm trying to perform a system copy from PRD to QAS. The database has been mounted to QAS via detach and attach method. I did a DBCC on the database and everything looks OK. I'm running SAPINST (SAP Tools for MSSQL) and selecting the Database Copy option. The source database has a schema of DBO. Both PRD and QAS are running SAP 4.7/Basis 620. The target schema is QAS. SAPINST fails in step 2 (Define Params) with:

"This service cannot be used for a system with SAP ABAP release 620"

Is this message misleading? Has anyone receive this message before.

UPDATE:

I donwloaded the latest version of SAP Tools for MSSQL and now it failes during the execution phase on step, "Convert DB objects to new schema".

Here is the log:

Process environment

===================

Environment Variables

=====================

=::=::\

=C:=C:\Program Files\sapinst_instdir\MSS\CPY

ALLUSERSPROFILE=C:\Documents and Settings\All Users

APPDATA=C:\Documents and Settings\r3tadm.STAG\Application Data

CLIENTNAME=TRAIMONOTEBOOK

ClusterLog=C:\WINDOWS\Cluster\cluster.log

CommonProgramFiles=C:\Program Files\Common Files

COMPUTERNAME=STAG

ComSpec=C:\WINDOWS\system32\cmd.exe

DBMS_TYPE=MSS

FP_NO_HOST_CHECK=NO

HOMEDRIVE=C:

HOMEPATH=\Documents and Settings\r3tadm.STAG

LOGONSERVER=
STAG

MSSQL_DBNAME=R3T

MSSQL_SERVER=stag

NUMBER_OF_PROCESSORS=4

OS=Windows_NT

Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Dell\SysMgt\RAC5;C:\Program Files\Dell\SysMgt\oma\bin;C:\Program Files\Dell\SysMgt\oma\oldiags\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\usr\sap\R3T\SYS\exe\run

PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH

PROCESSOR_ARCHITECTURE=x86

PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 6, GenuineIntel

PROCESSOR_LEVEL=6

PROCESSOR_REVISION=0f06

ProgramFiles=C:\Program Files

SAPINST_EXEDIR_CD=C:/STM/I386

SAPINST_JRE_HOME=C:/WINDOWS/TEMP/3/sapinst_exe.3012.1234409473/jre

SAPLOCALHOST=stag

SESSIONNAME=RDP-Tcp#25

SystemDrive=C:

SystemRoot=C:\WINDOWS

TEMP=C:\WINDOWS\TEMP\3

TMP=C:\WINDOWS\TEMP\3

USERDOMAIN=STAG

USERNAME=r3tadm

USERPROFILE=C:\Documents and Settings\r3tadm.STAG

windir=C:\WINDOWS

User: STAG\r3tadm, Id: S-1-5-21-2727398557-1322528747-1943968026-1019

Working directory: C:/Program Files/sapinst_instdir/MSS/CPY

Current access token

====================

Could not get thread token. Last error: 1008. I assume that no thread token exists.

Got process token.

Privileges:

Privilege SeBackupPrivilege, display name: Back up files and directories, not enabled.

Privilege SeRestorePrivilege, display name: Restore files and directories, not enabled.

Privilege SeShutdownPrivilege, display name: Shut down the system, not enabled.

Privilege SeDebugPrivilege, display name: Debug programs, not enabled.

Privilege SeAssignPrimaryTokenPrivilege, display name: Replace a process level token, not enabled.

Privilege SeSystemEnvironmentPrivilege, display name: Modify firmware environment values, not enabled.

Privilege SeIncreaseQuotaPrivilege, display name: Adjust memory quotas for a process, not enabled.

Privilege SeChangeNotifyPrivilege, display name: Bypass traverse checking, enabled.

Privilege SeRemoteShutdownPrivilege, display name: Force shutdown from a remote system, not enabled.

Privilege SeTcbPrivilege, display name: Act as part of the operating system, not enabled.

Privilege SeUndockPrivilege, display name: Remove computer from docking station, not enabled.

Privilege SeSecurityPrivilege, display name: Manage auditing and security log, not enabled.

Privilege SeTakeOwnershipPrivilege, display name: Take ownership of files or other objects, not enabled.

Privilege SeLoadDriverPrivilege, display name: Load and unload device drivers, not enabled.

Privilege SeManageVolumePrivilege, display name: Perform volume maintenance tasks, not enabled.

Privilege SeSystemProfilePrivilege, display name: Profile system performance, not enabled.

Privilege SeImpersonatePrivilege, display name: Impersonate a client after authentication, enabled.

Privilege SeSystemtimePrivilege, display name: Change the system time, not enabled.

Privilege SeCreateGlobalPrivilege, display name: Create global objects, enabled.

Privilege SeProfileSingleProcessPrivilege, display name: Profile single process, not enabled.

Privilege SeIncreaseBasePriorityPrivilege, display name: Increase scheduling priority, not enabled.

Privilege SeCreatePagefilePrivilege, display name: Create a pagefile, not enabled.

Groups:

Group count: 14

\LOCAL S-1-2-0 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

BUILTIN\Administrators S-1-5-32-544 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED SE_GROUP_OWNER

\Everyone S-1-1-0 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

BUILTIN\Users S-1-5-32-545 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

STAG\SAP_R3T_LocalAdmin S-1-5-21-2727398557-1322528747-1943968026-1021 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

STAG\SAP_LocalAdmin S-1-5-21-2727398557-1322528747-1943968026-1023 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

STAG\None S-1-5-21-2727398557-1322528747-1943968026-513 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

NT AUTHORITY\INTERACTIVE S-1-5-4 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

NT AUTHORITY\NTLM Authentication S-1-5-64-10 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

NT AUTHORITY\Authenticated Users S-1-5-11 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

\ S-1-5-5-0-36828865 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED SE_GROUP_LOGON_ID

NT AUTHORITY\REMOTE INTERACTIVE LOGON S-1-5-14 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

NT AUTHORITY\This Organization S-1-5-15 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

STAG\SAP_R3T_GlobalAdmin S-1-5-21-2727398557-1322528747-1943968026-1018 Attributes: SE_GROUP_MANDATORY SE_GROUP_ENABLED_BY_DEFAULT SE_GROUP_ENABLED

ERROR 2009-02-11 19:31:46.529 [sixxcstepexecute.cpp:984]

FCO-00011 The step MoveSchema with step key |SAPMSSTOOLS|ind|ind|ind|ind|0|0|MssSysCopy|ind|ind|ind|ind|4|0|MssSchemaMove|ind|ind|ind|ind|2|0|MoveSchema was executed with status ERROR .

TRACE 2009-02-11 19:31:46.544

Call block:CallBackInCaseOfAnErrorDuringStepExecution

function:CallTheLogInquirer

is validator: true

WARNING 2009-02-11 19:31:46.544 [iaxxejshlp.cpp:150]

Could not get property IDs of the JavaScript object.

ERROR 2009-02-11 19:31:46.544 [iaxxejsctl.cpp:492]

FJS-00010 Could not get value for property .

TRACE 2009-02-11 19:31:46.544

A problem occurs during execution the inquirer callback. SAPinst will switch back to the standard behaiviour.

TRACE 2009-02-11 19:31:46.544 [iaxxgenimp.cpp:707]

CGuiEngineImp::showMessageBox

<html> <head> </head> <body> <p> An error occurred while processing service SAP Toools for MS SQL Server > Database Copy. You may now </p> <ul> <li> choose <i>Retry</i> to repeat the current step. </li> <li> choose <i>View Log</i> to get more information about the error. </li> <li> stop the task and continue with it later. </li> </ul> <p> Log files are written to C:\Program Files/sapinst_instdir/MSS/CPY. </p> </body></html>

TRACE 2009-02-11 19:31:46.544 [iaxxgenimp.cpp:1245]

CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

Edited by: Tony Raimo on Feb 12, 2009 4:37 AM

[patelyogesh]

This is looks like permission issue on source folder

Copy source in to your local drive and try again.

I had same issue and able to resolve after copy EXP1 EXP2 and EXP3 folder in to local drive C: with Everyone full access

Yogesh

[Former Member]

Please see OSS Note 1381061 - it answers this issue.