Clarity

 View Only
  • 1.  PMO Accelerator Installation error

    Posted Nov 06, 2015 07:38 PM

    Hello,

     

    Run the PMO Accelerator Installation After you install and configure CA PPM 14.2 On Premise, and a mistake came after several minutes of installation.

     

    The mistake came as attached below:

     

    error_pmo.png

    For more detail of what went on command prompt:

     

            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:260)

     

     

            at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)

            at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:

    198)

            at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:117

    5)

            at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminCli

    ent.java:911)

            at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminCli

    ent.java:674)

            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:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.niku.nsa.service.AdminManager.runExecutable(AdminManager.java:196

    2)

            at com.niku.nsa.service.AdminManager.doXogContent(AdminManager.java:3118

    )

            at com.niku.nsa.service.AdminManager.xogContent(AdminManager.java:1931)

            at com.niku.nsa.service.AdminManager.processXOGDriver(AdminManager.java:

    1828)

            at com.niku.nsa.service.AdminManager.installContent(AdminManager.java:16

    69)

            at com.niku.nsa.service.AdminManager.doContentDeploy(AdminManager.java:9

    65)

            at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:312)

     

     

            at com.niku.nsa.service.AdminManager.execute(AdminManager.java:187)

            at com.niku.nsa.service.Admin.main(Admin.java:77)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

    java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.werken.forehead.Forehead.run(Forehead.java:551)

            at com.werken.forehead.Forehead.main(Forehead.java:581)

    Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]

    The user does not have permission to perform this action.

            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)

            at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)

            at com.ca.clarity.jdbc.sqlserver.dda3.m(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.e(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.a(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.ddd2.a(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.v(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.r(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.ddd2.execute(Unknown Source)

            at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:

    68)

            at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$1a08

    5272.execute(<generated>)

            at com.niku.union.persistence.PersistenceController.processSql(Persisten

    ceController.java:2780)

            ... 82 more

    ERROR 2015-11-06 18:15:53,248 [main] niku.xql2 Database Error thrown

    com.niku.union.persistence.PersistenceException:

    SQL error code: 297

    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The user does not h

    ave permission to perform this action.

    Executed:

    delete  prj_obs_associations

              where   id in

                        (select   poa.id

                         from     prj_obs_associations poa WITH (READUNCOMMITTED), p

    rj_obs_units u WITH (READUNCOMMITTED), entity e WITH (READUNCOMMITTED)

                         where    poa.record_id = ?

                         and      poa.table_name = ?

                         and      poa.unit_id = u.id

                         and      u.type_id = e.org_chart_obs_type_id)

    Derived from statement:

    <?xml version="1.0" encoding="UTF-8"?>

    <statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath=

    "/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceI

    nfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSo

    urce="map" xmlns="http://schemas.niku.com/2002/pmd">

      <sql dbVendor="all">

        <text>

              delete  prj_obs_associations

              where   id in

                        (select   poa.id

                         from     prj_obs_associations poa @READUNCOMMITTED@, prj_ob

    s_units u @READUNCOMMITTED@, entity e @READUNCOMMITTED@

                         where    poa.record_id = ?

                         and      poa.table_name = ?

                         and      poa.unit_id = u.id

                         and      u.type_id = e.org_chart_obs_type_id)

            </text>

        <param name="record_id" type="long" direction="IN" expressionListDelimiter="

    ,"/>

        <param name="table_name" type="string" direction="IN" expressionListDelimite

    r=","/>

      </sql>

    </statement>

    Referenced by:

    <?xml version="1.0" encoding="UTF-8"?>

    <statementRef id="nmc.obsDeleteEntityAssocs_nested_0" inputSource="map" inputMap

    Index="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="

    /data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceIn

    fo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultS

    liceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas

    .niku.com/2002/pmd"/>

    Using input:

    {table_name=CMN_PORTLETS, value=nmc.obsDeleteEntityAssocs, parameters=[null:reco

    rd_id:5017034:, null:table_name:CMN_PORTLETS:], parameterSet=[], visitor=com.nik

    u.xql2.XQLVisitor@4d4dcbc1, record_id=5017034}

            at com.niku.union.persistence.PersistenceController.createException(Pers

    istenceController.java:2084)

            at com.niku.union.persistence.PersistenceController.handleSQLException(P

    ersistenceController.java:2188)

            at com.niku.union.persistence.PersistenceController.processSql(Persisten

    ceController.java:2818)

            at com.niku.union.persistence.PersistenceController.processStatement(Per

    sistenceController.java:867)

            at com.niku.union.persistence.PersistenceController.processStatements(Pe

    rsistenceController.java:767)

            at com.niku.union.persistence.PersistenceController.doProcessRequest(Per

    sistenceController.java:575)

            at com.niku.union.persistence.PersistenceController.processRequest(Persi

    stenceController.java:305)

            at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:204)

            at com.niku.xql2.handlers.ExecuteHandler.postProcess(ExecuteHandler.java

    :90)

            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.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.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.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:260)

     

     

            at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)

            at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:

    198)

            at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:117

    5)

            at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminCli

    ent.java:911)

            at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminCli

    ent.java:674)

            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:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.niku.nsa.service.AdminManager.runExecutable(AdminManager.java:196

    2)

            at com.niku.nsa.service.AdminManager.doXogContent(AdminManager.java:3118

    )

            at com.niku.nsa.service.AdminManager.xogContent(AdminManager.java:1931)

            at com.niku.nsa.service.AdminManager.processXOGDriver(AdminManager.java:

    1828)

            at com.niku.nsa.service.AdminManager.installContent(AdminManager.java:16

    69)

            at com.niku.nsa.service.AdminManager.doContentDeploy(AdminManager.java:9

    65)

            at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:312)

     

     

            at com.niku.nsa.service.AdminManager.execute(AdminManager.java:187)

            at com.niku.nsa.service.Admin.main(Admin.java:77)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

    java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.werken.forehead.Forehead.run(Forehead.java:551)

            at com.werken.forehead.Forehead.main(Forehead.java:581)

    Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]

    The user does not have permission to perform this action.

            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)

            at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)

            at com.ca.clarity.jdbc.sqlserver.dda3.m(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.e(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.a(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.ddd2.a(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.v(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.dde7.r(Unknown Source)

            at com.ca.clarity.jdbc.sqlserverbase.ddd2.execute(Unknown Source)

            at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:

    68)

            at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$1a08

    5272.execute(<generated>)

            at com.niku.union.persistence.PersistenceController.processSql(Persisten

    ceController.java:2780)

            ... 82 more

    Error Applying XOG: Failure occurred while applying portlets/cop_invTimesheetNot

    esLinkable.xml

    Check C:\niku\clarity\logs\content\xog\csk\portlets/cop_invTimesheetNotesLinkab

    le_out.xml for errors

    Failed to install content pack. ID: csk: exec returned: 2

    Failed to install content pack. ID: csk: exec returned: 2

    Error occurred: C:\niku\clarity\META-INF\content\xog\csk\install.xml:240: exec r

    eturned: 2

    Check admin.log or use -verbose for more information.

     

    C:\niku\clarity\bin>

     

    Deputy full installation file, and error log files.

     

    Please help!!!

    Attachment(s)



  • 2.  Re: PMO Accelerator Installation error

    Broadcom Employee
    Posted Nov 09, 2015 01:50 PM

    Hi John,


    Your actual error will be contained in cop_invTimesheetNotesLinkable_out.xml, which for you is situated here:
    C:\niku\clarity\logs\content\xog\csk\portlets/cop_invTimesheetNotesLinkable_out.xml


    Please could you upload this file for review?

    The other xml files, such as install.xml or cop_invTimesheetNotesLinkable.xml, are the same for all Clarity installations, so they will not represent a value when looking for the root cause of the error.

    Looking forward to hearing from you.


    Kind Regards

     

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer



  • 3.  Re: PMO Accelerator Installation error

     
    Posted Nov 16, 2015 02:48 PM

    Hi Juan- Did Nika's response help you resolve your issue? If so please mark as Correct Answer. Thanks! Chris