1. Home
  2. Support
Article - CS240266

Assembly Check Out, Check In, Undo Check Out, Save As, Revise or Remove from Workspace fails with error "A persistence error occurred. System message follows:" with Windchill PDMLink 11.0

Modified: 07-Oct-2020   


Applies To

  • Windchill PDMLink 11.0 F000 to M010
  • Pro/INTRALINK 8.x + 11.0 F000 to M010
  • Windchill ProjectLink 11.0 F000 to M010
  • Windchill PDM Essentials 11.0 F000 to M010
  • SQL Server (only)

Description

  • Assembly Check Out, Check In, Undo Check Out, Save As, Revise or Remove from Workspace fails:
A persistence error occurred. System message follows:

Error Message
 
  • The MethodServer reports errors on Add to Workspace:
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 for the statement "SELECT A0.blob$entrySetadHocAcl,A0.classnameA2A2,......,A1.uniqueLinkID,A1.uniqueNDId FROM EPMDocument A0,EPMMemberLink A1,EPMBuildRule A2,EPMBuildHistory A3,WTPart A4 WHERE ((((((((((A2.branchIdA3A5 = ?) AND (A2.branchIdA3B5 = A4.branchIditerationInfo)) AND (A4.latestiterationInfo = ?)) AND (A4.idA2A2 = A3.idA3B5)) AND (A3.buildRuleID = A2.uniqueID)) AND (A3.idA3A5 = A0.idA2A2)) AND (A0.idA2A2 = A1.idA3A5)) AND NOT (EXISTS (SELECT 1.0 FROM EPMMemberLink B0 WHERE (((B0.idA3A5 = A0.idA2A2))) GROUP BY B0.uniqueLinkID,A0.idA2A2 HAVING (COUNT(B0.uniqueLinkID) > ?)))))) AND ((A0.markForDeleteA2 = 0) AND (A1.markForDeleteA2 = 0) AND (A2.markForDeleteA2 = 0) AND (A3.markForDeleteA2 = 0) AND (A4.markForDeleteA2 = 0)); Bind Parameters=[5690664, 1.0, 1.0]". Database system message follows:
Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: Each GROUP BY expression must contain at least one column that is not an outer reference.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
    at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:559)
    at wt.pds.AbstractResultCursor.executeQuery(AbstractResultCursor.java:523)
    at wt.pds.BasicResultCursor.getNextResultSet(BasicResultCursor.java:282)
    at wt.pds.BasicResultCursor.advance(BasicResultCursor.java:234)
    at wt.pds.BasicResultCursor.next(BasicResultCursor.java:82)
    at wt.pds.SQLDatabasePds.query(SQLDatabasePds.java:853)
    at wt.pom.PersistentObjectManager.query(PersistentObjectManager.java:1111)
    at wt.fc.StandardPersistenceManager._query(StandardPersistenceManager.java:1970)
    at wt.fc.StandardPersistenceManager._find(StandardPersistenceManager.java:1994)
    at wt.fc.StandardPersistenceManager.find(StandardPersistenceManager.java:678)
    at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at wt.services.ServiceFactory$ServerInvocationHandler.invoke(ServiceFactory.java:399)
    at com.sun.proxy.$Proxy11.find(Unknown Source)
    at wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:1697)
    at wt.epm.query.pom.impl.AbstractEvaluator.execute(AbstractEvaluator.java:41)
    at wt.epm.query.pom.impl.StatementSpecEvaluator.execute(StatementSpecEvaluator.java:41)
    at wt.epm.query.pom.impl.POMProcessor.executeInteranal(POMProcessor.java:281)
    at wt.epm.query.pom.impl.POMProcessor.execute(POMProcessor.java:335)
    at wt.epm.query.AbstractQuery.execute(AbstractQuery.java:258)
    at wt.epm.query.Query.execute(Query.java:65)
    at wt.epm.query.Query.executeNoDistinct(Query.java:187)
    at wt.epm.structure.EPMStructureHelper.findAndHealDuplicateUniqueLinkId(EPMStructureHelper.java:355)
This is a printer-friendly version of Article 240266 and may be out of date. For the latest version click CS240266