Permissions after upgrade to 7.1
We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
Happy Birthday, Andy! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 9:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
Andy, Also since you say you have upgraded, make sure that after you have ugpraded, the system has all the necessary environments that can run your arcache utility, failing which the system will not be able to use that during system restarts to regenerate the user_cache table if necessary. I recently had that problem on one of our unix servers and it turned out to be an environment issue. And a happy birthday to you.. Joe From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 25, 2008 10:07:31 AM Subject: Re: Permissions after upgrade to 7.1 Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users aregetting a permission error. Nothing changed on the forms that I'm aware of, but now users aregetting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket ismoved from one group to another. Is there some known issue regarding this or am I just really lucky todaysince it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
I found a couple of permissions that were changed on the User Form and corrected that, but now I still have strange behavior. After doing some testing I have found a couple of things: The ARRERR [333] was actually being generated by the user form. On our trouble ticket we have a menu that searches the User form for Assigned Techs. The ARERR [333] appeared to be referring to the status field on the User Form and not the Trouble Ticket. I corrected the permissions and I no longer get that error, but now I have a different problem. The assigned tech field now says No entries in menu, unless you select the Assigned Group that the current user belongs to and then he sees only himself and not the entire group. I believe it has to be a permission problem somewhere because Admin accounts work perfectly. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 25, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 Andy, Also since you say you have upgraded, make sure that after you have ugpraded, the system has all the necessary environments that can run your arcache utility, failing which the system will not be able to use that during system restarts to regenerate the user_cache table if necessary. I recently had that problem on one of our unix servers and it turned out to be an environment issue. And a happy birthday to you.. Joe From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 25, 2008 10:07:31 AM Subject: Re: Permissions after upgrade to 7.1 Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
You will likely find that you need to open field 1 to public to make your application work the way it used to... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 10:17 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 ** I found a couple of permissions that were changed on the User Form and corrected that, but now I still have strange behavior. After doing some testing I have found a couple of things: The ARRERR [333] was actually being generated by the user form. On our trouble ticket we have a menu that searches the User form for Assigned Techs. The ARERR [333] appeared to be referring to the status field on the User Form and not the Trouble Ticket. I corrected the permissions and I no longer get that error, but now I have a different problem. The assigned tech field now says No entries in menu, unless you select the Assigned Group that the current user belongs to and then he sees only himself and not the entire group. I believe it has to be a permission problem somewhere because Admin accounts work perfectly. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 25, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 Andy, Also since you say you have upgraded, make sure that after you have ugpraded, the system has all the necessary environments that can run your arcache utility, failing which the system will not be able to use that during system restarts to regenerate the user_cache table if necessary. I recently had that problem on one of our unix servers and it turned out to be an environment issue. And a happy birthday to you.. Joe _ From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 25, 2008 10:07:31 AM Subject: Re: Permissions after upgrade to 7.1 Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
Andy, Check the permission groups on the Request ID(field id 1) on the source data form. If I remember correctly, the 7.1 User form now has row level access. Thanks, Bryan From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 12:17 PM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 ** I found a couple of permissions that were changed on the User Form and corrected that, but now I still have strange behavior. After doing some testing I have found a couple of things: The ARRERR [333] was actually being generated by the user form. On our trouble ticket we have a menu that searches the User form for Assigned Techs. The ARERR [333] appeared to be referring to the status field on the User Form and not the Trouble Ticket. I corrected the permissions and I no longer get that error, but now I have a different problem. The assigned tech field now says No entries in menu, unless you select the Assigned Group that the current user belongs to and then he sees only himself and not the entire group. I believe it has to be a permission problem somewhere because Admin accounts work perfectly. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 25, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 Andy, Also since you say you have upgraded, make sure that after you have ugpraded, the system has all the necessary environments that can run your arcache utility, failing which the system will not be able to use that during system restarts to regenerate the user_cache table if necessary. I recently had that problem on one of our unix servers and it turned out to be an environment issue. And a happy birthday to you.. Joe _ From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 25, 2008 10:07:31 AM Subject: Re: Permissions after upgrade to 7.1 Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
I LOVE YOU GUYS! That seems to have corrected the problem. Why does the Request ID field have any bearing on that though? My workflow doesn't reference the Request ID. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Tuesday, November 25, 2008 11:35 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 You will likely find that you need to open field 1 to public to make your application work the way it used to... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 10:17 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 ** I found a couple of permissions that were changed on the User Form and corrected that, but now I still have strange behavior. After doing some testing I have found a couple of things: The ARRERR [333] was actually being generated by the user form. On our trouble ticket we have a menu that searches the User form for Assigned Techs. The ARERR [333] appeared to be referring to the status field on the User Form and not the Trouble Ticket. I corrected the permissions and I no longer get that error, but now I have a different problem. The assigned tech field now says No entries in menu, unless you select the Assigned Group that the current user belongs to and then he sees only himself and not the entire group. I believe it has to be a permission problem somewhere because Admin accounts work perfectly. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 25, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 Andy, Also since you say you have upgraded, make sure that after you have ugpraded, the system has all the necessary environments that can run your arcache utility, failing which the system will not be able to use that during system restarts to regenerate the user_cache table if necessary. I recently had that problem on one of our unix servers and it turned out to be an environment issue. And a happy birthday to you.. Joe From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 25, 2008 10:07:31 AM Subject: Re: Permissions after upgrade to 7.1 Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Permissions after upgrade to 7.1
Field ID 1 is the row level permission field, if you don't have access to field 1 you don't have access to the record. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 10:51 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 ** I LOVE YOU GUYS! That seems to have corrected the problem. Why does the Request ID field have any bearing on that though? My workflow doesn't reference the Request ID. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Tuesday, November 25, 2008 11:35 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 You will likely find that you need to open field 1 to public to make your application work the way it used to... _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 10:17 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 ** I found a couple of permissions that were changed on the User Form and corrected that, but now I still have strange behavior. After doing some testing I have found a couple of things: The ARRERR [333] was actually being generated by the user form. On our trouble ticket we have a menu that searches the User form for Assigned Techs. The ARERR [333] appeared to be referring to the status field on the User Form and not the Trouble Ticket. I corrected the permissions and I no longer get that error, but now I have a different problem. The assigned tech field now says No entries in menu, unless you select the Assigned Group that the current user belongs to and then he sees only himself and not the entire group. I believe it has to be a permission problem somewhere because Admin accounts work perfectly. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 25, 2008 10:57 AM To: arslist@ARSLIST.ORG Subject: Re: Permissions after upgrade to 7.1 Andy, Also since you say you have upgraded, make sure that after you have ugpraded, the system has all the necessary environments that can run your arcache utility, failing which the system will not be able to use that during system restarts to regenerate the user_cache table if necessary. I recently had that problem on one of our unix servers and it turned out to be an environment issue. And a happy birthday to you.. Joe _ From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 25, 2008 10:07:31 AM Subject: Re: Permissions after upgrade to 7.1 Double check to make sure that the Group form's data is still correct. We had an issue when upgrading there the upgrade tried to add groups to the form and it resulted in duplicate data. Also you may need to update the server's user_cache for the user (Make a change to the group information for the user so the system will update their user_cache record, and then have the user log back in to the server). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Permissions after upgrade to 7.1 We upgraded one of our servers to 7.1.00 and now some of our users are getting a permission error. Nothing changed on the forms that I'm aware of, but now users are getting the ARERR [333] No access to field:7, which is the status field. This field is supposed to be updated through workflow when a ticket is moved from one group to another. Is there some known issue regarding this or am I just really lucky today since it's my birthday? Windows Server 2003 MSSQL 2000 ARS 7.1.00 Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
