Question
Redkite BPM Ltd
Redkite BPM Ltd
GB
Redkite BPM Ltd
Posted: Sep 27, 2018
Last activity: Oct 7, 2018
Last activity: 7 Oct 2018 4:19 EDT
Closed
Table is not creating in the DB while mapping the class group and data classes
Scenario:
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.
Posted: 7 years ago
Coforge Technologies (Erstwhile Incessant Technologies)
Coforge Technologies (Erstwhile Incessant Technologies)
GB
Posted: 7 years ago
PEGA
Pegasystems Inc.
IN
Hi Basker,
Do you see any exceptions in the logs? Can you share the logs?
Posted: 7 years ago
CollabPartnerz
CollabPartnerz
IN
Below link might be useful
Hi Basker,
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.