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"
