In Integrity, if the SQL Server database compatibility is set to SQL Server 2000 and below, the following error occurs:
Application Error:
System.Data.SqlClient.SqlException: Procedure or function 'IMOC_InsertMods' expects parameter '@Suppressed', which was not supplied.
The statement has been terminated.
at PAS.DAL.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at PAS.DAL.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at PAS.DAL.DataAccessLayer.mCmSaveImage(Guid ObjectID, String PropertyName, Byte[] Image, Int64 Checksum, Boolean IsFile, String UserName, enUpdateMethod UpdateMethod, String ApproversName, String Reason, String StartTime, String DocType, Int32 PropertyAttribute)
at PAS.AssetModeler.Propertee.Save(enUpdateMethod UpdateMethod)
End Application Error
To check database compatibility and prevent this problem:
-
Start SQL Server Management Studio.
-
Connect to the Database Engine using the credentials supplied.
-
Expand Databases, right-click the database, and then click Properties.
-
Select Options on the left.
-
Change the Compatibility level to the highest level available.
