Clarity

 View Only
Expand all | Collapse all

Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

  • 1.  Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Posted Apr 02, 2020 12:02 PM
    ​Hello,
    I have upraded from 15. 4 to 15.7.0.2020, all steps were sucessful exept this one from 15.7.0.202 to 15.7.1.272.
    Our database is SQL server 2016 as requested. This is the error that caused the fail of the installation:

    2 avr. 2020 à 17:45:47 Error executing command: db upgrade -Dfail.on.errors=true -Dxdm.apply=true -Dupgrade.phase=upgrade
    C:\Clarity\.setup\scripts\db.xml:2155: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2241: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2294: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2370: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2683: ERROR: Upgrade failed.  Please review the upgrade logs for details.
     at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:568)
     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:443)
     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.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 org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
     at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
     at com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:119)
     at com.niku.nsa.service.AntUtil.executeAntScript(AntUtil.java:81)
     at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:619)
     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)
    Caused by: C:\Clarity\.setup\scripts\db.xml:2241: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2294: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2370: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2683: ERROR: Upgrade failed.  Please review the upgrade logs for details.
     at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:568)
     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:443)
     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)
     ... 24 more
    Caused by: C:\Clarity\.setup\scripts\db.xml:2294: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2370: The following error occurred while executing this line:
    C:\Clarity\.setup\scripts\db.xml:2683: ERROR: Upgrade failed.  Please review the upgrade logs for details.
     at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:568)
     at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:443)
     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.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)
     ... 51 more

    Any help or suggestion to resolve this will be appreciated.

    Many thanks in advance.

    Karim


  • 2.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Broadcom Employee
    Posted Apr 02, 2020 12:15 PM
    Hi Karim Can we see the full install.log please?


  • 3.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Posted Apr 02, 2020 12:29 PM
    ​Hi Nika,
    Thank you again for your help.
    I could not upload the install log file in here. below some screenshot of it:
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Clarity Home Directory [C:\Clarity] :
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (SetupUtil) You chose the following:
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) install.dir = C:\Clarity
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (Expand) Expanding: C:\Temp\thirdparty.libs.15.7.1.jar into C:\Temp\tplibsdir
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (ReleaseUtilityTask) Current version: 15.7.0.212
    4/02/20 5:41 PM (ReleaseUtilityTask) Upgrading to:    15.7.1.270

    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "_dbBackupCheck" started.
    4/02/20 5:41 PM (Echo)   CA PPM upgrade from 15.7.0 to 15.7.1 detected.
    4/02/20 5:41 PM (Echo)    
    4/02/20 5:41 PM (Target) Target "_dbBackupCheck" finished.
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "_upgrade" started.
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo)            
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo) ATTENTION:
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo) This program will upgrade your existing installation to 15.7.1.270:
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo) Before proceeding, please make sure to do the following:
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo) - For upgrades or patch: Read the upgrade section in the
    4/02/20 5:41 PM (Echo)   installation guide thoroughly.
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo) - Review your process for restoring any of your
    4/02/20 5:41 PM (Echo)   customizations.
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo) - Make sure to perform this upgrade or patch first on a test
    4/02/20 5:41 PM (Echo)   environment with a replication of your production
    4/02/20 5:41 PM (Echo)   data and customizations.
    4/02/20 5:41 PM (Echo)        
    4/02/20 5:41 PM (Echo)          
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo)            
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo)         
    4/02/20 5:41 PM (Echo)          
    4/02/20 5:41 PM (ReadLine)
    4/02/20 5:41 PM (ReadLine) Type 'y' to proceed :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Clarity Upgrade Target Install Directory [C:\Clarity] :
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (SetupUtil) You chose the following:
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) install.target.dir = C:\Clarity
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "_proceed-upgrade" started.
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo)      
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo) Release List for upgrade: 15.7.1
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo)    
    4/02/20 5:41 PM (Echo)    
    4/02/20 5:41 PM (CallTarget) Task "antcall" started.
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "_process-release-setup-props" started.
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "_version_prep_props_only" started.
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo)      
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo)  processing properties for release: 15.7.1
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo)  
    4/02/20 5:41 PM (Echo)    
    4/02/20 5:41 PM (Project) Trying to override old definition of task versionCompare
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "_install" started.
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) J2SDK 11 Home Directory [C:\Java\jdk-11.0.4+11] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Beacon Multicast Address [230.0.0.1] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Beacon Multicast Port [9090] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Beacon Client Port [9091] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Install Clarity System Administrator Application (CSA)? [true] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Tomcat 8 Home Directory [C:\Tomcat] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) CSA Web Port [8090] :
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (SetupUtil) You chose the following:
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) java_home             = C:\Java\jdk-11.0.4+11
    4/02/20 5:41 PM (SetupUtil) nsa.multicast.address = 230.0.0.1
    4/02/20 5:41 PM (SetupUtil) nsa.multicast.port    = 9090
    4/02/20 5:41 PM (SetupUtil) nsa.client.port       = 9091
    4/02/20 5:41 PM (SetupUtil) nsa.install           = true
    4/02/20 5:41 PM (SetupUtil) j2ee.home             = C:\Tomcat
    4/02/20 5:41 PM (SetupUtil) nsa.web.port          = 8090
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (SetupUtil) Use these settings? [(y)es, (n)o]
    4/02/20 5:41 PM (Target) Target "_install" finished.
    4/02/20 5:41 PM (Target) Target "_version_prep_props_only" finished.
    4/02/20 5:41 PM (Target) Target "_process-release-setup-props" finished.
    4/02/20 5:41 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "_preprocess-upgrade" started.
    4/02/20 5:41 PM (Echo) preprocess-upgrade proceeding...
    4/02/20 5:41 PM (Project) Trying to override old definition of task java
    4/02/20 5:41 PM (Target) Target "_precheck" started.
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "checkinstall" started.
    4/02/20 5:41 PM (Echo)
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo) This program will perform a check for the prerequisite of
    4/02/20 5:41 PM (Echo) an upgrade from Clarity version: 15.7.0.212
    4/02/20 5:41 PM (Echo) -------------------------------------------------------------
    4/02/20 5:41 PM (Echo)            
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "_get-upgrade-target-props" started.
    4/02/20 5:41 PM (Target) Target "_get-upgrade-target-props" finished.
    4/02/20 5:41 PM (Target) Target "perform_upgrade_check" started.
    4/02/20 5:41 PM (Target) Target "_perform_check" started.
    4/02/20 5:41 PM (Target) Target "_create-output-header" started.
    4/02/20 5:41 PM (Target) Target "_create-output-header" finished.
    4/02/20 5:41 PM (Target) Target "check-includes-init" started.
    4/02/20 5:41 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "check" started.
    4/02/20 5:41 PM (Target) Target "perform-check" started.
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Operator user name [DIOUFK] :
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) Operator email address:(name@abcabc.com) [k.diouf@lombardodier.com] :
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (SetupUtil) You chose the following:
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) operator.username     = DIOUFK
    4/02/20 5:41 PM (SetupUtil) operator.emailaddress = k.diouf@lombardodier.com
    4/02/20 5:41 PM (SetupUtil) -----------------------------------------
    4/02/20 5:41 PM (SetupUtil) Use these settings? [(y)es, (n)o]
    4/02/20 5:41 PM (Target) Target "perform-check" finished.
    4/02/20 5:41 PM (Target) Target "report-result" started.
    4/02/20 5:41 PM (Echo) script name = check-credentials.xml
    4/02/20 5:41 PM (Echo) check.result = INFO
    4/02/20 5:41 PM (Target) Target "_output-log-info" started.
    4/02/20 5:41 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:41 PM (Target) Target "report-result" finished.
    4/02/20 5:41 PM (Target) Target "check" finished.
    4/02/20 5:41 PM (Target) Target "check-includes-init" started.
    4/02/20 5:41 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:41 PM (Target) Target "init" started.
    4/02/20 5:41 PM (Target) Target "init" finished.
    4/02/20 5:41 PM (Target) Target "check" started.
    4/02/20 5:41 PM (Target) Target "perform-check" started.
    4/02/20 5:41 PM (SetupUtil)
    4/02/20 5:41 PM (SetupUtil) I acknowledge that I have reviewed the Clarity Installation Guide and Change Impact Guide: [true] :
    4/02/20 5:42 PM (SetupUtil) -----------------------------------------
    4/02/20 5:42 PM (SetupUtil) You chose the following:
    4/02/20 5:42 PM (SetupUtil)
    4/02/20 5:42 PM (SetupUtil) doc.review.acknowledge = true
    4/02/20 5:42 PM (SetupUtil) -----------------------------------------
    4/02/20 5:42 PM (SetupUtil) Use these settings? [(y)es, (n)o]
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-doc-ackowledgement.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-export-permissions.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-dwh-export-permissions.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (ScriptDefBase) Warning: Nashorn engine is planned to be removed from a future JDK release
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-free-disk-space.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Echo) Database Vendor = mssql
    4/02/20 5:42 PM (Echo) Current Database Version = 13.0.5698.0 - DEVELOPER EDITION (64-BIT)
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-version.xml
    4/02/20 5:42 PM (Echo) check.result = WARNING
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check-action" started.
    4/02/20 5:42 PM (Target) Target "perform-check-action" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-sqlserver-collation.xml
    4/02/20 5:42 PM (Echo) check.result = WARNING
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-tablespaces.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Project) Trying to override old definition of task checkIfDWHInstalled
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) SELECT ISNULL(entity_key, 'NULL') entity_key FROM dwh_settings
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) 1 of 1 SQL statements executed successfully
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-dwh-create-database.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Echo) Checking Host and DB Timezone.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-timezones.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Project) Trying to override old definition of task checkIfDWHInstalled
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) select top 1 installed_version datawarehouse_version
                  from cmn_dwh_install_history
                  where install_id = 'dwhdatabase' order by installed_date desc
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) 1 of 1 SQL statements executed successfully
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) select top 1 installed_version ppm_version
                  from cmn_install_history
                  where install_id = 'database' order by installed_date desc
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) 1 of 1 SQL statements executed successfully
    4/02/20 5:42 PM (Echo) PPM Database Version = 15.7.0.212
    4/02/20 5:42 PM (Echo) DHW Database Version = 15.7.0.212
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-dwh-sync.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-14309-patch.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Project) Trying to override old definition of task checkIfDWHInstalled
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) SELECT ISNULL(entity_key, 'NULL') entity_key FROM dwh_settings
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) 1 of 1 SQL statements executed successfully
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-dwh-constraints.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Project) Trying to override old definition of task checkIfDWHInstalled
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) SELECT ISNULL(entity_key, 'NULL') entity_key FROM dwh_settings
    4/02/20 5:42 PM (SQLTask) 
    4/02/20 5:42 PM (SQLTask) 1 of 1 SQL statements executed successfully
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-dwh-load-job-success.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Delete) Deleting: C:\Temp\checkinstall\check-logs\database_customization_triggers.txt
    4/02/20 5:42 PM (Delete) Deleting: C:\Temp\checkinstall\check-logs\database_customization_indexes.txt
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "get-ootb-indices" started.
    4/02/20 5:42 PM (MacroDef) Task "macrodef" started.
    4/02/20 5:42 PM (MacroDef) Task "macrodef" finished.
    4/02/20 5:42 PM (Target) Target "get-ootb-indices" finished.
    4/02/20 5:42 PM (Target) Target "perform-check-action" started.
    4/02/20 5:42 PM (Target) Target "perform-check-action" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-customization.xml
    4/02/20 5:42 PM (Echo) check.result = WARNING
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-invalid-objects.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-db-partitioned-tables.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-system-users.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-lang-locale-setting.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-admin-user-rights.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Project) Trying to override old definition of task checkIfDWHInstalled
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-ppmjasperadmin-user.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Project) Trying to override old definition of task checkIfDWHInstalled
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" started.
    4/02/20 5:42 PM (Target) Target "check-for-right" finished.
    4/02/20 5:42 PM (CallTarget) Task "antcall" finished.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-ppmjasperadmin-user-rights.xml
    4/02/20 5:42 PM (Echo) check.result = INFO
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-duplicate_glalloc_slices.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "report-result" started.
    4/02/20 5:42 PM (Echo) script name = check-idea-obs-associations.xml
    4/02/20 5:42 PM (Echo) check.result = SKIPPED
    4/02/20 5:42 PM (Target) Target "_output-log-info" started.
    4/02/20 5:42 PM (Target) Target "_output-log-info" finished.
    4/02/20 5:42 PM (Target) Target "report-result" finished.
    4/02/20 5:42 PM (Target) Target "check" finished.
    4/02/20 5:42 PM (Target) Target "check-includes-init" started.
    4/02/20 5:42 PM (Target) Target "check-includes-init" finished.
    4/02/20 5:42 PM (Target) Target "init" started.
    4/02/20 5:42 PM (Target) Target "init" finished.
    4/02/20 5:42 PM (Target) Target "check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" started.
    4/02/20 5:42 PM (Target) Target "perform-check" finished.

    Sorry for the long text.
    Regards,
    Karim


  • 4.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Broadcom Employee
    Posted Apr 02, 2020 12:34 PM
    This doesn't seem to contain the actual error though. The error should be between this part and the part you specified above


  • 5.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Posted Apr 02, 2020 12:43 PM
    This is what I found :
    ​/02/20 5:46 PM (Java) Error validating NSQL
    4/02/20 5:46 PM (Java)
    4/02/20 5:46 PM (Java)
    4/02/20 5:46 PM (Java) Query name=Data Warehouse Audit : Query ID=cop.admDWHAudit : Content Source=csk.niku.com : cmn_nsql_queries.id=5100007
    4/02/20 5:46 PM (Java)
    4/02/20 5:46 PM (Java) Query name=Data Warehouse Error : Query ID=cop.admDWHError : Content Source=csk.niku.com : cmn_nsql_queries.id=5100008
    4/02/20 5:46 PM (Java)
    4/02/20 5:46 PM (Java)
    4/02/20 5:46 PM (Java)
    4/02/20 5:46 PM (Java) You must correct invalid NSQL queries.  In PPM Studio, go to the NSQL tab for each failing NSQL query. Click the 'Preview' button to view the error details. See the Change Impact Guide for further information.

    and this error in the invalid_nsql_queries file :
    You must correct invalid NSQL queries. In Clarity Studio, go to the NSQL tab for each failing NSQL query. Click the 'Preview' button to view the error details. See the Change Impact Guide for further information.

    The following NSQL Queries are invalid :
    Query name=Project Status Issues(ID=csp.prjStatusIssues)
    Query name=Change Requests(ID=pbk.qry.change_req)
    Query name=Issues(ID=pbk.qry.issues)
    Query name=Risks(ID=pbk.qry.risks)
    Query name=Data Warehouse Audit(ID=cop.admDWHAudit)
    Query name=Data Warehouse Error(ID=cop.admDWHError)

    Thank you again for your help.
    Karim



  • 6.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Broadcom Employee
    Posted Apr 02, 2020 12:49 PM
    This is just a warning. Can you try uploading the whole install.log or sending as private message?


  • 7.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Posted Apr 02, 2020 01:23 PM
    HI Nika,
    I could not send you the file by private message.
    Could you  please send me in private your email so I can send you the file​ ?
    Thank you in advance.

    Karim


  • 8.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed
    Best Answer

    Broadcom Employee
    Posted Apr 02, 2020 02:55 PM
    Edited by Christopher Hackett Apr 09, 2020 05:05 PM




    Thank you for the log Karim, here is the error:

    4/02/204/02/20 5:45 PM (ExecTask) Note: Triggers have been disabled
    4/02/20 5:45 PM (ExecTask) Process - function: NK_SUM_JULIAN_FCT.xml
    4/02/20 5:45 PM (ExecTask) 
    4/02/20 5:45 PM (ExecTask) SQL Text: [...}
    4/02/20 5:45 PM (ExecTask) 
    4/02/20 5:45 PM (ExecTask) 
    4/02/20 5:45 PM (ExecTask) java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
    4/02/20 5:45 PM (ExecTask) at com.ca.clarity.jdbc.sqlserverbase.ddcw.b(Unknown Source)
    4/02/20 5:45 PM (ExecTask) at com.ca.clarity.jdbc.sqlserverbase.ddcw.a(Unknown Source)

    This is a known issue with the Compatibility level, check out: https://knowledge.broadcom.com/external/article?articleId=142274
    This solution should help move forward. You will have to rollback first though.


  • 9.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Posted Apr 03, 2020 05:14 AM
    Hi Nika,
    Thank you for your answer I did the upgrade again and do not have this error.
    But I am having another error :
    4/03/20 10:36 AM (ExecTask) Updating xogseeddata for component = infrastructure
    4/03/20 10:36 AM (ExecTask) Created dir: C:\Clarity\logs\xog-seeddata\out\infrastructure
    4/03/20 10:36 AM (ExecTask)  Applying PPM_INVALID_USER.xml
    4/03/20 10:36 AM (ExecTask) Error Applying XOG: Failure occurred while applying PPM_INVALID_USER.xml
    4/03/20 10:36 AM (ExecTask)  Check C:\Clarity/logs/xog-seeddata/out/infrastructure\PPM_INVALID_USER_out.xml for errors
    4/03/20 10:36 AM (ExecTask) C:\Clarity\.setup\scripts\db.xml:2582: The following error occurred while executing this line:
    4/03/20 10:36 AM (ExecTask) C:\Clarity\.setup\scripts\db.xml:2798: The following error occurred while executing this line:
    4/03/20 10:36 AM (ExecTask) C:\Clarity\.setup\scripts\db.macros.xml:172: Java returned: 2

    I have checked the  PPM_INVALIDER_USER_out.xml file, this is what I found about a permission to be given to niku :
    <?xml version="1.0" encoding="UTF-8"?>
    <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
      <Object type="user"/>
      <Status elapsedTime="1.11 seconds" state="FAILURE"/>
      <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
      <Records>
        <Record>
          <KeyInformation>
            <column name="ALL">ALL RECORDS</column>
          </KeyInformation>
          <ErrorInformation>
            <Severity>WARNING</Severity>
            <Description>New Users Password will be Defaulted to Value niku2000</Description>
          </ErrorInformation>
        </Record>
        <Record>
          <KeyInformation>
            <column name="externalSource">NIKU</column>
            <column name="externalId"/>
            <column name="userName">ppm_invalid_user</column>
          </KeyInformation>
          <ErrorInformation>
            <Severity>FATAL</Severity>
            <Description>This record has not been inserted</Description>
            <Exception><![CDATA[SQL Exception with error code : 300 message: [CA Clarity][SQLServer JDBC Driver][SQLServer]VIEW SERVER STATE permission was denied on object 'server', database 'master'.]]></Exception>
          </ErrorInformation>
        </Record>
      </Records>
    </XOGOutput>

    Should I have to give the user niku all permission about the server and the database master ?

    Many thanks in advance.
    Karim


  • 10.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Broadcom Employee
    Posted Apr 03, 2020 09:26 AM
    HI Karim

    View Server state must be granted to niku user. You will have to rollback now. Check out the required database parameters here and make sure they're all granted: 

    https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-7-1/installing-and-upgrading/install-clarity-ppm.html#concept.dita_c5fddf2f732699e579d4affe4d72b1178454ee97_ConfigureacappmDatabasewithMicrosoftSQLServer



  • 11.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Posted Apr 03, 2020 12:05 PM
    Hi Nika,
    Many thanks for your help. The upgrade was successful and even upgrade to 15.8.

    Have a nice weekend.
    Karim​


  • 12.  RE: Upgrade from 15.7 to 15.7.1 failed due db upgrade failed

    Broadcom Employee
    Posted Apr 03, 2020 12:22 PM
    Glad to hear this, have a great weekend Karim!