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

Question

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 )

Answer 1

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

Comments

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.