Symantec IGA

  • Private Community
Back to discussions
Expand all | Collapse all

Post CA IDM Upgrade - ERROR Task Persistence database schema was not upgraded successfully.

  • 1.  Post CA IDM Upgrade - ERROR Task Persistence database schema was not upgraded successfully.

    Posted Oct 20, 2018 02:57 PM

    Hi Team,

     

    We have upgraded CA IDM from 12.6.5 to 12.6.8

     

    When we are running CA IDM server the below error is coming

    (ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 84) Task Persistence database schema was not upgraded successfully.)

     

    i have changed my directory . CA\Identity Manager\IAM Suite\Identity Manager\tools\db\taskpersistence\

     

    please help us to fix the issue, which is the script to be runed on database server, (We have upgraded CA IDM from 12.6.5 to 12.6.8 ) 

    Please let us know what are the steps we need to follow

     

    Thanks you Team

     



  • 2.  Re: Post CA IDM Upgrade - ERROR Task Persistence database schema was not upgraded successfully.

    Posted Oct 22, 2018 10:17 AM

    please help on these



  • 3.  Re: Post CA IDM Upgrade - ERROR Task Persistence database schema was not upgraded successfully.

    Posted Oct 22, 2018 04:35 PM

    What is the complete error stack in the startup sequence? IM should upgrade on first startup.  Clearly it can connect, as it knows it needs to upgrade the schema, but it must not be able to make the required changes.

     

    The server log should make clear why this is not happening. The mostly likely scenario is that the user IM is using to connect to the task persistence database does not have the rights to modify the schema. The simplest solution is to have the DBA temporarily grant this user DBA priviledges and let the upgrade complete and then revert back to the original runtime rights.