Clarity

Clarity 14.3...does anyone have this information on this lookup? Its part of the PMO install package and referenced in the /app/niku/clarity143/META-INF/content/xog/csk/objects/cop_addin_lookup_map.xml install folder. Lookup goes by code:ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

Hi Allen,

This lookup, as you noted is part of PMO addin package, and is used by the new PMO object:
Add-In Lookup Mapping
This object is used to map lookups as parameterized lookups. Previously we had to create our own objects for this.

The lookup you're interested in is called "Add-In Lookup Mapping Page Layouts", and it's used in attribute Page Layout on the Addin Lookup Mapping object. This lookup is not visible in Clarity UI, it's a hidden system lookup. This is the reason you cannot actually find it in Administration - Lookups list. However it's functioning, and used to populate the Page Layout data for the Addin Lookup Mapping object.

Hope this helps.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

Nika,

As part of existing ca support case the XML file referencing this lookup simply hangs. Never completes and no error, send a query to identify this lookup existing so I can check our db instance. Also where or how does this lookup get created please. Source file location please.

Many thanks

Allen Bollinger

Sent from iPhone

Nika,

Post or add to our support case ticket any sql that identifies this lookup in the database. Also if you can, please identify the xml file (or other) that actually creates this internal lookup value. This will help our case ticket.

Thanks,

Allen

Hi Allen,

Here is the query you can use:

select * from cmn_lookup_types

where lookup_type ='ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT'

You will see the lookup is not admin visible, that's why it's not showing in UI.

All Page Layout attributes/lookups get generated automatically by the application when the custom object gets created. So there is no xml file that will contain this lookup specifically. It should get created when the object $clarity\META-INF\content\xog\csk\objects\cop_addin_lookup_map.xml gets inserted.

Concerning your PMO install hanging issue : I checked the Support case and I would recommend you to see if everything accessing the Clarity database is stopped at the time of the install. We have seen cases in which this was an issue. Anything such as BO Reporting, Jaspersoft, and other services should be stopped.

Also, how much time does it stay stuck? Have you tried letting it for a couple of hours to see if it goes through? Do you have any other environments on which this has worked? I could not see that information in the case.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer 

Nika,

Thanks for the query. As I guessed, the query returned NO DATA.

When running admin content csk command from the server, with all services stopped, in the output file that gets created as follows:

/app/niku/clarity143/logs/content/xog/csk/objects/cop_addin_lookup_map_out.xml.

This is the file contents.

1/4/2016 Update:

1. DBA killed off 6 active sessions on database, all were running below query: Note: Parameters not captured here.

  update odf_views

  set code = :v0

  ,view_type = :v1

  ,view_subtype= :v2

  ,principal_type = :v3

  ,principal_id = :v4

  ,data_service = :v5

  ,data_service_type = :v6

  ,object_code = :v7

  ,caption = :v8 ,is_customized = :v9 ,is_secure = :v10 where id = :v11

2. All Clarity services STOPPED.

3. Restarted PMO install using command: admin content csk at 10:15 am EST

4. Ran below query:

  select * from cmn_lookup_types

  where lookup_type ='ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT'; Note: output attached to case as excel sheet. Query CMN_LOOKUP_TYPES export.xlsx

5. From console:

Niku Beacon [beacon] is not running.

Niku Server [app] is not running.

Niku System Admin Server [nsa] is not running.

Niku Background Server [bg] is not running.

[nikuapp@******]$ admin content csk

Current product version: 14.3.0.298

The minimum product version(s)

that are supported: 14.3.0

Validating the current product version against

the minimum supported version: 14.3.0

The product version has been validated as supported

Installation properties for CA PPM Accelerator: Program Management Office

ID: csk

reports.apply=false

package.addin.release=14.3.0

package.addin.version=14.3.0.0001

force=false

Removing obj_alignment attribute...

Getting view information...

Total execution time: 0H:0M:56.980S

Content Pack csk version 8.1.0.03.4373 has been deployed

Installing content... csk

Installing content items that do not already exist or have the force option set to true

==========================================

DBTools Log - Mon Jan 04 10:14:08 EST 2016

==========================================

Command: install database schema from driver file

To URL: jdbc:clarity:oracle://*********************

As user: ******

For vendor: oracle

Loading DBDriver file: /app/niku/clarity143/database/content/csk/preupgrade-driver.xml

Loading DBDriver file: /app/niku/clarity143/database/content/csk/preupgrade-driver.xml

Current database version is database_csk_14.3.0.0001-preupgrade

DBDriver for database_csk_14.3.0.0001-preupgrade

DBDriver has already been installed!

Total time: 0H:0M:5S

  Applying lookups/COP_ADD_IN_LOOKUP_MAPPING_PARAM.xml

  Applying lookups/COP_ADD_IN_LOOKUP_MAPPING_PARENT_PARAM.xml

  Applying lookups/COP_ADD_IN_LOOKUP_MAPPING_CHILD_PARAM.xml

  Applying objects/cop_idea_prj_map.xml

  Applying objects/cop_addin_lookup_map.xml

  Applying objects/cop_prj_statusrpt.xml

  Applying lookups/OBJ_IDEA_PROJECT_CATEGORY_PARAM.xml

  Applying objects/inv.xml

  Applying objects/project.xml

  Applying objects/idea.xml

  Applying objects/task.xml

  Applying objects/benefitplandetail.xml

  Applying objects/glallocation.xml

  Applying objects/resourcecredit.xml

  Applying objects/risk.xml

  Applying objects/pfm_investment.xml

  Applying objects/pfm_portfolio.xml

  Applying views/cop_addin_lookup_map.xml

6. From SQL Developer connection to database, ran this query:

  select * from odf_views order by CREATED_DATE desc; Output attached to case as excel file PMO ODF_VIEWS export.xlsx

Will allow pmo install to run for several hours to see if completes.

DBA determined a session was blocked update odf_views command. Killed the session. Now the PMO install generates error message output file.

<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="contentPack"/>
  <Status elapsedTime="4.139 seconds" state="FAILURE"/>
  <Statistics failureRecords="1" insertedRecords="1" totalNumberOfRecords="3" updatedRecords="2"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="externalSource">NIKU</column>
        <column name="source"/>
        <column name="code"/>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>XOG-3350: Custom view record has not been inserted java.lang.Exception: Invalid expression insertMasterView: com.niku.union.persistence.PersistenceException:
SQL error code: 1400
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")

Executed:
INSERT INTO ODF_VIEWS
        (id, code, view_type, view_subtype, principal_type, principal_id,
        data_service, data_service_type, object_code, caption, sequence,
        obs_table_name_key, is_system, partition_code, is_customized,
        link_code,
        is_secure,
        created_date, created_by, last_updated_date, last_updated_by
        )
        VALUES
        (?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?,
        ?, ?, ?, ?,
        ?,
        ?,
        ?, ?, ?, ?
        )
Derived from statement:
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;statement location="view/property.xml" id="odf.insertPropertyView" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd"&gt;
  &lt;errorMapping applicationCode="odf.valueToLarge"&gt;
    &lt;dbError dbCode="1401" dbVendor="oracle"/&gt;
    &lt;dbError dbCode="8152" dbVendor="mssql"/&gt;
  &lt;/errorMapping&gt;
  &lt;sql dbVendor="all"&gt;
    &lt;text&gt;
        INSERT INTO ODF_VIEWS
        (id, code, view_type, view_subtype, principal_type, principal_id,
        data_service, data_service_type, object_code, caption, sequence,
        obs_table_name_key, is_system, partition_code, is_customized,
        link_code,
        is_secure,
        created_date, created_by, last_updated_date, last_updated_by
        )
        VALUES
        (?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?,
        ?, ?, ?, ?,
        ?,
        ?,
        ?, ?, ?, ?
        )
      &lt;/text&gt;
    &lt;param name="ID" direction="IN" expressionListDelimiter="," tableName="ODF_VIEWS" sequenceType="nextValue"/&gt;
    &lt;param name="viewName" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="type" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="view_subtype" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="p_type" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="p_id" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="dataService" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="dataServiceType" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="objectName" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="caption" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="sequence" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="obsTableNameKey" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="is_system" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param name="partitionCode" type="string" direction="IN" defaultValue="NIKU.ROOT" expressionListDelimiter=","/&gt;
    &lt;param name="is_customized" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param name="linkCode" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="is_secure" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param replace="timestamp" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="userId" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="timestamp" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="userId" direction="IN" expressionListDelimiter=","/&gt;
  &lt;/sql&gt;
  &lt;outputMapping rowElementName="view"/&gt;
