topic Re: Invalid object name in Talend Studio

Invalid object name

Anonymous — Mon, 29 Jun 2015 23:31:24 GMT

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

Re: Invalid object name

Anonymous — Tue, 30 Jun 2015 04:30:07 GMT

Hi,
Have you tried to change the table name to dbo.tablename to see if it works?
Best regards
Sabrina

Re: Invalid object name

Anonymous — Wed, 01 Jul 2015 20:06:54 GMT

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

Re: Invalid object name

Anonymous — Thu, 02 Jul 2015 09:48:39 GMT

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