1 Reply Latest reply on Feb 16, 2021 4:08 AM by Nico Heinze

    TM Error: [ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name

    renato Talo New Member

      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.