{"id":95,"date":"2016-06-08T11:14:27","date_gmt":"2016-06-08T11:14:27","guid":{"rendered":"http:\/\/www.enhisecure.com\/isecureblog\/?p=95"},"modified":"2016-07-14T19:41:35","modified_gmt":"2016-07-14T15:11:35","slug":"identityiq-migration-from-mysql-to-oracle-database","status":"publish","type":"post","link":"https:\/\/www.enhisecure.com\/isecureblog\/2016\/06\/08\/identityiq-migration-from-mysql-to-oracle-database\/","title":{"rendered":"IdentityIQ Migration from MySQL to Oracle database"},"content":{"rendered":"

Sailpoint’s<\/a> IdentityIQ<\/a>\u00a0migration from Oracle Database<\/a> to MySQL<\/a> could probably cause a problem with \u00a0work items, event logs, identity requests. Creation of work items, event logs, identity requests fail with the following error :<\/p>\n

“unable to find the sequence”<\/a><\/p>\n

The problem was caused because of migration to the Oracle database<\/a>. Sailpoint’s<\/a> IdentityIQ<\/a> sql script for MySQL<\/a>\u00a0in\u00a0IdentityIQ<\/a> creates these sequences as tables and the same is translated into the\u00a0Oracle database<\/a>.<\/p>\n

Here is how you solve the problem:-<\/p>\n

IdentityIQ<\/a> has 3 sequences in all.<\/p>\n

    \n
  1. identityiq.spt_syslog_event_sequence.<\/li>\n
  2. identityiq.spt_identity_request_sequence.<\/li>\n
  3. identityiq.spt_work_item_sequence.<\/li>\n<\/ol>\n

    We can find the current values of these sequences by the following \u00a0queries on your new Oracle Database<\/a>:<\/p>\n

    select * from spt_syslog_event_sequence\r\n\r\nselect * from spt_identity_request_sequence\r\n\r\nselect * from spt_work_item_sequence<\/pre>\n
    Drop all these tables by the following queries:<\/p>\n
    drop table spt_syslog_event_sequence;\r\n\r\ndrop table spt_identity_request_sequence;\r\n\r\ndrop table spt_work_item_sequence;<\/pre>\n
    Create the required sequences by the following queries:<\/p>\n
    create sequence identityiq.spt_syslog_event_sequence start with <current_sequence_value> increment by 1 nocache;\r\n\r\ncreate sequence identityiq.spt_identity_request_sequence start with <current_sequence_value> increment by 1 nocache;\r\n\r\ncreate sequence identityiq.spt_work_item_sequence start with <current_sequence_value> increment by 1 nocache;<\/pre>\n
    Now that we have the sequences in place , creation of event logs, \u00a0work items, identity requests will be working fine.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Sailpoint’s IdentityIQ\u00a0migration from Oracle Database to MySQL could probably cause a problem with \u00a0work items, event logs, identity requests. Creation of work items, event logs, identity requests fail with the following error : “unable to find the sequence” The problem was caused because of migration to the Oracle database. Sailpoint’s IdentityIQ sql script for MySQL\u00a0in\u00a0IdentityIQ […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,15,14],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-identity-governance","category-implementation-problems","category-sailpoint"],"_links":{"self":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":8,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/posts\/95\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.enhisecure.com\/isecureblog\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}