&lt;/statement&gt;

Referenced by:
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;statementRef id="odf.insertPropertyView" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/&gt;

Using input:
{is_system=0, viewName=, partitionCode=NIKU.ROOT, view_subtype=master, p_type=ADMINISTRATOR, objectName=cop_addin_lookup_map, caption=xogExport, is_customized=1, type=property} sequences[ODF_VIEWS: 5668001]

at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1134)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1060)
at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:59)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:263)
at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:170)
at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:198)
at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:1176)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:912)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:675)
at com.niku.xog.client.XOGAdminClient.execute(XOGAdminClient.java:532)
at com.niku.xog.client.XOGAdminClient.main(XOGAdminClient.java:260)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.niku.nsa.service.AdminManager.runExecutable(AdminManager.java:2160)
at com.niku.nsa.service.AdminManager.doXogContent(AdminManager.java:3555)
at com.niku.nsa.service.AdminManager.xogContent(AdminManager.java:2129)
at com.niku.nsa.service.AdminManager.processXOGDriver(AdminManager.java:2026)
at com.niku.nsa.service.AdminManager.installContent(AdminManager.java:1867)
at com.niku.nsa.service.AdminManager.doContentDeploy(AdminManager.java:1163)
at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:341)
at com.niku.nsa.service.AdminManager.execute(AdminManager.java:188)
at com.niku.nsa.service.Admin.main(Admin.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
Caused by: java.lang.RuntimeException: com.niku.union.persistence.PersistenceException:
SQL error code: 1400
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")

Executed:
INSERT INTO ODF_VIEWS
        (id, code, view_type, view_subtype, principal_type, principal_id,
        data_service, data_service_type, object_code, caption, sequence,
        obs_table_name_key, is_system, partition_code, is_customized,
        link_code,
        is_secure,
        created_date, created_by, last_updated_date, last_updated_by
        )
        VALUES
        (?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?,
        ?, ?, ?, ?,
        ?,
        ?,
        ?, ?, ?, ?
        )
Derived from statement:
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;statement location="view/property.xml" id="odf.insertPropertyView" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd"&gt;
  &lt;errorMapping applicationCode="odf.valueToLarge"&gt;
    &lt;dbError dbCode="1401" dbVendor="oracle"/&gt;
    &lt;dbError dbCode="8152" dbVendor="mssql"/&gt;
  &lt;/errorMapping&gt;
  &lt;sql dbVendor="all"&gt;
    &lt;text&gt;
        INSERT INTO ODF_VIEWS
        (id, code, view_type, view_subtype, principal_type, principal_id,
        data_service, data_service_type, object_code, caption, sequence,
        obs_table_name_key, is_system, partition_code, is_customized,
        link_code,
        is_secure,
        created_date, created_by, last_updated_date, last_updated_by
        )
        VALUES
        (?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?,
        ?, ?, ?, ?,
        ?,
        ?,
        ?, ?, ?, ?
        )
      &lt;/text&gt;
    &lt;param name="ID" direction="IN" expressionListDelimiter="," tableName="ODF_VIEWS" sequenceType="nextValue"/&gt;
    &lt;param name="viewName" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="type" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="view_subtype" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="p_type" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="p_id" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="dataService" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="dataServiceType" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="objectName" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="caption" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="sequence" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="obsTableNameKey" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="is_system" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param name="partitionCode" type="string" direction="IN" defaultValue="NIKU.ROOT" expressionListDelimiter=","/&gt;
    &lt;param name="is_customized" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param name="linkCode" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="is_secure" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param replace="timestamp" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="userId" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="timestamp" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="userId" direction="IN" expressionListDelimiter=","/&gt;
  &lt;/sql&gt;
  &lt;outputMapping rowElementName="view"/&gt;
&lt;/statement&gt;

Referenced by:
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;statementRef id="odf.insertPropertyView" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/&gt;

Using input:
{is_system=0, viewName=, partitionCode=NIKU.ROOT, view_subtype=master, p_type=ADMINISTRATOR, objectName=cop_addin_lookup_map, caption=xogExport, is_customized=1, type=property} sequences[ODF_VIEWS: 5668001]

at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:877)
at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1480)
at com.niku.xql2.eval.XQLPropertyNode.eval(XQLPropertyNode.java:92)
at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1086)
... 69 more
Caused by: com.niku.union.persistence.PersistenceException:
SQL error code: 1400
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")

