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.
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.
Click Here to Expand Forum to Full Width