web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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,821

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

I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    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.

  • P NOUSHAD Profile Picture
    P NOUSHAD 1,821 on at

    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,058 Moderator on at

    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,821 on at

    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,058 Moderator on at

    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.

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans