Forum Discussion
MuhammmadZubair
Sep 15, 2022Copper Contributor
I have upgraded DEV environment from 10.0.26 to 10.0.28 and facing error on DB sync.
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.
No RepliesBe the first to reply