Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  IBMCONSOLE.ADMIN_TASK_HISTORY

    Posted 02/27/24 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 02/28/24 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 02/29/24 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
    ------------------------------

    Original Message


  • 4.  RE: IBMCONSOLE.ADMIN_TASK_HISTORY

    Posted 03/01/24 10:24 AM

    Hello Denise,

    Are you loading a CSV file or another kind of file?

    How big is the size of the file that you are loading?   If the file is too big, have you tried with a smaller file to see if you still have the issue?

    The reason that I am asking you that is because we had a similar issue where customer was trying to load a CSV over 500MB.

    If you have the same issue with a smaller file, please create a case for further investigation.



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

    Original Message


Related Content