SAP Knowledge Base Article - Preview

3820803 - 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...."

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

Expense > Jobs Data Transfer/Transmission Expense > Jobs Imports

Product

Concur Expense all versions

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.