error connecting to server, server not up or wrong connection parameters

Hi Guys,

I'm new to HP service manager, I'm recently installed HP service manager 9.40 on a test VM, then I installed the HP service manager client.

when I try to open the client, the interface opens up a coonection window I then complete the fields on the connection window, then an error message pops up
 "error connecting to server, server not up or wrong connection parameters: ">http://localhost:13080/SM/ui",
the error message says the cause is Javax.xml.soap.SOAPException: message send failled.

another iussue I have is when I try verify my database connection after the install, I'm unable to connect to it, I'm using sqlExpress 2012 to as my server server.

The port is correct and the host(localhost) is also correct.
The service is running.

please assist.

Thanks in advance
Sivu

  • HI,

     

    See below:

      1488(  1196) 09/04/2017 17:08:20  RTE I Using "utalloc" memory manager, mode [0]
      1488(  1196) 09/04/2017 17:08:20  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -encrypt:sqllogin "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      1488(  1196) 09/04/2017 17:08:20  RTE I -Memory : S(50336) O(101644) MAX(160172) - MALLOC's Total(59)
      1488(  1196) 09/04/2017 17:08:20  RTE I Thread termination in progress
      1488(  1196) 09/04/2017 17:08:20  RTE E Unable to obtain SYSTEM lock in interm().
      1488(  1196) 09/04/2017 17:08:20  RTE I Process termination cleanup complete (exit code=0)
      1044(  3052) 09/04/2017 17:08:22  RTE I Using "utalloc" memory manager, mode [0]
      1044(  3052) 09/04/2017 17:08:22  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -sqlverifyconnection "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      1044(  3052) 09/04/2017 17:08:22  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:08:22  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:08:22  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:08:22  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:08:22  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'sivuyile.mlilwana'
      1044(  3052) 09/04/2017 17:08:22  RTE I Going to sleep for 15 seconds and try again to connect
      1044(  3052) 09/04/2017 17:08:37  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:08:37  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:08:37  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:08:37  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:08:37  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'sivuyile.mlilwana'
      1044(  3052) 09/04/2017 17:08:37  RTE I Going to sleep for 15 seconds and try again to connect
      1044(  3052) 09/04/2017 17:08:52  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:08:52  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:08:52  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:08:52  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:08:52  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'sivuyile.mlilwana'
      1044(  3052) 09/04/2017 17:08:52  RTE I Going to sleep for 15 seconds and try again to connect
      1044(  3052) 09/04/2017 17:09:07  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:09:07  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      1044(  3052) 09/04/2017 17:09:07  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:09:07  RTE E API=SQLConnect
      1044(  3052) 09/04/2017 17:09:07  RTE E Failure connecting to dbtype 'sqlserver' database 'SMDEMO' user 'sivuyile.mlilwana'
      1044(  3052) 09/04/2017 17:09:07  RTE E Failed to connect to RDBMS server, terminating.
      1044(  3052) 09/04/2017 17:09:07  RTE I -Memory : S(52320) O(107852) MAX(168364) - MALLOC's Total(122)
      1044(  3052) 09/04/2017 17:09:07  RTE I Thread termination in progress
      1044(  3052) 09/04/2017 17:09:07  RTE E Unable to obtain SYSTEM lock in interm().
      1044(  3052) 09/04/2017 17:09:07  RTE I Process termination cleanup complete (exit code=1)
       996(  2368) 09/04/2017 17:10:11  RTE I Using "utalloc" memory manager, mode [0]
       996(  2368) 09/04/2017 17:10:11  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -encrypt:sqllogin "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
       996(  2368) 09/04/2017 17:10:11  RTE I -Memory : S(50320) O(101660) MAX(160172) - MALLOC's Total(59)
       996(  2368) 09/04/2017 17:10:11  RTE I Thread termination in progress
       996(  2368) 09/04/2017 17:10:11  RTE E Unable to obtain SYSTEM lock in interm().
       996(  2368) 09/04/2017 17:10:11  RTE I Process termination cleanup complete (exit code=0)
      2900(  2128) 09/04/2017 17:10:13  RTE I Using "utalloc" memory manager, mode [0]
      2900(  2128) 09/04/2017 17:10:13  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -sqlverifyconnection "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      2900(  2128) 09/04/2017 17:10:13  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:13  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:13  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:13  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:13  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'sa'
      2900(  2128) 09/04/2017 17:10:13  RTE I Going to sleep for 15 seconds and try again to connect
      2900(  2128) 09/04/2017 17:10:28  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:28  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:28  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:28  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:28  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'sa'
      2900(  2128) 09/04/2017 17:10:28  RTE I Going to sleep for 15 seconds and try again to connect
      2900(  2128) 09/04/2017 17:10:43  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:43  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:43  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:43  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:43  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'sa'
      2900(  2128) 09/04/2017 17:10:43  RTE I Going to sleep for 15 seconds and try again to connect
      2900(  2128) 09/04/2017 17:10:58  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:58  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2900(  2128) 09/04/2017 17:10:58  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:58  RTE E API=SQLConnect
      2900(  2128) 09/04/2017 17:10:58  RTE E Failure connecting to dbtype 'sqlserver' database 'SMDEMO' user 'sa'
      2900(  2128) 09/04/2017 17:10:58  RTE E Failed to connect to RDBMS server, terminating.
      2900(  2128) 09/04/2017 17:10:58  RTE I -Memory : S(52304) O(107868) MAX(168364) - MALLOC's Total(122)
      2900(  2128) 09/04/2017 17:10:58  RTE I Thread termination in progress
      2900(  2128) 09/04/2017 17:10:58  RTE E Unable to obtain SYSTEM lock in interm().
      2900(  2128) 09/04/2017 17:10:58  RTE I Process termination cleanup complete (exit code=1)
      2848(  2824) 09/04/2017 17:57:42  RTE I Using "utalloc" memory manager, mode [0]
      2848(  2824) 09/04/2017 17:57:42  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -encrypt:sqllogin "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      2848(  2824) 09/04/2017 17:57:42  RTE I -Memory : S(50352) O(101628) MAX(164268) - MALLOC's Total(60)
      2848(  2824) 09/04/2017 17:57:42  RTE I Thread termination in progress
      2848(  2824) 09/04/2017 17:57:42  RTE E Unable to obtain SYSTEM lock in interm().
      2848(  2824) 09/04/2017 17:57:42  RTE I Process termination cleanup complete (exit code=0)
      2020(  2928) 09/04/2017 17:57:44  RTE I Using "utalloc" memory manager, mode [0]
      2020(  2928) 09/04/2017 17:57:44  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -sqlverifyconnection "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      2020(  2928) 09/04/2017 17:57:44  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:57:44  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:57:44  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:57:44  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:57:44  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      2020(  2928) 09/04/2017 17:57:44  RTE I Going to sleep for 15 seconds and try again to connect
      2020(  2928) 09/04/2017 17:57:59  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:57:59  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:57:59  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:57:59  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:57:59  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      2020(  2928) 09/04/2017 17:57:59  RTE I Going to sleep for 15 seconds and try again to connect
      2020(  2928) 09/04/2017 17:58:14  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:58:14  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:58:14  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:58:14  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:58:14  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      2020(  2928) 09/04/2017 17:58:14  RTE I Going to sleep for 15 seconds and try again to connect
      2020(  2928) 09/04/2017 17:58:29  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:58:29  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      2020(  2928) 09/04/2017 17:58:29  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:58:29  RTE E API=SQLConnect
      2020(  2928) 09/04/2017 17:58:29  RTE E Failure connecting to dbtype 'sqlserver' database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      2020(  2928) 09/04/2017 17:58:29  RTE E Failed to connect to RDBMS server, terminating.
      2020(  2928) 09/04/2017 17:58:29  RTE I -Memory : S(52336) O(107836) MAX(168364) - MALLOC's Total(122)
      2020(  2928) 09/04/2017 17:58:29  RTE I Thread termination in progress
      2020(  2928) 09/04/2017 17:58:29  RTE E Unable to obtain SYSTEM lock in interm().
      2020(  2928) 09/04/2017 17:58:29  RTE I Process termination cleanup complete (exit code=1)
      3872(  3876) 09/05/2017 09:10:23  RTE I Using "utalloc" memory manager, mode [0]
      3872(  3876) 09/05/2017 09:10:23  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -encrypt:sqllogin "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      3872(  3876) 09/05/2017 09:10:23  RTE I -Memory : S(50352) O(101628) MAX(164268) - MALLOC's Total(60)
      3872(  3876) 09/05/2017 09:10:23  RTE I Thread termination in progress
      3872(  3876) 09/05/2017 09:10:23  RTE E Unable to obtain SYSTEM lock in interm().
      3872(  3876) 09/05/2017 09:10:23  RTE I Process termination cleanup complete (exit code=0)
      3904(  3908) 09/05/2017 09:10:25  RTE I Using "utalloc" memory manager, mode [0]
      3904(  3908) 09/05/2017 09:10:25  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -sqlverifyconnection "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      3904(  3908) 09/05/2017 09:10:25  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:10:25  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:10:25  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:10:25  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:10:25  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3904(  3908) 09/05/2017 09:10:25  RTE I Going to sleep for 15 seconds and try again to connect
      3904(  3908) 09/05/2017 09:10:40  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:10:40  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:10:40  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:10:40  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:10:40  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3904(  3908) 09/05/2017 09:10:40  RTE I Going to sleep for 15 seconds and try again to connect
      3904(  3908) 09/05/2017 09:10:55  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:10:55  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:10:55  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:10:55  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:10:55  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3904(  3908) 09/05/2017 09:10:55  RTE I Going to sleep for 15 seconds and try again to connect
      3904(  3908) 09/05/2017 09:11:10  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:11:10  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3904(  3908) 09/05/2017 09:11:10  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:11:10  RTE E API=SQLConnect
      3904(  3908) 09/05/2017 09:11:10  RTE E Failure connecting to dbtype 'sqlserver' database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3904(  3908) 09/05/2017 09:11:10  RTE E Failed to connect to RDBMS server, terminating.
      3904(  3908) 09/05/2017 09:11:10  RTE I -Memory : S(52336) O(107836) MAX(168364) - MALLOC's Total(122)
      3904(  3908) 09/05/2017 09:11:10  RTE I Thread termination in progress
      3904(  3908) 09/05/2017 09:11:10  RTE E Unable to obtain SYSTEM lock in interm().
      3904(  3908) 09/05/2017 09:11:10  RTE I Process termination cleanup complete (exit code=1)
      3408(  1048) 09/05/2017 10:06:46  RTE I Using "utalloc" memory manager, mode [0]
      3408(  1048) 09/05/2017 10:06:46  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -sqlverifyconnection "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      3408(  1048) 09/05/2017 10:06:46  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:06:46  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:06:46  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:06:46  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:06:46  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3408(  1048) 09/05/2017 10:06:46  RTE I Going to sleep for 15 seconds and try again to connect
      3408(  1048) 09/05/2017 10:07:01  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:07:01  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:07:01  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:07:01  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:07:01  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3408(  1048) 09/05/2017 10:07:01  RTE I Going to sleep for 15 seconds and try again to connect
      3408(  1048) 09/05/2017 10:07:16  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:07:16  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:07:16  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:07:16  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:07:16  RTE E Failure connecting to dbtype [sqlserver], using database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3408(  1048) 09/05/2017 10:07:16  RTE I Going to sleep for 15 seconds and try again to connect
      3408(  1048) 09/05/2017 10:07:31  RTE E Error: SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:07:31  RTE E SQL State: IM002-0     Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
      3408(  1048) 09/05/2017 10:07:31  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:07:31  RTE E API=SQLConnect
      3408(  1048) 09/05/2017 10:07:31  RTE E Failure connecting to dbtype 'sqlserver' database 'SMDEMO' user 'WIN-KS00KAS0AG2\Sivuyile.Mlilwana'
      3408(  1048) 09/05/2017 10:07:31  RTE E Failed to connect to RDBMS server, terminating.
      3408(  1048) 09/05/2017 10:07:31  RTE I -Memory : S(52336) O(107836) MAX(168364) - MALLOC's Total(122)
      3408(  1048) 09/05/2017 10:07:31  RTE I Thread termination in progress
      3408(  1048) 09/05/2017 10:07:31  RTE E Unable to obtain SYSTEM lock in interm().
      3408(  1048) 09/05/2017 10:07:31  RTE I Process termination cleanup complete (exit code=1)
      3084(   632) 09/05/2017 10:10:22  RTE I Using "utalloc" memory manager, mode [0]
      3084(   632) 09/05/2017 10:10:22  RTE I Command line: "C:\Program Files (x86)\HP\Service Manager 9.40\Server\RUN\sm" -encrypt:sqllogin "-log:C:\Program Files (x86)\HP\Service Manager 9.40\Server\smconfig.log"
      3084(   632) 09/05/2017 10:10:22  RTE I -Memory : S(50352) O(101628) MAX(164268) - MALLOC's Total(60)
      3084(   632) 09/05/2017 10:10:22  RTE I Thread termination in progress
      3084(   632) 09/05/2017 10:10:22  RTE E Unable to obtain SYSTEM lock in interm().
      3084(   632) 09/05/2017 10:10:22  RTE I Process termination cleanup complete (exit code=0)

  • SM service might be running, but it's not "up" because it can't talk to the database, which is why you can't connect your sm client to it.

    Check out this post:

    /it_ops_mgt/itsm/sws-smgr/f/itrc-695/227281/sm9-0-connect-to-sql2008-on-x64

     

  • HI,

    I managed to create the datasource connection to my database and the verify sql connection step went though successfully.

    Thanks to Tom.

    I'm still struggling to connect to my windows client, I was also unable to load sample data, I end up clicking next without loading the sample data.


      5648(  9152) 09/06/2017 08:29:45  RTE I Thread termination in progress
      5648(  9152) 09/06/2017 08:29:45  RTE E Unable to obtain SYSTEM lock in interm().
      5648(  9152) 09/06/2017 08:29:45  RTE I Process termination cleanup complete (exit code=0)
     10724(  9552) 09/06/2017 08:29:48  RTE I Using "utalloc" memory manager, mode [0]
     10724(  9552) 09/06/2017 08:29:48  RTE I Command line: "C:\Program Files (x86)\HPE\Service Manager 9.50\Server\RUN\sm" -sqlverifyconnection "-log:C:\Program Files (x86)\HPE\Service Manager 9.50\Server\smconfig.log"
     10724(  9552) 09/06/2017 08:29:48  RTE I Info: SQL State: 01000-5701  Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed database context to 'master'.
     10724(  9552) 09/06/2017 08:29:48  RTE I Info: SQL State: 01000-5703  Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed language setting to us_english.
     10724(  9552) 09/06/2017 08:29:48  RTE I API=SQLConnect
     10724(  9552) 09/06/2017 08:29:48  RTE I Connection established to dbtype 'sqlserver' database 'MSDEMO' user 'EOHCORP\Sivuyile.Mlilwana'
     10724(  9552) 09/06/2017 08:29:48  RTE I Connected to Data source 'MSDEMO' SQL server 'EOHLSMLILWANA1\SQLEXPRESSSIVU' version: 11.0.2100 through SQL driver version: 11.0.2100 using database 'master' as user 'dbo'
     10724(  9552) 09/06/2017 08:29:48  RTE I MS SQL Server collation 'Latin1_General_CI_AS', varchar codepage 1252, comparison 196609: case insensitive, accent sensitive
     10724(  9552) 09/06/2017 08:29:48  RTE I Successfully connected to RDBMS server
     10724(  9552) 09/06/2017 08:29:48  RTE I -Memory : S(52336) O(107836) MAX(176556) - MALLOC's Total(121)
     10724(  9552) 09/06/2017 08:29:48  RTE I Thread termination in progress
     10724(  9552) 09/06/2017 08:29:48  RTE E Unable to obtain SYSTEM lock in interm().
     10724(  9552) 09/06/2017 08:29:48  RTE I Process termination cleanup complete (exit code=0)
      4628(  6748) 09/06/2017 08:30:08  RTE I Using "utalloc" memory manager, mode [0]
      4628(  6748) 09/06/2017 08:30:08  RTE I Command line: "C:\Program Files (x86)\HPE\Service Manager 9.50\Server\RUN\sm" -system_load -mssqlunicode:1 "-system_directory:C:\Program Files (x86)\HPE\Service Manager 9.50\Server\data" "-log:C:\Program Files (x86)\HPE\Service Manager 9.50\Server\smconfig.log"
      4628(  6748) 09/06/2017 08:30:08  RTE I Process sm 9.50.0025 () System: 13080 (0x784DFB00) on PC (x64 64-bit) running Windows (6.2 Build 9200) Timezone GMT 02:00 Locale en_ZA from EOHLSMLILWANA1
      4628(  6748) 09/06/2017 08:30:08  RTE I Creating resources for system '13080' with key 0x784DFB00
      4628(  6748) 09/06/2017 08:30:08  RTE W The shared memory size 32000000 is less than the recommended size 134217728
      4628(  6748) 09/06/2017 08:30:08  RTE I Created shared memory of size 32000000 using key 0x784DFB00 and attached to it at address 0x80000000
      4628(  6748) 09/06/2017 08:30:08  RTE I C:\Program Files (x86)\HPE\Service Manager 9.50\Server\RUN\jre\bin\client\jvm.dll is used.
      4628(  6748) 09/06/2017 08:30:08  RTE I JVM successfully created
      4628(  6748) 09/06/2017 08:30:08 JRTE I Java version: 1.8.0-internal
      4628(  6748) 09/06/2017 08:30:31 JRTE E Multiple ipaddresses found [192.168.81.1, 10.50.70.70, 192.168.32.1]
      4628(  6748) 09/06/2017 08:30:31 JRTE E Provide a valid local ipaddress to use in groupbindaddress parameter.
      4628(  6748) 09/06/2017 08:30:31 JRTE E Init: getInstance() failed
      4628(  6748) 09/06/2017 08:30:31  RTE E HP Service Manager is unable to start. Failed to initialize or attach to shared memory environment
      4628(  6748) 09/06/2017 08:30:31  RTE E Failed Initializing Java.
      4628(  6748) 09/06/2017 08:30:31 JRTE E Multiple ipaddresses found. [192.168.81.1, 10.50.70.70, 192.168.32.1]
      4628(  6748) 09/06/2017 08:30:31 JRTE E Provide valid groupbindaddress:<ipaddress> parameter.
      4628(  6748) 09/06/2017 08:30:31 JRTE E Multiple ipaddresses found. [192.168.81.1, 10.50.70.70, 192.168.32.1]
      4628(  6748) 09/06/2017 08:30:31 JRTE E Provide valid groupbindaddress:<ipaddress> parameter.
      4628(  6748) 09/06/2017 08:30:31 JRTE E Multiple ipaddresses found. [192.168.81.1, 10.50.70.70, 192.168.32.1]
      4628(  6748) 09/06/2017 08:30:31 JRTE E Provide valid groupbindaddress:<ipaddress> parameter.
      4628(  6748) 09/06/2017 08:30:31  RTE I -Memory : S(59064) O(113396) MAX(328364) - MALLOC's Total(1560)
      4628(  6748) 09/06/2017 08:30:31  RTE I Thread termination in progress
      4628(  6748) 09/06/2017 08:30:31  RTE I Shutdown of HP Service Manager environment has completed
      4628(  6748) 09/06/2017 08:30:31  RTE I Process termination cleanup complete (exit code=1)
      8468(  3768) 09/06/2017 08:30:31  RTE I Using "utalloc" memory manager, mode [0]
      8468(  3768) 09/06/2017 08:30:31  RTE I Command line: "C:\Program Files (x86)\HPE\Service Manager 9.50\Server\RUN\sm" -shutipc "-log:C:\Program Files (x86)\HPE\Service Manager 9.50\Server\smconfig.log"
      8468(  3768) 09/06/2017 08:30:31  RTE I -Memory : S(52048) O(104028) MAX(160172) - MALLOC's Total(94)
      8468(  3768) 09/06/2017 08:30:31  RTE I Thread termination in progress
      8468(  3768) 09/06/2017 08:30:31  RTE E Unable to obtain SYSTEM lock in interm().
      8468(  3768) 09/06/2017 08:30:31  RTE I Process termination cleanup complete (exit code=0)
      1652(  7024) 09/06/2017 08:30:32  RTE I Using "utalloc" memory manager, mode [0]
      1652(  7024) 09/06/2017 08:30:32  RTE I Command line: "C:\Program Files (x86)\HPE\Service Manager 9.50\Server\RUN\sm" -instantOn "-log:C:\Program Files (x86)\HPE\Service Manager 9.50\Server\smconfig.log"
      1652(  7024) 09/06/2017 08:30:32  RTE I Process sm 9.50.0025 () System: 13080 (0x784DFB00) on PC (x64 64-bit) running Windows (6.2 Build 9200) Timezone GMT 02:00 Locale en_ZA from EOHLSMLILWANA1
      1652(  7024) 09/06/2017 08:30:32  RTE I Creating resources for system '13080' with key 0x784DFB00
      1652(  7024) 09/06/2017 08:30:32  RTE W The shared memory size 32000000 is less than the recommended size 134217728
      1652(  7024) 09/06/2017 08:30:32  RTE I Created shared memory of size 32000000 using key 0x784DFB00 and attached to it at address 0x80000000
      1652(  7024) 09/06/2017 08:30:32  RTE I C:\Program Files (x86)\HPE\Service Manager 9.50\Server\RUN\jre\bin\client\jvm.dll is used.
      1652(  7024) 09/06/2017 08:30:32  RTE I JVM successfully created
      1652(  7024) 09/06/2017 08:30:32 JRTE I Java version: 1.8.0-internal
      1652(  7024) 09/06/2017 08:30:55 JRTE E Multiple ipaddresses found [192.168.81.1, 10.50.70.70, 192.168.32.1]
      1652(  7024) 09/06/2017 08:30:55 JRTE E Provide a valid local ipaddress to use in groupbindaddress parameter.
      1652(  7024) 09/06/2017 08:30:55 JRTE E Init: getInstance() failed
      1652(  7024) 09/06/2017 08:30:55  RTE E HP Service Manager is unable to start. Failed to initialize or attach to shared memory environment
      1652(  7024) 09/06/2017 08:30:55  RTE E Failed Initializing Java.
      1652(  7024) 09/06/2017 08:30:55 JRTE E Multiple ipaddresses found. [192.168.81.1, 10.50.70.70, 192.168.32.1]
      1652(  7024) 09/06/2017 08:30:55 JRTE E Provide valid groupbindaddress:<ipaddress> parameter.
      1652(  7024) 09/06/2017 08:30:55 JRTE E Multiple ipaddresses found. [192.168.81.1, 10.50.70.70, 192.168.32.1]
      1652(  7024) 09/06/2017 08:30:55 JRTE E Provide valid groupbindaddress:<ipaddress> parameter.
      1652(  7024) 09/06/2017 08:30:55 JRTE E Multiple ipaddresses found. [192.168.81.1, 10.50.70.70, 192.168.32.1]
      1652(  7024) 09/06/2017 08:30:55 JRTE E Provide valid groupbindaddress:<ipaddress> parameter.
      1652(  7024) 09/06/2017 08:30:55  RTE I -Memory : S(58840) O(113620) MAX(328364) - MALLOC's Total(1527)
      1652(  7024) 09/06/2017 08:30:55  RTE I Thread termination in progress
      1652(  7024) 09/06/2017 08:30:55  RTE I Shutdown of HP Service Manager environment has completed
      1652(  7024) 09/06/2017 08:30:55  RTE I Process termination cleanup complete (exit code=1)

  • Well if you have not loaded sample data you have NO service manager running and thus you cannot login..

    You also have an issue with multiple ip's on your server you need to adress this too in order to start sm server. Look in documentation for configuration parameters. You need to specify which ip is the main ip.

     

  • To setup the database run the config tool and make sure to run it as admin otherwise loading the database could fail.