Query zur ExceptionSELECT P_OID, SUBCLASS, P_ZEITSTEMPEL, P_ANLAGE_DATUM, P_LETZTE_AENDERUNG, P_ARTICLE, P_DATA, P_FEHLERTEXT, P_FILENAME, P_FINISHED, P_HOST, P_JOB_NUMBER, P_LINENUMBER, P_RECORD_TYPE, P_REFERENCE_NUMBER, P_SEQUENCE_NUMBER, P_STATUS, P_SUB_JOB_NUMBER, P_MANDANT, P_EIGENTUEMER FROM OUTPUTDATE WHERE ((((P_STATUS = 'new') AND (P_HOST = 7)) AND (P_MANDANT = 173182607)) AND (SUBCLASS = 'de.cim.prolag.business.hostschnittstelle.OutputDate')) ORDER BY P_SEQUENCE_NUMBER ASC Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.1.v20090430-r4097): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Die Anweisung wurde geschlossen. Error Code: 0 Call: SELECT P_OID, SUBCLASS, P_ZEITSTEMPEL, P_ANLAGE_DATUM, P_LETZTE_AENDERUNG, P_ARTICLE, P_DATA, P_FEHLERTEXT, P_FILENAME, P_FINISHED, P_HOST, P_JOB_NUMBER, P_LINENUMBER, P_RECORD_TYPE, P_REFERENCE_NUMBER, P_SEQUENCE_NUMBER, P_STATUS, P_SUB_JOB_NUMBER, P_MANDANT, P_EIGENTUEMER FROM OUTPUTDATE WHERE ((((P_STATUS = 'new') AND (P_HOST = 7)) AND (P_MANDANT = 173182607)) AND (SUBCLASS = 'de.cim.prolag.business.hostschnittstelle.OutputDate')) ORDER BY P_SEQUENCE_NUMBER ASC Query: ReadAllQuery(referenceClass=OutputDate sql="SELECT P_OID, SUBCLASS, P_ZEITSTEMPEL, P_ANLAGE_DATUM, P_LETZTE_AENDERUNG, P_ARTICLE, P_DATA, P_FEHLERTEXT, P_FILENAME, P_FINISHED, P_HOST, P_JOB_NUMBER, P_LINENUMBER, P_RECORD_TYPE, P_REFERENCE_NUMBER, P_SEQUENCE_NUMBER, P_STATUS, P_SUB_JOB_NUMBER, P_MANDANT, P_EIGENTUEMER FROM OUTPUTDATE WHERE ((((P_STATUS = ?) AND (P_HOST = ?)) AND (P_MANDANT = ?)) AND (SUBCLASS = ?)) ORDER BY P_SEQUENCE_NUMBER ASC") at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:332) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:666) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:502) at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:536) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:599) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2520) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2478) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:481) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:928) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:664) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:889) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:458) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2243) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1181) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1165) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1125) at de.cim.prolag.db.dbmanager.TOPLinkDBManager.executeQuery(TOPLinkDBManager.java:1939) at de.cim.prolag.business.konverter.STDKonverter.readOutputDate(STDKonverter.java:756) at de.cim.prolag.business.konverter.STDKonverter.runOutXmlhier(STDKonverter.java:1869) at de.cim.prolag.business.konverter.Konverter.runOut(Konverter.java:668) at de.cim.prolag.business.konverter.STDKonverter.run(STDKonverter.java:1050) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Die Anweisung wurde geschlossen. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getMetaData(Unknown Source) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:590) ... 22 more de.cim.prolag.db.dbmanager.DBManagerException at de.cim.prolag.db.dbmanager.TOPLinkDBManager.executeQuery(TOPLinkDBManager.java:1968) at de.cim.prolag.business.konverter.STDKonverter.readOutputDate(STDKonverter.java:756) at de.cim.prolag.business.konverter.STDKonverter.runOutXmlhier(STDKonverter.java:1869) at de.cim.prolag.business.konverter.Konverter.runOut(Konverter.java:668) at de.cim.prolag.business.konverter.STDKonverter.run(STDKonverter.java:1050) Local Exception Stack: uery: ReadAllQuery(referenceClass=OutputDate sql="SELECT P_OID, SUBCLASS, P_ZEITSTEMPEL, P_ANLAGE_DATUM, P_LETZTE_AENDERUNG, P_ARTICLE, P_DATA, P_FEHLERTEXT, P_FILENAME, P_FINISHED, P_HOST, P_JOB_NUMBER, P_LINENUMBER, P_RECORD_TYPE, P_REFERENCE_NUMBER, P_SEQUENCE_NUMBER, P_STATUS, P_SUB_JOB_NUMBER, P_MANDANT, P_EIGENTUEMER FROM OUTPUTDATE WHERE ((((P_STATUS = ?) AND (P_HOST = ?)) AND (P_MANDANT = ?)) AND (SUBCLASS = ?)) ORDER BY P_SEQUENCE_NUMBER ASC") --------------------- --------------------- Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Socket Problem on SQLSERVER detected Try ReExecute exception description: databaseaccessor not connected. Local Exception Stack: Exception [EclipseLink-6094] (Eclipse Persistence Services - 1.1.1.v20090430-r4097): org.eclipse.persistence.exceptions.QueryException Exception Description: The parameter name [P_OID] in the query's selection criteria does not match any parameter name defined in the query. Query: ReadAllQuery(name="p_sendungen" referenceClass=Sendung sql="SELECT t1.P_OID, t1.SUBCLASS, t1.P_ZEITSTEMPEL, t1.P_ANLAGE_DATUM, t1.P_LETZTE_AENDERUNG, t1.P_ANZAHL_PAKETE, t1.P_ANZ_PALETTEN, t1.P_BEMERKUNG_FRACHTBRIEF, t1.P_DHL_AUFTRAGSNR, t1.P_EMPFAENGER_UNFREI, t1.P_EMPFAENGER_VK, t1.P_GEWICHT, t1.P_GEWOGENES_GEWICHT, t1.P_KUNDENNUMMER, t1.P_NACHNAHME, t1.P_NUMMER, t1.P_OFFEN, t1.P_PICKS, t1.P_PKN_FLAG, t1.P_PRIORITAET, t1.P_PRODUKTE, t1.P_SAMMELPLATZ, t1.P_SERVICEOPTION, t1.P_STARTZEITPUNKT, t1.P_TNT_FRACHTBRIEFNR, t1.P_VERDICHT_KRITERIUM1, t1.P_VERDICHT_KRITERIUM2, t1.P_VERDICHT_KRITERIUM3, t1.P_VERDICHT_KRITERIUM4, t1.P_VERDICHT_KRITERIUM5, t1.P_VERDICHT_KRITERIUM6, t1.P_VERWENDUNGSZWECK, t1.P_VOLUMEN, t1.P_WARENWERT_SENDUNG, t1.P_ZAHLUNGSART, t1.P_ZOLL, t1.P_MANDANT, t1.P_EIGENTUEMER, t1.P_EINHEITGEWICHT, t1.P_EINHEITVOLUMEN, t1.P_ORGTOUR, t1.P_STATUS, t1.P_TOUR FROM REGALFACHTOSENDUNG t0, SENDUNG t1 WHERE (((t0.REGALFACHP_OID = ?) AND (t1.P_OID = t0.SENDUNGP_OID)) AND (t1.SUBCLASS = ?))") at org.eclipse.persistence.exceptions.QueryException.parameterNameMismatch(QueryException.java:1012) at org.eclipse.persistence.internal.expressions.ParameterExpression.getValue(ParameterExpression.java:238) at org.eclipse.persistence.internal.databaseaccess.DatasourceCall.translateQueryString(DatasourceCall.java:679) at org.eclipse.persistence.internal.databaseaccess.DatabaseCall.translate(DatabaseCall.java:959) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:204) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:262) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.selectAllRows(DatasourceCallQueryMechanism.java:599) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRowsFromTable(ExpressionQueryMechanism.java:2520) at org.eclipse.persistence.internal.queries.ExpressionQueryMechanism.selectAllRows(ExpressionQueryMechanism.java:2478) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:481) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:928) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:664) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:889) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:458) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2243) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1181) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1165) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1125) at de.cim.prolag.db.dbmanager.SQLSERVERExceptionHandler.handleException(SQLSERVERExceptionHandler.java:57) at org.eclipse.persistence.internal.sessions.AbstractSession.handleException(AbstractSession.java:2156) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1266) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1165) at org.eclipse.persistence.internal.indirection.NoIndirectionPolicy.valueFromQuery(NoIndirectionPolicy.java:299) at org.eclipse.persistence.mappings.ForeignReferenceMapping.valueFromRowInternal(ForeignReferenceMapping.java:1473) at org.eclipse.persistence.mappings.ForeignReferenceMapping.valueFromRow(ForeignReferenceMapping.java:1402) at org.eclipse.persistence.mappings.DatabaseMapping.readFromRowIntoObject(DatabaseMapping.java:1136) at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildAttributesIntoObject(ObjectBuilder.java:325) at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:652) at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObject(ObjectBuilder.java:487) at org.eclipse.persistence.internal.descriptors.ObjectBuilder.buildObjectsInto(ObjectBuilder.java:824) at org.eclipse.persistence.queries.ReadAllQuery.executeObjectLevelReadQuery(ReadAllQuery.java:493) at org.eclipse.persistence.queries.ObjectLevelReadQuery.executeDatabaseQuery(ObjectLevelReadQuery.java:928) at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:664) at org.eclipse.persistence.queries.ObjectLevelReadQuery.execute(ObjectLevelReadQuery.java:889) at org.eclipse.persistence.queries.ReadAllQuery.execute(ReadAllQuery.java:458) at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2243) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1181) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1165) at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1125) at de.cim.prolag.db.dbmanager.TOPLinkDBManager.executeQuery(TOPLinkDBManager.java:1939) at de.cim.prolag.business.lagerphysik.ortsbarcode.PalettenPlatzOBC.getRegalfaecher(PalettenPlatzOBC.java:511) at de.cim.prolag.business.lagerphysik.ortsbarcode.PalettenPlatzOBC.getRegalfach(PalettenPlatzOBC.java:111) at de.cim.prolag.business.lagerphysik.ortsbarcode.PalettenPlatzOBC.getFlaechenelement(PalettenPlatzOBC.java:156) at de.cim.prolag.business.lagerphysik.ortsbarcode.PalettenPlatzOBC.pruefeObc(PalettenPlatzOBC.java:361) at de.cim.prolag.business.stapler.allgemein.STDEingabeOrt.pruefeObcUndErfrageFehlendeOrtsangaben(STDEingabeOrt.java:72) at de.cim.prolag.business.stapler.auslag.SEScanneOrt.todo(SEScanneOrt.java:159) at de.cim.prolag.allgemeines.framework.elemente.StaplerElement.execute(StaplerElement.java:222) at de.cim.prolag.allgemeines.framework.verteiler.Verteiler.execute(Verteiler.java:228) at de.cim.prolag.allgemeines.framework.auswerter.Auswerter.execute(Auswerter.java:171) at de.cim.prolag.allgemeines.framework.elemente.StaplerElement.executeAuswerter(StaplerElement.java:330) at de.cim.prolag.business.stapler.rundlauf.STDRLVerzweiger.todo(STDRLVerzweiger.java:90) at de.cim.prolag.allgemeines.framework.elemente.StaplerElement.execute(StaplerElement.java:222) at de.cim.prolag.allgemeines.framework.verteiler.Verteiler.execute(Verteiler.java:228) at de.cim.prolag.business.stapler.auslag.STDAuslagAllg.execute(STDAuslagAllg.java:100) at de.cim.prolag.business.stapler.auslag.STDScanneListenDialog.execute(STDScanneListenDialog.java:44) at de.cim.prolag.business.stapler.STDStapler.execute(STDStapler.java:366) at de.cim.prolag.allgemeines.telnetserver.Anwendung.execute(Anwendung.java:395) at de.cim.prolag.allgemeines.telnetserver.Verbindungsaufbau.run(Verbindungsaufbau.java:547) Socket Problem on SQLSERVER detected Try ReExecute