Support Article
Marketing Installation Missing Tables
SA-31405
Summary
While installing Marketing 7.2.1 user encountered errors while importing rules due to a missing table PEGARULES.MKT_RULE.
There is also a warning on startup relating to the same table and PEGARULES.MKT_RULE_OFFER. User could not find any errors relating to the creation of those tables in the logs.
Error Messages
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable PEGARULES.MKT_RULE PegaRULES
[8/4/16 9:21:04:340 CEST] 0000009c SystemOut O 2016-08-04 09:21:04,340 [ a0190sw3692] [ STANDARD] [ ] [ ] (AbstractVirtualTableCacheQuery) WARN - VTable may not be properly initialized. Unable to load rules from PEGARULES.MKT_RULE_OFFER using SQL null with parameters {}
[8/4/16 9:21:04:723 CEST] 0000009c SystemOut O 2016-08-04 09:21:04,722 [ a0190sw3692] [ STANDARD] [ ] [ ] (AbstractVirtualTableCacheQuery) WARN - VTable may not be properly initialized. Unable to load rules from PEGARULES.MKT_RULE using SQL null with parameters {}
Steps to Reproduce
Install Marketing 7.2.1 on Pega 7.2.1.
Root Cause
A zip file had not been imported during install.
Resolution
Import “PegaMarketing_PreRequisites_0721.zip” which is part of the Pega Marketing media file in the environment.
Published August 23, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.