cancel
Showing results for 
Search instead for 
Did you mean: 

Error when changing datasource location "Some tables could not be replaced"

Former Member
0 Kudos
433

I currently upgraded from Crystal XI to XI SP6. Reports that were originally built in Crystal 8.5 were converted by opening from within Crystal XI, refreshing, and saving. Reports seem to have converted properly. However, when tyring to set data source location from a production database, to a test db (exact copy of production), I'm getting the following error message: "Some tables could not be replaced, as no match was found in ghte new data source. Please specify the table required for any unmodified tables." Please note that my ODBC drivers have been properly set up and tested. What's causing this and how to fix?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you go to show SQL you will see in the from section that tables are prefixed with production schema name. To remove and make reports portable across dev and production

Database-> set data source

Click the + on the table and then properties, double click Overridded qualified table name and enter the table name as it appears in the table label above.

Ian

Former Member
0 Kudos

I tried the above fix but this did not help. In addition to switching from prod to dev environments, we are also trying to change the data source connection from ODBC to JDBC (JNDI). I don't have direct access to the customer's SQL environment to confirm if dev is an exact copy or not but I can't update the data source connection to use JDBC (JNDI). Any assistance would be greatly appreciated. Thanks in advance!

Answers (0)