[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1716
  • Last Modified:

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
0
trobertson7
Asked:
trobertson7
  • 5
  • 5
1 Solution
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now