Connection timed out error in Adapters

Document ID : KB000123969
Last Modified Date : 27/12/2018
Show Technical Document Details
Issue:
Connection time out error in adapters. ORA-01653 error message in t_log file

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:
Business Service Insight 8.3.5
Oracle 11g
Cause:
Size of the tablespace TBS_CSL_DATA_TAB_01 is full and reached the max limit of a file on windows server i.e. default 34GB defined for the tablespace file which cannot be extended as per Microsoft norms
Resolution:
Reached the max file size (Microsoft Max limit for a file) and the only solution is to create a new tablespace for the problematic file.

Note: This is out of support scope and need to reach out to DB Admins/owners to provide you more information on how to extend the table space for the problematic file.