Crystal Reports 2008 runs wrong Oracle stored procedure

[jonlesada]

When trying to run a report last saved in Crystal Reports 10 format using Crystal Reports 2008 (v11), the report seems to have started running Oracle stored procedures that aren't part of the report. It references one particular stored procedure, and also seems to think that procedure is a table. This cause a massive data deletion for us, which is obviously quite troubling.

There was no indication of what was running on the database, only that the database information failed to load. We discovered that the commands were running from Crystal Reports using Oracle logs.

Has anyone else experienced this type of erratic behavior from Crystal Reports 2008?

 

[IanWaterman]

Have you checked Datasource

Click on + and see where it really is getting data from. In DataExpert and on data explorer you only see the Alias. Could be aliased as table but in datasource actually pointing at Stored Proc.

Ian

 

[jonlesada]

Yes. There is only one database object associated with the report, but the procs it ran are not it. I had others double check using CR 10 to be sure.

 

[Turkbear]

Hi,
Check to see if a Command object is also in the report..
Crystal cannot 'run' anything in Oracle unless someone writes a command ( and to delete anything ( very odd behavior for a report) would require someone to grant the user sufficient rights) -
If no command object is found,check the table for triggers...
Try tracing the Oracle connection using Oracle's Enterprise manager or some other tool to see what is actually happening.
Absent a trigger or a command object, I am almost certain Crystal Reports is not the cause of your problem.







To Paraphrase:"The Help you get is proportional to the Help you give.."