Crystal Reports 2016 - Long time to update data source

[111378]

We receive Crystal Reports from a vendor that we update for use in our system. When we get the reports we need to update the data source as it initially is pointing to one of their databases. When I try tot update the data source to our database it can take over 20 minutes to finish. Is it because it is looking for the original data soure (which is not available)? What can i do speed this up? I does eventually update but it impacts some other workflows.

[Former Member]

I am experiencing a similar issue. My destination is Oracle 12 c database. Is this a known problem with Crystal Reports 2016 and Oracle 12c database?

Thanks.
Marc

[vitaly_izmaylov]

With Oracle 12 C the time to query system tables like

SYS.ALL_SYNONYMS increased comparing to Oracle 11 and it caused performance issues for Set Datasource process in Crystal Reports. When we do Datasource to datasource changes it looks like it sent queries too many times. Table to table works better.

[111378]

Individually selecting the tables does go faster. Is this an CR2016 issue? We haven't had this problem with CR2013.

[vitaly_izmaylov]

Have you tried the following:

1. Open the report in CR Designer

2. Open Set datasource Location dialog

3. Create a new connection for you datasource

4. Do Table to Table Update instead of Connection to Connection.

Does it take long as well?

[vitaly_izmaylov]

If the destination is Oracle 12 c database then it is known problem. What is your database, connection?

[111378]

I believe their database is oracle while ours is a windows SQL server 2012

[Former Member]

I am experiencing a similar issue. My destination is Oracle 12 c database. Is this a known problem with Crystal Reports 2016 and Oracle 12c database?

Thanks.
Marc