Significant problem with socket communication

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:

     Source:          crypt32
     Category:       None
     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:

1st Error:    
     Source:         Seagate_wcscgi
     Category:      CORBA
     Type:             Error
     Event ID:        35402
     Description:   Web Component Server Connector Communication Initialization message:    Cannot setup communication with the Web Component Server.  Reason given: error number WSAEWOULDBLOCK.

2nd Error:
     Source:          Application Error
     Category:       (100)
     Type:              Error
     Event ID:         1000
     Description:    Faulting application pageserver.exe, version 8.0.0.14, faulting module ntdll.dll, version 5.2.3790.4455, fault address 0x0002cac2.

3rd Error:
     Source:          Seagate_WebCompServ
     Category:       General
     Type:              Warning
     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.

Tim
trobertson7Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
What version of Crystal are you running?

Are you running through Crystal Server or do you have other ways to run the reports?

mlmcc
0
trobertson7Author Commented:
The original Crystal Reports was 8.5 and viewed through a Seagate pageserver that was tied into Apache somehow. I didn't set them up, so forgive me if I can't be more specific with things.
0
mlmccCommented:
Has it ever run in this setup?

I know there were issues with Windows XP and some of the earlier versions of Crystal.

mlmcc
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

trobertson7Author Commented:
It has worked for several years, then just stopped working one day. I checked Windows Updates and there were some updates that were applied 2 days prior. I went through all of them and removed all updates applied that day, thinking it may have had a delayed reaction. Still nothing.
0
mlmccCommented:
Is the page server running?

mlmcc
0
trobertson7Author Commented:
Yes, Seagate Page Server, Seagate Web Component Server, and Apache are all running.

I've had support companies, SAP, and an SAP Partner, Progress support, and Vantage support remote in and nobody can figure this out. I figured I would throw something on here to see if I can get an answer.
0
mlmccCommented:
Unfortunately the technology you are using is too old for most of us to remember what the issues were/are.

mlmcc
0
trobertson7Author Commented:
I know what you mean. Do you happen to know if Crystal Reports Server 2008 will work with a Progress 9.1D database? I know that it's not a tested and supported DB platform, but I'm just trying to find a viable solution.
0
mlmccCommented:
I may if you can find an ODBC driver for it.

Supported just means SAP/Crystal will help you if there are problems
Tested means they tried it and it worked.

Since there are so many databases out there, they tend to look at the newer versions and work with them rather than try to make it work with all versions back to 1.0

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
trobertson7Author Commented:
I've tried installing CRS 2008 on a completely different server, and it still gives me connectivity issues. I'm checking out Stonefield SDK as an alternative to Crystal. I will let you know how I make out with things. Thanks!

Tim
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.