Getting error while updating the Identity Center Database

[Former Member]

Hi,

I have just Installed SAP IDM 7.2 SP 0 and trying to update it to SP10.

After running mxmc-xupdate.cmd (My Identity Center database name is other than mxmc) by passing all the parameters correctly, I am getting below error.

'CSCRIPT' is not recognized as an internal or external command,

operable program or batch file.

*****************************************************

Updating <prefix>_db on <host>

*****************************************************

Updating schema

Creating language generation procedures

Creating functions

Creating views

Creating procedures (this may take a few minutes)

Creating triggers

Updating existing data (this may take a few minutes)

Creating old 7.1 views if 71_COMPATIBILITY is TRUE

Sqlcmd: 'TEMP\9-enable-71-compatibility.sql': Invalid filename.

Adding new views if MX_NEW_APPROVALS is TRUE

Sqlcmd: 'TEMP\9-new-approval-views.sql': Invalid filename.

Adding repository type templates

Sqlcmd: 'TEMP\9-RepType-Templates.sql': Invalid filename.

Adding schedule procedures for new housekeeping mechanism

Sqlcmd: 'TEMP\9-SchedProc-Defs.sql': Invalid filename.

-----------------------------------------------------------------------------

Updating schema

Cannot open input file - TEMP\4-update-schema.sql

No such file or directory

Cannot open input file - TEMP\9-language-data.sql

No such file or directory

Cannot open input file - TEMP\5A-create-functions.sql

No such file or directory

Cannot open input file - TEMP\5B-create-views.sql

No such file or directory

Cannot open input file - TEMP\5D-create-procs.sql

No such file or directory

Cannot open input file - TEMP\5F-create-triggers.sql

No such file or directory

Cannot open input file - TEMP\8-update-data.sql

No such file or directory

-----------------------------------------------------------------------------

Result saved in <prefix>_logfile.log

Can any one suggest the probable reason of this error and fix.

My Environment Variable CLASSPATH is already pointing to sqljdbc4 and PATH is pointing to osql and sqlcmd (as osql and sqlcmd) are in same folder.

Do I need to add cscript.exe directory path also to environment variable?

To update database I logged-in to server by user having Domain admin authorization. 

Looking forward for your suggestions and solution.

Regards,

Chandan

Message was edited by: Chandan Kumar

[former_member222441 · Accepted solution]

Hi Chandan,

try thisin your cmd.exe:

%SystemRoot%\System32\cscript.exe

If it is working, check your PATH environment variable.

Kindly,

Andreas

[Former Member · Accepted solution]

Hi Andreas,

I have followed your suggestion but it didn't change anything in PATH variable.

I need fix for both error.

• 'CSCRIPT' is not recognized as an internal or external command,

          operable program or batch file.

• Sqlcmd: 'TEMP\9-enable-71-compatibility.sql': Invalid filename.

Sqlcmd: 'TEMP\9-enable-71-compatibility.sql': Invalid filename.

Adding new views if MX_NEW_APPROVALS is TRUE

Sqlcmd: 'TEMP\9-new-approval-views.sql': Invalid filename.

Adding repository type templates

Sqlcmd: 'TEMP\9-RepType-Templates.sql': Invalid filename.

Adding schedule procedures for new housekeeping mechanism

Sqlcmd: 'TEMP\9-SchedProc-Defs.sql': Invalid filename.

-----------------------------------------------------------------------------

Updating schema

Cannot open input file - TEMP\4-update-schema.sql

No such file or directory

Cannot open input file - TEMP\9-language-data.sql

No such file or directory

Cannot open input file - TEMP\5A-create-functions.sql

No such file or directory

Cannot open input file - TEMP\5B-create-views.sql

No such file or directory

Cannot open input file - TEMP\5D-create-procs.sql

No such file or directory

Cannot open input file - TEMP\5F-create-triggers.sql

No such file or directory

Cannot open input file - TEMP\8-update-data.sql

No such file or directory

-----------------------------------------------------------------------------

Regards,

Chandan

[former_member222441 · Accepted solution]

Don't worry about the second error. These files are created by the first step, which fails in your case.

What OS version are you running?

Can you check, if the file exists: c:\windows\System32\cscript.exe

If not, then it seems you don't have Windows Script Host (completely) installed. Windows Script Host is part of Internet Explorer.

Kindly,

Andreas

[Former Member · Accepted solution]

Thanks for reply Andreas!

I am using Windows server 2008 R2.

Yes I checked and file cscript.exe exist in c:\windows\System32 folder

Please suggest the fix.

Regards,

Chandan

[jaisuryan · Accepted solution]

Hi Chandan,

Add the below value to PATH system variable (environment variables)

%SystemRoot%\system32

Let me know if it worked

Kind regards,

Jai

[Former Member · Accepted solution]

Thanks Jaisuryan!

Actually I have added hard code value of directory path of cscript.exe file to PATH hence it was not working.

Now I have manually added %SystemRoot%\system32 to PATH variable along with the Directory Path of osql, ssqlcmd (separated by semicolon) and it worked perfectly

Regards,

Chandan