SAP Knowledge Base Article - Public

2492944 - Connector Error - ORA-29541: class CUSTOMER_STAGE_TMS.TimezoneUtil could not be resolved.

Symptom

  • Connector run ends in failed status.
  • Error message looks like the one below:

java.lang.IllegalStateException: Could not start tenant "customer"
at com.plateau.foundation.tenant.TenantHelper.startTenantIfNeeded(TenantHelper.java:346)
at com.plateau.foundation.tenant.TenantHelper.bindTenantToThread(TenantHelper.java:290)
at com.plateau.foundation.jobscheduling.TenantAwareJobRunnable.setUp(TenantAwareJobRunnable.java:59)
at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:82)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:807)
Caused by: com.plateau.foundation.tenant.TenantInitializationException: Problem initializing tenant
at com.plateausystems.elms.util.helper.TMSApplicationServicesInitializer.initTenant(TMSApplicationServicesInitializer.java:330)
at com.plateausystems.elms.framework.bootstrap.TMSPlateauFoundationSetupHandler$TMSTenantInitializer.initTenant(TMSPlateauFoundationSetupHandler.java:116)
at com.plateau.foundation.tenant.DefaultTenantController.startTenantImmediately(DefaultTenantController.java:241)
at com.plateau.foundation.tenant.TenantHelper.startTenantIfNeeded(TenantHelper.java:338)
... 6 more
Caused by: java.lang.IllegalStateException: Could not initialize the DB time zone state
at com.plateausystems.elms.util.helper.DBTimeZoneInitializationHelper.initDBTimeZone(DBTimeZoneInitializationHelper.java:63)
at com.plateausystems.elms.util.helper.TMSApplicationServicesInitializer.initDBTimeZone(TMSApplicationServicesInitializer.java:695)
at sun.reflect.GeneratedMethodAccessor952.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.plateausystems.elms.util.helper.TMSApplicationServicesInitializer$1.intercept(TMSApplicationServicesInitializer.java:251)
at com.plateausystems.elms.util.helper.TMSServletContextApplicationServicesInitializer$$EnhancerByCGLIB$$bd49f77a.initDBTimeZone(<generated>)
at com.plateausystems.elms.util.helper.TMSApplicationServicesInitializer.initTenant(TMSApplicationServicesInitializer.java:296)
... 9 more
Caused by: com.plateausystems.elms.util.helper.ElmsCheckedException: initializeDatabaseTimeZone: Could not Initialize/validate DB timezone
at com.plateausystems.elms.util.helper.DBTimeZoneInitializationHelper.initializeDatabaseTimeZone(DBTimeZoneInitializationHelper.java:158)
at com.plateausystems.elms.util.helper.DBTimeZoneInitializationHelper.initDBTimeZone(DBTimeZoneInitializationHelper.java:60)
... 16 more
Caused by: java.sql.SQLException: ORA-29541: class "CUSTOMER"_STAGE_TMS.TimezoneUtil could not be resolved
ORA-06512: at ""CUSTOMER"_STAGE_TMS.PKG_TOOL", line 664
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:204)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1041)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4739)
at oracle.jdbc.driver.T4CCallableStatement.executeUpdate(T4CCallableStatement.java)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
at oracle.jdbc.driver.OracleCallableStatementWrapper.executeUpdate(OracleCallableStatementWrapper.java)
at sun.reflect.GeneratedMethodAccessor3322.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)
at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.invoke(CallableStatementProxyFactory.java:101)
at com.sun.proxy.$Proxy3611.executeUpdate(Unknown Source)
at com.plateau.common.db.oracle.impl.AbstractOracleCallableStatementWrapper.executeUpdate(AbstractOracleCallableStatementWrapper.java:452)
at com.plateau.common.db.oracle.impl.PlateauOracleCallableStatement.executeUpdate(PlateauOracleCallableStatement.java)
at sun.reflect.GeneratedMethodAccessor3322.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.plateau.foundation.jdbc.StatementPerfMonitorInvocationHandler.invoke(StatementPerfMonitorInvocationHandler.java:146)
at com.sun.proxy.$Proxy3612.executeUpdate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor3322.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:71)
at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155)
at com.sun.proxy.$Proxy3613.executeUpdate(Unknown Source)
at com.plateausystems.elms.util.helper.DBTimeZoneInitializationHelper.validateDatabaseTimeZone(DBTimeZoneInitializationHelper.java:192)
at com.plateausystems.elms.util.helper.DBTimeZoneInitializationHelper.initializeDatabaseTimeZone(DBTimeZoneInitializationHelper.java:113)
... 17 more

Environment

  • Learning Management System

Cause

  • Packages PKG_TOOL and Timezone Util were affected, mostly due to a refresh issue.

Resolution

  • Please raise an incident to Cloud Support team. It will require Operations team involvement to rebuild the affected packages.

Keywords

  • ORA-29541: class CUSTOMER_STAGE_TMS.TimezoneUtil could not be resolved, connector error, connector failed, java.lang.IllegalStateException: Could not start tenant
, KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions