组织单元保存提交报错：提示重连
EAS Cloud-知识分享
金蝶云社区-张世军
张世军
0人赞赏了该文章 657次浏览 未经作者许可，禁止转载编辑于2017年03月03日 20:24:06

错误信息：null
Caused exception message is: Sql222 execute exception : insert into T_ORG_Admin (
FID,
FName_L1,
FName_L2,
FName_L3,
FNumber,
FDescription_L1,
FDescription_L2,
FDescription_L3,
FSimpleName,
FIsGrouping,
FEffectDate,
FInvalidDate,
FIsFreeze,
FIsCompanyOrgUnit,
FIsAdminOrgUnit,
FIsSaleOrgUnit,
FIsPurchaseOrgUnit,
FIsStorageOrgUnit,
FIsProfitOrgUnit,
FIsCostOrgUnit,
FIsCU,
FIsUnion,
FIsHROrgUnit,
FCreatorID,
FCreateTime,
FLastUpdateUserID,
FLastUpdateTime,
FControlUnitID,
FIsLeaf,
FLevel,
FLongNumber,
FParentID,
FIsEntity,
FIsVirtual,
FPhoneNumber,
FLayerID,
FResponPositionID,
FAddressID,
FAreaID,
FPrincipalID,
FLayerTypeID,
FBaseDuty_L1,
FBaseDuty_L2,
FBaseDuty_L3,
FIndex,
FJobSystemID,
FAdminAddress_L1,
FAdminAddress_L2,
FAdminAddress_L3,
FZipCode,
FFax,
FIsSealUp,
FIsStart,
FIsOUSealUp ,
FDisplayName_L1,
FDisplayName_L2,
FDisplayName_L3,
FPropertySealUpDate,
FVersionNumber,
FCode,
FIsTransportOrgUnit,
FIsQualityOrgUnit,
FIndustryID,
FSortCode,
FEconomicType,
FRegisteredCapital,
FRegisteredCode,
FSetupDate,
FEndupDate,
FTaxNumber,
FOrgCode,
FIsChurchyard,
FJuridicalPersonID,
FIsJuridicalCompany,
FIsIndependence,
forgTypeStr,
FTerritory_L1,
FTerritory_L2,
FTerritory_L3)
SELECT
ou.FID,
ou.FName_L1,
ou.FName_L2,
ou.FName_L3,
ou.FNumber,
ou.FDescription_L1,
ou.FDescription_L2,
ou.FDescription_L3,
ou.FSimpleName,
ou.FIsGrouping,
ou.FEffectDate,
ou.FInvalidDate,
ou.FIsFreeze,
ou.FIsCompanyOrgUnit,
ou.FIsAdminOrgUnit,
ou.FIsSaleOrgUnit,
ou.FIsPurchaseOrgUnit,
ou.FIsStorageOrgUnit,
ou.FIsProfitOrgUnit,
ou.FIsCostOrgUnit,
ou.FIsCU,
ou.FIsUnion,
ou.FIsHROrgUnit,
ou.FCreatorID,
ou.FCreateTime,
ou.FLastUpdateUserID,
ou.FLastUpdateTime,
adm.FControlUnitID,
stru.FIsLeaf,
stru.FLevel,
stru.FLongNumber,
stru1.FUnitId AS FParentID,
adm.FIsEntity,
adm.FIsVirtual,
adm.FPhoneNumber,
adm.FLayerID,
adm.FResponPositionID,
adm.FAddressID,
adm.FAreaID,
adm.FPrincipalID,
adm.FLayerTypeID,
adm.FBaseDuty_L1,
adm.FBaseDuty_L2,
adm.FBaseDuty_L3,
adm.FIndex,
adm.FJobSystemID,
adm.FAdminAddress_L1,
adm.FAdminAddress_L2,
adm.FAdminAddress_L3,
adm.FZipCode,
adm.FFax,
adm.FIsSealUp,
ou.FIsStart,
ou.FIsOUSealUp,
stru.FDisplayName_L1,
stru.FDisplayName_L2,
stru.FDisplayName_L3,
adm.FPropertySealUpDate,
ou.FVersionNumber,
ou.FCode,
ou.FIsTransportOrgUnit,
ou.FIsQualityOrgUnit,
adm.FIndustryID,
stru.FSortCode,
adm.FEconomicType,
adm.FRegisteredCapital,
adm.FRegisteredCode,
adm.FSetupDate,
adm.FEndupDate,
adm.FTaxNumber,
adm.FOrgCode,
adm.FIsChurchyard,
adm.FJuridicalPersonID,
adm.FIsJuridicalCompany,
adm.FIsIndependence,
ou.forgTypeStr,
adm.FTerritory_L1,
adm.FTerritory_L2,
adm.FTerritory_L3
FROM T_ORG_BaseUnit ou INNER JOIN
T_ORG_Structure stru ON ou.FID = stru.FUnitId LEFT OUTER JOIN
T_ORG_Structure stru1 ON stru.FParentID = stru1.FID INNER JOIN
T_ORG_OUPartAdmin adm ON ou.FID = adm.FUnitID
WHERE (stru.FTreeId = '00000000-0000-0000-0000-0000000000034F2827FD')
and (ou.fid=? OR stru.flongnumber like ?)
Caused exception message is: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
错误详细堆栈信息：com.kingdee.bos.BOSException: null
Caused exception message is: Sql222 execute exception : insert into T_ORG_Admin (
FID,
FName_L1,
FName_L2,
FName_L3,
FNumber,
FDescription_L1,
FDescription_L2,
FDescription_L3,
FSimpleName,
FIsGrouping,
FEffectDate,
FInvalidDate,
FIsFreeze,
FIsCompanyOrgUnit,
FIsAdminOrgUnit,
FIsSaleOrgUnit,
FIsPurchaseOrgUnit,
FIsStorageOrgUnit,
FIsProfitOrgUnit,
FIsCostOrgUnit,
FIsCU,
FIsUnion,
FIsHROrgUnit,
FCreatorID,
FCreateTime,
FLastUpdateUserID,
FLastUpdateTime,
FControlUnitID,
FIsLeaf,
FLevel,
FLongNumber,
FParentID,
FIsEntity,
FIsVirtual,
FPhoneNumber,
FLayerID,
FResponPositionID,
FAddressID,
FAreaID,
FPrincipalID,
FLayerTypeID,
FBaseDuty_L1,
FBaseDuty_L2,
FBaseDuty_L3,
FIndex,
FJobSystemID,
FAdminAddress_L1,
FAdminAddress_L2,
FAdminAddress_L3,
FZipCode,
FFax,
FIsSealUp,
FIsStart,
FIsOUSealUp ,
FDisplayName_L1,
FDisplayName_L2,
FDisplayName_L3,
FPropertySealUpDate,
FVersionNumber,
FCode,
FIsTransportOrgUnit,
FIsQualityOrgUnit,
FIndustryID,
FSortCode,
FEconomicType,
FRegisteredCapital,
FRegisteredCode,
FSetupDate,
FEndupDate,
FTaxNumber,
FOrgCode,
FIsChurchyard,
FJuridicalPersonID,
FIsJuridicalCompany,
FIsIndependence,
forgTypeStr,
FTerritory_L1,
FTerritory_L2,
FTerritory_L3)
SELECT
ou.FID,
ou.FName_L1,
ou.FName_L2,
ou.FName_L3,
ou.FNumber,
ou.FDescription_L1,
ou.FDescription_L2,
ou.FDescription_L3,
ou.FSimpleName,
ou.FIsGrouping,
ou.FEffectDate,
ou.FInvalidDate,
ou.FIsFreeze,
ou.FIsCompanyOrgUnit,
ou.FIsAdminOrgUnit,
ou.FIsSaleOrgUnit,
ou.FIsPurchaseOrgUnit,
ou.FIsStorageOrgUnit,
ou.FIsProfitOrgUnit,
ou.FIsCostOrgUnit,
ou.FIsCU,
ou.FIsUnion,
ou.FIsHROrgUnit,
ou.FCreatorID,
ou.FCreateTime,
ou.FLastUpdateUserID,
ou.FLastUpdateTime,
adm.FControlUnitID,
stru.FIsLeaf,
stru.FLevel,
stru.FLongNumber,
stru1.FUnitId AS FParentID,
adm.FIsEntity,
adm.FIsVirtual,
adm.FPhoneNumber,
adm.FLayerID,
adm.FResponPositionID,
adm.FAddressID,
adm.FAreaID,
adm.FPrincipalID,
adm.FLayerTypeID,
adm.FBaseDuty_L1,
adm.FBaseDuty_L2,
adm.FBaseDuty_L3,
adm.FIndex,
adm.FJobSystemID,
adm.FAdminAddress_L1,
adm.FAdminAddress_L2,
adm.FAdminAddress_L3,
adm.FZipCode,
adm.FFax,
adm.FIsSealUp,
ou.FIsStart,
ou.FIsOUSealUp,
stru.FDisplayName_L1,
stru.FDisplayName_L2,
stru.FDisplayName_L3,
adm.FPropertySealUpDate,
ou.FVersionNumber,
ou.FCode,
ou.FIsTransportOrgUnit,
ou.FIsQualityOrgUnit,
adm.FIndustryID,
stru.FSortCode,
adm.FEconomicType,
adm.FRegisteredCapital,
adm.FRegisteredCode,
adm.FSetupDate,
adm.FEndupDate,
adm.FTaxNumber,
adm.FOrgCode,
adm.FIsChurchyard,
adm.FJuridicalPersonID,
adm.FIsJuridicalCompany,
adm.FIsIndependence,
ou.forgTypeStr,
adm.FTerritory_L1,
adm.FTerritory_L2,
adm.FTerritory_L3
FROM T_ORG_BaseUnit ou INNER JOIN
T_ORG_Structure stru ON ou.FID = stru.FUnitId LEFT OUTER JOIN
T_ORG_Structure stru1 ON stru.FParentID = stru1.FID INNER JOIN
T_ORG_OUPartAdmin adm ON ou.FID = adm.FUnitID
WHERE (stru.FTreeId = '00000000-0000-0000-0000-0000000000034F2827FD')
and (ou.fid=? OR stru.flongnumber like ?)
Caused exception message is: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean._rebuildSpecialTables(OrgSpecialTablesRebuildFacadeControllerBean.java:191)
at com.kingdee.eas.basedata.org.app.AbstractOrgSpecialTablesRebuildFacadeControllerBean.rebuildSpecialTables(AbstractOrgSpecialTablesRebuildFacadeControllerBean.java:87)
at sun.reflect.GeneratedMethodAccessor623.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy494.rebuildSpecialTables(Unknown Source)
at com.kingdee.eas.basedata.org.OrgSpecialTablesRebuildFacade.rebuildSpecialTables(OrgSpecialTablesRebuildFacade.java:69)
at sun.reflect.GeneratedMethodAccessor622.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at $Proxy493.rebuildSpecialTables(Unknown Source)
at com.kingdee.eas.basedata.org.app.FullOrgUnitControllerBean._update(FullOrgUnitControllerBean.java:409)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.update(AbstractCoreBaseControllerBean.java:179)
at com.kingdee.eas.framework.app.CoreBaseControllerBean._submit(CoreBaseControllerBean.java:169)
at com.kingdee.eas.framework.app.DataBaseControllerBean._submit(DataBaseControllerBean.java:366)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.submit(AbstractCoreBaseControllerBean.java:455)
at sun.reflect.GeneratedMethodAccessor381.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy144.submit(Unknown Source)
at com.kingdee.eas.framework.CoreBase.submit(CoreBase.java:287)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_IFullOrgUnit.pi6(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_IFullOrgUnit.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: com.kingdee.bos.BOSException: Sql222 execute exception : insert into T_ORG_Admin (
FID,
FName_L1,
FName_L2,
FName_L3,
FNumber,
FDescription_L1,
FDescription_L2,
FDescription_L3,
FSimpleName,
FIsGrouping,
FEffectDate,
FInvalidDate,
FIsFreeze,
FIsCompanyOrgUnit,
FIsAdminOrgUnit,
FIsSaleOrgUnit,
FIsPurchaseOrgUnit,
FIsStorageOrgUnit,
FIsProfitOrgUnit,
FIsCostOrgUnit,
FIsCU,
FIsUnion,
FIsHROrgUnit,
FCreatorID,
FCreateTime,
FLastUpdateUserID,
FLastUpdateTime,
FControlUnitID,
FIsLeaf,
FLevel,
FLongNumber,
FParentID,
FIsEntity,
FIsVirtual,
FPhoneNumber,
FLayerID,
FResponPositionID,
FAddressID,
FAreaID,
FPrincipalID,
FLayerTypeID,
FBaseDuty_L1,
FBaseDuty_L2,
FBaseDuty_L3,
FIndex,
FJobSystemID,
FAdminAddress_L1,
FAdminAddress_L2,
FAdminAddress_L3,
FZipCode,
FFax,
FIsSealUp,
FIsStart,
FIsOUSealUp ,
FDisplayName_L1,
FDisplayName_L2,
FDisplayName_L3,
FPropertySealUpDate,
FVersionNumber,
FCode,
FIsTransportOrgUnit,
FIsQualityOrgUnit,
FIndustryID,
FSortCode,
FEconomicType,
FRegisteredCapital,
FRegisteredCode,
FSetupDate,
FEndupDate,
FTaxNumber,
FOrgCode,
FIsChurchyard,
FJuridicalPersonID,
FIsJuridicalCompany,
FIsIndependence,
forgTypeStr,
FTerritory_L1,
FTerritory_L2,
FTerritory_L3)
SELECT
ou.FID,
ou.FName_L1,
ou.FName_L2,
ou.FName_L3,
ou.FNumber,
ou.FDescription_L1,
ou.FDescription_L2,
ou.FDescription_L3,
ou.FSimpleName,
ou.FIsGrouping,
ou.FEffectDate,
ou.FInvalidDate,
ou.FIsFreeze,
ou.FIsCompanyOrgUnit,
ou.FIsAdminOrgUnit,
ou.FIsSaleOrgUnit,
ou.FIsPurchaseOrgUnit,
ou.FIsStorageOrgUnit,
ou.FIsProfitOrgUnit,
ou.FIsCostOrgUnit,
ou.FIsCU,
ou.FIsUnion,
ou.FIsHROrgUnit,
ou.FCreatorID,
ou.FCreateTime,
ou.FLastUpdateUserID,
ou.FLastUpdateTime,
adm.FControlUnitID,
stru.FIsLeaf,
stru.FLevel,
stru.FLongNumber,
stru1.FUnitId AS FParentID,
adm.FIsEntity,
adm.FIsVirtual,
adm.FPhoneNumber,
adm.FLayerID,
adm.FResponPositionID,
adm.FAddressID,
adm.FAreaID,
adm.FPrincipalID,
adm.FLayerTypeID,
adm.FBaseDuty_L1,
adm.FBaseDuty_L2,
adm.FBaseDuty_L3,
adm.FIndex,
adm.FJobSystemID,
adm.FAdminAddress_L1,
adm.FAdminAddress_L2,
adm.FAdminAddress_L3,
adm.FZipCode,
adm.FFax,
adm.FIsSealUp,
ou.FIsStart,
ou.FIsOUSealUp,
stru.FDisplayName_L1,
stru.FDisplayName_L2,
stru.FDisplayName_L3,
adm.FPropertySealUpDate,
ou.FVersionNumber,
ou.FCode,
ou.FIsTransportOrgUnit,
ou.FIsQualityOrgUnit,
adm.FIndustryID,
stru.FSortCode,
adm.FEconomicType,
adm.FRegisteredCapital,
adm.FRegisteredCode,
adm.FSetupDate,
adm.FEndupDate,
adm.FTaxNumber,
adm.FOrgCode,
adm.FIsChurchyard,
adm.FJuridicalPersonID,
adm.FIsJuridicalCompany,
adm.FIsIndependence,
ou.forgTypeStr,
adm.FTerritory_L1,
adm.FTerritory_L2,
adm.FTerritory_L3
FROM T_ORG_BaseUnit ou INNER JOIN
T_ORG_Structure stru ON ou.FID = stru.FUnitId LEFT OUTER JOIN
T_ORG_Structure stru1 ON stru.FParentID = stru1.FID INNER JOIN
T_ORG_OUPartAdmin adm ON ou.FID = adm.FUnitID
WHERE (stru.FTreeId = '00000000-0000-0000-0000-0000000000034F2827FD')
and (ou.fid=? OR stru.flongnumber like ?)
Caused exception message is: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:304)
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean.specialTableOperate(OrgSpecialTablesRebuildFacadeControllerBean.java:236)
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean._rebuildSpecialTables(OrgSpecialTablesRebuildFacadeControllerBean.java:170)
... 39 more
Caused by: java.sql.SQLException: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:294)
... 41 more
Caused by: com.kingdee.bos.BOSException
com.kingdee.bos.BOSException: Sql222 execute exception : insert into T_ORG_Admin (
FID,
FName_L1,
FName_L2,
FName_L3,
FNumber,
FDescription_L1,
FDescription_L2,
FDescription_L3,
FSimpleName,
FIsGrouping,
FEffectDate,
FInvalidDate,
FIsFreeze,
FIsCompanyOrgUnit,
FIsAdminOrgUnit,
FIsSaleOrgUnit,
FIsPurchaseOrgUnit,
FIsStorageOrgUnit,
FIsProfitOrgUnit,
FIsCostOrgUnit,
FIsCU,
FIsUnion,
FIsHROrgUnit,
FCreatorID,
FCreateTime,
FLastUpdateUserID,
FLastUpdateTime,
FControlUnitID,
FIsLeaf,
FLevel,
FLongNumber,
FParentID,
FIsEntity,
FIsVirtual,
FPhoneNumber,
FLayerID,
FResponPositionID,
FAddressID,
FAreaID,
FPrincipalID,
FLayerTypeID,
FBaseDuty_L1,
FBaseDuty_L2,
FBaseDuty_L3,
FIndex,
FJobSystemID,
FAdminAddress_L1,
FAdminAddress_L2,
FAdminAddress_L3,
FZipCode,
FFax,
FIsSealUp,
FIsStart,
FIsOUSealUp ,
FDisplayName_L1,
FDisplayName_L2,
FDisplayName_L3,
FPropertySealUpDate,
FVersionNumber,
FCode,
FIsTransportOrgUnit,
FIsQualityOrgUnit,
FIndustryID,
FSortCode,
FEconomicType,
FRegisteredCapital,
FRegisteredCode,
FSetupDate,
FEndupDate,
FTaxNumber,
FOrgCode,
FIsChurchyard,
FJuridicalPersonID,
FIsJuridicalCompany,
FIsIndependence,
forgTypeStr,
FTerritory_L1,
FTerritory_L2,
FTerritory_L3)
SELECT
ou.FID,
ou.FName_L1,
ou.FName_L2,
ou.FName_L3,
ou.FNumber,
ou.FDescription_L1,
ou.FDescription_L2,
ou.FDescription_L3,
ou.FSimpleName,
ou.FIsGrouping,
ou.FEffectDate,
ou.FInvalidDate,
ou.FIsFreeze,
ou.FIsCompanyOrgUnit,
ou.FIsAdminOrgUnit,
ou.FIsSaleOrgUnit,
ou.FIsPurchaseOrgUnit,
ou.FIsStorageOrgUnit,
ou.FIsProfitOrgUnit,
ou.FIsCostOrgUnit,
ou.FIsCU,
ou.FIsUnion,
ou.FIsHROrgUnit,
ou.FCreatorID,
ou.FCreateTime,
ou.FLastUpdateUserID,
ou.FLastUpdateTime,
adm.FControlUnitID,
stru.FIsLeaf,
stru.FLevel,
stru.FLongNumber,
stru1.FUnitId AS FParentID,
adm.FIsEntity,
adm.FIsVirtual,
adm.FPhoneNumber,
adm.FLayerID,
adm.FResponPositionID,
adm.FAddressID,
adm.FAreaID,
adm.FPrincipalID,
adm.FLayerTypeID,
adm.FBaseDuty_L1,
adm.FBaseDuty_L2,
adm.FBaseDuty_L3,
adm.FIndex,
adm.FJobSystemID,
adm.FAdminAddress_L1,
adm.FAdminAddress_L2,
adm.FAdminAddress_L3,
adm.FZipCode,
adm.FFax,
adm.FIsSealUp,
ou.FIsStart,
ou.FIsOUSealUp,
stru.FDisplayName_L1,
stru.FDisplayName_L2,
stru.FDisplayName_L3,
adm.FPropertySealUpDate,
ou.FVersionNumber,
ou.FCode,
ou.FIsTransportOrgUnit,
ou.FIsQualityOrgUnit,
adm.FIndustryID,
stru.FSortCode,
adm.FEconomicType,
adm.FRegisteredCapital,
adm.FRegisteredCode,
adm.FSetupDate,
adm.FEndupDate,
adm.FTaxNumber,
adm.FOrgCode,
adm.FIsChurchyard,
adm.FJuridicalPersonID,
adm.FIsJuridicalCompany,
adm.FIsIndependence,
ou.forgTypeStr,
adm.FTerritory_L1,
adm.FTerritory_L2,
adm.FTerritory_L3
FROM T_ORG_BaseUnit ou INNER JOIN
T_ORG_Structure stru ON ou.FID = stru.FUnitId LEFT OUTER JOIN
T_ORG_Structure stru1 ON stru.FParentID = stru1.FID INNER JOIN
T_ORG_OUPartAdmin adm ON ou.FID = adm.FUnitID
WHERE (stru.FTreeId = '00000000-0000-0000-0000-0000000000034F2827FD')
and (ou.fid=? OR stru.flongnumber like ?)
Caused exception message is: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:304)
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean.specialTableOperate(OrgSpecialTablesRebuildFacadeControllerBean.java:236)
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean._rebuildSpecialTables(OrgSpecialTablesRebuildFacadeControllerBean.java:170)
at com.kingdee.eas.basedata.org.app.AbstractOrgSpecialTablesRebuildFacadeControllerBean.rebuildSpecialTables(AbstractOrgSpecialTablesRebuildFacadeControllerBean.java:87)
at sun.reflect.GeneratedMethodAccessor623.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy494.rebuildSpecialTables(Unknown Source)
at com.kingdee.eas.basedata.org.OrgSpecialTablesRebuildFacade.rebuildSpecialTables(OrgSpecialTablesRebuildFacade.java:69)
at sun.reflect.GeneratedMethodAccessor622.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at $Proxy493.rebuildSpecialTables(Unknown Source)
at com.kingdee.eas.basedata.org.app.FullOrgUnitControllerBean._update(FullOrgUnitControllerBean.java:409)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.update(AbstractCoreBaseControllerBean.java:179)
at com.kingdee.eas.framework.app.CoreBaseControllerBean._submit(CoreBaseControllerBean.java:169)
at com.kingdee.eas.framework.app.DataBaseControllerBean._submit(DataBaseControllerBean.java:366)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.submit(AbstractCoreBaseControllerBean.java:455)
at sun.reflect.GeneratedMethodAccessor381.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy144.submit(Unknown Source)
at com.kingdee.eas.framework.CoreBase.submit(CoreBase.java:287)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_IFullOrgUnit.pi6(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_IFullOrgUnit.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:294)
... 41 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-00001: unique constraint (JINHUI.PK_ORG_ADMIN) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:294)
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean.specialTableOperate(OrgSpecialTablesRebuildFacadeControllerBean.java:236)
at com.kingdee.eas.basedata.org.app.OrgSpecialTablesRebuildFacadeControllerBean._rebuildSpecialTables(OrgSpecialTablesRebuildFacadeControllerBean.java:170)
at com.kingdee.eas.basedata.org.app.AbstractOrgSpecialTablesRebuildFacadeControllerBean.rebuildSpecialTables(AbstractOrgSpecialTablesRebuildFacadeControllerBean.java:87)
at sun.reflect.GeneratedMethodAccessor623.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy494.rebuildSpecialTables(Unknown Source)
at com.kingdee.eas.basedata.org.OrgSpecialTablesRebuildFacade.rebuildSpecialTables(OrgSpecialTablesRebuildFacade.java:69)
at sun.reflect.GeneratedMethodAccessor622.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at $Proxy493.rebuildSpecialTables(Unknown Source)
at com.kingdee.eas.basedata.org.app.FullOrgUnitControllerBean._update(FullOrgUnitControllerBean.java:409)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.update(AbstractCoreBaseControllerBean.java:179)
at com.kingdee.eas.framework.app.CoreBaseControllerBean._submit(CoreBaseControllerBean.java:169)
at com.kingdee.eas.framework.app.DataBaseControllerBean._submit(DataBaseControllerBean.java:366)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean.submit(AbstractCoreBaseControllerBean.java:455)
at sun.reflect.GeneratedMethodAccessor381.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:57)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy144.submit(Unknown Source)
at com.kingdee.eas.framework.CoreBase.submit(CoreBase.java:287)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_IFullOrgUnit.pi6(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_org_1_IFullOrgUnit.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)

Z)9)4K732CZG2B7NCYUX3E2.png(65.01KB)

推荐阅读

组织单元修改时总是提示尝试重连

在修改组织单元上级行政组织时，系统总是提示尝试重连，修改不了。 我在管理单元已经把上级管理单元修改了，但是组织单元总是修改不了。 说遇到过这个情况啊？ ,请提单 …

    文章

    1,880

新增核算项目,保存提示尝试重连

【解决方案】 EAS 8.1版本中可安装补丁PT144389来解决此问题，请更新至该补丁或最新补丁即可。 【说明】 安装补丁方法请参考补丁说明，并严格按照补丁说 …

    知识

    93

单据保存提交时报错：Duplicate co …

[图片] Duplicate column name错误解决方法 1、 第一步我们首先需要知道出现Duplicate column name错误，一般是sql语 …

    文章

    3,338