Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

Cannot specify database schema

Hi, all:
I try to run my first TOS from one table to another, but it threw exception: Exception in component tMSSqlOutput_1
java.sql.SQLException: Invalid object name.
I search the old log and found this: https://community.talend.com/t5/Design-and-Development/Cannot-specify-database-schema/td-p/66483
Can you tell me if TOS 2.3.2 has been fixed or not? and how to setup database schema? like dbo.table1.
Thanks
Vincent
Labels (3)
1 Reply
_AnonymousUser
Specialist III
Specialist III
Author

Hi, all:
I come up with the work around:
1) Under Metadata\DB Connections\yourDB\Table schemas,
Define your table schema name: CUSTOMER].. (,,,,,,) VALUES (?,?,?,?,?,?,?)");
This is specific for MS SQL 2000, I didn't test MS SQL 2005 if the same.