Question

Pegasystems Inc.
US
Last activity: 6 Apr 2018 19:26 EDT
Get errors on setup scripts (setup.bat) while upgrading PegaMarketing 7.13 to 7.21
Get errors on setup scripts (setup.bat) while upgrading PegaMarketing 7.13 to 7.21:
Get errors on setup scripts (setup.bat) while upgrading PegaMarketing 7.13 to 7.21:
[sql] Executing resource: ...PegaMarketing_7.21\ResourceKit\setup\generated\Upgrade\copy_mkt_rules.sql
[sql] Failed to execute: INSERT INTO RULES.MKT_RULE (PXCREATEDATETIME,...,PYDRAFTMODEON) SELECT PXCREATEDATETIME,..., PYDRAFTMODEON FROM RULES.PR4_RULE WHERE pxobjclass LIKE 'Rule-PegaMKT%' OR pxobjclass LIKE 'Rule-Obj-Template%' OR pxobjclass LIKE 'Rule-Obj-Report-Definition-Segment%' OR pxobjclass = 'Rule-Obj-Corr-SMS' OR pxobjclass = 'Rule-Obj-Analysis' OR pxobjclass LIKE 'Rule-Obj-Treatment%' OR pxobjclass = 'Rule-Obj-VolConstraintGrp'
[sql] java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RULES"."MKT_RULE"."PZTENANTID")
[sql] Failed to execute: INSERT INTO RULES.mkt_rule_offer (PXCREATEDATETIME,...,PXSAVEDATETIME) SELECT PXCREATEDATETIME,...,PXSAVEDATETIME FROM RULES.PR4_RULE_FLOW WHERE pxobjclass = 'Rule-Obj-Flow-Offer'
[sql] java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("RULES"."MKT_RULE_OFFER"."PZTENANTID")
column PZTENANTID can't be NULL in tables MKT_RULE and MKT_RULE_OFFER
fixed by adding PZTENANTID column to inserts/selects
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.