Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
The only message that appears on the Admin is: Field operation failed on server 112 ARRERR (552) Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Wed, 8 May 2013 17:50:10 + From: frederick.w.gro...@xo.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG But what SQL Error are you receiving in the Admin tool? I have had in the past, errors from the Admin tool about Views not being created, and those will not affect ARS (as the DB Views are not used by ARS). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Wednesday, May 08, 2013 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Thanks for your replies. Fred; I'm aware that SQL is not case sensitive, however it must have something to do, since if I attempt to modify any existing field on the forms labeled as t instead of T, I received the SQL error. I turned on the SQL log, but couldn't find any specific message that could lead to determine if the query is failing. However new fields added to the form are available for modification. Really weird, for sure; also I recall do not modifying by SQL ARS table structure, however could find technical notes and it mentions the chance of use Alter table command. But only on DB2. About the other chance mentioned by Phil, that could be the best approach, but I have the limitation about time, table has been there for 10 years, but don't know when it was modified, and data would take more than the time I had (last night i released a new WF on that form for setting rightly RLS field). However if it fails, I'd give a shot to recreate the form from the ground. Even I tried to import the DEV form, but it failed too. but guess I'll need to wait and give a try to Phil's recommendation. Thanks for your response Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- Date: Wed, 8 May 2013 09:47:13 -0500 From: pmurn...@windwardits.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG ** Hugo: I'm working from memory on this solution, so I'd recommend allowing a few hours for other listers to comment on it -- just in case I'm forgetting something. I'd also recommend opening a support incident with BMC to verify the procedure before performing it. If you have a development ARS server, you could export the form and related workflow from the production ARS server, and see if it will import into the development server. If successful, then you could proceed with the following... 1. Stop the ARS services, back up your database, and start the ARS services 2. Export the data from the production form into an .arx file 3. Export the form and related workflow into a .def file 4. Delete the form 1. If a warning appears about join forms that depend on this form, then do not delete and cancel this procedure 2. If the delete fails (eg, ARS is unable to make SQL drop the table), then cancel this procedure, stop the ARS services, restore the database from backup, and start the services again 5. Import the form from the .def file into production 6. Import the data from the .arx file 7. Import the remaining workflow from the .def file This procedure will re-create the form cleanly. HTH, --Phil -Original Message- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
552I would have expected that to show up in the SQL log or the server's arerror.log at least The info for 552 is: An SQL database error occurred during an operation against the database. An associated error message contains the full text of the error message from the database. The error is often a message about running out of space in the database log or data area. You can correct this by increasing the size of the data area or by flushing or increasing the size of the log area. One thing I just thought of ... Is the field you are increasing used in an index? Some database versions can't handle indexes of more than 256 characters total in length (I don't remember specifics on MS SQL Server versions). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Thursday, May 09, 2013 8:50 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS ** The only message that appears on the Admin is: Field operation failed on server 112 ARRERR (552) Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- Date: Wed, 8 May 2013 17:50:10 + From: frederick.w.gro...@xo.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG But what SQL Error are you receiving in the Admin tool? I have had in the past, errors from the Admin tool about Views not being created, and those will not affect ARS (as the DB Views are not used by ARS). Fred Thanks for your response Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
That's the funny part, no error on both logs. Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Thu, 9 May 2013 13:59:17 + From: frederick.w.gro...@xo.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG 552I would have expected that to show up in the SQL log or the server's arerror.log at least The info for 552 is: An SQL database error occurred during an operation against the database. An associated error message contains the full text of the error message from the database. The error is often a message about running out of space in the database log or data area. You can correct this by increasing the size of the data area or by flushing or increasing the size of the log area. One thing I just thought of ... Is the field you are increasing used in an index? Some database versions can't handle indexes of more than 256 characters total in length (I don't remember specifics on MS SQL Server versions). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Thursday, May 09, 2013 8:50 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS ** The only message that appears on the Admin is: Field operation failed on server 112 ARRERR (552) Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- Date: Wed, 8 May 2013 17:50:10 + From: frederick.w.gro...@xo.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG But what SQL Error are you receiving in the Admin tool? I have had in the past, errors from the Admin tool about Views not being created, and those will not affect ARS (as the DB Views are not used by ARS). Fred Thanks for your response Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
If you have the Alter Table SQL command (from the SQL Logs) you may have to try running it manually (and any SQL commands after) to see exactly what the SQL Server error is If you still can't find an error then maybe the ARS Server is trying to do a case sensitive check on the table name. That you can fix by renaming the table (rename it twice as I have seen some cases where just changing the case of the name doesn't recognize that the name is changing): EXEC sp_rename 't', 'tOLD'; EXEC sp_rename 'tOLD', 'T'; Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Thursday, May 09, 2013 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS ** That's the funny part, no error on both logs. Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- Date: Thu, 9 May 2013 13:59:17 + From: frederick.w.gro...@xo.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG 552 I would have expected that to show up in the SQL log or the server's arerror.log at least The info for 552 is: An SQL database error occurred during an operation against the database. An associated error message contains the full text of the error message from the database. The error is often a message about running out of space in the database log or data area. You can correct this by increasing the size of the data area or by flushing or increasing the size of the log area. One thing I just thought of ... Is the field you are increasing used in an index? Some database versions can't handle indexes of more than 256 characters total in length (I don't remember specifics on MS SQL Server versions). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Thursday, May 09, 2013 8:50 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS ** The only message that appears on the Admin is: Field operation failed on server 112 ARRERR (552) Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- Date: Wed, 8 May 2013 17:50:10 + From: frederick.w.gro...@xo.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG But what SQL Error are you receiving in the Admin tool? I have had in the past, errors from the Admin tool about Views not being created, and those will not affect ARS (as the DB Views are not used by ARS). Fred Thanks for your response Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
You should never modify the tables directly. What error are you receiving? (and if you turn on SQL Logs on the server you will see the actual SQL that is being executed) As for the t vs T ... SQL Server is not case sensitive so that should not matter. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Tuesday, May 07, 2013 8:58 PM To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS Importance: High ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
Hugo: I'm working from memory on this solution, so I'd recommend allowing a few hours for other listers to comment on it -- just in case I'm forgetting something. I'd also recommend opening a support incident with BMC to verify the procedure before performing it. If you have a development ARS server, you could export the form and related workflow from the production ARS server, and see if it will import into the development server. If successful, then you could proceed with the following... 1. Stop the ARS services, back up your database, and start the ARS services 2. Export the data from the production form into an .arx file 3. Export the form and related workflow into a .def file 4. Delete the form * If a warning appears about join forms that depend on this form, then do not delete and cancel this procedure * If the delete fails (eg, ARS is unable to make SQL drop the table), then cancel this procedure, stop the ARS services, restore the database from backup, and start the services again 5. Import the form from the .def file into production 6. Import the data from the .arx file 7. Import the remaining workflow from the .def file This procedure will re-create the form cleanly. HTH, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
Thanks for your replies. Fred; I'm aware that SQL is not case sensitive, however it must have something to do, since if I attempt to modify any existing field on the forms labeled as t instead of T, I received the SQL error. I turned on the SQL log, but couldn't find any specific message that could lead to determine if the query is failing. However new fields added to the form are available for modification. Really weird, for sure; also I recall do not modifying by SQL ARS table structure, however could find technical notes and it mentions the chance of use Alter table command. But only on DB2. About the other chance mentioned by Phil, that could be the best approach, but I have the limitation about time, table has been there for 10 years, but don't know when it was modified, and data would take more than the time I had (last night i released a new WF on that form for setting rightly RLS field). However if it fails, I'd give a shot to recreate the form from the ground. Even I tried to import the DEV form, but it failed too. but guess I'll need to wait and give a try to Phil's recommendation. Thanks for your response Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Wed, 8 May 2013 09:47:13 -0500 From: pmurn...@windwardits.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG ** Hugo: I'm working from memory on this solution, so I'd recommend allowing a few hours for other listers to comment on it -- just in case I'm forgetting something. I'd also recommend opening a support incident with BMC to verify the procedure before performing it. If you have a development ARS server, you could export the form and related workflow from the production ARS server, and see if it will import into the development server. If successful, then you could proceed with the following... Stop the ARS services, back up your database, and start the ARS services Export the data from the production form into an .arx file Export the form and related workflow into a .def file Delete the form If a warning appears about join forms that depend on this form, then do not delete and cancel this procedure If the delete fails (eg, ARS is unable to make SQL drop the table), then cancel this procedure, stop the ARS services, restore the database from backup, and start the services again Import the form from the .def file into production Import the data from the .arx file Import the remaining workflow from the .def file This procedure will re-create the form cleanly. HTH, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where
Re: [URGENT]Use Alter Table Alter Column on Remedy ARS
But what SQL Error are you receiving in the Admin tool? I have had in the past, errors from the Admin tool about Views not being created, and those will not affect ARS (as the DB Views are not used by ARS). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Wednesday, May 08, 2013 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Thanks for your replies. Fred; I'm aware that SQL is not case sensitive, however it must have something to do, since if I attempt to modify any existing field on the forms labeled as t instead of T, I received the SQL error. I turned on the SQL log, but couldn't find any specific message that could lead to determine if the query is failing. However new fields added to the form are available for modification. Really weird, for sure; also I recall do not modifying by SQL ARS table structure, however could find technical notes and it mentions the chance of use Alter table command. But only on DB2. About the other chance mentioned by Phil, that could be the best approach, but I have the limitation about time, table has been there for 10 years, but don't know when it was modified, and data would take more than the time I had (last night i released a new WF on that form for setting rightly RLS field). However if it fails, I'd give a shot to recreate the form from the ground. Even I tried to import the DEV form, but it failed too. but guess I'll need to wait and give a try to Phil's recommendation. Thanks for your response Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 -Original Message- Date: Wed, 8 May 2013 09:47:13 -0500 From: pmurn...@windwardits.com Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS To: arslist@ARSLIST.ORG ** Hugo: I'm working from memory on this solution, so I'd recommend allowing a few hours for other listers to comment on it -- just in case I'm forgetting something. I'd also recommend opening a support incident with BMC to verify the procedure before performing it. If you have a development ARS server, you could export the form and related workflow from the production ARS server, and see if it will import into the development server. If successful, then you could proceed with the following... 1. Stop the ARS services, back up your database, and start the ARS services 2. Export the data from the production form into an .arx file 3. Export the form and related workflow into a .def file 4. Delete the form 1. If a warning appears about join forms that depend on this form, then do not delete and cancel this procedure 2. If the delete fails (eg, ARS is unable to make SQL drop the table), then cancel this procedure, stop the ARS services, restore the database from backup, and start the services again 5. Import the form from the .def file into production 6. Import the data from the .arx file 7. Import the remaining workflow from the .def file This procedure will re-create the form cleanly. HTH, --Phil -Original Message- From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga [lord_dyna...@outlook.com] Sent: Tuesday, May 07, 2013 21:58 To: arslist@ARSLIST.ORG Subject: [URGENT]Use Alter Table Alter Column on Remedy ARS ** Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
[URGENT]Use Alter Table Alter Column on Remedy ARS
Guys, Besides that this could be a really silly question. I'd like to check with all of the gurus here. I need to increase the length of the RLS field on Remedy (ARS 7.0.01 patch 007) over a custom development, but when I do this on the Admin, It returns an SQL error, and field is not saved on the form. I went further and find that this table on the properties for the ARSystem DB (SQL Server) the table is labeled as t instead of T, what makes me think that someone had already played with the form. Question here is: Will I broke more at DB if I modify this field by using alter table and alter column commands? Thanks Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years