PMAC Upgrade Failed from 6.0.3 to PMAC 6.4 with ERROR 1067 (42000) in MySQL Phase

(Doc ID 2312508.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle Communications Diameter Signaling Router (DSR) - Version DSR 7.2.0 to DSR 8.1.1 [Release DSR 7.0 to DSR 8.0]
Information in this document applies to any platform.

Symptoms

During PMAC Upgrade failed from Rel 6.0.3.0.2-60.28.0 to PM&C 6.4.0.0.0-64.8.0, this is caused in the Post Script which is running Post Upgrade.

If you Check Upgrade Log /var/TKLC/log/upgrade/upgrade.log , Following is the Sequence of Error should be Displayed, Where it complains about Invalid Default for "Last_Password_Change"

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms