Skip to main content

My customer with remote deployment copied DB from TEST and replaced their DEV with.
According to instructions they exported the IFSIAMSYS schema from DEV before the copy and then imported it again after the copy.

The odata pods are not coming up after the clone.
Some errors from odata log:
Container initiated at Mon May 23 12:58:27 UTC 2022
SECRETIMAGE_VERSION=Mon Feb 7 04:36:03 UTC 2022 1.0.4
ALPINE_VERSION=Mon Feb 7 04:36:03 UTC 2022 3.14.3
BASEIMAGE_VERSION=Mon Feb 7 04:36:03 UTC 2022 1.0.22
CERTIFICATE_HANDLER_VERSION=Mon Feb 7 04:37:44 UTC 2022 1.0.4
JAVAIMAGE_VERSION=Mon Feb 7 04:37:44 UTC 2022 1.0.26
JDBC_DRIVER_VERSION=Mon Feb 7 04:39:15 UTC 2022 1.0.28
OPENLIBERTYIMAGE_VERSION=Mon Feb 7 04:39:15 UTC 2022 1.0.28
Using API to fetch certificates
curl: (7) Failed to connect to kubernetes.default.svc port 443 after 1 ms: Connection refused

.

"FFDC1015I: An FFDC Incident has been created: \"java.lang.NoClassDefFoundError: Ljavax\/enterprise\/concurrent\/ManagedExecutorService; com.ibm.ws.injectionengine.InjectionProcessorManager.getAllDeclaredFields 249\" at ffdc_22.05.23_12.59.18.0.log","ibm_threadId":"00000029","ibm_datetime":"2022-05-23T12:59:18.837+0000","ibm_messageId":"FFDC1015I","module":"com.ibm.ws.logging.internal.impl.IncidentImpl","loglevel":"INFO","ibm_sequence":"1653310758837_000000000004D"}
{"type":"liberty_message","host":"ifsapp-odata-fb6d9b566-xpgbp","ibm_userDir":"\/opt\/ifs\/wlp\/usr\/","ibm_serverName":"defaultServer","message":"CWNEN0047W: Resource annotations on the fields of the org.camunda.bpm.engine.cdi.impl.ManagedJobExecutor class will be ignored. The annotations could not be obtained because of the exception : java.lang.NoClassDefFoundError: Ljavax\/enterprise\/concurrent\/ManagedExecutorService;","ibm_threadId":"00000029","ibm_datetime":"2022-05-

.

"2022-05-23 12:59:27.208 ERROR  36  org.camunda.commons.logging.BaseLogger.logError() : ENGINE-12012 Exception on accessing the database connection: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalStateException: unable to start connection creation task DSRA0010E: SQL State = null, Error Code = 0"

.

FFDC1015I: An FFDC Incident has been created: \"java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:\nORA-12504, TNS:listener was not given the SID in CONNECT_DATA\n  com.ibm.ws.rsadapter.impl.WSManagedConnectionFactoryImpl 1372\" at ffdc_22.05.23_12.59.31.0.log","ibm_threadId":"00000024","ibm_datetime":"2022-05-

 

It is possible to connect to the database from plsql developer. 

Any ideas how to troubleshoot this?

 

Info from odata describe:

QoS Class:       Burstable
Node-Selectors:  <none>
Tolerations:     node.kubernetes.io/not-ready:NoExecute op=Exists for 300s
                 node.kubernetes.io/unreachable:NoExecute op=Exists for 300s
Events:
  Type     Reason     Age                   From     Message
  ----     ------     ----                  ----     -------
  Normal   Killing    12m (x22 over 11h)    kubelet  Container ifsapp-odata failed startup probe, will be restarted
  Warning  Unhealthy  2m8s (x659 over 11h)  kubelet  (combined from similar events): Startup probe failed: Readiness Check Status - DOWN
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed

  0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0
100   101  100   101    0     0   2632      0 --:--:-- --:--:-- --:--:--  2657
 

Hi @Malin Norgren ,

Is there a specific reason why the IFSIAMSYS schema was exported and re-imported after the database duplication? 

Cheers

These are instructions i received from cloud group, what they do in the cloud managed environments.

Is this not needed?

//Malin

Hi @Malin Norgren ,

That’s bit strange. My customer running remote simply drops the MT, duplicates the database from the source to destination, changes the backend user passwords after duplication is done in the destination database to match the passwords in the yaml file and re-deploy the MT. So far it has worked out quite well. Only thing that goes missing after the duplication seems to be External Identity providers setup in IAM.

Cheers 

Reply


Terms & ConditionsCookie settings