cancel
Showing results for 
Search instead for 
Did you mean: 

as java system export error

anil_singh19
Participant
0 Kudos

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)

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member185239
Active Contributor
0 Kudos

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