Db2 On Premise and Cloud

  • 1.  DMC 3.1.5 Internal Sever Error 500 when try to click Jobs or Unterbrechungen (German Version) on Linux

    Posted Thu August 26, 2021 09:53 AM
    Hi Folks.

    When I try to get to the jobs panel and clicking on jobs in the "Verwaltung" panel I received the following message in the logfie:

    15:48:13 [INFO] [i18n] - 374 locale messages for features_job registered 
    15:48:13 [INFO] [ShellService] - setPageHeader "/jobs" {"extraTitle":""} 
    15:48:13 [INFO] [RestService] - 17b82b7e-07a3-e710-6bc9-9c6a74642426: GET /dbapi/v4/tags/jobs => 500 Internal Server Error 
    15:48:13 [INFO] [RestService] - 17b82b7e-079d-f7d1-3b62-4ead54013309: GET /dbapi/v4/jobs => 500 Internal Server Error 
    15:48:13 [ERROR] [ErrorService] - APIError: An internal error has occurred {"req":{"url":"/dbapi/v4/tags/jobs","requestId":"17b82b7e-07a3-e710-6bc9-9c6a74642426","method":"GET","headers":{"X-Request-ID":"17b82b7e-07a3-e710-6bc9-9c6a74642426","ucUserID":"********","X-DB-Profile":"undefined","Authorization":"********","Accept":"application/json","Content-Type":"application/json"}},"res":{"url":"/dbapi/v4/tags/jobs","status":500,"statusText":"Internal Server Error","requestId":"17b82b7e-07a3-e710-6bc9-9c6a74642426","headers":{},"method":"GET","data":{"trace":"","errors":[{"code":"internal_server_error","message":"An internal error has occurred","target":{"type":"","name":""},"more_info":""}]}}} 
    15:48:13 [ERROR] [ErrorService] - APIError: An internal error has occurred {"req":{"url":"/dbapi/v4/jobs","requestId":"17b82b7e-079d-f7d1-3b62-4ead54013309","method":"GET","headers":{"X-Request-ID":"17b82b7e-079d-f7d1-3b62-4ead54013309","ucUserID":"********","X-DB-Profile":"undefined","Authorization":"********","Accept":"application/json","Content-Type":"application/json"}},"res":{"url":"/dbapi/v4/jobs","status":500,"statusText":"Internal Server Error","requestId":"17b82b7e-079d-f7d1-3b62-4ead54013309","headers":{},"method":"GET","data":{"trace":"","errors":[{"code":"internal_server_error","message":"An internal error has occurred","target":{"type":"","name":""},"more_info":""}]}}}

    Also when I try to configure the "Unterbrechung" maybe named interrupt on the english panel, I get the following error message:

    15:49:32 [INFO] [RestService] - 17b82b91-4dd1-1c6f-0fd6-f607f5435625: GET /dbapi/v4/alerts => 200 OK 
    15:50:12 [INFO] [RestService] - 17b82b9a-f9f3-739f-ce8b-53c35e635549: GET /dbapi/v4/multidb/home?end=1629985812383&start=1629899412383 => 200 OK 
    15:50:20 [INFO] [RestService] - 17b82b9c-f34d-ebd8-4bbb-2229ddf31014: GET /dbapi/v4/report/scheduler_list?limit=100&offset=0&sort=-last_run => 200 OK 
    15:50:20 [INFO] [RestService] - 17b82b9c-f356-2c9c-759c-1a883d936477: GET /dbapi/v4/report/result_list?limit=100&offset=0&sort=-generated_time => 200 OK 
    15:50:22 [INFO] [i18n] - 72 locale messages for features_blackout registered 
    15:50:22 [INFO] [RestService] - 17b82b9d-846f-cf85-1065-62ac76037578: GET /dbapi/v4/jobs?job_type=BLACKOUT => 500 Internal Server Error 
    15:50:22 [ERROR] [ErrorService] - APIError: An internal error has occurred {"req":{"url":"/dbapi/v4/jobs?job_type=BLACKOUT","requestId":"17b82b9d-846f-cf85-1065-62ac76037578","method":"GET","headers":{"X-Request-ID":"17b82b9d-846f-cf85-1065-62ac76037578","ucUserID":"********","X-DB-Profile":"undefined","Authorization":"********","Accept":"application/json","Content-Type":"application/json"}},"res":{"url":"/dbapi/v4/jobs?job_type=BLACKOUT","status":500,"statusText":"Internal Server Error","requestId":"17b82b9d-846f-cf85-1065-62ac76037578","headers":{},"method":"GET","data":{"trace":"","errors":[{"code":"internal_server_error","message":"An internal error has occurred","target":{"type":"","name":""},"more_info":""}]}}}

    Any ideas?

    regards
    Joerg


    ------------------------------
    Jörg Burdorf
    ------------------------------


  • 2.  RE: DMC 3.1.5 Internal Sever Error 500 when try to click Jobs or Unterbrechungen (German Version) on Linux

    Posted Thu September 02, 2021 12:01 AM
    Hi Matthias,

    Would you please post the job logs for further diagnosis, the log file locates at ${DMC installation directory}/addons/job-scheduler/logs, the file name is nohup.out, which is recording the current log trace.

    ​By the way, have you tried to restart the DMC server?

    Thanks


    ------------------------------
    Tao Wen
    ------------------------------



  • 3.  RE: DMC 3.1.5 Internal Sever Error 500 when try to click Jobs or Unterbrechungen (German Version) on Linux

    Posted Thu September 02, 2021 08:03 AM
    Hi Tao Wen!

    Here is the content of the file:

    /opt/IBM/ibm-datamgmtconsole/addons/job-scheduler/job-server: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /opt/IBM/ibm-datamgmtconsole/addons/clidriver/lib/libdb2.so.1)
    /opt/IBM/ibm-datamgmtconsole/addons/job-scheduler/job-server: /lib64/libgcc_s.so.1: version `GCC_4.8.0' not found (required by /opt/IBM/ibm-datamgmtconsole/addons/clidriver/lib/libdb2.so.1)

    regards
    Joerg

    ------------------------------
    Jörg Burdorf
    ------------------------------



  • 4.  RE: DMC 3.1.5 Internal Sever Error 500 when try to click Jobs or Unterbrechungen (German Version) on Linux

    Posted Thu September 02, 2021 11:12 PM
    Hi Joerg,

    What is the version of Linux distribution of your server?
    Could you please try to execute this shell command to check that?
    $ cat /etc/*-release
    or
    $ lsb_release -a

    Thank you.

    ------------------------------
    Tao Wen
    ------------------------------



  • 5.  RE: DMC 3.1.5 Internal Sever Error 500 when try to click Jobs or Unterbrechungen (German Version) on Linux

    Posted Tue September 07, 2021 03:57 AM
    Hi Joerg,

    Please double-check whether the DMC server OS is supported,  with this link https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=457FAA206BD611EBA199CCFE56FA6D9D&osPlatforms=Linux&duComponentIds=D002|S003&mandatoryCapIds=9|39|26&optionalCapIds=45

    For example, the DMC must be installed on the SLES12 SP3 or the later version.

    ------------------------------
    Tao Wen
    ------------------------------



  • 6.  RE: DMC 3.1.5 Internal Sever Error 500 when try to click Jobs or Unterbrechungen (German Version) on Linux

    Posted Tue September 21, 2021 11:16 AM
    Hi folks!

    The problem is the old version of Red Hat Linux. So I must wait until the server will be migrated to the next level.
    Thanks for your support!
    regards 
    Joerg

    ------------------------------
    Jörg Burdorf
    ------------------------------