Questions & Answers

papanova
I'm new here

SQL Exception beim Aufruf der Seite mit den Stukturierten Daten.

Hallo zusammen,

Problembeschreibung: Die FirstSpirit 5.0 Umgebung ist an die Oracle-Datenbank angebunden ist. Die Kontakt Daten sind in einer FirstSpirit Tabelle "contact" gepflegt. Der Formular der Absatzvorlage enthรคlt ein FS_DATASET Element, der auf die "Contact" Tabelle verweist.

Beim Aufruf der Inhaltseite in Browser kommt ein Exception (Stacktrace FS):

09.04.2013 10:30:52.260 ERROR ($CMS_VALUE(#global.page.body("content_center"))$ at 23, 6): de.espirit.or.QueryException: Error code: 17002, state: 08006

inside of: Template 'Inhaltsseite' (id=405)

inside of: $CMS_TRIM(level:3)$ - at 1, 1

inside of: $CMS_VALUE(#global.page.body("content_center"))$ - at 23, 6

Oracle Version: Oracle 11gR2 (11.2.0.1.0)

FS Version: 5.0.210.55494

Wie kann man das Problem lรถsen?

0 Kudos
4 Replies
thmarx
I'm new here

Hallo,

Oracle Fehlercode 17002 weist darauf hin, dass irgendwelche Netzwerkprobleme aufgetreten sind.

Bekommen sie irgendwelche Exceptions in den Logs?

Viele GrรผรŸe

Thorsten Marx

0 Kudos
eginger
Returning Observer

Hallo Herr Marx,

das Problem besteht trotz verschiedener Tests (Andere Oracle Treiber Version, Content Projektion ausgetauscht durch eine Verbindung รผber das fs_integration Modul, ...) bei uns weiterhin. Es scheint sich die Verbindung zur Datenbank nach ca. 30 Minuten schlafen zu legen und erst nach dem ersten (fehlerhaften) Verbindungsversuch wieder zu funktionieren. Die Exceptions in den FS Logs sehen folgendermaรŸen aus:

28.05.2013 08:31:59 ERROR 28.05.2013 08:31:59.056 {pID=97,uID=23} (de.espirit.firstspirit.logging.ServerLogging): Client error: ERROR 28.05.2013 09:28:54.468 (de.espirit.firstspirit.client.access.editor.FsListEditorValueImpl): Failed parsing data entry.

otest(otest otest (opus5)), session: 7878510408799648081, project: 45, ip: 192.168.32.183

FSVersion=5.0.210.55494#3238;JDK=1.7.0_17 32bit Oracle Corporation;OS=Windows 7 6.1 x86;Date=28.05.2013 09:28:54

java.lang.RuntimeException: cannot shutdown, close on connection failed - error code: 17002, message: I/O-Fehler: Connection reset

  at de.espirit.or.impl.connection.ConnectionInvocationHandler.shutdown(ConnectionInvocationHandler.java:106)

  at de.espirit.or.impl.connection.ConnectionInvocationHandler.invoke(ConnectionInvocationHandler.java:48)

  at $Proxy13.shutdown(Unknown Source)

  at de.espirit.or.impl.connection.DBConnectionManager.getConnection(DBConnectionManager.java:309)

  at de.espirit.or.impl.connection.DBConnectionManager.getConnection(DBConnectionManager.java:207)

  at de.espirit.or.impl.connection.ConnectionManagerFactory$DelegatingConnectionManager.getConnection(ConnectionManagerFactory.java:184)

  at de.espirit.or.impl.AbstractSessionHandler.executeQuery(AbstractSessionHandler.java:240)

  at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.executeQuery(ContentManagerImpl.java:1173)

  at de.espirit.firstspirit.content.ContentManagerImpl.executeQuery(ContentManagerImpl.java:545)

  at sun.reflect.GeneratedMethodAccessor1183.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:601)

  at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:62)

  at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:92)

  at de.espirit.firstspirit.server.io.handler.ManagerCall.handle(ManagerCall.java:68)

  at de.espirit.firstspirit.server.io.ManagerCallWorker.run(ManagerCallWorker.java:108)

  at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:582)

  at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:549)

  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  at java.util.concurrent.FutureTask.run(FutureTask.java:166)

  at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:419)

  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  at java.util.concurrent.FutureTask.run(FutureTask.java:166)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

  at java.lang.Thread.run(Thread.java:722)

  at de.espirit.common.util.SuspendableThread.run(SuspendableThread.java:37)

