Biztalk error if "&" special character is used from Oracle Database

10-11  Source: Network gathering  Views:2 

Advertisement
There is an error when system was received data form Oracle database. The data format is including "&"....etc special character. Becuase of the error appear between Oracle database and receive port. I can't do anything in Biztalk program to
encode the message. Does any way to do encoding when biztalk receive data?
xlang/s engine event log entry: Uncaught exception (see the 'inner exception' below) has suspended an instance of service 'ECT.TOSToEDB.orcWorkingTable(7e2c77ec-adb6-5790-29ad-835ec8374c1d)'.
The service instance will remain suspended until administratively resumed or terminated.
If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception.
InstanceId: 8eb4cb36-82b2-4d34-9b45-64b8aba23758
Shape name:
ShapeId: 09bc980e-3040-4238-a838-f3606294effe
Exception thrown from: segment 1, progress 84 Inner exception: An error occurred while parsing EntityName. Line 4, position 112.
Exception type: XmlException
Source: System.Xml
Target Site: Void Throw(System.Exception) The following is a stack trace that identifies the location where the exception occured
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
   at System.Xml.XmlTextReaderImpl.ParseEntityName()
   at System.Xml.XmlTextReaderImpl.ParseEntityReference()
   at System.Xml.XmlTextReaderImpl.Read()
   at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
   at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at ECT.TOSToEDB.orcWokingTableCheck.segment1(StopConditions stopOn)
   at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp)
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
There are 5 special characters which in xml   & < > "  '  if the Oracle fields contain any of those characters it will cause invaild xml.
This can be solved at the oracle side be replacing the special characters by it's  html encode equivalent, so  & becomes &amp; , I think the best way to solve it
is to make a custom pipeline component and translate the special characters there.
There is my Send Port Properties. Do you mean the default biztalk pipeline component ("XML Receive") cannot translate any special characters?
Related articles
  • Biztalk error if "&" special character is used from Oracle Database 10-11

    There is an error when system was received data form Oracle database. The data format is including "&"....etc special character. Becuase of the error appear between Oracle database and receive port. I can't do anything in Biztalk program to

  • Error while generating a flat file from oracle database 10-11

    i have imported three knowledge modules for the interafce. LKM SQL to SQL IKM SQL to FILE Append CKM oracle I have tried executing the interface in following ways 1. checked the staging area different from target and choosed SUNOPSIS_MEMORY_ENGINE. t

  • I export dump from oracle database 8.1.7 and try to import in 10.2.0. while import its prompt error 11-30

    I export dump from oracle database 8.1.7 and try to import in 10.2.0. while import its prompt error as follow 8.1.7 SQL> select * from nls_database_parameters where parameter like '%SET%'; PARAMETER                      VALUE NLS_CHARACTERSET        

  • How to send a character mode report from Oracle Form 10g to a printer. 10-11

    how sending a character mode report from Oracle 10g report to a printer. I'm sending to a printer located in the network i have theses parameter report desformat = prtname desname=?????? destype= ????? mode=character i would like to preview the repor

  • Error while importing tables from oracle database 10-11

    Hi I am getting the following error when i am trying to import table from oracle database. my operating system is windows and my database is oracle. [nQSError: 16001]ODBC error state: IM004 code:0 message: [Microsoft][ODBC Driver Manager] Driver`s SQ

  • Empty CLOB field value from Oracle database using JDBC Sender 10-11

    Hi All, I am selecting a CLOB field from Oracle database table using JDBC Sender adapter and getting error "NullPointerException" Seen SAP note 1283089 but its not applicable for my support pack PI 7.0 SP 12 and client dont want to upgrdate SP 1

  • Error calling BLS from oracle database 10-11

    Hi Experts, We have a scenario in which we are calling BLS from oracle database using trigger. The call is made using the following URL: http://<Host name>:50000/XMII/Runner?Transaction=<TRX_Path>&Material=MATNR&Pallet_id=PALLET&Pl

  • ODSI service using function from oracle database 11-30

    Hi , I need to create a ODSI service using function from oracle database. I am not sure how to create a Physical Layer and Logical Layer using the function fron db. Kindly provide a sample . I need It ASAP. Thanks in advance. Regards, TaraHere's what

  • How do I get from Oracle Database 8.1.7.0.0 to 8.1.7.2? 11-30

    How do I get from Oracle Database 8.1.7.0.0 to 8.1.7.2? There is a patchset that fixes a bug in 8.1.7 for memory leaks that I need installed. I am currently running on a WindowsNT Server with a Oracle Database version of 8.1.7.0.0. Is going to 8.1.7.

  • Sending a mail from oracle database 10-11

    Hi, I have a requirement to send a mail from oracle database.I use UTL_TCP package for this.Although my procedure is executed successfully,i dont get the mails in my inbox.Please help me to figure out a solution. Thanks in advance....Hi, you must use

  • How to call MSSQL stored procedure from oracle database 10-11

    MSSQL and Oracle databases are linked thru ODBC link using Oracle HSODBC. I can query MSSQL table or view from Oracle Database using standard notation for acessing remote objects schema.object@dblink_name... Can anybody give me syntax for calling MSS

  • Walkthrough: Displaying Data from Oracle database in a Windows application. 11-30

    This article is intended to illustrate one of the most common business scenarios such as displaying data from Oracle database on a form in a Windows application using DataSet objects and .NET Framework Data Provider for Oracle. You can read more at h

  • Disconnected from Oracle Database 10g Release 10.2.0.1.0 - Production 11-30

    Can anyone tell me why my Database is not starting, I have been getting this error for quite some time now Total System Global Area 532676608 bytes Fixed Size          1249992 bytes Variable Size          167775544 bytes Database Buffers     36071014

  • How to extract data from oracle database directly in to bi7.0 (net weaver) 10-11

    how to extract data from oracle database directly in to bi7.0 (net weaver)? is it something do with EDI? can anybody explain me in detail? Thanks YorkYou can use UDConnect to get from Oracle database in to BW <b>Data Transfer with UD Connect -</b

  • Export an XML file from oracle database 10-11

    plz help me its urgent requirement....could u pls tell me the step by step procedure for following questions...?how to export a data as an XML file from oracle database? is it possible..? thanks in advance, Bala. is it possible? Edited by: user352329

  • How to I convert data from oracle database into excel sheet 10-11

    how to I convert data from oracle database into excel sheet. I need to import columns and there datas from oracle database to microsoft excel sheet. Please let me know the different ways for doing this. Thanks.asktom.oracle.com has an excellent artic

  • How to mail pdf file from oracle database 11g 10-11

    Hi, Using following code to send pdf file from oracle database. DECLARE v_From VARCHAR2(80) := '[email protected]'; v_Recipient VARCHAR2(80) := '[email protected]'; v_Subject VARCHAR2(80) := 'test subject'; v_Mail_Host VARCHAR2(30) := '116.214.31.249

  • Is Oracle Expert tool still used in Oracle database 11g? 11-30

    Is Oracle Expert tool still used in Oracle database 11g?!exp help=yes Export: Release 11.2.0.1.0 - Production on Sat May 8 08:17:06 2010 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. You can let Export prompt you for p

  • REP-0159 when run_product from oracle database 11-30

    Hi, I can`t open report from oracle database. I have this products (Windows NT 4): Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Report Builder 6.0.8.8.3 ORACLE Server R

  • Data transfer from oracle database(external database) to sap database 11-30

    Hi Abapers, I have a requirment like excel data upload from oracle database(external database) to SAP database .Plz any one can help me how to create a bdc program for this requarment. Advance thanks you. JnanaHI use function module 'ASLM_EXCEL_TO_IN