Recently, I had an issue where my intranet reports stopped working. The reports were generated by Crystal Reports and served up in Internet Explorer. I've been looking for a resolution to the problem I am having and have just about run out of options. I have had several people look at the problem and they have all been stumped. The only reports that don't work are the reports that pull data from my Progress 9.1D database. I have reports using SQL, MySQL, and Access data and they work fine.
I'm not quite convinced that they are an error with Crystal. I've tried to install Crystal Reports Server 2008 on a completely different server and get a similar result when I try to run a report that pulls from my Progress database. However, when I check the event log on the server that holds my Progress database, I see nothing out of the ordinary at the time the reports went down. However, there IS an error the day prior. That error is:
Event ID: 11
Description: Failed extract of third-party root list from auto update cab at: <http://www.download.windowsupdate.com/msdownload/update/v3/static/trustedr/en/authrootstl.cab
> with error: A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file.
I've checked my event logs on my reports servers and got the following errors:
Event ID: 35402
Description: Web Component Server Connector Communication Initialization message: Cannot setup communication with the Web Component Server. Reason given: error number WSAEWOULDBLOCK.
Source: Application Error
Event ID: 1000
Description: Faulting application pageserver.exe, version 126.96.36.199, faulting module ntdll.dll, version 5.2.3790.4455, fault address 0x0002cac2.
Event ID: 33000
Description: The Page Server you are trying to connect to is not accessible. Please contact your system administrator. [Connecting to Page Server: servername.domain]
I would really appreciate any help I can get on this, I'm ripping out the little bit of hair that I have left.