A1.115 : Prompted Message: Edit Debtor Error - Unknown SQL Exception (Number=9420, Message=XML parsing: line 1, character 209, illegal xml character)

A1.115 : Prompted Message: Edit Debtor Error - Unknown SQL Exception (Number=9420, Message=XML parsing: line 1, character 209, illegal xml character)

Question: When I click on save button after editing a debtor, system prompts me an error message, “Unknown Sql Exception (Number=9420, Message=XML parsing: line 1, character 209, illegal xml character)”. Why?

Xmlparsing1.png


Possible Reason:

There is/are unrecognized xml characters being keyed in debtor information.


Solution:

Remove the unrecognized xml characters. Before this you need to delete the changelog trigger first in order to successfully save the changes.

1) Search and open SQL Management Studio from window search.

Login primary key2.png


2) Connect SQL Server Management Studio.

Login primary key3.png


3) Find the database that contains the error, then expand the database.

Xmlparsing4.png


4) Expand Tables.

Xmlparsing5.png


5) Find a table naming “dBo.Debtor”, then expand the table.

Xmlparsing6.png


6) Expand Triggers.

Xmlparsing7.png


7) Select on DebtorChangeLog.

Xmlparsing8.png


8) Right click on DebtorChangeLog, then click on Script Trigger as > Create To > New Query Editor Window.

Do not close that new query editor windows for now, you will need to use it later.

Xmlparsing9.png


9) Right click on DebtorChangeLog and select on Delete.

Xmlparsing10.png


10) Now, you may edit on Debtor and remove the unrecognized xml characters, then click on Save.

11) After user changed the debtor’s information, go back to SQL Management Studio.

12) Execute the query that was created just now.

Xmlparsing11.png


--Source from AutoCount Wiki --