Community Tip - You can change your system assigned username to something more personal in your community settings. X
I was able to run WContentVerify on a smaller vault but my large vault keeps throwing a java.sql.SQLRecoverableException. See below. I tried using a -batchSize=2000 but that did not help. Since the tool does not output anything until the end, how best can I complete the verification? It appears to still run but these messages will occasionally display in the console and MS logs. Any suggestions for breaking this job up if its too large to complete?
(wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
Nested exception is: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows:
Nested exception is: java.sql.SQLRecoverableException: IO Error: Socket read interrupted
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1092)
at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3456)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:742)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:698)
at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:412)
at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:209)
at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:880)
at wt.pom.PagingHelper.query(PagingHelper.java:173)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1111)
at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1005)
at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1955)
at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1465)
at wt.fc.StandardPersistenceManager.query(StandardPersistenceManager.java:1351)
at wt.fv.tools.WCV_Util._server_executePagingQuery(WCV_Util.java:292)
at wt.fv.tools.WCV_Util._server_executePagingQuery(WCV_Util.java:273)
at wt.fv.tools.WCV_BasicMasterFolderCheck._server_getPerFolderStatsForFvItemsOnMasterServer(WCV_BasicMasterFolderCheck.java:526)
at wt.fv.tools.WCV_BasicMasterFolderCheck._server_getPerFolderStats(WCV_BasicMasterFolderCheck.java:500)
at jdk.internal.reflect.GeneratedMethodAccessor2696.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at wt.method.MethodResultWriter.writeExternal(MethodResultWriter.java:165)
at wt.method.MethodResult.writeExternal(MethodResult.java:226)
at java.base/java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1447)
at java.base/java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1421)
at java.base/java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1169)
at java.base/java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:345)
at java.rmi/sun.rmi.server.UnicastRef.marshalValue(UnicastRef.java:293)
at java.rmi/sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:369)
at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:200)
at java.rmi/sun.rmi.transport.Transport$1.run(Transport.java:197)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.rmi/sun.rmi.transport.Transport.serviceCall(Transport.java:196)
at java.rmi/sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:562)
at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:796)
at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$0(TCPTransport.java:677)
at java.base/java.security.AccessController.doPrivileged(Native Method)
at java.rmi/sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:676)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.io.InterruptedIOException: Socket read interrupted
at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:258)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:180)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:555)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:258)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:190)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:132)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:105)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:784)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1079)
Solved! Go to Solution.
I was able to run a single folder of my large vault. This folder had 595712 files in it. 19 files missing from 19 years and 4 upgrades ago. Not bad. Hopefully, I can repeat this successfully for the remainder of the folders.
I was able to run a single folder of my large vault. This folder had 595712 files in it. 19 files missing from 19 years and 4 upgrades ago. Not bad. Hopefully, I can repeat this successfully for the remainder of the folders.