Question

2
Replies
90
Views
Maryrita Styer (MaryritaStyer)
MOD
Digital Product Manager, Collaboration Center
Pegasystems Inc.
US
MaryritaStyer Member since 2010 131 posts
MOD
Posted: August 9, 2016
Last activity: April 6, 2018
Posted: 9 Aug 2016 12:16 EDT
Last activity: 6 Apr 2018 19:26 EDT
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.

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.