[resolved] UUID NumberFormatException

One Star

[resolved] UUID NumberFormatException

Hello.
I use Talend MDM community v5.4.1
I created a data model entity with a primary key of type UUID.
I selected "custom type" in simple type creation window and choosed UUID. Then an UUID model type appear in right panel, with the base type String.
When I deploy this and create a new item in Web user interface I have this error in console :
20:54:33,131 ERROR Failed to save item Person, For input string: "e375f6de-1b03-4169-acec-c7356472b185"
...
...
Caused by: java.lang.NumberFormatException: For input string: "e375f6de-1b03-4169-acec-c7356472b185"
e375f6de-1b03-4169-acec-c7356472b185 is the UUID generated for my primary key.
Did I missed something ??
Thank you

Accepted Solutions
One Star

Re: [resolved] UUID NumberFormatException

Thank you very much.
My problem is SOLVED Smiley Happy
I deleted all .db files in MDM server related to my container, I redeployed and it works !!
The ID was an AUTO_INCREMENT (int) before, when I changed it to UUID (String) the issue occured. Now I know how to deal with that.

All Replies
Moderator

Re: [resolved] UUID NumberFormatException

Hi,
Could you please paste your data model entity xsd into forum so that we can address your issue quickly.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] UUID NumberFormatException

Sure, here is my xsd data model :
Thank you for your support Smiley Happy
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:import namespace="http://www.w3.org/2001/XMLSchema" />
<xsd:element name="Task" type="TaskType">
<xsd:unique name="Task">
<xsd:selector xpath="." />
<xsd:field xpath="id" />
</xsd:unique>
</xsd:element>
<xsd:complexType name="TaskType">
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="id" type="UUID" />
<xsd:element maxOccurs="10" minOccurs="0" name="subtasks" type="UUID">
<xsd:annotation>
<xsd:appinfo source="X_ForeignKey">Task/id</xsd:appinfo>
<xsd:appinfo source="X_ForeignKey_NotSep">false</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element maxOccurs="1" minOccurs="1" name="description" type="DescriptionType" />
<xsd:element maxOccurs="1" minOccurs="0" name="place" type="PlaceType" />
<xsd:element maxOccurs="1" minOccurs="0" name="begin" type="xsd:dateTime" />
<xsd:element maxOccurs="1" minOccurs="0" name="end" type="xsd:dateTime" />
<xsd:element maxOccurs="1" minOccurs="0" name="contact" type="ContactType" />
<xsd:element maxOccurs="1" minOccurs="1" name="recurrent" type="xsd:boolean" />
<xsd:element maxOccurs="1" minOccurs="1" name="repeatable" type="xsd:boolean" />
<xsd:element maxOccurs="1" minOccurs="1" name="waiting" type="xsd:boolean" />
</xsd:sequence>
</xsd:complexType>
<xsd:simpleType name="DescriptionType">
<xsd:restriction base="xsd:normalizedString">
<xsd:pattern value="{1}*" />
<xsd:whiteSpace value="replace" />
<xsd:minLength value="10" />
<xsd:maxLength value="200" />
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="PlaceType">
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="name" type="DescriptionType" />
<xsd:element maxOccurs="1" minOccurs="1" name="address" type="AddressType" />
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="AddressType">
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="0" name="number" type="AddressNumberType" />
<xsd:element maxOccurs="1" minOccurs="0" name="complement" type="AddressNumberComplementType" />
<xsd:element maxOccurs="1" minOccurs="1" name="street" type="AddressStreetType" />
<xsd:element maxOccurs="1" minOccurs="1" name="postCode" type="AddressPostCodeType" />
<xsd:element maxOccurs="1" minOccurs="1" name="town" type="AddressTownType" />
</xsd:sequence>
</xsd:complexType>
<xsd:simpleType name="AddressNumberType">
<xsd:restriction base="xsd:unsignedShort">
<xsd:minInclusive value="1" />
<xsd:maxInclusive value="9999" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="AddressNumberComplementType">
<xsd:restriction base="xsd:normalizedString">
<xsd:minLength value="1" />
<xsd:maxLength value="5" />
<xsd:pattern value="{1,5}" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="AddressStreetType">
<xsd:restriction base="xsd:normalizedString">
<xsd:minLength value="10" />
<xsd:maxLength value="200" />
<xsd:whiteSpace value="collapse" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="AddressPostCodeType">
<xsd:restriction base="xsd:normalizedString">
<xsd:length value="5" />
<xsd:pattern value="{5}" />
</xsd:restriction>
</xsd:simpleType>
<xsd:simpleType name="AddressTownType">
<xsd:restriction base="xsd:normalizedString">
<xsd:minLength value="2" />
<xsd:maxLength value="200" />
<xsd:whiteSpace value="collapse" />
</xsd:restriction>
</xsd:simpleType>
<xsd:complexType name="ContactType">
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="1" name="firstname" type="xsd:string" />
<xsd:element maxOccurs="1" minOccurs="1" name="lastname" type="xsd:string" />
</xsd:sequence>
</xsd:complexType>
<xsd:simpleType name="UUID">
<xsd:restriction base="xsd:string" />
</xsd:simpleType>
</xsd:schema>
Employee

