Widget Error

Controller: RocNavigation
Action: Index
Exception: RocCommunicationException

[Status Description] InternalServerError

[Request Resource] api/menu/product/attribute/specific/2a7a6754-e9a7-4958-bf17-ac58d6b105bf/2a7a6754-e9a7-4958-bf17-ac58d6b105bf

[Error Message] The 'br' start tag on line 4 position 132 does not match the end tag of 'title'. Line 4, position 187.

[Error Exception] System.Xml.XmlException: The 'br' start tag on line 4 position 132 does not match the end tag of 'title'. Line 4, position 187.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)
at System.Xml.XmlTextReaderImpl.ParseEndElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.Linq.XContainer.ReadContentFrom(XmlReader r)
at System.Xml.Linq.XContainer.ReadContentFrom(XmlReader r, LoadOptions o)
at System.Xml.Linq.XDocument.Load(XmlReader reader, LoadOptions options)
at System.Xml.Linq.XDocument.Parse(String text, LoadOptions options)
at RestSharp.Deserializers.XmlDeserializer.Deserialize[T](IRestResponse response)
at RestSharp.RestClient.Deserialize[T](IRestRequest request, IRestResponse raw)

[Response Content]


Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.<br>Login failed for user 'bestplumbingapi-tasks-415'.






Server Error in '/' Application.



Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.





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: Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.



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): Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.]
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) +1431
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +1085
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) +57
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +1142
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +312
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +202
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +413
System.Data.SqlClient.SqlConnection.Open() +128
OpenAccessRuntime.Intellitrace.OpenConnection(DbConnection connection, String connectionString, String id) +142
Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) +665

[SQLException: Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.]
Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) +1331
OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) +353

[DatabaseNotFoundException: Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.]
Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) +9
OpenAccessRuntime.ExceptionWrapper.Throw() +13
OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL() +330
OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory() +278
OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory() +608
OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init() +833
OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init() +29
OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet props) +330
OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props) +351
OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open) +1507
OpenAccessRuntime.DatabaseAdapter.GetObjectScope(TransactionProvider provider) +40
Telerik.OpenAccess.OpenAccessContextBase.GetScope() +49
Roc.Core.Data.CommerceContext.Initialize() in F:\agent2018\_work\458\s\Roc\Roc.Core\Data\CommerceContext.cs:288
lambda_method(Closure , IBuilderContext ) +1084
Microsoft.Practices.ObjectBuilder2.<>c__DisplayClass1.<GetBuildMethod>b__0(IBuilderContext context) +35
Microsoft.Practices.ObjectBuilder2.BuildPlanStrategy.PreBuildUp(IBuilderContext context) +335
Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context) +389
Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +451

[ResolutionFailedException: Resolution of the dependency failed, type = "Roc.Contracts.Data.IRepository", name = "(none)".
Exception occurred while: Calling constructor Roc.Core.Data.CommerceContext(Roc.Contracts.Logging.ILoggingService logging, Roc.Contracts.Events.IEventService eventService, Roc.Contracts.Configuration.IConfigurationFileService configurationService, Roc.Contracts.Pipelines.IPipelineService pipelineService, System.String name).
Exception is: DatabaseNotFoundException - Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.
-----------------------------------------------
At the time of the exception, the container was:

Resolving Roc.Core.Data.CommerceContext,(none) (mapped from Roc.Contracts.Data.IRepository, (none))
Calling constructor Roc.Core.Data.CommerceContext(Roc.Contracts.Logging.ILoggingService logging, Roc.Contracts.Events.IEventService eventService, Roc.Contracts.Configuration.IConfigurationFileService configurationService, Roc.Contracts.Pipelines.IPipelineService pipelineService, System.String name)
]
Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +551
Microsoft.Practices.Unity.UnityContainer.Resolve(Type t, String name, ResolverOverride[] resolverOverrides) +20
Microsoft.Practices.Unity.UnityContainerExtensions.Resolve(IUnityContainer container, ResolverOverride[] overrides) +71
Roc.Services.Security.UserService.Create() in F:\agent2018\_work\458\s\Roc\Roc.Services\Security\UserService.cs:330
Roc.WebApi.Global.Application_Start(Object sender, EventArgs e) in F:\agent2018\_work\458\s\Roc\WebApi\Global.asax.cs:29

