Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Marketing DB Table for Output DB Template not created

SA-35445

Summary



Marketing DB Table for Output DB Template is not created fpr Pega Marketing 7.21.


Error Messages


2017-03-16 13:31:30,990 [.PegaWorkManager : 3] [ STANDARD] [ ] [ PegaMarketing:07.21] (ableForClass._baseclass.Action) ERROR - CreateDBTableForClass - Failed while creating specified table:

com.pega.pegarules.pub.database.BadInputException: No type information avaliable for property: TEST: code: <none> SQLState: <none> Message: <none>

From: (B2D0A978208F3A9ECE129FB69A0DE31CF)

at com.pega.pegarules.data.internal.access.db2udb.SQLGeneratorDb2.getColumnTypeForPRPC(SQLGeneratorDb2.java:340)

at com.pega.pegarules.data.internal.access.SQLGenerator.getAddTableSQLExcludeDefaultColumns(SQLGenerator.java:632)

at com.pega.pegarules.data.internal.access.DatabaseImpl.generateSchemaForClass(DatabaseImpl.java:11063)

at com.pegarules.generated.activity.ra_action_createdbtableforclass_9f2ffc4e110c8a133cf6d97d38b4a8ca.step2_circum0(ra_action_createdbtableforclass_9f2ffc4e110c8a133cf6d97d38b4a8ca.java:261)

at com.pegarules.generated.activity.ra_action_createdbtableforclass_9f2ffc4e110c8a133cf6d97d38b4a8ca.perform(ra_action_createdbtableforclass_9f2ffc4e110c8a133cf6d97d38b4a8ca.java:86)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)

at com.pegarules.generated.activity.ra_action_validatedbtemplate_d082681eb90cee7835ef1449a80defb9.step4_circum0(ra_action_validatedbtemplate_d082681eb90cee7835ef1449a80defb9.java:567)

at com.pegarules.generated.activity.ra_action_validatedbtemplate_d082681eb90cee7835ef1449a80defb9.perform(ra_action_validatedbtemplate_d082681eb90cee7835ef1449a80defb9.java:120)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)

at com.pegarules.generated.activity.ra_action_writetotable_9b7bddb1c5da540592f96a17329f6826.step5_circum0(ra_action_writetotable_9b7bddb1c5da540592f96a17329f6826.java:926)

at com.pegarules.generated.activity.ra_action_writetotable_9b7bddb1c5da540592f96a17329f6826.perform(ra_action_writetotable_9b7bddb1c5da540592f96a17329f6826.java:153)

at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3527)

at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10674)

at com.pegarules.generated.activity.ra_action_outboundagenthelper_915cd7e2ca414f94a518240299f5e047.step2_circum0(ra_action_outboundagenthelper_915cd7e2ca414f94a518240299f5e047.java:296)

at com.pegarules.generated.activity.ra_action_outboundagenthelper_915cd7e2ca414f94a518240299f5e047.perform(ra_action_outboundagenthelper_915cd7e2ca414f94a518240299f5e047.java:86)

Steps to Reproduce



1. Create new output template in records->marketing-output template.
2. Set destination type to db in output template rule.
3. Define db and new table for output in output template rule.
4. Define few text fields in output template rule.


Root Cause



a) An issue with rulesets visibility for the agents doing the db template processing.
b) An issue with pulse and the conclusion cache not in sync across the nodes in the cluster.

In both cases, user get that error from generateSchemaForClass method as it can't find any type information for the property that's been mapped.

Access group the agents are running as ( that access group is often PegaNBAM:Agents which should be pointing to the correct application record.)

Resolution


Perform the following local-change:

  1. Unlock the locked artificats rulesets.
  2. Map PegaNBAM:Agents to PegaRules agent.
  3. Restart the node.

Published April 11, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us