Sftp Exception Uploading file - "Failure; ORA-01654"

0 votes
asked May 15, 2012 by Mali (320 points)
edited May 16, 2012

I get the following exception when I try execute the following statement: request.Upload(sourceFilePath, destinationFilePath, TraversalMode.MatchFilesShallow, TransferMethod.Copy, ActionOnExistingFiles.OverwriteAll);

Is invoked as:

request.Upload("C:\QTM\TestLog\FTPData\DataTogo\QtmLog\PMAHALIN_information_05_15_2012_15_17_24.log", "/", TraversalMode.MatchFilesShallow, TransferMethod.Copy, ActionOnExistingFiles.OverwriteAll);

EXCEPTION THROWN:
{"Failure; ORA-01654: unable to extend index MFTCRPDEV.IDX_MMBX_184220 by 128 in tablespace MFTCRP_INDEX\n."}   Rebex.Net.NetworkSessionException {Rebex.Net.SftpException}

STACK TRACE:

 at 1RyBHn.1yALZOZ.HandleException(Exception ex, 2CkSFs type, 1Acxa2 remoteItem, 1Acxa2 localItem, 1vhEpGZ defaultAction, 1vhEpGZ possibleActions, 1vhEpGZ& chosenAction)
   at 1RyBHn.1yALZOZ.HandleCaughtException(Exception caught, String message, 2CkSFs type, String remotePath, String localPath, 1Acxa2 remoteItem, 1Acxa2 localItem, 1vhEpGZ possibleActions, 1vhEpGZ& chosenAction)
   at 1RyBHn.1yALZOZ.C329b(String , String , String , String , 1Acxa2 , 1Acxa2 , 1Acxa2 , 1Acxa2 , Boolean , Boolean , Boolean )
   at 1RyBHn.1yALZOZ.1sdVhQZ(1YiDCIZ )
   at 1RyBHn.1yALZOZ.1idltvZ()
   at 1RyBHn.1yALZOZ.Transfer(YpcDbZ method, 18waHwZ sourceFilter, String targetPath, TransferMethod transferMethod, MoveMode moveMode, LinkProcessingMode actionOnLinks, ActionOnExistingFiles actionOnExistingFiles, 1Acxa2 expectedRootItem)
   at gbMKS.9h58kZ.1jMzU7Z(28xx7VZ , p5IYsZ , String , TransferMethod , MoveMode , LinkProcessingMode , ActionOnExistingFiles )
   at Rebex.Net.Sftp.1yALZOZ(28xx7VZ , udycp , dpo7FZ , String , TransferMethod , MoveMode , LinkProcessingMode , ActionOnExistingFiles )
   at Rebex.Net.Sftp.1eIxR5(udycp , String , String , TraversalMode , TransferMethod , MoveMode , LinkProcessingMode , ActionOnExistingFiles , Boolean )
   at Rebex.Net.Sftp.1eIxR5(udycp , String , String , TraversalMode , TransferMethod , ActionOnExistingFiles )
   at Rebex.Net.Sftp.Upload(String localPath, String remoteDirectoryPath, TraversalMode traversalMode, TransferMethod transferMethod, ActionOnExistingFiles existingFileMode)
   at DataCollector.SFTPFileSystemManager.UploadFileCopy(String sourceFilePath, String destinationFilePath, String uploadFileName) in C:\perforcesourcecode\pmahalin_All\dev\user\pmahalin\DataCollection\DataCollector_Compress\Main\DataCollector\SFTPFileSystemManager.cs:line 328

THE COMMUNICATION LOG is as follows: (An excerpt from the Log)
2012-05-15 15:27:59.773 DEBUG Sftp(48)[10] Command: SSH_FXP_WRITE (6, 0x30, 57344, 4877 bytes)
2012-05-15 15:27:59.773 VERBOSE Sftp(48)[10] SSH: Received packet SSH_MSG_CHANNEL_DATA (62 bytes).
 0000 |5E-00-00-00-00-00-00-00 35-00-00-00-31-65-00-00| ^.......5...1e..
 0010 |00-04-00-00-00-00-00-00 00-20-54-68-65-20-77-72| ......... The wr
 0020 |69-74-65-20-63-6F-6D-70 6C-65-74-65-64-20-73-75| ite completed su
 0030 |63-63-65-73-73-66-75-6C 6C-79-00-00-00-00      | ccessfully....
