Error(s) occured in phase PREP_INIT/DBCHK_INI!

[Former Member]

Hello experts im doing a upgrade of a ecc 6.0 to ehp 6 and im facing a error
that says:

SAPup broke during phase DBCHK_INI in module PREP_INIT / Initialization
Error Message: Cannot open 'D:\usr\sap\DSB\SUM\abap\tmp\NLSLANG.DAT':

The system cannot find the file specified. Where do i fing the NLSLANG.DAT or how i generate it?

here is the trouble ticket:

This trouble ticket was created by SAPup on 20130522150755
-------------------------------------------------------------
SAPup broke during phase DBCHK_INI in module PREP_INIT / Initialization
Error Message: Cannot open 'D:\usr\sap\DSB\SUM\abap\tmp\NLSLANG.DAT': The system cannot find the file specified.

-------------------------------------------------------------
-------------------------------------------------------------
Summary of SAPup:
-------------------------------------------------------------
SAPehpi Release: lmt_008
SAPehpi Version: SAPup release lmt_008 version 52.000
Start Release:  700
Target Release:  731
-------------------------------------------------------------
Summary of host system details:
-------------------------------------------------------------
SID:   DSB
Host:   sandbox
MS Host:  sandbox
GW Host:  sandbox
Start Path:  D:\usr\sap\DSB\DVEBMGS00\exe
Kernel Path:  D:\usr\sap\DSB\DVEBMGS00\exe
-------------------------------------------------------------
Summary of operating system details:
-------------------------------------------------------------
OS Type:  Windows NT X86_64
OS Version:  6.1
-------------------------------------------------------------
Summary of database details:
-------------------------------------------------------------
Database Type:  ora
Database Version: 11.2.0.3.0
-------------------------------------------------------------
Summary of RFC details:
-------------------------------------------------------------
Host:   sandbox
GW Host:  sandbox
Client:   000
Destination:  DSB
Language:  E
System No.:  00
-------------------------------------------------------------
-------------------------------------------------------------

Thanks for your help,

Regards,

[praveen_nambiar · Accepted solution]

Hello Ale,

I can see Karthik given some suggestions, while you are trying that, can you see some errors in SAPup.LOG or SAPupConsol.log?

By the what version of SUM you are using?

Many Thanks
Praveen Kumar

[Former Member · Accepted solution]

Hello thanks for your help,

im using the sum:

Software Update Manager Version: 1.0

Support Package Version: 7

Patch Level: 2    

I renamed the NLS_LANG to NLS_LANG_old but it still in the issue.

here are the las lines of the of the

SAPup.log:

************************* SAPup started in PREPARE mode *************************

# This is SAPup release lmt_008 version 52.000 compile time 19:14:38 May 12 2013.

# This is UNICODE SAPup!

# Running in graphics mode batch.

# DB-functions initialized for 'ORACLE'.

# GUI reports feature 'dialogue' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'handleerror' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'dialoghelp' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'html' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'console' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'progress' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'unitcontrol' as 'enabled' level 3, user said 'unknown'.

# GUI reports feature 'unitstatus' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'actions' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'remotecontrol' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'synchronization' as 'enabled' level 2, user said 'unknown'.

# GUI reports feature 'mid' as 'enabled' level 4, user said 'unknown'.

# GUI reports feature 'exit' as 'unknown' level 0, user said 'unknown'.

# GUI reports feature 'evaluation' as 'enabled' level 1, user said 'unknown'.

# GUI reports feature 'newhttpsrv' as 'unknown' level 0, user said 'unknown'.

STARTUP 20130528182607

Current unit is 'EXTRACT', next unit is 'EXTRACT'.

-> decided to continue with unit EXTRACT.

...begin dialog at 20130528182607

...end dialog at 20130528182610

..answered at 20130528182610.

-> decided to try again.

# Executing module 'PREP_INIT'.

Execution of PREPARE module "Initialization" begins at 20130528182610

# Starting phase execution with maxpar = 3, scheduled: 37x'-'

CURRENTPHASE PREP_INIT/DBCHK_INI

...started at 20130528182610

..finished at 20130528182611 with status ABORTED.

# Error message set: 'Cannot open 'D:\usr\sap\DSB\SUM\abap\tmp\NLSLANG.DAT': The system cannot find the file specified.

'

...begin dialog at 20130528182612

...end dialog at 20130528182615

..answered at 20130528182615.

-> decided to try again.

CURRENTPHASE PREP_INIT/DBCHK_INI

...started at 20130528182615

..finished at 20130528182615 with status ABORTED.

# Error message set: 'Cannot open 'D:\usr\sap\DSB\SUM\abap\tmp\NLSLANG.DAT': The system cannot find the file specified.

'

...begin dialog at 20130528182616

and the SAPupConsol.log:

Execution of PREPARE module "Initialization" begins at 20130528182610

>> 2013/05/28 18:26:10  START OF PHASE PREP_INIT/DBCHK_INI

Running D:\usr\sap\DSB\DVEBMGS00\exe\tp pf=D:\usr\sap\DSB\SUM\abap\var\DEFAULT.TPP getdbinfo DSB

