DMS giving error while replicating a table

0

I am doing refactoring from Oracle to postgres. All the tables data migrated from Oracle to postgressql. I am having issue with one table, below error found in postgres log files. Please let me know how to fix this error.

2022-07-05 20:02:07 UTC::@:[4551]:LOG: checkpoint starting: time 2022-07-05 20:02:07 UTC::@:[4551]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 1 removed, 0 recycled; write=0.106 s, sync=0.003 s, total=0.148 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=119791 kB 2022-07-05 20:07:07 UTC::@:[4551]:LOG: checkpoint starting: time 2022-07-05 20:07:07 UTC::@:[4551]:LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.106 s, sync=0.003 s, total=0.136 s; sync files=1, longest=0.003 s, average=0.003 s; distance=65536 kB, estimate=114365 kB 2022-07-05 20:09:00 UTC:10.0.0.192(44794):toype@bm:[29897]:ERROR: permission denied for table job_log 2022-07-05 20:09:00 UTC:10.0.0.192(44794):toype@bm:[29897]:CONTEXT: SQL statement "UPDATE central.job_log SET finished = --(CLOCK_TIMESTAMP() AT TIME ZONE COALESCE(CURRENT_SETTING('aws_oracle_ext.tz', TRUE), 'UTC'))::TIMESTAMP(0), current_timestamp,

		job_state = PJOBSTATUS, task_state = PTASKSTATUS
            WHERE schema = PSCHEMA AND job_id = PJOB_ID AND finished IS NULL"
PL/pgSQL function central.job_logger(text,double precision,text,text,double precision,double precision) line 62 at SQL statement
SQL statement "CALL central.job_logger(SESSION_USER, new.job_id, new.job_type, new.requester_id, new.job_state, new.task_state)"
PL/pgSQL function "job_trig$job"() line 4 at CALL
COPY job, line 1: "33984,"finsum","auto",4,"finsum",4,"<parameter name=\"user\" value=\"NSC\" /><parameter name=\"netId..."

2022-07-05 20:09:00 UTC:10.0.0.192(44794):toype@bm:[29897]:STATEMENT: COPY "toype"."job" FROM STDIN WITH DELIMITER ',' CSV NULL 'attNULL' ESCAPE '' 2022-07-05 20:12:07 UTC::@:[4551]:LOG: checkpoint starting: time 2022-07-05 20:12:08 UTC::@:[4551]:LOG: checkpoint complete: wrote 12 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=1.212 s, sync=0.004 s, total=1.241 s; sync files=6, longest=0.004 s, average=0.001 s; distance=65558 kB, estimate=109485 kB

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions