Troubleshooting
Problem
- When fn_setup_rdb -u is executed, fn_msodbc returned an error that osql could not be executed.
- sqlcmd.exe not always executed when osql.exe is missing.
Symptom
The following errors are reported in the elog
fn_msodbc: ERROR MSSQL Server Software was not installed on this home directory.
ERROR: The following error may mean SQL Server is not installed or
The SQL Server Tools\binn directory is missing from the environment PATH:
'sqlcmd.exe' is not recognized as an internal or external command,
Operable program or batch file.
ERROR: The following error may mean SQL Server is not installed or
The SQL Server Tools\binn directory is missing from the environment PATH:
'sqlcmd.exe' is not recognized as an internal or external command,
Operable program or batch file.
'osql' is not recognized as an internal or external command,
Operable program or batch file.
Operable program or batch file.
Please verify system configuration is correct.
2023/02/14 04:56:36.759 212,6,31 HGNYZ0031E <Administrator> fn_get_input.exe FN_GET_MSSQL_2005_UPGRADE (2108.4184.0 0x83c.1058) ... [SERIOUS]
ERROR: The following error may mean SQL Server is not installed or
The SQL Server Tools\binn directory is missing from the environment PATH:
'sqlcmd.exe' is not recognized as an internal or external command,
Operable program or batch file.
2023/02/14 04:56:36.759 212,6,31 HGNYZ0031E <Administrator> fn_get_input.exe FN_GET_MSSQL_2005_UPGRADE (2108.4184.0 0x83c.1058) ... [SERIOUS]
ERROR: The following error may mean SQL Server is not installed or
The SQL Server Tools\binn directory is missing from the environment PATH:
'sqlcmd.exe' is not recognized as an internal or external command,
Operable program or batch file.
Please verify system configuration is correct.
Error occurred while Granting VIEW SERVER STATE to IS users or while setting ANSI_NULL_DFLT_ON to ON
fn_setup_rdb terminated abnormally.
fn_setup_rdb terminated abnormally.
Running fn_util upgrade_to_odbc 2019
fn_util, odbc: starting 'upgrade_to_odbc'
fn_msodbc: ERROR MSSQL Server Software was not installed on this home directory.
fn_util, odbc: starting 'upgrade_to_odbc'
fn_msodbc: ERROR MSSQL Server Software was not installed on this home directory.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSNVUD","label":"FileNet Image Services"},"ARM Category":[{"code":"a8m50000000Ce0AAAS","label":"FileNet Image Manager Active Edition (Click on +)-\u003EFileNet Image Services-\u003EData Bases-\u003EMicrosoft SQL DB"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1.2;4.2.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
ibm16981785