Article - CS339633
Receive 'A persistence error occurred' for 'New Topic' action in Windchill
Modified: 24-Feb-2021
Applies To
- Windchill PDMLink 11.0 to 12.0
Description
- Receive A persistence error occurred for New Topic action and MethodServer log shows SQLIntegrityConstraintViolationException error
com.ptc.core.components.forms.DefaultFormProcessorController wcadmin - A persistence error occurred.
(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 "INSERT INTO DiscussionTopic(...) VALUES ('wt.workflow.forum.DiscussionTopic',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WINDEDUPROD"."DISCUSSIONTOPIC"."NAME")
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
...
at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3205)
at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:306)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2404)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:572)
at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1382)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1434)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:534)
...
at com.ptc.core.components.forms.CreateObjectFormProcessor.doOperation(CreateObjectFormProcessor.java:98)
at com.ptc.netmarkets.forumTopic.processors.CreateTopicFormProcessor.doOperation(CreateTopicFormProcessor.java:107)
at com.ptc.core.components.forms.DefaultFormProcessorController.executeDoOperation(DefaultFormProcessorController.java:538)
at com.ptc.core.components.forms.DefaultFormProcessorController.performExecuteDoOperationAndPostProcess(DefaultFormProcessorController.java:342)
at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:263)
at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146)
at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116)
at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93)
at sun.reflect.GeneratedMethodAccessor40284.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ptc.netmarkets.util.beans.NmCommandBean.execute(NmCommandBean.java:2005)
at com.ptc.jca.mvc.controllers.ActionController.executeWizardAction(ActionController.java:211)
at com.ptc.jca.mvc.controllers.ActionController.processRequest(ActionController.java:114)
(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 "INSERT INTO DiscussionTopic(...) VALUES ('wt.workflow.forum.DiscussionTopic',1,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)". Database system message follows:
Nested exception is: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WINDEDUPROD"."DISCUSSIONTOPIC"."NAME")
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
...
at wt.pds.SQLDatabasePds.insertList(SQLDatabasePds.java:3205)
at wt.pds.SQLDatabasePds.insert(SQLDatabasePds.java:306)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:2404)
at wt.pom.PersistentObjectManager.insert(PersistentObjectManager.java:572)
at wt.fc.StandardPersistenceManager.insert(StandardPersistenceManager.java:1382)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:1434)
at wt.fc.StandardPersistenceManager.store(StandardPersistenceManager.java:534)
...
at com.ptc.core.components.forms.CreateObjectFormProcessor.doOperation(CreateObjectFormProcessor.java:98)
at com.ptc.netmarkets.forumTopic.processors.CreateTopicFormProcessor.doOperation(CreateTopicFormProcessor.java:107)
at com.ptc.core.components.forms.DefaultFormProcessorController.executeDoOperation(DefaultFormProcessorController.java:538)
at com.ptc.core.components.forms.DefaultFormProcessorController.performExecuteDoOperationAndPostProcess(DefaultFormProcessorController.java:342)
at com.ptc.core.components.forms.DefaultFormProcessorController.execute(DefaultFormProcessorController.java:263)
at com.ptc.core.components.forms.FormDispatcher.callControllerExecute(FormDispatcher.java:146)
at com.ptc.core.components.forms.FormDispatcher.callFormProcessorController(FormDispatcher.java:116)
at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:93)
at sun.reflect.GeneratedMethodAccessor40284.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ptc.netmarkets.util.beans.NmCommandBean.execute(NmCommandBean.java:2005)
at com.ptc.jca.mvc.controllers.ActionController.executeWizardAction(ActionController.java:211)
at com.ptc.jca.mvc.controllers.ActionController.processRequest(ActionController.java:114)
This is a printer-friendly version of Article 339633 and may be out of date. For the latest version click CS339633