javax.servlet.ServletException

Cannot find work items. An attempt to fetch the work items using the where condition " ( wi_state = 1 OR wi_state = 2 OR wi_state = 3 ) " from the datastore has failed. The exception reported is: Invalid column name Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid. sql statement: SELECT * FROM admin_list_wi WHERE ci_domain_ref = 0 AND ( wi_state = 1 OR wi_state = 2 OR wi_state = 3 ) ORDER BY wi_modify_date desc

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4765

  • via Oracle Community by user8973124, 1 year ago
    hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid. sql statement: SELECT * FROM admin_list_wi WHERE ci_domain_ref = 0 AND ( wi_state = 1 OR wi_state = 2 OR wi_state = 3 ) ORDER BY wi_modify_date desc
  • machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid. sql statement: SELECT FROM admin_list_wi WHERE ci_domain_ref = 0 AND ( wi_state = 5 OR wi_state = 6 ) ORDER BY wi_modify_date desc
  • via Oracle Community by 622841, 1 year ago
    machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid. sql statement: SELECT * FROM admin_list_wi WHERE ci_domain_ref = 1 AND wi_state = ? AND fault_name LIKE ? ORDER BY wi_modify_date desc
  • Stack trace

    • javax.servlet.ServletException: Cannot find work items. An attempt to fetch the work items using the where condition " ( wi_state = 1 OR wi_state = 2 OR wi_state = 3 ) " from the datastore has failed. The exception reported is: Invalid column name Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid. sql statement: SELECT * FROM admin_list_wi WHERE ci_domain_ref = 0 AND ( wi_state = 1 OR wi_state = 2 OR wi_state = 3 ) ORDER BY wi_modify_date desc at com.evermind.server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:866) at com.evermind.server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:813)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago