XML parsing error - character 17489

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

XML parsing error - character 17489

Author

Topic

Mathias
Posting Yak Master

119 Posts

Posted - 2009-12-10 : 04:49:57

I have an error with the following and I cannot find where it is wrong. It has been working already more than thousand times but not this time. Any clue?

select cast('<?xml version="1.0" encoding="UTF-8"?><SBS xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bcl.lu/2007/SBS ../SBS.OBS.xsd" creationDateTime="2009-12-10T10:22:02.817" version="1.0" xmlns="http://www.bcl.lu/2007/SBS"><header><endMonthDate>2009-10-31</endMonthDate><closingDate>2009-10-31</closingDate><reporterID><type>23</type><code>167</code></reporterID><declarantID><type>26</type><code>047440001</code></declarantID><reportingCurrency>USD</reportingCurrency></header><OBS><assets><reportedLine><id><item>1-051</item><country>XX</country><currency>XXX</currency><sector>90000</sector></id><ISIN><security><securityID><codeType>1</codeType><code>KYG0219V1014</code></securityID><holdSecurityType>01</holdSecurityType><equity><currencyQuoted><numberOfUnits>2665.0932</numberOfUnits></currencyQuoted></equity><reportedAmount>982312.05000</reportedAmount></security><security><securityID><codeType>1</codeType><code>KYG405081228</code></securityID><holdSecurityType>01</holdSecurityType><equity><currencyQuoted><numberOfUnits>561.7800</numberOfUnits></currencyQuoted></equity><reportedAmount>876888.02000</reportedAmount></security></ISIN><totalReportedAmount>1859200.07000</totalReportedAmount></reportedLine><reportedLine><id><item>1-052</item><country>XX</country><currency>XXX</currency><sector>90000</sector></id><other><security><securityID><codeType>2</codeType><code>DK23956</code><name>Centaurus International Risk Arbitrage Fund Ltd Cl USD Shares Sub Cl 1</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>6975.2436</numberOfUnits></currencyQuoted></equity><reportedAmount>820179.55000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D054754</code><name>Claren Road Credit Fund Ltd Cl B Ser 1</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1151.6212</numberOfUnits></currencyQuoted></equity><reportedAmount>1752027.73000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK33851</code><name>Davidson Kempner Distressed Opportunities International Ltd Cl B Ser 0108</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1318.2772</numberOfUnits></currencyQuoted></equity><reportedAmount>2206166.78000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK78879</code><name>Davidson Kempner Distressed Opportunities International Ltd Cl S NNI Ser 1208</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>52.4908</numberOfUnits></currencyQuoted></equity><reportedAmount>28708.01000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK78937</code><name>Davidson Kempner International Ltd Cl S (C & D) Ser 12/2008</name><currency>USD</currency></securityID><issuerID><country>VG</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>306.8684</numberOfUnits></currencyQuoted></equity><reportedAmount>22667.30000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK78921</code><name>Davidson Kempner International Ltd Cl S Ser 12/2008</name><currency>USD</currency></securityID><issuerID><country>VG</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1335.7880</numberOfUnits></currencyQuoted></equity><reportedAmount>99133.00000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK88687</code><name>Discus Feeder Ltd Cl B USD Standard Leverage</name><currency>USD</currency></securityID><issuerID><country>VG</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1139.9184</numberOfUnits></currencyQuoted></equity><reportedAmount>1376747.85000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK68455</code><name>Longchamp Market Neutral Fund Ltd Ser 33</name><currency>USD</currency></securityID><issuerID><country>VG</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>183.3730</numberOfUnits></currencyQuoted></equity><reportedAmount>1598158.52000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK23695</code><name>Lynx (Bermuda) Ltd Cl A Ser Apr 09</name><currency>USD</currency></securityID><issuerID><country>BM</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>600.0000</numberOfUnits></currencyQuoted></equity><reportedAmount>585798.63000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D077226</code><name>MKM Longboat Multi-Strategy Fund Ltd Cl N (Non Voting )New Issue</name><currency>USD</currency></securityID><issuerID><country>IE</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>487.3200</numberOfUnits></currencyQuoted></equity><reportedAmount>16179.72000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D082786</code><name>MKM Longboat Multi-Strategy Fund Ltd USD Cl R (Non Voting) NNI</name><currency>USD</currency></securityID><issuerID><country>IE</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>620.1600</numberOfUnits></currencyQuoted></equity><reportedAmount>20956.19000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK44131</code><name>Marshall Wace TOPS Fund Limited Cl N</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>9330.0000</numberOfUnits></currencyQuoted></equity><reportedAmount>920404.50000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK79282</code><name>Moore Emerging Fixed Income And Currency Fund Ltd Cl A</name><currency>USD</currency></securityID><issuerID><country>BS</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>761.8540</numberOfUnits></currencyQuoted></equity><reportedAmount>816297.09000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D077399</code><name>One East Partners International Ltd Cl A1 GMAC - Side Pocket</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>138.6601</numberOfUnits></currencyQuoted></equity><reportedAmount>16536.45000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK77031</code><name>One East Partners International Ltd Cl CH A2 Ser SP</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>136.7324</numberOfUnits></currencyQuoted></equity><reportedAmount>17374.37000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK67725</code><name>One East Partners International Ltd Cl DA Ser 0608 (7-1-08)</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>422.5249</numberOfUnits></currencyQuoted></equity><reportedAmount>212841.22000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK34163</code><name>One East Partners International Ltd Cl IS Ser A SP3</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>116.9970</numberOfUnits></currencyQuoted></equity><reportedAmount>77248.83000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK67988</code><name>One East Partners International Ltd Ser One East Holdback</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>125.6209</numberOfUnits></currencyQuoted></equity><reportedAmount>90959.19000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK29062</code><name>Pharo Macro Fund Ltd Cl A Ser 07 July 09</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>275.5060</numberOfUnits></currencyQuoted></equity><reportedAmount>561288.10000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS01199</code><name>Plexus Fund Ltd A2</name><currency>USD</currency></securityID><issuerID><country>US</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>4354.8100</numberOfUnits></currencyQuoted></equity><reportedAmount>302801.61000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D056687</code><name>Plexus Fund Ltd Cl A-3</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>7319.8900</numberOfUnits></currencyQuoted></equity><reportedAmount>362776.66000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DH00453</code><name>Polygon Global Opportunities Fund Cl B</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>7254.5562</numberOfUnits></currencyQuoted></equity><reportedAmount>328338.56000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS12078</code><name>Polygon Global Opportunities Fund Cl D</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>10006.5117</numberOfUnits></currencyQuoted></equity><reportedAmount>452704.13000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK90688</code><name>Gartmore Investment Funds - Gartmore UK Absolute Return Fund Class Institutional</name><currency>GBP</currency></securityID><issuerID><country>GB</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>510941.8700</numberOfUnits></currencyQuoted></equity><reportedAmount>898835.66000</reportedAmount></security><security><securityID><codeType>2</codeType><code>3256015</code><name>Sark Fund Ltd (USD)</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>7597.2642</numberOfUnits></currencyQuoted></equity><reportedAmount>1214090.68000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK23937</code><name>Exane Funds 1 -Templier Fund Cl A</name><currency>EUR</currency></securityID><issuerID><country>FR</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>37.2641</numberOfUnits></currencyQuoted></equity><reportedAmount>920320.99000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK23935</code><name>Alphadyne Global Rates Fund Ltd Cl B Sub Cl 1 Ser 2009-07</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>800.0000</numberOfUnits></currencyQuoted></equity><reportedAmount>851124.42000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK77334</code><name>Alphadyne Investment Strategies Fund Ltd Cl B Ser 1</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1213.6698</numberOfUnits></currencyQuoted></equity><reportedAmount>1643932.94000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK89395</code><name>Amber Fund (Cayman) Ltd Cl J Ser Initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>573.1443</numberOfUnits></currencyQuoted></equity><reportedAmount>288325.10000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK44451</code><name>Arrowgrass Intl Fund Ltd Cl B USD NNI Ser Mar 08 Initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>9585.0618</numberOfUnits></currencyQuoted></equity><reportedAmount>1204210.27000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK78428</code><name>Bluegold Global Fund Inc Cl A USD Non New Issue</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1124.7966</numberOfUnits></currencyQuoted></equity><reportedAmount>536339.12000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DH38690</code><name>Brevan Howard Asia Fund Ltd USD Cl</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>6167.5900</numberOfUnits></currencyQuoted></equity><reportedAmount>1098324.42000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK44497</code><name>Brevan Howard Emerging Markets Strategies Fund Ltd Cl A USD</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>10564.0460</numberOfUnits></currencyQuoted></equity><reportedAmount>1444633.29000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS74770</code><name>Brevan Howard Fund Ltd Cl A (USD)</name><currency>USD</currency></securityID><issuerID><country>US</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>3871.3900</numberOfUnits></currencyQuoted></equity><reportedAmount>988636.86000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DQ59082</code><name>CLAREN ROAD Credit Fund Ltd CL Interests – Series 1 Payable</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>0.5000</numberOfUnits></currencyQuoted></equity><reportedAmount>459436.00000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D064143</code><name>COMAC Global Macro Fund Ltd USD</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>8611.0030</numberOfUnits></currencyQuoted></equity><reportedAmount>1310216.58000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS51963</code><name>Capula Global Relative Value Fund Ltd Cl A USD</name><currency>USD</currency></securityID><issuerID><country>US</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>10123.0001</numberOfUnits></currencyQuoted></equity><reportedAmount>1780129.56000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK69318</code><name>Carrousel Fund Ltd (The) Cl H Ser II A initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>14329.3097</numberOfUnits></currencyQuoted></equity><reportedAmount>1167027.70000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK28909</code><name>Carrousel Fund Ltd Cl H Ser E Initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>12796.2246</numberOfUnits></currencyQuoted></equity><reportedAmount>1330832.95000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS56066</code><name>Cazenove Leveraged UK Equity Absolute Return Fund Ltd Cl B (USD)</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>1140.0864</numberOfUnits></currencyQuoted></equity><reportedAmount>1636347.65000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS67858</code><name>Prologue Feeder Fund Ltd USD Cl A Ser Initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>902.7500</numberOfUnits></currencyQuoted></equity><reportedAmount>1377062.80000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DH38681</code><name>QVT Overseas Ltd S7 - GMAC</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>12.3810</numberOfUnits></currencyQuoted></equity><reportedAmount>2437.27000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DT29636</code><name>QVT Overseas Ltd S8 - Emerging Markets</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>14.2659</numberOfUnits></currencyQuoted></equity><reportedAmount>33580.19000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS36646</code><name>QVT Overseas Ltd Ser 1 Biosynexus</name><currency>USD</currency></securityID><issuerID><country>US</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>55.5210</numberOfUnits></currencyQuoted></equity><reportedAmount>41568.15000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK66550</code><name>Stratus Feeder Ltd Cl B USD Standard Leverage</name><currency>USD</currency></securityID><issuerID><country>VG</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>860.0017</numberOfUnits></currencyQuoted></equity><reportedAmount>1122663.42000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS08402</code><name>Treesdale Fixed Income Fund Ltd Cl B Ser 1</name><currency>USD</currency></securityID><issuerID><country>US</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>9401.9260</numberOfUnits></currencyQuoted></equity><reportedAmount>799067.74000</reportedAmount></security><security><securityID><codeType>2</codeType><code>D032500</code><name>York European Opportunities Unit Trust Cl A Ser 1</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>01</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>105016.7688</numberOfUnits></currencyQuoted></equity><reportedAmount>1396723.02000</reportedAmount></security></other><totalReportedAmount>36232160.77000</totalReportedAmount></reportedLine></assets><liabilities><reportedLine><id><item>2-025</item><country>XX</country><currency>XXX</currency><sector>90000</sector></id><other><security><securityID><codeType>2</codeType><code>DK69318</code><name>Carrousel Fund Ltd (The) Cl H Ser II A initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>05</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>14329.3097</numberOfUnits></currencyQuoted></equity><reportedAmount>1167027.70000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK28909</code><name>Carrousel Fund Ltd Cl H Ser E Initial</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>05</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>12796.2246</numberOfUnits></currencyQuoted></equity><reportedAmount>1330832.95000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DK68455</code><name>Longchamp Market Neutral Fund Ltd Ser 33</name><currency>USD</currency></securityID><issuerID><country>VG</country><sector>41112</sector></issuerID><holdSecurityType>05</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>48.2220</numberOfUnits></currencyQuoted></equity><reportedAmount>420271.24000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DH00453</code><name>Polygon Global Opportunities Fund Cl B</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>05</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>7254.5562</numberOfUnits></currencyQuoted></equity><reportedAmount>328338.56000</reportedAmount></security><security><securityID><codeType>2</codeType><code>DS12078</code><name>Polygon Global Opportunities Fund Cl D</name><currency>USD</currency></securityID><issuerID><country>KY</country><sector>41112</sector></issuerID><holdSecurityType>05</holdSecurityType><equity><supplements><securityType>F.52</securityType></supplements><currencyQuoted><numberOfUnits>10006.5117</numberOfUnits></currencyQuoted></equity><reportedAmount>452704.13000</reportedAmount></security></other><totalReportedAmount>3699174.58000</totalReportedAmount></reportedLine><reportedLine><id><item>2-040</item><country>XX</country><currency>XXX</currency><sector>90000</sector></id><ISIN><security><securityID><codeType>1</codeType><code>LU0305321985</code></securityID><holdSecurityType>04</holdSecurityType><equity><currencyQuoted><numberOfUnits>24137.5500</numberOfUnits></currencyQuoted></equity><reportedAmount>4475039.00000</reportedAmount></security><security><securityID><codeType>1</codeType><code>LU0305322363</code></securityID><holdSecurityType>04</holdSecurityType><equity><currencyQuoted><numberOfUnits>63173.7500</numberOfUnits></currencyQuoted></equity><reportedAmount>14834406.65000</reportedAmount></security><security><securityID><codeType>1</codeType><code>LU0305323254</code></securityID><holdSecurityType>04</holdSecurityType><equity><currencyQuoted><numberOfUnits>97318.9600</numberOfUnits></currencyQuoted></equity><reportedAmount>17818835.62000</reportedAmount></security><security><securityID><codeType>1</codeType><code>LU0331687995</code></securityID><holdSecurityType>04</holdSecurityType><equity><currencyQuoted><numberOfUnits>100.0000</numberOfUnits></currencyQuoted></equity><reportedAmount>13797.64000</reportedAmount></security><security><securityID><codeType>1</codeType><code>LU0305323767</code></securityID><holdSecurityType>04</holdSecurityType><equity><currencyQuoted><numberOfUnits>33882.5300</numberOfUnits></currencyQuoted></equity><reportedAmount>4673413.59000</reportedAmount></security><security><securityID><codeType>1</codeType><code>LU0328111835</code></securityID><holdSecurityType>04</holdSecurityType><equity><currencyQuoted><numberOfUnits>915.0000</numberOfUnits></currencyQuoted></equity><reportedAmount>781229.60000</reportedAmount></security></ISIN><totalReportedAmount>42596722.10000</totalReportedAmount></reportedLine></liabilities></OBS></SBS>' as xml)

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-12-10 : 04:54:56

