3 Replies Latest reply on Feb 17, 2015 6:34 PM by 2659278

    Planning Outlineload Utility Fails

    2659278

      I am attempting to run the Outline load utility. However, this is the error message which gets created. Any help will be greatly appreciated.

       

      C:\Oracle\mwh\user_projects\epmsystem2\Planning\planning1>OutlineLoad /S:DA6THYPPS01 /A:HPBud /
      U:admin /M /N /I:C:\Oracle\mwh\user_projects\epmsystem2\Planning\OutlineFiles\Cl
      assDim.csv /D:Class /L:C:\Oracle\mwh\user_projects\epmsystem2\Planning\OutlineLo
      gs\outlineLoad.log /X:C:\Oracle\mwh\user_projects\epmsystem2\Planning\OutlineExc
      \outlineLoad.exc
      Enter password:
      Planning locale: en_US
      Query Failed: SQL_GET_PROPS_BY_ID: [0]
      java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Inva
      lid object name 'HSPSYS_PROPERTIES'.
              at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
              at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
              at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
              at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
              at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
              at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddel.u(Unknown Source)
              at weblogic.jdbc.sqlserverbase.ddde.executeQuery(Unknown Source)
              at com.hyperion.planning.sql.HspSQLImpl.executeQuery(HspSQLImpl.java:143
      )
              at com.hyperion.planning.sql.HspSQLImpl.executeQuery(HspSQLImpl.java:114
      )
              at com.hyperion.planning.sql.HspSQLImpl.executeQuery(HspSQLImpl.java:99)

              at com.hyperion.planning.utils.HspJSHomePropsFactory.createHomeInstance(
      HspJSHomePropsFactory.java:60)
              at com.hyperion.planning.HspJSHomeImpl.loadProperties(HspJSHomeImpl.java
      :455)
              at com.hyperion.planning.HspJSHomeImpl.<init>(HspJSHomeImpl.java:89)
              at com.hyperion.planning.HspJSHomeImpl.getStaticHome(HspJSHomeImpl.java:
      809)
              at com.hyperion.planning.HspJSHomeImpl.getStaticHome(HspJSHomeImpl.java:
      803)
              at com.hyperion.planning.utils.HspOutlineLoad.login(HspOutlineLoad.java:
      1067)
              at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
      utlineLoad.java:108)
              at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
      ineLoad.java:1303)
              at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
      292)
      [Fri Feb 13 14:04:03 CST 2015]Unable to obtain dimension information and/or perf
      orm a data load: Error getting Global properties from System DB