Topic
3 replies Latest Post - ‏2012-10-10T10:19:25Z by SystemAdmin
babinag
babinag
91 Posts
ACCEPTED ANSWER

Pinned topic Collaboration item did not appears in catalog after "Success" step.

‏2012-10-10T09:07:22Z |
Hi all.
There is an issue, that appears second time.
1. New CollaborationItem was created in collaboration area.
2. Item went througt all steps, and succesfully exited "Success" step and "CHECKIN" event was logged.

09 Окт 2012, 09:44 BEGINSTEP 08 - Согласование записей НОРСИ SUCCESS RebroVA 09 Окт 2012, 09:44 ENDSTEP 08 - Согласование записей НОРСИ SUCCESS RebroVA SUCCESS 09 Окт 2012, 09:45 CHECKIN 08 - Согласование записей НОРСИ SUCCESS RebroVA

3. Item did not appeared in catalog.

Collaboration history of item exists, item does not exist.

Am I to open pmr, or some one knows what happens?
Updated on 2012-10-10T10:19:25Z at 2012-10-10T10:19:25Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    648 Posts
    ACCEPTED ANSWER

    Re: Collaboration item did not appears in catalog after "Success" step.

    ‏2012-10-10T09:22:36Z  in response to babinag
    Hi Alexey,

    Are there any exceptions in log files of the workflow service?
    Did you check the Fixit step of the colarea?
    • babinag
      babinag
      91 Posts
      ACCEPTED ANSWER

      Re: Collaboration item did not appears in catalog after "Success" step.

      ‏2012-10-10T10:07:48Z  in response to SystemAdmin
      Hi, Alexander.
      There is nothing at fixit.
      But i've found something in logs.
      db.log:
      
      2012-10-09 09:45:34,247 [WorkflowEventProcessorEventId2501625] ERROR com.ibm.ccd.common.db.Query - CWPCM0040E:The query failed : [ Static Query [name: GEN_CTG_CFP_CAT_FULL_PATHS_GETBYCTRIDTYPEFULLPATH] [id: 372] SELECT * FROM tctg_cfp_cat_full_paths WHERE cfp_company_id = 10001 AND cfp_cat_tree_id = 1403 AND cfp_full_path_type = 
      'PATH_FULL_PATH' AND cfp_full_path = 
      'Hierarchy_Export_Status?01_Waiting_for_transfer' AND cfp_version_id <= 999999999 AND cfp_next_version_id >= 999999999 ], Exception:ORA-03113: end-of-file on communication channel Идентификатор процесса: 17278 Идентификатор сеанса: 239 Порядковый номер: 2460   java.sql.SQLRecoverableException: ORA-03113: end-of-file on communication channel Идентификатор процесса: 17278 Идентификатор сеанса: 239 Порядковый номер: 2460   at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661) at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205) at com.ibm.ccd.common.db.Query.execute(Unknown Source) at com.ibm.ccd.common.db.Query.execute(Unknown Source) at com.ibm.ccd.common.db.Query.execute(Unknown Source) at com.ibm.ccd.common.db.Query.execute(Unknown Source) at com.ibm.ccd.common.gendb.GenCtgCfpCatFullPathsTable.getByCtrIdTypeFullPath(Unknown Source) at com.ibm.ccd.content.common.CategoryTree.getCategoryByPathFromDB(Unknown Source) at com.ibm.ccd.content.common.CategoryTree.getCategoryByPath(Unknown Source) at com.ibm.ccd.content.common.CategoryTree.getCategoryByPath(Unknown Source) at com.ibm.ccd.api.hierarchy.AbstractHierarchyImpl.getHierarchyNodeByPath(Unknown Source) at com.ibm.ccd.api.hierarchy.AbstractHierarchyImpl.getHierarchyNodeByPath(Unknown Source) at com.ibm.ccd.api.hierarchy.HierarchyImpl.getCategoryByPath(Unknown Source) ...the rest is invocation of postsave code   2012-10-09 09:45:34,247 [WorkflowEventProcessorEventId2501625] ERROR com.ibm.ccd.common.db.Query - Error with query: Static Query [name: GEN_CTG_CFP_CAT_FULL_PATHS_GETBYCTRIDTYPEFULLPATH] [id: 372] SELECT * FROM tctg_cfp_cat_full_paths WHERE cfp_company_id = 10001 AND cfp_cat_tree_id = 1403 AND cfp_full_path_type = 
      'PATH_FULL_PATH' AND cfp_full_path = 
      'Hierarchy_Export_Status?01_Waiting_for_transfer' AND cfp_version_id <= 999999999 AND cfp_next_version_id >= 999999999 2012-10-09 09:45:37,073 [WorkflowEventProcessorEventId2501625] WARN  com.ibm.ccd.common.db.Query - CWPCM0018W:The query is delayed: ( 2 490 ms)\n Static Query [name: UPDATE_WEE_STATUS] [id: 1966] update twfl_wee_workflow_event_entry set wee_event_entry_status = 
      'CHECKIN_SUCCESSFUL' where wee_event_id = 2501625 and wee_entry_id = 2054164 2012-10-09 09:45:39,169 [WorkflowEventProcessorEventId2501625] WARN  com.ibm.ccd.common.db.Query - CWPCM0018W:The query is delayed: ( 2 030 ms)\n Dynamic Query [ DELETE FROM TCTG_ITA_ITEM_ATTRIBUTES WHERE ( ITA_ITEM_ID IN  (2054164)) AND ITA_CATALOG_ID = 11815]
      

      This is execution of "PostSave" code:
      
      HierarchyManager hierMan = ctx.getHierarchyManager(); Hierarchy hier = hierMan.getHierarchy(
      "Hierarchy_Export_Status"); 
      //this line >> Category catToMap = hier.getCategoryByPath(
      "01_Waiting_for_transfer");
      

      exception.log - same exception
      
      2012-10-09 09:45:34,247 [WorkflowEventProcessorEventId2501625] ERROR com.ibm.ccd.common.error.AustinException - CWPCM0002E:Generic error / Exception: Failed to execute 
      'getByCtrIdTypeFullPath' on 
      'GenCtgCfpCatFullPaths'., Exception:ORA-03113: end-of-file on communication channel Идентификатор процесса: 17278 Идентификатор сеанса: 239 Порядковый номер: 2460   java.sql.SQLRecoverableException: ORA-03113: end-of-file on communication channel Идентификатор процесса: 17278 Идентификатор сеанса: 239 Порядковый номер: 2460
      


      Heh. As i see, internal exception raised in postsave, and item did not saved in catalog.
      Omg, there was no try{}catch() in
      
      @Override 
      
      public 
      
      void postsave(PostItemSaveFunctionArguments inArgs) ... 
      }
      

      My bad, i've not reviewed that code for a long time.

      I think, problem solved, thanks.
      • SystemAdmin
        SystemAdmin
        648 Posts
        ACCEPTED ANSWER

        Re: Collaboration item did not appears in catalog after "Success" step.

        ‏2012-10-10T10:19:25Z  in response to babinag
        Hi Alexey,

        Very strange that the exceptions wasn't captured by the workflow engine and the item wasn't transfered into the Fixit step.