Re: SQL 2005 to 2008 question
Larry, That error has nothing to do with 2008, it has to do with a bug in the Dev Studio where you are editing a piece of workflow that belongs to a deployable app while you are not in the app..it for some reason has trouble translating the role ID's to names and throws that error, it however doesn't actually remove them from the permission list, so I personally haven't seen issue with it. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes Sent: Tuesday, February 22, 2011 10:41 AM To: arslist@ARSLIST.ORG Subject: SQL 2005 to 2008 question ** Sorry, I should have mentioned that we upgraded to sql 2008 from 2005 and remedy seems to find commas in integer values We have a test server that we brought up using a backup of the database from our production server. The production server is running SQL 2005 and the test server is running 2008. When I run Development Studio and save changes to any form, filter, etc. I get the following error and I'm wondering if anyone has seen this. Group having ID :-30,050 does not exist on the server. This group has been removed from the permission list., 5309, HRMS:EmployeeEntry-FindUserToMirror Thanks for your time, Larry B. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: SQL 2005 to 2008 question
Larry, To the best of my knowledge, commas are never ‘stored’ in an integer value however large it may be in a database. It would have been an illegal character if an attempt was made to save a comma to an integer column. It must be the way your database engine is reading the values when retrieving it from the database. You might want to check some of your global database settings and I won’t be surprised if there is something that has integer columns formatted that way when retrieving values from them.. Joe From: Larry Barnes Sent: Tuesday, February 22, 2011 12:41 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: SQL 2005 to 2008 question ** Sorry, I should have mentioned that we upgraded to sql 2008 from 2005 and remedy seems to find commas in integer values We have a test server that we brought up using a backup of the database from our production server. The production server is running SQL 2005 and the test server is running 2008. When I run Development Studio and save changes to any form, filter, etc. I get the following error and I'm wondering if anyone has seen this. Group having ID :-30,050 does not exist on the server. This group has been removed from the permission list., 5309, HRMS:EmployeeEntry-FindUserToMirror Thanks for your time, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: SQL 2005 to 2008 question
Are there major differences between SQL 2005 and 2008? Kind regards, David David Frankfater Column Technical Services Toll Free 1-866-265-8665 Ext. 332 Cell 630-664-5800 Fax 630-271-1487 dfrankfa...@columnit.com www.columntech.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes Sent: Tuesday, February 22, 2011 11:41 AM To: arslist@ARSLIST.ORG Subject: SQL 2005 to 2008 question ** Sorry, I should have mentioned that we upgraded to sql 2008 from 2005 and remedy seems to find commas in integer values We have a test server that we brought up using a backup of the database from our production server. The production server is running SQL 2005 and the test server is running 2008. When I run Development Studio and save changes to any form, filter, etc. I get the following error and I'm wondering if anyone has seen this. Group having ID :-30,050 does not exist on the server. This group has been removed from the permission list., 5309, HRMS:EmployeeEntry-FindUserToMirror Thanks for your time, Larry B. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
SQL 2005 to 2008 question
Sorry, I should have mentioned that we upgraded to sql 2008 from 2005 and remedy seems to find commas in integer values We have a test server that we brought up using a backup of the database from our production server. The production server is running SQL 2005 and the test server is running 2008. When I run Development Studio and save changes to any form, filter, etc. I get the following error and I'm wondering if anyone has seen this. Group having ID :-30,050 does not exist on the server. This group has been removed from the permission list., 5309, HRMS:EmployeeEntry-FindUserToMirror Thanks for your time, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
SQL 2005 to 2008 question
We have a test server that we brought up using a backup of the database from our production server. The production server is running SQL 2005 and the test server is running 2008. When I run Development Studio and save changes to any form, filter, etc. I get the following error and I'm wondering if anyone has seen this. Group having ID :-30,050 does not exist on the server. This group has been removed from the permission list., 5309, HRMS:EmployeeEntry-FindUserToMirror Thanks for your time, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"