cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to install Dailog Java instance for EP.

Former Member
0 Kudos

Hi SAP Basis Gurus,

We are unable to installed Java Dailog instance for EP

error message:MDB-05800 <html>Unable to determine the port number for MSSQL version

Platform used:

OS: Win 2003 64-Bit

DB: MS SQL Server 2005

EP Version: EP 6.0 ( SAP Netweaver 2004)

We followed Below steps for Installation:

SQL Server installation on host SQLV605V: DVD used "51036539"

1. We installed SQL server 2005 using SQL4sap.vbs script.

2. Selected SID NPP for Named instance.

3. Prompt "SAP recommends that you install default instance. Do you

want to install deafult instance ? Selected "NO".

4. Installation finished successfully.

5. rebooted server.

6. Set Authentication mode "Mixed".

7. Enable sa user.

Central Instance Installation on host SQLV605V using System Copy: DVD

Used "51033746_15"

1. Selected SAP Netweaver 04 SR1 >System Copy>Target System-->

Java System >MS SQL Server>Migration Target System Installation.

2. Prompt for JAVA DVD. DVD USed "51031849_2"

and Migration Export path.

3. Prompt For SAPSID: "NPP"

and installation drive: E.

4. Prompt for JDK directory: c:\j2sdk1.4.2_28-x64\

5. Propmt for Java Crptographic tool kit: Selected Strong.

and Path for JCE policy.

6. SAP Domain Selection: Selected "Installation of domain of current

user".

7. Prompt for OS Password: BDN\nppadm & BDN\SAPServiceNPP

8. Propmt for SCS Instance Parameter:

SCS Instance Number 01 and

SAP Message service port( Leave empty for Default)= "Left EMPTY"

9. J2EE Engine Parameter:

Central Instance Number: 00

Number of servers: 1

Max Heap Size(MB):1024

10. Propmt for SDM user password and

Administrator user password.

11.Propmt for database Schema SAPNPPDB password:

12.Prompt for Java DVD: 51031849_3 & 51031849_1

13.Prompt for MS SQL Server Instance Name: Database Instance

name:SQLV605V\NPP

14.New Database will be created with same name as SAPSID.

15.Path for Database files: Data and Log

Dailog instance installation on host:SAPV606A: DVD Used "51033746_15"

we first installed SNAC from DVD and then

1.Selected SAP Netweaver 04 SR1 >SAP System Installation>

Java System>MS SQL Server>Central/Distributed System-->Dailog

Instance Installation.

2.Propmt for SAP System parameter:

SAPSID: NPP

SCS HOSTNAME:SQLV605V

3.Prompt for JDK path: c:\j2sdk1.4.2_28-x64\

4.SAP System User Domain:

Selected "Installation of domain of current user".

5.Propmt for OS User:

BDN\nppadm and BDN\SAPServiceNPP

6.Prompt for J2EE Engine Parameters:

Installation Drive: E

Instance Number: 00

Number of servers:1

MAx Heap Size (MB):1024

7.Prompt for Java DVD:51031849_3 & 51031849_1

after we receive error:

ERROR 2010-11-26 06:44:23 [iaxxinscbk.cpp:289]

abortInstallation

MDB-05800 <html>Unable to determine the port number for MSSQL version

NaN</html>

Our CI is working fine but unable to installa JAava dialog instance.

We have checked SAP Note: 639702 JDBC Driver for Microsoft SQL Server

and download latest JDBC driver files i.e jar files in j2ee/jdbc directory

E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa

<password>

-


Server : sqlv605v:3404

User : sa

Password : <password>

-


No Microsoft JDBC Driver found.

com.microsoft.sqlserver.jdbc.SQLServerDriver

-


Found DataDirect Driver.

Driver version is : 3.50.20 (016225.009408.011318)

JDBC version: 3.0

Then we tried downloading newer version and excuted below query

again:

E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa

<password>

-


Server : sqlv605v:3404

User : sa

Password : <password>

-


No Microsoft JDBC Driver found.

com.microsoft.sqlserver.jdbc.SQLServerDriver

-


Found DataDirect Driver.

Driver version is : 3.70.11 (029613.012904.017408)

JDBC version: 3.0

But still no success!!!

Details of jdbc & java url path in secure store:

jdbc/pool/NPP/ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

jdbc/pool/NPP/Url=jdbc:nwmss:sqlserver://SQLV605V:3404;databasename=NPP

Aslo the port Number is 3404 in regedit:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\NPP\MSSQLServer\SuperSoctNetLib\Tcp = 3404

We also modify the control.xml file in Master dvd in the else part in the

function. this.getPortNumber from 5912 to 3404 but still it gives same error:

trace of sapinst_dev.log:

-


Opened iamodmssql.dll

ERROR 2010-11-26 05:42:16 [iaxxinscbk.cpp:289]

abortInstallation

MDB-05800 <html>Unable to determine the port number for MSSQL version NaN</html>

TRACE [iaxxejsbas.hpp:270]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined

WARNING 2010-11-26 05:42:16

lib=iamodmssql module=CIaNtMssDmo

Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

<br>Call your SAP Support.<br><br>

WARNING 2010-11-26 05:42:16 [iaxxccntrl.cpp:477]

CController::stepExecuted()

The step dConfigureDriver with step key J2EE_EngineEnterprise_DI|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|INSERT_JDBC_DRIVER_INTO_CONTEXT_TABLES|ind|ind|ind|ind|ind|0|MSS_JDBC_DRIVER|ind|ind|ind|ind|ind|0|dConfigureDriver was executed with status ERROR.

