none
Errors in Reporting DB RRS feed

  • Question

  • Hi everyone!

    A few days ago I have found some troubles with synchronization DB Published and DB Reporting. Some Data are different in this two DB. I tried to begin rebuild for Reporting DB, but reporting database refresh stuck in waiting to be processed (sleeping). I have found discussion of the same troubles, but no one of them ware resolved. I have no idea what to do.

    Tuesday, June 3, 2014 6:10 AM

All replies

  • ZearolenoN,

    Set your queue settings to view ALL jobs, and see if there are any errors. Also check the ULS logs fro errors. 

    If you see an error message, please post so that we can help.

    Also, do you have a large number of resources in your pool? that is generally the cause for slow sync or failed sync.


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    Tuesday, June 3, 2014 6:19 PM
    Moderator
  • Hi Adavi, thanks for your reply!

    Yes, we have some errors messages in queue like:

    Project Checkin Failed But Not Blocking Correlation

    or

    Project Save from Project Professional

    Failed But Not Blocking Correlation

    In ULS log found the next messages:

    PWA:http://ddsm-prj2010/PWA, ServiceApp:PWA, User:DIGDES\Kramarev.A, PSI: [RDS] Start processing RDS job 97d6a55c-3d77-4dcb-a1e2-18a7097bd6e5. Message type ReportRefreshMessage. Message: RDB area: Epm, error mode: ContinueOnErrors, lock RDB on errors: False, refresh sleep time: 00:05:00.

    and

    PWA:http://ddsm-prj2010/PWA, ServiceApp:PWA, User:DIGDES\Kramarev.A, PSI: [RDS] ULS Event: ReportingRDBRefreshMessageFailed was associated with exception: System.Data.SqlClient.SqlException: Cannot open database "ddsm-prj2010_Reporting" requested by the login. The login failed.  Login failed for user 'DIGDES\ddsm_prj2010_fa'.    
     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)    
     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)    
     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)    
     at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)    
     at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)    
     at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)    
     at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)    
     at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)    
     at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)    
     at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)    
     at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)    
     at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)    
     at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)    
     at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)    
     at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)    
     at System.Data.SqlClient.SqlConnection.Open()    
     at Microsoft.Office.Project.Server.DataAccessLayer.DAL.GetConnection(DataStoreEnum store)    
     at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.CreateStoredProcedureCommand(String storedProcedureName, SqlParameter[] parameters)    
     at Microsoft.Office.Project.Server.DataAccessLayer.DAL.SubDal.ExecuteStoredProcedureNoResult(String storedProcedureName, SqlParameter[] parameters)    
     at Microsoft.Office.Project.Server.DataAccessLayer.Generated.ReportingMetadataDalBase.EpmRefreshModeStartedNoResult(Nullable`1 RefreshLockOnErrors)    
     at Microsoft.Office.Project.Server.BusinessLayer.ReportingLayer.RdsRefreshMessageProcessor.MarkStartOfRefresh(MessageAreaType messageArea)    
     at Microsoft.Office.Project.Server.BusinessLayer.ReportingLayer.RdsRefreshMessageProcessor.runRDSTransformation(ReportRefreshMessage reportRefreshMessage, Boolean initialStage, Boolean duplicateMessageFound)    
     at Microsoft.Office.Project.Server.BusinessLayer.ReportingLayer.RdsRefreshMessageProcessor.HandleMessage(Message msg, Group messageGroup, JobTicket jobTicket, MessageContext mContext)

    There a lot of other messages, but i'm not sure exactly, which of them could be useful.

    In our resource pool we have about 500-1000 resources, i don't know is it a lot? 

    Wednesday, June 4, 2014 7:24 AM
  • It looks like there is a permission issue for the account that is used to refresh the RDB. Make sure the account has db owner permissions on these databases.-----

    PWA:http://ddsm-prj2010/PWA, ServiceApp:PWA, User:DIGDES\Kramarev.A, PSI: [RDS] ULS Event: ReportingRDBRefreshMessageFailed was associated with exception: System.Data.SqlClient.SqlException: Cannot open database "ddsm-prj2010_Reporting" requested by the login. The login failed.  Login failed for user 'DIGDES\ddsm_prj2010_fa'. 

    -----


    Prasanna Adavi,PMP,MCTS,MCITP,MCT TWitter: @prasannaadavi Blog: http://www.prasannaadavi.com

    Wednesday, June 4, 2014 5:05 PM
    Moderator