An object or column name is missing or empty.

Six Stars

An object or column name is missing or empty.

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

Highlighted
Forteen Stars TRF
Forteen Stars

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

Share your tMSSqlOutput_1 details.


TRF

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.