Db2

 View Only
  • 1.  IBMCONSOLE.ADMIN_TASK_HISTORY

    Posted Tue February 27, 2024 01:27 PM

    I've been trying to upload data into some tables but had no luck. This is the error msg I keep receiving: IBMCONSOLE.ADMIN_TASK_HISTORY

    I double checked on the timestamps and they seem to be okay. 

    I don't know what I'm doing wrong. Can anyone help me with this? 



    ------------------------------
    Denise Meneses Lopez
    ------------------------------



  • 2.  RE: IBMCONSOLE.ADMIN_TASK_HISTORY

    Posted Wed February 28, 2024 09:33 AM

    Hello Denise,

    The IBMCONSOLE.ADMIN_TASK_HISTORY is a table that belongs to the DMC repository database.

    Few questions for you:

    1.) What tables are you trying to upload data to?

    2.) Is your DMC repository database the same database as you are trying to upload data to?

    3.) What is the full error message that you are getting?

    Please let me know.



    ------------------------------
    Cintia Ogura
    ------------------------------



  • 3.  RE: IBMCONSOLE.ADMIN_TASK_HISTORY

    Posted Thu February 29, 2024 11:16 PM
    2024-02-27T16:22:08.583Z [INFO] [MTUserService] - waiting for user service ready 
    2024-02-27T16:22:08.589Z [INFO] [session] - use default session 
    2024-02-27T16:22:08.590Z [INFO] [session] - get sso key at  1709050928590 
    2024-02-27T16:22:08.597Z [INFO] [i18n] - 598 locale messages for platforms_console registered 
    2024-02-27T16:22:08.601Z [INFO] [ConfigService] - Browser: chrome 121.0.0 
    2024-02-27T16:22:08.601Z [INFO] [ConfigService] - OS: Windows 10 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - Product id: cloud_db2_txn_entry 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - Product title: Db2 on Cloud 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - GIT branch: uc-oc-woc-202308 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - GIT commit: 554d50b 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - Build time: 2023-11-09T02:15:41.133Z 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - Configuration: {"productID":"cloud_db2_txn_entry","support_update_password":true,"locale":"en_US","customer_dbProfileName":"crn:v1:bluemix:public:dashdb-for-transactions:us-south:a/3651d875d2124a46a5035a8f2e902f98:cfae0420-6c59-4007-9463-183c91e59269::","enable_scaling":false,"productVersion":"3.1.0","enable_aspera":false,"apiVersion":"v4","ui_commit":"fc1f545","enable_dr":false,"inactive":false,"disableNoneSSLProd":"cloud_db2w_mppv2|cloud_db2w_mppv2_aws","days_to_inactive":-1,"multi_tenant":true,"support_forget_password":true,"idle_timeout":1800000,"segmentMetricsTag":"DYZur5EXpBcSYUIl2QO01lVQQPZOCzJ9","support_usermgmt":true,"operation.credentials.save.to.repository":true,"console_hostname":null,"supportIAM":true,"container_env":true,"api_commit":"e69a67f","enable_dr_backup":false,"enable_db2audit":false,"enable_replication":false,"PLATFORM":"console","productTitle":"Db2 on Cloud","copyrightText":"(C) Copyright IBM Corp. 2016, 2024","OAUTH2_DISCOVERY_URL":"https://api.ng.bluemix.net/info","loadFromET":"false","isRepositoryVendorLUW":"true","disableSocket":"false","singleDBmode":"true"} 
    2024-02-27T16:22:08.602Z [INFO] [ConfigService] - Release build: true 
    2024-02-27T16:22:08.603Z [INFO] [ExtensionService] - =>1. Load extensions configuration 
    2024-02-27T16:22:08.621Z [INFO] [i18n] - 201 locale messages for shared registered 
    2024-02-27T16:22:08.799Z [INFO] [ShareLinkService] - Share link UI connected 
    2024-02-27T16:22:08.866Z [INFO] [services] - Lazy registering tuning APIs ["showVisualExplainDialog"] 
    2024-02-27T16:22:08.866Z [INFO] [services] - Lazy registering tuning APIs ["showActivityDialog"] 
    2024-02-27T16:22:08.994Z [INFO] [RestService] - 18deb5f9-ddcb-7a99-2579-bc2ec6218893: GET /dbapi/v4/internal/settings_ext => 200  
    2024-02-27T16:22:09.057Z [INFO] [RestService] - 18deb5f9-eee5-6a8a-ea0f-3296ab233637: GET /dbapi/v4/internal/user/should_init => 200  
    2024-02-27T16:22:09.170Z [INFO] [RestService] - 18deb5f9-eaab-56fa-b873-4f9746f35362: GET /dbapi/v4/about => 200  
    2024-02-27T16:22:09.244Z [INFO] [RestService] - 18deb5f9-fa2a-c284-06a3-a018f5d12219: GET /dbapi/v4/dbprofiles/connection/test => 200  
    2024-02-27T16:22:09.245Z [INFO] [services] - Lazy registering about APIs ["show"] 
    2024-02-27T16:22:09.245Z [INFO] [MTUserService] - user service is ready 
    2024-02-27T16:22:11.660Z [INFO] [RestService] - 18deb5fa-0607-f0d3-121b-38c401d31515: GET /dbapi/v4/users/zny86979?test_connection=false => 200  
    2024-02-27T16:22:11.661Z [INFO] [UserService] - User: {"roles":["bluuser"],"isAdmin":false,"dvRole":"","metadata":null,"formatedIbmid":"deni.lop34@gmail.com","role":"bluuser","iamid":"IBMid-6970004RBW","permittedActions":["view-settings","settings","backup","access","restore","manage-users","clone","scale","monitor","admin-objects","runsql"],"allClean":false,"password":"","iam":true,"name":"","ibmid":"deni.lop34@gmail.com","id":"zny86979","locked":"no","initErrorMsg":"","email":"deni.lop34@gmail.com","authentication":{"method":"internal","policy_id":"Default"}} 
    2024-02-27T16:22:11.662Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709050931662 
    2024-02-27T16:22:11.689Z [INFO] [Routers] - Console started in 4052ms 
    2024-02-27T16:22:11.824Z [INFO] [i18n] - 4435 locale messages for features_monitor registered 
    2024-02-27T16:22:11.981Z [INFO] [RestService] - 18deb5fa-a486-ec98-066b-4d3cffc84240: GET /dbapi/v4/dbprofiles/crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A => 200  
    2024-02-27T16:22:21.160Z [INFO] [RestService] - 18deb5fc-de9c-9e71-86c1-06bd87e12407: GET /dbapi/v4/run_sql/api/permission => 200  
    2024-02-27T16:22:21.191Z [INFO] [i18n] - 396 locale messages for features_runSQL registered 
    2024-02-27T16:22:21.192Z [INFO] [i18n] - 218 locale messages for features_runSQLV2 registered 
    2024-02-27T16:22:21.307Z [INFO] [RestService] - 18deb5fc-f08b-c11e-f726-70dbf1062447: GET /dbapi/v4/run_sql/config => 200  
    2024-02-27T16:22:21.717Z [INFO] [i18n] - 0 locale messages for features_runSQLV2_src_sqlBuilder registered 
    2024-02-27T16:22:22.210Z [INFO] [RestService] - 18deb5fd-1157-d946-3c5a-7815d5837104: GET /dbapi/v4/run_sql/history/init => 200  
    2024-02-27T16:22:22.213Z [INFO] [RestService] - 18deb5fd-114b-7698-6f9f-b3c704f34258: GET /dbapi/v4/run_sql/builders => 400  
    2024-02-27T16:22:22.215Z [INFO] [RestService] - 18deb5fd-1155-c4b1-b6fd-0d2218376144: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T16:22:22.809Z [WARN] [RestService] - Waiting GET /dbapi/v4/metrics/global/collection_interval/crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A exceeded 10000ms 
    2024-02-27T16:22:22.811Z [ERROR] [ErrorService] - APIError: IBMCONSOLE.ADMIN_SAVED_BUILDER {"req":{"url":"/dbapi/v4/run_sql/builders","requestId":"18deb5fd-114b-7698-6f9f-b3c704f34258","method":"GET","headers":{"X-Request-ID":"18deb5fd-114b-7698-6f9f-b3c704f34258","ucUserID":"********","X-DB-Profile":"crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A","Authorization":"********","Accept":"application/json","Content-Type":"application/json"}},"res":{"status":400,"data":{"trace":"18deb5fd-114b-7698-6f9f-b3c704f34258","errors":[{"code":"database_error","message":"IBMCONSOLE.ADMIN_SAVED_BUILDER","target":{"type":"","name":""},"more_info":"https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00204n.html"}]}}} 
    2024-02-27T16:22:22.840Z [INFO] [RestService] - 18deb5fd-4986-f3b2-5d07-49e5ebc16241: GET /dbapi/v4/users/preference/zny86979/SQLEditor_user_options => 200  
    2024-02-27T16:22:23.061Z [INFO] [RestService] - 18deb5fa-d518-a971-4ced-53c3c3935456: GET /dbapi/v4/metrics/global/collection_interval/crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A => 200  
    2024-02-27T16:22:23.105Z [INFO] [RestService] - 18deb5fd-4bae-b1e1-0efd-1eb14f419178: GET /dbapi/v4/admin/schema-names?rows_return=100 => 200  
    2024-02-27T16:22:23.221Z [INFO] [RestService] - 18deb5fd-4bbb-2bd0-916b-fec968e33840: GET /dbapi/v4/admin/table-like-objects => 200  
    2024-02-27T16:22:23.354Z [INFO] [RestService] - 18deb5fd-6563-e86d-8f4e-18c890a17272: POST /dbapi/v4/run_sql/parser => 200  
    2024-02-27T16:22:32.843Z [INFO] [RestService] - 18deb5fd-5815-7293-9265-d516fc336433: GET /dbapi/v4/users/zny86979?test_connection=false => 200  
    2024-02-27T16:22:32.849Z [INFO] [UserService] - User: {"roles":["bluuser"],"isAdmin":false,"dvRole":"","metadata":null,"formatedIbmid":"deni.lop34@gmail.com","role":"bluuser","iamid":"IBMid-6970004RBW","permittedActions":["view-settings","settings","backup","access","restore","manage-users","clone","scale","monitor","admin-objects","runsql"],"allClean":false,"password":"","iam":true,"name":"","ibmid":"deni.lop34@gmail.com","id":"zny86979","locked":"no","initErrorMsg":"","email":"deni.lop34@gmail.com","authentication":{"method":"internal","policy_id":"Default"}} 
    2024-02-27T16:23:34.785Z [INFO] [RestService] - 18deb60e-d666-d6cd-1b57-338a0ff32202: POST /dbapi/v4/run_sql/parser => 200  
    2024-02-27T16:23:35.598Z [INFO] [RestService] - 18deb60f-0e75-aaf2-28f4-021825312619: POST /dbapi/v4/run_sql/parser => 200  
    2024-02-27T16:23:37.558Z [INFO] [RestService] - 18deb60f-85c1-4232-938a-4f08a4341936: POST /dbapi/v4/run_sql/parser => 200  
    ...123 logs are ignored. 
    2024-02-27T18:02:21.749Z [INFO] [RestService] - 18debbb5-aedc-5567-390d-3a9cf4d29834: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T18:02:21.750Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709056941750 
    2024-02-27T18:06:54.329Z [INFO] [RestService] - 18debbf8-5e3a-4ac5-a79d-b021bd225825: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:06:57.860Z [INFO] [RestService] - 18debbf9-3a7f-1947-2ca2-7b61e6d33628: GET /dbapi/v4/admin/table-like-objects => 200  
    2024-02-27T18:06:58.149Z [INFO] [RestService] - 18debbf9-4fdd-8e9e-e34f-1d415df23547: POST /dbapi/v4/run_sql/parser => 200  
    2024-02-27T18:11:55.155Z [INFO] [RestService] - 18debc41-d107-fa10-c1e1-7bd823f90973: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:12:21.775Z [INFO] [OCRestService] - refresh token by timer at 1709057541775 
    2024-02-27T18:12:22.119Z [INFO] [RestService] - 18debc48-694b-5512-71ab-53471fc28339: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T18:12:22.120Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709057542120 
    2024-02-27T18:16:55.121Z [INFO] [RestService] - 18debc8b-0e7a-d025-5f2f-0d3b2a771740: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:21:55.165Z [INFO] [RestService] - 18debcd4-4c81-08cb-ac0b-4d369b333844: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:22:22.758Z [INFO] [OCRestService] - refresh token by timer at 1709058142758 
    2024-02-27T18:22:24.027Z [INFO] [RestService] - 18debcdb-2298-b5a5-c0b1-880f90b18703: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T18:22:24.028Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709058144028 
    2024-02-27T18:26:55.133Z [INFO] [RestService] - 18debd1d-8a58-39b3-5c3e-f38655345378: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:31:59.220Z [INFO] [RestService] - 18debd67-c376-9023-2ae6-8617f9121734: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:32:24.760Z [INFO] [OCRestService] - refresh token by timer at 1709058744760 
    2024-02-27T18:32:25.503Z [INFO] [RestService] - 18debd6e-1baf-ca3a-493f-847766f40394: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T18:32:25.504Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709058745504 
    2024-02-27T18:36:59.154Z [INFO] [RestService] - 18debdb1-01bb-9738-68b1-33d380a30762: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:41:59.206Z [INFO] [RestService] - 18debdfa-3efc-bbb1-2cf5-39ea6c122321: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:42:25.762Z [INFO] [OCRestService] - refresh token by timer at 1709059345762 
    2024-02-27T18:42:26.118Z [INFO] [RestService] - 18debe00-d658-86c4-49e1-1b8a8cf45614: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T18:42:26.119Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709059346119 
    2024-02-27T18:46:59.188Z [INFO] [RestService] - 18debe43-7d67-8748-2e51-7533fa026326: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:51:59.629Z [INFO] [RestService] - 18debe8c-bb53-acc5-f468-476bbd711054: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T18:52:26.809Z [INFO] [OCRestService] - refresh token by timer at 1709059946809 
    2024-02-27T18:52:27.715Z [INFO] [RestService] - 18debe93-93b3-de55-8e4d-62e565c40141: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T18:52:27.717Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709059947717 
    2024-02-27T18:56:59.145Z [INFO] [RestService] - 18debed5-f89d-bcb7-041d-0cf2dc236186: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:01:59.580Z [INFO] [RestService] - 18debf1f-382b-0b0d-2614-ee2239842686: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:02:27.761Z [INFO] [OCRestService] - refresh token by timer at 1709060547761 
    2024-02-27T19:02:28.282Z [INFO] [RestService] - 18debf26-4b38-8dbd-b9ed-fcccbb919413: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T19:02:28.283Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709060548283 
    2024-02-27T19:06:59.149Z [INFO] [RestService] - 18debf68-74bd-2cf4-6576-6f5942424907: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:11:59.152Z [INFO] [RestService] - 18debfb1-b30e-8644-0e8b-69544f940016: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:12:28.754Z [INFO] [OCRestService] - refresh token by timer at 1709061148754 
    2024-02-27T19:12:29.168Z [INFO] [RestService] - 18debfb9-057d-75cc-015e-a7cec3024913: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T19:12:29.169Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709061149169 
    2024-02-27T19:16:59.286Z [INFO] [RestService] - 18debffa-fb62-57e1-230e-78f860c31056: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:21:59.173Z [INFO] [RestService] - 18dec044-2f9c-455d-4d05-257167628424: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:22:29.768Z [INFO] [OCRestService] - refresh token by timer at 1709061749768 
    2024-02-27T19:22:30.727Z [INFO] [RestService] - 18dec04b-c0c6-ffe3-7ecc-48acb3221351: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T19:22:30.729Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709061750729 
    2024-02-27T19:26:59.206Z [INFO] [RestService] - 18dec08d-6df7-2a26-6bdf-898337d20574: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:31:59.234Z [INFO] [RestService] - 18dec0d6-ab53-c0d5-c1bc-a6012f230265: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:32:30.762Z [INFO] [OCRestService] - refresh token by timer at 1709062350762 
    2024-02-27T19:32:31.097Z [INFO] [RestService] - 18dec0de-7ad7-8a21-1f89-c79b92125519: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T19:32:31.098Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709062351098 
    2024-02-27T19:36:59.157Z [INFO] [RestService] - 18dec11f-e91d-50d7-5b32-f28fc4526623: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:41:59.230Z [INFO] [RestService] - 18dec169-284d-aa14-7136-e2bb2d345870: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:42:31.754Z [INFO] [OCRestService] - refresh token by timer at 1709062951754 
    2024-02-27T19:42:32.496Z [INFO] [RestService] - 18dec171-34e2-7fa9-99b1-27029c936470: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T19:42:32.497Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709062952497 
    2024-02-27T19:46:59.177Z [INFO] [RestService] - 18dec1b2-6631-c0d7-b41b-884932c27644: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:51:59.176Z [INFO] [RestService] - 18dec1fb-a354-f130-c5d4-22e0e8828031: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T19:52:32.764Z [INFO] [OCRestService] - refresh token by timer at 1709063552764 
    2024-02-27T19:52:33.514Z [INFO] [RestService] - 18dec203-f007-5b84-c252-2b0722f41529: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T19:52:33.515Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709063553515 
    2024-02-27T19:56:59.132Z [INFO] [RestService] - 18dec244-e252-f992-bdf2-e81013078382: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:01:59.119Z [INFO] [RestService] - 18dec28e-1ec3-a335-ef54-cc0303729515: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:02:33.756Z [INFO] [OCRestService] - refresh token by timer at 1709064153756 
    2024-02-27T20:02:34.565Z [INFO] [RestService] - 18dec296-a9d4-316a-5f5e-6d4fa1020289: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T20:02:34.565Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709064154565 
    2024-02-27T20:06:59.234Z [INFO] [RestService] - 18dec2d7-5dfe-3bc2-7743-51f515c34529: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:11:59.194Z [INFO] [RestService] - 18dec320-9b7f-febd-d632-d36d55e30203: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:12:34.752Z [INFO] [OCRestService] - refresh token by timer at 1709064754752 
    2024-02-27T20:12:35.125Z [INFO] [RestService] - 18dec329-641e-240a-1dd2-383484332815: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T20:12:35.125Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709064755125 
    2024-02-27T20:16:59.116Z [INFO] [RestService] - 18dec369-da2f-3bdb-98df-a3ab1fa11758: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:21:59.203Z [INFO] [RestService] - 18dec3b3-1737-155a-ef68-d2508f642807: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:22:35.761Z [INFO] [OCRestService] - refresh token by timer at 1709065355761 
    2024-02-27T20:22:37.045Z [INFO] [RestService] - 18dec3bc-1f43-868a-eb3d-0d36b1f95260: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T20:22:37.047Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709065357047 
    2024-02-27T20:26:59.154Z [INFO] [RestService] - 18dec3fc-557f-c1f4-f4e6-cc710ab30145: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:31:59.139Z [INFO] [RestService] - 18dec445-9425-3a06-85f7-04ead8611808: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:32:37.754Z [INFO] [OCRestService] - refresh token by timer at 1709065957754 
    2024-02-27T20:32:38.317Z [INFO] [RestService] - 18dec44f-17dd-0e61-5776-8c9e30021935: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T20:32:38.318Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709065958318 
    2024-02-27T20:36:59.585Z [INFO] [RestService] - 18dec48e-d1de-48b2-dc11-766f20117785: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:41:59.353Z [INFO] [RestService] - 18dec4d8-101c-6143-22c4-42d37c435276: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:42:38.757Z [INFO] [OCRestService] - refresh token by timer at 1709066558757 
    2024-02-27T20:42:39.419Z [INFO] [RestService] - 18dec4e1-d28e-7782-82ea-530bb3e24409: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T20:42:39.421Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709066559421 
    2024-02-27T20:46:59.184Z [INFO] [RestService] - 18dec521-4cf9-107c-f0a5-65b9ada12832: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:51:59.140Z [INFO] [RestService] - 18dec56a-8b85-33ad-4fa7-be1125c32101: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T20:52:39.752Z [INFO] [OCRestService] - refresh token by timer at 1709067159752 
    2024-02-27T20:52:40.623Z [INFO] [RestService] - 18dec574-8cae-ec46-66a8-0813c9e32509: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T20:52:40.627Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709067160627 
    2024-02-27T20:56:59.162Z [INFO] [RestService] - 18dec5b3-cb1d-e6dd-f7b1-665acd838796: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:01:59.210Z [INFO] [RestService] - 18dec5fd-06d9-5441-682a-1c005ab27467: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:02:40.754Z [INFO] [OCRestService] - refresh token by timer at 1709067760754 
    2024-02-27T21:02:41.707Z [INFO] [RestService] - 18dec607-477b-4703-6d42-b37dd6915194: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T21:02:41.709Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709067761709 
    2024-02-27T21:06:59.192Z [INFO] [RestService] - 18dec646-475b-7afb-67f3-b6cbff951810: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:11:59.138Z [INFO] [RestService] - 18dec68f-83d9-9f3c-6d6f-fc9790034160: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:12:41.764Z [INFO] [OCRestService] - refresh token by timer at 1709068361764 
    2024-02-27T21:12:42.421Z [INFO] [RestService] - 18dec69a-0293-0c59-232c-3b3b8d738769: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T21:12:42.422Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709068362422 
    2024-02-27T21:16:59.127Z [INFO] [RestService] - 18dec6d8-c30e-7214-0eee-9adb61434555: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:21:59.661Z [INFO] [RestService] - 18dec721-ff8a-3360-4eb9-c5bd34535031: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:22:42.763Z [INFO] [OCRestService] - refresh token by timer at 1709068962763 
    2024-02-27T21:22:43.390Z [INFO] [RestService] - 18dec72c-bd4f-b76e-5502-47a075d29082: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T21:22:43.392Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709068963392 
    2024-02-27T21:26:54.734Z [INFO] [RestService] - 18dec76a-2bbb-b8d1-0a9c-3ac0bd033437: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:31:55.343Z [INFO] [RestService] - 18dec7b3-80a5-e5eb-4309-51badb318493: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:32:42.018Z [INFO] [RestService] - 18dec7be-e22d-ba5f-452a-db80ddc20282: POST /dbapi/v4/run_sql/sql_jobs => 201  
    2024-02-27T21:32:43.302Z [INFO] [RestService] - 18dec7bf-49ad-50d0-99fb-9fd8c6437974: GET /dbapi/v4/run_sql/sql_jobs/1709069561520_1076215927 => 200  
    2024-02-27T21:32:43.396Z [INFO] [OCRestService] - refresh token by timer at 1709069563396 
    2024-02-27T21:32:43.653Z [INFO] [RestService] - 18dec7bf-604a-3356-27a2-3fc476117853: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T21:32:43.663Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709069563663 
    2024-02-27T21:32:43.777Z [INFO] [RestService] - 18dec7bf-5ac4-deda-205f-a58928630947: GET /dbapi/v4/admin/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA/definition => 200  
    2024-02-27T21:36:55.285Z [INFO] [RestService] - 18dec7fc-be1c-5670-de23-177177634383: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:41:55.020Z [INFO] [RestService] - 18dec845-e685-8c20-a526-336d74d22959: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:42:14.321Z [INFO] [RestService] - 18dec84a-a0c7-651d-1ace-ab1a17c16910: GET /dbapi/v4/admin/tablespaces?name_only=true => 200  
    2024-02-27T21:42:14.353Z [INFO] [RestService] - 18dec84a-a0b6-7c13-0f55-a2065e015099: GET /dbapi/v4/schemas => 200  
    2024-02-27T21:42:17.527Z [INFO] [RestService] - 18dec84b-6b07-25fb-88a7-31c985099817: GET /dbapi/v4/schemas/ZNY86979/tables => 200  
    2024-02-27T21:42:21.402Z [INFO] [RestService] - 18dec84c-5bf8-2040-e1d5-4687ab470267: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA => 200  
    2024-02-27T21:42:43.669Z [INFO] [OCRestService] - refresh token by timer at 1709070163669 
    2024-02-27T21:42:44.583Z [INFO] [RestService] - 18dec851-eda9-13d4-91eb-f27dd7d10209: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T21:42:44.584Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709070164584 
    2024-02-27T21:43:56.401Z [INFO] [RestService] - 18dec863-7d76-915e-34c5-60068b240733: POST /dbapi/v4/load_jobs => 500  
    2024-02-27T21:43:56.419Z [ERROR] [ErrorService] - APIError: IBMCONSOLE.ADMIN_TASK_HISTORY {"req":{"url":"/dbapi/v4/load_jobs","requestId":"18dec863-7d76-915e-34c5-60068b240733","method":"POST","headers":{"X-Request-ID":"18dec863-7d76-915e-34c5-60068b240733","ucUserID":"********","X-DB-Profile":"crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A","Authorization":"********","Accept":"application/json","Content-Type":"application/json"},"data":{"cloud_source":{"endpoint":"","path":"","auth_id":"********","auth_secret":"********"},"load_action":"INSERT","load_source":"SERVER","max_warning_count":1000,"schema":"ZNY86979","server_source":{"file_path":"ChicagoCrimeData.csv"},"stream_source":{"file_name":""},"file_options":{"has_header_row":"no","column_delimiter":",","code_page":"********","date_format":"YYYY-MM-DD","time_format":"HH:MM:SS","timestamp_format":"YYYY-MM-DD HH:MM:SS","date_delimiter":"-","time_delimiter":":","date_style":"","time_style":"","encoding":"1208","null_value":"","escape_char":""},"table":"CHICAGO_CRIME_DATA","userid":"********","columns":{"0":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"ID","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"1":{"type_name":"VARCHAR","type_precision":8,"comments":"","nullable":"yes","generated":"","name":"CASE_NUMBER","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"2":{"type_name":"DATE","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"DATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"3":{"type_name":"VARCHAR","type_precision":35,"comments":"","nullable":"yes","generated":"","name":"BLOCK","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"4":{"type_name":"VARCHAR","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"IUCR","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"5":{"type_name":"VARCHAR","type_precision":33,"comments":"","nullable":"yes","generated":"","name":"PRIMARY_TYPE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"6":{"type_name":"VARCHAR","type_precision":46,"comments":"","nullable":"yes","generated":"","name":"DESCRIPTION","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"7":{"type_name":"VARCHAR","type_precision":33,"comments":"","nullable":"yes","generated":"","name":"LOCATION_DESCRIPTION","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"8":{"type_name":"VARCHAR","type_precision":5,"comments":"","nullable":"yes","generated":"","name":"ARREST","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"9":{"type_name":"VARCHAR","type_precision":5,"comments":"","nullable":"yes","generated":"","name":"DOMESTIC","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"10":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"BEAT","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"11":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"DISTRICT","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"12":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"WARD","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"13":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"COMMUNITY_AREA_NUMBER","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"14":{"type_name":"VARCHAR","type_precision":3,"comments":"","nullable":"yes","generated":"","name":"FBICODE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"15":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"X_COORDINATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"16":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"Y_COORDINATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"17":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"YEAR","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"18":{"type_name":"DECIMAL","type_precision":18,"comments":"","nullable":"yes","generated":"","name":"LATITUDE","type_scale":8,"type_string_codeunit":"********","type_modifier":""},"19":{"type_name":"DECIMAL","type_precision":18,"comments":"","nullable":"yes","generated":"","name":"LONGITUDE","type_scale":8,"type_string_codeunit":"********","type_modifier":""},"20":{"type_name":"VARCHAR","type_precision":29,"comments":"","nullable":"yes","generated":"","name":"LOCATION","type_scale":0,"type_string_codeunit":"********","type_modifier":""}}}},"res":{"status":500,"data":{"trace":"18dec863-7d76-915e-34c5-60068b240733","errors":[{"code":"database_error","message":"IBMCONSOLE.ADMIN_TASK_HISTORY","target":{"type":"","name":""},"more_info":"https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00204n.html"}]}}} 
    2024-02-27T21:47:40.944Z [INFO] [RestService] - 18dec89a-5855-8ab3-dbb5-cb6fe7a12992: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:47:49.033Z [INFO] [RestService] - 18dec89c-67ea-2758-2cd2-4762b6f15630: GET /dbapi/v4/run_sql/scripts => 200  
    2024-02-27T21:52:44.588Z [INFO] [OCRestService] - refresh token by timer at 1709070764588 
    2024-02-27T21:52:45.236Z [INFO] [RestService] - 18dec8e4-a2fa-2307-df65-04ad23f32174: GET /dbapi/v4/iam/token/refresh => 200  
    2024-02-27T21:52:45.237Z [INFO] [OCRestService] - IAM user, start token refreshing service at 1709070765237 
    2024-02-27T21:53:17.457Z [INFO] [RestService] - 18dec8ec-6f6b-b397-7816-0ebfa8326821: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA => 200  
    2024-02-27T21:53:17.942Z [INFO] [RestService] - 18dec8ec-ac14-7956-827e-24839df27421: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA/data?_limit=50 => 200  
    2024-02-27T21:53:22.180Z [INFO] [RestService] - 18dec8ed-b84b-e842-2ce9-c9eb0af36899: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA => 200  
    2024-02-27T21:53:22.638Z [INFO] [RestService] - 18dec8ed-d0ee-2454-c3e4-026d8ac41076: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA/data?_limit=50 => 200  
    2024-02-27T21:53:49.102Z [INFO] [RestService] - 18dec8f4-4745-48be-087b-cc1217b25725: GET /dbapi/v4/schemas => 200  
    2024-02-27T21:53:49.138Z [INFO] [RestService] - 18dec8f4-477b-c312-c873-6fd86b722799: GET /dbapi/v4/admin/tablespaces?name_only=true => 200  
    2024-02-27T21:53:52.849Z [INFO] [RestService] - 18dec8f5-211b-ad5a-98c8-e9c6fe242139: GET /dbapi/v4/schemas/ZNY86979/tables => 200  
    2024-02-27T21:53:59.463Z [INFO] [RestService] - 18dec8f6-cbf6-73ef-c7cf-7a326ba47408: GET /dbapi/v4/schemas/ZNY86979/tables => 200  
    2024-02-27T21:54:04.428Z [INFO] [RestService] - 18dec8f8-072b-5612-cd06-86b7ef612031: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA => 200  
    2024-02-27T21:54:52.909Z [INFO] [RestService] - 18dec903-d6e3-43e9-4e4b-3a1473f23608: GET /dbapi/v4/schemas => 200  
    2024-02-27T21:54:53.006Z [INFO] [RestService] - 18dec903-d6fb-74a8-ae1d-aa73e2137014: GET /dbapi/v4/admin/tablespaces?name_only=true => 200  
    2024-02-27T21:55:25.250Z [INFO] [RestService] - 18dec90b-be07-f661-d0a2-50aa4b942715: GET /dbapi/v4/admin/tablespaces?name_only=true => 200  
    2024-02-27T21:55:25.549Z [INFO] [RestService] - 18dec90b-be05-b860-0056-c4ea98231221: GET /dbapi/v4/schemas => 200  
    2024-02-27T21:58:23.707Z [INFO] [RestService] - 18dec937-3ec1-9b1d-5c88-1b8b8f439339: POST /dbapi/v4/load_jobs => 500  
    2024-02-27T21:58:23.729Z [ERROR] [ErrorService] - APIError: IBMCONSOLE.ADMIN_TASK_HISTORY {"req":{"url":"/dbapi/v4/load_jobs","requestId":"18dec937-3ec1-9b1d-5c88-1b8b8f439339","method":"POST","headers":{"X-Request-ID":"18dec937-3ec1-9b1d-5c88-1b8b8f439339","ucUserID":"********","X-DB-Profile":"crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A","Authorization":"********","Accept":"application/json","Content-Type":"application/json"},"data":{"cloud_source":{"endpoint":"","path":"","auth_id":"********","auth_secret":"********"},"load_action":"INSERT","load_source":"SERVER","max_warning_count":1000,"schema":"ZNY86979","server_source":{"file_path":"ChicagoCrimeData.csv"},"stream_source":{"file_name":""},"file_options":{"has_header_row":"no","column_delimiter":",","code_page":"********","date_format":"YYYY-MM-DD","time_format":"HH:MM:SS","timestamp_format":"YYYY-MM-DD HH:MM:SS","date_delimiter":"-","time_delimiter":":","date_style":"","time_style":"","encoding":"1208","null_value":"","escape_char":""},"table":"CHICAGO_CRIME_DATA","userid":"********","columns":{"0":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"ID","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"1":{"type_name":"VARCHAR","type_precision":8,"comments":"","nullable":"yes","generated":"","name":"CASE_NUMBER","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"2":{"type_name":"DATE","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"DATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"3":{"type_name":"VARCHAR","type_precision":35,"comments":"","nullable":"yes","generated":"","name":"BLOCK","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"4":{"type_name":"VARCHAR","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"IUCR","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"5":{"type_name":"VARCHAR","type_precision":33,"comments":"","nullable":"yes","generated":"","name":"PRIMARY_TYPE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"6":{"type_name":"VARCHAR","type_precision":46,"comments":"","nullable":"yes","generated":"","name":"DESCRIPTION","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"7":{"type_name":"VARCHAR","type_precision":33,"comments":"","nullable":"yes","generated":"","name":"LOCATION_DESCRIPTION","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"8":{"type_name":"VARCHAR","type_precision":5,"comments":"","nullable":"yes","generated":"","name":"ARREST","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"9":{"type_name":"VARCHAR","type_precision":5,"comments":"","nullable":"yes","generated":"","name":"DOMESTIC","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"10":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"BEAT","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"11":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"DISTRICT","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"12":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"WARD","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"13":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"COMMUNITY_AREA_NUMBER","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"14":{"type_name":"VARCHAR","type_precision":3,"comments":"","nullable":"yes","generated":"","name":"FBICODE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"15":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"X_COORDINATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"16":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"Y_COORDINATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"17":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"YEAR","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"18":{"type_name":"DECIMAL","type_precision":18,"comments":"","nullable":"yes","generated":"","name":"LATITUDE","type_scale":8,"type_string_codeunit":"********","type_modifier":""},"19":{"type_name":"DECIMAL","type_precision":18,"comments":"","nullable":"yes","generated":"","name":"LONGITUDE","type_scale":8,"type_string_codeunit":"********","type_modifier":""},"20":{"type_name":"VARCHAR","type_precision":29,"comments":"","nullable":"yes","generated":"","name":"LOCATION","type_scale":0,"type_string_codeunit":"********","type_modifier":""}}}},"res":{"status":500,"data":{"trace":"18dec937-3ec1-9b1d-5c88-1b8b8f439339","errors":[{"code":"database_error","message":"IBMCONSOLE.ADMIN_TASK_HISTORY","target":{"type":"","name":""},"more_info":"https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00204n.html"}]}}} 
    2024-02-27T21:59:52.516Z [INFO] [RestService] - 18dec94c-ffde-62b1-a21f-fc764f726870: GET /dbapi/v4/admin/tablespaces?name_only=true => 200  
    2024-02-27T21:59:52.531Z [INFO] [RestService] - 18dec94c-ffd9-76b7-8cf9-46f7b9d19254: GET /dbapi/v4/schemas => 200  
    2024-02-27T21:59:55.114Z [INFO] [RestService] - 18dec94d-a366-d070-7cb5-360bfce42010: GET /dbapi/v4/schemas/ZNY86979/tables => 200  
    2024-02-27T21:59:59.131Z [INFO] [RestService] - 18dec94e-9f45-9f1d-d996-c73809369755: GET /dbapi/v4/schemas/ZNY86979/tables/CHICAGO_CRIME_DATA => 200  
    2024-02-27T22:01:27.787Z [INFO] [RestService] - 18dec964-329d-73d5-8aee-8759ffc12462: POST /dbapi/v4/load_jobs => 500  
    2024-02-27T22:01:27.795Z [ERROR] [ErrorService] - APIError: IBMCONSOLE.ADMIN_TASK_HISTORY {"req":{"url":"/dbapi/v4/load_jobs","requestId":"18dec964-329d-73d5-8aee-8759ffc12462","method":"POST","headers":{"X-Request-ID":"18dec964-329d-73d5-8aee-8759ffc12462","ucUserID":"********","X-DB-Profile":"crn%3Av1%3Abluemix%3Apublic%3Adashdb-for-transactions%3Aus-south%3Aa%2F3651d875d2124a46a5035a8f2e902f98%3Acfae0420-6c59-4007-9463-183c91e59269%3A%3A","Authorization":"********","Accept":"application/json","Content-Type":"application/json"},"data":{"cloud_source":{"endpoint":"","path":"","auth_id":"********","auth_secret":"********"},"load_action":"REPLACE","load_source":"SERVER","max_warning_count":1000,"schema":"ZNY86979","server_source":{"file_path":"ChicagoCrimeData.csv"},"stream_source":{"file_name":""},"file_options":{"has_header_row":"no","column_delimiter":",","code_page":"********","date_format":"YYYY-MM-DD","time_format":"HH:MM:SS","timestamp_format":"YYYY-MM-DD HH:MM:SS","date_delimiter":"-","time_delimiter":":","date_style":"","time_style":"","encoding":"1208","null_value":"","escape_char":""},"table":"CHICAGO_CRIME_DATA","userid":"********","columns":{"0":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"ID","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"1":{"type_name":"VARCHAR","type_precision":8,"comments":"","nullable":"yes","generated":"","name":"CASE_NUMBER","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"2":{"type_name":"DATE","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"DATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"3":{"type_name":"VARCHAR","type_precision":35,"comments":"","nullable":"yes","generated":"","name":"BLOCK","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"4":{"type_name":"VARCHAR","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"IUCR","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"5":{"type_name":"VARCHAR","type_precision":33,"comments":"","nullable":"yes","generated":"","name":"PRIMARY_TYPE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"6":{"type_name":"VARCHAR","type_precision":46,"comments":"","nullable":"yes","generated":"","name":"DESCRIPTION","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"7":{"type_name":"VARCHAR","type_precision":33,"comments":"","nullable":"yes","generated":"","name":"LOCATION_DESCRIPTION","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"8":{"type_name":"VARCHAR","type_precision":5,"comments":"","nullable":"yes","generated":"","name":"ARREST","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"9":{"type_name":"VARCHAR","type_precision":5,"comments":"","nullable":"yes","generated":"","name":"DOMESTIC","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"10":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"BEAT","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"11":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"DISTRICT","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"12":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"WARD","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"13":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"COMMUNITY_AREA_NUMBER","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"14":{"type_name":"VARCHAR","type_precision":3,"comments":"","nullable":"yes","generated":"","name":"FBICODE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"15":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"X_COORDINATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"16":{"type_name":"INTEGER","type_precision":4,"comments":"","nullable":"yes","generated":"","name":"Y_COORDINATE","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"17":{"type_name":"SMALLINT","type_precision":2,"comments":"","nullable":"yes","generated":"","name":"YEAR","type_scale":0,"type_string_codeunit":"********","type_modifier":""},"18":{"type_name":"DECIMAL","type_precision":18,"comments":"","nullable":"yes","generated":"","name":"LATITUDE","type_scale":8,"type_string_codeunit":"********","type_modifier":""},"19":{"type_name":"DECIMAL","type_precision":18,"comments":"","nullable":"yes","generated":"","name":"LONGITUDE","type_scale":8,"type_string_codeunit":"********","type_modifier":""},"20":{"type_name":"VARCHAR","type_precision":29,"comments":"","nullable":"yes","generated":"","name":"LOCATION","type_scale":0,"type_string_codeunit":"********","type_modifier":""}}}},"res":{"status":500,"data":{"trace":"18dec964-329d-73d5-8aee-8759ffc12462","errors":[{"code":"database_error","message":"IBMCONSOLE.ADMIN_TASK_HISTORY","target":{"type":"","name":""},"more_info":"https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql00204n.html"}]}}} 


    ------------------------------
    Denise Meneses Lopez
    ------------------------------



  • 4.  RE: IBMCONSOLE.ADMIN_TASK_HISTORY