866-860-1223

mosaicpaperless
How Can We Help?

Search for answers or browse our knowledge base.

Categories
< All Topics
Print

How to Fix SQL Error 10002 in Eclipse ECM Install

✅ How to Fix SQL Error 10002 in Eclipse ECM Install

🚨 Error 10002 Explained
The SQL Error 10002 typically appears during an Eclipse ECM install and is related to host scripts being skipped. This happens if the SQL Server database compatibility level is not set correctly, causing scripts like host50258 to fail.

👉 Root cause: Compatibility level mismatch or skipped scripts.


✅ Step-by-step fix for Error 10002:

  1. Check SQL Server compatibility level:
  • Open SQL Server Management Studio (SSMS)
  • Right-click your database (e.g., AAAA0001)
  • Select Properties > Options
  • Make sure the compatibility level is set to 160 (SQL Server 2022)
  • Click OK
  1. Run the first SQL script (if needed, run against Astria_Host):
sqlCopyEditIF EXISTS(Select * from dbo.UserSetting where Name='uiLayoutAppearance')
BEGIN
	UPDATE dbo.UserSetting 
	SET Value = JSON_MODIFY(Value, '$.basicDetails', 'show')
    WHERE Name = 'uiLayoutAppearance';
END;
GO

✅ If this succeeds, rerun the database installer.

  1. If the first SQL script doesn’t run:
    Run the following command to mark it complete and skip:
sqlCopyEditINSERT INTO DBVersionHistory VALUES(50250, GETDATE())
  1. Run the following critical SQL commands:

👉 Add CMS AP License:

sqlCopyEditIF (NOT EXISTS( SELECT * FROM LicenseToken WHERE Id = 47))
BEGIN
INSERT INTO LicenseToken ([Id],[LicenseKey],[LicenseType]) VALUES(47,47,10);
END
GO
INSERT INTO DBVersionHistory Values(50255, GETDATE())

👉 Add column to CompanySettings:

sqlCopyEditIF NOT EXISTS(SELECT * FROM sys.columns WHERE name = 'BuiltIn' AND object_id = OBJECT_ID('[CompanySetting]'))
BEGIN
	ALTER TABLE [dbo].[CompanySetting] ADD [BuiltIn] [bit] NOT NULL DEFAULT 0
END
GO
INSERT INTO [Astria_Host].dbo.DBVersionHistory
VALUES(50258, GETDATE())
  1. Rerun server configuration and the installer should complete without errors.

Summary:
By ensuring SQL compatibility is set to 160 and running the necessary SQL scripts, you can resolve Error 10002 and prevent skipped host scripts during Eclipse ECM installation.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
Please Share Your Feedback
How Can We Improve This Article?
Table of Contents