Posted: 27 Sep 2018 10:09 EDT Last activity: 7 Oct 2018 4:19 EDT
Table is not creating in the DB while mapping the class group and data classes
Created the new application on PEGA PRPC v7.4 and able to map the db table but its showing 'table does not exist in the DB like that', so i have verified in DB its not created the work table for the class group, ideally it should map one table which class group name, prefix as pc_ <Classgroup name>
But its not created and also not creating the table for Data classes eventhough after mapping local source keys.
I have verified the below System setting value its set as 'true'
database/AutoDBSchemaChanges = true
Could you please provide me the solution and resolution steps.
There are two types of db configuration while installing pega, dual user configuration and single user configuration. Dual user configuration contains admin user and base user configurations, while single user configuration contains only base user configuration. If Auto schema changes required we should have dual user configuration with admin user. Base user configuration will have minimal privileges which will not allow auto schema changes. Please look into server configuration file for dbuser and confirm the role from db as admin.