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

gefragt vor 2 Jahren96 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen