About oData service error.

Business Central/NAV Developers Forum
1

Hi Expert.

Recently we need provide the data for power bi, but when we connect to odata url, the nas will be stopped. , i checked the system event viewer. the error message below:

Server instance: DynamicsNAV90
Tenant ID: 
User: 
Type: System.InvalidOperationException
Message: A property with same name 'No' already exists in type 'NAV.ERPPOCSale'. Please make sure that there is no property with the same name defined in one of the base types.
StackTrace:
at System.Data.Services.Providers.ResourceType.AddPropertyInternal(ResourceProperty property)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataMetadataExtensions.GenerateResourceTypePage(String name, String nameSpace, Int32 objectId, MetaPage metaPage)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataMetadataExtensions.AddPageServiceMetadata(ODataMetadata metadata, String serviceName, Int32 pageId)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.ODataMetadataProvider.CreateResourceTypesForPublishedServices(NavSession session)
at Microsoft.Dynamics.Nav.Service.ODataServiceProvider.NavServiceHelper.ExecuteOperation[TResult,T1,T2](String companyName, ODataOperation`3 operation, T1 parameter1, T2 parameter2, Boolean isDefaultCompanyRequired)
Source: Microsoft.Data.Services
HResult: -2146233079

But the soap web service is ok.

such as :

xsd:sequence

<xsd:element minOccurs=“0” maxOccurs=“1” name=“Key” type=“xsd:string”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Document_No” type=“xsd:string”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Line_No” type=“xsd:int”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“No” type=“xsd:string”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Description” type=“xsd:string”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Quantity” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Unit_Price” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“VAT_Percent” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Amount” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Amount_Including_VAT” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Quantity_Shipped” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Quantity_Invoiced” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Quantity_Base” type=“xsd:decimal”/>
<xsd:element minOccurs=“0” maxOccurs=“1” name=“Unit_of_Measure_Code” type=“xsd:string”/>

</xsd:sequence>

any suggestion will be appreciated.

2

Could you copy the query you are exposing from NAV?
It could be something in the naming af elements

3

thanks for your reply, i used the web service of sales order page.

4

it does not look like it is the standard sales order page,
“A property with same name ‘No’ already exists in type ‘NAV.ERPPOCSale’. Please make sure that there is no property with the same name defined in one of the base types.”
Can you check that you don have multiple fields called “No.” ?