Unable to add new users – v6.3 May 2014 patch
18 June, 2014
Hi,
After updating to the latest patch (v6.3, yellowfin-20140523-update), we are unable to add new users. The command starts execution but never finishes. It creates a blocking transaction on the SQL Server (2005 SP4) which then ties up everything else.
I've tried using different browsers as well (MSIE, Firefox, Chrome). No joy.
Attached is the Info.jsp data.
Please investigate and correct.
Regards,
Chris
Additional: We have rolled back our app to the Feb 2014 version. We were able to add new users.
After updating to the latest patch (v6.3, yellowfin-20140523-update), we are unable to add new users. The command starts execution but never finishes. It creates a blocking transaction on the SQL Server (2005 SP4) which then ties up everything else.
I've tried using different browsers as well (MSIE, Firefox, Chrome). No joy.
Attached is the Info.jsp data.
Please investigate and correct.
Regards,
Chris
Additional: We have rolled back our app to the Feb 2014 version. We were able to add new users.
Hi Chris,
we were able to reproduce the issue over here so a defect has been raised with HIGH priority (Support Task 164952) and will be fixed for the next patch on Friday 27th June.
Thanks for alerting us to this defect, and apologies for the inconvenience caused.
regards,
Dave
we were able to reproduce the issue over here so a defect has been raised with HIGH priority (Support Task 164952) and will be fixed for the next patch on Friday 27th June.
Thanks for alerting us to this defect, and apologies for the inconvenience caused.
regards,
Dave
Hi Chris,
I should have added, there is actually a workaround to this issue, and that is to use the User Import facility. I know you have already rolled back to the Feb build, however I just thought it was worth you knowing.
If you do want to import users then please make sure that the final column "Role Code" uses values from the RoleCode column in the OrgRole table (e.g. YFADMIN not "System Administrator")
regards,
Dave
I should have added, there is actually a workaround to this issue, and that is to use the User Import facility. I know you have already rolled back to the Feb build, however I just thought it was worth you knowing.
If you do want to import users then please make sure that the final column "Role Code" uses values from the RoleCode column in the OrgRole table (e.g. YFADMIN not "System Administrator")
regards,
Dave
Hi Chris,
Good news.
The defect has now been fixed and will be included in the upcoming patch release on Friday June 27th.
Please let me know if you have any concerns on this.
Regards,
David
Good news.
The defect has now been fixed and will be included in the upcoming patch release on Friday June 27th.
Please let me know if you have any concerns on this.
Regards,
David
Hi,
Just applied the July 2014 patch, and still cannot add a user.
Version is 6.3. see attached file for app info.
App does try to invoke but just churning with no resulting addition of user.
Also noticed that some fields in New User form are pre-populating (see below).
Need a fix for this issue.
Thanks,
Chris
Just applied the July 2014 patch, and still cannot add a user.
Version is 6.3. see attached file for app info.
App does try to invoke but just churning with no resulting addition of user.
Also noticed that some fields in New User form are pre-populating (see below).
Need a fix for this issue.
Thanks,
Chris
Hi Chris,
I updated our installation of your prod YF 6.3 from earlier this year to the July build and found like you that I couldn't create new users, so have raised the priority of the task to HIGH to make sure it is fixed for the next patch. In the meantime did you try the workaround mentioned above?
regards,
Dave
I updated our installation of your prod YF 6.3 from earlier this year to the July build and found like you that I couldn't create new users, so have raised the priority of the task to HIGH to make sure it is fixed for the next patch. In the meantime did you try the workaround mentioned above?
regards,
Dave
Hi Chris,
please ignore the previous response, we have found the problem can be solved by turning on Snapshot Isolation for the Yellowfin repository. Just run the 2 ALTER queries as explained in this Microsoft web page
Please let us know whether this works for you (it should, I have tested it on our installation of your DB over here.)
regards,
Dave
please ignore the previous response, we have found the problem can be solved by turning on Snapshot Isolation for the Yellowfin repository. Just run the 2 ALTER queries as explained in this Microsoft web page
Please let us know whether this works for you (it should, I have tested it on our installation of your DB over here.)
regards,
Dave