Locked sessions
Hi everyone,
We are having a problem with users locking up in Forms 30 applications,
when they scroll a certain number of records before performing an insert
or update. When they Commit, the session freezes, and the iap30 process
starts to run wild.
I can repeat the problem consistently in all our databases. In all
cases, in the same form, I can update the 77th row, but freeze up when
I attempt to update the 78th row. The size of the rows being retrieved
is 62 characters + a date (is that 66 bytes?).
In testing, I ran the form with the -b switch, to set the maximum
number of records buffered in memory to be the same as the number of
rows displayed plus a few. I was able to successfully update any
row, but of course scrolling through the records was much slower.
Maybe related to this problem, is the situation where a user scrolls
very fast through a large number of records (by holding down the Down
Arrow key). The application terminates abnormally, and displays
an 'pid nnnnn (iap30) was killed on an unaligned access, at pc xxxxxx'
'Bus error', error message.
We are using Oracle 6.0.37.6.1, with Forms 3 applications, but with
mostly V2 triggers. We are on DEC Risc Ultrix 4.4, DEC 5000/260,
with 256Mb memory.
Can anyone help me? It is causing major problems in our production
system, and I am getting nowhere with solving the problem.
Many thanks
Karen
Karen Payten
Database Administrator
Computing and Communication Services
University of New England, Armidale NSW
Email: karen_at_metz.une.edu.au Phone: +61 67 733549
Received on Tue Nov 29 1994 - 06:13:58 CET
Original text of this message