Clarity

Hi,

While installing the pmo accelerartor by using:

admin content csk

from the command line, the system returned to the console the next message:

Current product version: 14.4.0.234

The minimum product version(s)
that are supported: 14.4.0

Validating the current product version against
the minimum supported version: 14.4.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.4.0
package.addin.version=14.4.0.0001
force=false
Removing obj_alignment attribute...
Getting view information...
Total execution time: 0H:0M:29.658S
Content Pack csk version 0.0.0.0 has been deployed
Installing content... csk
Installing content items that do not already exist or have the force option set to true
==========================================
DBTools Log - Wed Oct 26 18:05:01 CEST 2016
==========================================
Command: install database schema from driver file
To URL: jdbc:clarity:sqlserver://WKSBCN051;DatabaseName=niku;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
As user: niku
For vendor: mssql
Loading DBDriver file: C:\Users\FVILLENA\Desktop\ppm\ppm\database\content\csk\preupgrade-driver.xml
Loading DBDriver file: C:\Users\FVILLENA\Desktop\ppm\ppm\database\content\csk\preupgrade-driver.xml
Current database version is database_csk_14.4.0.0001-preupgrade
DBDriver for database_csk_14.4.0.0001-preupgrade
DBDriver has already been installed!
Total time: 0H:0M:1S
        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
Loading registered objects for custom attribute bootstrap...
Loading registered objects for object mappings bootstrap...
Loading registered objects to bootstrap...
Loading registered objects for view bootstrap...
Loading registered objects for object action bootstrap...
Loading registered objects for data warehouse attributes bootstrap...
Loading registered objects for building blocks bootstrap...
Failed to install content pack. ID: csk: exec returned: 2
Failed to install content pack. ID: csk: exec returned: 2
Error occurred: C:\Users\FVILLENA\Desktop\ppm\ppm\META-INF\content\xog\csk\install.xml:240: exec returned: 2
Check admin.log or use -verbose for more information.

I have attached the admin.log file in the case, from this file, it seems that the contect pack with id: csk has failed.

Any help will be apprecaited.

Thanks

Regards

Francisco

Hi Francisco,

The error message you are having is the following:

26/10/16 17:33 (admin)  Applying resources/csk_roles.xml
26/10/16 17:33 (admin) Error Applying XOG: Failure occurred while applying resources/csk_roles.xml
26/10/16 17:33 (admin)  Check C:\Users\FVILLENA\Desktop\ppm\ppm\logs\content\xog\csk\resources/csk_roles_out.xml for errors
26/10/16 17:33 (admin) Failed to install content pack. ID: csk
C:\Users\FVILLENA\Desktop\ppm\ppm\META-INF\content\xog\csk\install.xml:240: exec returned: 2

Please check the file csk_roles_out.xml as per above to see what is the exact error message that failed your PMO install.

Thanks -Nika

Thanks Nika,

The csk_roles_out.xml content:

<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
  <Object type="role"/>
  <Status elapsedTime="0.372 seconds" state="FAILURE"/>
  <Statistics failureRecords="8" insertedRecords="0" totalNumberOfRecords="8" updatedRecords="0"/>
  <Records>
    <Record>
      <KeyInformation>
        <column name="full_name">Developer</column>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>This record has not been inserted</Description>
        <Exception><![CDATA[
java.sql.SQLDataException: [CA Clarity][SQLServer JDBC Driver][SQLServer]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo.
    at com.ca.clarity.jdbc.sqlserverbase.ddcw.b(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcw.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcv.b(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcv.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)

.....

.....
    at com.niku.xql2.jdbc.JDBCDataSource.execute(JDBCDataSource.java:287)
    at com.niku.xql2.handlers.ExecuteHandler.postProcess(ExecuteHandler.java:111)
    at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419)
    at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
    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.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 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>
    <Record>
      <KeyInformation>
        <column name="full_name">Project Manager</column>
      </KeyInformation>
      <ErrorInformation>
        <Severity>FATAL</Severity>
        <Description>This record has not been inserted</Description>
        <Exception><![CDATA[
java.sql.SQLDataException: [CA Clarity][SQLServer JDBC Driver][SQLServer]La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo.
    at com.ca.clarity.jdbc.sqlserverbase.ddcw.b(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcw.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcv.b(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcv.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddq.a(Unknown Source)

........
   (end of file)

some of the highlighted content is in Spanish, the line:

'La conversión del tipo de datos nvarchar en datetime produjo un valor fuera de intervalo'

could be translate into english as:

The conversion of data type nvarchar to datetime produced a value out of range.

The error seems to come from a database problem, the insert process expects a type of value
that differs from the one that is in the datamodel.

Is there any previous process that should be launched?

Any help will be appreciated

Thank you very much

Regards

Hi Francisco,

This looks to be an issue with the database settings as a value in this xml goes out of range. Please try changing the user’s language to English.

Please do the following:

1. Run this query:
alter login niku with DEFAULT_LANGUAGE = us_english
2. Restart the services
3. Retry the PMO install

Thanks -Nika