|
Home > Archive > BizTalk Server Orchestration > May 2006 > Mapping
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]
|
|
| Umeshnath 2006-05-15, 1:14 pm |
| How I can map a field element to attribute.
The scenario is when we generate SQL service.XSD in 2006 the parametes are
coming as attribute and my source schema having field element. when I am
mapping it is ok and not giving any errors. The problem when processing the
XML file, BTS is not taking in filed format, it is taking only attribute
format. But my souce file is the form of filed.
Thanks in advance
Umeshnath
| |
| cyberkinser 2006-05-15, 1:14 pm |
| wont matter, as long as it is not a date, or another data type that your
trying to force into a column with data contsraints it then it wont matter,
in the mapper just drag over the element to the attribute and it will parse
it, like i said as long as it is not contrained by the data base regarding
types, (if it is you need to run your sql schema generator again to pick up
those data types) the attributes can go into elements and so on (not records
but element fields into attribute fields)
--
Brian Kinser
Senior Managing Consultant
briankinser@sbclobal.net
"Umeshnath" wrote:
> How I can map a field element to attribute.
> The scenario is when we generate SQL service.XSD in 2006 the parametes are
> coming as attribute and my source schema having field element. when I am
> mapping it is ok and not giving any errors. The problem when processing the
> XML file, BTS is not taking in filed format, it is taking only attribute
> format. But my souce file is the form of filed.
>
> Thanks in advance
> Umeshnath
| |
| cyberkinser 2006-05-15, 1:14 pm |
|
--
Brian Kinser
Senior Managing Consultant
Software Architects
BKinser@sark.com
"Umeshnath" wrote:
> How I can map a field element to attribute.
> The scenario is when we generate SQL service.XSD in 2006 the parametes are
> coming as attribute and my source schema having field element. when I am
> mapping it is ok and not giving any errors. The problem when processing the
> XML file, BTS is not taking in filed format, it is taking only attribute
> format. But my souce file is the form of filed.
>
> Thanks in advance
> Umeshnath
| |
| Umeshnath 2006-05-16, 7:13 am |
| I am not able to execute the source file as elements.I have generated XML
file from source schema nd put into the receive location, it was throwing
error the sp name couldn't find Pls find the below error details in bracket.
When I generate XML file of Sqlservicce.XSD and put in the receive location
,it was working fine.
(The first problem was BTS was taking the first field of my input schema as
the SP name,hence I changed the first field to the same as the name of SP.
Then I undeployed and deployed still it is pointing to the field EPCID (it
was the first field of input schema but no changed to the SP name). Now I
changed the position of EPCID filed but still it is pointing to the EPCID. I
don't know how it happens. I have undeplyed and uninstall the assembly,
restart the system.
Still it is pointing to the field EPCID instead of the SP. and I am gettign
the below error in event viewer
event id -5740
The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
Description="Could not find stored procedure 'EPCID'."
".
and with event id =5743
The adapter failed to transmit message going to send port
"Send_Event_SP_Port" with URL "SQL://DPSC10W100A/EPCISRepository/". It will
be retransmitted after the retry interval specified for this Send Port.
Details:"HRESULT="0x80040e14" Description="Could not find stored procedure
'EPCID'.")
"cyberkinser" wrote:
[vbcol=seagreen]
> wont matter, as long as it is not a date, or another data type that your
> trying to force into a column with data contsraints it then it wont matter,
> in the mapper just drag over the element to the attribute and it will parse
> it, like i said as long as it is not contrained by the data base regarding
> types, (if it is you need to run your sql schema generator again to pick up
> those data types) the attributes can go into elements and so on (not records
> but element fields into attribute fields)
>
>
> --
> Brian Kinser
> Senior Managing Consultant
> briankinser@sbclobal.net
>
>
> "Umeshnath" wrote:
>
| |
| dichasri@gmail.com 2006-05-24, 1:17 am |
| hi,
Were you able to solve this problem. I am getting a similar error, and
my problem is that I dont even have a stored procedure. It is just
looking at the first node and interpreting this as a stored procedure.
Any input in this regard would be great.
Thanks,
-Dinakar.
Umeshnath wrote:[vbcol=seagreen]
> I am not able to execute the source file as elements.I have generated XML
> file from source schema nd put into the receive location, it was throwing
> error the sp name couldn't find Pls find the below error details in bracket.
> When I generate XML file of Sqlservicce.XSD and put in the receive location
> ,it was working fine.
>
> (The first problem was BTS was taking the first field of my input schema as
> the SP name,hence I changed the first field to the same as the name of SP.
> Then I undeployed and deployed still it is pointing to the field EPCID (it
> was the first field of input schema but no changed to the SP name). Now I
> changed the position of EPCID filed but still it is pointing to the EPCID. I
> don't know how it happens. I have undeplyed and uninstall the assembly,
> restart the system.
> Still it is pointing to the field EPCID instead of the SP. and I am gettign
> the below error in event viewer
>
> event id -5740
>
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
> Description="Could not find stored procedure 'EPCID'."
> ".
>
> and with event id =5743
>
> The adapter failed to transmit message going to send port
> "Send_Event_SP_Port" with URL "SQL://DPSC10W100A/EPCISRepository/". It will
> be retransmitted after the retry interval specified for this Send Port.
> Details:"HRESULT="0x80040e14" Description="Could not find stored procedure
> 'EPCID'.")
>
>
>
> "cyberkinser" wrote:
>
| |
| dichasri@gmail.com 2006-05-24, 1:17 am |
| hi,
Were you able to solve this problem. I am getting a similar error, and
my problem is that I dont even have a stored procedure. It is just
looking at the first node and interpreting this as a stored procedure.
Any input in this regard would be great.
Thanks,
-Dinakar.
Umeshnath wrote:[vbcol=seagreen]
> I am not able to execute the source file as elements.I have generated XML
> file from source schema nd put into the receive location, it was throwing
> error the sp name couldn't find Pls find the below error details in bracket.
> When I generate XML file of Sqlservicce.XSD and put in the receive location
> ,it was working fine.
>
> (The first problem was BTS was taking the first field of my input schema as
> the SP name,hence I changed the first field to the same as the name of SP.
> Then I undeployed and deployed still it is pointing to the field EPCID (it
> was the first field of input schema but no changed to the SP name). Now I
> changed the position of EPCID filed but still it is pointing to the EPCID. I
> don't know how it happens. I have undeplyed and uninstall the assembly,
> restart the system.
> Still it is pointing to the field EPCID instead of the SP. and I am gettign
> the below error in event viewer
>
> event id -5740
>
> The adapter "SQL" raised an error message. Details "HRESULT="0x80040e14"
> Description="Could not find stored procedure 'EPCID'."
> ".
>
> and with event id =5743
>
> The adapter failed to transmit message going to send port
> "Send_Event_SP_Port" with URL "SQL://DPSC10W100A/EPCISRepository/". It will
> be retransmitted after the retry interval specified for this Send Port.
> Details:"HRESULT="0x80040e14" Description="Could not find stored procedure
> 'EPCID'.")
>
>
>
> "cyberkinser" wrote:
>
| |
| Umeshnath 2006-05-24, 7:15 am |
| Hi,
I am able to solve this problem.You change your sendport to file and check
the XML generated.Most cases XML file will generate correctly if not correct
the mapping as per your requirement. Then change to SQL Adapter it will work.
I am not aware of the reason why it is picking from the input schema. May be
some binding problem.Please let me know if you can resolve the issue .
mail me @
umeshnath@hotmail.com/umeshnath@hp.com
"dichasri@gmail.com" wrote:
> hi,
> Were you able to solve this problem. I am getting a similar error, and
> my problem is that I dont even have a stored procedure. It is just
> looking at the first node and interpreting this as a stored procedure.
> Any input in this regard would be great.
>
> Thanks,
> -Dinakar.
>
> Umeshnath wrote:
>
>
|
|
|
|
|