Error assigning an Event to a Campaign
Hello,
Our problem is that during the edit campaign process, when an Real Time Event is adding to the Campaign, this cannot be neither saved than Confirm.
This is the error we get in the screen:
- Batch table creation failed reason :Database-General Problem executing SQL to update database schema 955 42000 ORA-00955: name is already used by an existing object
- DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
- | SQL Code: 955 | SQL State: 42000
- pzBatchReportingClassCreationFailed Trying to save an invalid page: Table does not exist in database
- Trying to save an invalid page: page is not valid
- Failed to create the event Output Configuration for this Campaign.
- Trying to save an invalid page: page is not valid
We have create several campaigns, but the error is the same.
If we configure a Campaing without Event in the Enablement it works fine
[ MKT:01.02.01] ( internal.access.DatabaseImpl) ERROR - A commit cannot be performed because a deferred save of instance RULE-OBJ-CLASS PEGAMKT-DATA-RESULTOUTPUT-EVENT-P20 failed
[ MKT:01.02.01] ( internal.access.DatabaseImpl) ERROR - The deferred save failed with the following exception
com.pega.pegarules.pub.database.BadInputException: Trying to save an invalid page: Table does not exist in database
Trying to save an invalid page: page is not valid
Hello,
Our problem is that during the edit campaign process, when an Real Time Event is adding to the Campaign, this cannot be neither saved than Confirm.
This is the error we get in the screen:
- Batch table creation failed reason :Database-General Problem executing SQL to update database schema 955 42000 ORA-00955: name is already used by an existing object
- DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
- | SQL Code: 955 | SQL State: 42000
- pzBatchReportingClassCreationFailed Trying to save an invalid page: Table does not exist in database
- Trying to save an invalid page: page is not valid
- Failed to create the event Output Configuration for this Campaign.
- Trying to save an invalid page: page is not valid
We have create several campaigns, but the error is the same.
If we configure a Campaing without Event in the Enablement it works fine
[ MKT:01.02.01] ( internal.access.DatabaseImpl) ERROR - A commit cannot be performed because a deferred save of instance RULE-OBJ-CLASS PEGAMKT-DATA-RESULTOUTPUT-EVENT-P20 failed
[ MKT:01.02.01] ( internal.access.DatabaseImpl) ERROR - The deferred save failed with the following exception
com.pega.pegarules.pub.database.BadInputException: Trying to save an invalid page: Table does not exist in database
Trying to save an invalid page: page is not valid
at com.pega.pegarules.data.internal.access.Saver.validate(Saver.java:1164) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Saver.saveDeferred(Saver.java:386) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:2739) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:2723) ~[prprivate.jar:?]
at com.pegarules.generated.activity.ra_action_pzcreatebatchdecisionoutput_4e875b0ef984d8c3f1133160bbbf735d.step33_circum0(ra_action_pzcreatebatchdecisionoutput_4e875b0ef984d8c3f1133160bbbf735d.java:3202) ~[?:?]
at com.pegarules.generated.activity.ra_action_pzcreatebatchdecisionoutput_4e875b0ef984d8c3f1133160bbbf735d.perform(ra_action_pzcreatebatchdecisionoutput_4e875b0ef984d8c3f1133160bbbf735d.java:764) ~[?:?]
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3556) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10878) ~[prprivate.jar:?]
***Edited by Moderator Marissa to update SR Details***