This is a long post, but we have done quite a bit of testing.
PROBLEM: Cannot generate symbols. No .txt files are generated by finsql.exe. Event log errors are below.
The same issue occurs on a laptop development environment and two virtual servers (nothing but BC and SQL loaded on the virtuals). All environments were patched (Windows Update) up to date.
Occurs with both the original release files (build 29537) and Cumulative Update five (build 36463). Occurs with standard database as well as client (custom) database.
Conversion from Dynamics NAV 2009 R2. Application objects are standard Business Central 14 objects except for tables. All tables compile. All objects except Outlook integration code units compile. Note: Outlook is not installed. Server is a virtual Windows server 2012. Laptop is Windows 10.
SCENARIO ONE
From an administrative command prompt, and the Business Central service installation directory, run the following command:
finsql.exe command=generatesymbolreference, database=DBNAME, servername=BC14\SQL2016
The Event Viewer shows the following errors:
ERROR ONE
Application: finsql.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileNotFoundException
at <Module>.GenerateSymbolReference(Byte*, std.basic_string<unsigned short,std::char_traits<unsigned short>,std::allocator<unsigned short> >*, std.basic_string<char,std::char_traits<char>,std::allocator<char> >*)
at <Module>._WinMainCRTStartup()
ERROR TWO
Faulting application name: finsql.exe, version: 14.0.36457.0, time stamp: 0x5d85d62e
Faulting module name: KERNELBASE.dll, version: 10.0.17763.652, time stamp: 0x57e2061a
Exception code: 0xe0434352
Fault offset: 0x0011fd82
Faulting process id: 0x198c
Faulting application start time: 0x01d58dd478c4bcd1
Faulting application path: C:\Program Files\Microsoft Dynamics 365 Business Central\140\Service\finsql.exe
Faulting module path: C:\Windows\System32\KERNELBASE.dll
Report Id: 502b54fe-ea1a-42da-8914-2150e0865cf2
Faulting package full name:
Faulting package-relative application ID:
INFORMATION ENTRY IN THE EVENT LOG
Fault bucket 1810120295511509300, type 1
Event Name: APPCRASH
Response: Not available
Cab Id: 0
Problem signature:
P1: finsql.exe
P2: 14.0.36457.0
P3: 5d85d62e
P4: KERNELBASE.dll
P5: 10.0.17763.652
P6: 57e2061a
P7: e0434352
P8: 0011fd82
P9:
P10:
Attached files:
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER5CE.tmp.dmp
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER6AA.tmp.WERInternalMetadata.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER6BB.tmp.xml
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER6B9.tmp.csv
\\?\C:\ProgramData\Microsoft\Windows\WER\Temp\WER6F8.tmp.txt
These files may be available here:
\\?\C:\ProgramData\Microsoft\Windows\WER\ReportArchive\AppCrash_finsql.exe_33e2f751b84b96ed8de26fb41cc92587a899_aaf149b4_19e2091a
Analysis symbol:
Rechecking for solution: 0
Report Id: 502b54fe-ea1a-42da-8914-2150e0865cf2
Report Status: 268435456
Hashed bucket: a99e5575c14f34c7c91ed6d17eb04934
Cab Guid: 0
SCENARIO NUMBER TWO
Same configuration as above. Using the following command from an administrative Power Shell Session (both BC administrator extensions loaded, and run as administrator):
Compile-NAVApplicationObject -DatabaseName DBNAME -DatabaseServer BC14\SQL2016 -Recompile -GenerateSymbolReference -Filter 'Type=Table'
During this command, finsql.exe runs in the Task Manager Details pane for longer than it runs during the command in scenario number one.
No output, no errors, no event log errors. Using Get-NavAppInfo shows no application symbols loaded. No table changes are downloaded to VSC from either standard or custom db.
SCENARIO NUMBER THREE
run finsql.exe with generatesymbolreference=yes or 1.
Compiling any object causes the DEV environment to close without error. The same errors are recorded in the event log.
Any ideas?
