Re: Invalid table name in toracleoutputdelimited - Qlik Community

BNP · ‎2020-10-17

Hi Team,

I'm new to talend. I'm using csv file in tfileinputdelimited and output is torcaleoutput. while running the job, getting error message as "Invalid table name". Please find below the error.

Can you help me .

Starting job CSV_to_DBase at 22:47 17/10/2020.

[statistics] connecting to socket on port 3930

[statistics] connected

Exception in component tDBOutput_1 (CSV_to_DBase)

java.sql.SQLException: ORA-00903: invalid table name

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:754)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)

at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:963)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1192)

at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1731)

at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1701)

at proj.csv_to_dbase_0_1.CSV_to_DBase.tFileInputDelimited_1Process(CSV_to_DBase.java:3690)

at proj.csv_to_dbase_0_1.CSV_to_DBase.tDBConnection_1Process(CSV_to_DBase.java:517)

at proj.csv_to_dbase_0_1.CSV_to_DBase.runJobInTOS(CSV_to_DBase.java:4602)

at proj.csv_to_dbase_0_1.CSV_to_DBase.main(CSV_to_DBase.java:4402)

[FATAL]: proj.csv_to_dbase_0_1.CSV_to_DBase - tDBOutput_1 ORA-00903: invalid table name