Symptom
We are trying to import employee data via Employee Import job for a new employee but we receive the following error when the file is processed:
Error: An exception occurred while processing an import record. Stack Trace: org.apache.torque.TorqueException: org.apache.torque.TorqueException: java.sql.SQLDataException: [SEAPR1DB0034]String or binary data would be truncated. Msg 8152, Level 16, State 13, Line 1, Sqlstate 22001 at com.concur.om.ext.BaseCtEmployeePeer.doInsert(BaseCtEmployeePeer.java:1904) at com.concur.om.base.BaseCtEmployee.save(BaseCtEmployee.java:35540) at com.concur.om.ext.BaseCtEmployee.save(BaseCtEmployee.java:3122) at com.concur.om.CtEmployee.save(CtEmployee.java:255) at com.concur.services.importer.employee.EmployeeImporter.saveEmployee(EmployeeImporter.java:401) at com.concur.services.importer.employee.EmployeeImporter.processImpl(EmployeeImporter.java:316) at com.concur.services.importer.employee.EmployeeImporterBase.process(EmployeeImporterBase.java:226) at com.concur.services.importer.Feed.processRecord(Feed.java:325) at com.concur.services.importer.Feed.processLine(Feed.java:288) at com.concur.services.importer.Feed.process(Feed.java:193) at com.concur.services.importer.ConcurImporterService.importSingleFile(ConcurImporterService.java:429) at com.concur.services.importer.ConcurImporterService.importFile(ConcurImporterService.java:159) at com.concur.services.importer.ConcurImporterService.runJob(ConcurImporterService.java:866) at com.concur.util.jobs.JobRunner.runJob(JobRunner.java:105) at com.concur.services.cron.DefaultCronJob.runJob(DefaultCronJob.java:202) at com.concur.services.cron.DefaultCronJob.execute(DefaultCronJob.java:318) at com.concur.services.cron.JobThread.processJob(JobThread.java:80) at com.concur.services.cron.JobThread.run(JobThread.java:65) Caused by: org.apache.torque.TorqueException: java.sql.SQLDataException: [SEAPR1DB0034]String or binary data would be truncated. Msg 8152, Level 16, State 13, Line 1, Sqlstate 22001 at org.apache.torque.util.BasePeer.throwTorqueExce
As a result the profile is not created in Concur.
Read more...
Environment
Product
Keywords
Exception on import preventing the creation of employee profile , KBA , CON-CA-ADM , Administration , CON-CA-TLS-IEM , Import / Extract Monitor , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview