Results 1 to 4 of 4

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

  1. #1

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

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


  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,246

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

    same old questions to ask:

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

    also

    - what method of connecting to database?
    - JDE Connection?
    - ODBC?
    - OLE DB?
    - Provider? (Microsoft or Oacle?)
    Larry Jones
    E1 9.2 - TR 9.2.2.6 on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3

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

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

  4. #4

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

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.