<br><font size=2 face="sans-serif">All,</font>
<br>
<br><font size=2 face="sans-serif">I have an intermittent problem with
QTP adding records, and then SQL being not able to read all the records.
</font>
<br>
<br><font size=2 face="sans-serif">The QTP has multiple requests, the commit
is at run. In one of the requests it adds 1 record to table A and
1 record to table B. In the next request it calls a stored procedure
which reads the record on table A but is unable to read the record on table
B. It seems like some sort of timing issue but makes no sense to
me.</font>
<br>
<br><font size=2 face="sans-serif">The Powerhouse version is 8.43d1.</font>
<br><font size=2 face="sans-serif">The Unix version is AIX 5.3.0.</font>
<br><font size=2 face="sans-serif">The Oracle version is 10.0.1.0.2.0.</font>
<br>
<br><font size=2 face="sans-serif">Has anyone come across this problem
before? If so was you able to resolve it?</font>
<br>
<br><font size=2 face="sans-serif">The problem is bigger than not being
able to read records from SQL. I have had the same problem before
where 10 records get added to table A in one request and in the next request
it only reads 5. I was able to get around this by writing the records
to a subfile as well as the table and then in the next request access the
subfile instead of the table. That suggests that it is some sort
of problem between Oracle and QTP.</font>
<br>
<br><font size=2 face="sans-serif">Many thanks,</font>
<br><font size=2 face="sans-serif">Dave Wiltshire</font>
<BR>
***************************************************************<BR>
Wincanton plc is a leading European provider of supply chain solutions. We design, implement and operate creative solutions for customers in 15 countries. Our business has a turnover of over EUR2.4bn /1.68bn pounds and employs 27,000 staff across 360 locations. Warehousing, transport and specialist services are provided for customers in a range of sectors including automotive, retail, FMCG, petrochemicals and manufacturing. Further information on our unique achievements and competencies can be found by visiting <BR>
<BR>
www.wincanton.co.uk<BR>
<BR>
****************************************************************<BR>
This e-mail and any files transmitted with it are confidential <BR>
and intended solely for the use of the individual(s) to whom it <BR>
is addressed. If you have received this e-mail in error please <BR>
contact IT Service Desk on +44 (0) 870 870 9393 or e-mail<BR>
mail.monitor@wincanton.co.uk<BR>
<BR>
Any views or opinions expressed are solely those of the author <BR>
and do not necessarily represent those of Wincanton plc<BR>
or any of its subsidiary companies. Unauthorised publication, <BR>
use, dissemination, forwarding, printing or copying of this <BR>
e-mail and its associated attachment(s) is strictly prohibited.<BR>
Wincanton plc, Methuen Park, Chippenham, Wiltshire SN14 0WT.<BR>
****************************************************************<BR>