This KB article addresses the following error which may appear in the recognition.log file when running the ARL update:
2023-11-20 01:14:39,879 [ft.Recognition.Program] [FATAL] An unhandled exception occurred.
System.Exception: Error running command: sqlcmd.exe -S server-name -d FNMSCompliance -b -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql" -E ---> System.ComponentModel.Win32Exception: The system cannot find the file specified
2023-11-20 01:14:39,744 [ecognition.Recognition] [INFO ] Executing SQL file C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql
2023-11-20 01:14:39,854 [ecognition.Recognition] [INFO ] Executing command: -S server-name -d FNMSCompliance -b -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql" -E
2023-11-20 01:14:39,879 [ft.Recognition.Program] [FATAL] An unhandled exception occurred.
System.Exception: Error running command: sqlcmd.exe -S server-name -d FNMSCompliance -b -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLCreateTables120.sql" -E ---> System.ComponentModel.Win32Exception: The system cannot find the file specified
at System.Diagnostics.Process.StartWithCreateProcess(ProcessStartInfo startInfo)
at ManageSoft.Recognition.Recognition.ExecuteCommand(String command, String commandParams, String[] argumentsForSanitization)
setx PATH "<directory containing sqlcmd.exe>" /M
A common location where sqlcmd.exe can be found is: C:\Program Files\Microsoft SQL Server\<version-number>\Tools\Binn
If multiple versions of sqlcmd.exe are installed, the system PATH environment variable should be configured so that the directory containing the most recent ODBC-based version of sqlcmd.exe appears before any directories containing other versions.
on Nov 29, 2012 04:16 AM - edited on Jan 18, 2024 05:36 PM by ChrisG
same issue occurred in our environment.
we followed the below steps.
now it's working fine.
Thanks,
sreerama yenuga