I m trying to execute talend job where it fails object not found. Please find the logs below. i am able to see the tables in the respective schemas. I use 3 schemas src, meta, tgt. Loading from src to tgt and meta. Could anyone let me know what I should add so that talend identifies the object under the schemas. i executing through an user i have given all grants to the user. Is thr anyway to explicitly elt he user to look into a specific schema. i am able to query the schema and tables through ssms.
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'customer'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:845) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:752) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(SQLServerStatement.java:654) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.tJDBCInput_1Process(t_customer.java:2837) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.tJDBCConnection_4Process(t_customer.java:2168) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.tJDBCConnection_3Process(t_customer.java:1977) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.tFileInputDelimited_1Process(t_customer.java:1762) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.tJava_1Process(t_customer.java:871) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.runJobInTOS(t_customer.java:20543) at ormbreporting_jdbc.t_customer_dim_0_1.t_customer_dim.runJob(t_customer.java:20260) at ormbreporting_jdbc.t_runjob_ormb_dw_dim_refresh_0_1.t_RunJob_ormb_dw_dim_refresh.tRunJob_5Process(t_RunJob_ormb_dw_dim_refresh.java:2256)
What's Microsoft SQL Server version are you using? Are respective tables getting created in sql server? Have you tried with and without informed the table schema (dbo)?
