Posted: 8 Dec 2017 12:22 EST Last activity: 27 Sep 2018 2:47 EDT
Table does not exist when creating a case. Database error.
I am working with a fresh install of Pega platform 7.3.1 setup with Tomcat and MSSQL server db. I try to create a case and it gives me this error: "Table does not exist in database".
If I go to my class and test connection to PegaData it tells me that my application work class is mapped to a table in PegaData which does not exist. I'm not sure if this is a permissions issue or a database connection issue.
I created the new application from the Administrator@pega account, then logged into the new application with the Admin.Application account and creating a case leads me to the error. Looking at the Pega server log it seems that the sql syntax is incorrect for the user action. Any help would be greatly appreciated.
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.