String or binary data would be truncated

[Former Member]

Hi,

While trying to add a company in the SLD (automated) the job is getting stuck in the queue with IPO-Step status exception

com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested
exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception:
java.sql.BatchUpdateException: String or binary data would be truncated.

If I look for IPO log:

#9519616 --- 2013-05-02T16:57:32, millis=1367510252429

Level  SEVERE
Logger com.sap.b1i.xcellerator
Class/Method com.sap.b1i.bizprocessor.BizProcException, dumpBPEx
Thread 334259

com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: java.sql.BatchUpdateException: String or binary data would be truncated.
at com.sap.b1i.bizprocessor.BizStoreAccessor.endTransaction(BizStoreAccessor.java:4573)
at com.sap.b1i.xcellerator.IPOWorkResource.finalizeBstAndQAndWConn(IPOWorkResource.java:539)
at com.sap.b1i.xcellerator.IPOWorkResource.execute(IPOWorkResource.java:442)
at com.sap.b1i.xcellerator.IPOStepInstance.executeInner(IPOStepInstance.java:680)
at com.sap.b1i.xcellerator.IPOStepInstance.executeOuter(IPOStepInstance.java:515)
at com.sap.b1i.xcellerator.Xcellerator.trigger(Xcellerator.java:1387)
at com.sap.b1i.xcellerator.SingleAdapterPool.trigger(SingleAdapterPool.java:486)
at com.sap.b1i.xcellerator.XclScheduler$JobRunner$JobThread.run(XclScheduler.java:295)
Caused by: java.sql.BatchUpdateException: String or binary data would be truncated.
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1132)
at com.sap.b1i.dblayer.WriteStmnt.execute(WriteStmnt.java:73)
at com.sap.b1i.bizprocessor.BizStoreAccessor$A11d.<init>(BizStoreAccessor.java:2112)
at com.sap.b1i.bizprocessor.BizStoreAccessor$A11d.<init>(BizStoreAccessor.java:2078)
at com.sap.b1i.bizprocessor.BizStoreAccessor$ApplyCollector.deferredWrite(BizStoreAccessor.java:3324)
at com.sap.b1i.bizprocessor.BizStoreAccessor$ApplyCollector.access$7000(BizStoreAccessor.java:2894)
at com.sap.b1i.bizprocessor.BizStoreAccessor.endTransaction(BizStoreAccessor.java:4548)
... 7 more

tried to reactivate however no avail.

I can add the company manually no issues.

cleared the company from the SLSP and SLSPP tables and checked the queue still the same error.

It is only occuring on a few companies in a list of more than 60 companies, any suggestions please?

thanking you in anticipation.

Regards,

Kumar

[Former Member · Accepted solution]

It was due to database name too long.

B1i by default consider database name in format - <servername>!!<databasename>

there is a limit of 50 charaters upto SAP 8.82 PL11 and 100 for SAP PL11<