|
Home > Archive > BizTalk Server General > October 2004 > Generating SQL Schema problem
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 |
Generating SQL Schema problem
|
|
|
| I am using the SQL Adapter to try and generate a schema from a stored
procedure I have. I do include the xmldata at the end of the query but
still, I get an error when I'm in the SQL Transport Schema Generation Wizard
after I generate my SP and click next I get the following error:
Type 'http://www.w3.org/2001/XMLSchema:char' is not declared or not a simple
type. An error occurred at , (0, 0).
I haven't found anything online related to this error nor in any help
documentation. Can anyone help out with this one?
Thanks - Phil
| |
|
| I found the resolution shortly after my original post. The following was
posted by Larry Franks on 9/7 in a separate thread. I tried this and it
worked for me.
Regards, Phil
* * * *
You can workaround this issue by modifying the XDRtoXSD.xslt file shipped
with BizTalk. Find the line that says:
<xsl:template mode="convert-datatype"
match="@dt:type[.='char']">xs:char</xsl:template>
and change it to:
<xsl:template mode="convert-datatype"
match="@dt:type[.='char']">xs:string</xsl:template>
There should be a KB on this in the near future.
Larry Franks
* * * *
"phil" wrote:
> I am using the SQL Adapter to try and generate a schema from a stored
> procedure I have. I do include the xmldata at the end of the query but
> still, I get an error when I'm in the SQL Transport Schema Generation Wizard
> after I generate my SP and click next I get the following error:
>
> Type 'http://www.w3.org/2001/XMLSchema:char' is not declared or not a simple
> type. An error occurred at , (0, 0).
>
> I haven't found anything online related to this error nor in any help
> documentation. Can anyone help out with this one?
>
> Thanks - Phil
| |
| Balaji Thiagarajan 2004-10-28, 5:49 pm |
| here is the fix..
http://biztalkbits.blogspot.com/200...tor-wizard.html
--
Balaji Thiagarajan
MCP (BizTalk)
http://biztalkbits.blogspot.com
--
"phil" <phil@discussions.microsoft.com> wrote in message
news:97DFED51-504D-473D-9DC6-96B9366BC441@microsoft.com...
> I am using the SQL Adapter to try and generate a schema from a stored
> procedure I have. I do include the xmldata at the end of the query but
> still, I get an error when I'm in the SQL Transport Schema Generation
Wizard
> after I generate my SP and click next I get the following error:
>
> Type 'http://www.w3.org/2001/XMLSchema:char' is not declared or not a
simple
> type. An error occurred at , (0, 0).
>
> I haven't found anything online related to this error nor in any help
> documentation. Can anyone help out with this one?
>
> Thanks - Phil
|
|
|
|
|