Hi Team,
We have a utility which creates users in yellowfin database. For some reason we are getting the web service 27 exception during the user creation.
I see that, Yellowfin is throwing below error while user creation –
BMC:SR:2018-05-16 08:34:08:DEBUG (AdministrationService:remoteAdministrationCall) - Successfully authenticated user: siadmin
BMC:SR:2018-05-16 08:34:08:DEBUG (AdministrationService:remoteAdministrationCall) - Creating Session
BMC:SR:2018-05-16 08:34:08:DEBUG (WebServicesSessionManager:newSession) - Session f2ede77b75b6cc48f03c3b3f8c50c2c6 has been created...
BMC:SR:2018-05-16 08:34:08:DEBUG (AdministrationService:remoteAdministrationCall) - Processing function: ADDUSERSIGNOREDUPLICATES
BMC:SR:2018-05-16 08:34:08:DEBUG (DBAction:<init>) - Establishing database connection for sourceId null
BMC:SR:2018-05-16 08:34:08:DEBUG (AdministrationService:addUsers) - Creating New User via Webservices...
BMC:SR:2018-05-16 08:34:08:DEBUG (MIAdminProcess:checkExistingEmail) - Entering checkExistingEmail()
BMC:SR:2018-05-16 08:34:08:DEBUG (IpContactManager:searchCurrentUserByEmail) - Entering method searchCurrentUserByEmail()
BMC:SR:2018-05-16 08:34:08:DEBUG (IpContactManager:searchCurrentUserByEmail) - IpContact SELECT SQL:
SELECT a.IpId, a.ContactTypeCode, a.ContactCode, a.CountryDialCode,
a.AreaDialCode, a.PhoneNbr, a.EmailAddress, a.PreferredContact,
a.ContactFormatCode, a.EncodeContent
FROM IpContact a, IpClass b
WHERE a.ContactTypeCode = 'EMAIL'
AND a.EmailAddress = N'tzvi_r@snifim.blroot'
AND a.IpId = b.IpId
AND b.StartDate <= '20180516'
AND b.EndDate > '20180516'
BMC:SR:2018-05-16 08:34:08:DEBUG (IpContactManager:searchCurrentUserByEmail) - Method searchCurrentUserByEmail() completed successfully
BMC:SR:2018-05-16 08:34:08:DEBUG (DBAction:disconnect) - Terminating Database connection
BMC:SR:2018-05-16 08:34:08: INFO (AdministrationService:remoteAdministrationCall) - WebserviceException caught: 27(ROLE_NOT_FOUND)
BMC:SR:2018-05-16 08:34:08:DEBUG (AdministrationService:remoteAdministrationCall) - remoteAdministrationCall() completed with status: FAILURE
Attached the logs.
The same problem 
Hi,
I have also noticed that all the OOTB roles in yellowfin exist as it is. There is no change in roles names nor the description.
Regards,
Bharath
Hi,
I have also noticed that all the OOTB roles in yellowfin exist as it is. There is no change in roles names nor the description.
Regards,
Bharath
Hi Bharath,
This means that the value you are passing to the role property of the administration person object does not exist currently. To figure out what this should be, you can go into the "orgrole" table of the configuration database and see what exactly the acceptable values are.
Nathan
Hi Bharath,
This means that the value you are passing to the role property of the administration person object does not exist currently. To figure out what this should be, you can go into the "orgrole" table of the configuration database and see what exactly the acceptable values are.
Nathan
Hi Nathan,
Thanks for looking into this. I have below roles from the orgrole table:
YFADMIN
YFCORPWRITER
YFDASHBOARDCONSUMER
YFREPORTCONSUMER
YFREPORTWRITER
As per my understanding users should get created with any of the above roles.
Regards,
Bharath
Hi Nathan,
Thanks for looking into this. I have below roles from the orgrole table:
YFADMIN
YFCORPWRITER
YFDASHBOARDCONSUMER
YFREPORTCONSUMER
YFREPORTWRITER
As per my understanding users should get created with any of the above roles.
Regards,
Bharath
Hi Bharath,
Yes these are the default roles, but you can also specify any roles you create manually. Once created, you will need to reference this table to see what value YF assigned to use in the user creation call.
Let me know if this makes sense.
Nathan
Hi Bharath,
Yes these are the default roles, but you can also specify any roles you create manually. Once created, you will need to reference this table to see what value YF assigned to use in the user creation call.
Let me know if this makes sense.
Nathan
Thanks Nathan, I have deleted and recreated the problematic roles.
Now the users are created successfully.
-Bharath
Thanks Nathan, I have deleted and recreated the problematic roles.
Now the users are created successfully.
-Bharath
Hi Bharath,
Very glad to hear it, I am going to close this one.
Nathan
Hi Bharath,
Very glad to hear it, I am going to close this one.
Nathan
Replies have been locked on this page!