WS - SelectedSerialNumber.AddserialNum - SNFormat error

Yahoo Archive
1
Hi there! I am getting the following error when using
SelectedSerialNumber.AddSerialNumber in Service Connect.

<msg:source> A column named 'SNFormat' already belongs to this
DataTable: cannot set a nested table name to the same name.

Has anyone else run into this before. I would greatly appreciate your
insight in how you got around this. thank you so much!

Here is the request to the WS.
<msg:dta>
<dta:AddSerialNumRequest
xmlns:dta="http://Epicor.com/SelectedSerialNumberService/AddSerialNumReq\
uest">
<dta:CompanyID>USP</dta:CompanyID>
<dta:ds>
<SelectedSerialNumbersDataSet>
<SNFormat>
<PartNum>PB420625X65</PartNum>
<SNFormat>0900009</SNFormat>
<SNBaseDataType>INTEGER</SNBaseDataType>
<NumberOfDigits>5</NumberOfDigits>
<LeadingZeroes>true</LeadingZeroes>
<Company>USP</Company>
<SNPrefix>09</SNPrefix>
<HasSerialNumbers>true</HasSerialNumbers>
<RowIdent></RowIdent>
<RowMod>U</RowMod> (I have also tried Null and got the
same result)
</SNFormat>
</SelectedSerialNumbersDataSet>
</dta:ds>
<dta:partNum>PB420625X65</dta:partNum>
<dta:serialNum>0900098</dta:serialNum>
<dta:sourceRowID/>
<dta:transType/>
</dta:AddSerialNumRequest>
</msg:dta>

Here is the trace:
<tracePacket>

<businessObject>Epicor.Mfg.BO.SelectedSerialNumbers</businessObject>
<methodName>AddSerialNum</methodName>
<returnType>void</returnType>
<localTime>5/11/2009 14:08:28:4150000 PM</localTime>
<executionTime>62.5</executionTime>
<parameters>
<parameter name="ds"
type="Epicor.Mfg.BO.SelectedSerialNumbersDataSet">
<SelectedSerialNumbersDataSet
xmlns="http://www.epicor.com/Mfg/100/BO.SelectedSerialNumbers/SelectedSe\
rialNumbers">
<SNFormat>
<PartNum>PB420625X65</PartNum>
<SNFormat>0900009</SNFormat>
<SNBaseDataType>INTEGER</SNBaseDataType>
<NumberOfDigits>5</NumberOfDigits>
<LeadingZeroes>true</LeadingZeroes>
<Company>USP</Company>
<SNPrefix>09</SNPrefix>
<HasSerialNumbers>true</HasSerialNumbers>
<RowIdent/>
<RowMod/>
</SNFormat>
</SelectedSerialNumbersDataSet>
</parameter>
<parameter name="partNum"
type="System.String"><![CDATA[PB420625X65]]></parameter>
<parameter name="serialNum"
type="System.String"><![CDATA[0900097]]></parameter>
<parameter name="sourceRowID" type="System.String"/>
<parameter name="transType" type="System.String"/>
</parameters>
<paramDataSetChanges/>
</tracePacket>

Cathlene Fishman
Wolffe & Associates



[Non-text portions of this message have been removed]