Clarity: Demand Management: Create Incident, Click 'Submit' button, URL is incomplete and generates error

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

Description:

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:

  1. Login to Clarity

  2. The home page for this user is set to Incidents > 'Assigned to Me' page

  3. Click 'New' button

  4. 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'

  5. 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

Solution:

Workaround:
None.

Status/Resolution:
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.