Active BPM Process with Linked Object causes System Error on Task Save action indicating invalid SQL statement attribute preagg_resource

Document ID : KB000018740
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

If a BPM Process is created with a Linked Object and an auto-start condition, and the process is activated even if the auto-start condition is not met, this will cause a problem in saving any task. This issue also occurs when trying to save the project back into Clarity from Open Workbench (OWB).

Partial APP-CA.LOG Error Message:
WARN 2014-03-25 11:21:55,664 [http-bio-80-exec-359] com.niku (clarity:myuser:8274053_6EFE744B-098D-41EF-B0B2-6AAF8769B642:projmgr.taskPropertiesPost)

For info only - SQL statement not supported by OMP:
WARN 2014-03-25 11:21:55,664 [http-bio-80-exec-359] com.niku (clarity:myuser:8274053_6EFE744B-098D-41EF-B0B2-6AAF8769B642:projmgr.taskPropertiesPost)

SQL message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification
WARN 2014-03-25 11:21:55,664 [http-bio-80-exec-359] com.niku (clarity:myuser:8274053_6EFE744B-098D-41EF-B0B2-6AAF8769B642:projmgr.taskPropertiesPost)

Statement Id: omp.dynamic.select-object.map::project:NIKU.ALL:0:preagg_resource
WARN 2014-03-25 11:21:55,664 [http-bio-80-exec-359] com.niku (clarity:myuser:8274053_6EFE744B-098D-41EF-B0B2-6AAF8769B642:projmgr.taskPropertiesPost)

SQL statement: SELECT s0.id odf_pk, s0.null AS preagg_resource FROM inv_investments s0 WHERE ( s0.id=? )
WARN 2014-03-25 11:21:55,664 [http-bio-80-exec-359] com.niku (clarity:myuser:8274053_6EFE744B-098D-41EF-B0B2-6AAF8769B642:projmgr.taskPropertiesPost)

Parameter 1: 5010001
ERROR 2014-03-25 11:21:55,664 [http-bio-80-exec-359] niku.xql2 (clarity:myuser:8274053_6EFE744B-098D-41EF-B0B2-6AAF8769B642:projmgr.taskPropertiesPost)

Internal Processing exception
com.niku.union.omp.persistence.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the omp.dynamic.select-object.map::project:NIKU.ALL:0:preagg_resource-DynamicParameterMap.
--- Check the statement (query failed).
--- Cause: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01747: invalid user.table.column, table.column, or column specification

Steps to Reproduce:

  1. Login  as an administrator user
  2. Administration, Processes, click 'New' button (Name/ID = 'MyProjectProcess')
  3. Primary Object = Project, Linked Object = Resource or any other linked attribute that can be selected
    • Business Owner
    • Created By Resource 
    • Finance and Governance
    • Last Updated By Resource
    • Manager Resource
    • Project Management Office
    • Provider Department
    • Resource
  4. Start Options, Auto-start, Start Event = Update, Start Condition = 'Project Stage' = Initiation (or any other valid stage)
  5. Start Step - Then Go To 'Finish' step
  6. Validate All and Activate
  7. Home, Projects
  8. Optional: you can check Stage value, but the issue is reproduced regardless of the value meeting the BPM process auto-start condition
  9. Go to Tasks Tab, Create New or open existing Task
  10. Try to modify Task Name, click task 'Save' button
  11. Open the project in Open Workbench (OWB), and then try to save it back into Clarity - the error is also reproduced for this action

Expected Result: No Error message, save is successful.

Actual Result: System Error message, save is not successful.

Cause:

Caused by CLRT-74340

Resolution:

Resolved in CA PPM 14.1

Workaround:

Place BPM Process definition 'On Hold' or 'Draft' - do not activate a process with a linked object configuration.