SAP ERP6.0 Installtion stopped

[Former Member]

Hi gurus,

My ERP6.0 Installtion stopped at the step Grant database access for account domain\<sid>adm

The sapinst log shows below.

ERROR 2010-01-20 18:26:48.222

MDB-05700 <p> MS SQL server cannot get information about account INCHNSIRSAP\devadm. SOLUTION: Use the MS SQL Server tools to execute the command master..xp_logininfo 'INCHNSIRSAP\devadm' and analyze the errors returned. </p>

ERROR 2010-01-20 18:26:48.269

MUT-03025 Caught ESAPinstException in Modulecall: INCHNSIRSAP\devadm.

ERROR 2010-01-20 18:26:48.316

FCO-00011 The step doGrantOsLogin with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_MSS_DB|ind|ind|ind|ind|2|0|MssOsUser|ind|ind|ind|ind|11|0|doGrantOsLogin was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: INCHNSIRSAP\devadm.).

I created the OS user before starting the installtion..It seems to be permission issue.

Pls let me know how to proceed further..

Regards,

Raja. G

Edited by: Raja Gunasekaran on Jan 20, 2010 2:01 PM

Edited by: Raja Gunasekaran on Jan 20, 2010 2:03 PM

[Former Member]

Hi Raja,

we are also facing same issue? please let us know how did you resolve the error?

Regards,

Mahendra

[Former Member]

Solved. Thx for everyone. The issue is different.

[Former Member]

The SAPinst_dev log as shown below.

Environment Variables

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

= C:=C:\Program Files\sapinst_instdir\ERP\SYSTEM\MSS\CENTRAL\AS

= E:=E:\All CD's\BS_2005_SR3_SAP_Installation_Master\IM_WINDOWS_X86_64

ALLUSERSPROFILE = C:\Documents and Settings\All Users

APPDATA = C:\Documents and Settings\DEVADM\Application Data

CLIENTNAME = 01HW254203

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

CommonProgramFiles = C:\Program Files\Common Files

CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files

COMPUTERNAME = INCHNSIRSAP

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

DBMS_TYPE = mss

FP_NO_HOST_CHECK = NO

HOMEDRIVE = C:

HOMEPATH = \Documents and Settings\DEVADM

LOGONSERVER =
INCHNSIRSAP

MSSQL_DBNAME = DEV

MSSQL_SCHEMA = dev

MSSQL_SERVER = INCHNSIRSAP\DEV

NUMBER_OF_PROCESSORS = 8

OS = Windows_NT

Path = E:\oracle\MRO\102\bin;C:\Program Files\HP\NCU;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\WINDOWS\system32\WindowsPowerShell\v1.0;E:\usr\sap\DEV\SYS\exe\uc\NTAMD64

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

PERL5LIB = E:\oracle\MRO\102\perl\5.8.3\lib\MSWin32-X64-multi-thread;E:\oracle\MRO\102\perl\5.8.3\lib;E:\oracle\MRO\102\perl\5.8.3\lib\MSWin32-X64-multi-thread;E:\oracle\MRO\102\perl\site\5.8.3;E:\oracle\MRO\102\perl\site\5.8.3\lib;E:\oracle\MRO\102\sysman\admin\scripts

PROCESSOR_ARCHITECTURE = AMD64

PROCESSOR_IDENTIFIER = EM64T Family 6 Model 23 Stepping 6, GenuineIntel

PROCESSOR_LEVEL = 6

PROCESSOR_REVISION = 1706

ProgramFiles = C:\Program Files

ProgramFiles(x86) = C:\Program Files (x86)

SAPEXE = E:\usr\sap\DEV\SYS\exe\uc\NTAMD64

SAPINST_EXEDIR_CD = E:/All CD's/BS_2005_SR3_SAP_Installation_Master/IM_WINDOWS_X86_64

SAPINST_JRE_HOME = C:\j2sdk1.4.2_17-x64

SAPLOCALHOST = INCHNSIRSAP

SAPSYSTEMNAME = DEV

SESSIONNAME = RDP-Tcp#12

SystemDrive = C:

