Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / SL 2015 Web Apps •1027...
Microsoft Dynamics SL (Archived)

SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Greetings, I installed a test setup of Dynamics SL 2015 with SQL Server 2012, Web Services, and Web Apps all on the same Windows Server 2008 R2 computer. I used our existing Dynamics SL 2011 FP1 databases and updated them using Database Maintenance.

I am at the point where I can log into Web Apps but each account I try returns the error "10272 - SL User [username] should be associated with one Employee."

I have tried the solutions in the following posts but I still get the error:

https://community.dynamics.com/sl/f/35/t/124807

https://community.dynamics.com/sl/f/35/t/143138

I haven't installed CU1 yet either.

Any other ideas?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Tengo el mismo problema y ya lo tengo  asignado a un empleado 

    Esp

    4087.1.PNG

    7612.2.png

    File   WebClientLogs

    18/10/2016 11:17 a. m. Login Login Success User 'MSBUSINESS\SOPORTEADMIN' logged into company GCG on ASP.NET Session 'zjtlzf00oucsz0wn4j2422ge' (Client ::1)
    18/10/2016 11:17 a. m. Login Access Rights Failure 10272 - El usuario de SL SYSADMIN debe estar asociado con un empleado. ()
    18/10/2016 11:25 a. m. Login Login Failure The user name or password provided is incorrect. (Client: 192.0.1.142)
    18/10/2016 11:25 a. m. Login Login Success User 'MSBUSINESS\RTAPIA' logged into company GCG on ASP.NET Session 'ad25gyv4iekury2dryjhpowo' (Client 192.0.1.142)
    18/10/2016 11:25 a. m. Login Access Rights Failure 10272 - El usuario de SL RTAPIA debe estar asociado con un empleado. ()
    18/10/2016 11:38 a. m. Logout Logout A forced Logout occurred because ASP.NET Session 'zjtlzf00oucsz0wn4j2422ge' is terminating
    18/10/2016 11:46 a. m. Logout Logout A forced Logout occurred because ASP.NET Session 'ad25gyv4iekury2dryjhpowo' is terminating

    File  WebServiceLogs

    14/10/2016 02:07 p. m. LoginWindows OnBehalfOfAccountException SM~~9902~~Dynamics SL Message 9902: La Cuenta MSBUSINESS\soporteadmin est? intentando utilizar OnBehalfOf. La Cuenta debe pertenecer al rol de TrustedWebService.~~~~ (Consumer: 192.0.0.49)
    at Microsoft.Dynamics.SL.WebServices.Session.LoginWindows.LoginWindows(LoginWindowsContext context)
    14/10/2016 02:09 p. m. LoginWindows OnBehalfOfAccountException SM~~9902~~Dynamics SL Message 9902: La Cuenta MSBUSINESS\soporteadmin est? intentando utilizar OnBehalfOf. La Cuenta debe pertenecer al rol de TrustedWebService.~~~~ (Consumer: 192.0.0.49)
    at Microsoft.Dynamics.SL.WebServices.Session.LoginWindows.LoginWindows(LoginWindowsContext context)
    14/10/2016 04:18 p. m. DefaultSLUserFromWindowsUser FormatException String was not recognized as a valid DateTime. (Consumer: 192.0.0.49)
    at System.DateTime.ParseExact(String s, String[] formats, IFormatProvider provider, DateTimeStyles style)
    at System.Data.SqlTypes.SqlDateTime.Parse(String s)
    at Microsoft.Dynamics.SL.WebServices.SLSecurity.Security.Authorize(String fullyQualifiedMethodName, Guid session)
    at Microsoft.Dynamics.SL.WebServices.WebMethodPattern.Run[T1,T2,TResult](String methodName, Guid session, Func`3 method, T1 arg1, T2 arg2)
    14/10/2016 04:18 p. m. DefaultSLUserFromWindowsUser FormatException String was not recognized as a valid DateTime. (Consumer: 192.0.0.49)
    at System.DateTime.ParseExact(String s, String[] formats, IFormatProvider provider, DateTimeStyles style)
    at System.Data.SqlTypes.SqlDateTime.Parse(String s)
    at Microsoft.Dynamics.SL.WebServices.SLSecurity.Security.Authorize(String fullyQualifiedMethodName, Guid session)
    at Microsoft.Dynamics.SL.WebServices.WebMethodPattern.Run[T1,T2,TResult](String methodName, Guid session, Func`3 method, T1 arg1, T2 arg2)

    Espero me puedan apoyer.

    Saludos.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    I did get it resolved. I ended up doing what Jeremy said to do with re-running the scripts after I found the correct field for the ID.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Scott,

    Go ahead and run the following scripts and let me know if you return more than one item for each.

    --run in app DB

    --replace SYSADMIN with the SL user that is being used for web apps

    select USER_id,employee,* from pjemploy where user_id='SYSADMIN'

    --run in system DB

    --replace domain\user with the domain\user associated with the web apps login

    select WindowsUserAcct,DefaultUser,* from userrec where windowsuseracct='domain\user' and defaultuser='1'

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Scott,

    Can you send me your WebClientLog and WebServiceLog located under C:\ProgramData\Microsoft Dynamics SL?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Hi Jeremy,

    I've done all that.  The only way I could seem to solve the problem is to make an Employee/Resource record whose ID matches the SL User ID.  It's not enough to put the SL ID on the Employee/Resource screen if the ID# is different from the SL User.  This is a big issue.  We already have our Employee IDs established and they are of a different scheme that what we use for SL User IDs.  Seems like a bug to me - since the SL User ID is linked to the Employee/Resource ID#, they shouldn't have to be the same, nor should we have to change key fields for this function.  Any thoughts on that?

    Thanks,

    Scott

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Rerun database upgrade and then run the web apps SQL scripts again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Hi Casey,

    Did you ever get this resolved?  I'm on Web Apps CU1 and am having a similar issue.  When I DON'T have a User ID in the Employee and Resource Maintenance screen, I can log on to Web Apps, but get the error that I don't have an associated SL user set up.  After adding the SL User ID to the Employee/Resource Maintenance screen, I can no longer log in to Web Apps at all.  I enter my password and just get bounced back to the logon screen.  If I go back in and remove the SL User ID from the Employee and Resource Maintenance screen, I can log on to Web Apps but of course can't access any Project screens in Web Apps.  Any ideas??

    Thanks,

    Scott

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    Thank you! I was missing the Employee ID field in PA.EMP.00. I kept looking for the ID field at the top of the screen and it is actually half-way down in the left column of fields on the screen.

    Once I added the ID, now the log in completes, but the screen just flashes back to the log in screen.

    The error log states that there is an Access Rights Failure when logging in.

    7/24/2015 8:48 AM Login Login Success User '[removed the username]' logged into company [removed company name] on ASP.NET Session 'onmp004kxjvqhqvm5oefv0r0' (Client ::1)

    7/24/2015 8:48 AM Login Access Rights Failure An unexpected exception occurred while checking Access Rights to Project Timecard: Column 'PostTimesheetsDirectly' does not belong to table Result Set 0. (Client: ::1)

    7/24/2015 8:48 AM Menu ArgumentException Column 'PostTimesheetsDirectly' does not belong to table Result Set 0. (Client: ::1)

    at System.Data.DataRow.get_Item(String columnName)

    at Microsoft.Dynamics.SL.Mobile.MDTMTCEModel.TMSetupInformation.GetTMSetupInformation(String SLUserId, String WinUserId, Guid session)

    at Microsoft.Dynamics.SL.Mobile.ProjectTimecard.ProjectTimecardController.InitializeSession(HttpRequestBase activeRequest, HttpResponseBase activeResponse, HttpSessionStateBase activeSession)

    at Microsoft.Dynamics.SL.Mobile.ProjectTimecard.ProjectTimecardController.InitializeForMenuItem(HttpRequestBase activeRequest, HttpResponseBase activeResponse, HttpSessionStateBase activeSession)

    at Microsoft.Dynamics.SL.Mobile.HomeController._Lambda$__23()

    7/24/2015 8:48 AM Logout Logout Client logged out on ASP.NET Session 'onmp004kxjvqhqvm5oefv0r0'

    I looked trough the database and did not find any table with the column 'PostTimesheetsDirectly'.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SL 2015 Web Apps •10272 - SL User [username] should be associated with one Employee.

    You will need to associate the Employee ID with an SL User ID in the Employee and Resource Maintenance screen (PA.EMP.00).

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans