oData issue

0
Hi, anynone know how to solve this issue? This issue appeared after I add one association. Then I removed the association and it still occured the same error.   Console message: Exception occurred while serializing OData response. com.ctc.wstx.exc.WstxIOException: Invalid white space character (0xb) in text to output (in xml 1.1, could output as a character entity)     at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:469)     at com.mendix.integration.xml.StreamingXmlWriter$Logic.onPush(StreamingXmlWriter.scala:72)     at akka.stream.impl.fusing.GraphInterpreter.processPush(GraphInterpreter.scala:523)     at akka.stream.impl.fusing.GraphInterpreter.processEvent(GraphInterpreter.scala:480)     at akka.stream.impl.fusing.GraphInterpreter.execute(GraphInterpreter.scala:376)     at akka.stream.impl.fusing.GraphInterpreterShell.runBatch(ActorGraphInterpreter.scala:606)     at akka.stream.impl.fusing.GraphInterpreterShell$ResumeShell.execute(ActorGraphInterpreter.scala:497)     at akka.stream.impl.fusing.GraphInterpreterShell.processEvent(ActorGraphInterpreter.scala:581)     at akka.stream.impl.fusing.ActorGraphInterpreter.akka$stream$impl$fusing$ActorGraphInterpreter$$processEvent(ActorGraphInterpreter.scala:749)     at akka.stream.impl.fusing.ActorGraphInterpreter.akka$stream$impl$fusing$ActorGraphInterpreter$$shortCircuitBatch(ActorGraphInterpreter.scala:739)     at akka.stream.impl.fusing.ActorGraphInterpreter$$anonfun$receive$1.applyOrElse(ActorGraphInterpreter.scala:765)     at akka.actor.Actor.aroundReceive(Actor.scala:539)     at akka.actor.Actor.aroundReceive$(Actor.scala:537)     at akka.stream.impl.fusing.ActorGraphInterpreter.aroundReceive(ActorGraphInterpreter.scala:671)     at akka.actor.ActorCell.receiveMessage(ActorCell.scala:612)     at akka.actor.ActorCell.invoke(ActorCell.scala:581)     at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:268)     at akka.dispatch.Mailbox.run(Mailbox.scala:229)     at akka.dispatch.Mailbox.exec(Mailbox.scala:241)     at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)     at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)     at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)     at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107) Caused by: java.io.IOException: Invalid white space character (0xb) in text to output (in xml 1.1, could output as a character entity)     at com.ctc.wstx.api.InvalidCharHandler$FailingHandler.convertInvalidChar(InvalidCharHandler.java:56)     at com.ctc.wstx.sw.XmlWriter.handleInvalidChar(XmlWriter.java:629)     at com.ctc.wstx.sw.BufferingXmlWriter.writeCharacters(BufferingXmlWriter.java:583)     at com.ctc.wstx.sw.BaseStreamWriter.writeCharacters(BaseStreamWriter.java:467)     at com.mendix.integration.xml.StreamingXmlWriter$Logic.onPush(StreamingXmlWriter.scala:72)     at akka.stream.impl.fusing.GraphInterpreter.processPush(GraphInterpreter.scala:523)     at akka.stream.impl.fusing.GraphInterpreter.processEvent(GraphInterpreter.scala:480)     at akka.stream.impl.fusing.GraphInterpreter.execute(GraphInterpreter.scala:376)     at akka.stream.impl.fusing.GraphInterpreterShell.runBatch(ActorGraphInterpreter.scala:606)     at akka.stream.impl.fusing.GraphInterpreterShell$ResumeShell.execute(ActorGraphInterpreter.scala:497)     at akka.stream.impl.fusing.GraphInterpreterShell.processEvent(ActorGraphInterpreter.scala:581)     at akka.stream.impl.fusing.ActorGraphInterpreter.akka$stream$impl$fusing$ActorGraphInterpreter$$processEvent(ActorGraphInterpreter.scala:749)     at akka.stream.impl.fusing.ActorGraphInterpreter.akka$stream$impl$fusing$ActorGraphInterpreter$$shortCircuitBatch(ActorGraphInterpreter.scala:739)     at akka.stream.impl.fusing.ActorGraphInterpreter$$anonfun$receive$1.applyOrElse(ActorGraphInterpreter.scala:765)     at akka.actor.Actor.aroundReceive(Actor.scala:539)     at akka.actor.Actor.aroundReceive$(Actor.scala:537)     at akka.stream.impl.fusing.ActorGraphInterpreter.aroundReceive(ActorGraphInterpreter.scala:671)     at akka.actor.ActorCell.receiveMessage(ActorCell.scala:612)     at akka.actor.ActorCell.invoke(ActorCell.scala:581)     at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:268)     at akka.dispatch.Mailbox.run(Mailbox.scala:229)     at akka.dispatch.Mailbox.exec(Mailbox.scala:241)     at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)     at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)     at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)     at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)   Output after I add oData in Power BI :  
asked
1 answers
0

I have fixed the issue by replace the to replace illegal XML characters to yes.

 

 

5.2 Replace Illegal XML Characters

Some special characters cannot be used in XML. If your data contains these characters, the client will get an error. If you set this setting to Yes, those illegal characters are replaced by the DEL character, and the client will not get an error. However, the data that the client receives will not be exactly what is stored in your database, because these characters have been replaced.
This Replace Illegal XML Characters option is not available when the OData version is OData 4, because OData 4 returns data in JSON format.
Default value: No

 

answered