Skip to main content
suryawanshinp
Silver ⭐️
February 10, 2023
Question

CDP data warehousing catalog creation error

Hi Team,

We have CDP cluster integrated with OpenShift cluster, private cloud setup with all the service like hive, atlas, ranger running. 

When we are creating the Datawarehouse CatLog in management console we are getting the below error in console, can you please help us to find out the cause.

some Errors from management console: 

1. Driver failed to create DB Catalog: IP address is not expected for default warheouse RDS endpoint. Check if RDS is enabled in the env? Error Code : 9999

2. timeout exceeded transitioning from state 'Starting'.Last event: {InProgress checking if metastore statefulset is ready with at least 1 ready replica(s) (config-id: 5afc7144-9409-47e2-a9b9-2c7822adafbf version: 2022.0.7.1-2) 2023-02-09 10:08:44.366274685 +0000 UTC} Error Code : 9999

OpenShift pods log:

/usr/local/bin/config-merger /tmp/hive/conf/atlas-application.properties /mnt/config/current/atlas-application.properties /etc/hive/conf/atlas-application.properties -wf2 atlas.rest.address -wf2 atlas.kafka.bootstrap.servers -wf2 atlas.kafka.zookeeper.sync.time.ms -wf2 atlas.kafka.security.protocol -wf2 atlas.enableTLS -wf2 atlas.jaas.KafkaClient.option.principal -wf2 atlas.jaas.KafkaClient.option.serviceName -wf2 atlas.kafka.sasl.kerberos.service.name -setfromparams atlas.jaas.KafkaClient.option.principal=$+SERVICE_PRINCIPAL -set truststore.file=/mnt/config/current/truststore.jks -set atlas.kafka.ssl.truststore.location=/mnt/config/current/truststore.jks -set hadoop.security.credential.provider.path=localjceks://file/jceks/secrets.jceks -set truststore.password=changeit -set cert.stores.credential.provider.path=localjceks://file/jceks/secrets.jceks -set atlas.jaas.KafkaClient.option.keyTab=/mnt/config/current/hive

4 replies

aakulov
Platinum ⭐️
Platinum ⭐️
February 12, 2023

Hi @suryawanshinp , 
Looks like the error you list in point (1) can potentially be due to your external postresDB database using an IP address instead of the hostname. Please consult the documentation here: https://docs.cloudera.com/cdp-private-cloud-data-services/1.5.0/installation/topics/cdppvc-installation-external-db-setup.html

 

 

Kind regards,

Alex

 

Translate
suryawanshinp
Silver ⭐️
February 20, 2023

@aakulov  : Yes, external postgress DB database configured with IP address as per document link provided, we changed it to hostname . but still getting same error. no luck.

Translate
aakulov
Platinum ⭐️
Platinum ⭐️
February 23, 2023

I would suggest working with Cloudera support on this, as they would be best suited for analyzing logs and suggesting next steps.

Translate
DianaTorres
Community Manager
Community Manager
February 16, 2023

@suryawanshinp Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks

Translate
Regards, Diana Torres, Senior Community Moderator