Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

No user with username IIS APPPOOL\MyWebsite was found Cannot insert the value NULL into column 'fkSynchedUser', table 'NewJabil.dbo.tblSynchedUserRelations'; column does not allow nulls. INSERT fails.

Vote:
 

Hi All,

Whenevr I am trying to access any page in view mode I am getting following error,But i am able to view the page in edit mode,

MyWebsite is the name of App Pool which is being used by application

:

No user with username IIS APPPOOL\MyWebsite was found
Cannot insert the value NULL into column 'fkSynchedUser', table 'NewJabil.dbo.tblSynchedUserRelations'; column does not allow nulls. INSERT fails.

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: No user with username IIS APPPOOL\MyWebsite was found
Cannot insert the value NULL into column 'fkSynchedUser', table 'NewJabil.dbo.tblSynchedUserRelations'; column does not allow nulls. INSERT fails.

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): No user with username IIS APPPOOL\MyWebsite was found
Cannot insert the value NULL into column 'fkSynchedUser', table 'NewJabil.dbo.tblSynchedUserRelations'; column does not allow nulls. INSERT fails.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3279580
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +791
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4927
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +442
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3114
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +554
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +475
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +386
   EPiServer.Data.Providers.<>c__DisplayClass32.b__31() +15
   EPiServer.Data.Providers.<>c__DisplayClass35`1.b__34() +192
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +967
   EPiServer.Security.SynchronizingUserService.SynchronizeUserAndClaims(String userName, IEnumerable`1 claims) +337
   EPiServer.Security.WindowsRoleProvider.GetRolesForUser(String username) +647
   System.Web.Security.RolePrincipal.GetRoles() +272
   System.Web.Security.d__4.MoveNext() +72
   System.Security.Claims.d__51.MoveNext() +411
   System.Security.Principal.d__95.MoveNext() +230
   System.Linq.WhereSelectEnumerableIterator`2.MoveNext() +118
   System.Linq.d__63`1.MoveNext() +333
   System.Collections.Generic.HashSet`1.UnionWith(IEnumerable`1 other) +107
   System.Collections.Generic.HashSet`1..ctor(IEnumerable`1 collection, IEqualityComparer`1 comparer) +156
   EPiServer.Security.VirtualRoleToClaimConverter.AddClaims(IPrincipal principal) +873
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +92
#150455
Jun 18, 2016 23:33
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.