Resolution:
Description:
============
The following exceptions are seen when trying to import an SQL based Datasource in CIM:

1). java.sql.SQLException: ORA-12899: value too large for column "CIMUSER"."STG_34398"."CSHORTDESC" (actual: 292, maximum: 256).

2). Error converting string (28-JUN-10) to date for Attribute TEST_DT.

Environment:
==========
TIBCO Product name and version: TIBCO Collaborative Information Manager 8.0.1
Operating System(s): All Operating Systems
Database: Oracle

Symptoms:
========
The error indicated above will be seen in the Event Log in the CIM UI during the Import operation and the import will eventually fail.

Cause:
=====
This has been identified as a known issue and the root cause is that the column type and size for the columns in the staging table that gets created during the import (STG_34398 in this case) is VARCHAR and 256 respectively so it cannot handle data which is too big or of any other type, e.g., Date, etc.

Resolution:
==========
Manually change the size / type of problematic column in staging table.  For example:

1). ALTER TABLE STG_34398 MODIFY (CSHORTDESC varchar2(4000));

2). ALTER TABLE STG_34398 MODIFY (CTEST_DT Date);

Attachments:
===========
None.

References:
==========
None.

Exception while importing an SQL based Datasource in TIBCO Collaborative Information Manager (CIM)