Cannot Save Projects in 11g BPA Architect: Save Operation Is Not Possible. Internal Error: Error During Data Transfer (Doc ID 1307401.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Business Process Analysis Suite - Version: 11.1.1.1.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms

Using BPA Architect 11g connected to a Repository Server which is connected to an Oracle database. The connection from the Repository Server to the database is working, meaning that it was possible to start the Repository Server without any issues and Architect can also connect fine to the Repository Server.

However, when attempting to save any changes to a database project in Architect, it fails with:

"Save operation is not possible. Internal error: Error during data transfer. No more data to read from socket".

Restarting the Architect and/or the Repository Server has no positive impact.

Observing the Repository Server logfile at ...\Oracle BPA Suite11g\server\log\internalerr0.log similar errors will be seen:

2011-03-22T12:05:37,240 com.idsscheer.aris.server.Exceptions - Exception, userinfo: DB: Business Process Repository, user: abc, client: app=Oracle Business Process Architect 11gR1; user=abc@129454.oracle.com; pid=; exe=Oracle Business Process Architect 11gR1; ip=10.10.10.10; pattern=Architect
com.idsscheer.aris.server.bl.logic.web.ABLHelper.printUnexpectedException
com.idsscheer.aris.server.ul.AULLoginException: No more data to read from socket, SQL: SELECT /*+ FIRST_ROWS */ v0.DISCRIMINATOR,v0.DefinitionID,v0.Position_X,v0.Position_Y,v0.Flags,v0.Hints,v0.UnionID,v0.ModelID,v0.BizOccID,v0.Size_X,v0.Size_Y,v0.ID,v0.Pen_Width,v0.Pen_Style,v0.Pen_Color,v0.TypeNum,v0.SymbolGUID,v0.ZOrder,v0.Brush_Type,v0.Brush_Color2,v0.Brush_Color,v0.SeqNum,v0.ExternalGUID,v0.ToObjOccID,v0.Points,v0.TgtArrow,v0.SrcArrow,v0.FromObjOccID,v0.Alignment,v0.Data FROM aris71adm.DB$10$Occ v0 WHERE v0.ModelID = ?
at com.idsscheer.aris.server.ul.aris.logic.AUserObjectManager.loadArisObjects(AUserObjectManager.java:902)
at com.idsscheer.aris.server.bl.logic.webactionobject.AActionObjectCollection.loadNetForSaveModel(AActionObjectCollection.java:630)
at com.idsscheer.aris.server.bl.logic.webactionobject.AActionObjectCollection.save(AActionObjectCollection.java:139)
at com.idsscheer.aris.server.bl.logic.webdesigner.ADesigner$16.execute(ADesigner.java:1307)
at com.idsscheer.aris.server.bl.logic.web.ABLExecuter.runWithExceptions(ABLExecuter.java:270)
at com.idsscheer.aris.server.bl.logic.web.ABLExecuter.run(ABLExecuter.java:164)
at com.idsscheer.aris.server.bl.logic.web.ABLExecuter.runAndTransformServerException(ABLExecuter.java:150)
at com.idsscheer.aris.server.bl.logic.webdesigner.ADesigner.save(ADesigner.java:1297)
at com.idsscheer.aris.cltech.common.core.webdesigner.IDesignerDelegate.save(IDesignerDelegate.java:54)
at com.idsscheer.aris.cltech.common.corba.webdesigner.IDesignerServant.save(IDesignerServant.java:92)
at com.idsscheer.aris.cltech.common.corba.webdesigner.IDesignerPOATie.save(IDesignerPOATie.java:102)
at com.idsscheer.aris.cltech.common.corba.webdesigner.IDesignerPOA._OB_op_save(IDesignerPOA.java:1838)
at com.idsscheer.aris.cltech.common.corba.webdesigner.IDesignerPOA._invoke(IDesignerPOA.java:380)
at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source)
at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source)
at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source)
at com.ooc.OB.ThreadPool$Dispatcher.run(Unknown Source)
.
.2011-03-24T13:42:23,529 com.idsscheer.aris.server.CannotBe - cannot be
com.idsscheer.aris.server.arisldap.AExternalIdentityServiceFactory.createExternalIdentityServiceAccess
DLException: OALL8 is in an inconsistent state
define plan LDAP_SETTINGS() as (select * from LDAPProperties)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef$ASimpleExecutionStrategy.doExecuteQuery(ANodeDef.java:460)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef$ASimpleExecutionStrategy.executeQuery(ANodeDef.java:415)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef.executeQuery(ANodeDef.java:1021)
at com.idsscheer.dl.logic.jdbcbased.qpleng.AQueryDef.doExecuteQuery(AQueryDef.java:117)
at com.idsscheer.dl.logic.jdbcbased.qpleng.AQueryDef.executeQuery(AQueryDef.java:110)
at com.idsscheer.dl.logic.base.qpleng.APreparedQueryPlan.executeQuery(APreparedQueryPlan.java:97)
at com.idsscheer.dl.logic.base.qpleng.APreparedQueryPlan.execute2(APreparedQueryPlan.java:69)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.prepareAndExecute(AUseCaseExecutor.java:78)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executeUseCase2(AUseCaseExecutor.java:55)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executeUseCase2(AUseCaseExecutor.java:43)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executeUseCase(AUseCaseExecutor.java:38)
at com.idsscheer.aris.server.arisldap.implementation.AExternalIdentityServiceSettingsHelper.getSettingsFromDb(AExternalIdentityServiceSettingsHelper.java:36)
at com.idsscheer.aris.server.arisldap.AExternalIdentityServiceFactory.createExternalIdentityServiceAccess(AExternalIdentityServiceFactory.java:47)
at com.idsscheer.aris.server.bl.admin.logic.jaas.ALoginModuleBase.connectDb(ALoginModuleBase.java:321)
at com.idsscheer.aris.server.bl.admin.logic.jaas.AArisLoginModule.testPwd(AArisLoginModule.java:52)
at com.idsscheer.aris.server.bl.admin.logic.jaas.ALoginModuleBase.login(ALoginModuleBase.java:151)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
at com.idsscheer.aris.server.bl.admin.logic.AArisUserAuthentication.checkLogin(AArisUserAuthentication.java:66)
at com.idsscheer.aris.server.bl.admin.logic.AArisUserAuthentication.testPwd(AArisUserAuthentication.java:50)
at com.idsscheer.aris.server.bl.logic.aris.AArisLogin.getInternalLoginContext(AArisLogin.java:310)
at com.idsscheer.aris.server.bl.logic.aris.AArisLogin.logininternal(AArisLogin.java:291)
at com.idsscheer.aris.server.bl.logic.aris.AArisLogin.login(AArisLogin.java:283)
at com.idsscheer.aris.cltech.common.core.aris.IArisLoginDelegate.login(IArisLoginDelegate.java:67)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginServant.login(IArisLoginServant.java:106)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOATie.login(IArisLoginPOATie.java:122)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOA._OB_op_login(IArisLoginPOA.java:226)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOA._invoke(IArisLoginPOA.java:122)
at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source)
at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source)
at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source)
at com.ooc.OB.ThreadPool$Dispatcher.run(Unknown Source)
Caused by: java.sql.SQLException: OALL8 is in an inconsistent state
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:439)
at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:470)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef$ASimpleExecutionStrategy.doExecuteQuery(ANodeDef.java:447)
... 38 more
..
2011-03-24T13:44:01,561 com.idsscheer.aris.server.Exceptions - exception
com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.getServerException
DLException: Closed Connection
define plan FILTERS(String :usr) as (select * from UserTbl where id in (select parentitemid from AttrTextDef<User> where AttrTypeNum = 1000 and textvalue TEQ :usr) (select * from usertousergroup reached by userid (select * from usergroup reached by usergroupid))) (select * from ArisRoot)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef$ASimpleExecutionStrategy.doExecuteQuery(ANodeDef.java:460)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef$ASimpleExecutionStrategy.executeQuery(ANodeDef.java:415)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef.executeQuery(ANodeDef.java:1021)
at com.idsscheer.dl.logic.jdbcbased.qpleng.AQueryDef.doExecuteQuery(AQueryDef.java:117)
at com.idsscheer.dl.logic.jdbcbased.qpleng.AQueryDef.executeQuery(AQueryDef.java:110)
at com.idsscheer.dl.logic.base.qpleng.APreparedQueryPlan.executeQuery(APreparedQueryPlan.java:97)
at com.idsscheer.dl.logic.base.qpleng.APreparedQueryPlan.execute2(APreparedQueryPlan.java:69)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.prepareAndExecute(AUseCaseExecutor.java:78)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executeUseCase2(AUseCaseExecutor.java:55)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executeUseCase2(AUseCaseExecutor.java:43)
at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executeUseCase(AUseCaseExecutor.java:38)
at com.idsscheer.aris.server.bl.logic.aris.AArisLogin.getFilters(AArisLogin.java:142)
at com.idsscheer.aris.cltech.common.core.aris.IArisLoginDelegate.getFilters(IArisLoginDelegate.java:51)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginServant.getFilters(IArisLoginServant.java:73)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOATie.getFilters(IArisLoginPOATie.java:97)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOA._OB_op_getFilters(IArisLoginPOA.java:205)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOA._invoke(IArisLoginPOA.java:119)
at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source)
at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source)
at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source)
at com.ooc.OB.ThreadPool$Dispatcher.run(Unknown Source)
Caused by: java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:439)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3046)
at com.idsscheer.dl.logic.jdbcbased.util.ADebugConnection.prepareStatement(ADebugConnection.java:266)
at com.idsscheer.dl.logic.jdbcbased.qpleng.ANodeDef$ASimpleExecutionStrategy.doExecuteQuery(ANodeDef.java:432)
... 20 more
.
.
2011-03-24T13:44:01,561 com.idsscheer.aris.server.Exceptions - Exception! Error during data transfer.(40002)
com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.logException
com.idsscheer.aris.cltech.common.core.ariscommon.ServerException
at com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.createServerException(AServerExceptionFactory.java:99)
at com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.createServerException(AServerExceptionFactory.java:109)
at com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.createException(AServerExceptionFactory.java:46)
at com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.getServerException(AServerExceptionFactory.java:245)
at com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.createServerException(AServerExceptionFactory.java:63)
at com.idsscheer.aris.server.bl.logic.aris.AServerExceptionFactory.createServerException(AServerExceptionFactory.java:85)
at com.idsscheer.aris.server.bl.logic.aris.AArisLogin.getFilters(AArisLogin.java:195)
at com.idsscheer.aris.cltech.common.core.aris.IArisLoginDelegate.getFilters(IArisLoginDelegate.java:51)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginServant.getFilters(IArisLoginServant.java:73)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOATie.getFilters(IArisLoginPOATie.java:97)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOA._OB_op_getFilters(IArisLoginPOA.java:205)
at com.idsscheer.aris.cltech.common.corba.aris.IArisLoginPOA._invoke(IArisLoginPOA.java:119)
at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source)
at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source)
at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source)
at com.ooc.OB.ThreadPool$Dispatcher.run(Unknown Source)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms