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
-
Jet Reports Historic Posts Hello Nordmand28,
There isn't anything in that section of the log that details what may be causing your issue.
Have you tested the GL() function with a user that is a SUPER user in NAV to see if the issue may be related to permissions?
Are you using a specific NAV vertical like Serenic?
Best regards,
MWilson -
Jet Reports Historic Posts Hi MWilson,
See attached file for full Jetlog
My user is only SUPER user in NAV.
Test connection in Jet reports doesn't comes with any error messages and i can see and choose my database and company.
So it looks like my connection to the server is ok but for some reason it can't read a balance of an account. -
Jet Reports Historic Posts Hello Nordmand28,
You noted that you were trying to retrieve the balance of any account.
Have you tried the GL(Balance) function, it appears that you are using the GL(Budget) function.
Best regards,
MWilson -
Jet Reports Historic Posts Hi MWilson,
Im using GL balance and when im connected through the webservice it works.
See attached file.
The only thing is that the webservice is too slow.
Takes 1 minute to refresh the report so we need to connect with the SQLserver method.
Kind regards
Nordmand28 -
Jet Reports Historic Posts Hello Nordmand28,
It appears that the GL() function is working with the SQL Server connection but it is returning 0 values (rather than #VALUE).
Can you ensure that you are connected to the same Database that the Web Services Data Source is connected to.
To see which database the Web Services Data Source is connected to open the Dynamics NAV Administration Console.
Select your NAV instance and look at the Server\Instance\Database listed.
Ensure that the Server\Instance and Database are the same in the Jet Data Source Settings for the SQL Server Data Source.
Best regards,
MWilson -
Jet Reports Historic Posts Hi MWilson,
It's the same Server and database with SQL data source as with Web services data source.
/Nordmand28