Question

2
Replies
87
Views
MaryritaStyer Member since 2010 130 posts
MOD
Posted: 4 years ago
Last activity: 4 years 2 months ago
Closed
Solved

Get errors on setup scripts (setup.bat) while upgrading PegaMarketing 7.13 to 7.21

June 28, 2016 - 3:53pm

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.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn