SAP Knowledge Base Article - Preview

3085902 - Fatal error updating User Timezone field not being Updated via connector

Symptom

Fatal error in SF user connector not updating time zones for users:

Unexpected Error.ElmsCreateException in updateUserPreferences()
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [461]: foreign key constraint violation: TrexColumnUpdate failed on table '<*SCHEMA*> :PA_USER_PREFERENCE_DTE_PATTERN' with error: Only found 0 of 1 rows from <*SCHEMA*>:PA_USER_PREFERENCE_DTE_PATTERN(LOCALE_ID, PATTERN_ID) in <*SCHEMA*> :PA_I18N_ACTIVE_LOCALE_DTE_FRMT(LOCALE_ID, PATTERN_ID), rc=1535
 at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:209)
 at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:42)
 at com.sap.db.jdbc.packet.HReplyPacket._buildExceptionChain(HReplyPacket.java:841)
 at com.sap.db.jdbc.packet.HReplyPacket.getSQLExceptionChain(HReplyPacket.java:158)
 at com.sap.db.jdbc.packet.HPartInfo.getSQLExceptionChain(HPartInfo.java:39)
 at com.sap.db.jdbc.ConnectionSapDB._receive(ConnectionSapDB.java:4560)
 at com.sap.db.jdbc.ConnectionSapDB.exchange(ConnectionSapDB.java:1942)
 at com.sap.db.jdbc.PreparedStatementSapDB._execute(PreparedStatementSapDB.java:3161)
 at com.sap.db.jdbc.PreparedStatementSapDB._execute(PreparedStatementSapDB.java:2278)
 at com.sap.db.jdbc.PreparedStatementSapDB._executeUpdate(PreparedStatementSapDB.java:2253)
 at com.sap.db.jdbc.PreparedStatementSapDB.executeUpdate(PreparedStatementSapDB.java:610)
 at com.sap.db.jdbc.HanaPreparedStatement.executeUpdate(HanaPreparedStatement.java)
 at com.plateau.common.db.hana.impl.HanaPreparedStatement.executeUpdate(HanaPreparedStatement.java:328)
 at sun.reflect.GeneratedMethodAccessor407.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:272)
 at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:138)
 at com.sun.proxy.$Proxy417.executeUpdate(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor407.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.plateau.foundation.jdbc.StatementPerfMonitorInvocationHandler.invoke(StatementPerfMonitorInvocationHandler.java:138)
 at com.sun.proxy.$Proxy418.executeUpdate(Unknown Source)
 at sun.reflect.GeneratedMethodAccessor407.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 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.$Proxy419.executeUpdate(Unknown Source)
 at com.plateausystems.elms.util.helper.DBUtil.executeUpdateSQL(DBUtil.java:1093)
 at com.plateausystems.elms.util.helper.DBUtil.excuteUpdateSQL(DBUtil.java:1021)
 at com.platea
...


Read more...

Environment

SAP SuccessFactors Learning

Product

SAP SuccessFactors Learning all versions

Keywords

sap, sf, learning, lms, connector, sfuser, user-sf, user, fatal, error, exception, update, preference, date, dte, format, pattern, locale, timezone, time, zone, INC0907281, LRN-118588 , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-USR , User Entity , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.