Prerequisites:

  1. All SP patches related to SSA from SDC website should have been updated. Any issue in updation to be taken up with SDC for solution
  2. Only Post and Sign db to be restored. Other scheme data need not be deleted. The tool can be run with all schemes. The SSA stand alone tool will extract only SSA accounts. No major change in the migration process.

Tool to be used:

  1. DataProfilingTool_V6.6_DOP_Package_SSA.zip
  2. SSA Standalone tool v2.0

Path for downloading the tool:

/CBSDM/incoming/Production/ONE_MIGRATION_TOOL/01-June-15

Procedure to upload SSA data


1. Restore the Post and Sign DB.
2. Run the premigration tool and DBanalyser Tool. No Dbanalyser clearance is required.
3. Run the DPT 6.6. Clear all the discrepencies.
4. Do the day end. The day end and system date should be same.
5. Run the SSA Stand alone Tool v2.0. The tool should not be run from Desktop or C drive
6. On completion of the tool, run the CBS keys PO version.
7. Share the SP Tool and DM Tool path, DMCC file with PDFs to DMCC under the Subject name - SSA Migration – PONAME - SOLID
8. The T Report sent by DMCC should be signed by Postmaster and the same should be scanned and sent to DMCC by email. Electronic T Recon sign off will not be considered

Solution for errors noticed in SSA Migration

1. Post mandatory tables missing: SSA_fee

Reason - It is seen that a column name ‘arrears’ is missing in the SSA_Fee table. It can be viewed in the Postextraction_exception file available in the ‘DM Utility/SP Tool_All/Post_Extract’ or the ‘DM Utility/SP Tool_All/Output file’. 
Solution – Take up with SDC
2. Older version of SP Tool used:
Reason - The system date and day end date is not same
Solution – Ensure both dates are equal
3. Failed to connect to database:
Reason - This issue occurs in DPT stage itself. Have to check the DPT logs available in the 
‘SPtool_All/Dataprofiling tool’
Solution – SSA patches not updated properly