Error getting data from nav

gorvega79

hi all

We have a problem with nav server. we have a web site developed in csharp, this web is connected with nav by web services. we made a data base migration from 2009 R2 to nav2016. The problem is when we redirect the service url of the web config file from web site to Nav2016 database, the same web with 2009 r2 service Works perfectly.

The error is in this stack trace, and we don´t know what is doing.


Server instance: NAV2016_Pre
Tenant ID:
User:
Type: Microsoft.Dynamics.Nav.Types.Exceptions.NavNotSupportedException
SuppressMessage: False
SuppressExceptionCreatedEvent: False
FatalityScope: None
Message: A flow field is part of the query column list, this is not supported
StackTrace:
at Microsoft.Dynamics.Nav.Runtime.NavSqlQueryCommand.CheckQueryCapabilities(NCLMetaQueryDefinition query)
at Microsoft.Dynamics.Nav.Runtime.NavSqlQueryCommand.EnsureCommandIsCreatedAndPrepared(NCLMetaQueryDefinition query, FilterExpression queryAndPositioningFilter, FilterExpression filterOnlyColumnFilters, FilterFieldDictionary queryFiltersOnFlowFilters, Dictionary`2 globalAndSecurityFilters, Boolean addExplicitJoinHints)
at Microsoft.Dynamics.Nav.Runtime.NavSqlQueryCommand.<>c__DisplayClass2e.<QueryExecute>b__2c()
at Microsoft.Dynamics.Nav.Runtime.NavSqlConnection.ExecuteCommandAndCacheOnSuccess[T](NavSqlCommandCacheKey commandKey, Func`1 createFunc, Func`2 executeFunc)
at Microsoft.Dynamics.Nav.Runtime.NavSqlQueryCommand.QueryExecute(NavSqlConnectionScope conScope, NCLMetaQueryDefinition query, NavDatabase database, Int32 companyToken, Int32 topNumberOfRowsToReturn, FiltersAndMarks queryFilters, TableFilterDictionary globalAndSecurityFilters, Boolean includeCurrent, MutableRecordBuffer startingPosition, SecurityFiltering securityFiltering, Boolean addExplicitJoinHints)
at Microsoft.Dynamics.Nav.Runtime.NavSqlQueryCommand.<Query>d__30.MoveNext()
at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at Microsoft.Dynamics.Nav.Runtime.ResultSet.TryGetAtIndex(Int32 index, ReadOnlyRecordBuffer& recordBuffer)
at Microsoft.Dynamics.Nav.Runtime.ResultSetEnumerator.TryMoveNextImpl(MutableRecordBuffer& recordBuffer)
at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.Advance(Int32 steps, Boolean moveBackwards, Boolean automaticFindFromPositionOnInvalid, Boolean& resultSetValid)
at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.IssueFindRequest(DataError errorLevel, Boolean reversed, FindType findType, Boolean useCache)
at Microsoft.Dynamics.Nav.Runtime.RecordImplementation.FindRecordImp(DataError errorLevel, String searchMethod)
at Microsoft.Dynamics.Nav.Runtime.NavRecord.ALFind(DataError errorLevel, String searchMethod)
at Microsoft.Dynamics.Nav.Runtime.NavForm.FindRecord(String which)
at Microsoft.Dynamics.Nav.Service.WebServices.ServiceForm.MoveFirst()
at Microsoft.Dynamics.Nav.Service.WebServices.ServiceForm.Fetch(String lastKnownKey, Int32 numberOfEntities, DoWork callBack)
at Microsoft.Dynamics.Nav.Service.WebServices.XmlWWriter.Element(String name, XmlCallback elementHandler)
at Microsoft.Dynamics.Nav.Service.WebServices.XmlWWriter.Element(String name, XmlCallback elementHandler)
at Microsoft.Dynamics.Nav.Service.WebServices.XmlWWriter.SetNamespace(QNamespace namespace, XmlCallback nodeHandler)
at Microsoft.Dynamics.Nav.Service.WebServices.ServiceFormXmlAdapter.ReadMultiple(XmlElement input, XmlWWriter output)
--- End of stack trace from previous location where exception was thrown ---
at Microsoft.Dynamics.Nav.Service.WebServices.ServiceBroker.Invoke(Boolean isSoapMessage, Uri url, XmlReader input, TextWriter output, NavUserAuthentication navUserAuth)
at Microsoft.Dynamics.Nav.Service.WebServices.NavWebService.<>c__DisplayClass5.<>c__DisplayClass7.<ProcessMessage>b__3()
at Microsoft.Dynamics.Nav.Service.WebServices.Disposer.Scope(Code code)
at Microsoft.Dynamics.Nav.Service.WebServices.NavWebService.ProcessMessage(Message message)
at SyncInvokeProcessMessage(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
Source: Microsoft.Dynamics.Nav.Ncl
HResult: -2146233088

thanks in advance for your help

Regards!!!!

postsaurav

Hi,

It seems you were using Page web service in 2009 R2 and Now in 2016 you are using a Query Object to Publish Data as web service.

I found that in NAV 2015, discussed here -
http://saurav-nav.blogspot.in/2015/11/nav-2015-error-while-consuming-query.html

But your question clarify one doubt that Microsoft have added that in event viewer

Try using a Page web services and let me know finding.

gorvega79

thanks for the response postsaurav

but we haven´t published a query, our page is a list from a record only to show its records, only have one dataItem one repeater group, nothing more is very simple.

if we change the definition of the field to normal field the page Works perfectly but doesn´t work with that flow field.

regards.

ACaignie

I don't know if this is still an issue, but I have the same problem. The reason is a flowfield on a field that is also a flowfield. This is supported in NAV2009, but apparently not in NAV2016/2017