Unable to add a new data source which has encrypted communication

1

Hi ,

Getting below error in tema.log file:

ERROR: Database connection error for database ‘BFENT’ on host ‘HOSTNAME’: Java::ComIbmDb2JccAm::DisconnectNonTransientException: [jcc][t4][2034][11148][4.28.11] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
Line 282: A DRDA Data Stream Syntax Error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009
Line 283: [1/9/23 7:55:04:896 UTC] 00000055 SystemOut O 2023-01-09 07:55:04 ERROR: RECOMMENDED USER ACTION: Unreachable Database. Check your database name or host connection. It looks like the configuration you have provided is incorrect.
Line 284: [1/9/23 7:55:04:975 UTC] 00000055 SystemOut O 2023-01-09 07:55:04 ERROR: Datasource validation: Java::ComIbmDb2JccAm::DisconnectNonTransientException: [jcc][t4][2034][11148][4.28.11] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
Line 285: A DRDA Data Stream Syntax Error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009
Line 286: [1/9/23 7:55:05:091 UTC] 00000055 SystemOut O 2023-01-09 07:55:05 ERROR: Database connection error for database ‘BESREPOR’ on host ‘HOSTNAME’: Java::ComIbmDb2JccAm::DisconnectNonTransientException: [jcc][t4][2034][11148][4.28.11] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
Line 287: A DRDA Data Stream Syntax Error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009
Line 288: [1/9/23 7:55:05:093 UTC] 00000055 SystemOut O 2023-01-09 07:55:05 ERROR: RECOMMENDED USER ACTION: Unreachable Database. Check your database name or host connection. It looks like the configuration you have provided is incorrect.
Line 290: [1/9/23 7:55:05:639 UTC] 00000055 SystemOut O 2023-01-09 07:55:05 ERROR: Database connection error for database ‘BFENT’ on host ‘HOSTNAME’: Java::ComIbmDb2JccAm::DisconnectNonTransientException: [jcc][t4][2034][11148][4.28.11] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
Line 291: A DRDA Data Stream Syntax Error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009
Line 292: [1/9/23 7:55:05:640 UTC] 00000055 SystemOut O 2023-01-09 07:55:05 ERROR: RECOMMENDED USER ACTION: Unreachable Database. Check your database name or host connection. It looks like the configuration you have provided is incorrect.

Please suggest how we can resolve the issue ?

2

The error is “unreachable database”, so start tracking down from the BFI/ILMT server the connection the the data source - can you ping; can you open connection; can you connect with the provided credentials (try manually outside of BFI/ILMT).

1 Like