TOPIC: Failed to retrieve data Vendor Code 536

Failed to retrieve data Vendor Code 536 01 Nov 2013 18:14 #1468

  • cphillips
  • cphillips's Avatar
  • Offline
Hi,

I've taken a report that executes correctly through the Desktop app, and through Crystal Reports, but does not execute correctly when added to an RRD.
When the RRD executes it gives the following error:

"
Failed to retrieve data from the database.
Details: [ Database Vendor Code: 536 ]
Failed to retrieve data from the database.
Error in File [my report name.rpt]:
Failed to retrieve data from the database.
Details: [ Database Vendor Code: 536 ]
"

I can't seem to find any good info about what this specific error indicates. Does anyone here have any idea?

Thanks,
Chris
The administrator has disabled public write access.

Failed to retrieve data Vendor Code 536 01 Nov 2013 18:23 #1469

  • cphillips
  • cphillips's Avatar
  • Offline
Attached is a screenshot of the error message as well:
Attachments:
The administrator has disabled public write access.

Failed to retrieve data Vendor Code 536 01 Nov 2013 18:31 #1470

  • cphillips
  • cphillips's Avatar
  • Offline
The contents of my RRD file are as follows:

;WORKSPACE_MODE=FALSE
SaveReport[test]=C:\Users\cphillips\Desktop\report.rpt?DiscardSavedData=True&dbserver=IPCC01&dbdb=db_cra&dbuser=<redacted>&dbpass=<redacted>&saveas=C:\Users\cphillips\Desktop\report.pdf&export=Adobe Acrobat (PDF)&pdfPassword=&SaveSupressIfNoRecords=False¶m[CSQList]=OR|csq_01_hfhelpdesk,csq_01_iibahelpdesk¶m[EndDate]=11/1/2013¶m[StartDate]=10/31/2013&
The administrator has disabled public write access.