Skip to Content
0

Crystal Reports 2016 - Long time to update data source

Nov 23, 2017 at 02:04 PM

92

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vitaly Izmaylov
Nov 23, 2017 at 04:29 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
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

0
Vitaly Izmaylov
Nov 24, 2017 at 03:18 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 06, 2017 at 11:18 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 25 at 03:32 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0