Re: what is T1 used for? RESOLVED
** many thanks to all for these replies. At the end it turned that kicking the loggin from the master database it solved the problem. Cheers serouche Guillaume Rheault wrote: ** RE: what is T1 used for? Well I take that back!! That was for old versions of ARS (4.x). I checked in a ARS 7.5 with ITSM 7.5.1 and T1 is the table for form "AR System Message Catalog" The User form is related to form T30...how about that! So I guess the only way to know is querying the arschema table -Guillaume -Original Message- From: Guillaume Rheault Sent: Thu 05/14/09 9:26 AM To: arslist@ARSLIST.ORG; arslist@ARSLIST.ORG Subject: RE: what is T1 used for? In most situations, T1 is the table related to the User form... Of course if the User form was dropped and recreated or anything like that, the User form table could be another T table -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Remedy Maniac Sent: Thu 05/14/09 4:26 AM To: arslist@ARSLIST.ORG Subject: what is T1 used for? dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: what is T1 used for?
Well I take that back!! That was for old versions of ARS (4.x). I checked in a ARS 7.5 with ITSM 7.5.1 and T1 is the table for form "AR System Message Catalog" The User form is related to form T30...how about that! So I guess the only way to know is querying the arschema table -Guillaume -Original Message- From: Guillaume Rheault Sent: Thu 05/14/09 9:26 AM To: arslist@ARSLIST.ORG; arslist@ARSLIST.ORG Subject: RE: what is T1 used for? In most situations, T1 is the table related to the User form... Of course if the User form was dropped and recreated or anything like that, the User form table could be another T table -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Remedy Maniac Sent: Thu 05/14/09 4:26 AM To: arslist@ARSLIST.ORG Subject: what is T1 used for? dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: what is T1 used for?
RE: what is T1 used for?Hi, 1. You can cache an admin user using the arcache utility, see your documentation for details. 2. You can restore T1 and user_cache tables using your recent database backup. Regards, Nicky Madjarov phone: 973-202-4278 Find out how to bust your AR System performance @ http://www.SpeedUpARS.com - Original Message - From: Guillaume Rheault Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, May 14, 2009 9:26 AM Subject: Re: what is T1 used for? ** In most situations, T1 is the table related to the User form... Of course if the User form was dropped and recreated or anything like that, the User form table could be another T table -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Remedy Maniac Sent: Thu 05/14/09 4:26 AM To: arslist@ARSLIST.ORG Subject: what is T1 used for? dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: what is T1 used for?
In most situations, T1 is the table related to the User form... Of course if the User form was dropped and recreated or anything like that, the User form table could be another T table -Guillaume -Original Message- From: Action Request System discussion list(ARSList) on behalf of Remedy Maniac Sent: Thu 05/14/09 4:26 AM To: arslist@ARSLIST.ORG Subject: what is T1 used for? dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: what is T1 used for?
There is a support-provided downloadable tool that allows you to "force" a new admin-enabled record for just such an occassion. You'd be far from the first person to blow away their admin-enabled accounts and get locked out. Check the support site, or some other kind soul might post an external link to their personal copy. Once you get it, keep that tool handy. It doesn't happen often in one's career, but it DOES happen... From: Remedy Maniac To: arslist@ARSLIST.ORG Sent: Thursday, May 14, 2009 4:26:52 PM Subject: what is T1 used for? dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
AW: what is T1 used for?
Serouche, I'm not familiar with sybase, but on some DB's (e.g. Informix) changing the length from 255 to 4000 causes a datatype change of the column. If that's the case ARS creates a new column with the new datatype, copy's the data from old to new column, drops old column and renames new column to old column name. I think there was some problem and ARS has already created the new column. If you try to do the same again, the db is complaining about already existing column name. But to be sure whats going on, turn on SQL-Logging and you'll see the failing sql statement. HTH Regards Conny PS: The new columns are generally named Z. So if youre changing field with ID 536870915 from 255 to 4000, your new column name will be C536870915Z. Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac Gesendet: Donnerstag, 14. Mai 2009 10:49 An: arslist@ARSLIST.ORG Betreff: Re: what is T1 used for? ** thank you Misi. It's realy good to know there are people out there who care about others. My problem is now solved. It's still unclear to me what was the issue. But as a matter of fact here is what happend: I was trying to modify a character field from a length of 255 to 4000 I did the change on the dev server and it went ok On the production the Admin tool answered back some problems and that T1 could not be found on the server (Sybase). Right after this no connection was possible anymore. My DBA checked and he could see ARAdmin is logged into master which should not be. And where T1 is not. So kicked ARAdmin out of master so I could login again. But then just to display the list of forms in the admin tool was hanging for ever So I thought it could be somehow T1 But as I see T1 is for Message Catalog. So I don't see the relation. But anyway. Has anybody already experienced something similar? By the way, now I am able to access the forms but if I try to perform the same change I did on dev, I get an error that the column exists 2 times in the table. Strange, no? Serouche Misi Mladoniczky wrote: Hi, T1 corresponds to a Remedy-form, and data needs to be copied parallel with the H1 and B1 table. To understand which form this is, you must check the ARSCHEMA-table. The T1 table may be completely different. select name from arschema where schemaid=1 The above SQL will give you the form name. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: what is T1 used for?
** thank you Misi. It's realy good to know there are people out there who care about others. My problem is now solved. It's still unclear to me what was the issue. But as a matter of fact here is what happend: I was trying to modify a character field from a length of 255 to 4000 I did the change on the dev server and it went ok On the production the Admin tool answered back some problems and that T1 could not be found on the server (Sybase). Right after this no connection was possible anymore. My DBA checked and he could see ARAdmin is logged into master which should not be. And where T1 is not. So kicked ARAdmin out of master so I could login again. But then just to display the list of forms in the admin tool was hanging for ever So I thought it could be somehow T1 But as I see T1 is for Message Catalog. So I don't see the relation. But anyway. Has anybody already experienced something similar? By the way, now I am able to access the forms but if I try to perform the same change I did on dev, I get an error that the column exists 2 times in the table. Strange, no? Serouche Misi Mladoniczky wrote: Hi, T1 corresponds to a Remedy-form, and data needs to be copied parallel with the H1 and B1 table. To understand which form this is, you must check the ARSCHEMA-table. The T1 table may be completely different. select name from arschema where schemaid=1 The above SQL will give you the form name. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_
Re: what is T1 used for?
Hi, T1 corresponds to a Remedy-form, and data needs to be copied parallel with the H1 and B1 table. To understand which form this is, you must check the ARSCHEMA-table. The T1 table may be completely different. select name from arschema where schemaid=1 The above SQL will give you the form name. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > dear all, > > I am not able to access my server with the admin tool anymore. > T1 is empty. > I suspect this must be the problem. > How and when and why that happend, is really not my concern. > I'll investigate later. > What I need right now is to know how to recover? > Can I simply copy the content of T1 from my dev server to my prod? > Many thanks for your help > Serouche > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
what is T1 used for?
dear all, I am not able to access my server with the admin tool anymore. T1 is empty. I suspect this must be the problem. How and when and why that happend, is really not my concern. I'll investigate later. What I need right now is to know how to recover? Can I simply copy the content of T1 from my dev server to my prod? Many thanks for your help Serouche ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"