Skip to main content

Search

Welcome to Tibero GTS!

Error TBR-90612 Occurs When Handling LOB Data During tbexport/Import Migration

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.
Caution
Apply the patch through technical support provided by Tmax Tibero.
Note
If 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
 
 
 

Related to