Document Type | Issue Resolution
Category | Migration
Applicable Product Versions | 7FS01, 7FS02, 7FS02PS
Document Number | TMITS013
Issue
When importing a dump file exported by tbexport in Tibero5 SP1 into Tibero7 using tbimport,
full=y default_password=y options together, an error JDBC-7055:Encrypted password is invalid. occurs during the user creation process.NoteTesting was conducted in the following environments.
<#ExpImp~.log>
-- [FAILED] TBR-7055: JDBC-7055:Encrypted password is invalid.
at line 1, column 44 of null:
CREATE USER "TEST" IDENTIFIED BY ENCRYPTED 'CY9rzUYh03PK3k6DJie09g=='
^^^^^^^^^^^^^^^^^^^^^^^^^^ :
CREATE USER "TEST" IDENTIFIED BY ENCRYPTED 'CY9rzUYh03PK3k6DJie09g=='
DEFAULT TABLESPACE "TESTโ
...Cause
When performing tbimport in Tibero7 using a dump file exported by tbexport from Tibero5 SP1, the tbimport logic from Tibero5 SP1 is applied as is.
During this process, the default_password option is not reflected in the logic, causing the issue.
Solutions
Apply the FS02_299388d, FS02PS_299388d patches to resolve the issue.
CautionApply the patch through technical support provided by Tmax Tibero.
NoteAs a workaround, you can create tablespaces and users directly in Tibero7 before performing tbimport.