inQuiry: CSP migration & verification steps

As part of CSP migration below data will be migrated:

• Graph DB: "appIcon","posterImage","artifactUrl","downloadUrl","variants","previewUrl","pdfUrl"

• Cassandra DB: hierarchy column will be migrated in questionset_hierarchy table.

• None of the external data (Cassandra DB) for Question object will be migrated. media column will continue to use the proxy url (https://domain_name)

• Live Node (Question or QuestionSet) will be republished to have a new ecar bundle

Migration Dependency:

• All Assets (image, audio, video) should be migrated first. For more details, please refer here

Migration Sequence:

1. All Questions (including visibility Parent) should be migrated first.

2. After Successful migration of Questions, QuestionSet migration should be done.
   

Migration Steps:

1. Execute below queries in neo4j graph database and save the output for later reference

   1. Match(n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Question", "QuestionImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.migrationVersion is null return n.IL_FUNC_OBJECT_TYPE as ObjectType,n.status as Status,count(n) as Count;

   2. Match(n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["QuestionSet", "QuestionSetImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.migrationVersion is null return n.IL_FUNC_OBJECT_TYPE as ObjectType,n.status as Status,count(n) as Count;

2. Deploy Sync-tool and run below command to migrate the data. Migration Sequence has to be maintained for successful migration. You can execute any command from below table as per requirement (based on data volume).

3. After migration, Please use below query to confirm the migration
Question:

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Question", "QuestionImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.migrationVersion is null return n.IL_FUNC_OBJECT_TYPE as ObjectType,n.status as Status,count(n) as Count;

QuestionSet:

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["QuestionSet", "QuestionSetImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" and n.migrationVersion is null return n.IL_FUNC_OBJECT_TYPE as ObjectType,n.status as Status,count(n) as Count;

Note: Count should be 0 (Zero), if the migration is successful

To See exact status of migration, Please use below query:
Question:

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["Question", "QuestionImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return n.IL_FUNC_OBJECT_TYPE as ObjectType,n.status as Status,n.migrationVersion as MigrationVersion,count(n) as Count;

QuestionSet:

Match (n:domain) where n.IL_FUNC_OBJECT_TYPE IN ["QuestionSet", "QuestionSetImage"] and n.IL_SYS_NODE_TYPE="DATA_NODE" return n.IL_FUNC_OBJECT_TYPE as ObjectType,n.status as Status,n.migrationVersion as MigrationVersion,count(n) as Count;


Migration Version Details: