Solution for DM Utility Error during CIF creation stating "RC001"

The CBS Migration data upload process includes DT Utility (SP Tool + DM Tool). Initially SP Tool will be executed on starting "RunAll.bat." On successful completion of this tool, DM Tool will start executing. At times the following few errors occur:

1. Problem in executing transformation job. Job: m_NSS_CIF_RC001_Master_details_V, DM utility will exit.
2. Problem in executing transformation job. Job: m_MIS_CIF_RC001_Master_details_V, DM utility will exit.

(These errors occur when 15-35% of the DM Tool gets completed)

The errors specified are purely related to Oracle and can be solved with the following steps:

Steps for increasing the Processes/sessions:

1. Select Oracle 11G Database

2. Click on Run SQL command (SQL> command window will be opened)

3. SQL > connect

SQL> 

Login as : sys as sysdba
Password: sa

4. SELECT * FROM V$RESOURCES (‘processes’,’sessions’);

The above query shows the current values. This can be increased using the steps below: 

5. Click on Run SQL command (SQL> command window will be opened)

SQL > connect
SQL>
a. Login as sysdba in oracle
b. Execute command - ALTER system SET processes=300 scope=spfile;
c. Restart all Oracle service in services.msc
d. Execute query and check if LIMIT_VALUE = 300
SELECT * FROM v$resource_limit WHERE resource_name IN
('processes','sessions'); 

6. Restart DTUtility 

Note:

1. The Oracle installation and Data upload can be executed preferably in a stand-alone SQL configured PC. (Indiapost Domain linked PCs are not user friendly for CBS Migrations)
2. The Windows 7 professional 32 bit OS with SQL Server 2008 Standard/Express edition combination suits much better for CBS Migrations.
3. If the DM Tool crosses 35% of its processes successfully, then the Upload process will not get interrupted most probably.

Solution Shared by : Saravanan R, DSM Pollachi Division, 8903742541