Error "Unable to Create Activity Project Entry!" when restoring files from NuGenesis SDMS - WKB14168

SYMPTOMS

The following error message appears when restoring files from NuGenesis SDMS:

"Unable to Create Activity Project Entry! Please see Log File for Restore Summary."

ENVIRONMENT

• NuGenesis 9 SDMS
• NuGenesis 8 SDMS

CAUSE

Database Tablespace is 99% or full.

FIX or WORKAROUND

1. Run the sdms_db_monitor_r10.sql script.
2. Look through the script log to determine what tablespace needs more space.
3. Contact Waters support or your DBA team to increase tablespace.

Sample SQL command to add a data file to a tablespace:

Please note that this command uses a datafile path that is applicable only to Oracle databases on Windows machines. The data file location and name, and the tablespace name, must be customized to the database and tablespace prior to running the command on the database.

ALTER TABLESPACE SDMS70LOBDATA ADD DATAFILE 'F:\ORACLE\PRODUCT\ORADATA\WATLI1\NGSDMS70LOB_23.DBF' SIZE 100M
AUTOEXTEND ON NEXT 50M MAXSIZE 7999M;

ADDITIONAL INFORMATION

The error message refers to an "Activity Project entry". The NuGenesis Restore client uploads a new entry to the SDMS System Activities project in NuGenesis each time a user restores a file. If for any reason the NuGenesis Restore client can't add this project entry, the above error message appears. Most times, this error message can be traced to a problem in the NuGenesis database.

In most cases, the cause of this issue is that the Windows account that is doing the restore must have WRITE permission to the folder "\Program Files (x86)\NuGenesis 8.0\UV" to create a temporary log file in it and upload that to the "SDMS_System_Activities" project.