Wednesday, 15 June 2016

SmartList Builder Security

All SmartList Builder windows are denied access by default. To use SmartList Builder, the user must be in a POWERUSER role, or be granted access to the following windows in a Microsoft Dynamics GP Security Task:

First go to Security Tasks and select the following as seen in screen below.
Product: Smartlist Builder
Type: Windows
Series: Project
               Go To
               Set Field Options (3 windows)
               SmartList Builder




Second change series to System and select the below as per screen:
·        Background
·        Copy List
·        Display SQL
·        Preview
·        Process Queue
·        Resource Lookup
·        Smartlist Builder Progress
·        Smartlist Lookup
·        Table Details
·        Table Finder(2 items)
·        Upgrade Modified SmartLists





Third - Beyond the Window permissions, there are SmartList Builder Permissions that need to be granted as well.  These SmartList Builder Permissions can be granted in the Microsoft Dynamics GP Security Task as well.
 In same security task change Product to SmartList Builder, Type to SmartList Builder Permissions and Series to SmartList Builder.
·        Create a Go To that opens a Dynamics GP Form
·        Create a Go To that opens a file
·        Create a Go To that opens a website
·        Create a Go To that opens another SmartList
·        Create a Go To that runs a procedure
·        Create SmartLists with SQL Tables
·        Enter Calculated Fields
·        Update SmartList
·        View SmartLists with SQL Tables




Monday, 13 June 2016

Integration manager - Invalid string

Error: The destination could not be initialized due to the following problem input string 


This happens when you run IM as admin and GP as admin BUT - your GP company as a default company marked so when you sign in you have to switch the company you signed in to.

To resolve, remove the 'remember this company' mark from your account just by unclicking it on the sign in window.

Then run GP as admin and select the correct company before getting in and then run IM as admin as well.

Voila!!

It worked for me. Hope it works for you!

Management Reporter Database in Suspect Mode

So you check SQL and notice your backups stop running.

Only to notice it is because your MR database is in suspect mode. To resolve the issue i would first suggest, removing MR from the database backup plan and complete your GP backups.

Then run the below script to resolve the MR suspect mode issue. Then create your separate plan for MR backups.

Script:

EXEC sp_resetstatus ManagementReporter;

ALTER DATABASE ManagementReporter SET EMERGENCY

DBCC checkdb(ManagementReporter)

ALTER DATABASE ManagementReporter SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB (ManagementReporter, REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE ManagementReporter SET MULTI_USER