Unable to lgin to Portal
Problem reported by Glen Harvy - July 6 at 7:26 PM
Locked
Not A Problem
Hi,
 
I am getting the following errors when trying to login:
 
=====================
[2018-07-06 3:11:58 AM]
Could not get current user
The ConnectionString property has not been initialized.
System.InvalidOperationException: The ConnectionString property has not been initialized.
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at SmarterTrack.Data.Utilities.QueryRunner.ExecuteReader[T](IDbConnection& conn, Action`2 workFunction, T otherdata, String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Utilities.QueryRunner.ExecuteReader[T](Action`2 workFunction, T otherdata, String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Caching.Lookups.UserIdsByNameCache.#l5m()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at SmarterTrack.Data.Caching.Lookups.UserIdsByNameCache.Lookup(String username)
   at SmarterTrack.Data.Caching.Complete.UserCache.GetByUsername(String username)
   at SmarterTrack.HelperClasses.Security.ManagementUserInfo.GetCurrentUser(HttpContext context)


=====================
[2018-07-06 3:12:28 AM]
Unhandled error
 - Page: [xxxx/HttpHandlers/Portal/User/login.ashx]
 - Referrer: [xxxx/Main/]
 - User Agent: [Mozilla/5.0 (Linux; Android 7.0; SM-T819Y Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36] - IP: [1.144.109.206]
The ConnectionString property has not been initialized.
System.InvalidOperationException: The ConnectionString property has not been initialized.
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at SmarterTrack.Data.Utilities.QueryRunner.ExecuteReader[T](IDbConnection& conn, Action`2 workFunction, T otherdata, String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Utilities.QueryRunner.ExecuteReader[T](Action`2 workFunction, T otherdata, String query, SqlParameter[] parameters)
   at SmarterTrack.Data.Caching.Lookups.UserIdsByNameCache.#l5m()
   at System.Lazy`1.CreateValue()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Lazy`1.get_Value()
   at SmarterTrack.Data.Caching.Lookups.UserIdsByNameCache.Lookup(String username)
   at SmarterTrack.Data.Caching.Complete.UserCache.GetByUsername(String username)
   at SmarterTrack.Data.UserEntity.GetByUsername(String username)
   at SmarterTrack.MRS.Main.HttpHandlers.UserFunctions.#xki(HttpContext #Vxb, JsonTextWriter #xQi)
   at SmarterTrack.MRS.Main.HttpHandlers.UserFunctions.HandleRequest(HttpContext context)
   at SmarterTools.Web.HttpHandlers.HttpHandlerBase.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
 
 
I can do everything else OK and the Self-Diagnostics return no errors.
 
I'll keep looking but has anyone any suggestions. I'm using shared hosting on IIS 10:
:
Info SmarterTrack Version: 14.0.6752
Info Hosting Process: w3wp
Info Pipeline Mode: Integrated
Passed Microsoft.Net Framework Version: 4.0.30319

3 Replies

Reply to Thread
0
Glen Harvy Replied
When I try to login using an incorrect password, it tells me that the password/username is incorrect. When I use the correct password, there is no error message and the screen appears to simply refresh. The Login button remains without any drop down options. When I click forgot password I am sent an email with my username and password.
0
Glen Harvy Replied
I think this may be an IIS 10 induced issue!
0
Andrew Barker Replied
Employee Post
As I advised in your other thread - https://portal.smartertools.com/community/a90849/unable-to-login-after-upgrade-from-v7_x-to-14_x.aspx - we would be able to help you the best if you submitted to a support ticket.
 
Since this is a duplicate of your other thread, I am going to lock this thread, and mark it as Not a Problem.

Andrew Barker
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com