Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c Sax parser returned an exception Error

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

SessionID: 172.16.210.20.82f.ua28863

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

Regards,

Dilek

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

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

Did you recently move your catalogue from another environment?

Was it a binary transfer? (not text)

dilek

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

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

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

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

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

Do you have back ups to refer to?

Gianni Ceresa

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

Thank you so much Gianni. It solved our problem.