Clarity PPM1

Expand all | Collapse all

Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

Jump to Best Answer
  • 1.  Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-29-2015 01:53 PM

    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



  • 2.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-29-2015 05:38 PM

    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



  • 3.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-29-2015 06:30 PM

    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



  • 4.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-30-2015 08:51 AM

    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



  • 5.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-30-2015 02:27 PM

    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 



  • 6.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-30-2015 03:29 PM

    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.

     

     



  • 7.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 01-04-2016 11:58 AM

    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.



  • 8.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 01-04-2016 03:50 PM

    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>



  • 9.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 01-04-2016 05:24 PM

    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



  • 10.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 01-05-2016 11:58 AM

    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>



  • 11.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 01-05-2016 02:45 PM

    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

     



  • 12.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks
    Best Answer

    Posted 01-08-2016 10:55 AM

    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.



  • 13.  Re: Clarity 14.3...does anyone have this information on this lookup? :ODF_CST_COP_ADDIN_LOOKUP_MAP_PAGE_LAYOUT.  Thanks

    Posted 12-13-2016 03:38 PM

    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?