欢迎使用普元产品知识库,本知识库包含普元应用开发平台EOSPlatform,流程平台BPS,企业服务总线ESB,微服务平台Microservice,运维管理平台Devops,数据集成平台DI

页面树结构

欢迎使用普元文档库

Skip to end of metadata
Go to start of metadata

问题描述DI6.2studio在执行作业模型的时候发生异常,异常信息如下:

 

2017/11/02 14:51:45 - 表输入 2.0 - ERROR (version 6.2.0.0) : Unexpected error
2017/11/02 14:51:45 - 表输入 2.0 - ERROR (version 6.2.0.0) : com.primeton.di.core.exception.DataIntegrationDatabaseException: 
2017/11/02 14:51:45 - 表输入 2.0 - Couldn't get row from result set
2017/11/02 14:51:45 - 表输入 2.0 - 
2017/11/02 14:51:45 - 表输入 2.0 - Unable to get value 'String(9999999)' from database resultset, index 3
2017/11/02 14:51:45 - 表输入 2.0 - Io 异常: 无法从套接字读取更多的数据
2017/11/02 14:51:45 - 表输入 2.0 - 
2017/11/02 14:51:45 - 表输入 2.0 - 
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.database.Database.getRow(Database.java:2448)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.database.Database.getRow(Database.java:2404)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:145)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.trans.step.RunThread.run(RunThread.java:62)
2017/11/02 14:51:45 - 表输入 2.0 - 	at java.lang.Thread.run(Thread.java:745)
2017/11/02 14:51:45 - 表输入 2.0 - Caused by: com.primeton.di.core.exception.DataIntegrationDatabaseException: 
2017/11/02 14:51:45 - 表输入 2.0 - Unable to get value 'String(9999999)' from database resultset, index 3
2017/11/02 14:51:45 - 表输入 2.0 - Io 异常: 无法从套接字读取更多的数据
2017/11/02 14:51:45 - 表输入 2.0 - 
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4758)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.database.BaseDatabaseMeta.getValueFromResultSet(BaseDatabaseMeta.java:2069)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.database.DatabaseMeta.getValueFromResultSet(DatabaseMeta.java:2842)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.database.Database.getRow(Database.java:2440)
2017/11/02 14:51:45 - 表输入 2.0 - 	... 4 more
2017/11/02 14:51:45 - 表输入 2.0 - Caused by: java.sql.SQLException: Io 异常: 无法从套接字读取更多的数据
2017/11/02 14:51:45 - 表输入 2.0 - 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2017/11/02 14:51:45 - 表输入 2.0 - 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2017/11/02 14:51:45 - 表输入 2.0 - 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
2017/11/02 14:51:45 - 表输入 2.0 - 	at oracle.jdbc.driver.ClobAccessor.getString(ClobAccessor.java:244)
2017/11/02 14:51:45 - 表输入 2.0 - 	at oracle.jdbc.driver.T4CClobAccessor.getString(T4CClobAccessor.java:70)
2017/11/02 14:51:45 - 表输入 2.0 - 	at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:397)
2017/11/02 14:51:45 - 表输入 2.0 - 	at com.primeton.di.core.row.value.ValueMetaBase.getValueFromResultSet(ValueMetaBase.java:4725)
2017/11/02 14:51:45 - 表输入 2.0 - 	... 7 more
2017/11/02 14:51:45 - 表输入 2.0 - Finished reading query, closing connection.
2017/11/02 14:51:45 -  - ERROR (version 6.2.0.0) : Error disconnecting from database:
2017/11/02 14:51:45 -  - 
2017/11/02 14:51:45 -  - Error comitting connection
2017/11/02 14:51:45 -  - 无法从套接字读取更多的数据
2017/11/02 14:51:45 -  - ERROR (version 6.2.0.0) : com.primeton.di.core.exception.DataIntegrationDatabaseException: 
2017/11/02 14:51:45 -  - Error comitting connection
2017/11/02 14:51:45 -  - 无法从套接字读取更多的数据
2017/11/02 14:51:45 -  - 
2017/11/02 14:51:45 -  - 	at com.primeton.di.core.database.Database.commit(Database.java:774)
2017/11/02 14:51:45 -  - 	at com.primeton.di.core.database.Database.commit(Database.java:746)
2017/11/02 14:51:45 -  - 	at com.primeton.di.core.database.Database.disconnect(Database.java:619)
2017/11/02 14:51:45 -  - 	at com.primeton.di.trans.steps.tableinput.TableInput.dispose(TableInput.java:271)
2017/11/02 14:51:45 -  - 	at com.primeton.di.trans.step.RunThread.run(RunThread.java:96)
2017/11/02 14:51:45 -  - 	at java.lang.Thread.run(Thread.java:745)
2017/11/02 14:51:45 -  - Caused by: java.sql.SQLException: 无法从套接字读取更多的数据
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:106)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:523)
2017/11/02 14:51:45 -  - 	at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1128)
2017/11/02 14:51:45 -  - 	at com.primeton.di.core.database.Database.commit(Database.java:765)

解决方案:此问题是由于现场使用的数据库服务进行了重启,或者链接数据库的网络连接异常引起的。