externalmktdata.MKT_CUSTOMER in database ExternalMKTData, which does not exist
Hi Team,
I have created a new app on Pega CDH 8.5 after successful installation of Pega CDH. But when I was checking the class mapping of PegaMKT-Data-Customer it is showing the below exception.
externalmktdata.MKT_CUSTOMER in database ExternalMKTData, which does not exist.
When I looked at the schema connection and backend db, this table already exists. Please let me know if I am missing something. I haven't seen this issue in earlier.
Regards,
Nizam
Pegasystems Inc.
US
Is "externalmktdata" actually the schema name used by your database? If that is the correct schema name, then most likely there is a DB permission issue, where the DB user associated with the ExternalMKTData DADN does not have full DB permissions on the schema and its objects, or the search path for the DB user does not include the schema. What database type is being used? What connection type is being used on the ExternalMKTData DADN?
Tech Mahindra
IN
@WINKM Yes it is a schema used by my database. I have created an user with all the roles. I was able to find root cause of this issue. Once I change the connection type from JDBC URL - Though the connection is good this is showing the exception. But when I changed to the database setting to Inherit from existing connection(PegaDATA), it is working as expected.
Regards,
Nizam