Hello,
I am upgrading our PPM version 15.4 to 15.7.0.202 it is sucessfully upgraded. I have upgraded too our database into a new server SQL 2016 as required. But I am having this error when I tried to install the addin csk it failed with this error :
02.04.20 16:11 (admin) Error Applying XOG: Failure occurred while applying lookups/CSK_RPT_ALL_DYNAMIC_LOOKUPS.xml
02.04.20 16:11 (admin) Check C:\Clarity\logs\content\xog\csk\lookups/CSK_RPT_ALL_DYNAMIC_LOOKUPS_out.xml for errors
02.04.20 16:11 (admin) Failed to install content pack. ID: csk
C:\Clarity\META-INF\content\xog\csk\install.xml:242: exec returned: 2
at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:643)
at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:669)
at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java:495)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:219)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:132)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)
at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:224)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:132)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:219)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:435)
at org.apache.tools.ant.Target.performTasks(Target.java:456)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
at com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:123)
at com.niku.nsa.service.AntUtil.executeAntScript(AntUtil.java:81)
at com.niku.nsa.service.AdminManager.doInternContent(AdminManager.java:2424)
at com.niku.nsa.service.AdminManager.doInternContent(AdminManager.java:2363)
at com.niku.nsa.service.AdminManager.doInternAddinContent(AdminManager.java:2282)
at com.niku.nsa.service.AdminManager.doContent(AdminManager.java:2254)
at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:423)
at com.niku.nsa.service.AdminManager.execute(AdminManager.java:207)
at com.niku.nsa.service.Admin.main(Admin.java:78)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
I did check the csk_rpt_all_dynamic_lookups file and belew the error messages :
<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Object type="contentPack"/>
<Status elapsedTime="12.529 seconds" state="FAILURE"/>
<Statistics failureRecords="5" insertedRecords="-5" totalNumberOfRecords="52" updatedRecords="52"/>
<Records>
<Record>
<KeyInformation>
<column name="code">CSK_RPT_INVESTMENT</column>
</KeyInformation>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description>com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'DWH_SEC_INV_OBS_PARTIAL_MV'.
SQL Text:
SELECT i.investment_key investment_key,
i.investment_id investment_id,
i.investment_name investment_name
FROM dwh_inv_investment i
INNER JOIN dwh_inv_project p ON i.investment_key = p.investment_key
WHERE i.is_template = 0
AND (EXISTS (SELECT 1
FROM dwh_inv_security_v
WHERE user_uid = ?
AND investment_type_key = i.investment_type_key
AND investment_key = i.investment_key))
AND 1=? and 1=1 and 2 = 2 
at com.niku.union.persistence.nsql.NSQLQuery.retrieveMetaData(NSQLQuery.java:992)
at com.niku.union.persistence.nsql.NSQLQuery.initialize(NSQLQuery.java:288)
at com.niku.union.persistence.nsql.NSQLQuery.setNSQL(NSQLQuery.java:792)
at com.niku.union.persistence.nsql.NSQLQuery.<init>(NSQLQuery.java:328)
at com.niku.union.persistence.nsql.NSQLController.getQueryForUpdate(NSQLController.java:140)
at com.niku.odf.ori.dal.NsqlPersistenceService.updateNsql(NsqlPersistenceService.java:523)
at com.niku.odf.ori.dal.NsqlPersistenceService.updateNsql(NsqlPersistenceService.java:481)
at com.niku.odf.ori.service.DynamicLookupService.updateNsql(DynamicLookupService.java:213)
at com.niku.odf.ori.OdfEngine.importDynamicLookup(OdfEngine.java:2172)
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.updateDynamicLookup(LookupsXogImportHandler.java:350)
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.updateLookup(LookupsXogImportHandler.java:311)
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.processXogRequest(LookupsXogImportHandler.java:164)
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.postProcess(LookupsXogImportHandler.java:106)
at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1418)
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:1384)
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:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1384)
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:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1384)
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:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1384)
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:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1384)
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:1384)
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:261)
at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:168)
at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:180)
at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:1189)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:920)
at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:683)
at com.niku.xog.client.XOGAdminClient.execute(XOGAdminClient.java:538)
at com.niku.xog.client.XOGAdminClient.main(XOGAdminClient.java:265)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.niku.nsa.service.AdminManager.runExecutable(AdminManager.java:2924)
at com.niku.nsa.service.AdminManager.doXogContent(AdminManager.java:4304)
at com.niku.nsa.service.AdminManager.xogContent(AdminManager.java:2893)
at com.niku.nsa.service.AdminManager.processXOGDriver(AdminManager.java:2815)
at com.niku.nsa.service.AdminManager.installContent(AdminManager.java:2583)
at com.niku.nsa.service.AdminManager.doContentDeploy(AdminManager.java:1839)
at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:412)
at com.niku.nsa.service.AdminManager.execute(AdminManager.java:207)
at com.niku.nsa.service.Admin.main(Admin.java:78)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.werken.forehead.Forehead.run(Forehead.java:551)
at com.werken.forehead.Forehead.main(Forehead.java:581)
</Description>
</ErrorInformation>
</Record>
<Record>
<KeyInformation>
<column name="code">CSK_RPT_PRODUCT_APP</column>
</KeyInformation>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description>com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'DWH_SEC_INV_OBS_PARTIAL_MV'.
SQL Text:
SELECT i.investment_key investment_key,
i.investment_id investment_id,
i.investment_name investment_name
FROM dwh_inv_security_v s
INNER JOIN dwh_inv_investment i ON s.investment_key = i.investment_key
AND i.is_template = 0
INNER JOIN dwh_inv_project p ON s.investment_key = p.investment_key
AND p.is_program = 0
Any help or suggestion to resolve this issue will be appreciated.
Many thanks in advance.
Karim