-


Please let me know how do we resolve this issue.

Regards,

Prashant Mistry

Edited by: Prashant MIstry on Dec 6, 2010 9:50 AM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

in addition to above:

Our CI is working fine but unable to installa JAava dialog instance.

We have checked SAP Note: 639702 JDBC Driver for Microsoft SQL Server

and download latest JDBC driver files i.e jar files in j2ee/jdbc directory

E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa

<password>

-


Server : sqlv605v:3404

User : sa

Password : <password>

-


No Microsoft JDBC Driver found.

com.microsoft.sqlserver.jdbc.SQLServerDriver

-


Found DataDirect Driver.

Driver version is : 3.50.20 (016225.009408.011318)

JDBC version: 3.0

Then we tried downloading newer version and excuted below query

again:

E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa

<password>

-


Server : sqlv605v:3404

User : sa

Password : <password>

-


No Microsoft JDBC Driver found.

com.microsoft.sqlserver.jdbc.SQLServerDriver

-


Found DataDirect Driver.

Driver version is : 3.70.11 (029613.012904.017408)

JDBC version: 3.0

But still no success!!!

Details of jdbc & java url path in secure store:

jdbc/pool/NPP/ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

jdbc/pool/NPP/Url=jdbc:nwmss:sqlserver://SQLV605V:3404;databasename=NPP

Aslo the port Number is 3404 in regedit:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\NPP\MSSQLServer\SuperSoctNetLib\Tcp = 3404

We also modify the control.xml file in Master dvd in the else part in the

function. this.getPortNumber from 5912 to 3404 but still it gives same error:

trace of sapinst_dev.log:

-


Opened iamodmssql.dll

ERROR 2010-11-26 05:42:16 [iaxxinscbk.cpp:289]

abortInstallation

MDB-05800 <html>Unable to determine the port number for MSSQL version NaN</html>

TRACE [iaxxejsbas.hpp:270]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined

WARNING 2010-11-26 05:42:16

lib=iamodmssql module=CIaNtMssDmo

Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

<br>Call your SAP Support.<br><br>

WARNING 2010-11-26 05:42:16 [iaxxccntrl.cpp:477]

CController::stepExecuted()

The step dConfigureDriver with step key J2EE_EngineEnterprise_DI|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|INSERT_JDBC_DRIVER_INTO_CONTEXT_TABLES|ind|ind|ind|ind|ind|0|MSS_JDBC_DRIVER|ind|ind|ind|ind|ind|0|dConfigureDriver was executed with status ERROR.

-


Please let me know how do we resolve this issue.

Regards,

Prashant Mistry

Former Member
0 Kudos

In addition to above details:

Our CI is working fine but unable to installa JAava dialog instance.

We have checked SAP Note: 639702 JDBC Driver for Microsoft SQL Server

and download latest JDBC driver files i.e jar files in j2ee/jdbc directory

E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa

<password>

-


Server : sqlv605v:3404

User : sa

Password : <password>

-


No Microsoft JDBC Driver found.

com.microsoft.sqlserver.jdbc.SQLServerDriver

-


Found DataDirect Driver.

Driver version is : 3.50.20 (016225.009408.011318)

JDBC version: 3.0

Then we tried downloading newer version and excuted below query

again:

E:\usr\sap\NPP\JC00\j2ee\jdbc>SAPCheckVersion.cmd sqlv605v:3404 sa

<password>

-


Server : sqlv605v:3404

User : sa

Password : <password>

-


No Microsoft JDBC Driver found.

com.microsoft.sqlserver.jdbc.SQLServerDriver

-


Found DataDirect Driver.

Driver version is : 3.70.11 (029613.012904.017408)

JDBC version: 3.0

But still no success!!!

Details of jdbc & java url path in secure store:

jdbc/pool/NPP/ClassName=com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

jdbc/pool/NPP/Url=jdbc:nwmss:sqlserver://SQLV605V:3404;databasename=NPP

Aslo the port Number is 3404 in regedit:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\NPP\MSSQLServer\SuperSoctNetLib\Tcp = 3404

We also modify the control.xml file in Master dvd in the else part in the

function. this.getPortNumber from 5912 to 3404 but still it gives same error:

trace of sapinst_dev.log:

-


Opened iamodmssql.dll

ERROR 2010-11-26 05:42:16 [iaxxinscbk.cpp:289]

abortInstallation

MDB-05800 <html>Unable to determine the port number for MSSQL version NaN</html>

TRACE [iaxxejsbas.hpp:270]

EJS_Base::dispatchFunctionCall()

JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined

WARNING 2010-11-26 05:42:16

lib=iamodmssql module=CIaNtMssDmo

Cannot connect to the database server. Errors returned: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

<br>Call your SAP Support.<br><br>

WARNING 2010-11-26 05:42:16 [iaxxccntrl.cpp:477]

CController::stepExecuted()

The step dConfigureDriver with step key J2EE_EngineEnterprise_DI|ind|ind|ind|WebAS|630|0|J2EE_EngineEnterpriseDialogs|ind|ind|ind|WebAS|630|0|J2EE_Engine|ind|ind|ind|J2EE_Engine|630|0|INSERT_JDBC_DRIVER_INTO_CONTEXT_TABLES|ind|ind|ind|ind|ind|0|MSS_JDBC_DRIVER|ind|ind|ind|ind|ind|0|dConfigureDriver was executed with status ERROR.

-


Please let me know how do we resolve this issue.

Regards,

Prashant Mistry