Verify must be performed before the first refresh (CRS 300003)

[Former Member]

Hello,

one of our customers has a Problem with the following error message "Verify must be performed bevore the first refresh (CRS 300003)" after a failed scheduling of a Crystal Report document. This error occurs at each scheduling.

In the CR Client or in the BI Launch pad it is possible to refresh the document.

With the schuling of other CR documents the customer has no problems.

Envirornment:

SAP BusinessObjects 4.1 SP5

SQL Server (Datasource)

Does anyone know the Problem/error message? Is there a solution for the Problem?

It is possible to deactivate the Validation of the CR document?

Thanks,

Regards,

Daniel

[Former Member]

Hi,

Add following switch to the command line of all CrystalReportsProcessingServers* and all the AdaptiveJobServers which has the CrystalReportSchedulingService

Go to properties of the server in CMC>Servers

-procreportoptions __noverifydatabase

Note: there is a space after 'options' and two underscores after the space

* For CR 2013 report change has to be made in CrystalReports2013ProcessingServer

* For CR for Enterprise change has to be made in CrystalReportsProcessingServer

Restart all the servers in which the change has been made

Anupam Kelkar

[former_member185603]

Check this KB

2111914
  - Error: Verify must be performed before the first refresh (CRS
300003) occurs when schedul...

[Former Member]

I saw that KB. But in our case the data in the report is from a MS SQL Server and not from SAP BW/BEx query.

In the datasource (SQL Server) there were no changes

[DellSC]

I would open the report in Crystal, verify the database, and then resave it to the BI Platform.

Also, make sure that you're using the same version of the MS SQL client on BOTH the developer workstation and the server.  For example, if you have SQL Server Native Client 10 or 11 on the workstation where the report was created and just the SQL client that's installed with the operating system on the server, you'll need to upgrade the client on the server to match what's on the workstation.  If it's the other way around and the Native Client is on the server, then the workstation will have to be updated.

-Dell