Executing the following SQL: Aces_PostImportProcess System.Data.SqlClient.SqlException: Invalid object name 'Aces.dbo.SharedReference'.
This error occurs when the default database name of 'ACES ' is not used for the caching database. To resolve this error edit the stored procedure [Aces_ImportSharedReferences]. Change the line
select SoxDocuments.DocumentId, sd2.DocumentId as ParentId from
Aces.dbo.SharedReference sr1
to reference the correct database. For example, if your Aces caching database is set to ACES_CACHE then update the line to read
select SoxDocuments.DocumentId, sd2.DocumentId as ParentId from
ACES_CACHE.dbo.SharedReference sr1