Support Article

Unable to create a data table post application update

SA-60573

Summary



Unable to create a data table in PegaDATA.
The user is forced to create the data table in CustomerDATA database which inherits the connection from PegaDATA and get mapped in that schema. After configuring the source and key, when test connectivity is given for the generated class, it displays some warnings.



Error Messages



Not Applicable.


Steps to Reproduce

  1. Update from Pega 7.2.2 to Pega 7.4
  2. Create a data type and test the connection of its corresponding class


Root Cause



This is as per Pega Product design.


Resolution

In Pega7.4, configure source behavior is modified. All user defined tables (created through configured source) are created only in CustomerDATA schema. PegaDATA is used only for Pega shipped tables.

If CustomerDATA uses same connection as PegaDATA , tables are created in PegaDATA configured physical database or schema.
If CustomerDATA is configured with some other physical database or schema, then the tables are created in that database or schema.

Additinally, the displayed warnings does not result in failures. While configuring sources by default pxCreate* and pxUpdate* properties (total 8 properties) are listed for optimizations. These options can be deleted if the requirement is not expose the columns.


 

Published July 4, 2018 - Updated July 20, 2018


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.