Skip to Content
avatar image
Former Member

Connection refused when connecting SMP 3 to ASE 16

Hi all,

We're in the process of setting up an installation of SMP 3.0 with Sybase ASE 16 for one of our clients. The final goal is to run the SAP EHS Safety Issue mobile app.

When installing SMP 3.0 with Derby database, I'm able to start the system without any problems. However, when I try the installation configuring the Sybase ASE DB, the service gets stuck on a loop while starting up and doesn't react. I cannot stop it manually nor restart it. The only way to stop it is by restarting the system.

On the Sybase side of things, I can install the ASE without any issues. I have also done all the preliminary steps to create the user and smp3 DB for SMP. I've connected to the DB using this user and I'm able to see that the smp3 DB is created.

When looking at the logs, I can see an exception with the message: Connection refused. Here's an excerpt:

2014 07 28 15:01:10#0-500#ERROR#org.jgroups.protocols.SMP_JDBC_PING##anonymous#Timer-2,SAPDSMP-5000-smp3-smpserver:com.sap.mobile.platform.server.online.admin.backendconnections.cluster.ClusterBackends,SAPDSMP-4630###Failed creating JDBC connection for SMP_JDBC_PING java.sql.SQLException: JZ006: Caught IOException: java.net.ConnectException: Connection refused: connect

  at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)

  at com.sybase.jdbc4.jdbc.SybConnection.handleSQLE(Unknown Source)

  at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(Unknown Source)

  at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(Unknown Source)

Any idea what may be causing this issue?

Kind regards,

Omar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 30, 2014 at 02:54 PM

    I continued doing some research and found out that the connection.properties file was getting overwritten after installation with the parameters defined on the installer. The major difference between the parameters was that the password was getting encrypted.

    I tested changing the parameters manually to the values that I've entered manually before installation, and the connection to DB succeeded!!!

    However, the server didn't start... it got stuck trying to initialize the bundles. Here's the exception that I'm getting now:

    2014 07 30 09:16:25#0-500#ERROR#org.jgroups.protocols.SMP_JDBC_PING##anonymous#Timer-3,SAPDSMP-5000-smp3-gomobile:com.sap.mobile.platform.server.online.admin.logsettings.cluster.ClusterLogSettings,SAPDSMP-32939###Error updating JDBC_PING table java.sql.SQLException: jgroupsping not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

      at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(Unknown Source)

      at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(Unknown Source)

      at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)

      at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)

      at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(Unknown Source)

      at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(Unknown Source)

      at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)

      at org.jgroups.protocols.JDBC_PING.delete(JDBC_PING.java:276)

      at org.jgroups.protocols.JDBC_PING.writeToFile(JDBC_PING.java:243)

      at org.jgroups.protocols.FILE_PING.fetchClusterMembers(FILE_PING.java:73)

      at org.jgroups.protocols.Discovery.sendDiscoveryRequest(Discovery.java:263)

      at org.jgroups.protocols.Discovery.findMembers(Discovery.java:227)

      at org.jgroups.protocols.Discovery.findAllViews(Discovery.java:214)

      at org.jgroups.protocols.Discovery.down(Discovery.java:551)

      at org.jgroups.protocols.FILE_PING.down(FILE_PING.java:101)

      at org.jgroups.protocols.MERGE2$FindSubgroupsTask.findAllViews(MERGE2.java:351)

      at org.jgroups.protocols.MERGE2$FindSubgroupsTask._findAndNotify(MERGE2.java:286)

      at org.jgroups.protocols.MERGE2$FindSubgroupsTask.findAndNotify(MERGE2.java:274)

      at org.jgroups.protocols.MERGE2$FindSubgroupsTask$1.run(MERGE2.java:247)

      at org.jgroups.util.TimeScheduler3$Task.run(TimeScheduler3.java:277)

      at org.jgroups.util.TimeScheduler3$RecurringTask.run(TimeScheduler3.java:308)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

      at java.lang.Thread.run(Thread.java:791)

    |

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Omar,

      Regarding the mistake that you have mentioned in the configuration. Can you please let me know which config file do we need to mention the db name?

      I am currently facing a similar issue:

      "

      (Oct 30, 2014 6:54:50 AM), , com.installshield.smpserver.event.dialog.swing.PanelDBConfiguration, dbg, Ping failed: 1
      (Oct 30, 2014 6:54:50 AM), , com.installshield.smpserver.event.dialog.swing.PanelDBConfiguration, err, Cannot connect to database. Verify that the values entered are correct and that the database is running.
      (Oct 30, 2014 6:54:50 AM), , com.installshield.smpserver.event.dialog.swing.PanelDBConfiguration, err, Refer to errors in installation log.
      (Oct 30, 2014 6:54:50 AM), , com.installshield.smpserver.event.dialog.swing.PanelDBConfiguration, err, Failed to execute SQL script file Select CLUSTER_NAME, CLUSTER_VERSION, CLUSTER_KEY from SMP_CLUSTER . Error: java.sql.SQLException: SMP_CLUSTER not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

      "

      Any inputs around this will be very much  valuable.

      Many Thanks in advance!

      Regards,

      Kartik

  • avatar image
    Former Member
    Jul 29, 2014 at 08:53 PM

    Dear Omar,

    can you check the below

    1. If ASE services are running on the host machine on which SMP is installed

    2. Can you share the username and password configured in the .DLL file

    3. The DLL file after editing

    4. Also you can stop the services forcibly by going to services.msc and clicking the SAPSMP3Service. Double click on it and get the name of the service. Go to command prompt(launch as Administrator) nd use the command

    sc queryex smpservicename

    record the PID number and then run the below command

    taskkill /f /pid PIDNO

    then go to the SMP3 server installation directory from cmd

    cd //installationpath/SAP/Mobile3/Server

    and then hit the go command

    your service might not appear in the start mode but u can use all the features

    p.n before running the go.bat command delete the log folder, work folder under Server folder and the .state folder within the pickup folder

    hope this should help

    thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Omar,

      I am using ASE 16 with SMP 3.0.3

      While Installation of SMP Server were you able to communicate to the ASE where you enter the ASE Database properties.

      I hope you first installed the ASE Database and then Installed SMP.

      What i understand is that you changed the ASE User parameters but the SMP Server is still using the old parameters to communicate.

      Hence the ping is failing.

      What i can advice is do a fresh installation of both (ASE and SMP)

      Hope this helps,

      Thanks,

      Best Regards,

      Rakshit Doshi