• Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
  • Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In

    Dell EMC SourceOne Email Management: Journal jobs fail as the SourceOne Archive is not attached to SQL

    Summary: Journal jobs fail as the SourceOne Archive is not attached to SQL. Error: Cannot communicate with the database.

    Symptoms



    Journal jobs go into fail state and below errors are logged under  ExJBJournal.exe.log: CoExASDB::InitInternal|ERROR| Cannot communicate with the database. (0x86040400) {Cannot open database "ArchiveDatabase_Name" requested by the login. The login failed. Native error: 4060 SQL State: 42000 } |CoExASDB.cpp(272)

    CExASProvider::LogonDS|ERROR-LOGD| The connection string value is invalid: %1.  (0x8604011E) Cannot communicate with the database. (0x86040400) [ExJBJournal.exe, CoExASDB.cpp(272).CoExASDB::InitInternal]   >{Cannot open database "ArchiveDatabase_Name" requested by the login. The login failed. Native error: 4060 SQL State: 42000 } |CExASProvider.cpp(310)

    CCoExRepository::LogOn|ERROR| Unable to LogonDS to repository Archive Connection |CoExRepository.cpp(279)

    CExProviderGW::GetRepositoryFolder|ERROR| No data provider found for repository Archive Connection (0x86042E02) The connection string value is invalid: %1.  (0x8604011E) [ExJBJournal.exe, CExASProvider.cpp(310).CExASProvider::LogonDS]   >Cannot communicate with the database. (0x86040400) [ExJBJournal.exe, CoExASDB.cpp(272).CoExASDB::InitInternal]   >{ Cannot open database "ArchiveDatabase_Name" requested by the login. The login failed. Native error: 4060 SQL State: 42000 } |CExProviderGW.cpp(3467)

    Cause

    The cause for the connection issues with SourceOne Archive database is due to Es1Archive being detached from SQL server.
    The Es1Archive was not attached to the SQL server or instance holding SourceOne databases.

    Resolution

    To resolve the issue, attach the Es1Archive database .mdf file to the SQL server instance holding SourceOne databases.
    Note: In some environments, SourceOne databases may be on different SQL servers.

    SourceOne Email Management

    Product

    SourceOne, SourceOne Discovery Manager, SourceOne Email Management

    Last Published Date

    20 Nov 2020

    Version
    Article Type

    Solution