Good morning. I am using the Connector Wizard to feed the Cmdbuild database with an external data source. I have 2 tables that are connected to each other by a field of type Reference in Cmdbuild and in the table of the external source in this connection field I put the code of the referenced table (with the same mechanism used to import the data in the section "Import Data from CSV "). Only in the Wizard Connector the field is not synchronized and the job gives me the error: RROR 2019-01-25 10:23:00 [org.cmdbuild.services.sync.logging] error creating entry java.lang.RuntimeException: Conversion error at org.cmdbuild.logic.taskmanager.task.connector.DefaultAttributeValueAdapter $ 1.visit (DefaultAttributeValueAdapter.java:104) at org.cmdbuild.dao.entrytype.attributetype.ReferenceAttributeType.accept (ReferenceAttributeType.java:48) at org.cmdbuild.logic.taskmanager.task.connector.DefaultAttributeValueAdapter $ 1.adapt (DefaultAttributeValueAdapter.java:72) at org.cmdbuild.logic.taskmanager.task.connector.DefaultAttributeValueAdapter.toInternal (DefaultAttributeValueAdapter.java:129) at org.cmdbuild.services.sync.store.internal.InternalStore $ Create.visit (InternalStore.java:163) at org.cmdbuild.services.sync.store.ClassType.accept (ClassType.java:66) at org.cmdbuild.services.sync.store.internal.InternalStore $ Create.execute (InternalStore.java:153) at org.cmdbuild.services.sync.store.internal.InternalStore $ Create.execute (InternalStore.java:1) at org.cmdbuild.services.sync.store.internal.InternalStore.execute (InternalStore.java:359) at org.cmdbuild.services.sync.store.internal.InternalStore.create (InternalStore.java:319) at org.cmdbuild.services.sync.store.ForwardingStore.create (ForwardingStore.java:18) at org.cmdbuild.services.sync.store.Stores $ LoggingStore.create (Stores.java:24) at org.cmdbuild.services.sync.store.ForwardingStore.create (ForwardingStore.java:18) at org.cmdbuild.logic.taskmanager.task.connector.PermissionBasedStore.create (PermissionBasedStore.java:40) at org.cmdbuild.services.sync.store.StoreSynchronizer.doSync (StoreSynchronizer.java:131) at org.cmdbuild.services.sync.store.StoreSynchronizer.sync (StoreSynchronizer.java:88) at org.cmdbuild.logic.taskmanager.task.connector.ConnectorTaskCommandWrapper.execute (ConnectorTaskCommandWrapper.java:87) at org.cmdbuild.scheduler.command.ForwardingCommand.execute (ForwardingCommand.java:18) at org.cmdbuild.scheduler.command.Commands $ ComposeOnExeption.execute (Commands.java:73) at org.cmdbuild.scheduler.command.BuildableCommandBasedJob.execute (BuildableCommandBasedJob.java:72) at org.cmdbuild.scheduler.ForwardingJob.execute (ForwardingJob.java:24) at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade $ JobWithCallback.execute (DefaultSchedulerFacade.java:65) at org.cmdbuild.scheduler.ForwardingJob.execute (ForwardingJob.java:24) at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade $ JobWithCallback.execute (DefaultSchedulerFacade.java:65) at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade $ SuppressedExceptionJob.execute (DefaultSchedulerFacade.java:38) at org.cmdbuild.scheduler.quartz.QuartzJob.execute (QuartzJob.java:101) at org.quartz.core.JobRunShell.run (JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool $ WorkerThread.run (SimpleThreadPool.java:573)
Here is an example of the 2 tables. DOMAIN table with the Code and Description columns. Table VAL_DOMINIO with the columns Code, Description and DOM_CD that in CMDBUILD is of type Reference while in the other database it is of type String and reports the Code of the referenced Domain. How can I synchronize these 2 tables? Thank you.