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 'txxxx', 'txxxxOLD'; EXEC sp_rename 'txxxxOLD', 'Txxxx'; Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Hugo Ruesga Sent: Thursday, May 09, 2013 9:47 AM To: [email protected] 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 +0000 > From: [email protected] > Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS > To: [email protected] > > 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:[email protected]] On Behalf Of Hugo Ruesga > Sent: Thursday, May 09, 2013 8:50 AM > To: [email protected] > 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 +0000 > > From: [email protected] > > Subject: Re: [URGENT]Use Alter Table Alter Column on Remedy ARS > > To: [email protected] > > > > 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) [[email protected]] > > On Behalf Of Hugo Ruesga [[email protected]] > > Sent: Tuesday, May 07, 2013 21:58 > > To: [email protected] > > 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"
