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

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

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

    ‏2012-10-10T09:22:36Z  
    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

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

    ‏2012-10-10T10:07:48Z  
    Hi Alexey,

    Are there any exceptions in log files of the workflow service?
    Did you check the Fixit step of the colarea?
    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

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

    ‏2012-10-10T10:19:25Z  
    • babinag
    • ‏2012-10-10T10:07:48Z
    Hi, Alexander.
    There is nothing at fixit.
    But i've found something in logs.
    db.log:
    <pre class="jive-pre"> 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] </pre>
    This is execution of "PostSave" code:
    <pre class="jive-pre"> HierarchyManager hierMan = ctx.getHierarchyManager(); Hierarchy hier = hierMan.getHierarchy( "Hierarchy_Export_Status"); //this line >> Category catToMap = hier.getCategoryByPath( "01_Waiting_for_transfer"); </pre>
    exception.log - same exception
    <pre class="jive-pre"> 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 </pre>

    Heh. As i see, internal exception raised in postsave, and item did not saved in catalog.
    Omg, there was no try{}catch() in
    <pre class="jive-pre"> @Override public void postsave(PostItemSaveFunctionArguments inArgs) ... } </pre>
    My bad, i've not reviewed that code for a long time.

    I think, problem solved, thanks.
    Hi Alexey,

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