Executed:
INSERT INTO ODF_VIEWS
        (id, code, view_type, view_subtype, principal_type, principal_id,
        data_service, data_service_type, object_code, caption, sequence,
        obs_table_name_key, is_system, partition_code, is_customized,
        link_code,
        is_secure,
        created_date, created_by, last_updated_date, last_updated_by
        )
        VALUES
        (?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?,
        ?, ?, ?, ?,
        ?,
        ?,
        ?, ?, ?, ?
        )
Derived from statement:
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;statement location="view/property.xml" id="odf.insertPropertyView" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd"&gt;
  &lt;errorMapping applicationCode="odf.valueToLarge"&gt;
    &lt;dbError dbCode="1401" dbVendor="oracle"/&gt;
    &lt;dbError dbCode="8152" dbVendor="mssql"/&gt;
  &lt;/errorMapping&gt;
  &lt;sql dbVendor="all"&gt;
    &lt;text&gt;
        INSERT INTO ODF_VIEWS
        (id, code, view_type, view_subtype, principal_type, principal_id,
        data_service, data_service_type, object_code, caption, sequence,
        obs_table_name_key, is_system, partition_code, is_customized,
        link_code,
        is_secure,
        created_date, created_by, last_updated_date, last_updated_by
        )
        VALUES
        (?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?,
        ?, ?, ?, ?,
        ?,
        ?,
        ?, ?, ?, ?
        )
      &lt;/text&gt;
    &lt;param name="ID" direction="IN" expressionListDelimiter="," tableName="ODF_VIEWS" sequenceType="nextValue"/&gt;
    &lt;param name="viewName" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="type" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="view_subtype" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="p_type" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="p_id" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="dataService" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="dataServiceType" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="objectName" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="caption" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="sequence" type="int" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="obsTableNameKey" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="is_system" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param name="partitionCode" type="string" direction="IN" defaultValue="NIKU.ROOT" expressionListDelimiter=","/&gt;
    &lt;param name="is_customized" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param name="linkCode" type="string" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param name="is_secure" type="int" direction="IN" defaultValue="0" expressionListDelimiter=","/&gt;
    &lt;param replace="timestamp" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="userId" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="timestamp" direction="IN" expressionListDelimiter=","/&gt;
    &lt;param replace="userId" direction="IN" expressionListDelimiter=","/&gt;
  &lt;/sql&gt;
  &lt;outputMapping rowElementName="view"/&gt;
&lt;/statement&gt;

Referenced by:
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;statementRef id="odf.insertPropertyView" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/&gt;

Using input:
{is_system=0, viewName=, partitionCode=NIKU.ROOT, view_subtype=master, p_type=ADMINISTRATOR, objectName=cop_addin_lookup_map, caption=xogExport, is_customized=1, type=property} sequences[ODF_VIEWS: 5668001]

at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2085)
at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2189)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2823)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
at com.niku.xql2.pmd.PMDRecordSet.executePMDStatement(PMDRecordSet.java:267)
at com.niku.xql2.pmd.PMDRecordSet.&lt;init&gt;(PMDRecordSet.java:87)
at com.niku.xql2.pmd.PMDDataSource.select(PMDDataSource.java:94)
at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:868)
... 73 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")

