oracle无法减小列长度,中国港湾扩展表单分配时调整字段后保存时报错，无法正常维护表单定义...

版本号: 7.0.4

业务场景(如下):中国港湾扩展表单分配时调整字段后保存时报错，无法正常维护表单定义

异常提示:

异常信息:添加业务实体的时候出错。

导致错误的应用程序或对象的名称:Genersoft.Platform.RuntimeADP.Core

引发当前异常的方法:

异常相关帮助:

堆栈信息:

at Genersoft.Platform.RuntimeADP.Core.Manager.GSPBizEntityManager.AddBizEntityByFormID(IBusinessEntity entity, String baseEntityID, String bizFormID, Boolean& isEntityChanged)

at Genersoft.Platform.RuntimeADP.LocalClient.BizUnitLocalClient.AddBizEntityByFormID(IBusinessEntity entity, String baseEntityID, String bizFormID, Boolean& isEntityChanged, GSPState state)

at Genersoft.Platform.RuntimeADP.WebService.BizUnitWebService.AddBizEntityByFormID(BinaryReader reader, BinaryWriter writer)

内部异常:

异常提示:

异常信息:更新表结构出现异常，sql语句为：ALTER TABLE ROBXFK MODIFY ROBXFK_ZJJH varchar2(60),  ALTER TABLE ROBXFK MODIFY ROBXFK_JHXM varchar2(60),  ALTER TABLE ROBXFK MODIFY ROBXFK_KXXZ varchar2(60),  System.Data.OracleClient.OracleException (0x80131938): ORA-01441: 无法减小列长度, 因为一些值过大

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)

at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)

at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)

at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()

at Genersoft.Platform.Core.DataAccess.Database.ExecuteWithNoQuery(String[] cmdTextArray, Boolean isSqlStatement)

at Genersoft.Platform.Core.DataAccess.Database.ExecSqlStatement(String[] sqlStatements)

at Genersoft.Platform.Resource.ResourceManager.DataObjectManager.CreateDBTable(GspDataTable newObj, GspDataTable dbObj, String dataSrcCode)

导致错误的应用程序或对象的名称:Genersoft.Platform.Resource.DataObjectManager

引发当前异常的方法:

异常相关帮助:

堆栈信息:

at Genersoft.Platform.Resource.ResourceManager.DataObjectManager.CreateDBTable(GspDataTable newObj, GspDataTable dbObj, String dataSrcCode)

at Genersoft.Platform.Resource.ResourceManager.DataObjectManager.Create(GspDataTable gspDataTable)

at Genersoft.Platform.Resource.ResourceManager.DataObjectManager.CreateTableFromDataObject(GspDataTable gspDataTable, Boolean updateDataTableInfo, Boolean hasChange)

at Genersoft.Platform.RuntimeADP.Core.Manager.GSPBizEntityManager.SaveDataObjects(IBusinessEntity entity, Boolean isbase, Dictionary`2 dataTables, Boolean& isEntityChanged)

at Genersoft.Platform.RuntimeADP.Core.Manager.GSPBizEntityManager.SaveBizEntity(IBusinessEntity entity, Boolean isBase, BizUnitAssignment assignment, Boolean isSavingSelf, Boolean& isEntityChanged, Dictionary`2 dataTables)

at Genersoft.Platform.RuntimeADP.Core.Manager.GSPBizEntityManager.AddBizEntity(IBusinessEntity entity, BizUnitAssignment assignment, Boolean& isEntityChanged)

at Genersoft.Platform.RuntimeADP.Core.Manager.GSPBizEntityManager.AddBizEntityByFormID(IBusinessEntity entity, String baseEntityID, String bizFormID, Boolean& isEntityChanged)

内部异常:

异常提示:

异常信息:ORA-01441: 无法减小列长度, 因为一些值过大

导致错误的应用程序或对象的名称:System.Data.OracleClient

引发当前异常的方法:

异常相关帮助:

堆栈信息:

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)

at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)

at System.Data.OracleClient.OracleCommand.ExecuteNonQueryInternal(Boolean needRowid, OciRowidDescriptor& rowidDescriptor)

at System.Data.OracleClient.OracleCommand.ExecuteNonQuery()

at Genersoft.Platform.Core.DataAccess.Database.ExecuteWithNoQuery(String[] cmdTextArray, Boolean isSqlStatement)

at Genersoft.Platform.Core.DataAccess.Database.ExecSqlStatement(String[] sqlStatements)

at Genersoft.Platform.Resource.ResourceManager.DataObjectManager.CreateDBTable(GspDataTable newObj, GspDataTable dbObj, String dataSrcCode)

内部异常:{}

预期效果(如下):中国港湾扩展表单分配时调整字段后保存时能正常保存

实际效果(如下)(包括错误,异常):

操作步骤(如下):