Solved: connector service is stopped

Former Member · ‎03-26-2009

hi Gurus,

I got the error

com.sap.engine.services.connector.exceptions.BaseResourceException: "ConnectionManager" is closed

I sany solution?

Former Member · ‎03-26-2009

Could you please describe your problem a bit..

In the sense, what are you trying to achieve and when are you getting this error?

Former Member · ‎03-26-2009

Hi Manoj,

You have solved problem on your own You may remove the points awarded.

Regards,

Anagha

Former Member · ‎03-26-2009

problem solved

After patching, or some unexpected restart of JAVA,

the SAP JAVA schema user role may change to security admin,,

I removed this , and problem solved

Former Member · ‎03-26-2009

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.sap.nwmss.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)

at com.sap.nwmss.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeQuery(BasicPreparedStatement.java:97)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeQuery(DirectPreparedStatement.java:281)

at com.sap.sql.jdbc.common.CommonPreparedStatement.executeQuery(CommonPreparedStatement.java:185)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:249)

at com.sap.caf.eu.gp.schedule.impl.ScheduleDbImpl.getScheduleToProcess(ScheduleDbImpl.java:1948)

at com.sap.caf.eu.gp.schedule.impl.ScheduleService.getScheduleToProcess(ScheduleService.java:432)

at com.sap.caf.eu.gp.schedule.impl.ScheduleWorker.work(ScheduleWorker.java:77)

at com.sap.caf.eu.gp.schedule.impl.ScheduleWorker.run(ScheduleWorker.java:63)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

#

#1.5 #00219B89767C0084000727920000054C000465D950217ABD#1237883933535#/System/Database/sql/jdbc/direct##com.sap.sql.jdbc.direct.DirectPreparedStatement#J2EE_GUEST#0##n/a##b8607b22184e11de89ce00219b89767c#SAPEngine_Application_Thread[impl:3]_24##0#0#Error#1#com.sap.sql.jdbc.direct.DirectPreparedStatement#Java#com.sap.sql_0003#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection SAPPRODUCTION:TMK:SAPTMKDB: code=8,179, state="HY000", message="[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 3.";

SQL statement is "SELECT * FROM "JAVA" WHERE "NEXTEXEC" < ? AND "STATUS" = 1. ORDER BY 2".#5#8179#HY000#[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 3.#SAPPRODUCTION:TMK:SAPTMKDB#SELECT * FROM "JAVA" WHERE "NEXTEXEC" < ? AND "STATUS" = 1. ORDER BY 2#

#1.5 #00219B89767C0082000725040000054C000465D950217BD6#1237883933535#/System/Database/sql/jdbc/direct##com.sap.sql.jdbc.direct.DirectPreparedStatement#J2EE_GUEST#0##n/a##b8607b20184e11de9f2d00219b89767c#SAPEngine_Application_Thread[impl:3]_15##0#0#Error#1#com.sap.sql.jdbc.direct.DirectPreparedStatement#Java#com.sap.sql_0003#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection SAPPRODUCTION:TMK:SAPTMKDB: code=8,179, state="HY000", message="[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 3.";

SQL statement is "SELECT * FROM "JAVA" WHERE "NEXTEXEC" < ? AND "STATUS" = 1. ORDER BY 2".#5#8179#HY000#[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 3.#SAPPRODUCTION:TMK:SAPTMKDB#SELECT * FROM "JAVA" WHERE "NEXTEXEC" < ? AND "STATUS" = 1. ORDER BY 2#

#1.5 #00219B89767C0083000725D00000054C000465D950217C89#1237883933535#/System/Database/sql/jdbc/direct##com.sap.sql.jdbc.direct.DirectPreparedStatement#J2EE_GUEST#0##n/a##b8607b21184e11de843700219b89767c#SAPEngine_Application_Thread[impl:3]_32##0#0#Error#1#com.sap.sql.jdbc.direct.DirectPreparedStatement#Java#com.sap.sql_0003#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection SAPPRODUCTION:TMK:SAPTMKDB: code=8,179, state="HY000", message="[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 9.";

SQL statement is "SELECT * FROM "JAVA" WHERE "NEXTEXEC" < ? AND "STATUS" = 1. ORDER BY 2".#5#8179#HY000#[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 9.#SAPPRODUCTION:TMK:SAPTMKDB#SELECT * FROM "JAVA" WHERE "NEXTEXEC" < ? AND "STATUS" = 1. ORDER BY 2#

#1.5 #00219B89767C00890004DBF80000054C000465D950217DC5#1237883933535#/System/Database/sql/jdbc/direct##com.sap.sql.jdbc.direct.DirectPreparedStatement#J2EE_GUEST#0##n/a##c0e125b0184e11de811800219b89767c#SAPEngine_Application_Thread[impl:3]_25##0#0#Error#1#com.sap.sql.jdbc.direct.DirectPreparedStatement#Java#com.sap.sql_0003#com.sap.sql.log.OpenSQLResourceBundle#SQL error occurred on connection SAPPRODUCTION:TMK:SAPTMKDB: code=8,179, state="HY000", message="[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 7.";

SQL statement is "SELECT MIN("ITE_TIME") "ITE_TIME" FROM "CAF_GP_QUEITE" WHERE "QUE_UUID" = ? AND "ITE_STAT" = ?".#5#8179#HY000#[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 7.#SAPPRODUCTION:TMK:SAPTMKDB#SELECT MIN("ITE_TIME") "ITE_TIME" FROM "CAF_GP_QUEITE" WHERE "QUE_UUID" = ? AND "ITE_STAT" = ?#

#1.5 #00219B89767C0084000727950000054C000465D950217DE8#1237883933535#/System/Database##com.sap.caf.eu.gp.schedule.impl.ScheduleDbImpl#J2EE_GUEST#0##n/a##b8607b22184e11de89ce00219b89767c#SAPEngine_Application_Thread[impl:3]_24##0#0#Error#1#com.sap.caf.eu.gp.schedule.impl.ScheduleDbImpl#Plain###[NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 3.

java.sql.SQLException: [NWMss][SQLServer JAVA][SQLServer]Could not find prepared statement with handle 3.

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)