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

Symptoms:
========
None.

Cause:
=====
The following error is thrown:

ORA- -6502 :Error Message :- ORA-06502: PL/SQL: numeric or value error: character string buffer too small Can not create STAGING table fix it through UI

This happens in the migrationForStagingTable.sql file in the %MQ_HOME%\db\oracle\migration\Migrate72_80 directory.  

Resolution:
========
Work around for staging table issue :-

1). Get the list of all catalog input map id’s. This list tells the active input map that the query is:

select ID, sourceorganizationid , name , catalogid from cataloginputmap WHERE sourceorganizationid&gt1 and catalogid in (select id from catalog where  type='CATALOG') and active = 'Y';

There should be staging table for every input map id.

2). Run this query to get the list of not existing staging tables:

select id , name from cataloginputmap where id not in (select TO_NUMBER(SUBSTR(table_name,5)) from all_tables where table_name like 'STG_%') and active ='Y' and sourceorganizationid&gt1 and catalogid in (select id from catalog where  type='CATALOG');

3). Run the CIM application.

4). From the CIM UI go to the input map based on the catalog id and name.

5).  Click on the modify link. Then click on the save button. (no need to modify any data).

6). The corresponding staging table will be created.

7). Re-run step 1 and 2 above to confirm that staging table creation is done for all active InputMaps.

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

Keywords/Tags:  
=============
None

ORA- -6502 :Error Message seen when running the DatabaseMigration script.