Adapters Connection timed out error

Products

• CA Business Service Insight

Issue/Introduction

Connection time out error in adapters (t_log file):

ORA-01653 error message 

Error: Caught COM ERROR in operation EXECUTE (INSERT INTO T_RAW_DATA....) 

[ORA-01653: unable to extend table BSIADMIN.T_RAW_DATA by 8192 in tablespace TBS_CSL_DATA_TAB_01 (HR: 0x80040e14) (IDispatch error #3092) (Source = OraOLEDB)][(Error #80040e14) (Source = OraOLEDB) (Description = ORA-01653: unable to extend table BSIADMIN.T_RAW_DATA by 8192 in tablespace TBS_CSL_DATA_TAB_01) (NativeError: 675)] 

Environment

CA Business Service Insight 8.3.5.x
Oracle 11g

Cause

Size of the tablespace TBS_CSL_DATA_TAB_01 is full and reached the maximum limit (default 34GB defined for the tablespace file which cannot be extended as per Microsoft)

Resolution

Reached the maximum file size (Microsoft maximum limit for a file) and the only solution is to create a new tablespace for the problematic file.

Note: This is out of scope for Broadcom Support and needs to be addressed by the Oracle DBA