On 26/09/2013 06:27, Antti Lankinen wrote:
Hi,

I synchronized data which is 5000 enties to syncope, but I see following error message in core.log and I don't see Synchronization Task Execution "report". All data was however correctly created in syncope.

FailedObject: org.apache.syncope.core.persistence.beans.TaskExec@713b1ef8
Caused by: org.apache.openjpa.persistence.PersistenceException: Data truncation: Data too long for column 'message' at row 1 {prepstmnt 2052176465 INSERT INTO TaskExec (id, endDate, message, startDate, status, TASK_ID) VALUES (?, ?, ?, ?, ?, ?)} [code=1406, state=22001] in core.log

When I synchronized only 20 entries to syncope, I can see Synchronization Task Executions"report".

Hi,
which Syncope version are you using? On which DBMS?

The problem is of course that the TaskExec.message is too short to contain the whole execution message for 5000 users; the point is that this shouldn't happen since that column is configured as CLOB.

As a workaround, you can set the SyncTasks's trace level to SUMMARY.

Regards.

--
Francesco Chicchiriccò

ASF Member, Apache Syncope PMC chair, Apache Cocoon PMC Member
http://people.apache.org/~ilgrosso/

Reply via email to