Notifications
Clear all
Topic starter
We have a need to pull data from the centricityps database and another database onto the same crystal report. Both databases reside on the same SQL server. The report functions properly inside Crystal Reports. But once it is imported into CPS it will not pull the data.
When we try to run the report it will ask for the report parameters as expected. Once the start and stop dates are entered the report attempts to run for a second but then returns an error that reads "Failed to retrieve data from the database." The error message does not specify which database. I can only assume it's failing to pull data from the non centricityps database.
I'm thinking this could be a SQL permission issue, but I don't know which SQL account is used by CPS for reporting. Has anyone else seen this before?
Posted : February 6, 2019 1:31 am
I think you state that the Crystal Report functions when run on a specific computer, (assumed) with ODBC connections defined to point to extra data environment.
So, how do you run CPS? Do you use a Citrix environment? Just thinking that perhaps that environment does not have the ODBC connection defined?
Posted : February 6, 2019 2:29 am
I'm also thinking you have an auth issue. If you look at the SQL event viewer, you should see which account is being denied access to the database. I don't recall offhand which account CPS uses for database queries though. Perhaps "cpsuser".
-dp
Posted : February 6, 2019 3:09 am
Topic starter
Sorry if I was unclear. The Crystal Report works when I preview it within the Crystal Report application. Yes I am using ODBC connections defined for both databases. The report does not function once imported into CPS.
We are not using a Citrix environment or terminal servers. CPS client is launched on the local workstations.
Posted : February 6, 2019 3:27 am
