Thursday, July 1, 2010

How To Restore Data In AIFSchemaStore Table

AIFSchemaStore table contains the schema information for all the AIF services in AX

If data is deleted from this table or it doesn't contain the proper schema information then we can not configure endpoint action policy

Steps to regenerate data in AIFSchemaStore table:

1.Delete all data from AIFSchemaStore table
2.Delete all the data from AIFDocumentSchema table
3.Click on refresh button on Services form it will regenerate all the data in AIF SchemaStoretable and documentSchema table
4.To verify after refreshing the services check if In AIFAction table all the actions for services is pointing to the classid of corresponding service class.

4 comments:

  1. I tried and lost all my data... Refresh did not regenerate data for tables AIFSchemaStore & AIFDocumentSchema

    ReplyDelete
  2. I tried and lost all my data... Refresh did not regenerate data for tables AIFSchemaStore & AIFDocumentSchema

    ReplyDelete
  3. It seems that this is valid only for AX 2009 not for AX 2012.

    ReplyDelete
  4. For AX2012 after doing the above you need to run the following:

    AifGlobalSettings globalSettings;
    ;

    ttsbegin;
    select forupdate firstonly globalSettings;
    globalSettings.AifInitialized = NoYes::no;
    globalSettings.update();
    ttscommit;

    AifSetup::initialize();

    ReplyDelete