pdm_configure fails with error: "Error running SQL script to check permission"

Document ID : KB000029102
Last Modified Date : 14/02/2018
Show Technical Document Details

DESCRIPTION:

pdm_configure fails the following error:  "Error running SQL script to check permission"   corresponding configure.log shows messages like "sql_check_db.exe completed with exit code 11" 

We also see the following error from the gui:

<!--[endif]--> sql_error.jpg

                    

In the logs we see the following error:

06/14 15:31:55.682 INFO CheckDB.java 352 WARNING: Current server not yet defined.
06/14 15:31:55.932 INFO ProcessUtilities.java 572 Process C:\Program Files (x86)\CA\Service Desk Manager\bin\.\sql_check_db.exe completed with
exit code 11
06/14 15:31:55.932 INFO SQLDatabasePage.java 665 Running: sqlcmd -S <servername> -U ServiceDesk -P <password> -l 5 -i tmp_sql.sql
06/14 15:31:55.932 ERROR SQLDatabasePage.java 705 java.io.IOException: Cannot run program "sqlcmd" (in directory
C:\Users\ADMINI~1\AppData\Local\Temp\3"): CreateProcess error=2, The system cannot find the file specified

 

SOLUTION:

The error is caused by following

1) Missing SQL Client components on the primary server (in conventional mode) or any SDM server in Advanced Availability mode. Install SQL Client tools to resolve such

or

2) PATH to the SQL Client tools was missing from the Operating System's PATH

a. To resolve this, one could add the following to the operating system PATH "C:\Program Files\Microsoft\SQL Server\100\Tools\Binn"  

Note: Review the host to ensure the actual path on the affected server and adjust the above appropriately

b Reboot server

c. Re-Run pdm_configure / configuration again