Troubleshooting Tips

Problem 1 - MEMS generating ORDER_BY_NUM error when trying to add a disposition to a case

Solution - MEMS version 3.9.3 that wasn’t entirely tested may have some code blips. For this error, a script that was intended to sort a drop down was the issue. spMEMS_DISP_TYPE_S03.sql

Line endings may differ between your branch and master (LF vs CRLF, for example). This can cause hundreds of merge conflicts which Azure DevOps expects you to merge manually, one by one. Instead:

# From the root of your repository remove everything from the index
git rm --cached -r .

# Change the autocrlf setting of the repository (you may want 
#  to use true on windows):
git config core.autocrlf input

# Re-add all the deleted files to the index
# (You should get lots of messages like:
#   warning: CRLF will be replaced by LF in <file>.)
git diff --cached --name-only -z | xargs -0 git add

# Commit
git commit -m "Fixed crlf issue"

Problem 2 - To solve MEMS Prod build issue as shown in pic

Solution :Check if Prod Database password is save in setting file in files as show in pic