May 07, 2020

[Solved] Logic app error while calling D365FO action GetAzureWriteUrl

Error:
{
  "status"400,
  "message""An error has occurred.  Exception occurred while executing action GetAzureWriteUrl on Entity DataManagementDefinitionGroup: The blob with identifier  could not be obtained.\r\nclientRequestId: ###### ###",
  "error": {
    "message""An error has occurred.  Exception occurred while executing action GetAzureWriteUrl on Entity DataManagementDefinitionGroup: The blob with identifier  could not be obtained."
  },
  "source""###.####.dynamics.com",
  "errors": []
}

Possible reason:

If it's coming on newly added action than you are missing guid, If you modify anything on the action the guid parameter clears itself and you need to put it again.


Solution:

Pass a unique value in the action parameter uniqueFileName  , you can write an expression for guid like guid().

Cheers!!!

Check out my other post on Logic app errors and solutions.

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

May 02, 2020

How to get tableId of tables in D365FO

Hi Folks,

Now when we don't have the leverage of Jobs any more and if you need quick result when you are dealing with multiple tables, try below to get table Id

Option 1: D365FO browser
http://<Environment link>/?cmp=<LegalEntity>&mi=SysTableBrowser&TableName=SysTableIdView

Option 2: SQL server management studio
Run below query

select * from SysTableIdView

Of course, you can filter your queries based on your requirements. 


-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

April 04, 2020

How to enable maintenance mode

Hi Folks,

Now when most of the project management stuff needs to handle via LCS for D365FO project implementation. In each cloud-hosted environment, we use to have the option to enable maintenance mode for an environment. But for DevTest/Demo environments we don’t have that option on LCS. So, here are some steps to enable maintenance mode,
1. Open SQL server management studio (SSMS) in the dev box.
2. Go to AXDB and use the below queries as per your requirement,

a. To check current state
select Value from sqlsystemvariables a where a.PARM = 'configurationmode'

b. To enable maintenance mode
update sqlsystemvariables set VALUE = 1 where PARM = 'configurationmode'

c.  Now you need to restart word wide web service. Sometimes it doesn't work and you need to just restart this service for more than once.

d. Once you done with your activities run below query to disable maintenance mode
update sqlsystemvariables set VALUE = 0 where PARM = 'configurationmode'

3. Whenever you made a change to it.

Cheers!!!
Harry
Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

This post is referenced from MS Docs.