5 Replies Latest reply on Jun 27, 2017 5:39 AM by 3380516

    Getting blank XML file while using "Generate XML"

    3380516

      Hi there,

       

      I am trying to use FDMEE custom reports, but facing the issue while using SQL query with Group By clause.

       

      When I am using "Generate XML" button on Query definition, correct XML is getting generated. However, when I am trying to use Group By clause in same query, the xml file generated is blank.

       

      I have checked query and it's working fine in SQL developer.

       

      Can anyone help?

        • 2. Re: Getting blank XML file while using "Generate XML"
          1002763

          Hi @3380516,

           

          Did check in my DEV environment, some of reports is throwing error, the one that worked is "Audit Query", check for this Report.

           

          Thanks

          A

          • 3. Re: Getting blank XML file while using "Generate XML"
            3380516

            Hi,

             

            Thanks for your response.

             

            Can you please tell me where I can find Audit Query?

             

            I tried to see Report Group but not able to see "Audit Query". We checked for aif-WebApp logs and can see below errors:

             

            [2017-06-22T16:25:52.355+05:30] [ErpIntegrator0] [ERROR] [] [oracle.apps.erpi.model] [tid: 75] [userId: <anonymous>] [ecid: 0000LnFSQ2T62VVLu2k3yX1PG^VO0007Fr,0] [APP: AIF#11.1.2.0] [SRC_CLASS: com.hyperion.aif.gl.common.reporting.model.applicationModule.ReportAMImpl] [SRC_METHOD: generateXMLForQueryDefPage] An error occured while writing XML[[

            oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 2 with java object of type java.lang.Integer due to java.sql.SQLException.

              at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:2761)

              at oracle.jbo.server.ViewRowImpl.populate(ViewRowImpl.java:3982)

              at oracle.jbo.server.ViewDefImpl.createInstanceFromResultSet(ViewDefImpl.java:2645)

              at oracle.jbo.server.ViewObjectImpl.createRowFromResultSet(ViewObjectImpl.java:6253)

              at oracle.jbo.server.ViewObjectImpl.createInstanceFromResultSet(ViewObjectImpl.java:6044)

              at oracle.jbo.server.QueryCollection.populateRow(QueryCollection.java:3780)

              at oracle.jbo.server.QueryCollection.fetch(QueryCollection.java:3635)

              at oracle.jbo.server.QueryCollection.get(QueryCollection.java:2348)

              at oracle.jbo.server.ViewRowSetImpl.getRow(ViewRowSetImpl.java:5191)

              at oracle.jbo.server.ViewRowSetIteratorImpl.doFetch(ViewRowSetIteratorImpl.java:2989)

              at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2845)

              at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2805)

              at oracle.jbo.server.ViewRowSetIteratorImpl.setRangeStartWithRefresh(ViewRowSetIteratorImpl.java:2778)

             

             

             

             

             

            at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)

            at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

             

            Caused by: java.sql.SQLException: Numeric Overflow

            at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:4514)
            at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java:204)
            at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java:2040)
            at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getInt(Unknown Source)
            at oracle.jbo.common.IntegerTypeSQLNativeImpl.getDataFromResultSet(JboTypeMapEntries.java:506)
            at oracle.jbo.server.AttributeDefImpl.loadFromResultSet(AttributeDefImpl.java:2752)
            • 4. Re: Getting blank XML file while using "Generate XML"
              1002763

              Hi @3380516

               

              Please refer the attachment.

               

              Query_Definition.JPG

               

              Thanks

              A

              • 5. Re: Getting blank XML file while using "Generate XML"
                3380516

                Hi 1002763,

                 

                This will generate correct XML file as query does not include Group By clause. But when I am using any SQL query having Group By clause blank XML is getting generated.