Contributor Administration Error "could not load the XML into the DOM"

This error may ocure after installing Cognos planning if you use SQL server as a content store.

Error Message:

    could not load the XML into the DOM. Reason : -1072896681 Invalid xml declaration

    at character 3 on line 32

Reason:

    Probably the content store has a conflict configuration. In this case it was collation conflict

Solution: 

1. Stop cognos services
2. Delete the content store databse and create it with collation:
3.         SQL_Latin1_General_CP1_CI_AS
4. Open "C:\Program Files\ibm\cognos\c10\bin\FileSys.ini"
5. Delete the line strats with InstanceLock and save the file
6. Start cognos services
7. Open cognos contributor administration and test.

 

Finnally when use SQL server as a content store DB follow the following: 

1. Collation must be insenstive 
2. Collation must use UTF 8 or UTF 16 for encoding