Unable to create a data table post application update
SummaryUnable 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 MessagesNot 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 CauseThis is as per Pega Product design.
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