• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 550
  • Last Modified:

Crystal Management Console Server does not refresh reports

We have a Win 2003 SP2 Server running Crystal Management Console 11.5.  Over the weekend everything stopped running.  Reports were stacked up in the queue.  We bounced the server and now reports are refreshing very slowly.  We found a virus on the server hoping that this was the reason the Crystal application is having problems.  Most of our reports are Oracle ODBC and users are unable to see the normal tables that they see when they connect the crystal designer to the data base.  I can see the tables if I use the OLEDB for Oracle connector.  Has anyone run into this problem before?  What can we try to resolve the issue?
0
jrbledsoe001
Asked:
jrbledsoe001
  • 3
  • 3
2 Solutions
 
mlmccCommented:
Since you found a virus have you checked permissions to ensure they weren't changed?

mlmcc
0
 
jrbledsoe001Author Commented:
Hello mlmcc!

We checked the permissions and nothing was changed.  The server team did not reboot the server after the virus was removed so I am waiting to hear back if another reboot resolved the issue.   The issue is strange because the user running the reports (a system account) has access to all the Oracle tables with PL SQL, MS Access or OLEDB using Oracle oledb driver.  The system account can not access the tables when an ODBC connection is used.  No Microsoft patches were applied recently.  We were going to delete and recreate the MS ODBC system DSN if the restart doesn't clear up the issue.  The support team just bought a Crystal SAP support contract so I suggested they engage SAP before they uninstall and reinstall Oracle.  Let me know if you have seen this symptom before.
0
 
Kurt ReinhardtCommented:
With viruses or other malware, it's not uncommon for files in the system32 folder or their registry entries to be affected.   Simply "removing" a virus doesn't always solve the issue.  The easiest possible solution might be to copy odbcad32.exe from another machine and replace the one in your system32 folder.

That being said, I don't know if I'd trust a production server after it was hit with a virus, especially when things aren't working as expected.  Personally, I'd want to test the server thoroughly, read up on all issues associated to the specific virus, read up on other general virus-related issues (such as not being able to connect to the internet after successfully cleaning the virus), etc... As a last resort, I'd make sure I backed up my File Store and CMS Database, completely wipe the machine (assuming it's dedicated to Enteprise), do a clean Windows install and then a clean Enterprise install, restoring from the backups.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jrbledsoe001Author Commented:
Thank your for your input rhinok.  I took your suggestion and ran some tests from other machines and other data sources.  My dba verified that the user has necessary permissions on the tables which are no longer visible with the Crystal designer.  I created a machine data source on another machine using both Oracle and MS odbc drivers for oracle and the tables are not visible in the Crystal designer.  I can however view the tables with MS Access and other ODBC tools using both the oracle and microsoft odbc drivers for oracle.  I can view the tables using the Oracle service data connection and OLEDB for Oracle.  Even though the tables are not visible I can enter a sql command and pull in data into my report.  I am suspecting Crystal DLL problems.  Let me know if you have any other ideas of why my data tables are no longer visible with the Crystal designer.
0
 
mlmccCommented:
Have you tried to use a NEW machine with a clean install of Crystal.

The virus may have spread to other machines.

Are you running local installs of Crystal or a server install?

mlmcc
0
 
jrbledsoe001Author Commented:
Hello mlmcc,

The issue persisist regardless of the PC or Server we use.  We tested on workstations and servers which were not affected by the Virus.  The issue seems to be limited to the Oracle ODBC drivers.  The Microsoft ODBC drivers for SQL server were not impacted.
0
 
mlmccCommented:
You may have to at the least reinstall those drivers.  It may be neessary to reinstall Oracle or a full server rebuild.  

Apparently the virus caused more damage than you think it did.

mlmcc
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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