5 Replies Latest reply on Dec 29, 2011 3:06 PM by Machiel Treffers

    XML Parsing Error: no element found In BI Publisher

    lczinkoc
      Hi Gurus,

      I tried to get XML output for a Data Model which was based on SQL queries.
      But I got the following error in Firefox
      XML Parsing Error: no element found
      Location: http://localhost:9704/xmlpserver/servlet/xdo
      Line Number 4, Column 1:

      In IE I got an other error:
      There is no end tag for DATA_SET
      Any ideas?
      Many thanks
      Laszlo
        • 1. Re: XML Parsing Error: no element found In BI Publisher
          Aravind
          which one u r using 10g /11g?
          • 2. Re: XML Parsing Error: no element found In BI Publisher
            lczinkoc
            Hi,

            I use 11g.
            I tried to create element link when I got this error.
            Now I am using groupink.
            Without using bind variable I got result (Cartesian product)
            However if i created and used bind variable I got the same error
            this is a dept data set:
            select     "DEPARTMENTS"."DEPARTMENT_ID" as DEPTNO,
                 "DEPARTMENTS"."DEPARTMENT_NAME" as "DEPARTMENT_NAME",
                 "DEPARTMENTS"."LOCATION_ID" as "LOCATION_ID",
                 "DEPARTMENTS"."MANAGER_ID" as "MANAGER_ID"
            from     "HR"."DEPARTMENTS" "DEPARTMENTS"

            this is the emp data set:
            select     "EMPLOYEES"."COMMISSION_PCT" as "COMMISSION_PCT",
                 "EMPLOYEES"."DEPARTMENT_ID" as "DEPARTMENT_ID",
                 "EMPLOYEES"."EMAIL" as "EMAIL",
                 "EMPLOYEES"."EMPLOYEE_ID" as "EMPLOYEE_ID",
                 "EMPLOYEES"."FIRST_NAME" as "FIRST_NAME",
                 "EMPLOYEES"."HIRE_DATE" as "HIRE_DATE",
                 "EMPLOYEES"."JOB_ID" as "JOB_ID",
                 "EMPLOYEES"."LAST_NAME" as "LAST_NAME",
                 "EMPLOYEES"."MANAGER_ID" as "MANAGER_ID"
            from     "HR"."EMPLOYEES" "EMPLOYEES"
            WHERE "EMPLOYEES"."DEPARTMENT_ID" =:DEPTNO

            Thanks for any tip!
            Laszlo
            • 3. Re: XML Parsing Error: no element found In BI Publisher
              lczinkoc
              Hi aravind

              I copied the error message:
              Oracle Fusion Middleware Search Results: java.sql.SQLException: unsupported function at oracle.bi.jdbc.AnaJdbcPreparedStatement.setBigDecimal within Release Notes for Microsoft Windows (32-Bit)

              and explanation
              Data models that include a link between a data set of SQL query type against an Oracle database and a data set of SQL query type against the BI Server based on a numeric database column (used to create a parent-child hierarchical XML data structure with the SQL query against the Oracle database as the parent data set) fail to execute and return the following error: "Java.sql.SQLException: unsupported function at oracle.bi.jdbc.AnaJdbcPreparedStatement.setBigDecimal."

              The question is; How to use numeric column in the join and/or in WHERE clause?
              Thanks
              Laszlo
              • 4. Re: XML Parsing Error: no element found In BI Publisher
                lczinkoc
                Hi,

                now I am sure that the problem is the number data type.
                I created an other data model where the link (join ) column is VARCHAR worked fine!

                Laszlo
                • 5. Re: XML Parsing Error: no element found In BI Publisher
                  Machiel Treffers
                  Hi Laszlo,

                  I'm facing the exact same problem. Did you find a solution for this? Instead of the work around with a VARCHAR.
                  Because I need to create a link between NUMBER's.

                  Thanks in advance!

                  Kind regards,

                  Machiel