SDMS Data Migration for TIBCO Statistica 14.0/ TIBCO Data Science Workbench 1.3 involves taking all the documents stored physically on the SDMS (Statistica Document Management Server) Server to the Statistica Enterprise Meta Database . So obviously there should be enough space in the meta database to allow for the transfer for documents. If the meta database is Oracle and there is not enough tablespace to accommodate all the SDMS documents, the SDMS data migration may throw an error as shown below  with  "ORA-01653:unable to extend table CSMGSTAT in tablespace" :


 

How to resolve "ORA-01653:unable to extend table CSMGSTAT in tablespace" when migrating SDMS Data?

SOLUTION 1:
1. Login to the SDMS Server and determine the SDMS Installation directory
2. Launch Windows Powershell and execute cd [SDMS installation directory]\Data\Documents\
3. Run the command : gci -recurse -file | measure-object -sum length.



"Sum" is the total size of all documents in bytes and "Count" is the number of documents.  Then add the size of basic data of each revision which is roughly 100 bytes per revision.  So in this example, it'd be 55496742 + (100 * 24250) bytes = 57921742 Bytes. Add 20% to the number of bytes you get as a result to allow room for growth of the meta database.

Convert the bytes to GB/MB with the help of Google if necessary to determine the space you would require on the Enterprise meta database for the migration of SDMS documents to proceed successfully.

SOLUTION 2:
1. Remote into the SDMS Server
2. Open File Explorer and navigate to [SDMS installation directory]\Data\Documents\
3. Right Click on the folder and select Properties.Look at size on disk and 20% to allow for growth :



In the above example, ensure there is atleast ~ 8.22 GB of free table space on the Oracle Server to successfully migrate SDMS Documents to Statistica Enterprise Meta Database.