cloud-native-toolkit / terraform-gitops-cp-sterling-oms

Module tp populate a gitops repo with the resources to provision cp-sterling-oms
Apache License 2.0
0 stars 0 forks source link

ROKS POD - DB2 : Connection Pool #7

Closed balasgit closed 2 years ago

balasgit commented 2 years ago

OMS is trying to connect to dB2 but db2 connection pool is failing..

ACtions Taken: Validated the db2 is accessible from MacOS but not sure why the connections between OMS and DB2.

Need to debug if ports needs to be opened since its VPC

 [java] 2022-04-15 04:57:52,601:ERROR  :main: [1649998672600]Error_description_not_available               [system]: [dbf8d6d3-8145-4d1b-a653-654b3c2a582b]: [ ]: OMPExtensionPointInitializer
 [java] 2022-04-15 04:57:52,614:ERRORDTL:main: [1649998672600]<?xml version="1.0" encoding="UTF-8"?>
 [java] <Errors>
 [java]     <Error ErrorCode="YFC0003"
 [java]         ErrorDescription="Error_description_not_available" ErrorRelatedMoreInfo="">
 [java]         <Attribute Name="ErrorCode" Value="YFC0003"/>
 [java]         <Attribute Name="ErrorDescription" Value="Error_description_not_available"/>
 [java]         <Error ErrorCode="java.sql.SQLException" ErrorDescription="" ErrorRelatedMoreInfo="Not able to get a Connection for db2Pool">
 [java]             <Stack>java.sql.SQLException: Not able to get a Connection for db2Pool
 [java]     at com.yantra.interop.util.TransactionWrapper.getConnection(TransactionWrapper.java:113)
balasgit commented 2 years ago

Resolved the db connection pools issues and data is loading properly