6 Replies Latest reply on Feb 14, 2017 5:51 PM by JohnGoodwin

    DevMode

    pr921

      I set up the sample code,

       

      import java.math.BigDecimal as BigDecimal

      import java.sql as sql

      import com.hyperion.aif.scripting.API as API

       

      def DevMode():   

          #conn = sql.DriverManager.getConnection("jdbc:oracle:thin:@);

          #Start Initialize Code

          #Required for Dev Mode. Not required in production script

          fdmAPI = API()

          conn = None

          conn = sql.DriverManager.getConnection("jdbc:oracle:thin:@myserver.com:1999:cxaz", "User", "password");

          conn.setAutoCommit(False)

         

          fdmAPI.initializeDevMode(conn);

          print "SUCCESS CONNECTING TO DB"

          print BigDecimal(148)

          fdmContext = fdmAPI.initContext(BigDecimal(149))

          #End Initialize Code Required for Dev Mode. Not required in production script

       

       

       

      It fails even after I enter a loadid from the AIF_APPL_LOAD_AUDIT table.  I get the following error.

       

       

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

       

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

       

          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

       

          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)

       

          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

       

          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

       

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

       

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)

       

          at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774)

       

          at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)

       

          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)

       

          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)

       

          at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845)

       

          at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501)

       

          at com.hyperion.aif.scripting.API.initContext(API.java:811)

       

          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)

       

       

      java.sql.SQLSyntaxErrorException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist