Talend job execution - object not found

Anonymous — Thu, 25 Oct 2018 14:34:32 GMT

Hi,

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)

Re: Talend job execution - object not found

Anonymous — Mon, 05 Nov 2018 08:13:27 GMT

Hello,

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)?

Best regards

Sabrina

topic Talend job execution - object not found in Talend Studio

Talend job execution - object not found

Re: Talend job execution - object not found