CMDBuild Forum

Import MySQL Database error

Configurations
#1

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
#2

Hi Team,

Can anyone help me check this issue? thanks

#3

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.

#4

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.

#5

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

#6

Hi temence,

Have you found a solution?

#7

Hi Roello,

I haven’t found a solution yet, what do you mean by GUI import? Didn’t you import the database?

#8

Did you find the answer?

#9

Yes, I would also like to see a clearer example of how to do a database import in CMDBuild.