Unable to Install PI7 7.10 Dialogue Instance

[Former Member]

I have upgraded the Central Instance (Primary Server) of a SAP PI 7.0 system to 7.1 SPS8 but am having problems with the Dialogue Instance in the same High Availability cluster.

As per the installation guide, I have uninstalled the ERS (11) and the DI (02) on the DI server. I then succesfully installed a new ERS (11), but am unable to install a new DI.

When I install the DI, it gets to the phase 'Install instance basics' and stops with the error 'Can not get DB connection. Batchconfig will only be able to execute offline tasks.'

This installation processes also causes the Java instance on the CI node to fail. I believe this is because the installation process onthe DI node extracts some files to the shared cluster area. I have been able to get the Java instance on the CI node to work again by copying the kernel from our QA system to the production system and re-starting the production system.

I have tried:

- Retry

- Stopping the installation, restarting the server and resuming the installation

- Stopping the installation, restarting the server, unsinstalling the DI node and re-installing the DI node

but I get the same result every time.

These OSS notes do not highlight any issues:

98678 - SQL Server Connection Issues

128126 - Database Connect for external tools

1294762 - Schema repair script (SCHEMA4SAP.VBS)

Please can you suggest why the DI node fails at the phase 'Install instance basics' and how I can resolve this?

[Former Member]

Friends

I've got the same problem installin NW 7.01 PI Usage in a MSCS 2008 with DB2.

I solve it with an workaround, since we cannot find any OSS Notes:

We moved the SAP Group and the DB2 Group to the same Cluster node and the DI installation at node B finished succefully.

After this we checked the share poing /sapmnt: In both servers the user <sid>adm has no administrative rights; we fixed it and the installation finish.

Best Regards

Ricardo.

[Former Member]

Sorry for the long post.<br />

<br />

Niraj - Here is an extract of the log file. The error is on the last line of this.<br />

<br />

Mark - The SAPLOCALHOST variable is not set in the DEFAULT.PFL<br />

<br />

<br />

<br />

<br />

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'Path', const iastring & 'C:\j2sdk1.4.2_17-x64\bin;C:\Program Files\HP\NCU;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\sysWOW64;c:\Program Files\System Center Operations Manager 2007\;C:\Program Files\Hewlett-Packard\Cluster Extension XP\bin;C:\HORCM\etc;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\OmniBack\bin\;C:\Program Files (x86)\Windows Imaging\') 
Environment variable Path set to value 'C:\j2sdk1.4.2_17-x64\bin;C:\Program Files\HP\NCU;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\sysWOW64;c:\Program Files\System Center Operations Manager 2007\;C:\Program Files\Hewlett-Packard\Cluster Extension XP\bin;C:\HORCM\etc;C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\OmniBack\bin\;C:\Program Files (x86)\Windows Imaging\'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'PATHEXT', const iastring & '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH') 
Environment variable PATHEXT set to value '.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'PROCESSOR_ARCHITECTURE', const iastring & 'AMD64') 
Environment variable PROCESSOR_ARCHITECTURE set to value 'AMD64'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'PROCESSOR_IDENTIFIER', const iastring & 'EM64T Family 6 Model 23 Stepping 6, GenuineIntel') 
Environment variable PROCESSOR_IDENTIFIER set to value 'EM64T Family 6 Model 23 Stepping 6, GenuineIntel'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'PROCESSOR_LEVEL', const iastring & '6') 
Environment variable PROCESSOR_LEVEL set to value '6'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'PROCESSOR_REVISION', const iastring & '1706') 
Environment variable PROCESSOR_REVISION set to value '1706'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'ProgramFiles', const iastring & 'C:\Program Files') 
Environment variable ProgramFiles set to value 'C:\Program Files'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'ProgramFiles(x86)', const iastring & 'C:\Program Files (x86)') 
Environment variable ProgramFiles(x86) set to value 'C:\Program Files (x86)'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SAPEXE', const iastring & '\\ClusterSAPServer\sapmnt\SID\SYS\exe\uc\NTAMD64') 
Environment variable SAPEXE set to value '\\ClusterSAPServer\sapmnt\SID\SYS\exe\uc\NTAMD64'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SAPINST_EXEDIR_CD', const iastring & 'C:/SAP_Software/SAP NetWeaver 7/BS_2005_SR3_SAP_Installation_Master/IM_WINDOWS_X86_64') 
Environment variable SAPINST_EXEDIR_CD set to value 'C:/SAP_Software/SAP NetWeaver 7/BS_2005_SR3_SAP_Installation_Master/IM_WINDOWS_X86_64'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SAPLOCALHOST', const iastring & 'DISAPServer') 
Environment variable SAPLOCALHOST set to value 'DISAPServer'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SAPSYSTEMNAME', const iastring & 'SID') 
Environment variable SAPSYSTEMNAME set to value 'SID'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SESSIONNAME', const iastring & 'RDP-Tcp#1') 
Environment variable SESSIONNAME set to value 'RDP-Tcp#1'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SHLIBPATH', const iastring & '\\ClusterSAPServer\SAPMNT\SID\SYS\exe\uc\NTAMD64') 
Environment variable SHLIBPATH set to value '\\ClusterSAPServer\SAPMNT\SID\SYS\exe\uc\NTAMD64'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SNC_LIB', const iastring & 'T:\usr\sap\SID\ASCS00\exe') 
Environment variable SNC_LIB set to value 'T:\usr\sap\SID\ASCS00\exe'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SystemDrive', const iastring & 'C:') 
Environment variable SystemDrive set to value 'C:'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'SystemRoot', const iastring & 'C:\WINDOWS') 
Environment variable SystemRoot set to value 'C:\WINDOWS'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'TEMP', const iastring & 'C:\DOCUME~1\myUser\LOCALS~1\Temp\1') 
Environment variable TEMP set to value 'C:\DOCUME~1\myUser\LOCALS~1\Temp\1'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'TMP', const iastring & 'C:\DOCUME~1\myUser\LOCALS~1\Temp\1') 
Environment variable TMP set to value 'C:\DOCUME~1\myUser\LOCALS~1\Temp\1'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'UATDATA', const iastring & 'C:\WINDOWS\SysWOW64\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77') 
Environment variable UATDATA set to value 'C:\WINDOWS\SysWOW64\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'USERDNSDOMAIN', const iastring & 'UK.DELOITTE.COM') 
Environment variable USERDNSDOMAIN set to value 'UK.DELOITTE.COM'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'USERDOMAIN', const iastring & 'UK') 
Environment variable USERDOMAIN set to value 'UK'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'USERNAME', const iastring & 'myUser') 
Environment variable USERNAME set to value 'myUser'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'USERPROFILE', const iastring & 'C:\Documents and Settings\myUser') 
Environment variable USERPROFILE set to value 'C:\Documents and Settings\myUser'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'VSEDEFLOGDIR', const iastring & 'C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection') 
Environment variable VSEDEFLOGDIR set to value 'C:\Documents and Settings\All Users\Application Data\McAfee\DesktopProtection'.

