01-06-2017 1:07 PM - edited 01-21-2024 9:54 PM
Hi,
We are installing a SMP 3.0 SP11 on one of our servers Win 2008 R2. The SMP 3.0 server is a single node installed in Development mode. SAP SQL Anywhere Server service is running on port 2639. However after installation of SMP 3.0 the server is not starting up. The error being reported in the log files is "
Failed to verify database status on startup:java.sql.SQLException: JZ006: Caught
IOException: java.net.ConnectException: Connection refused: connect"
I tried to start the server using go.bat as well as "go.bat -clean" but still the server is not starting up. The output of go.bat file is given below.
Can somebody please try to help in figuring out why SMP 3.0 SP11 is not starting up?
F:\><SMP_HOME>\Server\go.bat
Using SMP_BASE: "<SMP_HOME>\Server"
Using SMP_HOME: "<SMP_HOME>\Server"
Using JAVA_HOME: "<SMP_HOME>\sapjvm_8"
First FIND
SECOND FIND
GOING TO CALL DBPING
SQL Anywhere Server Ping Utility Version 17.0.4.2053
Connected to SQL Anywhere 17.0.4.2053 server "smp3" and database "smp3".
Ping database successful.
java version "1.8.0_45"
Java(TM) SE Runtime Environment (build 8.1.008)
SAP Java Server VM (build 8.1.008 25.45-b12, Jun 17 2015 18:07:44 - 81_REL - opt
U - windows amd64 - 6 - bas2:242406 (mixed mode))
<SMP_HOME>\Server>"<SMP_HOME>\sapjvm_8\bin\java.exe" -server -XtraceFile=log/vm_@PID_trace.log "-Dcom.sap.mobile.platform.server.home=<SMP_HOME>\Server" "-XX:+HeapDumpOnOutOfMemoryError" "-XX:+DisableExplicitGC" "-Xms1024m" "-Xmx2048m" "-XX:PermSize=256M" "-XX:MaxPermSize=512M" "-XX:ErrorFile=./log/error.log" "-XX:HeapDumpPath=./log/heap_dump.hprof" "-Djava.io.tmpdir=./work/tmp" "-Djava.endorsed.dirs=lib/endorsed" "-Dosgi.logfile=./log/osgi.log" "-DsecretKey=HLEeb3PBN3" "-DsecretKeylength=128" "-Dfile.encoding=UTF-8" -classpath "<SMP_HOME>\Server\lib\*;<SMP_HOME>\Server\plugins\org.eclipse.equinox.launcher_1.3.0.v20120308-1358.jar;<SMP_HOME>\Server\plugins\com.sap.db.jdbc_1.0.49.373159.jar;<SMP_HOME>\Server\plugins\org.apache.servicemix.bundles.derby_10.8.2.2_1.jar;<SMP_HOME>\Server\plugins\org.apache.commons.codec_1.10.0.jar;<SMP_HOME>\Server\plugins\com.springsource.org.apache.commons.lang_2.5.0.jar" org.eclipse.equinox.launcher.Main -console localhost:2401
SMP Server version is 3.0.11.0
Checking DB...
Failed to verify database status on startup:java.sql.SQLException: JZ006: Caught
IOException: java.net.ConnectException: Connection refused: connect
___________________________
Have a nice day
Amardeep
I have the resolution to this incident. It was given in the OSS Note 2095952 (https://launchpad.support.sap.com/#/notes/2095952/E).
_________________________
Have a nice day
Amardeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Andreas,
Sorry for the delayed response. I did both of the items that you have outlined, namely
1) I changed in the Properties file, the Minimum Memory to 2048MB and Maximum to 8192 MB.
2) I am able to connect to the SQL Anywhere database using DBISQL.EXE with the details given by you. the connection log is given below
Connection succeeded.
Thu Jan 19 2017 18:24:01 18:24:01 Attempting to connect using: UID=gomobile;PWD=********;DBN=smp3;ServerName=smp3;CON=SQL_DBC_1c74fc90;LOG=%USER_HOME%\AppData\Local\Temp\4\testcon5480034439911771505.tmp;ASTART=NO
18:24:01 Attempting to connect to a running server...
18:24:01 Trying to start SharedMemory link ...
18:24:01 SharedMemory link started successfully
18:24:01 Attempting SharedMemory connection (no sasrv.ini cached address)
18:24:01 Connected to server over SharedMemory
18:24:01 Connected to SQL Anywhere Server version 17.0.4.2066
18:24:01 Application information:
18:24:01 IP=10.XXX.XXX.XXX;HOST=YYYYYYYYY;OSUSER=XXXXXXXX;OS='Windows 2008R2 Build 7601 Service Pack 1';EXE=<SMP_HOME>\Server\db\sa\smp3\win32\Bin64\dbisql.exe;PID=0x179c;THREAD=0x14fc;VERSION=17.0.4.2066;API=iAnywhereJDBC;TIMEZONEADJUSTMENT=330
18:24:01 Connected to the server, attempting to connect to a running database... 18:24:03 [ 1] Connected to database successfully
But still I am getting the same error.
!MESSAGE SMP-INIT-001 SAP Mobile Server - Failed to verify database status on startup. The following error was returned:JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect. ERROR CODE: 0. SQL State: JZ006
We even tried to install SMP 3.0 SP12 but still faced the same issue. We have installed this server in a Development mode. Can you please help me out.
__________________________
Have a nice day
Amardeep Verma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amardeep,
1 - first I would modify the
"-Xms1024m" "-Xmx2048m" parameter in the ..\Server\props.ini which are quite low.
I would suggest to set at least:
"-Xms2048m" "-Xmx8192m" (depending on the available RAM of course).
2 - Are you able to connect to the smp3 SQLA database using dbisql (from \Server\db\sa\smp3\win32\Bin64, default would be user: gomobile, pw: secret, Server name: smp3, Database name: smp3)?
KR
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.