-
Planning Assignment Error
Hello, For our customers system we have two different servers where the specific services are running. Specifically, it deals with the problem that a service on server A, which has activated the TaskScheduler and is only responsible for the job queue, has an error in combination with a service on server B, which is only…
-
Reporting Services and NAV
Hi everyone, as you can see from my post count, I'm new to this community. I've been introduced to Navision not so long ago, and wish to enhance my experience in working with it. At the moment, I don't have much skills on working with the detailed aspects of NAV, but I understand the gist of the functionalities and most of…
-
Relationships between tables Purch_ Inv_ + Sales Inv
Please, help me. I need information on the sales invoice regarding quantity, price, etc., but in the report, I want to see the price at which the item was purchased, the currency used, and the purchase date. How can I track this or combine sales invoice and purchase invoice?
-
This SqlTransaction has completed it is no longer usable
Hi folks, I am facing this error for days and I still can't find a solution. Here is the error: I have multiple services that connect on the same sql server instance and obviously on the same database. Our IT Managers did this for balance computing, or at least this is what they said. This is part of the stack trace,…
-
How to select SQL server instance in Dynamics NAV 2018
Hello, I had to create an additional instance of SQL SERVER. I can set that instance in development by defining Database Server to SRVNAV\MSSQLSERVER01 and Server Instance as link/dynamicsnav110. And it seems to set fine in dev environment. BUT when I try to open some page, i get data from old instance, and I not sure how…
-
Install business Central on linux
Hi Guys Do you know if business Central 365 is supported when it will be installed on a Linux/Ubuntu vm with sql 2017? Any experience with it?
-
Wrong ordering
SQL Server configured to use collation Latin1_General_CS_AS. NAV use Code(20) type column in primary key and SQL and NAV produces following wrong order: HUTNY-MATE-POLYESTER HUTNY-MATERIAL-PZN HUTNY-MATE-W.15,WPA where HUTNY-MATE-W.15,WPA should be ordered before HUTNY-MATERIAL-PZN. What is the reason or what is wrong?
-
SQL License Question
Sorry, forgive my ignorance. I could get this right in my mind. Customer will have 50 NAV2018 users in an On-Prem environment. One SQL2019 server on Windows 2022 server. Another separate Windows server 2022 for Navision Application Server. Only NAV accesses the SQL using a single windows domain user name. May be one or two…
-
SQL Error when I compile the object in NAV 2016
We are using NAV 2016 -(version 9.00.46621). I get an error when I compile the Service Header table object. This error occurs only for this table. It started happening recently. I can compile all other objects. I get the following error : An updated definition for table Service Header cannot be applied in SQL because the…
-
Trying to read an Image from SQL
I have developed a third party integration that pushes data out to SQL staging tables and pulls data from staging tables. One of the tables I am trying to read from contains a Customer Signature. It is stored as an Image Datatype within SQL and seems to be identical to the way Navision stores BLOB files within Sql. The…
-
The server failed to resume the transaction
Hi, A user is on NAV2017 and Microsoft SQL Server 2016 Enterprise Edition. The error log for the NAV Service tier contains various rows with the error message "The server failed to resume the transaction". Does anyone have experience with this error and experience regarding how to solve it? Thanks in advance for any help
-
External application to access Dynamics 365 SQL database
Hello everybody! In our organization we have an "on premise - Dynamics 365 Business Central" server that runs our main business database. It runs version 14, that is, Dynamics 365 Business Central Spring Release v14.00 I believe is also called Wave 1 2019. We now use the "web" client (after many, many years of using the…
-
Business Central 180 crashes when user try to rename Item
Hi guys, When I try to rename Item WebClient crashes. The error that I found in event viewer looks like this. When I try to debug Base app I get that client crashes when GlobalTrigger GetGlobalTableTriggerMask parameter TableID=7326. Any help would be appreciated. Message: Specified method is not supported. StackTrace: at…
-
How to extract SQL Query/ Store Procedure from SQL Profiler tool for MS Navision ?
for an example, I want to extract store procedure for INSERT item from SQL Profiler so from store procedure i will get idea how much table hit during INSERT.
-
SQL Server Database Growth Under Business Central 14 / NAV 2018
Hi, We converted our sql server database to 14.0.3391.2, then we did a NAV upgrade from NAV 2016 to BC14/NAV 2018. Now, our database size is increasing much faster than it did before. In addition, our differential backup is increasing at 5 or 10 times the rate it did before. Has anyone noted this condition? Does BC14 tend…
-
Nav 2018 SQL DB Replication possible?
Hi What would be best sql replication methods for Dynamics NAV 2018 database which the partner still uploads changes (objects including tables). The DB is around 200GB and subscriber will also be in the same premises (different building) I see snapshop, transactional etc. Not sure which one will work in this case?
-
UPDLOCK when using a ISEMPTY
Hi, Recently one of our customers is having deadlock issues on their NAV 2018 environment. In one specific case we captured the deadlock trace using SQL Profiler. The victim process was trying to get an exclusive lock for performing a DELETE. The other process had this SQL command: SELECT TOP 1 NULL FROM "some…
-
SELECT * FROM
Hi, I have executed the following SQL query on a NAV Database for two different companies and I surprise to see the column sequence. It differs from one another. SELECT * FROM CompanyName$TableName; What is the reason behind it? How do I fix that ? Thanks, navuser1
-
AlwaysOn High Availability Groups on SQL with Microsoft NAV
AlwaysOn High Availability Groups on SQL with Microsoft NAV I have planned to do setup AlwaysOn High Availability Groups for SQL with primary & one secondary. My question is how to connect with Microsoft Navision Application & during failover how connection will get changed to connect with secondary db as primary.
-
Business Central 140 CU upgrade not support Azure SQL Managed Instance
I am going to upgrade BC140 CU 11 to CU 20 (In order to apply some platform bugs fixed by microsoft) Error occured when open Db in step of converting Db to new CU version "ALTER DATABASE ... SET SINGLE_USER is not supported" Database is hosted in Azure SQL Managed Instance (aka SQL MI) After a few research, I realized that…
-
How to Delete NAV Company on SQL Database
Hi, We're using NAV 2018 and we have multiple companies on our database. We want to delete a certain company including all data on it, we've already deleted it on NAV RTC but when we look on the SQL database all tables and views are still there. Is there a way to delete a company and all of its records in a simple way?.…
-
Unable to connect to NAV2009 SQL after upgrading client server from Windows 2008R2 to Windows 2012
A client gets this error after having upgraded an old Windows 2008R2 server to Windows 2012: The following ODBC error occurred: Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Status-ID: IM002 We have found several threads suggesting to re-install the Native Client for…
-
Cannot generate SSPI context. State ID: HY000
I know there are other posts about this, and I tried it all out. I have Navision 5.00 on a SQL2005 standard edition on an XP (my portable). If I try to connect to the SQL DB with Windows login (with nettype default,Named Pipes,TCP/IP Sockets,Multiprotocol) I get this error. The strange thing is : if I connect with MS SQL…
-
Unable to open SQL Server database file (.mdf)
Experts, I have a SQL Server 2005 database file (a .mdf file) that I am trying to open in SQL Server Management Studio so I can add a field to a table, but I am unable to open the file. I can't say that I really understand how SQL Server handles these databases. I especially don't understand the "attaching" and "detaching"…
-
'TableData 2000000001' doesn't exist and ndo problems
I have just migrated my NAV4 SP1 database from SQL 2000 to SQL 2008 through an SQL restore. I' have windows authentication and various roles per user. Users with SUPER rights are getting the error that 'TableData 2000000001' does not exist. Users with other roles are getting the error that 'The Execute permission was…
-
How to copy data from multiple table from one DB to other DB in sql server where Timestamp is used.
I need to copy a set of tables from one DB to another DB, the tables structure is the same but the problem is when using Import/Export wizard I'm getting error that for table. Timestamp is used as column for all the set of tables which we cannot use for copy, so some one please suggest how to copy the data from db to db.…
-
How register dll server on pc cilent
i have focus accounting program , and i register dll file for active barcode and working in server , but i register dll file in cilent pc but not working . This massage error : activex component can't create object Please help me
-
Error with INSERT Trigger in Job Monitor (LS Retail)
Hi Everyone! I'm trying to insert to a secondary table whenever there is an insert another table( Member Point Entry). The issue is when I manually do an insert by T-SQL then its getting inserted and the trigger is fired properly. But at our site we have data director (product from LS Retail for replication), and when…
-
Convert BLOB to String(Text) SQL Server
I have a BLOB stored in SQL Server. I've managed to convert it utilizing C/AL code, but I need to determine a way to convert it via SQL Query. the C/AL code is: OnAfterGetRecord() CALCFIELDS(Rec."BLOB_FIELD", Rec."OTHER_BLOB_FIELD"); "BLOB_FIELD".CREATEINSTREAM(Istream); Istream.READ(TextData); CLEAR(Istream);…
-
Converting Mycrosoft Dynamics Nav compressed BLOB to NVARCHAR with CLR
One of the benefits of Ms Dynamics nav is its open physical data model. It allows us to generate external OLTP reporting, upload data for OLAP repositories with simple SQL queries without additional data extraction and decryption operations. Everything would be fine until we come across fields with the Blob type (in SQL,…