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