sorry table owner is test

i exported my pipeline to tql file so which is like below as your reference

CREATE APPLICATION emrah_cdc USE EXCEPTIONSTORE TTL : '7d' ;

CREATE FLOW emrah_cdc_SourceFlow;

CREATE SOURCE emrah_cdc_OracleSource USING Global.OracleReader ( 
  Password: 'DaOAJTW+rsG/7Bh9KwaK7w==', 
  Compression: false, 
  Tables: '"TEST"."SCALE_DATA";"TEST"."SCALE_DATA2"', 
  connectionRetryPolicy: 'timeOut=30, retryInterval=30, maxRetries=3', 
  Password_encrypted: 'true', 
  SupportPDB: false, 
  QuiesceMarkerTable: 'QUIESCEMARKER', 
  FetchSize: 1000, 
  DictionaryMode: 'OnlineCatalog', 
  QueueSize: 2048, 
  CommittedTransactions: true, 
  Username: 'striim', 
  TransactionBufferSpilloverSize: '1MB', 
  TransactionBufferType: 'Memory', 
  ConnectionURL: 'jdbc:oracle:thin:@//10.156.0.5:1521:1521/TMSNEW', 
  FilterTransactionBoundaries: true, 
  SendBeforeImage: true, 
  DatabaseRole: 'Primary' ) 
OUTPUT TO emrah_cdc_OutputStream;

END FLOW emrah_cdc_SourceFlow;

CREATE TARGET PostgreSQL_emrah_cdc_Target USING Global.DatabaseWriter ( 
  ConnectionRetryPolicy: 'retryInterval=30, maxRetries=3', 
  Tables: '"TEST"."%",TEST.%', 
  ParallelThreads: '2', 
  Password: 'h4sJIDx9CklrNjRl4Rw9rQ==', 
  CheckPointTable: 'CHKPOINT', 
  Password_encrypted: 'true', 
  CDDLAction: 'Process', 
  CommitPolicy: 'EventCount:1000,Interval:60', 
  StatementCacheSize: '50', 
  DatabaseProviderType: 'Postgres', 
  BatchPolicy: 'EventCount:1000,Interval:60', 
  ConnectionURL: 'jdbc:postgresql://10.30.21.2:5432/tmsnew', 
  PreserveSourceTransactionBoundary: 'false', 
  Username: 'postgres', 
  IgnorableExceptionCode: 'DUPLICATE_ROW_EXISTS, NO_OP_UPDATE, NO_OP_DELETE' ) 
INPUT FROM emrah_cdc_OutputStream;

END APPLICATION emrah_cdc;

Hello @Emrah 

can you please share output of the following queries - 

SELECT CDB FROM V$DATABASE;

SELECT NAME FROM V$CONTAINERS;

I just wanted to check if you are using a multitenant environment for capturing with OracleReader. If it is a multitenant environment, you should use three parts in the tables parameter. For example - ... - <container>.<schema>.<tablename>

-best

AKG

Hello

Thank you for reporting your issue.
Few points i observed 

1. from the tql file I see that connection URL has two ports mentioned 1521. 
Can you have it in the following format 

jdbc:oracle:thin:@//<container_db_fqdn>:1521/<pdb_service_name>



2. The database user must have access to root container , i think you are using the database user of a PDB. Please follow these steps to create a common user and use this in our application 
 

create role c##striim_privs;grant create session,execute_catalog_role,select any transaction,select any dictionary,logminingto c##striim_privs;grant select on SYSTEM.LOGMNR_COL$ to c##striim_privs;grant select on SYSTEM.LOGMNR_OBJ$ to c##striim_privs;grant select on SYSTEM.LOGMNR_USER$ to c##striim_privs;grant select on SYSTEM.LOGMNR_UID$ to c##striim_privs;create user c##striim identified by ******* container=all;grant c##striim_privs to c##striim container=all;alter user c##striim set container_data = (cdb$root, <PDB name>) container=current;

 Reference - https://www.striim.com/docs/en/oracle-database-cdc.html

Dear All,

striim and test users are common user, these are not part of any PDB and i am not using any PDB.

here is the output of commands.

SELECT CDB FROM V$DATABASE;

YES

SELECT NAME FROM V$CONTAINERS;

CDB$ROOT

SQL*Plus: Release 21.0.0.0.0 - Production on Wed Feb 7 16:56:31 2024
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Connected to:
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> conn striim/password;
Connected.
SQL> 

Summary of the problem :

Target table CDB$ROOT.SCALE_USER.SCALE_DATA doesn't exist

i changed the user from test to scale_user but the issue is same and i fixed 2 1521 ports on the connection URL but the result is same

Guys, i just changed the tables section on postgresql writer like this "CDB$ROOT.SCALE_USER"."%",SCALE_USER.%

and i did not get any error so it worked.

Thanks fo ryour support.

Regards