0

Jet Express won't read information with GL func.

Hi,

We have trouble with getting Jet Express to read from our database with SQL connection.
With the webservice connection, Jet Express can read and get the numbers but it's too slow with this connection.

In the Navision database, there has been giving permission to read information.
Anybody who knows what to do ??

Here is some information from the Jetlog:

2015-11-06 11.09.42.299 JetDispatcher.ValidateLicense: DataSource:
2015-11-06 11.09.42.300 LicenseManager.GetCurrentUserType: Data source name: No Data Source
2015-11-06 11.09.42.303 FunctionCache.TryFindResult: DesignMode: False
2015-11-06 11.09.42.309 FunctionCache.TryFindResult: Found: False
2015-11-06 11.09.42.310 JetDispatcher.EvaluateJetFunction: a
2015-11-06 11.09.42.313 JetDispatcher.EvaluateDataFunction: Sum
2015-11-06 11.09.42.313 DataSourceManager.OpenDataSource(string): Data source name:
2015-11-06 11.09.42.317 DataSourceManager.GetDataSource: Data source name: No Data Source
2015-11-06 11.09.42.318 DataSourceManager.GetDataSource: Creating data source…
2015-11-06 11.09.42.325 DataSourceManager.OpenDataSource(string): Data source type: NavisionSql
2015-11-06 11.09.42.327 DataSourceManager.OpenDataSource(IJetDataSource): Data source name: No Data Source
2015-11-06 11.09.42.327 DataSourceManager.OpenDataSource(IJetDataSource): Data source type: NavisionSql
2015-11-06 11.09.42.532 JetDispatcher.EvaluateDataFunction: Call Data Source ExecuteQuery
2015-11-06 11.09.43.817 SqlDataSource.TryGetSqlVersion: Database Version: 12.0.4213.0
2015-11-06 11.09.45.232 JetDispatcher.EvaluateDataFunction: Finish Data Source ExecuteQuery
2015-11-06 11.09.45.235 FunctionCache.CacheResult: Design mode: 'False' Functions in cache: '1'
2015-11-06 11.09.45.238 DataSourceManager.OpenDataSource(string): Data source name:
2015-11-06 11.09.45.239 DataSourceManager.GetDataSource: Data source name: No Data Source
2015-11-06 11.09.45.239 DataSourceManager.OpenDataSource(string): Data source type: NavisionSql
2015-11-06 11.09.45.239 DataSourceManager.OpenDataSource(IJetDataSource): Data source name: No Data Source
2015-11-06 11.09.45.239 DataSourceManager.OpenDataSource(IJetDataSource): Data source type: NavisionSql
2015-11-06 11.09.45.240 ReportManager.Drilldown: Drilling down
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(string): Data source name:
2015-11-06 11.09.45.268 DataSourceManager.GetDataSource: Data source name: No Data Source
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(string): Data source type: NavisionSql
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(IJetDataSource): Data source name: No Data Source
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(IJetDataSource): Data source type: NavisionSql
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(string): Data source name:
2015-11-06 11.09.45.268 DataSourceManager.GetDataSource: Data source name: No Data Source
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(string): Data source type: NavisionSql
2015-11-06 11.09.45.268 DataSourceManager.OpenDataSource(IJetDataSource): Data source name: No Data Source
2015-11-06 11.09.45.269 DataSourceManager.OpenDataSource(IJetDataSource): Data source type: NavisionSql

6 comments

Please sign in to leave a comment.