An object or column name is missing or empty.

gouravd_7 — Thu, 22 Nov 2018 13:35:18 GMT

Hi Team,

I am getting below error when, I am trying to load data from text file to mssqloutput.

Error:

Starting job bapitest at 18:45 22/11/2018.

[statistics] connecting to socket on port 3478
[statistics] connected
Exception in component tMSSqlOutput_1 (bapitest)
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:903)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:796)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183)
[FATAL]: sga_data_lake.bapitest_0_1.bapitest - tMSSqlOutput_1 An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
com.microsoft.sqlserver.jdbc.SQLServerException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:232)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1672)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:903)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:796)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7535)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:769)
at sga_data_lake.bapitest_0_1.bapitest.tFileInputDelimited_1Process(bapitest.java:1000)
at sga_data_lake.bapitest_0_1.bapitest.runJobInTOS(bapitest.java:1702)
at sga_data_lake.bapitest_0_1.bapitest.main(bapitest.java:1444)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2438)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:208)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:183)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:769)
at sga_data_lake.bapitest_0_1.bapitest.tFileInputDelimited_1Process(bapitest.java:1000)
at sga_data_lake.bapitest_0_1.bapitest.runJobInTOS(bapitest.java:1702)
at sga_data_lake.bapitest_0_1.bapitest.main(bapitest.java:1444)
[statistics] disconnected
Job bapitest ended at 18:45 22/11/2018. [exit code=1]

Please find the attached job screenshot.

Thanks,

Gourav Dubey

Re: An object or column name is missing or empty.

TRF — Sun, 25 Nov 2018 18:03:28 GMT

Share your tMSSqlOutput_1 details.

topic Re: An object or column name is missing or empty. in Talend Studio

An object or column name is missing or empty.

Re: An object or column name is missing or empty.