Support Article
Unable to create a data table post application update
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
- Update from Pega 7.2.2 to Pega 7.4
- 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 23, 2018 - 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.