BMC - User creation failed in yellowfin database with web service 27 code exception

Bharath Kumar shared this problem 6 years ago
Resolved

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.

Replies (6)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
2

Thanks Nathan, I have deleted and recreated the problematic roles.

Now the users are created successfully.

-Bharath

photo
1

Hi Bharath,

Very glad to hear it, I am going to close this one.

Nathan

Leave a Comment
 
Attach a file