This page lists various common error messages that may be encountered when setting up and running PCORnet Menu-Driven Queries. Errors are listed with the exact wording they appear with in the DataMart Client. Some issues have different error messages associated with them depending on the relational database platform that is being used, each of those error messages are listed below for clarity.
When executing against Oracle: "ORA-00942: table or view does not exist"
When executing against SQL Server: "Invalid object name '[schema].DEMOGRAPHIC'."
When executing against Postgres (error displayed in DataMart Client log file): "Failed in 3 ms with error: 42P01: relation "[schema].DEMOGRAPHIC" does not exist"
This is typically caused by either the Adapter field within your PCORnet CDM Model Settings being set to 'Modular Program' rather than 'PCORnet CDM', or you do not have full DataMart Administrator permissions associated with your PopMedNet account. To resolve:
Navigate to your PCORnet CDM Model Settings and make sure the Adapter field is set to 'PCORnet CDM'. After making necessary changes, click OK on all windows to save. Be sure to restart your DataMart Client before attempting to run another request.
If this does not work, contact your PopMedNet Administration team with your account name and network name requesting the ability to respond to PCORnet Menu-Driven Queries.