Crystal Reports Pro 6, Oracle 7.3.3 on Solaris, Bizarre Slowness

From: Steve Cooney <pacwin_at_ihug.co.nz>
Date: Sat, 12 Sep 1998 19:47:34 +1200
Message-ID: <6td8so$b08$1_at_newsource.ihug.co.nz>



Greetings,

we are stumped with 30-40 minute waits for Crystal Reports to populate its listbox, when and only when, we want to display the list of stored procedures
on the server when selecting the tables for a report. If you select the wrong procedure you are then faced with another 30-40 minute wait. Not good for productivity. We have the latest 6.0.151 build of CR Pro 6.

This is a dev server with minimal load, ODBC with CR6 (Intersolve), Microsoft and Oracle drivers for Oracle all work fine with tables. Client apps using the Oracle Call Interface/SQL-Net are not impacted. Only Crystal Reports and only with PL/SQL stored procedures. The clients are NT4W OS with most of Oracle Client for NT 7.3.4 installed.

We have logged a web technical request with Seagate but no response after 4 days. There is nothing notewrthy on Oracle Techsoft.

Any clues or advice on how to troubleshoot it. Any tracing or system initialisation files to tweak?

Steve Cooney Received on Sat Sep 12 1998 - 09:47:34 CEST

Original text of this message