Share
Report
30Hi,
I have made a modification to the AxdPurchaseRequisition query. I added a couple of datasources, because I need some name field to be returned which is not part of the default AxdPurchaseRequisition query result set. The picture below shows what I have added.
After updating the document service, refreshing the AIF services, and generating an incremental CIL, I enabled the new field on the outbound port data policy. The outbound port is configured to create an XML file with the fields that are enabled in the data policy.
However, when testing the outbound port, it failed to create the XML file. The AIF queue manager showed following error message.
Stack trace: Field 'NameSequence' in table 'DirPerson' has not been explicitly selected.
I find this odd, because I didn't add DirPerson.NameSequence as a field to my data source, since I actually don't need DirPerson.NameSequence in my XML file. But OK, if that's what it takes to solve this issue quickly, I am willing to add an extra field to the DirPartyTable datasource in my query. So, I did. Went through the entire update procedure again. But when running the test, I now get following error.
Stack trace: Field 'PersonalSuffix' in table 'DirPerson' has not been explicitly selected.
I'm not sure where this requirement comes from. I checked the data policy on my outbound port, and I see that all DirPartyTable fields are listed there, be it as not enabled and not required. Why are all these fields in the data policy, while I only added DirPartyTable.Name to the DirtPartyTable data source in my query? Is this perhaps the reason why I am getting the errors above? And if so, how can I solve this issue, without having to add all DirPartyTable fields to my query? Or is this just the way AX works?
Thanks
All responses (
Answers (
