Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Stored Procedure Called Twice in CMC Post Reply Post New Topic
Author Message
wizard34
Newbie
Newbie


Joined: 05 Sep 2008
Online Status: Offline
Posts: 8
Quote wizard34 Replybullet Topic: Stored Procedure Called Twice in CMC
    Posted: 05 Sep 2008 at 9:16am
Patch ID: 37129394
Description:
When users view reports on demand or schedule reports that are based on a Sybase- stored procedure, using an ODBC
custom database logon in the CMC, the stored procedure runs more than once.
New Behavior:
To fix this problem, users must install this Hot Fix patch, and then do the following:
1) Ensure the registry key "VerifyStoredProceduresOnSetLocation" is set to “No.”
For CE9, the registry key is in the following directory: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal
Decisions\9.0\Crystal Reports\DatabaseOptions\
For CE10, the registry key is in the following directory: HKEY_LOCAL_MACHINE\SOFTWARE\Crystal
Decisions\10.0\Crystal Reports\DatabaseOptions\
2) Add the command "procreportoptions __noverifydatabase" in the command line of the Pageserver and Jobserver.
Note: the command "procreportoptions __noverifydatabase" has two underscores.
Known Limitations:
This fix is for the ODBC driver only.
This fix won't work for the RAS server or the Native driver

Does this problem occur in higher versions of Crystal Reports as well?
I am using Crystal 10 and i am having problem scheduling a report in CMC that has a call to the stored procedure as it exectues the stored procedure twice..
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.