BizTalk Server - XML created by SQL Report Server Not Validating in BizTalk 2004

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server > March 2005 > XML created by SQL Report Server Not Validating in BizTalk 2004





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author XML created by SQL Report Server Not Validating in BizTalk 2004
mj

2005-03-10, 5:54 pm

Hello,
I have XML docs that are created by SQL Report Server. I am trying to
validate the xml docs in BizTalk 2004 and am having problems with trying to
validate them. The Errors I get "Could not find schema information for the
attributes 'INAME'
Could not find schema information for the attributes 'Iadd1'
etc. "

Here is example of schema:
<?xml version="1.0" encoding="utf-16"?>
<xs:schema xmlns="http://CompanyName.CompanyNameSchema"
xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
attributeFormDefault="unqualified" elementFormDefault="unqualified"
targetNamespace="http://CompanyName.CompanyNameSchema"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Reports">
<xs:complexType>
<xs:sequence>
<xs:element form="unqualified" name="Records">
<xs:complexType>
<xs:sequence>
<xs:element form="unqualified" name="Collection">
<xs:complexType>
<xs:sequence minOccurs="0" maxOccurs="1">
<xs:element minOccurs="0" maxOccurs="unbounded"
form="unqualified" name="Items">
<xs:complexType>
<xs:attribute default="null" name="NUM"
type="xs:string" />
<xs:attribute default="Null" name="Batch"
type="xs:string" />
<xs:attribute default="Null" name="EFFECTIVE"
type="xs:string" />
<xs:attribute default="Null" name="EXPDTE"
type="xs:string" />
<xs:attribute default="Null" name="Iphone"
type="xs:string" />
<xs:attribute default="000-000-0000" name="RPhone"
type="xs:string" />
<xs:attribute default="Null" name="CLASS"
type="xs:string" />
<xs:attribute default="Null" name="CDescription"
type="xs:string" />
<xs:attribute default="Null" name="EXP"
type="xs:string" />
<xs:attribute default="Null" name="EBASIS"
type="xs:string" />
<xs:attribute default="Null" name="INAME"
type="xs:string" />
<xs:attribute default="Null" name="DBA"
type="xs:string" />
<xs:attribute default="Null" name="Iadd1"
type="xs:string" />
<xs:attribute default="Null" name="Iadd2"
type="xs:string" />
<xs:attribute default="Null" name="STATE"
type="xs:string" />
<xs:attribute default="0" name="TYPE"
type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:schema>

Thank you in advance for any help!
--
mj
Matt Milner

2005-03-10, 5:54 pm

I'll ask the obvious question: does the schema you are using to validate
these documents have those attributes defined? Remember, XML is case
sensitive.

Matt


"mj" <mj@newsgroup.nospam> wrote in message
news:5E53D06A-11F2-4F2E-816F-C90444BDB738@microsoft.com...
> Hello,
> I have XML docs that are created by SQL Report Server. I am trying to
> validate the xml docs in BizTalk 2004 and am having problems with trying
> to
> validate them. The Errors I get "Could not find schema information for
> the
> attributes 'INAME'
> Could not find schema information for the attributes 'Iadd1'
> etc. "
>
> Here is example of schema:
> <?xml version="1.0" encoding="utf-16"?>
> <xs:schema xmlns="http://CompanyName.CompanyNameSchema"
> xmlns:b="http://schemas.microsoft.com/BizTalk/2003"
> attributeFormDefault="unqualified" elementFormDefault="unqualified"
> targetNamespace="http://CompanyName.CompanyNameSchema"
> xmlns:xs="http://www.w3.org/2001/XMLSchema">
> <xs:element name="Reports">
> <xs:complexType>
> <xs:sequence>
> <xs:element form="unqualified" name="Records">
> <xs:complexType>
> <xs:sequence>
> <xs:element form="unqualified" name="Collection">
> <xs:complexType>
> <xs:sequence minOccurs="0" maxOccurs="1">
> <xs:element minOccurs="0" maxOccurs="unbounded"
> form="unqualified" name="Items">
> <xs:complexType>
> <xs:attribute default="null" name="NUM"
> type="xs:string" />
> <xs:attribute default="Null" name="Batch"
> type="xs:string" />
> <xs:attribute default="Null" name="EFFECTIVE"
> type="xs:string" />
> <xs:attribute default="Null" name="EXPDTE"
> type="xs:string" />
> <xs:attribute default="Null" name="Iphone"
> type="xs:string" />
> <xs:attribute default="000-000-0000" name="RPhone"
> type="xs:string" />
> <xs:attribute default="Null" name="CLASS"
> type="xs:string" />
> <xs:attribute default="Null" name="CDescription"
> type="xs:string" />
> <xs:attribute default="Null" name="EXP"
> type="xs:string" />
> <xs:attribute default="Null" name="EBASIS"
> type="xs:string" />
> <xs:attribute default="Null" name="INAME"
> type="xs:string" />
> <xs:attribute default="Null" name="DBA"
> type="xs:string" />
> <xs:attribute default="Null" name="Iadd1"
> type="xs:string" />
> <xs:attribute default="Null" name="Iadd2"
> type="xs:string" />
> <xs:attribute default="Null" name="STATE"
> type="xs:string" />
> <xs:attribute default="0" name="TYPE"
> type="xs:string" />
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> <xs:attribute name="Name" type="xs:string" />
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
> Thank you in advance for any help!
> --
> mj



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com