Start a new topic
Answered

Migrating database from Oracle to Postgres

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

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

Answer

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 
Login to post a comment