同步结果只返回同步失败，无具体报错信息，如下图详细报错信息如下：com.fr.third.org.hibernate.exception.DataException: could not execute batch at com.fr.third.org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:118) at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:119) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:97) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:147) at com.fr.third.org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:236) at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:617) at com.fr.third.org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:462) at com.fr.third.org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337) at com.fr.third.org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39) at com.fr.third.org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1294) at com.fr.stable.db.session.SessionManager$DBSessionImpl.flush(SessionManager.java) at com.fr.stable.db.session.DAOSessionStore$1.remove(DAOSessionStore.java) at com.fr.stable.db.dao.BaseDAO.remove(BaseDAO.java) at com.fr.decision.authority.controller.DepartmentControllerImpl.removeDepRoleWithoutAuthority(Unknown Source) at com.fr.decision.sync.work.impl.DepRoleSyncWork.removeDepRole(Unknown Source) at com.fr.decision.sync.work.impl.DepRoleSyncWork.delete(Unknown Source) at com.fr.decision.sync.TableDataSyncAction.delete(Unknown Source) at com.fr.decision.sync.TableDataSyncAction.execute(Unknown Source) at com.fr.decision.authority.controller.personnel.PersonnelActionManager.execute(Unknown Source) at com.fr.decision.authority.controller.personnel.PersonnelActionManager.doWork(Unknown Source) at com.fr.decision.authority.AuthorityContext.doPersonnelWork(Unknown Source) at com.fr.decision.webservice.v10.user.SyncService.synchronize(Unknown Source) at com.fr.decision.webservice.v10.user.SyncService.lambda$setSyncConfig$0(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)Caused by: java.sql.BatchUpdateException: 将截断字符串或二进制数据。 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeBatch(SQLServerPreparedStatement.java:1870) at com.fr.third.alibaba.druid.pool.DruidPooledPreparedStatement.executeBatch(DruidPooledPreparedStatement.java:558) at com.fr.third.org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:110) ... 24 more求助这种报错排查思路
