AnsweredAssumed Answered

Error at admin content csk

Question asked by LiviuIonescu on May 23, 2017
Latest reply on May 25, 2017 by LiviuIonescu

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.

Outcomes