AnsweredAssumed Answered

PMO Accelerator Installation error

Question asked by johndaygo92 on Nov 7, 2015
Latest reply on Nov 16, 2015 by Chris_Hackett

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!!!

Outcomes