at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dde3.x(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dde3.t(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dddz.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$8642127f.execute(&lt;generated&gt;)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2785)
... 81 more</Description>
        <Exception><![CDATA[
java.sql.SQLIntegrityConstraintViolationException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01400: cannot insert NULL into ("NIKU"."ODF_VIEWS"."CODE")

at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.ddam.t(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dde3.x(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dde3.t(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.dddz.execute(Unknown Source)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)
at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$8642127f.execute(<generated>)
at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2785)
at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
at com.niku.xql2.pmd.PMDRecordSet.executePMDStatement(PMDRecordSet.java:267)
at com.niku.xql2.pmd.PMDRecordSet.<init>(PMDRecordSet.java:87)
at com.niku.xql2.pmd.PMDDataSource.select(PMDDataSource.java:94)
at com.niku.xql2.XQLVisitor.getObjectSet(XQLVisitor.java:868)
at com.niku.xql2.XQLVisitor.getField(XQLVisitor.java:1480)
at com.niku.xql2.eval.XQLPropertyNode.eval(XQLPropertyNode.java:92)
at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1086)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1060)
at com.niku.xql2.handlers.MatchHandler.preProcess(MatchHandler.java:59)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:263)
at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:170)
at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:198)
at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:1176)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:912)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:675)
at com.niku.xog.client.XOGAdminClient.execute(XOGAdminClient.java:532)
at com.niku.xog.client.XOGAdminClient.main(XOGAdminClient.java:260)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.niku.nsa.service.AdminManager.runExecutable(AdminManager.java:2160)
at com.niku.nsa.service.AdminManager.doXogContent(AdminManager.java:3555)
at com.niku.nsa.service.AdminManager.xogContent(AdminManager.java:2129)
at com.niku.nsa.service.AdminManager.processXOGDriver(AdminManager.java:2026)
at com.niku.nsa.service.AdminManager.installContent(AdminManager.java:1867)
at com.niku.nsa.service.AdminManager.doContentDeploy(AdminManager.java:1163)
at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:341)
at com.niku.nsa.service.AdminManager.execute(AdminManager.java:188)
at com.niku.nsa.service.Admin.main(Admin.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
]]></Exception>
      </ErrorInformation>
    </Record>
  </Records>
</XOGOutput>

Hi Allen,

Thanks for letting us know. It looks the view code it's trying to insert is null, and in the parameter it is null too. I am not sure why this happened, possibly killing one of the sessions that might have impacted the result. Please could you try the following and see if it helps:

1. Restart all Clarity services (start and stop them again)
2. Ensure all other services accessing the Clarity database such as Business Objects/Jaspersoft reporting or similar are stopped too. This is very important
3. Check with the DBA that ODF_VIEWS table is not being accessed
4. Run the install PMO command as follows:
admin content csk -verbose

Please let me know how it goes.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

Nika,

Your suggestion did not work. Same error as before.

We also tried to run the /app/niku/clarity143/META-INF/content/xog/csk/views/cop_addin_lookup_map.xml manually with the xog 14.3 client installed locally. Same error on inserting null.

Need more assistance here please.

Thanks,

Allen Bollinger

Sr. Developer | Corporate Systems and Emerging Businesses (CSEB) Technology

TIAA-CREF | Financial Services

1000 Louis Rose Place - LROS01-525HZ

Charlotte, NC 28262

Office: 704.988.1213

Cell:    704.816.0008

Email: ebollinger@tiaa-cref.org<mailto:ebollinger@tiaa-cref.org>

Hi Allen,

Thanks for letting me know.

I just tested the same XOG import on 14.3 and had no issues. It sounds like for you a prior query is misreading the results in the database and passing a null result through. Wherever the name/code is being read from, appears to be returning no result or nulls. To identify the root cause for the issue we will need to get some more tracing.

I'll send you the instructions on the Support case.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

Community update: Due to multiple database session connections after completing our 14.3 upgrade, the PMO install did not complete due to table locks on on earlier sessions. Restoring our database back to upgraded 14.3 version, and clearing out all database sessions allowed us to successfully install the PMO package.

I know this thread is almost a year old, but we are having the same issue during the upgrade from 13.3 to 14.4, and CA Support referenced this article.  After restoring to a pre-CSK point, stopping services and re-running the command, we've been sitting at "Applying objects/cop_addin_lookup_map.xml" for over an hour.  I haven't been able to get a feel for how long this command might take.  Is there any recommendation for how long I should let this sit before opening another case with CA?