cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

[resolved] UUID NumberFormatException

Highlighted
ju113n
One Star ju113n
One Star
‎01-26-2014 01:22 PM
‎01-26-2014 01:22 PM

[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
Labels:
0 Kudos
Reply

Accepted Solutions
ju113n
One Star ju113n
One Star
‎02-01-2014 04:59 AM
‎02-01-2014 04:59 AM

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.

View solution in original post

0 Kudos
Reply

All Replies
xdshi
Moderator xdshi
Moderator
‎01-26-2014 07:22 PM
‎01-26-2014 07:22 PM

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.
0 Kudos
Reply
ju113n
One Star ju113n
One Star
‎01-27-2014 05:21 PM
‎01-27-2014 05:21 PM

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>
0 Kudos
Reply
fhuaulme
Employee fhuaulme
Employee
‎01-28-2014 02:27 AM
‎01-28-2014 02:27 AM

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?
0 Kudos
Reply
ju113n
One Star ju113n
One Star
‎01-28-2014 12:12 PM
‎01-28-2014 12:12 PM

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
0 Kudos
Reply
ju113n
One Star ju113n
One Star
‎01-28-2014 12:56 PM
‎01-28-2014 12:56 PM

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
0 Kudos
Reply
fhuaulme
Employee fhuaulme
Employee
‎01-29-2014 03:37 AM
‎01-29-2014 03:37 AM

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).
0 Kudos
Reply
ju113n
One Star ju113n
One Star
‎02-01-2014 04:59 AM
‎02-01-2014 04:59 AM

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.

View solution in original post

0 Kudos
Reply

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog