reports compatibility issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: reports compatibility issue

  1. #1
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342

    Question

    Hi everyone,
    I have a very strange problem deploying reports.

    I have a db A, that runs on 817 NT.
    I have a db B, that runs on 817 AIX.

    When i compile the report against db A, I can successfully run the report connected to db A but when I run it connected to db B it hangs. --> 100% CPU utilisation on the client ( NT4 Workstation )

    When i compile the same report against db B, I can successfully run the report connected to db B, but when I run in connected to db A it hangs.

    I compile the report in reports builder. Then I create a REP file that is saved to disk. I start the report using a forms-application. So, the way I run the report is always the same, only the db I connect to is different.

    On db A and db B the NET8 listener is used.

    It resembles http://www.dbasupport.com/forums/sho...threadid=12287, but they're was no solution in this thread.

    Anyone an idea ?
    I also made an iTAR with oracle support.

    Gert

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342

    Talking

    We located the problem ourselves.

    In the report, we have a BeforeReport function.
    In this function, we call a report Packaged Function m_init.f_init(... ) that itselfs calls a db packaged function.

    When we create a report function ( not in a package ) f_init, instead of the packaged function, and we use this function in the BeforeReport function, everything seems to be OK.

    Looks like a bug in reports to me.
    I will keep you informed about what oracle support has to say.

    Regards
    Gert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width