Euro Conversion R03B11E

[mcb]

Hello List

Rollback segments are creating problems in R8903B11E and R8903B14E


These programs finishes with errors, on the JDE.LOG we can see


29752 Mon Jul 2 16:11:10 2001 dbfetch163
OCI0000056 - Unable to fetch - SELECT * FROM CRPDTA.F03B14 WHERE ( ( RZCO >= :KEY1 AND RZCO <= :KEY2 ) ) ORDER BY RZCO ASC,RZPYID ASC

29752 Mon Jul 2 16:11:10 2001 dbfetch169
OCI0000057 - Error - ORA-01555: snapshot too old: rollback segment number 3 with name "R03" too small

29752 Mon Jul 2 16:11:10 2001 jdb_drvm888
JDB9900172 - Failed to exeute db fetch

Our rollback segments are created correcly. They are setup as:

Number of segments=4
Size 400 MB aprox.

max of 500 extents of 1 MB each


It seems that we may have plenty of space for the conversion Jobs.

Have you encountered such situation??

Thanks.

 

[Carl_Fisher]

Are you sure they are big enough? When we upgraded from B732.1 to Xe we
needed one rollback of about 3.5Gb!!!!!!,that was for the F03B14 conversion,
I expect the F03B11 to be bigger. I calculate you are expecting a maximum
rollback of 900 Mb, not very big for the F03B14 (unless you are only a very
small shop) - you need enough space to hold the entire table in rollback!
for an efficient conversion with the JDE job.

How much free disk space do you have?

If you have plenty - set extents to 100 Mb and unlimited. If you do not have
plenty - get plenty, if necessary, borrow it, this is afterall a one off
job.

What messages do you have in the Oracle Logs? Has you DBA looked at the Size
of the Rollback segments? Look at the high-water mark - this shows how large
it got.





OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + Some 95 and NT PC's