[HttpException (0x80004005): Resolution of the dependency failed, type = "Roc.Contracts.Data.IRepository", name = "(none)".
Exception occurred while: Calling constructor Roc.Core.Data.CommerceContext(Roc.Contracts.Logging.ILoggingService logging, Roc.Contracts.Events.IEventService eventService, Roc.Contracts.Configuration.IConfigurationFileService configurationService, Roc.Contracts.Pipelines.IPipelineService pipelineService, System.String name).
Exception is: DatabaseNotFoundException - Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.
-----------------------------------------------
At the time of the exception, the container was:

Resolving Roc.Core.Data.CommerceContext,(none) (mapped from Roc.Contracts.Data.IRepository, (none))
Calling constructor Roc.Core.Data.CommerceContext(Roc.Contracts.Logging.ILoggingService logging, Roc.Contracts.Events.IEventService eventService, Roc.Contracts.Configuration.IConfigurationFileService configurationService, Roc.Contracts.Pipelines.IPipelineService pipelineService, System.String name)
]
System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +520
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +176
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +165
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +267
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +341

[HttpException (0x80004005): Resolution of the dependency failed, type = "Roc.Contracts.Data.IRepository", name = "(none)".
Exception occurred while: Calling constructor Roc.Core.Data.CommerceContext(Roc.Contracts.Logging.ILoggingService logging, Roc.Contracts.Events.IEventService eventService, Roc.Contracts.Configuration.IConfigurationFileService configurationService, Roc.Contracts.Pipelines.IPipelineService pipelineService, System.String name).
Exception is: DatabaseNotFoundException - Cannot open database "bestplumbingapi_BhavinP_T508369_04192021" requested by the login. The login failed.
Login failed for user 'bestplumbingapi-tasks-415'.
-----------------------------------------------
At the time of the exception, the container was:

Resolving Roc.Core.Data.CommerceContext,(none) (mapped from Roc.Contracts.Data.IRepository, (none))
Calling constructor Roc.Core.Data.CommerceContext(Roc.Contracts.Logging.ILoggingService logging, Roc.Contracts.Events.IEventService eventService, Roc.Contracts.Configuration.IConfigurationFileService configurationService, Roc.Contracts.Pipelines.IPipelineService pipelineService, System.String name)
]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +523
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +107
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +688










Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3930.0






Stack Trace:
at Roc.Sitefinity.Core.Services.ServiceManager.Get[T](String serviceEndpoint, IRestResponse`1& response, Dictionary`2 parameters, Dictionary`2 segments) in F:\agent2018\_work\458\s\Roc.Sitefinity\Roc.Sitefinity.Core\Services\ServiceManager.cs:line 278
at Roc.Sitefinity.Core.Services.ServiceManager.CachedGet[T](String serviceEndpoint, Dictionary`2 parameters, Dictionary`2 segments, Int32 expireInSeconds, Boolean useSeparateCacheForAuthUsers, Boolean forceRefresh) in F:\agent2018\_work\458\s\Roc.Sitefinity\Roc.Sitefinity.Core\Services\ServiceManager.cs:line 330
at Roc.Sitefinity.Widgets.Layout.Mvc.Models.NavigationModel.InitializeNavigationWidgetSettings(BannerService bannerService, String requestUrl) in F:\agent2018\_work\458\s\Roc.Sitefinity\Roc.Sitefinity.Widgets.Layout\Mvc\Models\NavigationModel.cs:line 400
at Roc.Sitefinity.Widgets.Layout.Mvc.Controllers.RocNavigationController.InitializeModel() in F:\agent2018\_work\458\s\Roc.Sitefinity\Roc.Sitefinity.Widgets.Layout\Mvc\Controllers\RocNavigationController.cs:line 241
at Roc.Sitefinity.Widgets.Layout.Mvc.Controllers.RocNavigationController.get_Model() in F:\agent2018\_work\458\s\Roc.Sitefinity\Roc.Sitefinity.Widgets.Layout\Mvc\Controllers\RocNavigationController.cs:line 154
at Roc.Sitefinity.Widgets.Layout.Mvc.Controllers.RocNavigationController.Index() in F:\agent2018\_work\458\s\Roc.Sitefinity\Roc.Sitefinity.Widgets.Layout\Mvc\Controllers\RocNavigationController.cs:line 179
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.b__12()
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)

Punch-Out

Prefer to shop with Best using e-Procurement & Punch-Out? 

Increased productivity, error reduction, accountability, and quick turnaround are all aspects of any great e-Procurement system that will help save your business money. We want to help make your purchasing process with Best as efficient as possible. This is why we offer
e-Procurement as an option for our customers.

In 2016, not only have we invested in a whole re-branding of our entire online catalog; we have made sure to also invest heavily in an
e-Procurement option to ensure that we can provide you with the most efficient ordering process. 

If you are currently a customer...

and would like to be set up with our e-Procurement services, please contact your sales representative or call us toll free at (800)-448-6710.

If you’re NOT a Best Plumbing Specialties commercial customer...

then what are you waiting for? Call us today and let us help you save time, money and space so you can keep your fixtures and facilities running smoothly and effectively!