2012-05-15 15:27:59.773 DEBUG Sftp(48)[10] Response: SSH_FXP_STATUS (4, 0, 'The write completed successfully')
2012-05-15 15:27:59.789 VERBOSE Sftp(48)[10] SSH: Received packet SSH_MSG_CHANNEL_DATA (62 bytes).
 0000 |5E-00-00-00-00-00-00-00 35-00-00-00-31-65-00-00| ^.......5...1e..
 0010 |00-05-00-00-00-00-00-00 00-20-54-68-65-20-77-72| ......... The wr
 0020 |69-74-65-20-63-6F-6D-70 6C-65-74-65-64-20-73-75| ite completed su
 0030 |63-63-65-73-73-66-75-6C 6C-79-00-00-00-00      | ccessfully....
2012-05-15 15:27:59.789 DEBUG Sftp(48)[10] Response: SSH_FXP_STATUS (5, 0, 'The write completed successfully')
2012-05-15 15:27:59.789 VERBOSE Sftp(48)[10] SSH: Received packet SSH_MSG_CHANNEL_DATA (62 bytes).
 0000 |5E-00-00-00-00-00-00-00 35-00-00-00-31-65-00-00| ^.......5...1e..
 0010 |00-06-00-00-00-00-00-00 00-20-54-68-65-20-77-72| ......... The wr
 0020 |69-74-65-20-63-6F-6D-70 6C-65-74-65-64-20-73-75| ite completed su
 0030 |63-63-65-73-73-66-75-6C 6C-79-00-00-00-00      | ccessfully....
2012-05-15 15:27:59.789 DEBUG Sftp(48)[10] Response: SSH_FXP_STATUS (6, 0, 'The write completed successfully')
2012-05-15 15:27:59.789 VERBOSE Sftp(48)[10] SSH: Sending packet SSH_MSG_CHANNEL_DATA (23 bytes).
 0000 |5E-00-00-00-00-00-00-00 0E-00-00-00-0A-04-00-00| ^...............
 0010 |00-07-00-00-00-01-30                           | ......0
2012-05-15 15:27:59.789 INFO Sftp(48)[10] Command: SSH_FXP_CLOSE (7, 0x30)
2012-05-15 15:27:59.967 VERBOSE Sftp(48)[10] SSH: Received packet SSH_MSG_CHANNEL_DATA (124 bytes).
 0000 |5E-00-00-00-00-00-00-00 73-00-00-00-6F-65-00-00| ^.......s...oe..
 0010 |00-07-00-00-00-04-00-00 00-5E-4F-52-41-2D-30-31| .........^ORA-01
 0020 |36-35-34-3A-20-75-6E-61 62-6C-65-20-74-6F-20-65| 654: unable to e
 0030 |78-74-65-6E-64-20-69-6E 64-65-78-20-4D-46-54-43| xtend index MFTC
 0040 |52-50-44-45-56-2E-49-44 58-5F-4D-4D-42-58-5F-31| RPDEV.IDX_MMBX_1
 0050 |38-34-32-32-30-20-62-79 20-31-32-38-20-69-6E-20| 84220 by 128 in 
 0060 |74-61-62-6C-65-73-70-61 63-65-20-4D-46-54-43-52| tablespace MFTCR
 0070 |50-5F-49-4E-44-45-58-0A 00-00-00-00            | P_INDEX.....
2012-05-15 15:27:59.967 INFO Sftp(48)[10] Response: SSH_FXP_STATUS (7, 4, 'ORA-01654: unable to extend index MFTCRPDEV.IDX_MMBX_184220 by 128 in tablespace MFTCRP_INDEX
')
2012-05-15 15:27:59.971 ERROR Sftp(48)[10] Info: Rebex.Net.SftpException: Failure; ORA-01654: unable to extend index MFTCRPDEV.IDX_MMBX_184220 by 128 in tablespace MFTCRP_INDEX
.
   at gbMKS.PEQpz.eCVvJZ(1dRwomZ , Type )
   at gbMKS.PEQpz.1GGhpaZ(PTFpRZ , Boolean )
   at Rebex.Net.Sftp.1xTmHi(Qu2Ci , udycp , String , Stream , Int64 , Int64 , 27NpLhZ )
Applies to: Rebex SFTP

1 Answer

0 votes
answered May 16, 2012 by Mali (320 points)
edited May 16, 2012

The problem is at our server end. Sorry for the post.

commented May 16, 2012 by Lukas Pokorny (107,350 points)
edited May 16, 2012

Thanks for letting us know!

This looks like an SftpException with a Status of SftpExceptionStatus.ProtocolError and these are always raised as a result of an error reported by the server. The "RA-01654: unable to extend index MFTCRPDEV.IDX_MMBX_184220 by 128 in tablespace MFTCRP_INDEX" message was actually sent by the server itself.

...