Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

Posted on by Microsoft Employee

Hello sir,

I installed business portal 5.1 successfully and i can open the site with web browser but if i click on busines portal column or if i want to creat GP repports it throws up this error .

Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8.

Please how do i resolve this.

Thank you

*This post is locked for comments

  • Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    FUNMILAYO,

    Is this a new install or an upgrade?  Based on the error, I would guess that the install failed at some point and wasn't able to complete the assigning of permissions to sql artifacts.  Your best option may be working with support to resolve this issue.

    Thanks

    Rob

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    Hello,

    @Rob

    Thank you for your responce.

    I did what you told me and this is the result:

    (Server Error in '/' Application.

    The SELECT permission was denied on the object 'MC40200', database 'DYNAMICS', schema 'dbo'.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'MC40200', database 'DYNAMICS', schema 'dbo'.

    Source Error:

    The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

    1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

    <%@ Page Language="C#" Debug="true" %>

    or:

    2) Add the following section to the configuration file of your application:

    <configuration>

    <system.web>

    <compilation debug="true"/>

    </system.web>

    </configuration>

    Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

    Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. )

    Stack Trace:

    [SqlException (0x80131904): The SELECT permission was denied on the object 'MC40200', database 'DYNAMICS', schema 'dbo'.]

      System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212

      System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245

      System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1099

      System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +58

      System.Data.SqlClient.SqlDataReader.get_MetaData() +112

      System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6291924

      System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6292993

      System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424

      System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28

      System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +211

      System.Data.SqlClient.SqlCommand.ExecuteReader() +117

      Microsoft.BusinessFramework.Data.SqlAdHocQuery.ExecuteCommand(AdHocStatementBuilder builder) +105

    [GeneralDatabaseException: The SELECT permission was denied on the object 'MC40200', database 'DYNAMICS', schema 'dbo'.]

      Microsoft.BusinessFramework.Data.Storage.StorageUtil.ThrowStorageException(SqlException sqlException) +777

      Microsoft.BusinessFramework.Data.SqlAdHocQuery.ExecuteCommand(AdHocStatementBuilder builder) +476

      Microsoft.BusinessFramework.Data.SqlAdHocQuery.ExecuteAdHocQuery(Object genericParams) +88

      Microsoft.BusinessFramework.Data.Internal.TransactionServicesNative.BeginSupported(CallThroughMethod callThroughMethod, Object passThroughParams) +268

      Microsoft.BusinessFramework.Data.TransactionServices.EstablishContext(TransactionOption requestedOption, IsolationLevel isoLevel, Type targetClass, CallThroughMethod callbackClass, Object passThroughParams) +594

      Microsoft.BusinessFramework.Data.SqlAdHocQuery.ExecuteQuery(AdHocQueryCriteria criteria, EntityPersistenceOptions options, Boolean reverseOrder) +453

      Microsoft.BusinessFramework.Entity.AdHocQueryBlockEnumeratorService.MoveNext(IAdHocQueryBlockReader blockReader, IAdHocQueryBookMark currentDataRow) +981

      Microsoft.BusinessFramework.Security.AdHocQuerySecurityService.MoveNext(IAdHocQueryBlockReader blockReader, IAdHocQueryBookMark currentDataRow) +697

      Microsoft.BusinessFramework.Entity.AdHocQueryBlockEnumerator.MoveNext() +468

      Microsoft.BusinessFramework.Entity.AdHocQuery.GetDataSet(AdHocQueryCriteria criteria) +251

      Microsoft.Dynamics.DynamicsCurrencyProvider.FillCurrencyLookupTable() +648

      Microsoft.Dynamics.DynamicsCurrencyProvider..ctor() +24

      Microsoft.Dynamics.DynamicsCurrencyProvider.Initialize() +90

      ASP.global_asax.Application_PreRequestHandlerExecute(Object sender, EventArgs e) +21

      System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80

      System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

    Version Information: Microsoft .NET Framework Version:2.0.50727.5420; ASP.NET Version:2.0.50727.5420 )

    Please i need your help.

    Thank you

  • Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    FUNMILAYO,

    I'd recommend the following:

    • Open your web.config for the particular SharePoint site.  The path would be something like the following:  d:\inetpub\wwwroot\wss\VirtualDirectories\80.
    • Change CustomErrors to False and CallStack to True, and run through your scenario again.  You should get more detail after doing this.

     

    Thanks

    Rob

  • Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    That doesn't much to go on. At this point I would recommend you open a support case or reach out to your partner to further troubleshoot the issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    Hello,

    Thank you for your responce.

    I am logging with the user that install business portal.

    this what the event viewer is showing:

    Level             Dateandtime                     Source      EventID       Task Category

    Error 1/16/2013 11:40:52 AM   WMI 10 None

    (Event filter with query "SELECT * FROM __InstanceModificationEvent WITHIN 60 WHERE TargetInstance ISA "Win32_Processor" AND TargetInstance.LoadPercentage > 99" could not be reactivated in namespace "//./root/CIMV2" because of error 0x80041003. Events cannot be delivered through this filter until the problem is corrected.)

    Thank you

  • Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    Are you logging in as the user who did the install? What does the error in Event Viewer state?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Business portal error:Correlation ID: 489c0094-fa66-4ef9-bcc1-81f0c1f0bfa8

    Hello sir,

    I installed business portal 5.1 successfully and i can open the site with web browser but if i click on busines portal column or if i want to creat GP repports it throws up this error .

    Error

    An unexpected error has occurred.

    Troubleshoot issues with Microsoft SharePoint Foundation.

    Correlation ID: 4ca506f7-528f-4f12-a576-2d06d841b9df

    Date and Time: 1/12/2013 6:43:13 PM

    Please how do i resolve this.

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans