Error in Data Manager "The field could not be updated"

Error message in Document Manager and approach that was used to fix this issue.
Below are the steps that where used to restore project functionality in this particular case and could wary from case to case. But I believe that this information will help in similar cases.
This issue was result of unsuccessful SQL server change, however it was not determined how this happened and what was the cause. 

" The field could not be updated. Please check the query definition: Cannot update. Database or object is read-only "

 

1. Case : Incorect link in adp files

Projedata.adp and Schema.adp files in %Project_root%\projdata are referencing to wrong database.
Open adp file go to File >Server>Connection  make sure that database and server name match Data Link Properties (Project Administrator>Database>Databases) in Project Administrator.

 2. Case: Incorrect Connection strings in %Project_root%\Project.ini

Check connection strings in  %Project_root%\Project.ini in [DATABASES] section. Change if necessary.

Integrated Security
(Ex: Projdata=Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Database_Name;Data Source=SQL_Server_Name)

Non -Integrated Security
(Ex: Projdata=Password=Password;Persist Security Info=True;User ID=User_Name;Initial Catalog=Database_Name;Data Source=SQL_Server_Name)

 3. Case : Missing primary keys in database.

Delete Integrity.xml and Integrity.xsl from %Project_root% and ConsistencyReports.mdb from  %Project_root%\projdata\ (if these files exist)
Enable Integrity Check in Project Administrator>Edit>Preferences>Integrity Check.
Upgrade project from integrity check results. Right Click on the project Upgrade> From integrity check results.
This should recreate primary keys in database.

 4.Case : Corrupted project.mdb

Copy Project.mdb from C:\Program Files (x86)\Bentley\Plant V8i\Base\Project\Projdata and paste it to %Project_root%\projdata\.
Run Data manager, views should be recreated and linked correctly.


Anonymous