RSS

Tag Archives: Microsoft Dynamics NAV

Dynamics NAV: Field List

The last couple of years I have started to use an new trick to make my everyday life with Dynamics NAV easier.

Usually I have the problems like this:

  • How do I easy see all the locations of a certain field name in the database?
  • How can I quick look up a datatype for a certain field?
  • How can I quick see if a field is a flowfield?
  • How can I search on database fields using captions?

For me the solution became to make a page on the virtual table field (How to: Create a Page to View a Virtual Table).This is real handy when you have an addon table with 355 fields were the captions don’t really match the field names.

Read the rest of this entry »

 
Leave a comment

Posted by on 2015-08-29 in Okategoriserade

 

Tags: , ,

XMLPort: Import Into Temporary Table

Earlier today I wrote a blog post XMLPort: Export from temporary tables. The principle is the same when you want to import to a temporary table. Instead of calling a function in XMLPort before you call the export that inserts values into the temporary table you do the opposite, call a function after the import has completed that copies all the temporary data to your temporary record parameter.   Read the rest of this entry »

 
1 Comment

Posted by on 2015-08-08 in Okategoriserade

 

Tags: , , ,

XMLPort: Export from temporary tables

You can export data from tables to XML by using XMLPorts. But you can also use XMLPorts to export data from temporary tables.
The principle is to set the Temporary property on the table line and then create a function in XMLPort that inserts all the data into the temporary record.

Read the rest of this entry »

 
1 Comment

Posted by on 2015-08-08 in Okategoriserade

 

Tags: , ,

Dynamics NAV System.StackOverflowException: NST crashes

We had this scenario were had new update of a partner addon that we should implement in the production environment. Before the implementation we had done a couple of tests to verify that the addon was working. But on the day we put update in the production environment the NST (NAV Service Tier) started to crash after 1,5h and continued to crash every five minutes. It was really bad, we had no clue about what was causing this except that it must come from the update. It was actually so bad that we decided to do a rollback by restoring a SQL backup.

When we looked in the eventviewer and we found three event that tells us about the crash.System.StackOverflowException

The first one says:
Faulting application name: Microsoft.Dynamics.Nav.Server.exe, version: 8.0.38457.0, time stamp: 0x5452bd3b
Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000
Exception code: 0xc00000fd
Fault offset: 0x00007ffbcab200d7
Faulting process id: 0x31bc
Faulting application start time: 0x01d0a33d1cface2b
Faulting application path: C:\Program Files\Microsoft Dynamics NAV\80\Service\Microsoft.Dynamics.Nav.Server.exe
Faulting module path: unknown
Report Id: a4e43f71-0f30-11e5-80c8-0050569da38d
Faulting package full name:
Faulting package-relative application ID:

The second and the third message from the source “Windows Error Reporting” gave the error message:
Fault bucket , type 0
Event Name: CLR20r3
Response: Not available
Cab Id: 0

Problem signature:
P1: Microsoft.Dynamics.Nav.Server
P2: 8.0.38457.0
P3: 5452bd3b
P4: RecordXXXXX
P5: 0.0.0.0
P6: 5577c927
P7: 4
P8: 0
P9: System.StackOverflowException
P10:

Attached files:

These files may be available here:
C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_Microsoft.Dynami_XXXX

Analysis symbol:
Rechecking for solution: 0
Report Id: a4e43f71-0f30-11e5-80c8-0050569da38d
Report Status: 4100

The interesting part of this message is P4 and P9. Here we can see that error appears in recordXXXXX and that it is a System.StackOverflowException.

System.StackOverflowException is: “The exception that is thrown when the execution stack overflows because it contains too many nested method calls. This class cannot be inherited.

After a lot of more testing we finally found the error. The reason was that we had a loop of infinity. We had function1 that called a function2 that in its turn called function1. A loop that never stops. This code was originally run from a OnValidate trigger in recordXXXXX. So to summarize this, look for a loop of infinity in the object that was stated in P4.

I hope this help you solve the problem. Good luck!

 
Leave a comment

Posted by on 2015-06-12 in Okategoriserade

 

Tags: , , , ,

Dynamics NAV ClickOnce: Failed while downloading…

If you try to install your ClickOnce application and get errors like this I’ll show you what Microsoft recomends you to do:

SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://xxx.xxx.xxx.xxx/App.application resulted in exception. Following failure messages were detected:
+ Failed while downloading http://xxx.xxx.xxx.xxx/App.exe.manifest
+ The remote server returned an error: (404) Not Found.

Your problem is probably that your deployment contain files that the webserver (if a webserver installation) doesn’t support download. The fix is to change the mime types to the current webserver. Read the rest of this entry »

 
Leave a comment

Posted by on 2014-11-13 in Okategoriserade

 

Tags: , , , ,

 
Dynamics 365 Business Central for Partners

Reflections from the ERP field

Freddys blog

Learn something new... - then Teach someone!

Stefano Demiliani Technical Blog

Reflections from the ERP field

David Worthington's NAV Performance Blog

Micosoft Dynamics NAV Performance Testing & Optimization

Freddys Blog

Reflections from the ERP field

Mark Brummel Blog | Microsoft Dynamics NAV

Master Classes Design Patterns and more...

Vjeko.com

ideas in the cloud

Goprowe AB

Reflections from the ERP field

ArcherPoint Developer Blog

Reflections from the ERP field

The NAV Viking´s Blog

- Sharing my experience in the Dynamics NAV world

Comments for waldo's blog

Reflections from the ERP field

Nav Can Be Fun

Its Really Fun to Work with Microsoft Dynamics Nav / D365 Business Central

Navision-Girl.Com

Reflections from the ERP field

Kine's Info

Reflections from the ERP field

blog.wibeck.org/

Just another WordPress.com site

NAV/SQL Performance - My Two Cents

Reflections from the ERP field

Hougaard.com – Applied Hacking

Reflections from the ERP field

Kauffmann @ Dynamics 365 Business Central

Reflections from the ERP field