将扩展的webservice终结点升级到系统协定3 (18.200.001)时抛出错误"View Results has BQL delegate“
提问于 2019-04-29 15:30:56
我们有一家使用我们扩展的webservice端点的EDI供应商。这些目前还都是6.1合约2。
我们尝试提供升级的18.200.001 Contract 3终结点，但它们在尝试从终结点提取数据时遇到错误"View Results has BQL delegate“。(终端通过GI收集大量库存数据。)
供应商告诉我们，如果这些是扩展的，而不是默认的，那么即使在旧的默认版本被弃用后，它们也应该继续工作。
他们还说:随着2018 Acumatica的更新，他们的优化使得几乎不可能像这些查询那样提取整个记录集。可能有一种方法可以关闭BQL委托，但您需要咨询Acumatica。
这是真的吗？我们是更好地让它们保持原样，还是有办法让它们在新合同中发挥作用？
下面是webservice端点使用的(升级后的) GI。
<GenericInquiryScreen>
<data-set>
<relations format-version="3" relations-version="20180809" main-table="GIDesign" stable-sharing="True" file-name="(Name)">
<link from="GIFilter (DesignID)" to="GIDesign (DesignID)" />
<link from="GIGroupBy (DesignID)" to="GIDesign (DesignID)" />
<link from="GIMassAction (DesignID)" to="GIDesign (DesignID)" />
<link from="GIMassUpdateField (DesignID)" to="GIDesign (DesignID)" />
<link from="GINavigationScreen (DesignID)" to="GIDesign (DesignID)" />
<link from="GINavigationParameter (DesignID, ScreenID)" to="GINavigationScreen (DesignID, ScreenID)" />
<link from="GIOn (DesignID, RelationNbr)" to="GIRelation (DesignID, LineNbr)" />
<link from="GIRecordDefault (DesignID)" to="GIDesign (DesignID)" />
<link from="GIRelation (DesignID, ParentTable)" to="GITable (DesignID, Alias)" />
<link from="GIRelation (DesignID, ChildTable)" to="GITable (DesignID, Alias)" />
<link from="GIResult (DesignID)" to="GIDesign (DesignID)" />
<link from="GIResult (ObjectName, DesignID)" to="GITable (Alias, DesignID)" />
<link from="GISort (DesignID)" to="GIDesign (DesignID)" />
<link from="GITable (DesignID)" to="GIDesign (DesignID)" />
<link from="GIWhere (DesignID)" to="GIDesign (DesignID)" />
<link from="SiteMap (Url)" to="GIDesign (DesignID)" type="WeakByUrl" linkname="toDesignById" baseurl="~/GenericInquiry/GenericInquiry.aspx" paramnames="id" />
<link from="SiteMap (Url)" to="GIDesign (Name)" type="WeakByUrl" linkname="toDesignByName" baseurl="~/GenericInquiry/GenericInquiry.aspx" />
<link from="ListEntryPoint (ListScreenID)" to="SiteMap (ScreenID)" />
<link from="SiteMap (ScreenID)" to="GIDesign (PrimaryScreenIDNew)" linkname="to1Screen" />
<link from="SiteMap (NodeID)" to="SiteMap (ParentID)" type="WeakToParent" recursive-nesting="yes" include-parents="False" />
<link from="FilterHeader (ScreenID)" to="SiteMap (ScreenID)" />
<link from="FilterRow (FilterID)" to="FilterHeader (FilterID)" />
<link from="PivotTable (NoteID)" to="FilterHeader (RefNoteID)" />
<link from="PivotField (ScreenID, PivotTableID)" to="PivotTable (ScreenID, PivotTableID)" />
<link from="MUIScreen (NodeID)" to="SiteMap (NodeID)" />
<link from="MUIWorkspace (WorkspaceID)" to="MUIScreen (WorkspaceID)" type="FromMaster" linkname="workspaceToScreen" split-location="yes" updateable="True" />
<link from="MUISubcategory (SubcategoryID)" to="MUIScreen (SubcategoryID)" type="FromMaster" updateable="True" />
<link from="MUITile (ScreenID)" to="SiteMap (ScreenID)" />
<link from="MUIWorkspace (WorkspaceID)" to="MUITile (WorkspaceID)" type="FromMaster" linkname="workspaceToTile" split-location="yes" updateable="True" />
<link from="MUIArea (AreaID)" to="MUIWorkspace (AreaID)" type="FromMaster" updateable="True" />
<link from="MUIPinnedScreen (NodeID, WorkspaceID)" to="MUIScreen (NodeID, WorkspaceID)" type="WeakIfEmpty" isEmpty="Username" />
<link from="MUIFavoriteWorkspace (WorkspaceID)" to="MUIWorkspace (WorkspaceID)" type="WeakIfEmpty" isEmpty="Username" />
<link from="GIDesign (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIFilter (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIFilter (NoteID)" to="GIFilterKvExt (RecordID)" type="RowKvExt" />
<link from="GIGroupBy (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIOn (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIRelation (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIResult (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIResult (NoteID)" to="GIResultKvExt (RecordID)" type="RowKvExt" />
<link from="GISort (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GITable (NoteID)" to="Note (NoteID)" type="Note" />
<link from="GIWhere (NoteID)" to="Note (NoteID)" type="Note" />
<link from="FilterHeader (NoteID)" to="Note (NoteID)" type="Note" />
</relations>
<layout>
<table name="GIDesign">
<table name="GIFilter" uplink="(DesignID) = (DesignID)">
<table name="Note" uplink="(NoteID) = (NoteID)" />
<table name="GIFilterKvExt" uplink="(NoteID) = (RecordID)" />
</table>
<table name="GIGroupBy" uplink="(DesignID) = (DesignID)">
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="GIMassAction" uplink="(DesignID) = (DesignID)" />
<table name="GIMassUpdateField" uplink="(DesignID) = (DesignID)" />
<table name="GINavigationScreen" uplink="(DesignID) = (DesignID)">
<table name="GINavigationParameter" uplink="(DesignID, ScreenID) = (DesignID, ScreenID)" />
</table>
<table name="GIRecordDefault" uplink="(DesignID) = (DesignID)" />
<table name="GISort" uplink="(DesignID) = (DesignID)">
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="GITable" uplink="(DesignID) = (DesignID)">
<table name="GIRelation" uplink="(DesignID, Alias) = (DesignID, ParentTable)">
<table name="GIOn" uplink="(DesignID, LineNbr) = (DesignID, RelationNbr)">
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="GIResult" uplink="(Alias, DesignID) = (ObjectName, DesignID)">
<table name="Note" uplink="(NoteID) = (NoteID)" />
<table name="GIResultKvExt" uplink="(NoteID) = (RecordID)" />
</table>
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="GIWhere" uplink="(DesignID) = (DesignID)">
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="SiteMap" uplink="(DesignID) = (Url)" recursion="(NodeID) = (ParentID)" linkname="toDesignById">
<table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" />
<table name="FilterHeader" uplink="(ScreenID) = (ScreenID)">
<table name="FilterRow" uplink="(FilterID) = (FilterID)" />
<table name="PivotTable" uplink="(RefNoteID) = (NoteID)">
<table name="PivotField" uplink="(ScreenID, PivotTableID) = (ScreenID, PivotTableID)" />
</table>
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="MUIScreen" uplink="(NodeID) = (NodeID)">
<table name="MUIPinnedScreen" uplink="(NodeID, WorkspaceID) = (NodeID, WorkspaceID)" />
</table>
<table name="MUITile" uplink="(ScreenID) = (ScreenID)" />
</table>
<table name="SiteMap" uplink="(Name) = (Url)" recursion="(NodeID) = (ParentID)" linkname="toDesignByName">
<table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" />
<table name="FilterHeader" uplink="(ScreenID) = (ScreenID)">
<table name="FilterRow" uplink="(FilterID) = (FilterID)" />
<table name="PivotTable" uplink="(RefNoteID) = (NoteID)">
<table name="PivotField" uplink="(ScreenID, PivotTableID) = (ScreenID, PivotTableID)" />
</table>
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="MUIScreen" uplink="(NodeID) = (NodeID)">
<table name="MUIPinnedScreen" uplink="(NodeID, WorkspaceID) = (NodeID, WorkspaceID)" />
</table>
<table name="MUITile" uplink="(ScreenID) = (ScreenID)" />
</table>
<table name="SiteMap" uplink="(PrimaryScreenIDNew) = (ScreenID)" recursion="(NodeID) = (ParentID)" linkname="to1Screen">
<table name="ListEntryPoint" uplink="(ScreenID) = (ListScreenID)" />
<table name="FilterHeader" uplink="(ScreenID) = (ScreenID)">
<table name="FilterRow" uplink="(FilterID) = (FilterID)" />
<table name="PivotTable" uplink="(RefNoteID) = (NoteID)">
<table name="PivotField" uplink="(ScreenID, PivotTableID) = (ScreenID, PivotTableID)" />
</table>
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="MUIScreen" uplink="(NodeID) = (NodeID)">
<table name="MUIPinnedScreen" uplink="(NodeID, WorkspaceID) = (NodeID, WorkspaceID)" />
</table>
<table name="MUITile" uplink="(ScreenID) = (ScreenID)" />
</table>
<table name="Note" uplink="(NoteID) = (NoteID)" />
</table>
<table name="MUIWorkspace">
<table name="MUIFavoriteWorkspace" uplink="(WorkspaceID) = (WorkspaceID)" />
</table>
<table name="MUISubcategory" />
<table name="MUIArea" />
</layout>
<data>
<GIDesign>
<row DesignID="f7069dfb-2aac-433f-828f-29fc8d32f9dc" Name="B2B-IN-ItemInventory-Synnex" FilterColCount="3" PageSize="0" NewRecordCreationEnabled="0" MassDeleteEnabled="0" AutoConfirmDelete="0" MassRecordsUpdateEnabled="0" MassActionsOnRecordsEnabled="0" ExposeViaOData="0" ExposeViaMobile="0">
<GITable Alias="RawPart" Name="PX.Objects.IN.InventoryItem">
<GIRelation LineNbr="4" ChildTable="INLocationStatus" IsActive="1" JoinType="I">
<GIOn LineNbr="4" ParentField="inventoryID" Condition="E " ChildField="inventoryID" Operation="A" />
</GIRelation>
</GITable>
<GITable Alias="INLocationStatus" Name="PX.Objects.IN.INLocationStatus">
<GIRelation LineNbr="5" ChildTable="INLocation" IsActive="1" JoinType="I">
<GIOn LineNbr="5" ParentField="locationID" Condition="E " ChildField="locationID" Operation="A" />
</GIRelation>
<GIResult LineNbr="3" SortOrder="3" IsActive="1" Field="qtyAvail" SchemaField="INLocationStatus.QtyAvail" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="b684871b-4807-4d66-91db-cec612910c9c" />
</GITable>
<GITable Alias="INLocation" Name="PX.Objects.IN.INLocation" />
<GITable Alias="INKitSpecStkDet" Name="PX.Objects.IN.INKitSpecStkDet">
<GIRelation LineNbr="3" ChildTable="RawPart" IsActive="1" JoinType="I">
<GIOn LineNbr="3" ParentField="compInventoryID" Condition="E " ChildField="inventoryID" Operation="A" />
</GIRelation>
</GITable>
<GITable Alias="INKitSpecHdr" Name="PX.Objects.IN.INKitSpecHdr">
<GIRelation LineNbr="2" ChildTable="INKitSpecStkDet" IsActive="1" JoinType="I">
<GIOn LineNbr="2" ParentField="kitInventoryID" Condition="E " ChildField="kitInventoryID" Operation="A" />
</GIRelation>
<GIRelation LineNbr="1" ChildTable="FinishedPart" IsActive="1" JoinType="I">
<GIOn LineNbr="1" ParentField="KitInventoryID" Condition="E " ChildField="InventoryID" Operation="A" />
</GIRelation>
</GITable>
<GITable Alias="INItemXRef" Name="PX.Objects.IN.INItemXRef">
<GIResult LineNbr="4" SortOrder="4" IsActive="1" Field="alternateID" SchemaField="INItemXRef.AlternateID" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="d49abd75-3796-4245-9920-d55d68d2dcf8" />
</GITable>
<GITable Alias="FinishedPart" Name="PX.Objects.IN.InventoryItem">
<GIRelation LineNbr="6" ChildTable="INItemXRef" IsActive="1" JoinType="I">
<GIOn LineNbr="6" ParentField="inventoryID" Condition="E " ChildField="inventoryID" Operation="A" />
</GIRelation>
<GIResult LineNbr="2" SortOrder="2" IsActive="1" Field="descr" SchemaField="FinishedPart.Descr" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="cf77c143-839f-426a-a99c-9eea30fa1814" />
<GIResult LineNbr="1" SortOrder="1" IsActive="1" Field="InventoryCD" SchemaField="FinishedPart.InventoryCD" IsVisible="1" DefaultNav="1" QuickFilter="0" FastFilter="1" RowID="69cdb4da-c09e-4a67-a235-ff865aa8ff4e" />
</GITable>
<GIWhere LineNbr="5" IsActive="1" DataFieldName="FinishedPart.itemStatus" Condition="E " IsExpression="1" Value1="NP" CloseBrackets=") " Operation="A" />
<GIWhere LineNbr="4" IsActive="1" OpenBrackets="( " DataFieldName="FinishedPart.itemStatus" Condition="E " IsExpression="1" Value1="AC" Operation="O" />
<GIWhere LineNbr="3" IsActive="1" DataFieldName="INItemXRef.bAccountID" Condition="E " IsExpression="0" Value1="SYNNE01" Operation="A" />
<GIWhere LineNbr="2" IsActive="1" DataFieldName="INLocation.locationCD" Condition="E " IsExpression="0" Value1="IOMAIN" Operation="A" />
<GIWhere LineNbr="1" IsActive="1" DataFieldName="INKitSpecStkDet.dfltCompQty" Condition="E " IsExpression="0" Value1="1.0" Operation="A" />
<SiteMap linkname="toDesignById">
<row Position="28" Title="IN-ItemInventory" Url="~/GenericInquiry/GenericInquiry.aspx?id=f7069dfb-2aac-433f-828f-29fc8d32f9dc" Expanded="0" IsFolder="0" ScreenID="B2GI0053" NodeID="968db91a-9cd3-4b04-87f2-15bd15d0bb8b" ParentID="e3e41d8f-4d7c-4e76-ae19-8faca25d7be7">
<SiteMap Position="828.75" Title="Hidden GIs for Webservice Endpoints" Expanded="1" IsFolder="0" NodeID="e3e41d8f-4d7c-4e76-ae19-8faca25d7be7">
<SiteMap Position="71" Title="Hidden" Url="~/Frames/Default.aspx" Expanded="0" IsFolder="0" ScreenID="HD000000" NodeID="84351bc9-bf6c-48b5-9dea-f8207283b64a">
<SiteMap Position="0" Title="Acumatica Company" Url="~/Frames/Default.aspx" Expanded="0" IsFolder="0" ScreenID="00000000" NodeID="00000000-0000-0000-0000-000000000000" />
</SiteMap>
</SiteMap>
</row>
</SiteMap>
</row>
</GIDesign>
</data>
</data-set>
</GenericInquiryScreen>
回答 1
Stack Overflow用户
回答已采纳
发布于 2019-04-29 17:25:52
根据我对您的消息的理解，您可能正在使用基于约定的API，尽管我不确定它是SOAP还是REST版本。
如果您正在使用泛型查询(GI)，那么为了正确地检索数据，您应该使用PUT方法而不是GET方法。
这里是显示更多详细信息的帮助页面。
对于SOAP版本，也可以执行相同的过程。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/55906487
复制
腾讯云开发者
