Invalid object name

One Star

Invalid object name

Hi,
I have a schema available in my database and I can also view it under the Db connection.
In the database, this table is called DI.STGProviderErrorLog, but when it gets retrieved as a schema, it is only STGProviderErrorLog.
When I want to use the tMSSQLOutput to insert into this table, I get the error --
Invalid object name 'STGProviderErrorLog'.
OR
Invalid object name 'DI.STGProviderErrorLog'. (when I use the "DI." as the table name)
What should I do to so that Talend recognizes this table?

Regards,
Namrata
Moderator

Re: Invalid object name

Hi,
Have you tried to change the table name to dbo.tablename to see if it works?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Invalid object name

From the above, you can see that my table is not a dbo table. It is DI.STGProviderErrorLog. When I created my connection, I didn't enter any schema, which is why I could retrieve the tables under all the schemas. I have Core, DI, Pyt as various schemas in my database.
Will I have to create a separate connection for each of the database schemas although they belong to the same database?
Regards,
Namrata
Moderator

Re: Invalid object name

Hi,
We have seen that you use Context value in DB connection parameter. What's the value in context.AP2DB_Schema?
Have you tried to use DB connection parameter directly without using context in tMSSQLOutput to see if it works? Can you get 'STGProviderErrorLog' when input "DI" schema in DB connection parameter?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog