bods Query either selects from no object at all

[astudillo]

Hi everybody,

When I execute muy job in BODS I get the error below:

225023472523952CON-12090422/09/2017 14:23:16|Session Cargar_tablas 225023472523952CON-12090422/09/2017 14:23:16Warning: Data Services ODBC Driver Manager got an unknown ODBC conformance level <30,000000> for datasource <origen>. The 225023472523952CON-12090422/09/2017 14:23:16Driver Manager will attempt to load the driver with the lowest ODBC conformance level possible. 225023472523952RES-02014822/09/2017 14:23:16|SESSION Cargar_tablas|WORKFLOW CARGA_TABLA_HECHOS|DATAFLOW CARGA_HECHOS|STATEMENT <GUID::'ff7e9fef-c71a-4523-abc1-a8be77681060' QUERY Query> 225023472523952RES-02014822/09/2017 14:23:16Query <Query> either selects from no object at all, or its SELECT produces <17> columns while the query output schema specifies 225023472523952RES-02014822/09/2017 14:23:16<17> columns. Please re-edit the query. 225023472523952RES-02014822/09/2017 14:23:16|SESSION Cargar_tablas|WORKFLOW CARGA_TABLA_HECHOS|DATAFLOW CARGA_HECHOS|STATEMENT <GUID::'ff7e9fef-c71a-4523-abc1-a8be77681060' QUERY Query> 225023472523952RES-02014822/09/2017 14:23:16Query <Query> either selects from no object at all, or its SELECT produces <17> columns while the query output schema specifies 225023472523952RES-02014822/09/2017 14:23:16<17> columns. Please re-edit the query.

Please what is happening ?

I have seen in sap that the problem could be :

Query <Query> either selects from no object at all, or its SELECT produces <1 > columns while the query output schema specifies <0> columns. Please re-edit the query.

Are you mapping columns from source table to target table in Query Transform? Check it out.

I think that I am mapping only source with target , it is right ?????

I my case is :

Query <Query> either selects from no object at all, or its SELECT produces <17 > columns while the query output schema specifies <17> columns. Please re-edit the query.

Please what is happening in my case ?

I have attached some pìctures.

Thanks in advance

Best Regards

[mageshwaran_subramanian]

Make sure you have a valid SQL statements in SQL transforms and check the column names in the mapping