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

Oracle Community | user8973124 | 6 years ago
  1. 0

    Oracle BPEL Process Manager Full Cycle

    Oracle Community | 6 years ago | user8973124
    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
  2. 0

    BPEL Console Fails with error

    Oracle Community | 9 years ago | 578146
    javax.servlet.ServletException
  3. 0

    Error in BPLE CONSOLE after applying the patch 10.1.3.3.0

    Oracle Community | 8 years ago | Ashok Kumar P
    javax.servlet.ServletException: Cannot find work items. An attempt to fetch the work items using the where condition "" from the datastore has failed. The exception reported is: [ODBC S1002] invalid column number 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 ORDER BY wi_modify_date desc
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    strange human task error in BPEL process

    Oracle Community | 8 years ago | ali_nizam
    javax.servlet.ServletException: Cannot find work items. An attempt to fetch the work items using the where condition "cikey = ? and ( node_id like 'BpInv%' or node_id like 'BpRcv%' or node_id like 'BpOMs%')" 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 cikey = ? and ( node_id like 'BpInv%' or node_id like 'BpRcv%' or node_id like 'BpOMs%') ORDER BY wi_creation_date
  6. 0

    Problem with BPEL Admin

    Oracle Community | 8 years ago | 591371
    javax.servlet.ServletException

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. com.evermind.server
      EvermindPageContext.handlePageException
      1. com.evermind.server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:866)
      2. com.evermind.server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:813)
      2 frames