Clarity PPM

Expand all | Collapse all

Jaspersoft Load DWH Error

  • 1.  Jaspersoft Load DWH Error

    Posted 08-25-2017 12:48 PM

    Hi All,

    I'm trying to reload my DWH and running into the following error.  Any ideas on next steps?

     

     

    dwh_db_check_ - An error occurred executing this job entry :
    Couldn't execute SQL: BEGIN
     DWH_CFG_PRE_CONFIG_SP(
        P_DBLINK => 'PPMDBLINK.regence.com',
     P_FULL_RELOAD => 'Y'
    );
    END;

    [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 2, column 2:
    PLS-00306: wrong number or types of arguments in call to 'DWH_CFG_PRE_CONFIG_SP'
    ORA-06550: line 2, column 2:
    PL/SQL: Statement ignored
     



  • 2.  Re: Jaspersoft Load DWH Error

    Posted 08-25-2017 01:11 PM


  • 3.  Re: Jaspersoft Load DWH Error

    Posted 08-25-2017 01:17 PM

    Hi Senthil,

    I get an error when attempting to run this command:

     

    Aug 25, 2017 11:02:45 AM Error executing command: db dwh-upgrade -Dupgrade.phase=maintenance
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1882: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1912: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1925: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1987: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2132: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2133: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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:459)
     at com.niku.nsa.service.AdminManager.execute(AdminManager.java:188)
     at com.niku.nsa.service.Admin.main(Admin.java:77)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     at com.werken.forehead.Forehead.run(Forehead.java:551)
     at com.werken.forehead.Forehead.main(Forehead.java:581)
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:1912: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1925: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1987: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2132: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2133: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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)
     ... 52 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:1925: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:1987: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2132: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2133: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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)
     ... 65 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:1987: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2132: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2133: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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)
     ... 92 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2132: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2133: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     at com.niku.tools.taskdefs.XPath.execute(XPath.java:448)
     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
     at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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)
     ... 119 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2133: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     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 com.niku.tools.taskdefs.xpath.Iter.executeTarget(Iter.java:294)
     at com.niku.tools.taskdefs.xpath.Iter.execute(Iter.java:189)
     at com.niku.tools.taskdefs.xpath.Iter.execute(Iter.java:145)
     at com.niku.tools.taskdefs.XPath.execute(XPath.java:419)
     ... 138 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:2477: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:568)
     at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:399)
     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
     at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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)
     ... 143 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:2968: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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.MacroInstance.execute(MacroInstance.java:396)
     ... 162 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.xml:624: The following error occurred while executing this line:
    D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:568)
     at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:399)
     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
     at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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)
     ... 184 more
    Caused by: D:\ClarityHome\Clarity\.setup\scripts\db.macros.xml:44: Java returned: 1
     at org.apache.tools.ant.taskdefs.Java.execute(Java.java:111)
     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
     at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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 sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     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.MacroInstance.execute(MacroInstance.java:396)
     ... 196 more



  • 4.  Re: Jaspersoft Load DWH Error

    Posted 08-28-2017 02:11 AM

    The maintainace command will not run, because the problem lies with the DB link. Can you try toverify the DB link and see if that works and once that work you should be abl to go pasw this stage.

     

     

    The command "admin db dwh-upgrade -Dupgrade.phase=maintenance" is only required when your PPM and DWH version is not in sync and thats the time you would need this to be run.