SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Data Target (Update) node error 32: Data Access Plugin - Output table doesn't exist

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Data Target (Update) node error 32: Data Access Plugin - Output table doesn't exist

[ Edited ]

I have a data job that needs to output NCOA data into an existing table in Teradata. However, I'm getting an error (32: Data Access Plugin - Output table doesn't exist) when I run the data job. I've made sure the correct output table is selected under properties in the Data Target (Update) node and the inputs (DSN, Schema_name, Table_name, Fields, Primary_key, etc) to the Data Target (Update) node are correct based on my existing table in Teradata. What is required in the Data Target (Update) node to insert data into an empty table? 


Accepted Solutions
Solution
3 weeks ago
Respected Advisor
Posts: 4,674

Re: Data Target (Update) node error 32: Data Access Plugin - Output table doesn't exist

@maxd

The message 32: Data Access Plugin - Output table doesn't exist looks to me like:

- Access to Teradata as such is working

- Either the table does really not exist in Teradata or your user connecting to Teradata doesn't have the right privileges to "see" the table.

View solution in original post


All Replies
Solution
3 weeks ago
Respected Advisor
Posts: 4,674

Re: Data Target (Update) node error 32: Data Access Plugin - Output table doesn't exist

@maxd

The message 32: Data Access Plugin - Output table doesn't exist looks to me like:

- Access to Teradata as such is working

- Either the table does really not exist in Teradata or your user connecting to Teradata doesn't have the right privileges to "see" the table.

New Contributor
Posts: 2

Re: Data Target (Update) node error 32: Data Access Plugin - Output table doesn't exist

After giving the user correct access to the table in Teradata, the job is running. Thank you for your guidance.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 136 views
  • 0 likes
  • 2 in conversation