E03020003: Database error [CAI/PT][ODBC Oracle Dynamicdriver][Oracle]ORA-01691: unable to extend lob segmentCA_SCM.SYS_LOB0000055283C00012$$ by 8192 in tablespace HARVESTBLOB

Products

• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Description:

You attempt to perform a check in and you get Oracle error something like below....

E03020003: Database error [CAI/PT][ODBC Oracle Dynamic
driver][Oracle]ORA-01691: unable to extend lob segment
CA_SCM.SYS_LOB0000055283C00012$$ by 8192 in tablespace HARVESTBLOB

Environment

CA Software Change Management

Resolution

The error is in the tablespace HARVESTBLOB, but you will also need to check tablespaces like TEMP and SYSTEM as well.

You will need to involve a DBA person to increase the space.

You can run the following SQL database query to determine the space available in all your data files:

1. Login to sqlplus with the user id and password of the owner of the Harvest tables and run the following:

   	    set feedback off 	 	set pagesize 66 	 	column "Tablespace Name" format a19 	 	column "Used" format 99999990 justify right 	 	column "Free" format 99999990 justify right 	 	column "% Free" format 999.9 justify right 	 	column "File Name (Size)" format a30 	 	 	select y.tablespace_name "Tablespace Name", y.file_name || ' (' || 	 	max(y.bytes) / 1024 || 'K)' "File Name (Size)", 	 	max(y.bytes) / 1024 - nvl(max(x.bytes),0) / 1024 "Used", 	 	nvl(max(x.bytes),0) / 1024 "Free", 	 	nvl(max(x.bytes),0) / max(y.bytes) * 100 " Free%" 	 	from sys.dba_data_files y, sys.dba_free_space x 	 	where y.tablespace_name = x.tablespace_name(+) 	 	and y.file_id = x.file_id(+) 	 	group by y.tablespace_name, y.file_name; 

2. It will provide an output similar to this.

      Tablespace Name File Name (Size) Used Free Free%      ------------------------- --------------------------------------------------- --------- --------- ------      USERS C:\ORACLEXE\ORADATA\XE\USERS.DBF (102400K) 1664 100736 98.4      HARVESTMETA C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\HARVESTMETA.ORA (51200K) 8896 42304 82.6      HARVESTBLOB C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\HARVESTBLOB.ORA (51200K) 29760 21440 41.9      SYSTEM C:\ORACLEXE\ORADATA\XE\SYSTEM. DBF (358400K) 353344 5056 1.4 

      HARVESTINDEX C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\HARVESTINDEX.ORA (51200K) 9408 41792 81.6 

3. From the output, see HARVESTBLOB , HARVESTMETA, and HARVESTINDEX for the Free% column. If any of the tablespaces are low (< 25%), then the DBA needs to extend the tablespace. Also check the physical hard drive disk space to insure it will accommodate the extension.
   
   This is not a Harvest problem, it is a space problem defined in Oracle.
   
   Note:
   As a result of this problem, you may also have to unlock the package that you were trying to check files into.
   To do this you will then have to use hpkgunlk commandline to unlock the package. Insure no one is trying to do Harvest transactions at the time when you perform the hpkgunlk command.