Monday, 23 March 2015

Insufficient rights to execute Menu Item Create default favorite group.: Script for do visible navigation pane in AX 2012

Hi,
I was restoring demo data (*.bak) file into our instance but when I opened to AX 2012 R3 it was completely blank means no any modules visible and giving one error: "Insufficient rights to execute Menu Item Create default favorite group."

Then  I wrote and executed  one query in SQL Server Management Studio and it's fixed. Completed initial checklist and enjoying DAXing....

UPDATE USERINFO SET SID = 'S-1-5-21-2146773085-903363285-719344707-1910427'

UPDATE SYSBCPROXYUSERACCOUNT SET SID = 'S-1-5-21-1721254763-462695806-1538882281-2782893'

UPDATE SYSUSERINFO SET SQMUSERGUID = '00C6CD72-3148-4317-9324-1A3B11169379'

DELETE FROM SYSSERVERCONFIG

DELETE FROM SYSSERVERSESSIONS

DELETE FROM SYSCLIENTSESSIONS

DELETE FROM SRSSERVERS

DELETE FROM BATCHSERVERCONFIG

DELETE FROM BATCHSERVERGROUP

DELETE FROM SYSUSERLOG

DELETE FROM BICONFIGURATION

DELETE FROM BIANALYSISSERVER

DELETE FROM SMMPHONEPARAMETERS

DELETE FROM EPGlobalParameters

DELETE FROM EPWebSiteParameters

Happy DAXing......

1 comment: