Db2 (On Premises and Cloud)

[ERROR] [ErrorService] - APIError: An internal error has occurred

  • 1.  [ERROR] [ErrorService] - APIError: An internal error has occurred

    Posted Tue June 22, 2021 09:51 AM

    Is anyone else seeing the following errors (from the log) when using new 3.5 function? I upgraded from 3.4 including the hotfix, and how I am getting internal server errors when using some function including this example when I try to schedule a script. 

    09:43:47 [INFO] [RestService] - 17a33f67-1406-7b80-a694-90ec22c27394: POST /dbapi/v4/jobs => 500 Internal Server Error 09:43:47 [ERROR] [ErrorService] - APIError: An internal error has occurred {"req":{"url":"/dbapi/v4/jobs","requestId":"17a33f67-1406-7b80-a694-90ec22c27394","method":"POST","headers":{"X-Request-ID":"17a33f67-1406-7b80-a694-90ec22c27394","ucUserID":"********","X-DB-Profile":"undefined","Authorization":"********","Accept":"application/json","Content-Type":"application/json"},"data":{"name":"Test","description":"","job_type":"RunSQL","category":"scheduled","schedule_info":{"startOn":1624369689691,"endOn":0,"repeat":false,"schedule":"","time_offset":-4,"timezone":"America/Toronto"},"notification_info":{"recipients":[]},"conn_profiles":["Banking-ML"],"configuration":{"separator":";","commands":"SELECT AC.\"TAIL_NUMBER\", AC.\"MANUFACTURER\", AC.\"MODEL\", OT.\"FLIGHTDATE\", OT.\"UNIQUECARRIER\", OT.\"AIRLINEID\", OT.\"CARRIER\", OT.\"TAILNUM\", OT.\"FLIGHTNUM\", OT.\"ORIGINAIRPORTID\", OT.\"ORIGINAIRPORTSEQID\", OT.\"ORIGINCITYNAME\", OT.\"ORIGINSTATE\", OT.\"DESTAIRPORTID\", OT.\"DESTCITYNAME\", OT.\"DESTSTATE\", OT.\"DEPTIME\", OT.\"DEPDELAY\", OT.\"TAXIOUT\", OT.\"WHEELSOFF\", OT.\"WHEELSON\", OT.\"TAXIIN\", OT.\"ARRTIME\", OT.\"ARRDELAY\", OT.\"ARRDELAYMINUTES\", OT.\"CANCELLED\", OT.\"AIRTIME\", OT.\"DISTANCE\"\n FROM \"ONTIME\".\"ONTIME\" OT, \"ONTIME\".\"AIRCRAFT\" AC \n WHERE AC.\"TAIL_NUMBER\" = OT.TAILNUM\n AND ORIGINSTATE = 'NJ'\n AND DESTSTATE = 'CA'\n AND AC.MANUFACTURER = 'Boeing' \n AND AC.MODEL LIKE 'B737%'\n AND OT.TAXIOUT > 30\n AND OT.DISTANCE > 2000\n AND OT.DEPDELAY > 300\n ORDER BY OT.ARRDELAY;","type":"JDBC","max_resultset_size":10,"failure_action":"STOP","job_type":"RunSQL","success_action":"AUTOCOMMIT"},"schedule_enabled":true}},"res":{"url":"/dbapi/v4/jobs","status":500,"statusText":"Internal Server Error","requestId":"17a33f67-1406-7b80-a694-90ec22c27394","headers":{},"method":"POST","data":{"trace":"","errors":[{"code":"internal_server_error","message":"An internal error has occurred","target":{"type":"","name":""},"more_info":""}]}}}



    ------------------------------
    Peter Kohlmann
    HDM Digital Technical Engagement
    IBM Canada
    kohlmann@ca.ibm.com
    ------------------------------