Incident Object is partitioned.
Layout Create page has 2 lookup attributes; one attribute is a parameterized lookup dependent on the other lookup value.
When creating a new Incident Record, clicking submit button generates a system error on the UI:
ERROR 2011-07-19 16:26:11,629 [http-443-Processor44] niku.xql2 (admin:11991927__-6346cc51:pma.investmentIncidents) Internal Processing exception com.niku.xql2.XQLVisitorNoObjectException: No Current XQL Object
ERROR 2011-07-19 16:26:11,676 [http-443-Processor44] niku.xql2 (admin:11991927__-6346cc51:pma.investmentIncidents) Exception in processing
java.lang.Exception: Invalid expression qData: com.niku.union.persistence.PersistenceException:
SQL error code: 936
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00936: missing expression
The URL is missing part of the expression.
Steps to Reproduce:
- Login to Clarity
- The home page for this user is set to Incidents > 'Assigned to Me' page
- Click 'New' button
- Fill out the required fields
Note: custom attributes on the Create Layout that is parameterized lookups and you have to select a value for 'Agency' before you can select a value for 'Contact'
- Click 'SUBMIT' button
Expected Result: Incident is created successfully and navigation should return user to list of incidents
Actual Result: Incident is created successfully and navigation is NOT returned to list of incidents; an error message appears on the page
Resolved in Clarity 12.0.6 Generic Patch. Reference TEC522707
Resolved in Clarity 12.1.0 Generic Patch. Reference TEC542313
Resolved in Clarity 12.1.1
Keywords: CLARITYKB, CLRT-57089, clarity12resolved, clarity1211resolved.