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

[Tom Johnston (JIRA)]

Tom Johnston created TEIID-2995:
-----------------------------------

             Summary: 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
          Components: OData
            Reporter: Tom Johnston
            Assignee: Steven Hawkins


The following snippet is what is seen in the $metadata call

<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>

the ERROR is:

<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>

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.3#6260)