Clarity

  • Private Community

  • 1.  Jaspersoft Load DWH Error

    Posted Aug 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

    Broadcom Employee
    Posted Aug 25, 2017 01:11 PM

    Refers as below

     

    Load Data Warehouse job fails - DWH_CFG_PRE_CONFIG_SP 

     

    Thanks

    Senthil



  • 3.  Re: Jaspersoft Load DWH Error

    Posted Aug 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

    Broadcom Employee
    Posted Aug 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.