Note: Applies for DS 6.5.3 and above
Issue: When opening a document the following error message is displayed:
com.xerox.docushare.db.DatabaseException: getDocRendition; nested exception is:
java.sql.SQLException: [Docushare][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
at com.xerox.docushare.db.jdbc.DbConnectionJDBC.getDocRendition(DbConnectionJDBC.java:22733)
at com.xerox.docushare.impl.server.BackendSessionImpl.getContentElementsForDoc(BackendSessionImpl.java:9122)
at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:305)
at sun.rmi.transport.Transport$1.run(Transport.java:159)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:155)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:535)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:790)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:649)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Solution
Note: Please take a backup of Document Repository and database before running this utility.
Please do the following steps:
1. Stop DocuShare.
2. Download fixDuplicateLinks for 6.x utility from the below URL (fixDuplicateLinks6.zip)
https://docushare.xerox.com/doug/dsweb/View/Collection-10720
(Login with your DOUG site user name and password)
3. Please follow the read me file.
4. Start DocuShare.
5. First we will check whether there are duplicate links or not.For that run the command fixduplicatelinks -l
eg: C:\xerox\docushare\bin> fixDuplicateLinks -l C:\logs\myLog.txt
6. If the output reports any duplicate links we can fix it by running the command:
fixduplicatelinks -f -l
eg: C:\xerox\docushare\bin> fixDuplicateLinks -f -l C:\logs\myLog.txt
7. Then again run the command in step 5 to check that all the duplicate links have been fixed.
Solution Published: April 8th, 2013
Solution ID: 1290