Question
The Mitre Corporation
US
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.
Pegasystems Inc.
IN
Hi William,
"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"
If above is true then surely it will fail.
"Looking at the Pega server log it seems that the sql syntax is incorrect for the user action"
Can you please send over the logs for us to have a look at.
Can you create another application and see if corresponding table gets created against that application.
Thanks,
Ujjwal
EPAM Systems, Inc.
ES
Adding to Ujjawal,
I want to see the tracer file, please make sure to capture DB query.
In tracer window, click on "Settings" and configure as below:
It would help us to understand the wrong SQL syntax as mentioned.
Coforge Technologies (Erstwhile Incessant Technologies)
GB
Did you get any resolution for this issue.
Pegasystems Inc.
IN
Hi,
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.