IBMCONSOLE.ADMIN_TASK_HISTORY

View Only

Expand all | Collapse all

IBMCONSOLE.ADMIN_TASK_HISTORY

1. IBMCONSOLE.ADMIN_TASK_HISTORY

0 Like
Denise Meneses Lopez
Posted Tue February 27, 2024 01:27 PM

Reply
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

0 Like
Cintia Ogura
Posted Wed February 28, 2024 09:33 AM

Reply
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
------------------------------

Original Message

3. RE: IBMCONSOLE.ADMIN_TASK_HISTORY

Like

Denise Meneses Lopez

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
------------------------------

Original Message

4. RE: IBMCONSOLE.ADMIN_TASK_HISTORY

Like

Cintia Ogura

Posted Fri March 01, 2024 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

Original Message:
Sent: Thu February 29, 2024 11:16 PM
From: Denise Meneses Lopez
Subject: IBMCONSOLE.ADMIN_TASK_HISTORY

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:
Sent: Wed February 28, 2024 09:32 AM
From: Cintia Ogura
Subject: IBMCONSOLE.ADMIN_TASK_HISTORY

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

Original Message:
Sent: Tue February 27, 2024 12:26 PM
From: Denise Meneses Lopez
Subject: IBMCONSOLE.ADMIN_TASK_HISTORY

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
------------------------------

IBM Data Management Community

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

Db2