Tuesday, June 7, 2011

custom database logon in the CMC, the stored procedure runs more than once.

CE 10, BO XI R2 and BO 3.1


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

No comments:

Post a Comment

Sonarqube Upgrade from 9.4.4 to 9.9.4 LTS

 Issue:  1) Java hasbeen upgraded from 11 to Open JDK 17. And Sonarqube is upgraded from 9.4 to 9.9.4. 2) After the upgrade sonarqube servic...