We performed the below steps while working on Testing HA Configuration.
- Modified ODBC connection
- Modified .ini config file - all SQLDRIVERCONNECT statements
- Shutdown UC4 application
- Stopped DB Services on both SQL nodes.
- Rebooted node 1
- Rebooted node 2
- started DB services on both servers
- Rebooted application server
- Failover to secondary node
- Tried starting UC4 application - We were unable to start any of the WP's and CP's.
The WP logs showed the below error:
20190502/182848.814 - U00003526 UCUDB: Database version ('0.0.0') does not match your program version ('12.1.0').
20190502/182848.814 - U00003611 DB OPEN executed. Return Code = '0000003526'
20190502/182848.814 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20190502/182848.814 - U00003526 UCUDB: Database version ('0.0.0') does not match your program version ('12.1.0').
20190502/182848.881 - U00003449 Output to the TRACE file is finished.
20190502/182848.883 - U00003450 The TRACE file was opened with the switches '0000000000000000'.
20190502/182848.884 - U00003380 Server 'UC4Q#WP' version '12.1.0+hf.1.build.1342' (Runtime '0/00:00:00', Log# '1', Trc# '1').
20190502/182848.884 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20190502/182848.884 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.
20190502/182848.886 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: ca7000 DB-HDBC: ca70e0
20190502/182848.886 - U00003591 UCUDB - DB error info: OPC: 'SQLNumResultCols' Return code: 'ERROR'
20190502/182848.886 - U00003592 UCUDB - Status: '42S02' Native error: '208' Msg: 'Invalid object name 'ABLOB'.'
20190502/182848.886 - U00003592 UCUDB - Status: '42000' Native error: '8180' Msg: 'Statement(s) could not be prepared.'
20190502/182848.886 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20190502/182848.886 - U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR ', '42000', 'Statement(s) could not be prepared.'
20190502/182849.097 - U00003449 Output to the TRACE file is finished.
20190502/182849.099 - U00003450 The TRACE file was opened with the switches '0000000000000000'.
20190502/182849.099 - U00003380 Server 'UC4Q#WP' version '12.1.0+hf.1.build.1342' (Runtime '0/00:00:01', Log# '1', Trc# '2').
20190502/182849.099 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20190502/182849.099 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.
20190502/182849.100 - U00003590 UCUDB - DB error: 'SQLNumResultCols', 'ERROR ', '42000', 'Statement(s) could not be prepared.'
20190502/182849.103 - U00003408 Library 'UCSJ.DLL' was successfully unloaded.
20190502/182849.103 - U00003410 Server 'UC4Q#WP' version '12.1.0+hf.1.build.1342' ended abnormally.
Could someone please provide an insight or any solution on the above.