Question
Pegasystems
US
Last activity: 30 May 2019 10:39 EDT
Error importing PegaMarketing_Core_0802.zip
Getting the following exception during the import:
Import cannot proceed due to exception: java.lang.IllegalStateException: Improperly form view metadata element: <?xml version="1.0" encoding="UTF-8"?><database catalogName="" databaseName="ExternalMKTData" schemaName="" type="6"><view description="View V_MKT_CUSTOMER_SEGMENTS" name="V_MKT_CUSTOMER_SEGMENTS" ruleset="Pega-RULES"><select/></view></database>
Getting the following exception during the import:
Import cannot proceed due to exception: java.lang.IllegalStateException: Improperly form view metadata element: <?xml version="1.0" encoding="UTF-8"?><database catalogName="" databaseName="ExternalMKTData" schemaName="" type="6"><view description="View V_MKT_CUSTOMER_SEGMENTS" name="V_MKT_CUSTOMER_SEGMENTS" ruleset="Pega-RULES"><select/></view></database>
Configured the Database rule per directions and successfully tested with JNDI config. This just points to the PegaDATA schema.
2. Configured schema reference (customerdata) in context.xml alongside PegaRULES and PegaDATA entries. Tried also setting this up as a DSS originally per instructions with same results.
3. Marketing tables were created manually b/c Pega did not seem able to identify the schema.
Accepted Solution
Pegasystems
US
**Resolved - Documentation Bug **
The problem is that the Dynamic System Setting that points to the default schema for the ExternalMKTData database rule needs to match the name of the database rule. This seems obvious in hindsight, but is not made clear in the docs. So, instead of using the setting purpose:
prconfig/database/databases/customerdata/defaultSchema/default
as instructed in the prerequisite tasks of the Pega Marketing install guide, it should be:
prconfig/database/databases/ExternalMKTData/defaultSchema/default
Pegasystems Inc.
IN
Have you confirmed if the ExternalMKTData is configured correctly and is able to connect to the DB?
Can you provide screenshots of how the ExternaMKTData database looks like? Please also include the Advanced tab.
Pegasystems
US
Yes. The Database connection seems to be fine. The issue appears to be that Pega is not picking up the schema name. Attaching a Word doc with screenshots of my configuration and errors. I started this morning with a clean VM 8.2.1 image and got the same results. The screenshots show the schema reference in the Tomcat context.xml file, but I have also tried it with a Dynamic System Setting and after reboot got the same results.
Accepted Solution
Pegasystems
US
**Resolved - Documentation Bug **
The problem is that the Dynamic System Setting that points to the default schema for the ExternalMKTData database rule needs to match the name of the database rule. This seems obvious in hindsight, but is not made clear in the docs. So, instead of using the setting purpose:
prconfig/database/databases/customerdata/defaultSchema/default
as instructed in the prerequisite tasks of the Pega Marketing install guide, it should be:
prconfig/database/databases/ExternalMKTData/defaultSchema/default