Caused by: java.sql.SQLRecoverableException: I/O-Fehler: Connection reset

  at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:556)

  at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3984)

  at de.espirit.or.impl.connection.ConnectionInvocationHandler.shutdown(ConnectionInvocationHandler.java:101)

... 27 more

Caused by: java.net.SocketException: Connection reset

  at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

  at java.net.SocketOutputStream.write(SocketOutputStream.java:153)

  at oracle.net.ns.DataPacket.send(DataPacket.java:210)

  at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:230)

  at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:312)

  at oracle.net.ns.NetInputStream.read(NetInputStream.java:260)

  at oracle.net.ns.NetInputStream.read(NetInputStream.java:185)

  at oracle.net.ns.NetInputStream.read(NetInputStream.java:102)

  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)

  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)

  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

  at oracle.jdbc.driver.T4C7Ocommoncall.doOLOGOFF(T4C7Ocommoncall.java:61)

  at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:543)

  at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:3984)

  at de.espirit.or.impl.connection.ConnectionInvocationHandler.shutdown(ConnectionInvocationHandler.java:101)

  at de.espirit.or.impl.connection.ConnectionInvocationHandler.invoke(ConnectionInvocationHandler.java:48)

  at $Proxy13.shutdown(Unknown Source)

  at de.espirit.or.impl.connection.DBConnectionManager.getConnection(DBConnectionManager.java:309)

  at de.espirit.or.impl.connection.DBConnectionManager.getConnection(DBConnectionManager.java:207)

  at de.espirit.or.impl.connection.ConnectionManagerFactory$DelegatingConnectionManager.getConnection(ConnectionManagerFactory.java:184)

  at de.espirit.or.impl.AbstractSessionHandler.executeQuery(AbstractSessionHandler.java:240)

  at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.executeQuery(ContentManagerImpl.java:1173)

  at de.espirit.firstspirit.content.ContentManagerImpl.executeQuery(ContentManagerImpl.java:545)

  at sun.reflect.GeneratedMethodAccessor1183.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:601)

  at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:62)

  at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:92)

  at de.espirit.firstspirit.server.io.handler.ManagerCall.handle(ManagerCall.java:68)

  at de.espirit.firstspirit.server.io.ManagerCallWorker.run(ManagerCallWorker.java:108)

  at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:582)

  at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:549)

  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  at java.util.concurrent.FutureTask.run(FutureTask.java:166)

  at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:419)

  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

  at java.util.concurrent.FutureTask.run(FutureTask.java:166)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

  at de.espirit.firstspirit.client.io.ServerCaller.callManager(ServerCaller.java:368)

  at de.espirit.firstspirit.io.DefaultClientHandler.callManager(DefaultClientHandler.java:55)

  at de.espirit.firstspirit.client.io.RemoteManagerCaller.invoke(RemoteManagerCaller.java:52)

  at de.espirit.firstspirit.server.$Proxy47.executeQuery(Unknown Source)

  at de.espirit.firstspirit.store.access.templatestore.SessionHandlerImpl.executeQuery(SessionHandlerImpl.java:81)

  at de.espirit.or.impl.AbstractSession.find(AbstractSession.java:198)

  at de.espirit.or.impl.SessionImpl.find(SessionImpl.java:24)

  at de.espirit.or.impl.AbstractSession.find(AbstractSession.java:181)

  at de.espirit.or.impl.SessionImpl.find(SessionImpl.java:24)

  at de.espirit.firstspirit.access.store.contentstore.gom.list.ContentDataFactory.parseEntry(ContentDataFactory.java:649)

  at de.espirit.firstspirit.access.store.contentstore.gom.list.ContentDataFactory.load(ContentDataFactory.java:540)

  at de.espirit.firstspirit.client.access.editor.FsListEditorValueImpl.parseEntries(FsListEditorValueImpl.java:280)

  at de.espirit.firstspirit.client.access.editor.FsListEditorValueImpl.parseValue(FsListEditorValueImpl.java:243)

  at de.espirit.firstspirit.client.access.editor.FsListEditorValueImpl.parseValue(FsListEditorValueImpl.java:60)

  at de.espirit.firstspirit.client.access.editor.AbstractEditorValue.parseDataElement(AbstractEditorValue.java:415)

  at de.espirit.firstspirit.client.access.editor.AbstractEditorValue.setValueNode(AbstractEditorValue.java:365)

  at de.espirit.firstspirit.client.access.editor.AbstractEditorValue.initialize(AbstractEditorValue.java:123)

  at de.espirit.firstspirit.module.GadgetSpecification$ValueMediatorFactoryImpl.createValue(GadgetSpecification.java:206)

  at de.espirit.firstspirit.module.GadgetSpecification$ValueMediatorFactoryImpl.createValue(GadgetSpecification.java:186)

  at de.espirit.firstspirit.client.access.editor.EditorValueFactory.create(EditorValueFactory.java:61)

  at de.espirit.firstspirit.client.access.editor.EditorValueFactory.create(EditorValueFactory.java:46)

  at de.espirit.firstspirit.store.access.DataImpl.create(DataImpl.java:187)

  at de.espirit.firstspirit.store.access.DataImpl.create(DataImpl.java:168)

  at de.espirit.firstspirit.store.access.DataBuilder.toData(DataBuilder.java:109)

  at de.espirit.firstspirit.store.access.templatestore.FormDefaultsMaintainer.update(FormDefaultsMaintainer.java:171)

  at de.espirit.firstspirit.store.access.templatestore.FormDefaultsMaintainer.onFormChange(FormDefaultsMaintainer.java:133)

  at de.espirit.firstspirit.store.access.templatestore.FormDefinitionMaintainer.update(FormDefinitionMaintainer.java:229)

  at de.espirit.firstspirit.store.access.templatestore.FormDefinitionMaintainer.getForm(FormDefinitionMaintainer.java:186)

  at de.espirit.firstspirit.store.access.templatestore.FormDefinitionMaintainer.get(FormDefinitionMaintainer.java:163)

  at de.espirit.firstspirit.store.access.templatestore.TemplateImpl.getFormDefinition(TemplateImpl.java:322)

  at de.espirit.firstspirit.store.access.DataProviderHelper.parseData(DataProviderHelper.java:184)

  at de.espirit.firstspirit.store.access.DataProviderHelper.getData(DataProviderHelper.java:150)

  at de.espirit.firstspirit.store.access.pagestore.PageImpl.getData(PageImpl.java:177)

  at de.espirit.firstspirit.client.gui.tree.store.pagestore.PSPageView.computeStates(PSPageView.java:124)

  at de.espirit.firstspirit.client.gui.tree.store.pagestore.PSPageView.<init>(PSPageView.java:113)

  at de.espirit.firstspirit.client.gui.tree.store.pagestore.GuiPage.createView(GuiPage.java:137)

  at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.getAccessView(AbstractGuiStoreElement.java:1311)

  at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.getView(AbstractGuiStoreElement.java:1118)

  at de.espirit.firstspirit.client.gui.tabbing.ElementTabConfiguration$ElementView.doGetView(ElementTabConfiguration.java:290)

  at de.espirit.firstspirit.client.gui.tabbing.ElementTabConfiguration$ElementView.getViewComponent(ElementTabConfiguration.java:281)

  at de.espirit.firstspirit.client.gui.tabbing.TabContentView$ComponentFactory.getRealComponent(TabContentView.java:399)

  at de.espirit.firstspirit.client.gui.tabbing.TabContentView$ComponentFactory.call(TabContentView.java:372)

  at de.espirit.firstspirit.client.gui.tabbing.TabContentView$ComponentFactory.call(TabContentView.java:259)

  at de.espirit.firstspirit.client.gui.util.GuiUtil$CallableWrapper.call(GuiUtil.java:1948)

  at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

  at java.util.concurrent.FutureTask.run(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

Mit freundlichen GrรผรŸen

Stephan Eginger

0 Kudos

Hallo,

ich vermute, dass durch den konfigurierten Timeout der Datenbank (nicht in FirstSpirit), die Verbindungen geschlossen werden. Bei der Verwendung in FirstSpirit, kommt es dann zu dieser Exception, da die Verbindung ungรผltig ist.

Schauen sie mal in der Administrator Dokumentation im Kapitel 4.8.4.2 Beschreibung der optionalen Parameter. Hier kรถnnte ihnen CONNECTIONTIMEOUT weiterhelfen. Setzen sie den Wert mal etwas runter, am besten unterhalb des Timeouts der Datenbank.

Viele GrรผรŸe

Thorsten Marx

0 Kudos
eginger
Returning Observer

Hallo Herr Marx,

danke fรผr den Hinweis!

Ich habe den Timeout auf 10 Minuten eingestellt und es scheint der Fehler nicht mehr aufzutreten.

Mit freundlichen GrรผรŸen

Stephan Eginger

0 Kudos

Type a product name