Skip to main content

Search

Welcome to Tibero GTS!

tbExp Execution and Backup Not Possible When Creating Temporary Files

Document Type | Troubleshooting 

Category | Utility

Applicable Product Version | 6FS06

Error Code | 90613

Document Number | TUTTS008

 

Issue

An error occurs during the execution of tbExport, the export utility provided by Tibero, and the backup does not proceed.
tbexport
tbexport 5.1 (FS02)  107953 Copyright(c) 2014 TmaxData, Co., Ltd. All rights reserved
Patch files (none)
Export character set: UTF-8
Export national character set: UTF-16
    exporting table: "TIBERO"."TN_MDSS_INSD_SCNDR_DATA_H10_1"
java.io.FileNotFoundException: /home/tibero5/test/.expimp_1444869680691/00540049004200450052004F.0054004E005F004D004400530053005F0049004E00530044005F00530043004E00440052005F0044004100540041005F004800310030005F0031.0050004E005F0049004E00530044005F0053005500520056005F004800310030005F00390039003900390039003900390039005F003900390039.0 (File name too long)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:194)
at java.io.FileOutputStream.<init>(FileOutputStream.java:84)
at com.m.expimp.exporter.AbstractExportRows.makeOutputStream(AbstractExportRows.java:498)
at com.m.expimp.exporter.AbstractExportRows.exportRows(AbstractExportRows.java:329)
at com.m.expimp.exporter.AbstractExportRows.run(AbstractExportRows.java:125)
at java.lang.Thread.run(Thread.java:662)
Packing the file...

 

Cause

An error occurs when the temporary file created during tbExport execution is named with a file name longer than 256 characters.
 
 

Solutions

Apply the patch to resolve this issue. (Applied patch: 101340c_expimp)
Caution
Apply the patch through technical support provided by Tmax Tibero.
 
--After applying the patch
 
tbexport
tbexport 6.0  113062 TmaxData Corporation Copyright (c) 2008-. All rights


the TABLE: TN_MDSS_INSD_SCNDR_DATA_H10_1: Mon Nov 09 14:50:13 KST 2015
Export national character set: UTF-16
    exporting table: "TIBERO"."TN_MDSS_INSD_SCNDR_DATA_H10_1"
      [0] TIBERO.TN_MDSS_INSD_SCNDR_DATA_H10_1                999 rows exported.
Packing the file...
Export completed successfully: Mon Nov 09 14:50:18 KST 2015

Note

When replacing tbexport, if the path inside tbexport is set to the client path instead of the $TB_HOME path, it does not affect other tools.

[ps1@psdblcbp:/sdiske/ps1/dosmap/tibero6/client/bin]$ cat tbexport
#! /bin/sh


prog= basename $0


#Classpath
toolcom=/sdiske/ps1/test_client/tibero5/client/lib/jar/toolcom.jar
expimp=/sdiske/ps1/test_client/tibero5/client/lib/jar/expimp.jar
jdbc=/sdiske/ps1/test_client/tibero5/client/lib/jar/internal-jdbc-14.jar
logger=/sdiske/ps1/test_client/tibero5/client/lib/jar/msllogger-14.jar


#Main Class
mainclass=com.m.expimp.exporter.ExportMain


#PREV_LANG=$LANG
#export LANG=ko_KR.euckr
java -Xms64m -Xmx512m -classpath $toolcom:$expimp:$jdbc:$logger $mainclass $*
#export LANG=$PREV_LANG

 

 

 

Related to