Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue while doing view data from HTTP connection and dataset at BIP Data model

Sangeeta PandeyOct 31 2020 — edited Oct 31 2020

Hello Experts,
I created one HTTP (XML feed) connection through BIP (Administration) and it is successfull:
image.png
Then I created a BIP data model using this HTTP connection as dataset:
image.pngIf I validate my data model then it looks good:
image.pngHowever when doing view data getting below error:
image.pngBelow is detailed error message from view engine log:
Total Number of Datasets: 4
Total Number of Elements: 0
Total Parse Time (ms): 0
Total Used Memory at Start: 2.29 GB
Total Used Memory after Parsing: 2.29 GB
Total Used Memory after Processing: 2.32 GB
Total Datamodel Validation Time: .000 mseconds
Total Xplan Generation Time: .000 mseconds
Total Data Generation Time: 1.000 seconds
Total XML Data Size Generated: 145
Processing Exceptions: oracle.xdo.XDOException: Unsupported content-type:text/html; charset=UTF-8
at oracle.xdo.dataengine.datasource.http.RestApi.writeOutputStream(RestApi.java:327)
at oracle.xdo.dataengine.datasource.http.RestApi.execute(RestApi.java:229)
at oracle.xdo.dataengine.datasource.http.HTTPHandler.execute(HTTPHandler.java:105)
at oracle.xdo.dataengine.datasource.XMLStatement.executeHTTP(XMLStatement.java:235)
at oracle.xdo.dataengine.datasource.ThreadExecutor.process(ThreadExecutor.java:92)
at oracle.xdo.dataengine.datasource.ThreadExecutor.run(ThreadExecutor.java:62)

I am not the expert , however it seems that it is expecting content type as XML and I could not see any option to define content type as XML at BIP whilst I could choose through postman:

image.png
My HTTP url in above screenshot (from postman) is defined at BIP as below:
and I mentioned in HTTP connection and dataset like below:
image.png
image.pngPlease help !!!

Thanks,

This post has been answered by Gianni Ceresa on Nov 1 2020
Jump to Answer
Comments