OpenEMM Technical Support Forum

Download link for OVA 24.10 is https://share.agnitas.de/index.php/s/gbe4JZwjepB4j5L

You can build executables of old OpenEMM versions from GitHub at https://github.com/agnitas-org/openemm/branches/all

DB schema looks ok. The problem is that error message ERROR [WorkerExecutorService-emm-thread-#2] org.agnitas.dao.impl.ImportRecipientsDaoImpl - Error: PreparedStatementCallback; SQL [INSERT INTO customer_1_binding_tbl (customer_id, user_type, user_status, user_remark, timestamp, creation_date, exit...

Let's check the schema of your customer_1_binding_tbl:

Code: Select all

# mysql -u root -p
> use openemm
> DESC customer_1_binding_tbl;

What do you get? (edited)

The import profile looks OK. Does the mapping contain all fields which are present in the import file?

Which exact version of OpenEMM do you use?

Root cause is "Column 'user_status' cannot be null". Please share the settings of your import profile.

This log does not help. Please post the stacktrace from Tomcat's log catalina.out.

When saving of the import profile fails, you should get a stacktrace in Tomcat's log catalina.out. Please post it here

We just published the first GA (general availability) version of OpenEMM 25.11. What is new in OpenEMM 25.04? Have a look at the factsheet for OpenEMM 25.11: https://wiki-iframe.agnitas.de/lib/exe/fetch.php?media=agnitas-openemm-news-version-25.11-en.pdf See the OpenEMM Wiki at https://wiki.openemm....

Wow! I will check the JSON file if it is really clean. It may contain some artifacts too.

From which version of OpenEMM do you come initially?

Is "uupload_tb" a typo from your side? But "upload_tbl" is not part of OpenEMM either.

Try

Code: Select all

DELETE FROM job_queue_parameter_tbl WHERE job_id = (SELECT id FROM job_queue_tbl WHERE description = 'DBCleaner');

Class DBCleanerJobWorker is not part of OpenEMM. Please execute DELETE FROM job_queue_result_tbl WHERE job_id = (SELECT id FROM job_queue_tbl WHERE description = 'DBCleaner'); DELETE FROM job_queue_tbl WHERE description = 'DBCleaner'; INSERT INTO agn_dbversioninfo_tbl (version_number, updating_user,...

Please show us the complete entry for description "DBCleaner" and tell us which exact version of OpenEMM you use.

I added it in section "OpenEMM Downloads" in the OpenEMM Wiki (https://wiki.openemm.org).

OpenEMM Technical Support Forum

Search found 2659 matches

Re: CSV Import fails with "user_status" cannot be null

Re: CSV Import fails with "user_status" cannot be null

Re: CSV Import fails with "user_status" cannot be null

Re: CSV Import fails with "user_status" cannot be null

Re: CSV Import fails with "user_status" cannot be null

Re: CSV Import fails with "user_status" cannot be null

Re: 25.04: cannot add new import profile

Final Version of OpenEMM 25.11 now Available

Re: CSV Import fails with "user_status" cannot be null

Re: CSV Import fails with "user_status" cannot be null

Re: ERROR: Missing value for field nextstart in table job_queue_tbl for JobWorker DBCleaner

Re: ERROR: Missing value for field nextstart in table job_queue_tbl for JobWorker DBCleaner

Re: ERROR: Missing value for field nextstart in table job_queue_tbl for JobWorker DBCleaner

Re: ERROR: Missing value for field nextstart in table job_queue_tbl for JobWorker DBCleaner

Re: CSV Import fails with "user_status" cannot be null