Home
  •  

General Data Access Layer error while getting connection strings

General_Data_Access_Layer_error_while_getting_connection_strings_1_Rule (Rule)

Knowledge Base article:

Management Pack
Summary

The Data Access Layer reads information from the configuration database of the Windows SharePoint Services farm when a Project Server application server is starting. The configuration database contains system infrastructure information, including the location of the Project Server databases. If a Project Server application server cannot obtain this information from the configuration database, it cannot start.

 
Causes

Probable causes include:

  • Infrastructure availability problems that affect the configuration database or the SQL Server computer where the configuration database is hosted.
  • Credential issues with the service account. This can be caused by a failure to propagate an account or a changed password, or the account has been locked out.
  • Incomplete or incorrect information in the configuration database due to a partial farm restore of an older copy of the configuration database that doesn’t contain the Project Server information.
 
Resolutions

Depending on the root cause of the issue, you might use the troubleshooting guides in the following list to resolve the problem or restore the configuration database from backup.

Possible resolutions include:

  • If the problem is due to network connectivity problems between the Project Server application servers and SQL Server computers, see the Knowledge Base article, How to troubleshoot network connectivity problems at http://go.microsoft.com/fwlink/?LinkID=72704&clcid=0x409.
  • If the problem is due to SQL connectivity issues, see the Knowledge Base article, How to troubleshoot connectivity issues in SQL Server 2000 at http://go.microsoft.com/fwlink/?LinkID=72705&clcid=0x409.
  • If the problem is due to incorrect data in SQL, see the Knowledge Base article, Disaster Recovery Articles for SQL Server at http://go.microsoft.com/fwlink/?LinkID=72706&clcid=0x409.
  • In the case of an out-of-step restore of the configuration database with no possibility of rolling forward based on database logs, it is recommended that you reinstall Project Server and restore its data from backup into the new databases.
 
© %StartDate%-%EndDate% %CompanyName%, all rights reserved.

Element properties:

TargetMicrosoft.Office.ProjectServer.2007.Microsoft_Office_Project_Server_2007_Application_Servers_Installation
CategoryEventCollection
EnabledTrue
Event_ID7699
Event SourceOffice SharePoint Server
Alert GenerateTrue
Alert SeverityError
Alert PriorityLow
RemotableTrue
Alert Message
General Data Access Layer error while getting connection strings

$Data/EventDescription$
Event LogApplication
CommentMom2005ID='{9BA5FF7A-3030-46C5-9270-4E2846C4022F}';MOM2005ComputerGroupID={0CC3D849-D95B-4E04-8C8C-4268D9401457}

Member Modules:

ID Module Type TypeId RunAs 
_F6DA1507_12AF_11D3_AB21_00A0C98620CE_ DataSource Microsoft.Windows.EventProvider Default
CollectEventData WriteAction Microsoft.SystemCenter.CollectEvent Default
CollectEventDataWarehouse WriteAction Microsoft.SystemCenter.DataWarehouse.PublishEventData Default
GenerateAlert WriteAction System.Mom.BackwardCompatibility.AlertResponse Default

Source Code:

<Rule ID="General_Data_Access_Layer_error_while_getting_connection_strings_1_Rule" Target="Microsoft.Office.ProjectServer.2007.Microsoft_Office_Project_Server_2007_Application_Servers_Installation" Enabled="true" ConfirmDelivery="true" Comment="Mom2005ID='{9BA5FF7A-3030-46C5-9270-4E2846C4022F}';MOM2005ComputerGroupID={0CC3D849-D95B-4E04-8C8C-4268D9401457}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_F6DA1507_12AF_11D3_AB21_00A0C98620CE_" Comment="{F6DA1507-12AF-11D3-AB21-00A0C98620CE}" TypeID="WindowsLibrary!Microsoft.Windows.EventProvider">

      <ComputerName>$Target/Host/Property[Type="WindowsLibrary!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

      <LogName>Application</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="String">PublisherName</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>Office SharePoint Server</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value>7699</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.AlertResponse">

      <AlertGeneration>

        <GenerateAlert>true</GenerateAlert>

        <Owner/>

        <Description>

            $Data/EventDescription$

          </Description>

        <AlertLevel>40</AlertLevel>

        <ResolutionState/>

        <Source>

            $Data/PublisherName$

          </Source>

        <Name>General Data Access Layer error while getting connection strings</Name>

      </AlertGeneration>

      <InvokerType>0</InvokerType>

    </WriteAction>

    <WriteAction ID="CollectEventData" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="CollectEventDataWarehouse" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

  </WriteActions>

</Rule>