I have upgraded DEV environment from 10.0.26 to 10.0.28 and facing error on DB sync.

Copper Contributor

Error: PdsBatchAttribCode of data source PdsBatchAttribByItem does exist in the database or the configuration key on the field or on Extended Data Type used by the field is off


Solution:

1. Enable the maintenance mode on the environment.

  • Go to AXDB and use the below queries as per your requirement,
  • To check the current state
    select Value from sqlsystemvariables a where a.PARM = 'configurationmode'
  • To enable maintenance mode
    update sqlsystemvariables set VALUE = 1 where PARM = 'configurationmode'
  • Now you need to restart word wide web service.
    Open the Command prompt as admin and run iisreset
  • Once you done with your activities run below query to disable maintenance mode
    update sqlsystemvariables set VALUE = 0 where PARM = 'configurationmode'

2. log in to D365 and go to License configuration

3. And under the Configuration Key 

 Go to Process Distribution and Enable Batch attribute->Batch attribute and save the setting.


 

 

0 Replies