The following error details in recognition.log is what I would focus on here:

2024-12-19 01:08:29,465 [ecognition.Recognition] [INFO ] Executing SQL file C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLUpdate205.sql

2024-12-19 01:08:29,465 [ecognition.Recognition] [INFO ] Executing command: -S servername\Flexera -d FNMSCompliance -b -i "C:\ProgramData\Flexera Software\FlexNet Manager Platform\DataImport\Content\ARL\.temp-extract\ARLUpdate205.sql" -E

2024-12-19 01:08:29,853 [ecognition.Recognition] [INFO ] (0 rows affected)

2024-12-19 01:08:29,853 [ecognition.Recognition] [INFO ] (0 rows affected)

2024-12-19 01:08:29,853 [ecognition.Recognition] [INFO ] (0 rows affected)

2024-12-19 01:08:29,853 [ecognition.Recognition] [INFO ] (1 row affected)

2024-12-19 01:08:33,288 [ecognition.Recognition] [INFO ] Msg 156, Level 15, State 1, Server servername\FLEXERA, Procedure ARLStagingSoftwareTitleHierarchy101, Line 47

2024-12-19 01:08:33,288 [ecognition.Recognition] [INFO ] Incorrect syntax near the keyword 'IF'.

This is a somewhat strange error - is refers to a "procedure" named "ARLStagingSoftwareTitleHierarchy101", but this is actually a view and not a procedure.

I don't know what might cause this, but is it possible you have installed the Go version of sqlcmd rather than the ODBC version? (FlexNet Manager Suite requires use of the ODBC version of sqlcmd.)

To find out which version you have installed, execute the following command:

sqlcmd "-?"

Then check the output as detailed under the heading "Find out which version you have installed" on the following page: https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16&tabs=go%2Cwindows&pivots=cs1-bash

Hello,

Thank you for your response.

We have already checked this point and we have the ODBC version installed and we still get the same error. Do you have any alternative for this?

Thanks.