Re: [resolved] UUID NumberFormatException

Hi,
Quite strangely, you have this error:
20:54:33,131 ERROR Failed to save item Person, For input string: "e375f6de-1b03-4169-acec-c7356472b185"

But no "Person" entity in your data model. Are you sure you posted the correct data model?
One Star

Re: [resolved] UUID NumberFormatException

Hooo I posted the correct data model and the wrong error.
Sorry
For the "Task" data model the error is :
20:09:07,820 ERROR Failed to save item Task, For input string: "7053383c-c818-4fd3-be3b-7282d18504a7"

It seems that Talend wants to convert the string "7053383c-c818-4fd3-be3b-7282d18504a7" into a number ...
Thanks
One Star

Re: [resolved] UUID NumberFormatException

Note that I translated the error message above in English.
Here is the complete error stack :
20:55:20,474 ERROR  Data conversion error converting "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"; SQL statement:
select task0_.x_id as x1_209_3_, task0_.x_description as x2_209_3_, task0_.x_place_x_talend_id as x3_209_3_, task0_.x_begin as x4_209_3_, task0_.x_end as x5_209_3_, task0_.x_contact_x_talend_id as x6_209_3_, task0_.x_recurrent as x7_209_3_, task0_.x_repeatable as x8_209_3_, task0_.x_waiting as x9_209_3_, task0_.x_talend_timestamp as x10_209_3_, task0_.x_talend_task_id as x11_209_3_, x_placetyp1_.x_talend_id as x1_213_0_, x_placetyp1_.x_name as x2_213_0_, x_placetyp1_.x_address_x_talend_id as x3_213_0_, x_addresst2_.x_talend_id as x1_211_1_, x_addresst2_.x_number as x2_211_1_, x_addresst2_.x_complement as x3_211_1_, x_addresst2_.x_street as x4_211_1_, x_addresst2_.x_postcode as x5_211_1_, x_addresst2_.x_town as x6_211_1_, x_contactt3_.x_talend_id as x1_212_2_, x_contactt3_.x_firstname as x2_212_2_, x_contactt3_.x_lastname as x3_212_2_ from TASK task0_ left outer join X_PLACETYPE x_placetyp1_ on task0_.x_place_x_talend_id=x_placetyp1_.x_talend_id left outer join X_ADDRESSTYPE x_addresst2_ on x_placetyp1_.x_address_x_talend_id=x_addresst2_.x_talend_id left outer join X_CONTACTTYPE x_contactt3_ on task0_.x_contact_x_talend_id=x_contactt3_.x_talend_id where task0_.x_id=?
20:55:20,474 ERROR Unable to store the item Organizer.Task.23f1c65c-6bf9-42b5-954b-36c4c0afba4e: com.amalto.core.util.XtentisException: com.amalto.xmlserver.interfaces.XmlServerException: java.lang.RuntimeException: Exception occurred during update.
com.amalto.core.util.XtentisException: com.amalto.xmlserver.interfaces.XmlServerException: java.lang.RuntimeException: Exception occurred during update.
at com.amalto.core.ejb.XmlServerSLWrapperBean.putDocumentFromString(XmlServerSLWrapperBean.java:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy170.putDocumentFromString(Unknown Source)
at com.amalto.core.ejb.ItemPOJO.store(ItemPOJO.java:681)
at com.amalto.core.save.DefaultCommitter.save(DefaultCommitter.java:93)
at com.amalto.core.save.SaverSession.end(SaverSession.java:144)
at com.amalto.core.save.SaverSession.end(SaverSession.java:122)
at com.amalto.webapp.core.util.WebSaver.saveItemWithReport(WebSaver.java:88)
at com.amalto.webapp.core.util.IXtentisRMIPort.putItemWithReport(IXtentisRMIPort.java:2301)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.saveItem(BrowseRecordsAction.java:1730)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.saveItem(BrowseRecordsAction.java:1781)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:103)
at org.talend.mdm.webapp.base.server.AbstractService.processCall(AbstractService.java:52)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:73)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:724)
Caused by: com.amalto.xmlserver.interfaces.XmlServerException: java.lang.RuntimeException: Exception occurred during update.
at com.amalto.core.storage.StorageWrapper.putDocumentFromString(StorageWrapper.java:184)
at com.amalto.core.storage.StorageWrapper.putDocumentFromString(StorageWrapper.java:171)
at com.amalto.core.storage.DispatchWrapper.putDocumentFromString(DispatchWrapper.java:193)
at com.amalto.core.ejb.XmlServerSLWrapperBean.putDocumentFromString(XmlServerSLWrapperBean.java:219)
... 60 more
Caused by: java.lang.RuntimeException: Exception occurred during update.
at com.amalto.core.storage.hibernate.HibernateStorage.update(HibernateStorage.java:649)
at com.amalto.core.storage.hibernate.HibernateStorage.update(HibernateStorage.java:599)
at com.amalto.core.storage.SecuredStorage.update(SecuredStorage.java:90)
at com.amalto.core.storage.StorageLogger.update(StorageLogger.java:107)
at com.amalto.core.storage.StorageWrapper.putDocumentFromString(StorageWrapper.java:182)
... 63 more
Caused by: java.lang.RuntimeException: Exception occurred while creating internal object for type 'Task'
at com.amalto.core.storage.hibernate.ObjectDataRecordConverter.convert(ObjectDataRecordConverter.java:91)
at com.amalto.core.storage.record.DataRecord.convert(DataRecord.java:164)
at com.amalto.core.storage.hibernate.HibernateStorage.update(HibernateStorage.java:611)
... 67 more
Caused by: org.hibernate.exception.DataException: could not load an entity:
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1957)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:997)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:990)
at com.amalto.core.storage.hibernate.ObjectDataRecordConverter.convert(ObjectDataRecordConverter.java:64)
... 69 more
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"; SQL statement:
select task0_.x_id as x1_209_3_, task0_.x_description as x2_209_3_, task0_.x_place_x_talend_id as x3_209_3_, task0_.x_begin as x4_209_3_, task0_.x_end as x5_209_3_, task0_.x_contact_x_talend_id as x6_209_3_, task0_.x_recurrent as x7_209_3_, task0_.x_repeatable as x8_209_3_, task0_.x_waiting as x9_209_3_, task0_.x_talend_timestamp as x10_209_3_, task0_.x_talend_task_id as x11_209_3_, x_placetyp1_.x_talend_id as x1_213_0_, x_placetyp1_.x_name as x2_213_0_, x_placetyp1_.x_address_x_talend_id as x3_213_0_, x_addresst2_.x_talend_id as x1_211_1_, x_addresst2_.x_number as x2_211_1_, x_addresst2_.x_complement as x3_211_1_, x_addresst2_.x_street as x4_211_1_, x_addresst2_.x_postcode as x5_211_1_, x_addresst2_.x_town as x6_211_1_, x_contactt3_.x_talend_id as x1_212_2_, x_contactt3_.x_firstname as x2_212_2_, x_contactt3_.x_lastname as x3_212_2_ from TASK task0_ left outer join X_PLACETYPE x_placetyp1_ on task0_.x_place_x_talend_id=x_placetyp1_.x_talend_id left outer join X_ADDRESSTYPE x_addresst2_ on x_placetyp1_.x_address_x_talend_id=x_addresst2_.x_talend_id left outer join X_CONTACTTYPE x_contactt3_ on task0_.x_contact_x_talend_id=x_contactt3_.x_talend_id where task0_.x_id=?
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.value.Value.convertTo(Value.java:852)
at org.h2.value.Value.getLong(Value.java:421)
at org.h2.index.PageDataIndex.getKey(PageDataIndex.java:267)
at org.h2.index.PageDelegateIndex.find(PageDelegateIndex.java:57)
at org.h2.index.BaseIndex.find(BaseIndex.java:102)
at org.h2.index.MultiVersionIndex.find(MultiVersionIndex.java:68)
at org.h2.index.IndexCursor.find(IndexCursor.java:145)
at org.h2.table.TableFilter.next(TableFilter.java:322)
at org.h2.command.dml.Select.queryFlat(Select.java:513)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:618)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQuery(Command.java:187)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)
at org.hibernate.loader.Loader.doQuery(Loader.java:718)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1953)
... 81 more
Caused by: java.lang.NumberFormatException: For input string: "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:441)
at java.lang.Long.parseLong(Long.java:483)
at org.h2.value.Value.convertTo(Value.java:811)
... 102 more
20:55:20,490 ERROR Impossible de sauvegarder l'item Task, For input string: "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"
java.rmi.RemoteException: ; nested exception is:
com.amalto.webapp.core.util.WebCoreException: java.lang.NumberFormatException: For input string: "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:140)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:135)
at com.amalto.webapp.core.util.WebSaver.saveItemWithReport(WebSaver.java:93)
at com.amalto.webapp.core.util.IXtentisRMIPort.putItemWithReport(IXtentisRMIPort.java:2301)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.saveItem(BrowseRecordsAction.java:1730)
at org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.saveItem(BrowseRecordsAction.java:1781)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:569)
at org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:103)
at org.talend.mdm.webapp.base.server.AbstractService.processCall(AbstractService.java:52)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:73)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
at java.lang.Thread.run(Thread.java:724)
Caused by: com.amalto.webapp.core.util.WebCoreException: java.lang.NumberFormatException: For input string: "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"
at com.amalto.webapp.core.util.WebSaver.handleException(WebSaver.java:137)
... 44 more
Caused by: java.lang.NumberFormatException: For input string: "23f1c65c-6bf9-42b5-954b-36c4c0afba4e"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:441)
at java.lang.Long.parseLong(Long.java:483)
at org.h2.value.Value.convertTo(Value.java:811)
at org.h2.value.Value.getLong(Value.java:421)
at org.h2.index.PageDataIndex.getKey(PageDataIndex.java:267)
at org.h2.index.PageDelegateIndex.find(PageDelegateIndex.java:57)
at org.h2.index.BaseIndex.find(BaseIndex.java:102)
at org.h2.index.MultiVersionIndex.find(MultiVersionIndex.java:68)
at org.h2.index.IndexCursor.find(IndexCursor.java:145)
at org.h2.table.TableFilter.next(TableFilter.java:322)
at org.h2.command.dml.Select.queryFlat(Select.java:513)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:618)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:82)
at org.h2.command.Command.executeQuery(Command.java:187)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)
at org.hibernate.loader.Loader.doQuery(Loader.java:718)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1953)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:997)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:990)
at com.amalto.core.storage.hibernate.ObjectDataRecordConverter.convert(ObjectDataRecordConverter.java:64)
at com.amalto.core.storage.record.DataRecord.convert(DataRecord.java:164)
at com.amalto.core.storage.hibernate.HibernateStorage.update(HibernateStorage.java:611)
at com.amalto.core.storage.hibernate.HibernateStorage.update(HibernateStorage.java:599)
at com.amalto.core.storage.SecuredStorage.update(SecuredStorage.java:90)
at com.amalto.core.storage.StorageLogger.update(StorageLogger.java:107)
at com.amalto.core.storage.StorageWrapper.putDocumentFromString(StorageWrapper.java:182)
at com.amalto.core.storage.StorageWrapper.putDocumentFromString(StorageWrapper.java:171)
at com.amalto.core.storage.DispatchWrapper.putDocumentFromString(DispatchWrapper.java:193)
at com.amalto.core.ejb.XmlServerSLWrapperBean.putDocumentFromString(XmlServerSLWrapperBean.java:219)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
at org.jboss.ejb.Container.invoke(Container.java:960)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
at com.sun.proxy.$Proxy170.putDocumentFromString(Unknown Source)
at com.amalto.core.ejb.ItemPOJO.store(ItemPOJO.java:681)
at com.amalto.core.save.DefaultCommitter.save(DefaultCommitter.java:93)
at com.amalto.core.save.SaverSession.end(SaverSession.java:144)
at com.amalto.core.save.SaverSession.end(SaverSession.java:122)
at com.amalto.webapp.core.util.WebSaver.saveItemWithReport(WebSaver.java:88)
... 35 more
Employee

Re: [resolved] UUID NumberFormatException

Here's my guess: you first deployed the data model with an id typed as xsd:long (or xsd:integer... something that holds numeric values). Then you changed to UUID (a xsd:string based type) and redeployed the data model. But this doesn't change the column type in the database .
Please do the following:
* Check if the column type for "x_id" of the Task table is typed as numeric or string.
* If numeric: perform "alter table" statement to change the column to a varchar OR drop the whole database schema and restart MDM (MDM will recreate the schema from scratch).
: For conservative reasons, MDM only adds new stuff in the database but doesn't change existing database schema elements. For example, if you first deployed with an string Id and then change to numeric, the column will still be a string (because some values may already exist and some values can't be converted to a number).
One Star

Re: [resolved] UUID NumberFormatException

Thank you very much.
My problem is SOLVED Smiley Happy
I deleted all .db files in MDM server related to my container, I redeployed and it works !!
The ID was an AUTO_INCREMENT (int) before, when I changed it to UUID (String) the issue occured. Now I know how to deal with that.