Forum Discussion

paulsnet1986's avatar
paulsnet1986
Helper I
4 years ago
Solved

Error Using SQL to Prefilter Data from Hana / ODBC: ERROR [42S02]

One of my reports has a dataset that's taxing on our embedded instance, and so I'm trying to limit the records in the largest table before they're imported.   Advanced editor source I have l...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi paulsnet1986 

     

    This error message indicates that it couldn't find the table "PROJECTDETAILLIST_PBI1". Please check the name of the table. Does it have an additional "1" at the end? From the first picture, you are querying data from a table named "PROJECTDETAILLIST_PBI". 

     

    If the table name is correct, please check the schema of the table. From the error message, it tried to find the table in schema WEBUSER by default. If this table is not in the schema, you should specifiy its schema in the SQL statement like 

    select * from schemaname.tablename where SoldTo = '10015'

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi paulsnet1986 

 

This error message indicates that it couldn't find the table "PROJECTDETAILLIST_PBI1". Please check the name of the table. Does it have an additional "1" at the end? From the first picture, you are querying data from a table named "PROJECTDETAILLIST_PBI". 

 

If the table name is correct, please check the schema of the table. From the error message, it tried to find the table in schema WEBUSER by default. If this table is not in the schema, you should specifiy its schema in the SQL statement like 

select * from schemaname.tablename where SoldTo = '10015'

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.