Note: DocuShare version 6.6.1.
Problem
Unable to update object properties.
Scenario
After a custom property has been deleted, the second step is to submit the changes under update properties. During this step, the following error appears:
Sorry. Your request could not be processed.
1542: Cannot add a property by this name, because there is at least one instance property on an object of this class that has the same name.
Please try again.
Stack Trace:
com.xerox.docushare.db.DatabaseException: This new property is already an instance property on at least one instance of the target class: social_security at com.xerox.docushare.db.jdbc.DbConnectionJDBC.modifySchema(DbConnectionJDBC.java:29118) at com.xerox.docushare.impl.server.BackendSessionImpl.modifySchema(BackendSessionImpl.java:781) at sun.reflect.GeneratedMethodAccessor57.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
Solution
Any objects that have the custom property applied, must be deleted and expunged from DocuShare. The error is indicating that the custom property cannot be removed until all ties to it are eliminated.
If the issue persists after this step is performed, stop and restart both the DocuShare and SQL services.
Solution Published: May 8th, 2012
Solution ID: 1113