Hello there,
My registration client is throwing “Sync configuration failure” error after login. The username and the password are both correct
I am using regclient 1.2.0.2 tag along with 1.2.0.1 for other services since with regclient 1.2.0.1, the login button is not working (I refered to this post)
Here is the log from logs/registration.logs
2025-07-18 16:53:56,531 INFO [Thread-10] i.m.r.s.o.i.UserDetailServiceImpl : Entering into user detail save method...
2025-07-18 16:53:56,531 INFO [Thread-10] i.m.r.u.r.ServiceDelegateUtil : Registration Network Checker had been called --> https://api-internal-sandbox.mosip-local-instance.com/v1/syncdata/actuator/health
2025-07-18 16:53:56,840 WARN [Thread-10] i.m.r.s.BaseService : - REGISTRATION - REG - Ignoring pre-checks as its Initial sync
2025-07-18 16:53:56,840 INFO [Thread-10] i.m.k.c.s.i.TPMClientCryptoServiceImpl : ccSessionID - TPM - - Getting Asymmetric Key Creation from tpm
2025-07-18 16:53:56,840 INFO [Thread-10] i.m.r.u.SoftwareUpdateHandler : Checking for current version started...
2025-07-18 16:53:56,840 INFO [Thread-10] i.m.r.u.SoftwareUpdateHandler : Checking for current version completed : 1.2.0.2
2025-07-18 16:53:56,841 INFO [Thread-10] i.m.r.u.a.RestClientAuthAdvice : Auth advice triggered to check add authZ token to web service request header...
2025-07-18 16:53:56,843 INFO [Thread-10] i.m.r.u.a.RestClientAuthAdvice : Adding request signature to request header
2025-07-18 16:53:56,843 INFO [Thread-10] i.m.k.c.s.i.TPMClientCryptoServiceImpl : ccSessionID - TPM - - Creating the Key from Platform TPM
2025-07-18 16:53:56,952 INFO [Thread-10] i.m.k.c.s.i.TPMClientCryptoServiceImpl : ccSessionID - TPM - - Completed Signing data using TPM
2025-07-18 16:53:56,952 INFO [Thread-10] i.m.k.c.s.i.TPMClientCryptoServiceImpl : ccSessionID - TPM - - Getting Asymmetric Key Creation from tpm
2025-07-18 16:53:56,952 INFO [Thread-10] i.m.r.u.a.RestClientAuthAdvice : Completed adding request signature to request header completed
2025-07-18 16:53:56,952 INFO [Thread-10] i.m.r.u.r.AuthTokenUtilService : fetchAuthToken invoked for triggerPoint >>>>> System
2025-07-18 16:53:56,958 INFO [Thread-10] i.m.r.u.a.RestClientAuthAdvice : Adding authZ token to request header
2025-07-18 16:53:56,958 INFO [Thread-10] i.m.r.u.a.RestClientAuthAdvice : Adding of authZ token to request header completed
2025-07-18 16:53:57,570 INFO [Thread-10] i.m.r.u.a.ResponseSignatureAdvice : Response signature advice triggered...
2025-07-18 16:53:57,572 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - applicationId - SERVER-RESPONSE - Request received to getCertificate
2025-07-18 16:53:57,572 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - referenceId - Optional[SIGN-VERIFY] - Request received to getCertificate
2025-07-18 16:53:57,572 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - - - Reference Id is present. Will get Certificate from DB store
2025-07-18 16:53:57,573 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - applicationId - SERVER-RESPONSE - Getting public key from DB Store
2025-07-18 16:53:57,573 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - timestamp - 2025-07-18T14:53:57.572398500 - Getting public key from DB Store
2025-07-18 16:53:57,573 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - referenceId - SIGN-VERIFY - Getting public key from DB Store
2025-07-18 16:53:57,573 INFO [Thread-10] i.m.k.k.h.KeymanagerDBHelper : sessionId - - - Getting key alias
2025-07-18 16:53:57,574 INFO [Thread-10] i.m.k.k.h.KeymanagerDBHelper : sessionId - SERVER-RESPONSE - SIGN-VERIFY - PreExpireDays found as key policy:20
2025-07-18 16:53:57,574 INFO [Thread-10] i.m.k.k.h.KeymanagerDBHelper : sessionId - keyAlias - [KeyAlias(alias=2f5ffb7d-16b0-4c8b-a30b-d8b599b8a429, applicationId=SERVER-RESPONSE, referenceId=SIGN-VERIFY, keyGenerationTime=2025-04-11T08:00:33, keyExpiryTime=2028-04-10T08:00:33, status=null, certThumbprint=4C8D9D9224532393315A4FC7AC409CE54A4740968695B46F25A1104E66F65B3F, uniqueIdentifier=269711ADF37E28A9F28DE469CDB56C33EEDF285E)] - keyAlias
2025-07-18 16:53:57,575 INFO [Thread-10] i.m.k.k.h.KeymanagerDBHelper : sessionId - currentKeyAlias - [KeyAlias(alias=2f5ffb7d-16b0-4c8b-a30b-d8b599b8a429, applicationId=SERVER-RESPONSE, referenceId=SIGN-VERIFY, keyGenerationTime=2025-04-11T08:00:33, keyExpiryTime=2028-04-10T08:00:33, status=null, certThumbprint=4C8D9D9224532393315A4FC7AC409CE54A4740968695B46F25A1104E66F65B3F, uniqueIdentifier=269711ADF37E28A9F28DE469CDB56C33EEDF285E)] - currentKeyAlias
2025-07-18 16:53:57,575 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - currentKeyAlias - 2f5ffb7d-16b0-4c8b-a30b-d8b599b8a429 - CurrentKeyAlias size is one. Will fetch keypair using this alias
2025-07-18 16:53:57,576 INFO [Thread-10] i.m.k.k.s.i.KeymanagerServiceImpl : sessionId - keyFromDBStore - 2f5ffb7d-16b0-4c8b-a30b-d8b599b8a429 - Key in DBStore exists for this alias. Fetching Certificate.
2025-07-18 16:53:57,577 INFO [Thread-10] i.m.k.s.s.i.SignatureServiceImpl : SignatureSessionId - JWTSignature - - Certificate not found in JWT Header.
2025-07-18 16:53:57,579 INFO [Thread-10] i.m.r.u.a.ResponseSignatureAdvice : Response signature is valid... https://api-internal-sandbox.mosip-local-instance.com/v1/syncdata/v2/userdetails?keyindex=2c:39:8b:d9:d0:e2:85:4c:ef:d7:e9:78:ea:8a:08:38:99:f0:1e:1f:07:df:ba:2c:18:d2:d2:9c:e9:60:58:b8&version=1.2.0.2
2025-07-18 16:53:57,579 INFO [Thread-10] i.m.r.u.a.RestClientAuthAdvice : completed with request Auth advice
2025-07-18 16:53:57,579 INFO [Thread-10] i.m.k.c.s.i.TPMClientCryptoServiceImpl : ccSessionID - TPM - - Getting Asymmetric Key Creation from tpm
2025-07-18 16:53:57,685 INFO [Thread-10] i.m.r.d.i.UserDetailDAOImpl : Fetching All User details
2025-07-18 16:53:57,694 INFO [Thread-10] i.m.r.d.i.UserDetailDAOImpl : leaving user detail save method...
2025-07-18 16:53:57,723 ERROR [Thread-10] i.m.r.s.l.i.LoginServiceImpl : REGISTRATION - LOGIN - LOGIN_CONTROLLER - REGISTRATION - REG - org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not execute statement
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:263)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:225)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:527)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:135)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy162.saveAndFlush(Unknown Source)
at io.mosip.registration.dao.impl.UserDetailDAOImpl.save(UserDetailDAOImpl.java:176)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy168.save(Unknown Source)
at io.mosip.registration.service.operator.impl.UserDetailServiceImpl.save(UserDetailServiceImpl.java:112)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at io.micrometer.core.aop.TimedAspect.processWithTimer(TimedAspect.java:105)
at io.micrometer.core.aop.TimedAspect.timedMethod(TimedAspect.java:94)
at jdk.internal.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy135.save(Unknown Source)
at io.mosip.registration.service.login.impl.LoginServiceImpl.initialSync(LoginServiceImpl.java:350)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at io.micrometer.core.aop.CountedAspect.interceptAndRecord(CountedAspect.java:100)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at io.micrometer.core.aop.TimedAspect.processWithTimer(TimedAspect.java:105)
at io.micrometer.core.aop.TimedAspect.timedMethod(TimedAspect.java:94)
at jdk.internal.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy208.initialSync(Unknown Source)
at io.mosip.registration.controller.auth.LoginController$3$1.call(LoginController.java:912)
at io.mosip.registration.controller.auth.LoginController$3$1.call(LoginController.java:899)
at javafx.graphics/javafx.concurrent.Task$TaskCallable.call(Unknown Source)
at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
at javafx.graphics/javafx.concurrent.Service.lambda$executeTask$6(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at javafx.graphics/javafx.concurrent.Service.lambda$executeTask$7(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.DataException: could not execute statement
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3003)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3503)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:586)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:460)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1428)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1414)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:304)
at com.sun.proxy.$Proxy128.flush(Unknown Source)
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.flush(SimpleJpaRepository.java:534)
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.saveAndFlush(SimpleJpaRepository.java:505)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:377)
at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:200)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:629)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:593)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:578)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
... 86 more
Caused by: java.sql.SQLDataException: A truncation error was encountered trying to shrink VARCHAR 'service-account-mosip-resident-client' to length 36.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeLargeUpdate(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:205)
... 121 more
Caused by: ERROR 22001: A truncation error was encountered trying to shrink VARCHAR 'service-account-mosip-resident-client' to length 36.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.types.SQLChar.hasNonBlankChars(Unknown Source)
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
at org.apache.derby.iapi.types.SQLVarchar.normalize(Unknown Source)
at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.getNextRowCore(Unknown Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
... 126 more
2025-07-18 16:53:57,741 INFO [JavaFX Application Thread] i.m.r.c.r.AlertController : REGISTRATION - ALERT_CONTROLLER - ALERT_GENERATION - REGISTRATION - REG - Alert generation has been started
2025-07-18 16:53:57,742 INFO [JavaFX Application Thread] i.m.r.c.r.AlertController : REGISTRATION - ALERT_CONTROLLER - ALERT_GENERATION - REGISTRATION - REG - Alert generation has been ended
And the logs from syncdata does not contain any error
Thanks for the response.