=========== Repeat Phase ===========

Severe error(s) occured in phase PREP_INIT/DBCHK_INI!

Last error code set: Cannot open 'D:\usr\sap\DSB\SUM\abap\tmp\NLSLANG.DAT':

The system cannot find the file specified. <br/>

A trouble ticket and an archive with all relevant log files have been

generated.

Trouble ticket: "D:\usr\sap\DSB\SUM\abap\log\SAPup_troubleticket.log"

Log archive: "D:\usr\sap\DSB\SUM\abap\log\SAPup_troubleticket_logs.sar"

You can start the module from the start by choosing "Back".

01)  *  Repeat phase PREP_INIT/DBCHK_INI to continue at the point it stopped

02)  -  Exit program

: Repeat phase PREP_INIT/DBCHK_INI to continue at the point it stopped

>> 2013/05/28 18:26:15  START OF PHASE PREP_INIT/DBCHK_INI

Running D:\usr\sap\DSB\DVEBMGS00\exe\tp pf=D:\usr\sap\DSB\SUM\abap\var\DEFAULT.TPP getdbinfo DSB

Regards,

Alejandro.

[karthikeyan_natarajan4 · Accepted solution]

Hi Alejandro,

Just want to make sure, where you extracted the SUM? is it in the trans directory and also tell us where the data files and oracle db is installed.

regards

karthik

[Former Member · Accepted solution]

Hello Karthik thanks for your help,

i extrac the sum in the path: D:\usr\sap\DSB\SUM thats where the guie tell me, do you want me to extract the sum in the trans directory and run the upgrade there?

the oracle db is in the path:

E:\oracle\DSB

and the data files are in:

H:\oracle\DSB

Any idea?

Regards,

Alejandro.

[Reagan · Accepted solution]

Hello

Check whether you have the NLS_LANG set as an environment variable.

Regards

RB

[Reagan · Accepted solution]

Hello

The problem is still with the even after you have modified the registry entry.

That confirms that the system is still reading the old values.

Can you provide the NLS parameters set for this user please ?

Also can you tell me the version of the Oracle instant client you are using ?

Regards

RB

[Former Member · Accepted solution]

Hello RB thanks for your help,

the parameter for the \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE was se to SPANISH_VENEZUELA.WE8MSWIN1252 and the parameters NLS for the user was AMERICAN_AMERICA.UTF8.

so i change the \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE to AMERICAN_AMERICA.UTF8  and set the user and system variables to AMERICAN_AMERICA.UTF8.

i stop the upgade restart the server and continue the uprade but i still have the error.

we are using oracle 11g

any idea?

Regards,

[Reagan · Accepted solution]

Hello

Did you set the environment variable or did you unset it ?

If you see this link it suggests to unset it if the environment variable is NLS_LANG

http://www.dba-oracle.com/t_ora_12705_resolution.htm

Secondly can you list all the environment variables set for the sidadm user ?

Also provide the Oracle Instant Client version (not the Oracle version)

Check this SAP Note for more details

Note 998004 - Update the Oracle Instant Client on Windows

You need to first check the dbclient.lst file present in the kernel directory. This file will list all the files that are part of the Oracle Instant Client which will be present in the Kernel directory.

You can find the version of these files by checking the Properties - Version

Regards

RB

[Former Member · Accepted solution]

Hello,

the environment variables for this user where set right and the error was solved.

Regards,

Alejandro

[AtulKumarJain]

Hi Palazon,

Please check below thread

http://scn.sap.com/thread/3354930

http://scn.sap.com/thread/3247934

Have you entered the DB user password correctly ?

please check ORA*.LOG

Please open a message to sap as well.

Best Regards,

Atul

[karthikeyan_natarajan4]

Hi Alejandro,

Try this,

The NLS_LANG must be unset in the Windows registry (re-named is best).  Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.

before changing anything make sure you backed up the windows registry.

regards

karthik 

[Former Member]

Hi Karthik/Alejandro

As per sap note Note 606359 - FAQ: Oracle National Language Support (NLS).

Step 23.

From where does the NLS_LANG value come in the Registry under Oracle (WINDOWS)?

              As part of the Oracle installation or upgrade, NLS_LANG in the Registry under

HKEY_LOCAL_MACHINE -> Software -> Oracle -> Home

              is set to a value that matches the settings (language, code page) of the WINDOWS server (for example, GERMAN_GERMANY.WE8MSWIN1252 or AMERICAN_AMERICA.WE8ISO8859P1). Since this value is overwritten in the environment by the required NLS_LANG entry, it is ineffective and therefore not critical. For a better overview, however, it should be adjusted to the correct NLS_LANG value as it appears in the environment.

According to the note it should match the environment settings.

So if it not set in the environment settings then it should be removed.

Johan

[Former Member]

hello johan

thanks for your help,

i set the variable of the NLS_LANG on

\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE to AMERICAN_AMERICA.WE8ISO8859P1 there and in the env varibales.

and the issue sitll persist.

any other idea??

Regards,