*This post is locked for comments
This sounds like bug 30381. The bug states - system message 10272 - 'SL User[domain\user] should be associated with one Employee' when logging into Web Apps.
If you do not have any records in the MCSetup table (system DB) and you try to log in to web apps you receive system message 10272 - SL User[domain\user] should be associated with one Employee. If you look at the fmd1.1_app script there is an alter proc for WSL_TMSetup which is looking for records in the MCSetup table so if you do not have anything in this table then you receive the error.
Please run this script against your application database and then see if you can log in.
alter PROCEDURE WSL_TMSetup
@page int
,@size int
,@sort nvarchar(200)
,@UserID varchar(47)
,@WinUser varchar(85)
AS
SET NOCOUNT ON
if (@UserID = '') Begin set @UserID = (SELECT userID FROM vs_USERREC WHERE RecType = 'U' AND [WindowsUserAcct] = @WinUser AND defaultuser = 1) end
IF EXISTS (select * from PJCONTRL where PJCONTRL.control_code = 'PFT' and PJCONTRL.control_type = 'TM')
Begin
SELECT isnull([MCActivated],0),
SUBSTRING(PJCONTRL.control_data,226,1) as [AuditOn],
SUBSTRING(PJCONTRL1.control_data,1,1) as [ManagerReview],
SUBSTRING(PJCONTRL2.control_data,1,1) as [PFTActive],
SUBSTRING(PJCONTRL2.control_data,2,1) as [PFTOneDay],
SUBSTRING(PJCONTRL2.control_data,3,1) as [PFTFutureNotAllowed],
SUBSTRING(PJCONTRL2.control_data,4,1) as [PFTSource],
SUBSTRING(PJCONTRL2.control_data,5,1) as [PFTHideTaskTotal],
SUBSTRING(PJCONTRL2.control_data,6,1) as [PFTCorrecting],
SUBSTRING(PJCONTRL2.control_data,228,1) as [WebEnabled],
SUBSTRING(PJCONTRL.control_data,221, 3) AS [FirstDayOfWeek],
PJEMPLOY.employee as [EmployeeID]
FROM PJEMPLOY
left join vs_mcsetup on 1=1
inner join PJCONTRL on PJCONTRL.control_code = 'SETUP' and PJCONTRL.control_type = 'TM'
inner join PJCONTRL as PJCONTRL1 on PJCONTRL1.control_code = 'MANAGER-REVIEW' and PJCONTRL1.control_type = 'PA'
inner join PJCONTRL as PJCONTRL2 on PJCONTRL2.control_code = 'PFT' and PJCONTRL2.control_type = 'TM'
where PJEMPLOY.user_id = @userid
End
Else
Begin
SELECT [MCActivated],
SUBSTRING(PJCONTRL.control_data,226,1) as [AuditOn],
SUBSTRING(PJCONTRL1.control_data,1,1) as [ManagerReview],
'N' as [PFTActive],
'N' as [PFTOneDay],
'N' as [PFTFutureNotAllowed],
'S' as [PFTSource],
'N' as [PFTHideTaskTotal],
'' as [PFTCorrecting],
'N' as [WebEnabled],
SUBSTRING(PJCONTRL.control_data,221, 3) AS [FirstDayOfWeek],
PJEMPLOY.employee as [EmployeeID]
FROM vs_mcsetup, PJCONTRL,PJCONTRL as PJCONTRL1,PJEMPLOY where
PJCONTRL.control_code = 'SETUP' and PJCONTRL.control_type = 'TM' and PJCONTRL1.control_code = 'MANAGER-REVIEW' and PJCONTRL1.control_type = 'PA'
and PJEMPLOY.user_id = @UserID
End
Share
Report
All responses (
Answers (
30