TRACE      2010-04-12 17:26:30.850 [syxxccuren.cpp:31]
           CSyCurrentProcessEnvironmentImpl::setEnvironmentVariable(const iastring & 'windir', const iastring & 'C:\WINDOWS') 
Environment variable windir set to value 'C:\WINDOWS'.

INFO       2010-04-12 17:26:30.850 
           CJSlibModule::writeInfo_impl() 
Output of C:\j2sdk1.4.2_17-x64\bin\java.exe -classpath "C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/sharedlib/launcher.jar" -Xmx256m com.sap.engine.offline.OfflineToolStart com.sap.engine.configtool.batch.BatchConfig "\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_jce.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_jsse.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_smime.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_ssl.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/w3c_http.jar;C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/lib;C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/sharedlib;C:\usr\sap\SID\D02\exe\mssjdbc\sqljdbc.jar" "C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/BatchConfig.xml" is written to the logfile batchconfig.log.

WARNING    2010-04-12 17:26:32.616 
           CJSlibModule::writeWarning_impl() 
Execution of the command "C:\j2sdk1.4.2_17-x64\bin\java.exe -classpath "C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/sharedlib/launcher.jar" -Xmx256m com.sap.engine.offline.OfflineToolStart com.sap.engine.configtool.batch.BatchConfig "\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_jce.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_jsse.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_smime.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/iaik_ssl.jar;\\ClusterSAPServer/sapmnt/SID/SYS/global/security/lib/tools/w3c_http.jar;C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/lib;C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/sharedlib;C:\usr\sap\SID\D02\exe\mssjdbc\sqljdbc.jar" "C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/BatchConfig.xml"" finished with return code 31415. Output: 
Can not get DB connection. Batchconfig will only be able to execute offline tasks.

TRACE      2010-04-12 17:26:32.616 
NWException thrown: nw.configError:
Java EE Engine configuration error. DIAGNOSIS: See output of logfile batchconfig.log: '
Can not get DB connection. Batchconfig will only be able to execute offline tasks. '.

[Former Member]

Hi Paul,

Can you post batchconfig.log as well?

Kind regards,

Mark Dijsselbloem

[Former Member]

Hi Mark,

The batchconfig.log just says:

Can not get DB connection. Batchconfig will only be able to execute offline tasks.

So it indicates a DB connection issue, however:

- The DB is up and running

- The CI can connect to it (and I can log onto the ABAP stack via the SAP GUI, so I know the CI is up and running okay)

- I can connect to it from the Config tool (which is hosted on the CI and uses the JDBC drivers)

- The DI server had connected to the DB and was using it okay before I uninstalled the DI (as per the upgrade instructions). So there are no issues between the server that the DI is on and the database. There are no firewalls, etc.

- I have moved the DB cluster node to the same server node that the DI server is on and I get the same result

Edited by: Paul Richardson on Apr 13, 2010 12:12 PM

[Former Member]

Is the C:\usr\sap\SID\D02\exe\mssjdbc\sqljdbc.jar the same jdbc driver that is being used for the central instance?

