Document Type | Troubleshooting
Category | Backup/Recovery
Applicable Product Version | 6FS07
Document Number | TBATS005
Issue
During tbimport execution, the error JDBC-90603: Invalid operation: disconnected from the server occurs, causing the tbimport process to terminate abnormally.
Cause
The main connection process of tbimport waits idle until the data (row) transfer is complete.
If the row transfer operation takes longer than the time set in the ACTIVE_SESSION_TIMEOUT parameter, the main connection is forcibly disconnected by the server.
Solutions
Apply the following patches to resolve the issue.
- FS07_CS_224949a_expimp
- FS07_224949b
CautionApply the patch through technical support provided by Tmax Tibero.
NoteTemporary Workaround
Change active_session_timeout to 0 and then perform the import. Replace the $TB_HOME/client/lib/jar/expimp.jar file with the patched expimp.jar binary.โป It is recommended to back up the existing expimp.jar file.