Technote (troubleshooting)
Problem(Abstract)
The ITNM process ncp_model and those dependent on it, will not start. A log message states that there is a "Failed to connect to database".
Symptom
The ncp_model.DOMAIN.log shows this complete message:
Warning: W-RIV-002-209: [6248t] CMdlApplication.cc(178) Cannot connect to database : 28000 (Error -951): [Informix][Informix ODBC Driver][Informix]Incorrect password or user ncim@localhost[hostname.com] is not known on the database server.(from CNcpInformixDbh.cc line 151) dbId: NCIM
Fatal: F-RIV-002-098: [6248t] CMdlApplication.cc(180) Exit function called Error: Failed to connect to database
Diagnosing the problem
Check the access to the databases using;
ncp_perl %NCHOME%\precision\scripts\perl\scripts\ncp_db_access.pl
It will also report:
Level: info Msg: Attempting to connect to database (DBI:ODBC:driver=IBM INFORMIX ODBC DRIVER;host=hostname.com;server=ITNM;database=itnm;service=9088;protocol=onsoctcp;DELIMIDENT=Y)...
Level: critical Msg: Database Connection Error: [Informix][Informix ODBC Driver][Informix]Incorrect password or user ncim@localhost[hostname.com] is not known on the database server. (SQL-28000)
Resolving the problem
Change the Windows 2008 User Account properties for the users "ncim" and "informix" so that "Password never expires"
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.