Skip to main content

Posts

ERROR The trasaction log for database is full.

Hi all, Sometime we face an error in SQL Server while performing transaction in Navision. ERROR - (Error 9002) The following SQL Server Error or errors occured when accessing the "Table Name" table: 9002,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server] The trasaction log for  database 'Database name' is full. To find out why space in the log cannot be reused, see the log_reuse_Wait_desc column in sys.database. SQL: Update "database name"."dbo"."Table Name" with (RepeatTableRead) set something where  query. Reason For Error- The error is due to space avilability in the disk where Log file reside. Resoultion - There are multiple options for the resoultion of the same, choose one that best suite you- 1) Backing up the Log. 2) Freeing Disk Space. 3) Moving the Log File to a Different Disk 4) Increasing the size of a log file. 5) Adding a log file on a different disk. 6) Completing or killing a long-

RTC Report Development 2.

Hi all, If you haven't read the part first then read it  here. Now when you created the suggestion layout you can see the Red Dots in the Report body. For being specific in the table details of the first table in the Page Body. The most part of an RTC Report is the Page Header, we all face issues in this. Let's discuss what happens when we say suggest layout.

RTC Report Development 1.

Hi all, we all have some known and unknown issues while creating a Report For Role Tailored Client . we will try to create a standard report by deleting its Layout and creating a new RDLC Layout from Scratch. I have saved Standard Report 406 Purchase - Invoice as 5000 Purchase - Invoice 1. Then I deleted its existing layout by using Tools->Delete Layout. Now lets create the Layout from Scratch. Now lets see what Layout suggestion suggest for this report, by using Tools -> Create Layout Suggestion.

Microsoft Dynamics NAV Classic client was opened from an untrustworthy component. Contact your system administrator.

Hi all, A Comman error faced while trying to Run a Report From Role Tailored Client (a report with no layout defined), it try to start the Report Engine from classic Client. It can happen that after updating RTC, you end up with a version of RTC which is not compatible with the default classic client. In this case you will typically get this error message when trying to run the report. First of All you need to find the build of classic and Role tailored client. The Build for both should be same. Following screen shows how to check the build for both client. If the build is diffrent you need to udate the Build using this link (require Partner/Customer source login). If the build is same then we need to find out from where does RTC find the classic client for running classic reports? RTC finds the location of Finsql.exe in this place in registry: (can be opened by typing regedit in RUN) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\