Document TypeㅣTroubleshooting
CategoryㅣUtility
Document NumberㅣTUTTS011
Issue
During the tbexport/Import migration process, when performing tbexport on tables containing LOB data, error TBR-90612 occurred.
Excerpt from log during tbexp extraction
Export national character set: UTF-16
exporting schema:"TIBERO"
exporting tables
..
[FAILED] ("TIBERO"."ESAATTH")
TBR-90612: JDBC-90612:Conversion rule violation between DB type and JDBC type. - BLOB
Cause
When performing tbexport on tables that have LOB or LONG columns, a column reordering process is performed.
If DATE columns are included, during the reordering process, the LOB check is incorrectly performed, causing BLOB or CLOB data to be exported using an incorrect API, which results in the error.
Solutions
Apply patch FS06_276852a to resolve the issue.
This patch includes a fix that correctly performs the LOB check logic during the reordering process when DATE columns are present.
CautionApply the patch through technical support provided by Tmax Tibero.
NoteIf the TO-BE server includes patch FS06_276852a_expimp, tbexp can be performed over the network using the IP option. In this case, the firewall between AS-IS and TO-BE must be open.tbexport username=sys password=tibero ip=[AS-IS server IP] port=[AS-IS server PORT] sid=[AS-IS server SID] full=y file=/home/tibero/exp.dat log=exp.log