anhpham1652
Level 6

Manual Updates of Library Data

Jump to solution

Hello,

I updated manually library by running "ShadowHostWin.exe" "BatchProcessTask.exe" run ARLImport but got  error as this picture

pic1.PNG

 

But when I ran the error command, it worked normally like this

pic2.PNG

 

pic3.PNG

 

What should I do to fix this? Thank you so much

0 Kudos
2 Solutions
mfranz
Level 15

Looks like the system could not find sqlcmd.exe. Did you install SQL Server database drivers and command line tools and restart the machine afterwards?

Command line tools are added to the PATH variable and these changes only take effect after reboot.

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

ChrisG
Community Manager Community Manager
Community Manager

The fact that running sqlcmd.exe interactively yourself works, while running it from the ARL import process fails with a "The system cannot find the file specified" error suggests that maybe the PATH environment variable is set differently for different users.

To avoid a problem from this, ensure that the system PATH environment variable is set to include the directory where sqlcmd.exe is installed.

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)

View solution in original post

2 Replies
mfranz
Level 15

Looks like the system could not find sqlcmd.exe. Did you install SQL Server database drivers and command line tools and restart the machine afterwards?

Command line tools are added to the PATH variable and these changes only take effect after reboot.

Softline Group is Europe's leading independent expert in Software Asset Management.
ChrisG
Community Manager Community Manager
Community Manager

The fact that running sqlcmd.exe interactively yourself works, while running it from the ARL import process fails with a "The system cannot find the file specified" error suggests that maybe the PATH environment variable is set differently for different users.

To avoid a problem from this, ensure that the system PATH environment variable is set to include the directory where sqlcmd.exe is installed.

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)