Hello,
i'm trying to execute a data masking of one sql server table. but appear this error:
INFO : Mon Feb 15 16:40:21 2021 [RR_4029] : READER_1_1_1 SQ Instance [SQ_customers_1] User specified SQL Query [select t0.customer_id as "customer_id", t0.first_name as "first_name", t0.last_name as "last_name", t0.phone as "phone", t0.email as "email", t0.street as "street", t0.city as "city", t0.state as "state", t0.zip_code as "zip_code" from customers t0]
INFO : Mon Feb 15 16:40:21 2021 [RR_4049] : READER_1_1_1 RR_4049 SQL Query issued to database : (Mon Feb 15 16:40:21 2021)
ERROR : Mon Feb 15 16:40:21 2021 [RR_4035] : READER_1_1_1 SQL Error [
FnName: Execute -- [informatica][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'customers'.].
ERROR : Mon Feb 15 16:40:21 2021 [BLKR_16004] : READER_1_1_1 ERROR: Prepare failed.
INFO : Mon Feb 15 16:40:21 2021 [WRT_8333] : WRITER_1_*_1 Rolling back all the targets due to fatal session error.
INFO : Mon Feb 15 16:40:21 2021 [WRT_8325] : WRITER_1_*_1 Final rollback executed for the target [TGT_Microsoft_SQL_Server_customers] at end of load
INFO : Mon Feb 15 16:40:21 2021 [WRT_8035] : WRITER_1_*_1 Load complete time: Mon Feb 15 16:40:21 2021
Can you help me to resolve? in Attachment the log complete.
Thank you.
Using this connection there is no table "customers" in the SQL Server database. Either the connection points to the wrong database / DB schema, or the user ID used in the connection doesn't have SELECT permission on the table. So you will have to correct the connection.
Regards,
Nico