[teiid-issues] [JBoss JIRA] (TEIID-2995) procedure with inputs fails to be found when executed via odata

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-2995.
---------------------------------



> procedure with inputs fails to be found when executed via odata
> ---------------------------------------------------------------
>
>                 Key: TEIID-2995
>                 URL: https://issues.jboss.org/browse/TEIID-2995
>             Project: Teiid
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: OData
>            Reporter: Tom Johnston
>            Assignee: Steven Hawkins
>
> The following snippet is what is seen in the $metadata call
> {code}
> <ComplexType Name="getNominationbyRange_NewProcedureResult">
> <Property Name="WorkplanID" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/>
> <Property Name="RationaleComments" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/>
> </ComplexType>
> <EntityContainer Name="NominationRationaleVIEW" m:IsDefaultEntityContainer="false">
> <EntitySet Name="toLoadData" EntityType="NominationRationaleVIEW.toLoadData"/>
> <FunctionImport Name="getNominationbyRange" ReturnType="Collection(NominationRationaleVIEW.getNominationbyRange_NewProcedureResult)" m:HttpMethod="GET">
> <Parameter Name="StartNbr" Type="Edm.Int64" Mode="In" Nullable="false"/>
> <Parameter Name="EndNbr" Type="Edm.Int64" Mode="In" Nullable="false"/>
> </FunctionImport>
> </EntityContainer>
> {code}
> the ERROR is:
> {code}
> <error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
> <code>NotFoundException</code>
> <message lang="en-US">
> TEIID16011 EntitySet "NominationRationaleVIEW.getNominationbyRange" is not found; Check the spelling, use modelName.tableName; The table that representing the Entity type must either have a PRIMARY KEY or UNIQUE key(s)
> </message>
> </error>
> {code}
> the sample URL I'm trying is:
> http://127.0.0.1:8180/odata/POC_VDB/NominationRationaleVIEW.getNominationbyRange(StartNbr=1000,EndNbr=1000)



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)