• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Crystal Report Inconsistent behaviour after database change from Oracle9i to 10G


We have a very serious situation here.Crystal Report is not working properly after we switched from Oracle to Oracle 10G.Sometimes some reports are giving blank output and sometime some are going into error.And when we do a test by running one after another it works well . But again the next day same status . No all reports work ok.A same report with the same dataselection gives output sometime and doesn't give output sometime.
I am very new to this Crystal world & Need urgent help on this.
Thanks in advance


same old questions to ask:

- what version of Crystal?
- Fat clients or web/server version of crystal?


- what method of connecting to database?
- JDE Connection?
- Provider? (Microsoft or Oacle?)


We Are Experiencing Here at my business.. Your problem of crystal reports inconsistency after Oracle DB Upgrade...
Please Feed me Back if you found any cure to this problem
Thanks for your time..


Finally we found the cure to the problem.. we changed the connection from 'OLE DB' to 'oracle server' the connection 'oracle server' was not available untill our DBA installed a batch in crystal folders which was related to the DNS i think