Re: I don't want my users using the old user tool
Hello Serouche you could use the keyword VERSION to check the version of the user tool, and if the returned value is less than 6 than do a close window, that will prevent the users from using a older version of the UT. kind regards shafqat --- Serouche Rahimpour [EMAIL PROTECTED] wrote: Hi, some smart people are using the User tool version 4 against my ARS server version 6.00.01. They do this only to avoid the web interface because their Opera or whatever bloody browser is not good enough for them when using it on ARS. Actually to be totally honnest, they use Firefox 1.5 on Linux which is not listed in the Matrix. Anyway, I'd like to somehow educate these lost sheeps and make the old user tool not accessible to their use. Any idea/suggestion/help how to do this ? Thanks Serouche ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Shafqat Ayaz __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: I don't want my users using the old user tool
Hello Serouche The easiest way to achieve this will be to set the server setting Minimum API Setting (in Admin tool , Server Information , Configuration) For example, to only allow 6.3 clients to connect to your server, set the Minimum API version to 11. Please note that this will block any client which does not use the 6.3 API. So if you are using the mid-tier or any custom written API, it needs to use the 6.3 API, or it will be blocked. I suspect the API version for 6.0.1 is 10, but you will need to confirm this. Hope this helps Jacques Andre [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Mid-Tier Installation error
Hi List, I am trying to install mid-tier 6.3 on Apache 2.2.2 with mid-tier inbuilt ServletExec, but while installation i am getting the below error : * Enter port number [] Installing ServletExec AS in /usr/local/NewAtlanta/ServletExecAS Error constructing mod_servletexec.so Verify that the compiler and link-editor specified by $CFG_CC and $CFG_LD_SHLIB in your 'apxs' script are in your PATH. Also verify that the 'apxs' script has been properly installed. The installation log file (/tmp/SEinstall.log) has more details about these problems. If you continue to have problems then please forward the error messages and to [EMAIL PROTECTED] ServletExec installation aborting on failure! See /tmp/SEinstall.log for log of installation. Exiting ServletExec AS installer... egrep: can't open /usr/local/NewAtlanta/ServletExecAS/config/webadapter.properties mkdir: Failed to make directory /usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec /ServletExecData; No such file or directory chmod: WARNING: can't access /usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec/Ser vletExecData ./mt_install: /usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec/ServletExecData/oe m.properties: cannot create Please suggest. Thanks Sam
Mid-Tier: Session timeout - Wrong login/password
** Hi all! After timeout on Mid-Tier 7.0p1 user see a message Session timeout After logout or simply close the browser, user can't login again with own login/password - got authorization error that login/password invalid. In the Administrator I see than user connected and license given for him. Solution for this situation have 2 variance: 1 - Manually release user in Administrator. 2 - user must logging under different login/password, logout, and then login with own login/password. How can I solve this problem? С уважением, With best wishes, Вербовик Максим Дивизион программных решений INLINE Technologies Телефон: +7 (495) 721 3505 (доб. 393) Факс: +7 (495) 131 4529 Моб.: +7 (926) 351 6738, +7 (927) 200 2520 Maxim Verbovik Software solutions division INLINE Technologies Tel.: +7 (495) 721 3505 (ext. 393) Fax: +7 (495) 131 4529 Mob.: +7 (926) 351 6738, +7 (927) 200 2520 This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. __20060125___This posting was submitted with HTML in it___
Re: Spam:Re: I don't want my users using the old user tool
yes setting the API version is probably the best way. At least for me. Thanks to Carlos for his precise reference. Though this solution does not fully satisfy becasue I'd like to have a nice message as well explaining the user why he cannot connect anymore and what he should do. The default message coming with the ARSystem could be improved ;-) The problem is that I don't see how I should set my AL or filters to fire ? I have choosen that my users will not open the Home page. So I don't want to change this as I have more than 500 users. And so I don't see on which form my AL or filters should fire. Maybe I shall better create a hidden form to be opened upon connection ... hmmm ... Any other idea ? Serouche Jacques Andre wrote: Hello Serouche The easiest way to achieve this will be to set the server setting Minimum API Setting (in Admin tool , Server Information , Configuration) For example, to only allow 6.3 clients to connect to your server, set the Minimum API version to 11. Please note that this will block any client which does not use the 6.3 API. So if you are using the mid-tier or any custom written API, it needs to use the 6.3 API, or it will be blocked. I suspect the API version for 6.0.1 is 10, but you will need to confirm this. Hope this helps Jacques Andre [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Is it possible to create and write an Oracle DATE type field from Remedy?
** Sure, to the point, you can use a View form and you are off to the races! Matt White White Consulting, Inc. 201.248.0438 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nicoll, Alan Sent: Thursday, July 13, 2006 12:44 PM To: arslist@ARSLIST.ORG Subject: Re: Is it possible to create and write an Oracle DATE type field from Remedy? Yes. Ive got a request to recreate a current application in Remedy. The current application has an Oracle table at its base that uses an Oracle Date type field and it has many reports and other applications linked to it that use that Date field. Is there any way I can recreate that structure using Remedy as the front end? -Alan (Nick) Nicoll BGO/PSG/WFBU/DocuSP Problem Management System Administrator 8*823-5081 ESC1-615 From: Matthew White [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 12, 2006 5:59 PM Subject: Re: Is it possible to create and write an Oracle DATE type field from Remedy? Alan, What do you mean by create and write an Oracle Date type field from Remedy? Are you saying that you want to do this on the fly within ARS? Matt White White Consulting, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Nicoll, Alan Sent: Wednesday, July 12, 2006 7:21 PM To: arslist@ARSLIST.ORG Subject: Is it possible to create and write an Oracle DATE type field from Remedy? If so, how is it done? Alan E (Nick) Nicoll DocuSP Problem System Administrator Xerox Corporation Xerox Centre Drive, MS: ESC1-615 El Segundo, CA 90245 Phone 310 333-5081 Internal 8*823-5081 Fax 310 333-6898 [EMAIL PROTECTED] XEROX Technology Document Management Consulting Services www.xerox.com This email and any files transmitted with it are confidential and intended solely for the use of the addressee. If you have received this email in error please delete it. Any views or opinions presented in this email are solely those of the sender and do not necessarily represent those of Xerox Corporation. Finally, the recipient should check this email is authentic and examine it for the presence of viruses. Xerox does perform virus checks but cannot accept liability for any damage caused by any virus transmitted by this email. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy integration with CVS
** Tim, Without getting into a back and forth In whole, source control is a good thing. In fact, if you do work in the financial, insurance or pharmaceutical companies it is mandated. While Remedy doesnt play 100% nice with MS SourceControl the good points outway the bad points IMO. From what I am reading below (i.e., people on vacation) it sounds like a process issue more than anything. I am not sure who doesnt like the idea of being able to look at the differences between code for a given object from one point to another to track down a root cause and/or potential bug. Moreover, I enjoy having the ability to rollback to a previous version of an object with a few clicks. Matt White White Consulting, Inc. 201.248.0438 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Wednesday, July 12, 2006 10:40 PM To: arslist@ARSLIST.ORG Subject: Re: Remdy integration with CVS Or you could try the CVS proxy plug-in for SCC. (SCC is Microsoft's API/protocol for SourceSafe.) I've played with it on development AR servers, and it works OK. I've never tried it for extended periods or on production servers. Still, it's a nice little tool... http://www.pushok.com/soft_cvs_proxy.php On the whole I have an ambivalent attitude toward source control on ARS. It gives other development groups and managers (the PHBs) the mistaken impression that we actually have source. In reality, we have the opposite of source code -- we're storing exported, rendered definition files. There is no AR preprocessor. There is no AR compiler. I will grant you that it's nice to be able to lock out code that's under construction. However, I've experienced two kinds of events in which SourceSafe really gets in the way of productive work. First, I've been stuck with AR objects that are checked out (locked) by people who left on vacation. That's a pain, but not a real killer. Second, I've been on projects where SourceSafe has crashed. There's a good reason why Microsoft's internal development teams don't use SourceSafe... It isn't reliable and it doesn't scale. At least this was the state of affairs throughout the late 90s and the early 00s. If SourceSafe has recently gotten more reliable and scalable, that's nice. (But I kinda doubt it... I mean, consider the source.) Tim Widowfield [EMAIL PROTECTED] v: 937-878-9045 f: 937-878-9055 m: 937-369-7012 http://www.widowfield.com - Original Message From: Matthew White [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, July 12, 2006 9:03:33 PM Subject: Re: [ARSLIST] Remdy integration with CVS ** Balaji, Good luck! ;) In short, you would have to export each object into a def file and Checkout/Commit via command line or IDE (i.e., WinCVS). This is a place where Remedy/BMC just falls short Matt White Consulting, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Balaji Sent: Wednesday, July 12, 2006 8:01 AM To: arslist@ARSLIST.ORG Subject: Remdy integration with CVS ** Hello, Iwant to integrate remedy with CVS.Has any one does this integration beforeand can you pls share details as how to go about it. regards Balaji Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Performance concern about table field off a database table view..
Joe,
As you know everything we do on/with the RDBMS affects is performance.
(For the better or worst.) The basic design here should be fine.
My only inquiry is to make sure that the searches your doing are
as efficient as possible. For example you indicated that you only want
to show Open ticktes in the table/view. Good. However, I want to
make a simple suggestion. Add a field that positively identifies a
ticket as Open and a bit of data driven workflow to maintain that
field in the tickets. I would suggest that a simply table that lists
Form, 'Status' value and the corresponding 'Open?' field value with
a set field action that is run anytime 'Status' changes would be a
good starting point for the data driven logic. (unless there are
other rules that the business uses to decide what Open means.) This
way you can query for records that are 'Open?' = Yes instead of
('Status' = 0 OR 'Status' = 1 OR) or ('Status' = 5 OR 'Status'
=6). This design also allows you to later add (or ignore) 'Status'
values, and change their mind about pending or Fixed later and
decide if they are Open or not without changing your DB view objects
too. (Because the view would be based on the 'Open?' field instead of
the 'Status' field values.) Sure they would need to adjust existing
values for records on the system too. However if you wanted too you
could even build direct SQL that would do that for them too from the
'Status' -- 'Open?' value mapping form.
Just a few thoughts. HTH.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
Never ascribe to malice, that which can be explained by incompetence.
On 7/13/06, Joe DeSouza [EMAIL PROTECTED] wrote:
**
This has been done before so I'm inviting comments from those who have done it
and are having a heavily used application that might have a significantly large
number of records in their main data table..
This is what I am in the process of designing.. I am building a completely
custom trouble ticketing application for a cable company. Due to the nature of
their business where they are going to use this trouble ticketing application
to ticket network outages reported both manually as well as automatically from
network monitoring system this table is expected to grow rapidly.
On the control panel on their home page I need to have a table field with a
'thin' list of their open tickets (much the same way as the
SHR:ConsolidatedList in the ITSM application). The design is that instead of
having a place holder Remedy data table to push new tickets on creation with
the functionality to modify and delete enteries in that table, I have elected
to create a database table view of the main data table with the constraint that
it would display only tickets that are in an open status eliminating the
overhead that might be caused by creating an additional table, and the push
fields that happens on every transaction on the main data table.
Then on the control panel I simply build a table field that points to that
database view of the table.
My question is - would this impact performance in anyway.. I think this might
have a positive impact on the performance.. If any of you think otherwise
please do write back with reasons why you think it might not be the best design
to adopt. If any of you think the traditional approach of a thinner Remedy form
to hold the list information is better please do write about that too and your
reasons supporting that approach.
I hope to hear from you guys..
So far my protype right now on my development box rocks, but since I have never
used this approach in a thick data table that has the potential of eventually
housing thousands - maybe a few hundred thousand tickets eventually I would
love comments from those using this approach and their experiences with it...
Note that I will index the necessary columns that are used in the construction
of these database views of the data tables in question so as to optimize the
view creation.
Cheers
Joe D'Souza,
Remedy Consultant / Developer,
Shyle Networks,
New Jersey.
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy integration with CVS
** Related topic: This solution might not give you the granularity you require, but... Another option that is close to a CVS solutionis automated periodic exports of workflow. Every night my system exports all ARS objects to a .def file, then moves the .def file into a .zip file. The filename includes the date/time of the backup. HTH Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Matthew WhiteSent: Friday, July 14, 2006 6:59 AMTo: arslist@ARSLIST.ORGSubject: Re: Remedy integration with CVS ** Tim, Without getting into a back and forth In whole, source control is a good thing. In fact, if you do work in the financial, insurance or pharmaceutical companies it is mandated. While Remedy doesnt play 100% nice with MS SourceControl the good points outway the bad points IMO. From what I am reading below (i.e., people on vacation) it sounds like a process issue more than anything. I am not sure who doesnt like the idea of being able to look at the differences between code for a given object from one point to another to track down a root cause and/or potential bug. Moreover, I enjoy having the ability to rollback to a previous version of an object with a few clicks. Matt White White Consulting, Inc. 201.248.0438 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim WidowfieldSent: Wednesday, July 12, 2006 10:40 PMTo: arslist@ARSLIST.ORGSubject: Re: Remdy integration with CVS Or you could try the CVS proxy plug-in for SCC. (SCC is Microsoft's API/protocol for SourceSafe.) I've played with it on development AR servers, and it works OK. I've never tried it for extended periods or on production servers. Still, it's a nice little tool... http://www.pushok.com/soft_cvs_proxy.phpOn the whole I have an ambivalent attitude toward source control on ARS. It gives other development groups and managers (the PHBs) the mistaken impression that we actually have "source." In reality, we have the opposite of source code -- we're storing exported, rendered definition files. There is no AR preprocessor. There is no AR compiler.I will grant you that it's nice to be able to lock out code that's under construction. However, I've experienced two kinds of events in which SourceSafe really gets in the way of productive work. First, I've been stuck with AR objects that are checked out (locked) by people who left on vacation. That's a pain, but not a real killer. Second, I've been on projects where SourceSafe has crashed. There's a good reason why Microsoft's internal development teams don't use SourceSafe... It isn't reliable and it doesn't scale. At least this was the state of affairs throughout the late 90s and the early 00s. If SourceSafe has recently gotten more reliable and scalable, that's nice. (But I kinda doubt it... I mean, consider the "source.") Tim Widowfield[EMAIL PROTECTED]v: 937-878-9045f: 937-878-9055m: 937-369-7012http://www.widowfield.com - Original Message From: Matthew White [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Wednesday, July 12, 2006 9:03:33 PMSubject: Re: [ARSLIST] Remdy integration with CVS** Balaji, Good luck! ;) In short, you would have to export each object into a def file and Checkout/Commit via command line or IDE (i.e., WinCVS). This is a place where Remedy/BMC just falls short Matt White Consulting, Inc. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of BalajiSent: Wednesday, July 12, 2006 8:01 AMTo: arslist@ARSLIST.ORGSubject: Remdy integration with CVS ** Hello, Iwant to integrate remedy with CVS.Has any one does this integration beforeand can you pls share details as how to go about it. regards Balaji Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail Beta. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Documenting New Fields
Carey, You are correct this is an OOB app (Helpdesk 5.5). I hear what you are saying, and I will do the usual fit-gap analysis prior to actually doing the upgrade. I would like to know what my baseline (what I should be comparing) was/is. Which lead me to the question I sent to the list, and based on a few of the other suggestions, I think I have narrowed down my list. Thanks Kyle Carey Matthew Black wrote: Kyle, Hum legacy application fields were added after a certain date Might you be preparing for an upgrade of an OOB application? If so then you really need to not start at a field level, but at a process level. Evaluate what the new OOB application does or does not do with respect to the process that is desired. Then decide how to implement any changes to the NEW OOB application from there. LASTLY you map the old data to the new and customized OOB application. If you start with the details you may overlook the new features or even conflict with the new features of the OOB app. If your not doing an OOB application then maybe you could share more about what your trying to do rather than how your approaching the mystery problem? -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Performance concern about table field off a database table view..
**
Hello Mathew,Basically I am using the field Status to indicate the status of the ticket and considering that my only clause while building this view of the data table is the Status field as per the requirement I have here, considering that the Status field is an indexed field, I think at the DB level, the creation of the view is already optimized.Also after creating the view and finalizing what fields I need to show up on the columns (we are still in development mode) I intend recreating the view with a selective number of fields from that table, selecting only fields on the table that will be used by the table field while ignoring the rest of the fields.So that is my basic approach while creating this
particular view..There are a couple of other tables where I need this view to be created on forms that may have a clause on fields other than the status field, status field including so if these fields qualify to be indexed (such as CTI type of fields) I will have indexes on them.Stupid question to ask maybe but here it goes.. Do you need to index a view separately on its creation or does it inherit the indexes from the parent data table? I'm having a cutelittle foggy cloud here on my knowledge of table views so an opinion on this would help... :-)Joe D'Souza Remedy Consultant / Developer, Shyle Networks, New Jersey.Carey Matthew Black [EMAIL PROTECTED] wrote: Joe,As you know everything we do on/with the RDBMS affects is performance.(For the better or worst.) The basic design here should be fine.My only inquiry is to make sure that the searches your doing areas efficient as possible. For example you indicated that you only wantto show "Open ticktes" in the table/view. Good. However, I want tomake a simple suggestion. Add a field that positively identifies aticket as "Open" and a bit of data driven workflow to maintain thatfield in the tickets. I would suggest that a simply table that lists"Form", 'Status' value and the corresponding 'Open?' field value witha set field action that is run anytime 'Status' changes would be agood starting point for the data driven
logic. (unless there areother rules that the business uses to decide what "Open" means.) Thisway you can query for records that are 'Open?' = "Yes" instead of('Status' = 0 OR 'Status' = 1 OR) or ('Status' = 5 OR 'Status'=6). This design also allows you to later add (or ignore) 'Status'values, and change their mind about "pending" or "Fixed" later anddecide if they are "Open" or not without changing your DB view objectstoo. (Because the view would be based on the 'Open?' field instead ofthe 'Status' field values.) Sure they would need to adjust existingvalues for records on the system too. However if you wanted too youcould even build direct SQL that would do that for them too from the'Status' -- 'Open?' value mapping form.Just a few thoughts. HTH.-- Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Solution = People + Process + ToolsFast,
Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence.On 7/13/06, Joe DeSouza <[EMAIL PROTECTED]>wrote: ** This has been done before so I'm inviting comments from those who have done it and are having a heavily used application that might have a significantly large number of records in their main data table.. This is what I am in the process of designing.. I am building a completely custom trouble ticketing application for a cable company. Due to the nature of their business where they are going to use this trouble ticketing application to ticket network outages reported both manually as well as automatically from network monitoring system this table is expected to grow rapidly. On the control panel on their home page I need to have a table field with a 'thin' list of their open tickets (much the same way as the SHR:ConsolidatedList in the ITSM application).
The design is that instead of having a place holder Remedy data table to push new tickets on creation with the functionality to modify and delete enteries in that table, I have elected to create a database table view of the main data table with the constraint that it would display only tickets that are in an open status eliminating the overhead that might be caused by creating an additional table, and the push fields that happens on every transaction on the main data table. Then on the control panel I simply build a table field that points to that database view of the table. My question is - would this impact performance in anyway.. I think this might have a positive impact on the performance.. If any of you think otherwise please do write back with reasons why you think it might not be the best design to adopt. If any of you think the traditional approach of a thinner Remedy form to hold the list information is better please do write about
that too and your reasons supporting that approach. I hope to hear from you guys.. So far my protype
Re: Performance concern about table field off a database table view..
**
Hello Mathew,By the way thank you for responding - appreciated...CheersJoe D'Souza Remedy Consultant / Developer, Shyle Networks, New Jersey.Carey Matthew Black [EMAIL PROTECTED] wrote: Joe,As you know everything we do on/with the RDBMS affects is performance.(For the better or worst.) The basic design here should be fine.My only inquiry is to make sure that the searches your doing areas efficient as possible. For example
you indicated that you only wantto show "Open ticktes" in the table/view. Good. However, I want tomake a simple suggestion. Add a field that positively identifies aticket as "Open" and a bit of data driven workflow to maintain thatfield in the tickets. I would suggest that a simply table that lists"Form", 'Status' value and the corresponding 'Open?' field value witha set field action that is run anytime 'Status' changes would be agood starting point for the data driven logic. (unless there areother rules that the business uses to decide what "Open" means.) Thisway you can query for records that are 'Open?' = "Yes" instead of('Status' = 0 OR 'Status' = 1 OR) or ('Status' = 5 OR 'Status'=6). This design also allows you to later add (or ignore) 'Status'values, and change their mind about "pending" or "Fixed" later anddecide if they are "Open" or not without changing your DB view objectstoo. (Because the view
would be based on the 'Open?' field instead ofthe 'Status' field values.) Sure they would need to adjust existingvalues for records on the system too. However if you wanted too youcould even build direct SQL that would do that for them too from the'Status' -- 'Open?' value mapping form.Just a few thoughts. HTH.-- Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Solution = People + Process + ToolsFast, Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence.On 7/13/06, Joe DeSouza <[EMAIL PROTECTED]>wrote: ** This has been done before so I'm inviting comments from those who have done it and are having a heavily used application that might have a significantly large number of records in their main data table.. This is what I am in the process of designing.. I am building a completely
custom trouble ticketing application for a cable company. Due to the nature of their business where they are going to use this trouble ticketing application to ticket network outages reported both manually as well as automatically from network monitoring system this table is expected to grow rapidly. On the control panel on their home page I need to have a table field with a 'thin' list of their open tickets (much the same way as the SHR:ConsolidatedList in the ITSM application). The design is that instead of having a place holder Remedy data table to push new tickets on creation with the functionality to modify and delete enteries in that table, I have elected to create a database table view of the main data table with the constraint that it would display only tickets that are in an open status eliminating the overhead that might be caused by creating an additional table, and the push fields that happens on every transaction on the main data
table. Then on the control panel I simply build a table field that points to that database view of the table. My question is - would this impact performance in anyway.. I think this might have a positive impact on the performance.. If any of you think otherwise please do write back with reasons why you think it might not be the best design to adopt. If any of you think the traditional approach of a thinner Remedy form to hold the list information is better please do write about that too and your reasons supporting that approach. I hope to hear from you guys.. So far my protype right now on my development box rocks, but since I have never used this approach in a thick data table that has the potential of eventually housing thousands - maybe a few hundred thousand tickets eventually I would love comments from those using this approach and their experiences with it... Note that I will index the
necessary columns that are used in the construction of these database views of the data tables in question so as to optimize the view creation. Cheers Joe D'Souza, Remedy Consultant / Developer, Shyle Networks, New Jersey.
Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta.
__20060125___This posting was submitted with HTML in it___
Re: OT: Visio / ARS
Herb - does it still do this? If so what version do I need, etc.. Thanks. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Herb Partlow Sent: July 13, 2006 7:26 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS It can. I used it on several occasion. After creating the drawing I sent the drawing to my wife and she changed the setting of the drawing and ran it off on her plotter. I had a nice wall size drawing I used to show staff and other developers where we were at. Herb -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tyrone Dee Sent: Thursday, July 13, 2006 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS I was certain that Visio could document your workflow on it's own. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Herb Partlow Sent: July 13, 2006 2:38 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS You can use Visio to document/draw relationships diagram. Open visio Choose Database Template Choose database model diagram And then experiment with what works best for you Herb -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Estep Sent: Thursday, July 13, 2006 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Howdy, The IT Masters Suite did this, but it was absorbed by Remedy and discontinued. Some folks have said it became part of the developers suite, but that is a product I am not familiar with. I don't know of anything that will do this today. Bill Estep http://www.clubreading.com On Jul 13, 2006, at 9:24 AM, T. Dee wrote: A long time ago in a galaxy far far away ... Visio use to draw a diagram / flow chart from integrating with ARS. Does anyone remember this? Can this still be done? If so what version of Visio will this work with? THANKS! __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (Darwin) iD8DBQFEto9FgPRYzF5ewtERAjnCAJsFhYJ/j2KNzcZCMiKNUVOZDUJouACgrymJ vs6MURBX0zUydJ3L9383gfc= =/UNd -END PGP SIGNATURE- ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Spam:Re: I don't want my users using the old user tool
Serouche Here is an option. Set the remedy application to open an init form. Include a hidden field to set the version of the user tool connecting. Use a Active Link to check the version field. If the version is not what you want. Pop a message to the screen blah blah blah download lastest version from here Download now? If yes - Open a form with the url to download If no - message You will be required to download before continuing, close application Or something like that. This should give you the control over the message you want presented to the user. You could even get fancy and set up another form to track login and design it to accept/give 1 grace log in before they will be forced to download the next time they go to log in. My .02 cents :) Herb -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Serouche Rahimpour Sent: Friday, July 14, 2006 2:26 AM To: arslist@ARSLIST.ORG Subject: Re: Spam:Re: I don't want my users using the old user tool yes setting the API version is probably the best way. At least for me. Thanks to Carlos for his precise reference. Though this solution does not fully satisfy becasue I'd like to have a nice message as well explaining the user why he cannot connect anymore and what he should do. The default message coming with the ARSystem could be improved ;-) The problem is that I don't see how I should set my AL or filters to fire ? I have choosen that my users will not open the Home page. So I don't want to change this as I have more than 500 users. And so I don't see on which form my AL or filters should fire. Maybe I shall better create a hidden form to be opened upon connection ... hmmm ... Any other idea ? Serouche Jacques Andre wrote: Hello Serouche The easiest way to achieve this will be to set the server setting Minimum API Setting (in Admin tool , Server Information , Configuration) For example, to only allow 6.3 clients to connect to your server, set the Minimum API version to 11. Please note that this will block any client which does not use the 6.3 API. So if you are using the mid-tier or any custom written API, it needs to use the 6.3 API, or it will be blocked. I suspect the API version for 6.0.1 is 10, but you will need to confirm this. Hope this helps Jacques Andre [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Performance concern about table field off a database table view..
It depends upon the DBMS. SQL Server supports indexed views http://www.sqlteam.com/item.asp?ItemID=1015 Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, July 14, 2006 9:00 AM To: arslist@ARSLIST.ORG Subject: Re: Performance concern about table field off a database table view.. Joe, To my knowledge adding an index on a view is not possible. The view itself has no data in it to index. :) ( and your welcome. I am glad to try to help. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Performance concern about table field off a database table view..
** This is nice to know... I am on Oracle however so I guess I have one less consideration to think about..Joe"Heider, Stephen" [EMAIL PROTECTED] wrote: It depends upon the DBMS. SQL Server supports indexed views http://www.sqlteam.com/item.asp?ItemID=1015Stephen -Original Message-From: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew BlackSent: Friday, July 14, 2006 9:00 AMTo: arslist@ARSLIST.ORGSubject: Re: Performance concern about table field off a database tableview..Joe,To my knowledge adding an index on a view is not possible. The viewitself has no data in it to index. :)( and your welcome. I am glad to try to help. :)--Carey Matthew BlackRemedy Skilled Professional (RSP)ARS = Action Request System(Remedy)Solution = People + Process + ToolsFast, Accurate, Cheap Pick two.Never ascribe to malice, that which can be explained by incompetence. Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. __20060125___This posting was submitted with HTML in it___
Re: Mid-Tier Installation error
Title: RE: Mid-Tier Installation error ** Sam: The problem is in the error message. You have to install/build Apache with the DSO option turned ON. This will build (or should build the apxs script which is used to build Dynamic Service Objects (DSO). This will build the mod_servletexec.so file which is used for Servlets and JSP object translation/compilation when you are running your server. You are on UNIX, right? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shibu Samuel Sent: Friday, July 14, 2006 1:20 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier Installation error Hi List, I am trying to install mid-tier 6.3 on Apache 2.2.2 with mid-tier inbuilt ServletExec, but while installation i am getting the below error : * Enter port number [] Installing ServletExec AS in /usr/local/NewAtlanta/ServletExecAS Error constructing mod_servletexec.so Verify that the compiler and link-editor specified by $CFG_CC and $CFG_LD_SHLIB in your 'apxs' script are in your PATH. Also you have to have the path to gcc and ld in the PATH. Gcc is normally located in the /usr/gcc directory. If you are on a Solaris system, you have to install the SUN compiler package and add /usr/ccs/bin to your PATH. Also verify that the 'apxs' script has been properly installed. The installation log file (/tmp/SEinstall.log) has more details about these problems. If you continue to have problems then please forward the error messages and to [EMAIL PROTECTED] ServletExec installation aborting on failure! See /tmp/SEinstall.log for log of installation. Exiting ServletExec AS installer... egrep: can't open /usr/local/NewAtlanta/ServletExecAS/config/webadapter.properties mkdir: Failed to make directory /usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec /ServletExecData; No such file or directory chmod: WARNING: can't access /usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec/Ser vletExecData ./mt_install: /usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec/ServletExecData/oe m.properties: cannot create Please suggest. Thanks Sam __20060125___This posting was submitted with HTML in it___
Re: Mid-Tier Installation error
Hi James,
Thanks for the suggestions ..
My OS is Unix and Apache is configured with DSO enabled.
I have checked the DSO and the result is as below
servername{root}$ httpd -l
Compiled in modules:
core.c
mod_access.c
mod_auth.c
mod_include.c
mod_log_config.c
mod_env.c
mod_setenvif.c
prefork.c
http_core.c
mod_mime.c
mod_status.c
mod_autoindex.c
mod_asis.c
mod_cgi.c
mod_negotiation.c
mod_dir.c
mod_imap.c
mod_actions.c
mod_userdir.c
mod_alias.c
mod_so.c
Please suggest
Thanks
Sam
-Original Message-
From: Action Request System discussion list(ARSList) on behalf of
McKenzie, James J C-E LCMC HQISEC/L3
Sent: Fri 7/14/2006 2:36 PM
To: arslist@ARSLIST.ORG
Cc:
Subject: Re: Mid-Tier Installation error
**
Sam:
The problem is in the error message. You have to install/build Apache
with the DSO option turned ON. This will build (or should build the apxs
script which is used to build Dynamic Service Objects (DSO). This will build
the mod_servletexec.so file which is used for Servlets and JSP object
translation/compilation when you are running your server.
You are on UNIX, right?
James McKenzie
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL
PROTECTED] On Behalf Of Shibu Samuel
Sent: Friday, July 14, 2006 1:20 AM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier Installation error
Hi List,
I am trying to install mid-tier 6.3 on Apache 2.2.2 with mid-tier
inbuilt ServletExec, but while installation i am getting the below error :
*
Enter port number []
Installing ServletExec AS in
/usr/local/NewAtlanta/ServletExecAS
Error constructing mod_servletexec.so
Verify that the compiler and link-editor specified by $CFG_CC
and $CFG_LD_SHLIB in your 'apxs' script are in your PATH.
Also you have to have the path to gcc and ld in the PATH. Gcc is
normally
located in the /usr/gcc directory. If you are on a Solaris system,
you
have to install the SUN compiler package and add /usr/ccs/bin to
your
PATH.
Also verify that the 'apxs' script has been properly
installed. The installation log file (/tmp/SEinstall.log)
has more details about these problems.
If you continue to have problems then please forward the
error messages and to [EMAIL PROTECTED]
ServletExec installation aborting on failure!
See /tmp/SEinstall.log for log of installation.
Exiting ServletExec AS installer...
egrep: can't open
/usr/local/NewAtlanta/ServletExecAS/config/webadapter.properties
mkdir: Failed to make directory
/usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec
/ServletExecData; No such file or directory
chmod: WARNING: can't access
/usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec/Ser
vletExecData
./mt_install:
/usr/local/NewAtlanta/ServletExecAS/se-rwebtestServletExec/ServletExecData/oe
m.properties: cannot create
Please suggest.
Thanks
Sam
__20060125___This posting was submitted with HTML in it___
Re: Crystal report Parameter Field
Donald Not only adding the parameter to the report, but you will also to include a qualification for tickets between or greater then the date they inputted. Herb Partlow President/CEO IB Technical Consulting, Inc. (O) 408-253-0344 (F) 408-253-0344 (C) 408-309-5316 [EMAIL PROTECTED] http://www.ibtechnicalconsulting.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Klinton Torbert Sent: Friday, July 14, 2006 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal report Parameter Field Heath, From: Action Request System discussion list(ARSList) on behalf of Land CTR Donald H Sent: Thu 7/13/2006 9:16 AM To: arslist@ARSLIST.ORG Subject: Crystal report Parameter Field ** All, I am trying to create a parameter field that will ask for a Date and Time. I have my report set up to pull all ticket numbers for a 'Last Modified User'. When I add the parameter field to the DESIGN portion of the report, it will ask for the correct information, but will use it for all the records pulled. I need it to ask for each individual record. Can anyone please help Crystal Report 9 Remedy 4.05.01 Thanks in advance, Heath Land __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Crystal report Parameter Field - example
Donald
Here is an example that I have that pulls
All records for a technican working on a chosen project, between the
start date and the end date
1) prompts for tech name
2) prompts for project
3) prompts for start and ending date
{PTT_Project_Time_Tracker.Technician_Name}={?EnterConsultantName}
AND
{PTT_Project_Time_Tracker.Project_Name}={?EnterProjectName}
AND
{PTT_Project_Time_Tracker.Date} = {?StartDate}
AND
{PTT_Project_Time_Tracker.Date} = {?StopDate}
hope this helps
Herb Partlow
President/CEO
IB Technical Consulting, Inc.
(O) 408-253-0344
(F) 408-253-0344
(C) 408-309-5316
[EMAIL PROTECTED]
http://www.ibtechnicalconsulting.com
-Original Message-
From: Herb Partlow [mailto:[EMAIL PROTECTED]
Sent: Friday, July 14, 2006 9:25 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Crystal report Parameter Field
Donald
Not only adding the parameter to the report, but you
will also to include a qualification for tickets between
or greater then the date they inputted.
Herb Partlow
President/CEO
IB Technical Consulting, Inc.
(O) 408-253-0344
(F) 408-253-0344
(C) 408-309-5316
[EMAIL PROTECTED]
http://www.ibtechnicalconsulting.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Klinton Torbert
Sent: Friday, July 14, 2006 9:06 AM
To: arslist@ARSLIST.ORG
Subject: Re: Crystal report Parameter Field
Heath,
From: Action Request System discussion list(ARSList) on behalf of Land
CTR Donald H
Sent: Thu 7/13/2006 9:16 AM
To: arslist@ARSLIST.ORG
Subject: Crystal report Parameter Field
**
All,
I am trying to create a parameter field that will ask for a Date and
Time. I have my report set up to pull all ticket numbers for a 'Last
Modified User'. When I add the parameter field to the DESIGN portion
of the report, it will ask for the correct information, but will use it
for all the records pulled. I need it to ask for each individual
record. Can anyone please help
Crystal Report 9
Remedy 4.05.01
Thanks in advance,
Heath Land
__20060125___This posting was submitted with HTML in
it___
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy integration with CVS
Alan, While I agree that using VSS with Admin is touching the base -- it's better than not using it. Especially, when you are running a project with more than two developers -- 1) Are you going to send e-mails back and forth as the locking mechanism? 2) Have you never had the need to check a previous version of code? 3) Have you never had the need to compare to versions of code? While I would like to use ANT for my build and CVS/ClearCase for my source control it ain't [sic] going to happen any time soon with this product... ;) Matt White White Consulting, Inc. 201.248.0438 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tim Widowfield Sent: Friday, July 14, 2006 11:54 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy integration with CVS Matt, I like a good back-and-forth on a Friday. I think this is a subject worth talking about. Here's my take on the matter. Source control is better for systems that truly have source. For example, if I'm working on a small module in a huge C++ application at some large outfit, I can check it out and work locally. The more sophisticated source and version control systems can even leave my small module unlocked, with the expectation that my changes will be blended in later. So we can see a huge, inescapable difference already. If I check out a module in Remedy -- let's say it's just a few filters -- I'm probably not able to work on it locally. I'm not able to develop and test on a system that's identical to the main trunk, except for my small changes. What I'm working on, almost certainly, is the same development server that everybody else is working on. The other people in my group are likely making changes to their chunks concurrently with me. Will their changes affect what I'm doing? Beats me. This difference is not an insignificant distinction. When you say source control to a person who's working on, say, a huge Java application project, he or she is thinking, at least subconsciously: 1. I have a well-defined area of code that I'm working on. 2. I can compile and test it locally without affecting anyone else. I can make a real mess of it, give up, wipe it out, and start over -- and none of my co-workers will even know. (Except when they hear me yell Doh! in my cubicle.) 3. When others make changes locally on their little bits, I'm not affected. 4. Only after my updates have been verified and thoroughly tested by others will my changes become part of the main trunk. 5. If my changes are deemed to be a little too wild but nonetheless interesting, they may be placed in a branch, with the hopes that they might be blended back into the trunk someday. All of the above features (and many more) are intrinsic to source control. Notice that I'm not even talking about how and when code gets put into production. That's a whole different issue. It's all about controlling your source. We could approximate the above features in an AR System development environment, but it would be very expensive. Each developer would need his own AR Server, each identical to the current mainline trunk. After vetting the code changes, we would need to import the objects using Migrator. Then the whole bundle would need to be migrated to a staging server for more testing. And finally, once the whole system has passed its tests, we would migrate the changes to production. Sorry to get so long-winded. It's just that I can't help thinking when managers mandate source control and we Remedy developers say, Yeah, we've got that ...well, I think we're talking about different things. What they're really saying is they want total change control, the ultimate effect of which is the assurance that no code changes ever get into production without being thoroughly understood, tested, and certified. And if our updates wreak havoc, they want us to be able to roll out our changes immediately and restore the system to its pre-change state. If the above is true, then I submit that integrating Visual SourceSafe with the Admin Tool barely scratches the surface. You need to save definition dumps constantly during the day; you need continual system backups; and most of all you need Migrator. [Disclaimer: I'm not trying to sell anyone on Migrator. I've always had problems with it. I don't even enjoy using it. But in a large development environment, you need it or something like it. It's possible that Panacea is a better tool, but I have absolutely no experience with it. YMMV.] Tim Widowfield [EMAIL PROTECTED] v: 937-878-9045 f: 937-878-9055 m: 937-369-7012 http://www.widowfield.com - Original Message From: Matthew White To: arslist@ARSLIST.ORG Sent: Friday, July 14, 2006 6:59:02 AM Subject: Re: [ARSLIST] Remedy integration with CVS **
Re: Does $PROCESS$ have a character Limitation using Solaris 9
Jack, There is a limitation, but I am not sure what the value is at the moment. As a suggestion I would think about ARSPerl or the ARS Java API as a better approach for how this can be done. Still call the script via a $PROCESS$ call, but have the script do an ARS submit and return the Entry ID for the row that contains the response from the script. Then do a set field action to get the result from the Result form into the current transaction. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/14/06, Jack Samson [EMAIL PROTECTED] wrote: All, I had a question on how $PROCESS$ works on a Solaris OS. I have a perl script that I call using a $PROCESS$ that performs a bunch of parsing for the contents of a field. Is their a limitation on how much can be passed and returned to a $PROCESS$? I noticed if I have an Active Link with a character field that contains 12,000 characters that runs the same perl command using the following: $PROCESS$ @@: /usr/bin/perl/parse.pl $field$ It returns the correct 11,900 lines of characters. (As Expected) If I run the same command in a filter: $PROCESS$ /usr/bin/perl/parse.pl $field$, then it only returns about half of the text. If their is a limitation, can someone recommend a workaround with how I can return the parsed field into Remedy? Thanks, Jack _ Don't just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Does $PROCESS$ have a character Limitation using Solaris 9
Jack, One other variation... Use the Plugin server. Take a look at the ARFPerl plugin. That might be a best solution for your total needs too. ( It would avoid ARSPerl, a temp Results form/record and might even make what your Perl script is doing faster. Well, maybe.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/14/06, Carey Matthew Black [EMAIL PROTECTED] wrote: Jack, There is a limitation, but I am not sure what the value is at the moment. As a suggestion I would think about ARSPerl or the ARS Java API as a better approach for how this can be done. Still call the script via a $PROCESS$ call, but have the script do an ARS submit and return the Entry ID for the row that contains the response from the script. Then do a set field action to get the result from the Result form into the current transaction. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/14/06, Jack Samson [EMAIL PROTECTED] wrote: All, I had a question on how $PROCESS$ works on a Solaris OS. I have a perl script that I call using a $PROCESS$ that performs a bunch of parsing for the contents of a field. Is their a limitation on how much can be passed and returned to a $PROCESS$? I noticed if I have an Active Link with a character field that contains 12,000 characters that runs the same perl command using the following: $PROCESS$ @@: /usr/bin/perl/parse.pl $field$ It returns the correct 11,900 lines of characters. (As Expected) If I run the same command in a filter: $PROCESS$ /usr/bin/perl/parse.pl $field$, then it only returns about half of the text. If their is a limitation, can someone recommend a workaround with how I can return the parsed field into Remedy? Thanks, Jack ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Solaris 10 and Oracle 9i
Hello Fellow Listers, I would hear from any of you that has any experience with running Oracle 9i on Solaris 10. We are considering upgrading our servers to Solaris 10 and continue to run our Oracle 9i database but need to know if there are any issues, pitfall, show stoppers, or any other bugs, as well as successful implementations of this configuration. Any feedback would be appreciated. Christopher Pruitt Consultant Specialist EDS - Bank of America I3 Production Support Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Does $PROCESS$ have a character Limitation using Solaris 9
Jack, http://www.bmc.com/arsystem/dev_community/ -- Community Downloads (on the left) AKA: ( http://liberty.remedy.com/arsys/servlet/ViewFormServlet?mode=Queryform=DevDownloads Startview=webserver=action1username=ARWeb Userpwd= ) Login Select View All Utilities Find arfperl 5.0 (not sure if there is a version 6 of this) OR Find AR System Scripting Plug-In for Java Your choice depends on what ARS version your using and which language you want to use. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/14/06, Jack Samson [EMAIL PROTECTED] wrote: Thanks for the response. I am looking into both solutions. Do I need to compile the ARFPerl Plugin? If so, where do I get this from? Thanks! Jack ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy integration with CVS
** Stephen,That is exactly what I would like to do. I am a one person shop at this point so I don't have to worry about locking code but I love having defs for reference and restoration. Currently I export a def of the app I am working on after I have made considerable change and also export a complete def of the server every once in a while. This is great timing. I have been thinking about this a lot lately and have been meaning to look and see if there is a CLI for admin tool (just did, there is). Could you give me some more details on how you have automated this process? Thanks,JasonOn 7/14/06, Heider, Stephen [EMAIL PROTECTED] wrote: ** Related topic: This solution might not give you the granularity you require, but... Another option that is close to a CVS solutionis automated periodic exports of workflow. Every night my system exports all ARS objects to a .def file, then moves the .def file into a .zip file. The filename includes the date/time of the backup. HTH Stephen From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matthew WhiteSent: Friday, July 14, 2006 6:59 AMTo: arslist@ARSLIST.ORGSubject: Re: Remedy integration with CVS ** Tim, Without getting into a back and forth… In whole, source control is a good thing. In fact, if you do work in the financial, insurance or pharmaceutical companies it is mandated. While Remedy doesn't play 100% nice with MS SourceControl the good points outway the bad points IMO. From what I am reading below (i.e., people on vacation) it sounds like a process issue more than anything. I am not sure who doesn't like the idea of being able to look at the differences between code for a given object from one point to another to track down a root cause and/or potential bug. Moreover, I enjoy having the ability to rollback to a previous version of an object with a few clicks. Matt White White Consulting, Inc. 201.248.0438 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tim WidowfieldSent: Wednesday, July 12, 2006 10:40 PMTo: arslist@ARSLIST.ORGSubject: Re: Remdy integration with CVS Or you could try the CVS proxy plug-in for SCC. (SCC is Microsoft's API/protocol for SourceSafe.) I've played with it on development AR servers, and it works OK. I've never tried it for extended periods or on production servers. Still, it's a nice little tool... http://www.pushok.com/soft_cvs_proxy.php On the whole I have an ambivalent attitude toward source control on ARS. It gives other development groups and managers (the PHBs) the mistaken impression that we actually have source. In reality, we have the opposite of source code -- we're storing exported, rendered definition files. There is no AR preprocessor. There is no AR compiler.I will grant you that it's nice to be able to lock out code that's under construction. However, I've experienced two kinds of events in which SourceSafe really gets in the way of productive work. First, I've been stuck with AR objects that are checked out (locked) by people who left on vacation. That's a pain, but not a real killer. Second, I've been on projects where SourceSafe has crashed. There's a good reason why Microsoft's internal development teams don't use SourceSafe... It isn't reliable and it doesn't scale. At least this was the state of affairs throughout the late 90s and the early 00s. If SourceSafe has recently gotten more reliable and scalable, that's nice. (But I kinda doubt it... I mean, consider the source.) Tim Widowfield[EMAIL PROTECTED]v: 937-878-9045f: 937-878-9055m: 937-369-7012http://www.widowfield.com - Original Message From: Matthew White [EMAIL PROTECTED] To: arslist@ARSLIST.ORGSent: Wednesday, July 12, 2006 9:03:33 PMSubject: Re: [ARSLIST] Remdy integration with CVS** Balaji, Good luck! ;) In short, you would have to export each object into a def file and Checkout/Commit via command line or IDE (i.e., WinCVS). This is a place where Remedy/BMC just falls short… Matt White Consulting, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of BalajiSent: Wednesday, July 12, 2006 8:01 AMTo: arslist@ARSLIST.ORGSubject: Remdy integration with CVS ** Hello, Iwant to integrate remedy with CVS.Has any one does this integration beforeand can you pls share details as how to go about it. regards Balaji Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail Beta. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
OT: Friday Humor
Prison vs Work Just in case you ever get these two environments mixed up, this should make things a little bit clearer. IN PRISON..you spend the majority of your time in an 10X10 cell. AT WORKyou spend the majority of your time in an 8X8 cubicle. IN PRISON.you get three meals a day. AT WORK...you get a break for one meal and you have to pay for it. IN PRISON..you get time off for good behavior. AT WORKyou get more work for good behavior. IN PRISON..the guard locks and unlocks all the doors for you. AT WORKyou must often carry a security card and open all the doors for yourself. IN PRISON..you can watch TV and play games. AT WORK...you could get fired for watching TV and playing games. IN PRISON.you get your own toilet. AT WORK..you have to share the toilet with some people who pee on the seat. IN PRISON..they allow your family and friends to visit. AT WORKyou aren't even supposed to speak to your family. IN PRISON.all expenses are paid by the taxpayers with no work required. AT WORKyou get to pay all your expenses to go to work, and they deduct taxes from your salary to pay for prisoners. IN PRISON..you spend most of your life inside bars wanting to get out. AT WORK ...you spend most of your time wanting to get out and go inside bars. IN PRISON .you must deal with sadistic wardens. AT WORK...they are called managers. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Performance concern about table field off a database table view..
Oracle's semi-equivalent is called 'materialized views'; though I've only seen them commonly used for batch replication purposes. Axton Grams Joe DeSouza wrote: ** This is nice to know... I am on Oracle however so I guess I have one less consideration to think about.. Joe */Heider, Stephen [EMAIL PROTECTED]/* wrote: It depends upon the DBMS. SQL Server supports indexed views http://www.sqlteam.com/item.asp?ItemID=1015 Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, July 14, 2006 9:00 AM To: arslist@ARSLIST.ORG Subject: Re: Performance concern about table field off a database table view.. Joe, To my knowledge adding an index on a view is not possible. The view itself has no data in it to index. :) ( and your welcome. I am glad to try to help. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta. http://us.rd.yahoo.com/evt=42297/*http://advision.webevents.yahoo.com/handraisers __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Solaris 10 and Oracle 9i
We are running 10g on Solaris 9. Only thing I can add is that 7.0 requires the 10g client. Axton Grams Christopher Pruitt wrote: Hello Fellow Listers, I would hear from any of you that has any experience with running Oracle 9i on Solaris 10. We are considering upgrading our servers to Solaris 10 and continue to run our Oracle 9i database but need to know if there are any issues, pitfall, show stoppers, or any other bugs, as well as successful implementations of this configuration. Any feedback would be appreciated. Christopher Pruitt Consultant Specialist EDS - Bank of America I3 Production Support Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Solaris 10 and Oracle 9i
Title: RE: Solaris 10 and Oracle 9i ** Chris: I will state that Oracle says the memory 'footprint' for 10g is larger than 9i. If you are running on a marginal machine for 9i it will unusable for 10g. I presently run Oracle 9i on 1GB of physical memory. 10g will not run on this machine. And yes, I asked for 4GB of memory which I consider the minimum to run 10g. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, July 14, 2006 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Solaris 10 and Oracle 9i We are running 10g on Solaris 9. Only thing I can add is that 7.0 requires the 10g client. Axton Grams Christopher Pruitt wrote: Hello Fellow Listers, I would hear from any of you that has any experience with running Oracle 9i on Solaris 10. We are considering upgrading our servers to Solaris 10 and continue to run our Oracle 9i database but need to know if there are any issues, pitfall, show stoppers, or any other bugs, as well as successful implementations of this configuration. Any feedback would be appreciated. Christopher Pruitt Consultant Specialist EDS - Bank of America I3 Production Support Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: Solaris 10 and Oracle 9i
Title: RE: Solaris 10 and Oracle 9i ** Axton and James ... The other way around ... Oracle 9 on the Sun Solaris 10 Operating System We have a couple of Solaris 10 servers and the OS is very stable. The only thing that our admins have seenis when you create zones there can be some problems (like the backup tape drives needing to be installed in the base and the drivers not being seen in the other zones or needing to install shared libraries separately into each zone). One of the admins told me the other day he would install Solaris 10 with no hesitation in a production server (as long as you don't need to break it up into zones) Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, July 14, 2006 4:38 PMTo: arslist@ARSLIST.ORGSubject: Re: Solaris 10 and Oracle 9i ** Chris: I will state that Oracle says the memory 'footprint' for 10g is larger than 9i. If you are running on a marginal machine for 9i it will unusable for 10g. I presently run Oracle 9i on 1GB of physical memory. 10g will not run on this machine. And yes, I asked for 4GB of memory which I consider the minimum to run 10g. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Grams Sent: Friday, July 14, 2006 2:27 PM To: arslist@ARSLIST.ORG Subject: Re: Solaris 10 and Oracle 9i We are running 10g on Solaris 9. Only thing I can add is that 7.0 requires the 10g client. Axton Grams Christopher Pruitt wrote: Hello Fellow Listers, I would hear from any of you that has any experience with running Oracle 9i on Solaris 10. We are considering upgrading our servers to Solaris 10 and continue to run our Oracle 9i database but need to know if there are any issues, pitfall, show stoppers, or any other bugs, as well as successful implementations of this configuration. Any feedback would be appreciated. Christopher Pruitt Consultant Specialist EDS - Bank of America I3 Production Support Team Phone: +1-972-605-7702 (8-835) mailto:[EMAIL PROTECTED] __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Stop closing of windows user tool
** Dwayne,You can have an active link that fires on Close that gives the user an error message that you define. After they click OK to the error they are then prompted On or more active links failed when closing the form. Do you still want to ext the application? Yes/No. So in the error you could give them a message to say No to the next prompt and punch out (or you're fired). Not the cleanest solution but it may work for you.JasonOn 7/13/06, Dwayne Martin [EMAIL PROTECTED] wrote: Greetings everyone,Is there a way to have workflow halt the closing of thewindows tool?When our workers start in the morning they open a display-onlycontrol panel.This opens an "Hours Worked" form, into which they record their begin time.When they leave in the eveningthey close the control panel.This re-opens the same "HoursWorked" entry so they can enter their quitting time.BUT ifinstead of closing the control panel, they just close the user tool, the Hours Worked entry never gets filled out and wedon't know when they quit.The workflow log shows the Hours Worked entry opening, but itdoesn't stay open long enough to even be seen.I tried having the Hours Worked form run a "SET-CHANGE-FLAG 1" process,hoping that I would get a message saying "Your changes havenot been saved. . . " but I didn't.That is an ugly solutionanyway.What I would like is a process that stops the wut from closing, and allows the Hours Worked entry to display.Isthis possible?ARS 6.3, HPUX-11 serverDwayne MartinComputing SupportJames Madison University __20060125___This posting was submitted with HTML in it___
