Clarity

Expand all | Collapse all

Error at admin content csk

Jump to Best Answer
  • 1.  Error at admin content csk

    Posted 05-23-2017 06:08 AM

    Hi,

     

    We are trying to deploy Jaspersoft on Clarity 15.2. Jaspersoft Server and Application along with Data Warehouse is installed and working, but when trying to execute the command: admin content csk we get multiple errors ( admin.log ) like:

     

    5/22/17 4:25 PM (admin) {execute::batch=false, parameterSet=[], dynamic=true, visitor=com.niku.xql2.XQLVisitor@59282dc6, parameters=[], value=alter table odf_ca_cop_idea_prj_map add parent_lookup varchar(30) null}
    5/22/17 4:25 PM (admin) Using dynamic SQL:
    5/22/17 4:25 PM (admin) tag: @dynamic@ SQL:alter table odf_ca_cop_idea_prj_map add parent_lookup varchar(30) null

    ...

    5/22/17 4:25 PM (admin) Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01430: column being added already exists in table

    ...

    5/22/17 4:32 PM (admin) com.niku.union.odf.exception.ODFRuntimeException: com.niku.union.odf.exception.ODFRuntimeException: Invalid entity code attribute defined to object cop_idea_prj_map

    or

    5/22/17 4:32 PM (admin) Caused by: com.niku.union.odf.exception.ODFRuntimeException: Invalid entity code attribute defined to object cop_idea_prj_map
    5/22/17 4:32 PM (admin) at com.niku.odf.service.object.FiscalTSVPreProcessor.verifyFiscalTSVAttributes(FiscalTSVPreProcessor.java:202)
    5/22/17 4:32 PM (admin) ... 22 more
    5/22/17 4:32 PM (admin) ERROR 2017-05-22 16:32:57,240 [main] odf.bootstrap Unable to verify fiscal TSV reference attributes on object cop_idea_prj_map
    5/22/17 4:32 PM (admin) com.niku.union.odf.exception.ODFRuntimeException: com.niku.union.odf.exception.ODFRuntimeException: Invalid entity code attribute defined to object cop_idea_prj_map

     

    or

     

    5/22/17 4:35 PM (admin) Applying projects/csk_infrastructure.xml
    5/22/17 4:35 PM (admin) Error Applying XOG: Failure occurred while applying projects/csk_infrastructure.xml
    5/22/17 4:35 PM (admin) Check /opt/niku/clarity/logs/content/xog/csk/projects/csk_infrastructure_out.xml for errors
    5/22/17 4:35 PM (admin) Failed to install content pack. ID: csk
    /opt/niku/clarity/META-INF/content/xog/csk/install.xml:240: exec returned: 2

     

     

    5/22/17 4:35 PM (admin) Failed to install content pack. ID: csk
    /opt/niku/clarity/META-INF/content/xog/csk/install.xml:240: exec returned: 2

    ...

    May 22, 2017 4:35:12 PM Error executing command: content -Dinteractive=false -Dinstall.mode=databaseonly
    /opt/niku/clarity/META-INF/content/xog/csk/install.xml:240: exec returned: 2

     

    Do you have any ideea what is causing this? 

     

    Attached is the whole admin.log file if this might help you.

     

    Also the error in csk_infrastructure_out.xml is:

     

    <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
    <Object type="project"/>
    <Status elapsedTime="5.936 seconds" state="FAILURE"/>
    <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records>
    <Record>
    <KeyInformation>
    <column name="ID">5043000</column>
    <column name="name">Infrastructure Deployment Template</column>
    <column name="UNIQUE_NAME">csk.infrastructure</column>
    </KeyInformation>
    <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>Project Object insert failed</Description>
    <Exception><![CDATA[
    java.lang.Exception: INV-0021: Planned Cost Finish date is earlier than Planned Cost Start date

    ...

    Thanks,

    Liviu

     

    Later edit: I forgot to mention that the db instance is Oracle 11g, maybe the PMO is not compatible with this version of db.

    Attachment(s)

    zip
    2nd try admin.zip   13 KB 1 version
    zip
    admin.log.zip   5 KB 1 version


  • 2.  Re: Error at admin content csk

    Posted 05-23-2017 08:10 AM

    Hi,

     

    Can you please attach the entire /opt/niku/clarity/logs/content/xog/csk/projects/csk_infrastructure_out.xml file...



  • 3.  Re: Error at admin content csk

    Posted 05-23-2017 08:14 AM

    Hi,

     

    I've attached the file on the first post.

     

    Thanks,

    Liviu



  • 4.  Re: Error at admin content csk

    Posted 05-23-2017 08:55 AM

    Hi Liviu,

     

    Can you please navigate to Home -> Projects, and check if a template with ID "csk.infrastructure", is setup properly.. In terms of Start Dates and Finish Dates etc, of the Template itself and w.r.t the Cost Plans, Team etc..



  • 5.  Re: Error at admin content csk

    Posted 05-23-2017 09:28 AM

    Hi Jeevan, 

     

    I see no template with that ID. Actually I see no OOTB template, only 1 that is custum.

     

    Thanks,

    Liviu



  • 6.  Re: Error at admin content csk

    Broadcom Employee
    Posted 05-23-2017 09:36 AM

    Hi Liviu,

     

    You will not have that template because its not created in the system yet, hence raise a case we will help you xog in manually and then install the addin

     

    Regards

    Suman Pramanik 



  • 7.  Re: Error at admin content csk

    Posted 05-25-2017 04:12 AM

    Hi Suman,

     

    I have managed to XOG manually, but now we got different kind of errors( full log is in the original post, with "second try" as name)

     

    Applying seeddata/cop_idea_prj_map.xml
    5/25/17 9:57 AM (admin) ERROR 25-05 09:57:52,596 - exception XOGging object
    5/25/17 9:57 AM (admin) java.lang.NullPointerException

     

    ...

    And many of these:

     

    5/25/17 9:57 AM (admin) ERROR 2017-05-25 09:57:52,596 [main] xbl.XOGCustomObjectInstanceHandler exception XOGging object
    5/25/17 9:57 AM (admin) java.lang.NullPointerException

     

    Also:

     

    (admin) ERROR 25-05 10:01:59,816 - Unable to verify fiscal TSV reference attributes on object cop_idea_prj_map
    5/25/17 10:01 AM (admin) com.niku.union.odf.exception.ODFRuntimeException: com.niku.union.odf.exception.ODFRuntimeException: Invalid entity code attribute defined to object cop_idea_prj_map

     

    ...

     

    May 25, 2017 10:02:28 AM Error executing command: content-deploy csk -Dreports.apply=false -Dforce=false
    java.lang.NullPointerException

     


    5/25/17 10:02 AM (admin) ERROR 25-05 10:02:28,247 - Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 2017-05-25 10:02:28,247 [main] services.ContentAddInHelper Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 25-05 10:02:28,248 - Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 2017-05-25 10:02:28,248 [main] services.ContentAddInHelper Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 25-05 10:02:28,248 - Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 2017-05-25 10:02:28,248 [main] services.ContentAddInHelper Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 25-05 10:02:28,248 - Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 2017-05-25 10:02:28,248 [main] services.ContentAddInHelper Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 25-05 10:02:28,248 - Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 2017-05-25 10:02:28,248 [main] services.ContentAddInHelper Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 25-05 10:02:28,248 - Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) ERROR 2017-05-25 10:02:28,248 [main] services.ContentAddInHelper Unable to process the dependencyDocumentNode_java.lang.NullPointerException
    5/25/17 10:02 AM (admin) Error occured while importing the contents into CMS. java.lang.NullPointerException
    5/25/17 10:02 AM (admin) Failed to install content pack: null
    5/25/17 10:02 AM (admin) Error occurred: java.lang.NullPointerException
    5/25/17 10:02 AM (admin) Check admin.log or use -verbose for more information.
    5/25/17 10:02 AM (admin) Failed to install content pack. ID: csk
    /opt/niku/clarity/META-INF/content/xog/csk/install.xml:240: exec returned: 1

     

     

    Do you have any further ideeas?

     

    Thanks,

    Liviu



  • 8.  Re: Error at admin content csk
    Best Answer

    Posted 05-25-2017 06:52 AM

    Hi,

     

    I've managed to install csk and resolve the issue. For other that have the same issue, please find the procedure used:

     

    1. Stop all services
    2. Execute SQL query "select * from cmn_install_history order by installed_date desc" and delete the existing csk entry (if any)
    3. Back up the files from the following location: <clarity_home>/META-INF/content/xog/csk
    4. Move the back up OUT of the clarity home directory path (off the system completely is preferred)
    5. Delete the csk directory from step 2
    6. Open install iso and extract install.jar to a temporary location
    7. Extract the newly obtained package.jar inside the temporary location's, <temp_loc>/install-packages/13.3.0
    8. Copy META-INF/content/xog/csk folder (from the package.jar) to step 2's location
    1. Install PMO normally (admin content csk)

     

    Thank you all for the support,

    Liviu