Cr4e V2 Report stuck in infinite loop

[Former Member]

Recently we upgraded to Cr4e V2 from JRC. Our reports were running fine. We have replaced the ChangeTableLocation calls with ReplaceConnection calls with the _doNotVerifyDB option. Most of the reports run fine.

We have several reports which use a view into another DB (Oracle). These reports have an image on them that is pulled from that view and displayed on the page. The reports never stop running. I have set the crystal debug levels to info and I can see that it's stuck calling the same query over and over again:

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine.querybuilder] Query:

SELECT "B"."SYSID"

FROM   "E"."B" "B"

WHERE  "B"."SYSID"=3252652

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.formulas.Evaluator] Formula {@Record_Selection} evaluated to: b(true)

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine] Rowset restart: moveToStart true

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine] Rowset closeRowset: freeColumnInfo false

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine] Rowset execute

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine] Executing query using a Query Definition.

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine.querybuilder] Query:

SELECT "B"."SYSID"

FROM   "E"."B" "B"

WHERE  "B"."SYSID"=3252652

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.formulas.Evaluator] Formula {@Record_Selection} evaluated to: b(true)

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine] Rowset restart: moveToStart true

2015-08-05 09:15:59,065 INFO  [com.crystaldecisions.reports.queryengine] Rowset closeRowset: freeColumnInfo false

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine] Rowset execute

2015-08-05 09:15:59,065 INFO  [com.crystaldecisions.reports.queryengine] Executing query using a Query Definition.

2015-08-05 09:15:59,065 INFO [com.crystaldecisions.reports.queryengine.querybuilder] Query:

This keeps on going until all available temp space is used up on the server. it is useful to note that these same reports worked fine in the older SDK.

Interestingly for SOME of these reports the change datasource never completes and gets stuck doing this:

INFO  [com.crystaldecisions.reports.basicdataengine] Regenerating saved records

Just prior to that is some debug that says:

[com.crystaldecisions.reports.queryengine.querybuilder] Query:

SELECT "I_IMAGE"."IMAGE"

FROM   "IMG"."I_IMAGE" "I_IMAGE"

Which does not look correct as there's no where clause and these tables have millions of records in them. if it's trying to pull all the records that would be an issue.

Finally. If we remove the image from the reports they work fine.

Any and all help will be greatly appreciated.

[Former Member]

After further investigation it seems that if you have a dynamic image (not a static pre-loaded image, but one from a table row) in your report. Whether you are running ORCL or MSSQL and you switch datasources and attempt to persist the datsource with ReportClientDocument.saveAs(), Crystal will read every single record from the table before it saves the rpt file. No matter what the query is that you have set up in the report.