On other thing you could do, is continue the installation with option SAPINST_SKIP_ERRORSTEP=true and fix this problem manually after the installation.

Kind regards,

Mark Dijsselbloem

[Former Member]

Paul,

I am facing absolutly the same problem. Have you found the solution?

regargs, Mikhail

[Former Member]

Hi Mikhail,

I have had a high priority message open with SAP for weeks about this but it is still not resolved.

I tried continuing the installation with option SAPINST_SKIP_ERRORSTEP=true and the rest of the installation finished okay, however the Server0 instance on the DI server would fail when starting up.

We could not resolve this issue, so SAP agreed that I should remove and then re-install the DI instance. I did that yesterday, then got to the same point in the installation as I mentioned at the start of this topic.

All of the files used in the installation process look okay, as does the configuration. The DB is up and running and the ABAP stack works fine with it - it is only the JAVA stack that cannot connect to it.

Let me know if you have any ideas or find the solution! I will also post here if I find anything

[Former Member]

I've had a similar problem once... That was caused by the SAPLOCALHOST that was set in the DEFAULT.PFL and was pointing to the central instance.

Kind regards,

Mark Dijsselbloem

[Former Member]

Please check install log for error details other than "Can not get DB connection". Is this a dual stack DI? Is it homogeneous landscape (same OS as it's in CI)? Also please check what the difference is in /usr/sap/<SID>/SYS/exe/run after upgrade, any new directory created, the latest 710 kernel?

Regards,

[Former Member]

> Please check install log for error details other than "Can not get DB connection".

The errors are:

WARNING 2010-04-12 14:25:08.398

Execution of the command "C:\j2sdk1.4.2_17-x64\bin\java.exe -classpath "C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/sharedlib/launcher.jar" -Xmx256m com.sap.engine.offline.OfflineToolStart com.sap.engine.configtool.batch.BatchConfig "
mscs_sapserver/sapmnt/SID/SYS/global/security/lib/tools/iaik_jce.jar;
mscs_sapserver/sapmnt/SID/SYS/global/security/lib/tools/iaik_jsse.jar;
mscs_sapserver/sapmnt/SID/SYS/global/security/lib/tools/iaik_smime.jar;
mscs_sapserver/sapmnt/SID/SYS/global/security/lib/tools/iaik_ssl.jar;
mscs_sapserver/sapmnt/SID/SYS/global/security/lib/tools/w3c_http.jar;C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/lib;C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/install/sharedlib;C:\usr\sap\SID\D02\exe\mssjdbc\sqljdbc.jar" "C:/Program Files/sapinst_instdir/NW04S/SYSTEM/MSS/HA/ABAPJAVA/DI/BatchConfig.xml"" finished with return code 31415. Output:

Can not get DB connection. Batchconfig will only be able to execute offline tasks.

WARNING[E] 2010-04-12 14:25:08.398

CJS-30059 Java EE Engine configuration error. DIAGNOSIS: See output of logfile batchconfig.log: '

Can not get DB connection. Batchconfig will only be able to execute offline tasks. '.

ERROR 2010-04-12 14:25:09.226

FCO-00011 The step runBatchconfig with step key |NW_DI|ind|ind|ind|ind|0|0|NW_DI_Instance|ind|ind|ind|ind|10|0|runBatchconfig was executed with status ERROR .

So in summary, the errors clearly point to a DB connection issue, but the DB is up (the CI is able to connect to it and run okay).

> Is this a dual stack DI?

Yes.

> Is it homogeneous landscape (same OS as it's in CI)?

Yes. The whole landscape is running on Windows Server 2003 and MS SQL Server 2005.

> Also please check what the difference is in /usr/sap/<SID>/SYS/exe/run after upgrade, any new directory created,

The \exe folder on the DI server looks okay.

Thanks.

[Former Member]

Please compare the kernel files carefully between CI and DI kernel directories, including JDBC driver and Java security credential files.

It looks like JDBC driver is missing, to confirm check Java start log in DI work directory /usr/sap/<SID>/Dnn/work/dev_jcontrol.

[Former Member]

The dev_jcontrol file says:

[Thr 7732] *** WARNING => Can't open property file [C:\usr\sap\PI7\D02\j2ee\cluster\instance.properties] [jstartxx.c 2079]

and I can see that the C:\usr\sap\PI7\D02\j2ee\cluster\ directory is missing. I tried copying the files from the CI to this directory (on the DI) and resuming the installation, but that did not resolve the issue - or update the dev_jcontrol file.

I assume that this file does not exist because it hasn't yet reached the part of the installation that writes it.

All of the .JAR files that I listed in my previous post (including C:\usr\sap\SID\D02\exe\mssjdbc\sqljdbc.jar) do exist.

I have also tried copying the \exe directory from the DI of my QA system to this one (production) and resumed the upgrade, but I get the same error.

Thanks.

[former_member126060]

Hello Paul,

Can you check sapinst_dev.log and check the traces above the error code. this will give you the exact reason why the problem is coming.

if possible paste the content of the sapinst_dev.log. May be 2-3 pages above the error code.

Best Regards

Niraj