Db2

 View Only

 HWCCON0037E error in DMC while creating an blackout event

Roland Schock's profile image
Roland Schock IBM Champion posted Thu March 20, 2025 12:53 PM

Hi @Cintia Ogura,

while trying to create an blackout event for one of our servers I got following error.

I found a technote, which suggested to modify the LIBPATH in some addons/job-scheduler, but the error does not change. What information should I save, or what can be done to fix this issue in DMC 3.13.1?

2025-03-20T12:53:45.632Z [ERROR] [ErrorService] - APIError: HWCCON0037E: Failed to perform this operation due to an internal error, IOException occurs while converting connection profile to JSON format. {"req":{"url":"/dbapi/v4/blackouts","requestId":"195b39de-9f33-a1dd-4086-3ffa05b91128","method":"POST","headers":{"X-Request-ID":"195b39de-9f33-a1dd-4086-3ffa05b91128","ucUserID":"********","X-DB-Profile":"undefined","Authorization":"********","Accept":"application/json","Content-Type":"application/json"},"data":{"name":"ProdMig","description":"","job_type":"BLACKOUT","category":"scheduled","schedule_info":{"startOn":1742302620000,"endOn":0,"repeat":false,"schedule":"","time_offset":1,"timezone":"Europe/Berlin"},"conn_profiles":{},"configuration":{"blackout":"true","blackout_type":"full_blackout","blackout_duration_in_seconds":180180,"profiles":{"0":"DWH-Server"}},"schedule_enabled":true,"notification_info":{"0":{"enableSNMP":false,"enableEmail":"********","recipients":{}}}}},"res":{"status":400,"data":{"trace":"195b39de-9f33-a1dd-4086-3ffa05b91128","errors":[{"code":"db_profile_error","message":"HWCCON0037E: Failed to perform this operation due to an internal error, IOException occurs while converting connection profile to JSON format.","target":{"type":"field","name":"name"},"more_info":""}]}}}

Cheers

Roland

Cintia Ogura's profile image
Cintia Ogura posted Thu March 20, 2025 01:14 PM

Hello Roland,

Question, are you using V3.1.13 or V3.1.13.1?

In your post you said 3.13.1, so I am not sure exactly the DMC version or OS that you are using.

If you are using V3.1.13.1, please create a case so I can investigate further.

If you are using V3.1.13, please upgrade your DMC to the latest V3.1.13.1, as this is a known issue in V3.1.13 (that's why we released the new version after a few days).

Roland Schock's profile image
Roland Schock IBM Champion posted Fri March 28, 2025 04:14 AM

Hi @Cintia Ogura, 

sorry about the late reply. I was only today able to check at the customer. Well it is already version 3.1.13.1 (20250204-092628) Enterprise.

So I have to raise a ticket then.

Cheers

Roland

Cintia Ogura's profile image
Cintia Ogura posted Mon March 31, 2025 02:50 PM

Hello Roland,

Thank you for creating the case, I checked the collector files and the job server is not able to connect to the repository database because of the following error: SQL30082N Security processing failed with reason "17".

We do not support AUTHENTICATION TYPE = SERVER_ENCRYPT anymore.

Please follow the instructions from the following link:

https://www.ibm.com/support/pages/received-sql30082n-rc17-error-when-server-has-authentication-type-serverencrypt

Edit the repository database and click on save to save the new information, then restart DMC.

I asked the case owner to update the case, but I am also posting here in case other people hits the same issue as I am seeing several customers opening similar cases.

I hope that helps!

Related Content