HI

Don't you need to escape special characters like &, <, > etc. if they are to
appear inside XML tags.

-------------------------
R...

Mathias
Posting Yak Master

119 Posts

Posted - 2009-12-10 : 05:06:50

The XML should be clean, those characters should be properly treated already. I have thousand examples were it does work and I dont see any difference.

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2009-12-10 : 05:39:06

No, it does have a character escaping problem. There is a security with name "Davidson Kempner International Ltd Cl S (C & D) Ser 12/2008".
Both the ampersand & and less-than < characters must be escaped in text content of elements.

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2009-12-10 : 05:50:21

There's also a dodgy hyphen here: 'CLAREN ROAD Credit Fund Ltd CL Interests – Series 1 Payable'

Ryan Randall - Yak of all trades
Solutions are easy. Understanding the problem, now, that's the hard part.

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2009-12-10 : 17:05:36

Sorry! Ryan's right, the character at that position (17489) is the en-dash (U+2013), not the ampersand.
Come to think of it, I bet you are escaping the ampersands & the forum software here is reinterpreting them.

In that case, the problem is the 'mismatch' between the encoding attribute of the XML declaration and the presence of a non-ASCII character. I don't really understand why SQL Server tries to do something with the encoding attribute when the source of the conversion is a SQL string, but it certainly does (See BOL: Using XML Data Types).

Anyway, if the value you're converting to xml is a SQL string of some kind, like your example, then the encoding should either match (UTF-16 for nvarchar, etc. and usually windows-1252 for varchar, etc) or be omitted. If the value is coming from outside SQL, the BOL article I mentioned has the gory details.

Mathias
Posting Yak Master

119 Posts

Posted - 2009-12-11 : 08:39:40

Thank for your help

In fact, you can see the behavior in Word when you type
'something - something else', it will change the hypen. One is ascii 45, one is ascii 150.

I had to do replace(INVESTMENT, char(150), char(45)), it looks the same but it is not the same, like Canada dry

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources