Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Server Error in '/...
Microsoft Dynamics GP (Archived)

Server Error in '/' Application.

(0) ShareShare
ReportReport
Posted on by P NOUSHAD 1,771

Hi,

I am getting below error from GP business portal.  Please provide solution.

Server Error in '/' Application.
--------------------------------------------------------------------------------

Invalid object name 'SSC02..Hrm_Proxy'.
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: Invalid object name 'SSC02..Hrm_Proxy'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:


[SqlException (0x80131904): Invalid object name 'SSC02..Hrm_Proxy'.]
   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) +2843
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +127
   System.Data.SqlClient.SqlDataReader.get_MetaData() +112
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6338580
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6339649
   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.Storage.EntityQueryResultSet.Read(SqlCommand sqlCommand) +71

[GeneralDatabaseException: Invalid object name 'SSC02..Hrm_Proxy'.]
   Microsoft.BusinessFramework.Data.Storage.StorageUtil.ThrowStorageException(SqlException sqlException) +777
   Microsoft.BusinessFramework.Data.Storage.EntityQueryResultSet.Read(SqlCommand sqlCommand) +321
   Microsoft.BusinessFramework.Data.SqlEntity.ExecuteReadResultSet(EntityBasedSelectStatementBuilder builder, Boolean isCallBackSingleton) +570
   Microsoft.BusinessFramework.Data.SqlEntity.ExecuteRead(EntityCriteria criteria, EntityPersistenceOptions options, Boolean isCallBackSingleton) +447
   Microsoft.BusinessFramework.Data.EntityBroker.GetHandler(Object genericParams) +65
   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.EntityBroker.Get(EntityCriteria criteria, EntityPersistenceOptions options, ActivationReturnArgs& returnValue) +386
   Microsoft.BusinessFramework.Security.EntitySecurityService.Get(EntityCriteria criteria, EntityPersistenceOptions options, ActivationReturnArgs& returnValue) +135
   Microsoft.BusinessFramework.Entity.EntityVirtualCollectionService.Get(EntityCriteria criteria, EntityPersistenceOptions options, ActivationReturnArgs& returnValue) +52
   Microsoft.BusinessFramework.Entity.EntityVirtualCollection.Get(EntityCriteria criteria, EntityPersistenceOptions options, Boolean throwException) +295
   Microsoft.BusinessFramework.Entity.EntityVirtualCollection.Find(WhereExpression whereExpression) +248
   Microsoft.Dynamics.Hrm.Entity.ProxyVirtualCollection.FindByEmployeeIDAndProxyType(String employeeID, ProxyType proxyType) +139
   Microsoft.Dynamics.Hrm.Utilities.ProxyController.QuickIsEmployeeAProxy(Employee employee, ProxyType proxyType) +91
   Microsoft.Dynamics.Hrm.Utilities.ProxyController.IsEmployeeAProxy(Employee employee, ProxyType proxyType) +44
   Microsoft.Dynamics.Hrm.Attendance.TimecardController.GetTimecardEntryRole(String roleString) +231
   Microsoft.Dynamics.Hrm.UI.Attendance.TimecardList.Page_Load(Object sender, EventArgs e) +194
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.8009; ASP.NET Version:2.0.50727.8010

*This post is locked for comments

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Server Error in '/' Application.

    In case you're still looking for the documentation around BP setup, here is a valuable link : 

    https://community.dynamics.com/gp/b/dynamicsgp/archive/2014/02/13/now-available-business-portal-6-1-for-microsoft-dynamics-gp-2013

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Server Error in '/' Application.

    On the server side where BP is installed, you have to go into the control panel and select the Business Portal application, then click on the option 'manage' (or something like this), and run a repair or something similar.. It's been many years I haven't dealt with the setup.

  • P NOUSHAD Profile Picture
    P NOUSHAD 1,771 on at
    RE: Server Error in '/' Application.

    Hi,

    Thanks for your reply and support.  Please let me know where is BP setup wizard, how to run this wizard, kindly help me.

    Regards,

    Noushad

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Server Error in '/' Application.

    Hi  Noushad,

    When you add a new company to GP you have to run the BP setup wizard again to rescan the  DYNAMICS..SY01500 table for any changes to be added to the BP configuration..

    Without this you won't be able to use the new company in BP

  • P NOUSHAD Profile Picture
    P NOUSHAD 1,771 on at
    RE: Server Error in '/' Application.

    Hi,

    I am getting this issue when add new company in GP SO some setup need to be done for enable this company in BP.  Kindly help me to solve this issue.

    Regards,

    Noushad

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Server Error in '/' Application.

    Hi,

    What version of BP are you running ? what platform does it use (Windows & SharePoint) ?

    Did you recently add anything new to your BP configuration ? was it working before ? made any changes to your GP environment ?

    BP settings and the portal are stored in SQL databases and if you do a regular full backup of the system where BP is hosted, you should be able to quickly restore a working environment.

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