CMDBuild Forum

Import MySQL Database error

Hi CMDBuild Team,

I am from China and I am using CMDBuild READY2USE READY2USE 2.2-3.4. I found that the community version no longer supports OCS connector, so I need to use Import Database Temple and task management to import asset data.
However, when I import assets, an error message is reported as follows

org.cmdbuild.jobs.JobException: error executing job = JobData{id=1908321, code=test, type=etl, isEnabled=true}, caused by: org.cmdbuild.etl.EtlException: error processing etl job = JobData{id=1908321, code=test, type=etl, isEnabled=true}, caused by: org.cmdbuild.etl.EtlException: error processing etl gate = EtlGate{code=INLINE_JOB_test}, caused by: java.lang.NullPointerException: config not found for key =< target >

image

The following is my related import configuration, can you give me any suggestions? thank you
Database template:
image
image
image

Task management
image

MYSQL Data
image

This import problem has been bothering me for a long time. If you can give me any suggestions, that would be great

BR
Duke

2 Likes

Hi Team,

Can anyone help me check this issue? thanks

Hi @temence sometime I got this error either when into the import file not all requierd field are defined and when I do not include into mapping all required/uniques fields.

Hi
Thank you for your reply, but the database I tested only contains two columns of data, code and HOSTNAME, and my import template also contains code and HOSTNAME. You can see my screenshot above. This is very strange.

HI temence,
I receive the same error trying to schedule an import from a Database Table (MS Sql Server).
Importing from the gui I have no problems. It seems scheduler related