Migrating database from Oracle to Postgres : Portal

Start a new topic

Answered

Migrating database from Oracle to Postgres

Subham Dixit

started a topic about 4 years ago

After migrating my backend database from Oracle to Postgres, I can no longer browse as of date. My collection returns 0 values when browsing a date prior to the migration.

Best Answer

Subham Dixit said about 4 years ago

The browse as of date uses the repository MTA_INTEG_BATCH table to lookup the batch id. The repository is not typically migrated, so there browse as of date returns an error while looking for the batch id. You can follow these steps to migrate over the relevant tables.

Copy the content of MTA_INTEG_BATCH and MTA_INTEG_LOAD
set MTA_INTEG_BATCH.O_DATALOCATION to data location uuid of target environment.
nullify MTA_INTEG_BATCH.R_DATALOCJOB and R_JOBINSTANCE
Generate new UUID in the MTA_INTEG_LOAD
Generate new UUID in MTA_INTEG_BATCH
Copy the MTA_INTEG_LOAD UUID into the r_integload as it the r_integload references the UUID listed MTA_INTEG_LOAD

1 Comment

Subham Dixit

said about 4 years ago

Answer

Copy the content of MTA_INTEG_BATCH and MTA_INTEG_LOAD
set MTA_INTEG_BATCH.O_DATALOCATION to data location uuid of target environment.
nullify MTA_INTEG_BATCH.R_DATALOCJOB and R_JOBINSTANCE
Generate new UUID in the MTA_INTEG_LOAD
Generate new UUID in MTA_INTEG_BATCH
Copy the MTA_INTEG_LOAD UUID into the r_integload as it the r_integload references the UUID listed MTA_INTEG_LOAD