on 05-26-2016 8:03 AM
while exporting the as java system its throwing error
java.io.IOException: ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-22924: snapshot too old
at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:517)
at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:187)
at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:188)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:152)
at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:142)
at com.sap.sql.jdbc.common.CommonWrappedInputStream.read(CommonWrappedInputStream.java:89)
at com.sap.inst.jload.db.BlobHandler.writeValue(BitHandler.java:194)
at com.sap.inst.jload.db.DBTable.unload(DBTable.java:181)
at com.sap.inst.jload.executor.JobExecutor.dbExport(JobExecutor.java:176)
at com.sap.inst.jload.executor.JobExecutor.executeJob(JobExecutor.java:763)
at com.sap.inst.jload.Jload.main(Jload.java:273)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:331)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Hello Anil,
How big is the JAVA system you are exporting ?
It looks like your PSAPUNDO is too small. Allocate more space to the PSAPUNDO.
KR,
Amerjit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anil,
You might also want to check the value for Redo Log. This error normally happens when the redo log size is not big enough to handle any large data transfer activity.
Thanks,
Manas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anil,
Just repeat the the phase several time and your issue will get resolve.
If the issue still persist , then you can check the below sapnote
1828574 - error: ORA-01555 Snapshot Too Old occurs in Data Services loading Oracle table results
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.