OBIEE 12c Sax parser returned an exception Error — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c Sax parser returned an exception Error

Received Response
184
Views
11
Comments
dilek
dilek Rank 6 - Analytics Lead
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

Hi,

I have a question for obiee analytics side. When I run an analysis, OBIPS log file alwalys say following erros. (For all reports not for specific ones)

[2018-10-10T14:08:50+03:00] [OBIPS] [ERROR:31] [] [saw.catalog.serviceinstance.readObject] [ecid: 8c4164d1-ab63-4625-b7dc-9d159e642218-0000bdd2,0:1] [tid: 1531143936] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: altug.ipek] Sax parser returned an exception.

Message: Invalid document structure, Entity publicId: , Entity systemId: , Line number: 2, Column number: 1[[

File:saxreader.cpp

Line:807

Location:

    saw.catalog.serviceinstance.readObject

    saw.views.evc.activate

    saw.subsystem.go.getxslfo

    saw.subsystem.portal.office

    saw.httpserver.processrequest

    saw.rpc.server.responder

    saw.rpc.server

    saw.rpc.server.handleConnection

    saw.rpc.server.dispatch

    saw.threadpool.socketrpcserver

    saw.threads

RSP: o:portalgo~r:report

Path: /system/metadata/_datatype_formats

HttpCommand: Go

SID: e2rhuag5shjnnp6og37hhkb68m

AuthProps: AuthSchema=SSO|IMPERSONATE=altug.ipek|NQ_SESSION.SERVICEINSTANCEKEY=ssi|PWD=******|UID=ucj41zreghysopaxqln7mkd6itb0fvw8|User=altug.ipek|GUID=altug.ipek

SessionID: 172.16.210.20.82f.ua28863

What can be the reason of this failure? Can you help me please.

Regards,

Dilek

«1

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Based on the error it looks like there is an issue with the XML inside /system/metadata/_datatype_formats (in your catalog)

    Did you saved some default formats lately? Did you touch that file? Or what does it contains?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Did you recently move your catalogue from another environment?

    Was it a binary transfer? (not text)

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi,

    When I look at that file I see only one line, which is below;

    <?xml version="1.0" encoding="utf-8"?>

    Is it something wrong? I did not touch this file manually.

    Regards,

    Dilek

  • Gianni Ceresa
    Gianni Ceresa Mod

    What exact version of 12c do you have?

    What is the history of that catalog? Is that an upgrade? Is that, as Robert asked, a move from another environment?

    In a clean install of 12c I have content in that file, it isn't empty like your with just the XML tag.

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi,

    Our version is: 12.2.1.3.0 (Build BIPS-20170820114118 64-bit)

    Our system is a new installation of obiee 12c. It is not an upgrade and we did not move catalog :S

    Can I paste the correct lines under _datatype_formats file?

    Regards.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Do you have any other 12c system around? (even a sandbox or something like that)

    Look there to see the content of the file, if it isn't empty try by copying the file (if you copy the content directly make sure to not have line breaks breaking your tags and attributes and that the permissions on the file on disk didn't change). Do not touch the _datatype_formats.atr, this one is fine like that.

    That's something you can try ...

  • dilek
    dilek Rank 6 - Analytics Lead

    Hi,

    There is no any other 12c environment. To check this I searched this file under root. Only found files are the files that I pointed :S How can I ind the correct file in this case?

    Regards,

    Dilek

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Do you have back ups to refer to?

  • Gianni Ceresa
    Gianni Ceresa Mod

    That's my file on a clean install of 12.2.1.3 :

    <?xml version="1.0" encoding="utf-8"?><sawsavedformat:metadata xmlns:sawsavedformat="com.siebel.analytics.web/savedformat/v1.1"><sawsavedformat:datatypeSavedFormats><sawsavedformat:datatypeFormat xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" datatype="GDT:real"><saw:displayFormat><saw:formatSpec suppress="repeat" wrapText="true" visibility="visible" hAlign="right" vAlign="top" imagePlacement="right" interaction="action"><saw:dataFormat minDigits="0" maxDigits="0" commas="true" negativeType="minus" xsi:type="saw:number"/></saw:formatSpec></saw:displayFormat><saw:tableHeading><saw:displayFormat><saw:formatSpec/></saw:displayFormat></saw:tableHeading><saw:columnHeading><saw:displayFormat><saw:formatSpec/></saw:displayFormat></saw:columnHeading></sawsavedformat:datatypeFormat></sawsavedformat:datatypeSavedFormats></sawsavedformat:metadata>

    As you see it's just 1 line.

    PS: backup your current file first, make sure it's still XML once you added content inside and you don't have encoding issues, line breaks etc. All the typical things when playing with a web catalog file in an "uncommon" way ...

  • dilek
    dilek Rank 6 - Analytics Lead

    Thank you so much Gianni. It solved our problem.