SystemRoot = C:\WINDOWS

TEMP = E:\usr\sap\DEV\tmp\2

TMP = E:\usr\sap\DEV\tmp\2

USERDOMAIN = INCHNSIRSAP

USERNAME = DEVADM

USERPROFILE = C:\Documents and Settings\DEVADM

windir = C:\WINDOWS

User: INCHNSIRSAP\DEVADM, Id: S-1-5-21-3819717926-3488865363-3679611668-1014

Working directory: C:\Program Files\sapinst_instdir\ERP\SYSTEM\MSS\CENTRAL\AS

TRACE 2010-01-20 18:26:33.143 [syxxsyshlp.cpp:185]

syslib::logSystemState()

System information

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

OS version, host name: Microsoft Windows [Version 5.2.3790 Service Pack 2] INCHNSIRSAP

RAM size (MB): 16381.7

Swap size (MB): 40321.4

TRACE 2010-01-20 18:26:33.174

Running with control file control.xml version=701 changelist=33819 product-id=d0e25872

TRACE 2010-01-20 18:26:33.174

Selected Service NW_Onehost|ind|ind|ind|ind

TRACE 2010-01-20 18:26:33.190 [synxcfile.cpp:339]

CSyFileImpl::copy(const CSyPath & C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/inifile.8.xml, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

Copying file C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/inifile.xml to C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/inifile.8.xml

INFO 2010-01-20 18:26:33.190 [synxcfile.cpp:493]

CSyFileImpl::copy(const CSyPath & C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/inifile.8.xml, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

Copied file 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/inifile.8.xml'.

INFO 2010-01-20 18:26:33.503 [sixxcstepexecute.cpp:387]

Execute step

Component W2K_ServicePack_Check|ind|ind|ind|ind

Preprocess of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_First_Steps|ind|ind|ind|ind|1|0|W2K_ServicePack_Check|ind|ind|ind|ind|2|0

TRACE 2010-01-20 18:26:47.362

Java script statistics: ScriptSize 6038640 CompileTimeInSeconds 13.813

TRACE 2010-01-20 18:26:47.425 [iaxxclib.cpp:188]

CLib::load()

Opened E:/usr/sap/DEV/tmp/2/sapinst_exe.4076.1263992080/iajsmod.dll

TRACE 2010-01-20 18:26:47.581 [iaxxclib.cpp:188]

CLib::load()

Opened E:/usr/sap/DEV/tmp/2/sapinst_exe.4076.1263992080/iamodos.dll

TRACE 2010-01-20 18:26:47.628 [synxccuren.cpp:1115]

CSyCurrentProcessEnvironmentImpl::getEffectiveUser(iastring&)

effective user corresponds to real user

TRACE 2010-01-20 18:26:47.644

Call block:W2K_ServicePack_Check_ind_ind_ind_ind

function:W2K_ServicePack_Check_ind_ind_ind_ind_Preprocess

is validator: false

TRACE 2010-01-20 18:26:47.769

Status of Step |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_MSS_DB|ind|ind|ind|ind|2|0|MssOsUser|ind|ind|ind|ind|11|0|doGrantOsLogin is not OK. Re execute only that step and go on in RESTART mode.

TRACE 2010-01-20 18:26:47.894 [synxcfile.cpp:339]

CSyFileImpl::copy(const CSyPath & C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/keydb.8.xml, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

Copying file C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/keydb.xml to C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/keydb.8.xml

INFO 2010-01-20 18:26:47.894 [synxcfile.cpp:493]

CSyFileImpl::copy(const CSyPath & C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/keydb.8.xml, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

Copied file 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/keydb.xml' to 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/keydb.8.xml'.

TRACE 2010-01-20 18:26:47.987 [synxcfile.cpp:339]

CSyFileImpl::copy(const CSyPath & C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/statistic.23.xml, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

Copying file C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/statistic.xml to C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/statistic.23.xml

INFO 2010-01-20 18:26:48.003 [synxcfile.cpp:493]

CSyFileImpl::copy(const CSyPath & C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/statistic.23.xml, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

Copied file 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/statistic.xml' to 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/CENTRAL/AS/statistic.23.xml'.

INFO 2010-01-20 18:26:48.65 [sixxcstepexecute.cpp:781]

Execute step doGrantOsLogin of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_MSS_DB|ind|ind|ind|ind|2|0|MssOsUser|ind|ind|ind|ind|11|0

TRACE 2010-01-20 18:26:48.81 [sixxcstepexecute.cpp:850]

Execution of preprocess block of |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_MSS_DB|ind|ind|ind|ind|2|0|MssOsUser|ind|ind|ind|ind|11|0|doGrantOsLogin returns TRUE.

TRACE 2010-01-20 18:26:48.081 [synxccuren.cpp:1115]

CSyCurrentProcessEnvironmentImpl::getEffectiveUser(iastring&)

effective user corresponds to real user

TRACE 2010-01-20 18:26:48.097

Call block:MssOsUser_ind_ind_ind_ind

function:MssOsUser_ind_ind_ind_ind_PreStepPhase_doGrantOsLogin

is validator: false

TRACE 2010-01-20 18:26:48.144 [iaxxclib.cpp:188]

CLib::load()

Opened E:/usr/sap/DEV/tmp/2/sapinst_exe.4076.1263992080/iamodmssql.dll

TRACE 2010-01-20 18:26:48.190

t_MssMessages.remove(WHERE 1=1)

TRACE 2010-01-20 18:26:48.222

t_MssMessages.remove(WHERE 1=1)

ERROR 2010-01-20 18:26:48.222 [iaxxinscbk.cpp:260]

MDB-05700 <p> MS SQL server cannot get information about account INCHNSIRSAP\devadm. SOLUTION: Use the MS SQL Server tools to execute the command master..xp_logininfo 'INCHNSIRSAP\devadm' and analyze the errors returned. </p>

TRACE 2010-01-20 18:26:48.269 [iaxxejsbas.hpp:408]

handleException<ESAPinstException>()

Converting exception into JS Exception Exception.

TRACE 2010-01-20 18:26:48.269

Function setMessageIdOfExceptionMessage: modlib.jslib.caughtException

ERROR 2010-01-20 18:26:48.269

CJSlibModule::writeError_impl()

MUT-03025 Caught ESAPinstException in Modulecall: INCHNSIRSAP\devadm.

TRACE 2010-01-20 18:26:48.300 [iaxxejsbas.hpp:483]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown unknown exception. Rethrowing.

ERROR 2010-01-20 18:26:48.316 [sixxcstepexecute.cpp:951]

FCO-00011 The step doGrantOsLogin with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_MSS_DB|ind|ind|ind|ind|2|0|MssOsUser|ind|ind|ind|ind|11|0|doGrantOsLogin was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: INCHNSIRSAP\devadm.).

TRACE 2010-01-20 18:26:48.347 [iaxxgenimp.cpp:752]

CGuiEngineImp::showMessageBox

An error occurred while processing service SAP ERP 6.0 Support Release 3 > SAP Systems > MS SQL Server > Central System > Central System( Last error reported by the step :Caught ESAPinstException in Modulecall: INCHNSIRSAP\devadm.). 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/ERP/SYSTEM/MSS/CENTRAL/AS.

TRACE 2010-01-20 18:26:48.347 [iaxxgenimp.cpp:1255]

CGuiEngineImp::acceptAnswerForBlockingRequest

Waiting for an answer from GUI

[Former Member]

Hi,

Have you checked SAP Note 986456 - SAP installation stops with xp_logininfo execution ?

Cheers....,

Raghu

[Former Member]

Hi Raghu,

I solved the problem by SQL server latest patch..now i got into another problem..

An error occurred while processing service SAP ERP 6.0 Support Release 3 > SAP Systems > MS SQL Server > Central System > Central System( Last error reported by the step :Process call 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.). You may now

The sapinst.log shows as below..

E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP

E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jan 24 2008 01:41:44

E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -testconnect

(DB) ERROR: db_connect rc = 256

(DB) ERROR: DbSlErrorMsg rc = 99

E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100121144143

ERROR 2010-01-21 14:41:43.378

CJS-30023 Process call 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.

ERROR 2010-01-21 14:41:43.456

FCO-00011 The step testDatabaseConnection with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_ABAP_Import_Dialog|ind|ind|ind|ind|5|0|NW_ABAP_Import|ind|ind|ind|ind|0|0|testDatabaseConnection was executed with status ERROR ( Last error reported by the step :Process call 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\R3load.exe -testconnect' exits with error code 2. For details see log file(s) R3load.exe.log.).

pls help me to resolve the issue..

Regards,

Raja. G

[Former Member]

The trans.log shows as below..

4 ETW000 r3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 21.01.2010 - 12:39:02

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: r3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Thu Jan 21 12:39:04 2010 0 0.000000

4 ETW000 [dev trc ,00000] db_con_init called 0 0.000000

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 0 0.000000

4 ETW000 [dev trc ,00000] Loading DB library 'dbmssslib.dll' ... 0 0.000000

4 ETW000 [dev trc ,00000] load shared library (dbmssslib.dll), hdl 0 7956 0.007956

4 ETW000 [dev trc ,00000] using "E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbmssslib.dll"

4 ETW000 20 0.007976

4 ETW000 [dev trc ,00000] Library 'dbmssslib.dll' loaded 11 0.007987

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library dbmssslib.dll

4 ETW000 18 0.008005

4 ETW000 [dev trc ,00000] Version of 'dbmssslib.dll' is "700.08", patchlevel (0.144)

4 ETW000 525 0.008530

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library dbmssslib.dll

4 ETW000 19 0.008549

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library dbmssslib.dll

4 ETW000 16 0.008565

4 ETW000 [dev trc ,00000] New connection 0 created 22 0.008587

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 26 0.008613

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 16 0.008629

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse:

4 ETW000 16 0.008645

4 ETW000 [dev trc ,00000] 0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 22 0.008667

4 ETW000 [dev trc ,00000] Thank You for using the SLODBC-interface 902 0.009569

4 ETW000 [dev trc ,00000] Using dynamic link library 'E:\usr\sap\DEV\SYS\exe\uc\NTAMD64\dbmssslib.dll'

4 ETW000 23 0.009592

4 ETW000 [dev trc ,00000] dbmssslib.dll patch info 20 0.009612

4 ETW000 [dev trc ,00000] patchlevel 0 10 0.009622

4 ETW000 [dev trc ,00000] patchno 144 9 0.009631

4 ETW000 [dev trc ,00000] patchcomment MSSQL: ODBC fastload on separate connection (1131805)

4 ETW000 16 0.009647

4 ETW000 [dev trc ,00000] Local connection used on INCHNSIRSAP to named instance: lpc:INCHNSIRSAP\DEV

4 ETW000 387 0.010034

4 ETW000 [dev trc ,00000] Local connection used on INCHNSIRSAP to named instance: lpc:INCHNSIRSAP\DEV

4 ETW000 58866 0.068900

4 ETW000 [dev trc ,00000] Local connection used on INCHNSIRSAP to named instance: lpc:INCHNSIRSAP\DEV

4 ETW000 3756 0.072656

4 ETW000 [dev trc ,00000] Driver: sqlncli10.dll Driver release: 10.00.2531

4 ETW000 3594 0.076250

4 ETW000 [dev trc ,00000] GetDbRelease: 10.00.2531 281 0.076531

4 ETW000 [dev trc ,00000] GetDbRelease: Got DB release numbers (10,0,2531)

4 ETW000 18 0.076549

4 ETW000 [dev trc ,00000] ERROR: schema user dev has administrator fixed server role (user_name() is 'dbo').

4 ETW000 196 0.076745

4 ETW000 [dev trc ,00000] This is not allowed. Please check the Server Roles of user dev.

4 ETW000 17 0.076762

2EETW169 no connect possible: "DBMS = MSSQL --- SERVER = 'INCHNSIRSAP\DEV' DBNAME = 'DEV'"

[JPReyes]

Read SAP Note 1047985 - schema user sid may not be member of sysadmin server role

Regards

Juan