Re: Installing Client User tool on Windows 7
Thanks, Carey. But we still get You have 0 MB of space. . . Dwayne Original message Date: Wed, 17 Jun 2009 10:37:45 -0400 From: Carey Matthew Black black@gmail.com Subject: Re: Installing Client User tool on Windows 7 To: arslist@ARSLIST.ORG Dwayne, Try running the installer in a compatibility mode. Right click on the *.exe and select properties: Compatibility (tab) -- check the Run this program in compatibility mode for: check box then -- Set the drop down to something that the version of the installer might know. (XP, Vista, Win2000 if you need to) Just a guess, but I expect it will help. Good luck in Beta/RC land. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jun 17, 2009 at 9:08 AM, Dwayne Martinmarti...@jmu.edu wrote: Dear List, We are trying to install the Client User tool on Windows 7 PCs, and have run into two problems. When we try to install the 7.1 client we get, Cannot determine operating system. When we try to install the 7.5 client it says, You have 0 MB of space available on the current drive. If we check the available disk space we clearly have more than enuf. Any suggestions? Dwayne Martin James Madison University ___ 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: Installing Client User tool on Windows 7 SOLVED
Carey, Thanks again! We tried the 7.1 installer with Windows Vista and Service Pack 2 compatibility, and both worked. (Remember to check Change for all users.) Dwayne Original message Date: Wed, 17 Jun 2009 11:47:21 -0400 From: Carey Matthew Black black@gmail.com Subject: Re: Installing Client User tool on Windows 7 To: arslist@ARSLIST.ORG Dwayne, Try the 7.1 client. The space issue is well, a horse of a different color'. So to speak. (AKA: I doubt that the compatibility mode would fix that.) -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jun 17, 2009 at 11:41 AM, Dwayne Martinmarti...@jmu.edu wrote: Thanks, Carey. But we still get You have 0 MB of space. . . Dwayne Original message Date: Wed, 17 Jun 2009 10:37:45 -0400 From: Carey Matthew Black black@gmail.com Subject: Re: Installing Client User tool on Windows 7 To: arslist@ARSLIST.ORG Dwayne, Try running the installer in a compatibility mode. Right click on the *.exe and select properties: Compatibility (tab) -- check the Run this program in compatibility mode for: check box then -- Set the drop down to something that the version of the installer might know. (XP, Vista, Win2000 if you need to) Just a guess, but I expect it will help. Good luck in Beta/RC land. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jun 17, 2009 at 9:08 AM, Dwayne Martinmarti...@jmu.edu wrote: Dear List, We are trying to install the Client User tool on Windows 7 PCs, and have run into two problems. When we try to install the 7.1 client we get, Cannot determine operating system. When we try to install the 7.5 client it says, You have 0 MB of space available on the current drive. If we check the available disk space we clearly have more than enuf. Any suggestions? Dwayne Martin James Madison University ___ 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 ___ 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
Fwd: Re: Using filter to parse field and create subfile records SOLVED
Pushing the values to the Info Form and letting it create the subfile entries worked, and wasn't nearly as complicated as I expected. Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ---BeginMessage--- Thanks Fred. This is sort of what I had in mind with my Parsing Form idea. But using the Info Form as the Parsing Form simplifies it. The reason I need the guide is that the list of names is in a column on a single field, so I have to parse each name out one at a time and process it. Dwayne Original message Date: Fri, 12 Jun 2009 13:54:06 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Using filter to parse field and create subfile records To: arslist@ARSLIST.ORG I usually do that type of thing by adding a Display Only Processing ID to the Info Form. You then just push the Main Form ID to the Processing ID on the Info Form. A Modify Filter on the Info Form detects that there is a processing ID and can do a push to Subfile. No guide necessary. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, June 12, 2009 1:42 PM To: arslist@ARSLIST.ORG Subject: Using filter to parse field and create subfile records Dear List, I have three forms: Main Form, Subfile Form and Info Form. On Submit, Main Form goes to Info Form to get a list of names for which it needs to create Subfile Form records. Each Subfile Form record will have a Name, and Main Form ID which links it to the Main Form. So “On Submit” a filter gets the names list, then calls a guide that parses out the list. It retrieves each name into a temporary field, and does a “Push Fields” to create a Subfile Form record. The problem is that calling the guide happens in Phase 1, but the Push Fields happens in Phase 3. So, by the time the push fields happens, the temporary field has been overwritten, and all Subfile records get the final name. I could make the push fields happen in Phase 1, but the Main Form/Entry ID won’t have been set. It would be nice if it could wait till Phase 3 to call the guide, but I don’t know of any way of doing that. These entries are being created via a web template, so I can’t use Active Links. One possibility would be to push both the Main Form/Entry ID and the Name List to a Parsing Form with a single record, then let the Parsing Form create the Subfile records. It seems needlessly complicated, but is there a better way? Dwayne Martin James Madison University (ARS 7.1 Patch 3, RH Linux server, Oracle 10.2 db) ---End Message---
Using filter to parse field and create subfile records
Dear List, I have three forms: Main Form, Subfile Form and Info Form. On Submit, Main Form goes to Info Form to get a list of names for which it needs to create Subfile Form records. Each Subfile Form record will have a Name, and Main Form ID which links it to the Main Form. So “On Submit” a filter gets the names list, then calls a guide that parses out the list. It retrieves each name into a temporary field, and does a “Push Fields” to create a Subfile Form record. The problem is that calling the guide happens in Phase 1, but the Push Fields happens in Phase 3. So, by the time the push fields happens, the temporary field has been overwritten, and all Subfile records get the final name. I could make the push fields happen in Phase 1, but the Main Form/Entry ID won’t have been set. It would be nice if it could wait till Phase 3 to call the guide, but I don’t know of any way of doing that. These entries are being created via a web template, so I can’t use Active Links. One possibility would be to push both the Main Form/Entry ID and the Name List to a Parsing Form with a single record, then let the Parsing Form create the Subfile records. It seems needlessly complicated, but is there a better way? Dwayne Martin James Madison University (ARS 7.1 Patch 3, RH Linux server, Oracle 10.2 db)
Re: Using filter to parse field and create subfile records
Thanks Fred. This is sort of what I had in mind with my Parsing Form idea. But using the Info Form as the Parsing Form simplifies it. The reason I need the guide is that the list of names is in a column on a single field, so I have to parse each name out one at a time and process it. Dwayne Original message Date: Fri, 12 Jun 2009 13:54:06 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Using filter to parse field and create subfile records To: arslist@ARSLIST.ORG I usually do that type of thing by adding a Display Only Processing ID to the Info Form. You then just push the Main Form ID to the Processing ID on the Info Form. A Modify Filter on the Info Form detects that there is a processing ID and can do a push to Subfile. No guide necessary. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, June 12, 2009 1:42 PM To: arslist@ARSLIST.ORG Subject: Using filter to parse field and create subfile records Dear List, I have three forms: Main Form, Subfile Form and Info Form. On Submit, Main Form goes to Info Form to get a list of names for which it needs to create Subfile Form records. Each Subfile Form record will have a Name, and Main Form ID which links it to the Main Form. So “On Submit” a filter gets the names list, then calls a guide that parses out the list. It retrieves each name into a temporary field, and does a “Push Fields” to create a Subfile Form record. The problem is that calling the guide happens in Phase 1, but the Push Fields happens in Phase 3. So, by the time the push fields happens, the temporary field has been overwritten, and all Subfile records get the final name. I could make the push fields happen in Phase 1, but the Main Form/Entry ID won’t have been set. It would be nice if it could wait till Phase 3 to call the guide, but I don’t know of any way of doing that. These entries are being created via a web template, so I can’t use Active Links. One possibility would be to push both the Main Form/Entry ID and the Name List to a Parsing Form with a single record, then let the Parsing Form create the Subfile records. It seems needlessly complicated, but is there a better way? Dwayne Martin James Madison University (ARS 7.1 Patch 3, RH Linux server, Oracle 10.2 db)
How long does it take to display a display-only field?
Dear List, We are considering an operation that will mean adding 50 display-only fields to a form. This means that the system will need to gather info on each field before it can display a record. About how long would that take, and would there be any benefit to making the fields hidden? Obviously it depends on the speed of the PC and whether or not we are using the User tool or Mid-Tier, but can anyone give us a ruff ball-park guess? Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Fwd: RE: How long does it take to display a display-only field? SOLVED
Eric, Thank you for a GREAT idea! Put the field on an un-used view. Frederick, what we are doing is creating a change log showing who changed what fields and when. So On Modify a filter queries the database to get the present values, and write these into the disply-only fields. There is a separate filter for each field, and if that field has changed, the filter writes a line to the log showing the old and new value. Is there a better way to do this? I should probably ask that question in a different thread. Thanks both of you, Dwayne Original message Date: Wed, 10 Jun 2009 15:05:25 + From: Roys, Eric D eric.r...@verizonbusiness.com Subject: RE: How long does it take to display a display-only field? To: marti...@jmu.edu Dwayne, If the fields are temp fields only used for workflow processing and the user will never see them, you can put them on a separate view of the form. By doing so they will still be accessible to workflow but will not impact load time. There is a caveat with this approach as either table fields or attachments still need to be on the displayed view (sorry been awhile so I don't recall which). An example of this approach was taking the OTB Help Desk form, moving all temp fields to a new view (call it temp or whatever). This took load time from nearly 1.5 minutes to 30 seconds in a shared development/uat environment (2 instances on a single host). HTH, Kind Regards, Eric Roys Sr. Sales Engineer Application Solutions Group Verizon Business We solve complex business problems with advanced technology. * Custom Solutions and Applications * Complex Systems Integration * Non-standard Hosting Services ** Date: Wed 10 Jun 11:29:43 EDT 2009 From: Grooms, Frederick W frederick.w.gro...@xo.com Add To Address Book | This is Not Spam Subject: Re: How long does it take to display a display-only field? To: arslist@ARSLIST.ORG That's a real guess, but it could take anywhere from 1/2 a second to several seconds depending on what you have to do to fill each field. (and if they are lookups is the data indexed for the lookup) Also are you going to fill them by client side Active Links or serve side Get Filters? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Wednesday, June 10, 2009 9:59 AM To: arslist@ARSLIST.ORG Subject: How long does it take to display a display-only field? Dear List, We are considering an operation that will mean adding 50 display-only fields to a form. This means that the system will need to gather info on each field before it can display a record. About how long would that take, and would there be any benefit to making the fields hidden? Obviously it depends on the speed of the PC and whether or not we are using the User tool or Mid-Tier, but can anyone give us a ruff ball-park guess? Dwayne Martin James Madison University ___ 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: ARERR [311] Field ID is not related to this form : 200000020 SOLVED
First I did an export on Form A, using the Add All Related option, and did a search on it for 20020, but found nothing. Then I exported the definition of the Active Link that was supposed to open Form A and found that it was trying to sort on 20020. I had done a Save Active Link As from a link that opened the AST:ComputerSystem form, then changed the form in the Open Window option, but not the sort field. How dumb can you get?!?!? Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ---BeginMessage--- Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records. On Form B and C I have buttons that call Active Links, which are supposed to open particular records in Form A. But instead I get the above error- usually. On Form B there is a character field, and a button that calls a link that opens the single record in Form A that matches the character field. That button/link works. If I click a button that should display 35 records I get the error. But I can display each of the 35 records one at a time by pasting the value in the character field and clicking button that opens the matching record. I checked the BMC Knowledge Base and found an entry about an “embedded query.” 20020 is the “Name” fieldid in the Asset Management module, which we have. So somewhere in our set-up there must be a reference to this “Name” field. But I’ve checked the Database data for every field on the form, as well as the form itself. There is no error or reference to 20020 in the Active Link, Filter, or SQL logs. There are no tables with references to 20020 . Any suggestions? Dwayne Martin James Madison University (ARS 7.1 p 3, RH Linux Server, Oracle 10.2 db) ---End Message---
Re: ARERR [311] Field ID is not related to this form : 200000020 SOLVED
I might add that there was no field listed in the Sort page of the Window Open command, so there was no way of seeing what was wrong simply by inspecting the Active Link. Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ---BeginMessage--- First I did an export on Form A, using the Add All Related option, and did a search on it for 20020, but found nothing. Then I exported the definition of the Active Link that was supposed to open Form A and found that it was trying to sort on 20020. I had done a Save Active Link As from a link that opened the AST:ComputerSystem form, then changed the form in the Open Window option, but not the sort field. How dumb can you get?!?!? Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ---BeginMessage--- Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records. On Form B and C I have buttons that call Active Links, which are supposed to open particular records in Form A. But instead I get the above error- usually. On Form B there is a character field, and a button that calls a link that opens the single record in Form A that matches the character field. That button/link works. If I click a button that should display 35 records I get the error. But I can display each of the 35 records one at a time by pasting the value in the character field and clicking button that opens the matching record. I checked the BMC Knowledge Base and found an entry about an “embedded query.” 20020 is the “Name” fieldid in the Asset Management module, which we have. So somewhere in our set-up there must be a reference to this “Name” field. But I’ve checked the Database data for every field on the form, as well as the form itself. There is no error or reference to 20020 in the Active Link, Filter, or SQL logs. There are no tables with references to 20020 . Any suggestions? Dwayne Martin James Madison University (ARS 7.1 p 3, RH Linux Server, Oracle 10.2 db) ---End Message--- ---End Message---
ARERR [311] Field ID is not related to this form : 200000020
Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records. On Form B and C I have buttons that call Active Links, which are supposed to open particular records in Form A. But instead I get the above error- usually. On Form B there is a character field, and a button that calls a link that opens the single record in Form A that matches the character field. That button/link works. If I click a button that should display 35 records I get the error. But I can display each of the 35 records one at a time by pasting the value in the character field and clicking button that opens the matching record. I checked the BMC Knowledge Base and found an entry about an “embedded query.” 20020 is the “Name” fieldid in the Asset Management module, which we have. So somewhere in our set-up there must be a reference to this “Name” field. But I’ve checked the Database data for every field on the form, as well as the form itself. There is no error or reference to 20020 in the Active Link, Filter, or SQL logs. There are no tables with references to 20020 . Any suggestions? Dwayne Martin James Madison University (ARS 7.1 p 3, RH Linux Server, Oracle 10.2 db)
Re: ARERR [311] Field ID is not related to this form : 200000020
Thanks, but I've run Active Link and Filter logs, and there is no workflow triggered that references 20020. Dwayne Original message Date: Fri, 29 May 2009 15:26:36 -0400 From: rem...@arutilities.com Subject: Re: ARERR [311] Field ID is not related to this form : 20020 To: arslist@ARSLIST.ORG Is any additional workflow being triggered on Display, Window Open, Search etc.. If so, perhaps one of those is referencing that field. Dear List, I have a form (Form A) with 20,000 records. I can open the form in the client User tool, and run an unqualified query and retrieve all records. On Form B and C I have buttons that call Active Links, which are supposed to open particular records in Form A. But instead I get the above error- usually. On Form B there is a character field, and a button that calls a link that opens the single record in Form A that matches the character field. That button/link works. If I click a button that should display 35 records I get the error. But I can display each of the 35 records one at a time by pasting the value in the character field and clicking button that opens the matching record. I checked the BMC Knowledge Base and found an entry about an “embedded query.â€・ 20020 is the “Nameâ€・ fieldid in the Asset Management module, which we have. So somewhere in our set-up there must be a reference to this “Nameâ€・ field. But I’ve checked the Database data for every field on the form, as well as the form itself. There is no error or reference to 20020 in the Active Link, Filter, or SQL logs. There are no tables with references to 20020 . Any suggestions? Dwayne Martin James Madison University (ARS 7.1 p 3, RH Linux Server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Missing field’s ghost haunti ng form -OOOPS!
Frederick, What do you mean by Delete the database view? Delete the T1766 table in the database? Sounds scary but I'll try it if you say so. I tried deleting the SQL view, but it didn't help. Dwayne Original message Date: Wed, 20 May 2009 15:41:07 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Missing field’s ghost haunti ng form -OOOPS! To: arslist@ARSLIST.ORG Delete the database view and add a new dummy (optional) field to the form. ARS should re-create the database view whenever a database field is added or removed from the form. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Wednesday, May 20, 2009 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Missing field’s ghost haunting form -OOOPS! I spoke too soon. Whenever I try to save an entry I still get ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier, even when I delete the field entirely. So I guess my only choice is to start over with a new form. Dwayne
Re: Missing field’s ghost haunti ng form -OOOPS!
The troublesome field disappeared again, in spite of the fact that its name was now User-ID. So I decided to start over. I copied the form over to a new one, but still got USER_X: invalid identifier, when I tried to save a record. So I started from scratch with a totally new form, and copied the fields over, except for the trouble-maker. It I created from scratch. SO FAR this has worked, but I'm still feeling apprehensive. Thank you, everyone who replied with suggestions and info. Dwayne Original message Date: Thu, 21 May 2009 08:11:59 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Missing field’s ghost haunti ng form -OOOPS! To: arslist@ARSLIST.ORG No the SQL view is what I was talking about not the T table -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Thursday, May 21, 2009 8:05 AM To: arslist@ARSLIST.ORG Subject: Re: Missing field’s ghost haunti ng form -OOOPS! Frederick, What do you mean by Delete the database view? Delete the T1766 table in the database? Sounds scary but I'll try it if you say so. I tried deleting the SQL view, but it didn't help. Dwayne Original message Date: Wed, 20 May 2009 15:41:07 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Missing field’s ghost haunti ng form -OOOPS! To: arslist@ARSLIST.ORG Delete the database view and add a new dummy (optional) field to the form. ARS should re-create the database view whenever a database field is added or removed from the form. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Wednesday, May 20, 2009 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Missing field’s ghost haunting form -OOOPS! I spoke too soon. Whenever I try to save an entry I still get ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier, even when I delete the field entirely. So I guess my only choice is to start over with a new form. Dwayne
Re: Index Error
Try just migrating half the data. If you get the error, try a quarter, etc till you pin down the offending record. Dwayne Martin James Madison University Original message Date: Wed, 20 May 2009 13:02:24 +0530 From: Manish SINGLA manish.sin...@st.com Subject: Re: Index Error To: arslist@ARSLIST.ORG ** Hello Bhupesh, Do increase the index values there in ARSchema table at DB level, say by some static value 500 etc. This is because when you were archiving the DB, it was in use and some indexes(At ARschema) remains lesser and at form level it exceeds. Regards Manish From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bhupesh Gupta Sent: Wednesday, May 20, 2009 12:47 PM To: arslist@ARSLIST.ORG Subject: Index Error ** The value(s) for this entry violate a unique index that has been defined for this form I am facing this error while migrating data from source to target thru rrchive tool. I have already rebuild all indiexes after deleting the records from target in the database. Target DB is oracle and Source is SQL. PLease Suggest -- Regards, Bhupesh Gupta _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
Missing field’s ghost haunting form
Dear List, I have a form (“PCS:Asset”) that had a field called “User” that has mysteriously disappeared. In sql, if I select all the field IDs and names from the “field” table, it isn’t there. But when I try to save an entry I get an error saying “ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier.” The SQL log shows: select …, USER_X, … from PCS_ASSET where ASSETT_ID = 'PCA005' . . . */*** ERROR *** ORA-00904: USER_X: invalid identifier So my field is gone, but its ghost remains in the SQL view to haunt me. If I look for “Fields in View” the field isn’t in the “In” or “Not In” table. I tried “DROP VIEW PCS_ASSET” and adding a new field to see if Remedy would rebuild the SQL view, but if I do “DESC PCS_ASSET” I see the new field, along with “USER_X If I try to create a new field with the same name and ID, it first complains that the “User” name is already in use, then when I change the name it says “Field does not exist on current form : 565000229 (ARERR 314).” This problem may have something to do with the “_X” after the fieldname. Maybe I put two spaces after the name. I’m thinking of starting over from scratch. Any other suggestions? Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db)
Re: Missing field’s ghost haunting form
Thanks, Juan! According to my records and memory, the field has been named User for at least the past nine days. But I guess it is possible that I made some innocent change that I don't remember that triggered the problem. The big question is, now that I have made the mistake, is there any way of reversing it other than by creating a whole new form, and repointing the workflow from the present to the new form? Dwayne Original message Date: Wed, 20 May 2009 08:56:43 -0700 From: Juan Ingles juan.n...@gmail.com Subject: Re: Missing field’s ghost haunting form To: arslist@ARSLIST.ORG ** Did the field ever exist? I'm guessing it failed under the covers on creation when Remedy went to actually create the table. The word USER is a reserved word in the database. That's why the name in the view has the _X tagged onto it. ( Same reason the view for the user form is named User_x ) It's best to stay away from reserved names, as all sorts of weird things can happen as a result. If you can, I would suggest recreating the form and name the field something different. Juan Ingles On Wed, May 20, 2009 at 8:20 AM, Dwayne Martin marti...@jmu.edu wrote: Dear List, I have a form (“PCS:Asset”) that had a field called “User” that has mysteriously disappeared. In sql, if I select all the field IDs and names from the “field” table, it isn’t there. But when I try to save an entry I get an error saying “ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier.” The SQL log shows: select …, USER_X, … from PCS_ASSET where ASSETT_ID = 'PCA005' . . . */*** ERROR *** ORA-00904: USER_X: invalid identifier So my field is gone, but its ghost remains in the SQL view to haunt me. If I look for “Fields in View” the field isn’t in the “In” or “Not In” table. I tried “DROP VIEW PCS_ASSET” and adding a new field to see if Remedy would rebuild the SQL view, but if I do “DESC PCS_ASSET” I see the new field, along with “USER_X If I try to create a new field with the same name and ID, it first complains that the “User” name is already in use, then when I change the name it says “Field does not exist on current form : 565000229 (ARERR 314).” This problem may have something to do with the “_X” after the fieldname. Maybe I put two spaces after the name. I’m thinking of starting over from scratch. Any other suggestions? Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_
Re: Missing field’s ghost haunting form - SOLVED
This is weird. The field re-appeared as mysteriously as it disappeared. So I renamed it to UserID to avoid the naming problem. But when I tried to save the form I got Field is not related to this form C56500229 (can't remember the exact wording). So I deleted the field, saved the form, then pasted the field back in, and saved again, and now everything seems to be working. So thanks, Frederick and Juan for your replies. I now know not to name a field User. Dwayne Original message Date: Wed, 20 May 2009 13:15:14 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Missing field’s ghost haunti ng form To: arslist@ARSLIST.ORG Since you can see the database view you can see what table column that field on the view is pointing to. You can then update that field in the Admin tool (finding by the ID number). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Wednesday, May 20, 2009 12:17 PM To: arslist@ARSLIST.ORG Subject: Re: Missing field’s ghost haunting form Thanks, Juan! According to my records and memory, the field has been named User for at least the past nine days. But I guess it is possible that I made some innocent change that I don't remember that triggered the problem. The big question is, now that I have made the mistake, is there any way of reversing it other than by creating a whole new form, and repointing the workflow from the present to the new form? Dwayne Original message Date: Wed, 20 May 2009 08:56:43 -0700 From: Juan Ingles juan.n...@gmail.com Subject: Re: Missing field’s ghost haunting form To: arslist@ARSLIST.ORG ** Did the field ever exist? I'm guessing it failed under the covers on creation when Remedy went to actually create the table. The word USER is a reserved word in the database. That's why the name in the view has the _X tagged onto it. ( Same reason the view for the user form is named User_x ) It's best to stay away from reserved names, as all sorts of weird things can happen as a result. If you can, I would suggest recreating the form and name the field something different. Juan Ingles On Wed, May 20, 2009 at 8:20 AM, Dwayne Martin marti...@jmu.edu wrote: Dear List, I have a form (“PCS:Asset”) that had a field called “User” that has mysteriously disappeared. In sql, if I select all the field IDs and names from the “field” table, it isn’t there. But when I try to save an entry I get an error saying “ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier.” The SQL log shows: select …, USER_X, … from PCS_ASSET where ASSETT_ID = 'PCA005' . . . */*** ERROR *** ORA-00904: USER_X: invalid identifier So my field is gone, but its ghost remains in the SQL view to haunt me. If I look for “Fields in View” the field isn’t in the “In” or “Not In” table. I tried “DROP VIEW PCS_ASSET” and adding a new field to see if Remedy would rebuild the SQL view, but if I do “DESC PCS_ASSET” I see the new field, along with “USER_X If I try to create a new field with the same name and ID, it first complains that the “User” name is already in use, then when I change the name it says “Field does not exist on current form : 565000229 (ARERR 314).” This problem may have something to do with the “_X” after the fieldname. Maybe I put two spaces after the name. I’m thinking of starting over from scratch. Any other suggestions? Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db)
Re: Missing field’s ghost haunting form -OOOPS!
I spoke too soon. Whenever I try to save an entry I still get ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier, even when I delete the field entirely. So I guess my only choice is to start over with a new form. Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ---BeginMessage--- This is weird. The field re-appeared as mysteriously as it disappeared. So I renamed it to UserID to avoid the naming problem. But when I tried to save the form I got Field is not related to this form C56500229 (can't remember the exact wording). So I deleted the field, saved the form, then pasted the field back in, and saved again, and now everything seems to be working. So thanks, Frederick and Juan for your replies. I now know not to name a field User. Dwayne Original message Date: Wed, 20 May 2009 13:15:14 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Missing field’s ghost haunti ng form To: arslist@ARSLIST.ORG Since you can see the database view you can see what table column that field on the view is pointing to. You can then update that field in the Admin tool (finding by the ID number). Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Wednesday, May 20, 2009 12:17 PM To: arslist@ARSLIST.ORG Subject: Re: Missing field’s ghost haunting form Thanks, Juan! According to my records and memory, the field has been named User for at least the past nine days. But I guess it is possible that I made some innocent change that I don't remember that triggered the problem. The big question is, now that I have made the mistake, is there any way of reversing it other than by creating a whole new form, and repointing the workflow from the present to the new form? Dwayne Original message Date: Wed, 20 May 2009 08:56:43 -0700 From: Juan Ingles juan.n...@gmail.com Subject: Re: Missing field’s ghost haunting form To: arslist@ARSLIST.ORG ** Did the field ever exist? I'm guessing it failed under the covers on creation when Remedy went to actually create the table. The word USER is a reserved word in the database. That's why the name in the view has the _X tagged onto it. ( Same reason the view for the user form is named User_x ) It's best to stay away from reserved names, as all sorts of weird things can happen as a result. If you can, I would suggest recreating the form and name the field something different. Juan Ingles On Wed, May 20, 2009 at 8:20 AM, Dwayne Martin marti...@jmu.edu wrote: Dear List, I have a form (“PCS:Asset”) that had a field called “User” that has mysteriously disappeared. In sql, if I select all the field IDs and names from the “field” table, it isn’t there. But when I try to save an entry I get an error saying “ARERR [552] Failure during SQL operation to the database : ORA-00904: USER_X: invalid identifier.” The SQL log shows: select …, USER_X, … from PCS_ASSET where ASSETT_ID = 'PCA005' . . . */*** ERROR *** ORA-00904: USER_X: invalid identifier So my field is gone, but its ghost remains in the SQL view to haunt me. If I look for “Fields in View” the field isn’t in the “In” or “Not In” table. I tried “DROP VIEW PCS_ASSET” and adding a new field to see if Remedy would rebuild the SQL view, but if I do “DESC PCS_ASSET” I see the new field, along with “USER_X If I try to create a new field with the same name and ID, it first complains that the “User” name is already in use, then when I change the name it says “Field does not exist on current form : 565000229 (ARERR 314).” This problem may have something to do with the “_X” after the fieldname. Maybe I put two spaces after the name. I’m thinking of starting over from scratch. Any other suggestions? Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) ---End Message---
Mapping dis-similar Status Histories on data imports
Dear List, We are exporting our data from the AST:ComputerSystem (Asset Management) form into a totally customized form. AST:ComputerSystem has 14 Status values and the new form has just four, so obviously several AST:ComputerSystem Statuses have to map to just one Status in the new form. No problem. But what about Status History? In a data export file, Status history looks like: firstDate^firstUser^secondDate^secondUser^^^fifthDate^fifthUser . . . (The ^s appear as squares in Notepad. I don't know what they really are.) You would have to figure out which dateuser pairs in the old form map to which dateuser pair in the new form, then pick the latest. It sounds hideously complicated. But if anyone has ever tried anything similar, or even has some ideas it would be good to hear from them. Dwayne Martin, James Madison University (ARS 7.1 p2, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Audit Trail data in AST:ComputerSystem
Dear List, On the Asset Management Module/AST:ComputerSystem form there is an Audit Trail button, which, if you click, displays a table of changes made to that entry. Does anyone know where this list of changes is stored. I tried following the workflow, but got lost. Dwayne Martin James Madison University (Asset Management 6.3, ARS 7.1 p4, RH Linux server, Oracle 10.2 db ) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Audit Trail data in AST:ComputerSystem
Anne, I am trying to import the data into another form. At least you've given me a good excuse to tell them why I can't do it. Thanks, Dwayne Original message Date: Fri, 8 May 2009 10:47:57 -0400 From: Ramey, Anne anne.ra...@its.nc.gov Subject: Re: Audit Trail data in AST:ComputerSystem To: arslist@ARSLIST.ORG I've made a similar effort recently. It appears to be stored in a number of places and joined several times before reaching the form you see. I haven't figured out all the details yet. Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, May 08, 2009 10:31 AM To: arslist@ARSLIST.ORG Subject: Audit Trail data in AST:ComputerSystem Dear List, On the Asset Management Module/AST:ComputerSystem form there is an Audit Trail button, which, if you click, displays a table of changes made to that entry. Does anyone know where this list of changes is stored. I tried following the workflow, but got lost. Dwayne Martin James Madison University (Asset Management 6.3, ARS 7.1 p4, RH Linux server, Oracle 10.2 db ) ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Audit Trail data in AST:ComputerSystem
Good luck! At least you can tell them that you know somebody else who tried and failed. Dwayne Original message Date: Fri, 8 May 2009 12:04:52 -0400 From: Ramey, Anne anne.ra...@its.nc.gov Subject: Re: Audit Trail data in AST:ComputerSystem To: arslist@ARSLIST.ORG I wish my folks would take that answer. They want to report on it and just won't take no for an answer. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, May 08, 2009 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: Audit Trail data in AST:ComputerSystem Anne, I am trying to import the data into another form. At least you've given me a good excuse to tell them why I can't do it. Thanks, Dwayne Original message Date: Fri, 8 May 2009 10:47:57 -0400 From: Ramey, Anne anne.ra...@its.nc.gov Subject: Re: Audit Trail data in AST:ComputerSystem To: arslist@ARSLIST.ORG I've made a similar effort recently. It appears to be stored in a number of places and joined several times before reaching the form you see. I haven't figured out all the details yet. Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, May 08, 2009 10:31 AM To: arslist@ARSLIST.ORG Subject: Audit Trail data in AST:ComputerSystem Dear List, On the Asset Management Module/AST:ComputerSystem form there is an Audit Trail button, which, if you click, displays a table of changes made to that entry. Does anyone know where this list of changes is stored. I tried following the workflow, but got lost. Dwayne Martin James Madison University (Asset Management 6.3, ARS 7.1 p4, RH Linux server, Oracle 10.2 db ) ___ 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 ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Audit Trail data in AST:ComputerSystem
Roger, Yes, I am importing the data from the AST:ComputerSystem into a totally new customized Remedy form. And I want to include the Audit Trail. So where do I find it? I don't see it on the BMC:BMC_ComputerSystem_ form. Please tell me about this audit form that holds all of the details. Dwayne Original message Date: Fri, 8 May 2009 12:59:29 -0400 From: Roger Justice rjust2...@aol.com Subject: Re: Audit Trail data in AST:ComputerSystem To: arslist@ARSLIST.ORG ** You are looking at 2 different things. The Audit trail is controlled through the Base Element form and there is an audit form that holds all of the details. The importing of Assets must be done through either the AST join or the BMC join such as Computer system. The data is stored in the BMC:ComputerSystem regular form and the Base Element form and the instance ID is the same on both. -Original Message- From: Dwayne Martin marti...@jmu.edu To: arslist@ARSLIST.ORG Sent: Fri, 8 May 2009 12:17 pm Subject: Re: Audit Trail data in AST:ComputerSystem Good luck! At least you can tell them that you know somebody else who tried and failed. Dwayne Original message Date: Fri, 8 May 2009 12:04:52 -0400 From: Ramey, Anne anne.ra...@its.nc.gov Subject: Re: Audit Trail data in AST:ComputerSystem To: arslist@ARSLIST.ORG I wish my folks would take that answer. They want to report on it and just won't take no for an answer. Anne Ramey *** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, May 08, 2009 12:10 PM To: arslist@ARSLIST.ORG Subject: Re: Audit Trail data in AST:ComputerSystem Anne, I am trying to import the data into another form. At least you've given me a good excuse to tell them why I can't do it. Thanks, Dwayne Original message Date: Fri, 8 May 2009 10:47:57 -0400 From: Ramey, Anne anne.ra...@its.nc.gov Subject: Re: Audit Trail data in AST:ComputerSystem To: arslist@ARSLIST.ORG I've made a similar effort recently. It appears to be stored in a number of places and joined several times before reaching the form you see. I haven't figured out all the details yet. Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, May 08, 2009 10:31 AM To: arslist@ARSLIST.ORG Subject: Audit Trail data in AST:ComputerSystem Dear List, On the Asset Management Module/AST:ComputerSystem form there is an Audit Trail button, which, if you click, displays a table of changes made to that entry. Does anyone know where this list of changes is stored. I tried following the workflow, but got lost. Dwayne Martin James Madison University (Asset Management 6.3, ARS 7.1 p4, RH Linux server, Oracle 10.2 db ) ___ 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 ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are A Good Credit Score is 700 or Above. See yours in just 2 easy steps! _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: how to trigger a filter guide from an AL
Hi Jean-Louis, How do you Create a filter that starts when this display-only field is filled in? What I've always done is have my AL do a Commit Changes, and have the filter Run If TR.FieldName = Whatever value the AL set it to. But if there is a simpler way it would be good to know. Dwayne Martin James Madison University Original message Date: Thu, 7 May 2009 11:57:56 +0200 From: ARSmarts Support supp...@arsmarts.com Subject: Re: how to trigger a filter guide from an AL To: arslist@ARSLIST.ORG - Create a display-only field on the form where you filter guide is attached - Create a filter that starts when this display-only field is filled in, and that calls your filter guide - Create an AL that pushes a value to this display-only field That should do the trick. Jean-Louis Halleux ARSmarts sa http://www.arsmarts.com On 07 May 2009, at 11:51, Remedy Maniac wrote: dear experts, I have a Filter guide which sends an email out at some point. I have a AL on Display, which filters do not do, and which cannot send emails out. So I'd like this AL firing the Filter Guide so my email will be sent out. Is there a way to perform this? As usual, there is always a solution to any problem. Thanks in advance. 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Preparing import file with date fields in Excel
Dear List, This is really an Excel question, but I can’t find the answer so I’ll try you all. I am trying to create a template for exporting data from one form and importing it into a very different form. So I’ve exported the data from the first form into a comma-separated-file (csv), and opened the file in Excel. In the cell after all the data columns I am trying to build the import file data row. The date fields appear as dates in the main spreadsheet. But when I try to insert them into a formula they appear as long decimal numbers. Eg in the O2 cell I see “5/6/2009 4:34:00 PM”, but when I insert “O2” into a formula as: . . . CHAR(34)O2CHAR(34). . . the O2 value appears as 39939.690278”. I’ve tried the DATE and DATEVALUE. The formula that Excel uses to create these date numbers is way too complicated to convert into a Remedy date integer. How can I get the date to appear as a date in my formulated field? Dwayne Martin James Madison University
Re: SV: Preparing import file with date fields in Excel
Thanks, Jonas. The problem is, I don't know what the day, month, and year are. It appears in the cell as 5/6/2009 4:34:00 PM. I would have to do some very fancy parcing to come up with the values, and even then it wouldn't include the time, which in the case of Creation Date or Date Modified is important. I tried feeding it the whole value as one chunk, but it wouldn't take it. According to my Excel help, DATE() returns the serial number of a date. What I need is something that will take the serial number and return a date as a string, but I can't seem to find that. An idea I'm working on: Export the dates separately to an .arx (import) file. Then import them into the Excel spreadsheet, where they will appear as numbers, which can be imported. As long as the data doesn't change between exports it should work, but one little glitch and everything is all out of sync. Thanks again, Dwayne Original message Date: Thu, 7 May 2009 17:17:01 +0200 From: Jonas Stumph Stevnsvig jonas.stumph.stevns...@bec.dk Subject: SV: Preparing import file with date fields in Excel To: arslist@ARSLIST.ORG Hi dwayne - I am using a localized version of excel, but I've tried just that. My solution was: TEKST(O2;dd-mm-åå) So for an english excel my guess is TEXT(O2;dd-mm-yy) Observe that this is not applicable for VBA - that is an entierly different approach. with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Intern IT jonas.stumph.stevns...@bec.dk -Oprindelig meddelelse- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne af Dwayne Martin Sendt: 7. maj 2009 17:09 Til: arslist@ARSLIST.ORG Emne: Preparing import file with date fields in Excel Dear List, This is really an Excel question, but I can't find the answer so I'll try you all. I am trying to create a template for exporting data from one form and importing it into a very different form. So I've exported the data from the first form into a comma-separated-file (csv), and opened the file in Excel. In the cell after all the data columns I am trying to build the import file data row. The date fields appear as dates in the main spreadsheet. But when I try to insert them into a formula they appear as long decimal numbers. Eg in the O2 cell I see 5/6/2009 4:34:00 PM, but when I insert O2 into a formula as: . . . CHAR(34)O2CHAR(34). . . the O2 value appears as 39939.690278. I've tried the DATE and DATEVALUE. The formula that Excel uses to create these date numbers is way too complicated to convert into a Remedy date integer. How can I get the date to appear as a date in my formulated field? Dwayne Martin James Madison University ___ 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: SV: Preparing import file with date fields in Excel SOLVED
Thanks, Frederick! That works! Thanks again, Jonas. You were saying the same thing, but Excel Help's talk of serial number threw me off on a tangent. Gratefully yours, Dwayne Original message Date: Thu, 7 May 2009 12:56:46 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: SV: Preparing import file with date fields in Excel To: arslist@ARSLIST.ORG The TEXT function will format an Excel date into whatever format you specify. For normal US format it would be . . . CHAR(34)TEXT(O2,MM/DD/ HH:MM:SS)CHAR(34). . . Or . . . CHAR(34)TEXT(O2,MM/DD/ h:mm:ss AM/PM)CHAR(34). . . The 1st should be 24 hour format while the second has the AM or PM indicator Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Thursday, May 07, 2009 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: SV: Preparing import file with date fields in Excel Thanks, Jonas. The problem is, I don't know what the day, month, and year are. It appears in the cell as 5/6/2009 4:34:00 PM. I would have to do some very fancy parcing to come up with the values, and even then it wouldn't include the time, which in the case of Creation Date or Date Modified is important. I tried feeding it the whole value as one chunk, but it wouldn't take it. According to my Excel help, DATE() returns the serial number of a date. What I need is something that will take the serial number and return a date as a string, but I can't seem to find that. An idea I'm working on: Export the dates separately to an .arx (import) file. Then import them into the Excel spreadsheet, where they will appear as numbers, which can be imported. As long as the data doesn't change between exports it should work, but one little glitch and everything is all out of sync. Thanks again, Dwayne Original message Date: Thu, 7 May 2009 17:17:01 +0200 From: Jonas Stumph Stevnsvig jonas.stumph.stevns...@bec.dk Subject: SV: Preparing import file with date fields in Excel To: arslist@ARSLIST.ORG Hi dwayne - I am using a localized version of excel, but I've tried just that. My solution was: TEKST(O2;dd-mm-åå) So for an english excel my guess is TEXT(O2;dd-mm-yy) Observe that this is not applicable for VBA - that is an entierly different approach. with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Intern IT jonas.stumph.stevns...@bec.dk -Oprindelig meddelelse- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne af Dwayne Martin Sendt: 7. maj 2009 17:09 Til: arslist@ARSLIST.ORG Emne: Preparing import file with date fields in Excel Dear List, This is really an Excel question, but I can't find the answer so I'll try you all. I am trying to create a template for exporting data from one form and importing it into a very different form. So I've exported the data from the first form into a comma-separated-file (csv), and opened the file in Excel. In the cell after all the data columns I am trying to build the import file data row. The date fields appear as dates in the main spreadsheet. But when I try to insert them into a formula they appear as long decimal numbers. Eg in the O2 cell I see 5/6/2009 4:34:00 PM, but when I insert O2 into a formula as: . . . CHAR(34)O2CHAR(34). . . the O2 value appears as 39939.690278. I've tried the DATE and DATEVALUE. The formula that Excel uses to create these date numbers is way too complicated to convert into a Remedy date integer. How can I get the date to appear as a date in my formulated field? Dwayne Martin James Madison University ___ 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 ___ 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: Using oversized integer in ARDBC LDAP Vendor form SOLVED
Rick, BRILLIANT! Actually, I should have thot of that myself. Anyway, it works, so THANK YOU very much! Dwayne Original message Date: Mon, 4 May 2009 13:30:24 + From: Rick Cook remedyr...@gmail.com Subject: Re: Using oversized integer in ARDBC LDAP Vendor form To: arslist@ARSLIST.ORG I have two ideas : Truncate the number from the right. Format it in a character field, then dump the truncated results into a date time or integer field. Rick --Original Message-- From: Dwayne Martin Sender: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Subject: Using oversized integer in ARDBC LDAP Vendor form Sent: May 4, 2009 6:30 AM Dear List, I’m pretty sure this is hopeless but I’ll try anyway. We have an ARDBC LDAP Vendor form that queries Active Directory. One its fields is “Last Login”, which displays as a number like “128,848,740,512,645,963” (commas added). We have a formula for changing this value to a date-time ((“Last Login” – 116,444,880,000,000,000) / 10,000,000) but given that the largest integer Remedy can handle is 2,147,483,647 there doesn’t appear to be any way of applying the formula. I’ve tried various tricks but none of them work. Any suggestions? (ARS 7.2 p3, RH Linus server, Oracle 10.2 db) Dwayne Martin James Madison University Sent from my Verizon Wireless BlackBerry
Using oversized integer in ARDBC LDAP Vendor form
Dear List, I’m pretty sure this is hopeless but I’ll try anyway. We have an ARDBC LDAP Vendor form that queries Active Directory. One its fields is “Last Login”, which displays as a number like “128,848,740,512,645,963” (commas added). We have a formula for changing this value to a date-time ((“Last Login” – 116,444,880,000,000,000) / 10,000,000) but given that the largest integer Remedy can handle is 2,147,483,647 there doesn’t appear to be any way of applying the formula. I’ve tried various tricks but none of them work. Any suggestions? (ARS 7.2 p3, RH Linus server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Returning multiple values for an attribute in Active Directory SOLVED
Thanks, Carey! That works! Sorry for not reading the manual more thoroly before submitting the question. Dwayne Martin James Madison University * From: Carey Matthew Black black@gmail.com Subject: Re: Returning multiple values for an attribute in Active Directory You on v7.1... so your in luck... I know this feature was added in some version.. but I am not sure exactly which one... REF the section Multivalued attributes ( Integrating-710.pdf page 123 ) Which goes on to page 124 to say: To resolve this difference between the two data models, use a special notation when specifying the attribute name in the Field Properties window: attribute_name[*separator_string] Values associated with attribute_name are concatenated into a single value in AR System but separated with separator_string. For example, to concatenate all values associated with the telephoneNumber attribute and separate each value with a comma you would enter the following as the attribute name in the Form Properties window: telephoneNumber[*,] You could then define workflow to extract, add, or modify values in the comma separated list of telephone numbers. If that works...then you should be good to go. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (RSP) ARS = Action Request System(Remedy) * Dear List, We have created a vendor form based on ARSYS.ARDBC.LDAP that queries Active Directory for personal info. One of the pieces of info we need is all of the groups the person is a member of. The “memberOf” attribute can be a multi-value return, and when it is, Remedy is returning only the first one it finds (in our case, the first group). How can we get it to return them all? Dwayne Martin James Madison University (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db)
Returning multiple values for an attribute in Active Directory
Dear List, We have created a vendor form based on ARSYS.ARDBC.LDAP that queries Active Directory for personal info. One of the pieces of info we need is all of the groups the person is a member of. The “memberOf” attribute can be a multi-value return, and when it is, Remedy is returning only the first one it finds (in our case, the first group). How can we get it to return them all? Dwayne Martin James Madison University (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db)
Re: Error adding field to join form
Hi Janie, You are right. I am trying to add fields directly to the form in the Admin tool. We purchased the v6 Asset Management module about five years ago, but out of its vast potential, we have only used two of its forms. When we upgraded our ARSystem to V7 we were told that we needed to hire a consultant to upgrade the CMDB. We consulted with a consultant, and he said that since we are only using a small portion of the module the best thing to do was just go on using the two form and not bother upgrading the CMDB until we decided to use the entire system. So now we are at ARS 7.1, with a v6 CMDB, and trying to use two Asset Management forms as regular Remedy forms. What puzzles me is that I have added fields directly into BMC:BMC_ComputerSystem_ before and I never got that SQL view error. Now I get the error message when adding new fields, and the system will let me add those old fields to BMC:BMC_ComputerSystem, but not the new ones. I tried checking out the CMDB Console and CMDB2ASSET synchronization and it looks like something requiring an extra layer of knowledge, and which probably won't work anyway given that our CMDB version doesn't match our ARS version. So, any suggestions for a workaround? If not, I'll just say a big THANK YOU! for your reply and abandon the project. At least I know WHY it isn't working. Gratefully yours, Dwayne Martin Original message Date: Sun, 19 Apr 2009 08:39:29 -0700 From: Janie Sprenger jrsrem...@gmail.com Subject: Re: Error adding field to join form To: arslist@ARSLIST.ORG Hi Dwayne, What version of CMDB are you on? AssetBase indicates an older version of CMDB unless you are referring to the SHR:SchemaName reference. Normally, one adds attributes from the CMDB Console and then runs the CMDB2ASSET synchronize which places the fields on the Asset related forms. You can then position your fields on the Asset forms b/c the fields are then on the Custom(x) tabs. Your email sounds like you are adding fields directly to the Forms in the Admin tool? Have you also added the fields to the CMDB metadata? The SQL view error indicates that the actual SQL view (not the table), does not exist in the DB. Do you have access to your DB directly? The index error may be a result of a either an actual duplicate index because of the name, fieldid or because there may be an internal SQL problem with the parent forms. The indexes you mentioned for the parents sound like they are shy of about 7 others that are normally defined. Are you able to save either parent form without adding a new field with no error? Let me know what version of the CMDB you're dealing with. Thanks, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, April 17, 2009 10:33 AM To: arslist@ARSLIST.ORG Subject: Error adding field to join form Dear List, I am trying to add two database fields to the Asset Management Module “AST:ComputerSystem” form. This is a three-layer join form, which starts by joining “BMC:BMC_ComputerSystem_” with “BMC:BMC_AssetBase” to get “BMC:BMC_ComputerSystem.” When I add the fields to either of the two base forms I get: “Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARWARN 69).” First sign of trouble. When I go to “BMC:BMC_ComputerSystem” and try to bring the fields into that form I get: “Field : Equipment Status [the name of the new field] : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382).” and “Some field could not be saved in this form.” There are no errors in the SQL log. To make things still more complicated, there are fields that I added to “BMC:BMC_AssetBase” in a previous project that I can bring into “BMC:BMC_ComputerSystem” with no problem. Both “BMC:BMC_AssetBase” and “BMC:BMC_ComputerSystem” have indexes on InstanceId. What index might they be talking about? Any suggestions? Dwayne Martin James Madison University (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Error adding field to join form
Hi Jane, Yes, I'm able to save the two base fields if I just reposition a field. I decided to delete the fields I am trying to add and start over from scratch, but now the whole middle-layer BMB:BMC_ComputerSystem (no final _) has disappeared. I don't THINK I deleted it. When I try to import it from our live system I once again get, The value(s) for this entry violate a unique index that has been defined for this form: (ARERR 382). And that is without the added fields. Thanks again, Dwayne Original message Date: Mon, 20 Apr 2009 07:19:25 -0700 From: Janie Sprenger jrsrem...@gmail.com Subject: Re: Error adding field to join form To: arslist@ARSLIST.ORG Hi Dwayne, Are you able to save the Parent form AssetBase and ComputerSystem without an error, if you don't add a field -- just reposition a field? Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Monday, April 20, 2009 5:28 AM To: arslist@ARSLIST.ORG Subject: Re: Error adding field to join form Hi Janie, You are right. I am trying to add fields directly to the form in the Admin tool. We purchased the v6 Asset Management module about five years ago, but out of its vast potential, we have only used two of its forms. When we upgraded our ARSystem to V7 we were told that we needed to hire a consultant to upgrade the CMDB. We consulted with a consultant, and he said that since we are only using a small portion of the module the best thing to do was just go on using the two form and not bother upgrading the CMDB until we decided to use the entire system. So now we are at ARS 7.1, with a v6 CMDB, and trying to use two Asset Management forms as regular Remedy forms. What puzzles me is that I have added fields directly into BMC:BMC_ComputerSystem_ before and I never got that SQL view error. Now I get the error message when adding new fields, and the system will let me add those old fields to BMC:BMC_ComputerSystem, but not the new ones. I tried checking out the CMDB Console and CMDB2ASSET synchronization and it looks like something requiring an extra layer of knowledge, and which probably won't work anyway given that our CMDB version doesn't match our ARS version. So, any suggestions for a workaround? If not, I'll just say a big THANK YOU! for your reply and abandon the project. At least I know WHY it isn't working. Gratefully yours, Dwayne Martin Original message Date: Sun, 19 Apr 2009 08:39:29 -0700 From: Janie Sprenger jrsrem...@gmail.com Subject: Re: Error adding field to join form To: arslist@ARSLIST.ORG Hi Dwayne, What version of CMDB are you on? AssetBase indicates an older version of CMDB unless you are referring to the SHR:SchemaName reference. Normally, one adds attributes from the CMDB Console and then runs the CMDB2ASSET synchronize which places the fields on the Asset related forms. You can then position your fields on the Asset forms b/c the fields are then on the Custom(x) tabs. Your email sounds like you are adding fields directly to the Forms in the Admin tool? Have you also added the fields to the CMDB metadata? The SQL view error indicates that the actual SQL view (not the table), does not exist in the DB. Do you have access to your DB directly? The index error may be a result of a either an actual duplicate index because of the name, fieldid or because there may be an internal SQL problem with the parent forms. The indexes you mentioned for the parents sound like they are shy of about 7 others that are normally defined. Are you able to save either parent form without adding a new field with no error? Let me know what version of the CMDB you're dealing with. Thanks, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Friday, April 17, 2009 10:33 AM To: arslist@ARSLIST.ORG Subject: Error adding field to join form Dear List, I am trying to add two database fields to the Asset Management Module “AST:ComputerSystem” form. This is a three-layer join form, which starts by joining “BMC:BMC_ComputerSystem_” with “BMC:BMC_AssetBase” to get “BMC:BMC_ComputerSystem.” When I add the fields to either of the two base forms I get: “Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARWARN 69).” First sign of trouble. When I go to “BMC:BMC_ComputerSystem” and try to bring the fields into that form I get: “Field : Equipment Status [the name of the new field] : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382).” and “Some field could not be saved in this form.” There are no errors in the SQL log. To make things still more complicated, there are fields that I added to “BMC:BMC_AssetBase
Error adding field to join form
Dear List, I am trying to add two database fields to the Asset Management Module “AST:ComputerSystem” form. This is a three-layer join form, which starts by joining “BMC:BMC_ComputerSystem_” with “BMC:BMC_AssetBase” to get “BMC:BMC_ComputerSystem.” When I add the fields to either of the two base forms I get: “Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARWARN 69).” First sign of trouble. When I go to “BMC:BMC_ComputerSystem” and try to bring the fields into that form I get: “Field : Equipment Status [the name of the new field] : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382).” and “Some field could not be saved in this form.” There are no errors in the SQL log. To make things still more complicated, there are fields that I added to “BMC:BMC_AssetBase” in a previous project that I can bring into “BMC:BMC_ComputerSystem” with no problem. Both “BMC:BMC_AssetBase” and “BMC:BMC_ComputerSystem” have indexes on InstanceId. What index might they be talking about? Any suggestions? Dwayne Martin James Madison University (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db)
Deleting bogus core field
Dear List, We have a form in our test environment. On that form is a button that was mistakenly created with a field-id of 54. If we export the form definition and try to import it into our production system we get: The following item was not imported: ISA:Request (ARERR 55) Field ID is in the core field range but is not recognized: (54) (ARERR 404) If we try to delete the field we get: Cannot delete a core field : 54 (ARERR 349). How do we get rid of it? Dwayne Martin James Madison University (ARS 7.1, patch 2, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Deleting bogus core field SOLVED
Thanks, Fred. I thot of idea 1 as soon as I submitted the question. I had to not only delete the field description, but also edit num-fields. But it worked. Thanks again, Dwayne Original message Date: Thu, 16 Apr 2009 15:07:52 -0500 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Deleting bogus core field To: arslist@ARSLIST.ORG 2 Ideas... 1 Delete it from the export def file, then re-import 2 Try changing its ID using archgid, then deleting it Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Thursday, April 16, 2009 3:12 PM To: arslist@ARSLIST.ORG Subject: Deleting bogus core field Dear List, We have a form in our test environment. On that form is a button that was mistakenly created with a field-id of 54. If we export the form definition and try to import it into our production system we get: The following item was not imported: ISA:Request (ARERR 55) Field ID is in the core field range but is not recognized: (54) (ARERR 404) If we try to delete the field we get: Cannot delete a core field : 54 (ARERR 349). How do we get rid of it? Dwayne Martin James Madison University (ARS 7.1, patch 2, RH Linux server, Oracle 10.2 db) ___ 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: AR Inside with 7.5
The 7.5 Developer Studio has a Finding related objects feature, that might go a long toward satisfying the void left by the absence of AR Inside. We haven't upgraded yet, so I haven't seen it in action, but for those of you who have, how well does it work? Dwayne Martin James Madison University Original message Date: Tue, 7 Apr 2009 18:19:57 +0200 From: support supp...@arsmarts.com Subject: Re: AR Inside with 7.5 To: arslist@ARSLIST.ORG ** Dear list, The Document functionality of ARSmarts is currently in an advanced phase of development. We plan a beta program sometime in May. The Document feature produces an HTML documentation of AR System objects. It includes the cross-references. It works with cascading style sheets to allow users to modify the layout, put their logo in the header, ... ARS7.5 will be supported. The Document feature will be available from a number of places within ARSmarts. You will have the possibility to document selected AR System objects, obviously. You will also have the possibility to document the result of Search operations, the result of Compare operations, . We'll post a call for beta testers on the list when the beta program starts. Best regards. Kais kais.albas...@arsmarts.com www.arsmarts.com LJ Longwing wrote: ** I specifically asked him for the source, and he refused to give it for reasons not explained to me...he would apparently rather the tool die on the vine rather than let it flourish under another's care. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of patrick zandi Sent: Thursday, April 02, 2009 11:50 AM To: arslist@ARSLIST.ORG Subject: Re: AR Inside with 7.5 ** well what would be nice is if we can we just get him to give it to us.. and we can have one of our longstanding (coders) modify.. accordingly, like Matt, or Chris, or the ARS PERL group! On Thu, Apr 2, 2009 at 1:37 PM, LJ Longwing lj.longw...@gmail.com wrote: I talked to him quite some time ago and he isn't developing the tool anymore, unfortunately. So if it's not working for you you will need to find an alternate tool that will meet your needs. -Original Message- From: Action Request System discussion list(ARSList) __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: 7.5 User Tool Install
I was hoping that by now someone would have responded to Juan and James saying, It works and here's how we did it! We are planning to do a silent install of AR Server 7.5 on Linux, but after reading this exchange we are feeling a bit apprehensive. Has anybody had any success? Dwayne Martin James Madison University * Date: Thu, 26 Mar 2009 09:32:29 -0700 From: Juan Ingles juan.n...@gmail.com ** James, Kind of late for a reply to your message, but for the record... The same thing happens with the silent install of AR Server on Linux. No matter what I do, the install goes to the default location. Since the behavior is the same on different platforms and different installers, I suspect it is an underlying issue with the InstallAnywhere package that BMC is using. I have also run across all sorts of other problems with the silent install that has me on the verge of deciding that it is not viable. The latest gem is LDAP install errors when I don't even select the LDAP features. This has me really frustrated. The silent install is the only way around the X-Windows requirement. (What, exactly, is the value of a console install option if it still requires XWindows?) I hope you've had better luck than I have, Juan Ingles On Fri, Mar 13, 2009 at 11:05 AM, jham36 jha...@gmail.com wrote: HI. I am trying to configure an Options.txt file for a silent install of the 7.5 User Tool. I have been working with support on this, but not getting anywhere. I have found some parameters from the install logs that are not in the template they give you or the documentation, but there are still some pieces missing. I am not sure if anyone has attempted this yet or had any luck. I am trying to build this install so that it will perform an upgrade of sorts to existing 7.1 User Tool installs. No matter what I enter into the Options.txt file for the product install path c:\Program Files\Remedy and for BMC_USER_TOOL_INSTALL_DIRECTORY=c:\Program Files\Remedy (this is one parameter that only shows up in the logs), the user tool still installs to c:\Program Files\Remedy\User This results in having the existing 7.1 User Tool and the 7.5 User Tool installed. I can remove the 7.1 files, but my concern is for users that may have created desktop shorcuts to aruser.exe and such. The other option that is missing is for the preference server. I don't remember if that was part of the 7.1 install or if I just added it to the registry. We use marimba to deploy our application to the desktops, but I am still testing the setup.exe with the options.txt file manually. Running the setup without the options.txt file also results in that User directory being where it is installed. Any help would be appreciated. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Using “ARSystem-ini-template.txt” to upgrade to 7.5 on Linux
Dear List, I am trying to use the “ARSystem-ini-template.txt” file to upgrade to 7.5 on a Linux machine, Oracle 10.2 database. I am a bit puzzled by all the info they are asking for that wasn’t needed in the past, and wondering if it is all really necessary, and if not, what is and under what circumstances? A few specifics: # New Temporary Tablespace required #-J BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE=NEW|OLD Are they saying that a new temp tablespace IS required, or ASKING us if it is? And what is meant by the “NEW|OLD” option? They also ask: # Database DBA login #-J BMC_DATABASE_DBA_LOGIN=DBA User Name # Database DBA password #-J BMC_DATABASE_DBA_PASSWORD=DBA User Password This is followed by 11 different “DBA” questions. Our DBA is a bit reluctant to give me this info, and isn’t sure he wants his password on the system even if it is encrypted. (I’ve been told that encrypted passwords can be de-crypted, but don’t know if it is true.) In the past, the only database name and password we needed was the “ARAdmin.” What is the purpose of this info? Is it needed for the operation of the system, or just for the installation? Would it work to use a temporary password, then change it after the installation? Dwayne Martin James Madison University
Using Hummingbird instead of X Windows to install ARS 7.5
Dear List, The 7.5 installation manual says to use X Windows to install ARS on a Unix or Linux server. We already have Hummingbird, which supposedly works similarly to X Windows. Can we use it or do we need to buy X Windows? (We are presently at ARS 7.1 p3 on a RH Linux server.) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Unzipping 7.5 installer on Unix/Linux
Dear List, We have downloaded the 7.5 installer onto our Linux server, and did the usual gunzip and tar to unzip it. But deep in ARSuiteKit/Disk1/InstData folder is a file called Resource1.zip. Should we unzip it, or leave it alone? Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Unzipping 7.5 installer on Unix/Linux
Thanks, LJ! Dwayne Original message Date: Tue, 10 Mar 2009 13:11:07 -0600 From: LJ Longwing lj.longw...@gmail.com Subject: Re: Unzipping 7.5 installer on Unix/Linux To: arslist@ARSLIST.ORG don't touch anything inside the sub folders...the installer takes care of the rest. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Tuesday, March 10, 2009 12:57 PM To: arslist@ARSLIST.ORG Subject: Unzipping 7.5 installer on Unix/Linux Dear List, We have downloaded the 7.5 installer onto our Linux server, and did the usual gunzip and tar to unzip it. But deep in ARSuiteKit/Disk1/InstData folder is a file called Resource1.zip. Should we unzip it, or leave it alone? Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Workflow stops after exiting guide SOLVED
Thanks, Joe and Shafqat ! Shafqat asked, What happens if you disable the Active link that you have added? The answer is that the workflow continues to completion as you would expect. That got me started eliminating pieces of the guide, till I discovered that I had my Report Server set to a different server. That didn't seem to matter when I was running as Administrator, but when an ordinary user tried to display a Crystal Report, the workflow simply stopped after exiting the guide. The Save button was still enabled but if you clicked it nothing happened. Anybody want to address the issue of why workflow would come to halt in some cases if Report Server is mis-defined, and not other cases? Thanks again, Dwayne *** From: Joe DeSouza joe_rem...@yahoo.com Errors of any kind during the execution of one of the active links before the stop processing signal? Joe *** From: Shafqat Ayaz shafq...@yahoo.com Dwayne two things come to mind, firstly what happens if you disable the Active link that you have added? secondly there isn't a Goto lurking somewhere there is there? thanks shafqat --- On Wed, 3/4/09, Dwayne Martin marti...@jmu.edu wrote: From: Dwayne Martin marti...@jmu.edu Subject: Workflow stops after exiting guide To: arslist@ARSLIST.ORG Date: Wednesday, March 4, 2009, 9:33 PM Dear List, I have a long string of Active Links with “Public” permissions. We’ve been running them for years with no problem. I’ve added a new link in the middle of the sequence that calls a guide that calls additional links (all with “Public” permissions). Now, if I log in with Administrator permissions and run the sequence, the system does what you would expect, namely run the link that calls the guide, exit the guide, then get on with the rest of the links. BUT if I run the process as a test person without Administrator permissions, the system exits the guide, then stops. The AL logging is identical up to exiting the guide, but for Administrator it continues with the series of Active Links, while for the test user it shows “Stop active link processing - On Modify” even tho there are more links to run. It has to be a permissions issue, but all the links have “Public” permissions and my test user has been running them for years. Any ideas? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Workflow stops after exiting guide SOLVED
Sounds logical to me. Thanks, Dwayne Original message Date: Thu, 5 Mar 2009 10:46:24 -0800 From: Joe DeSouza joe_rem...@yahoo.com Subject: Re: Workflow stops after exiting guide SOLVED To: arslist@ARSLIST.ORG ** Dwayne, When running as an Administrator you probably have the same Admininstrator UserID and Password on that 'otehr' server while non admin users do not. So the system probably tries to process whatever it is by connecting to that 'other' server when running as an Administrator user, while it fails for other users. If that is the case, try changing the Administrator password on that other server and it may fail for the Admin user as well.. My two cents.. Cheers Joe From: Dwayne Martin marti...@jmu.edu To: arslist@ARSLIST.ORG Sent: Thursday, March 5, 2009 1:21:06 PM Subject: Re: Workflow stops after exiting guide SOLVED Thanks, Joe and Shafqat ! Shafqat asked, What happens if you disable the Active link that you have added? The answer is that the workflow continues to completion as you would expect. That got me started eliminating pieces of the guide, till I discovered that I had my Report Server set to a different server. That didn't seem to matter when I was running as Administrator, but when an ordinary user tried to display a Crystal Report, the workflow simply stopped after exiting the guide. The Save button was still enabled but if you clicked it nothing happened. Anybody want to address the issue of why workflow would come to halt in some cases if Report Server is mis-defined, and not other cases? Thanks again, Dwayne *** From: Joe DeSouza joe_rem...@yahoo.com Errors of any kind during the execution of one of the active links before the stop processing signal? Joe *** From: Shafqat Ayaz shafq...@yahoo.com Dwayne two things come to mind, firstly what happens if you disable the Active link that you have added? secondly there isn't a Goto lurking somewhere there is there? thanks shafqat --- On Wed, 3/4/09, Dwayne Martin marti...@jmu.edu wrote: From: Dwayne Martin marti...@jmu.edu Subject: Workflow stops after exiting guide To: arslist@ARSLIST.ORG Date: Wednesday, March 4, 2009, 9:33 PM Dear List, I have a long string of Active Links with “Public” permissions. We’ve been running them for years with no problem. I’ve added a new link in the middle of the sequence that calls a guide that calls additional links (all with “Public” permissions). Now, if I log in with Administrator permissions and run the sequence, the system does what you would expect, namely run the link that calls the guide, exit the guide, then get on with the rest of the links. BUT if I run the process as a test person without Administrator permissions, the system exits the guide, then stops. The AL logging is identical up to exiting the guide, but for Administrator it continues with the series of Active Links, while for the test user it shows “Stop active link processing - On Modify” even tho there are more links to run. It has to be a permissions issue, but all the links have “Public” permissions and my test user has been running them for years. Any ideas? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___
Workflow stops after exiting guide
Dear List, I have a long string of Active Links with “Public” permissions. We’ve been running them for years with no problem. I’ve added a new link in the middle of the sequence that calls a guide that calls additional links (all with “Public” permissions). Now, if I log in with Administrator permissions and run the sequence, the system does what you would expect, namely run the link that calls the guide, exit the guide, then get on with the rest of the links. BUT if I run the process as a test person without Administrator permissions, the system exits the guide, then stops. The AL logging is identical up to exiting the guide, but for Administrator it continues with the series of Active Links, while for the test user it shows “Stop active link processing - On Modify” even tho there are more links to run. It has to be a permissions issue, but all the links have “Public” permissions and my test user has been running them for years. Any ideas? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Ordering Remedy documentation on line
Dear List, I was told that you can go to BMC Support web page and order printed versions of the 7.5 documentation. I tried but couldn't find it, but my web-browsing skills may be lacking. Could somebody please point me to the correct link. Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Ordering Remedy documentation on line SOLVED
Thanks, David! Dwayne Original message Date: Tue, 3 Mar 2009 09:41:04 -0600 From: Easter, David david_eas...@bmc.com Subject: Re: Ordering Remedy documentation on line To: arslist@ARSLIST.ORG Bottom of the primary AR System 7.5.00 documentation page: http://www.bmc.com/support/hou_Support_ProdVersion/0,3648,19097_19695_158340_0,00.html -David J. Easter Sr. Product Manager, Solution Strategy and Development BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) on behalf of Dwayne Martin Sent: Tue 3/3/2009 6:26 AM To: arslist@ARSLIST.ORG Subject: Ordering Remedy documentation on line Dear List, I was told that you can go to BMC Support web page and order printed versions of the 7.5 documentation. I tried but couldn't find it, but my web-browsing skills may be lacking. Could somebody please point me to the correct link. Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
“Table Loop Selected Rows Only” gets unselected row, sometimes
Dear List, This is complicated so please bear with me. I have a form that contains a table of entries from another form. On the main form is a button, that calls an outer active link, that calls a guide, that calls an inner active link, that processes the table. The guide is set to “Table Loop Selected Rows Only.” (The inner link writes a column value into a field, which is how you know it has processed the row.) Because the first row in the table is automatically selected, I have an active link that runs on display that sets the table value to 0. When the form displays you can see the table opening up with the top row selected, and then getting de-selected. Once the main form is displayed I click the button and the inner link processes the first table row, even tho it has been de-selected. If I click the button again it does not process the row a second time. If I trigger an error message before clicking the button the inner link does not process the first table row. It seems like the guide doesn’t know that the table row is unselected, until an active link runs in addition to the one that set the table to 0. If I have the two links display the value of the table, they both say it is 0, even as the inner link is processing the row. I tried running a second table refresh after setting the table to 0 and that seems to have fixed the problem, but I am still puzzled by what is going on. Is this a bug, or am I not understanding something? Dwayne Martin James Madison University (ARS and client tools 7.1 p3, RH Linux server, Oracle 10.2 db)
Re: Table Loop Selected Rows Only gets unselected ro w, sometimes
Thanks, LJ! I thot there should be but I looked and looked and couldn't find it. But now I looked one more time and there it was plain as can be. Dwayne Original message Date: Mon, 23 Feb 2009 09:38:12 -0700 From: LJ Longwing lj.longw...@gmail.com Subject: Re: Table Loop Selected Rows Only gets unselected ro w, sometimes To: arslist@ARSLIST.ORG Dwayne, If you are looking to have the first row NOT selected on form open, check the properties of the table field, there is an option to not have anything selected, the default behavior however is to have the first row selected. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Monday, February 23, 2009 9:36 AM To: arslist@ARSLIST.ORG Subject: Table Loop Selected Rows Only gets unselected row, sometimes Dear List, This is complicated so please bear with me. I have a form that contains a table of entries from another form. On the main form is a button, that calls an outer active link, that calls a guide, that calls an inner active link, that processes the table. The guide is set to Table Loop Selected Rows Only. (The inner link writes a column value into a field, which is how you know it has processed the row.) Because the first row in the table is automatically selected, I have an active link that runs on display that sets the table value to 0. When the form displays you can see the table opening up with the top row selected, and then getting de-selected. Once the main form is displayed I click the button and the inner link processes the first table row, even tho it has been de-selected. If I click the button again it does not process the row a second time. If I trigger an error message before clicking the button the inner link does not process the first table row. It seems like the guide doesn't know that the table row is unselected, until an active link runs in addition to the one that set the table to 0. If I have the two links display the value of the table, they both say it is 0, even as the inner link is processing the row. I tried running a second table refresh after setting the table to 0 and that seems to have fixed the problem, but I am still puzzled by what is going on. Is this a bug, or am I not understanding something? Dwayne Martin James Madison University (ARS and client tools 7.1 p3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Workflow objects not displaying in window - SOLVED
Thanks, Conny and Fred, I've never used the Window-Cascade feature and forgot it was there. That solves the problem very nicely, at least in the short run. I am looking at the ar.ini file but don't see anything called Admin-WinPositions. Maybe that's what is causing the problem. The problem comes and goes but at least I know what to do when it happens. Thanks again, Dwayne - Date: Wed 18 Feb 13:39:31 EST 2009 From: Conny Martin conny.mar...@t-systems.com Dwayne, this is a common problem. Select Window-Cascade and all open objects will be arranged in the visible area of your Administrator-Window. HTH Kind Regards Conny - Date: Wed, 18 Feb 2009 10:40:50 -0600 From: Grooms, Frederick W frederick.w.gro...@xo.com Your window list in your preferences is telling Windows to display that window in an XY position off of your monitor. This is the same problem that some people have had with the Object List in the user tool. There are 2 solutions. 1. Edit your ar.ini (the section is called [Admin-WinPositions] ) to fix the position. 2. Edit your ar.ini and remove that section completely. The Admin tool will re-create it. If you use a preference server change the Edit your ar.ini above to be Edit your AR System Administrator Preference record Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Wednesday, February 18, 2009 10:26 AM To: arslist@ARSLIST.ORG Subject: Workflow objects not displaying in window Dear List, I’ve been using the 7.1 p3 version of the client Admin tool for probably a year, but something strange has suddenly started happening. I try to display an Active Link or Filter, and it won’t appear in the window. The Window menu lists it, but when I select it nothing happens. It appears to be displaying outside the window boundary. If I maximize (resize to fit window) any object that IS displaying, then all objects are maximized, including the ones that were off-screen, and I can work with them. But I can only see one at a time, which is unhandy. Two factors that may be related: 1. I have a dual monitor, but I’ve had it for years. 2. I am logged into my PC as “User” rather than “Administrator.” That just happened two weeks ago so it could have something to do with the problem. Any suggestions? (I know we need to upgrade to 7.5, but that doesn’t fit into our schedule just now.) Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db)
Workflow objects not displaying in window
Dear List, I’ve been using the 7.1 p3 version of the client Admin tool for probably a year, but something strange has suddenly started happening. I try to display an Active Link or Filter, and it won’t appear in the window. The Window menu lists it, but when I select it nothing happens. It appears to be displaying outside the window boundary. If I maximize (resize to fit window) any object that IS displaying, then all objects are maximized, including the ones that were off-screen, and I can work with them. But I can only see one at a time, which is unhandy. Two factors that may be related: 1. I have a dual monitor, but I’ve had it for years. 2. I am logged into my PC as “User” rather than “Administrator.” That just happened two weeks ago so it could have something to do with the problem. Any suggestions? (I know we need to upgrade to 7.5, but that doesn’t fit into our schedule just now.) Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db)
Re: Escalation question
Christopher, Unfortunately for your particular task, the Days of the Month and Weekdays are additive, that is if either criteria is met the Escalatio will fire. The best you can do is set a flag on the target form, then have a filter test to see if it meets the additional criteria. Here’s something you might try: -Create a display-only Radio Button field called “DoIt”. -Every Saturday have your Escalation set the “DoIt” flag to “Yes”. -The second Saturday of the month will have a date of 8 – 14. So you have a filter that runs if “’TR.DoIt’ = ”Yes” AND ($DAY$ = 8 AND $DAY$ = 14). This filter does whatever you wanted the escalation to do. Good luck, Dwayne Martin James Madison University Original message Date: Tue, 3 Feb 2009 12:00:17 -0600 From: Pruitt, Christopher J christopher.pru...@eds.com Subject: Escalation question To: arslist@ARSLIST.ORG ** I have been trying to figure out a way to make an Escalation run on the Second Saturday of every month. I know you can schedule it to run at during a specific Hour of the Day, or Day of the Month or even a Week Day but none of these options allow you to run it on a specific day of the Month where it is, say a Second Saturday or Third Monday, etc. Anyone had any success in this area of Escalation scheduling? Configuration: AR System 7.1 Oracle 10g Sun Solaris OS 5.9 Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___
Invalid credentials error when trying to create a Vendor form
Dear List, We are trying to create a Vendor form in order to retrieve AD data using the ARDBC LDAP plugin. When we choose “Create a new Vendor form,” the table displays but no default vendor forms are listed. When we try to enter them in manually and click “Load” we get: Cannot connect to the directory service : Invalid credentials (LDAPERR 49)80090308: LdapErr: DSID-0C090334, comment: AcceptSecurityContext error, data 52e, vece (ARERR 3375). We have, of course, made sure we entered the username and password in correctly. We have verified that the LDAP URL query is constructed correctly by using an LDAP browser to verify its functionality. We have checked the ar.conf file multiple times and all seems to be correct. The plugin log (logging set to ‘All’) shows the plugin loading with no errors or warnings. Any idea where to look for the problem? (ARS 7.1 patch 3, RH Linux server, Oracle 10 db) Dwayne Martin James Madison University
Running Remedy client User tool as PC user
Dear List, Our university is pushing everyone into doing their PC work as “User”, and only using an “Administrator” account for installing software. But it seems that there are all sorts of features that don’t work right when running the User tool as non-administrator. (I could have people launch the Remedy User tool as an administrator, but that is also a bother.) Is there a list of all the items that have to be set to get it to work? Dwayne Martin James Madison University (ARS and client tools 7.1 patch 3, RH Linux server, Oracle 10.2 db)
Re: Running Remedy client User tool as PC user SOLVED (I think)
Thanks, Frederick and others who replied, I started with Frederick's option, but decided instead to create new folders within the C:\Documents and Settings folder, where the PC user already has permission. Same effect. So far the only problem I've found is that Crystal Reports didn't print because user doesn't have access to the Remedy ODBC. I opened ODBC Administrator as user and manually added a AR System ODBC Data Source Usr DSN. That seems to have worked. I guess I'll keep my fingers crossed for the next couple weeks. Thanks again, Dwayne Original message Date: Thu, 29 Jan 2009 13:41:53 -0600 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Running Remedy client User tool as PC user To: arslist@ARSLIST.ORG Just give the user full rights to the Remedy Install directory and their Home directory and everything should work fine. i.e. If the user tool is installed in C:\Program Files\AR System\User and the Home Directory is C:\Documents and Settings\All Users\Application Data\Remedy you can use the following script to set the rights for the built in group Users: cacls C:\Program Files\AR System /T /E /P BUILTIN\Users:F cacls C:\Documents and Settings\All Users\Application Data\Remedy /T /E /P BUILTIN\Users:F Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Thursday, January 29, 2009 12:22 PM To: arslist@ARSLIST.ORG Subject: Running Remedy client User tool as PC user Dear List, Our university is pushing everyone into doing their PC work as “User”, and only using an “Administrator” account for installing software. But it seems that there are all sorts of features that don’t work right when running the User tool as non-administrator. (I could have people launch the Remedy User tool as an administrator, but that is also a bother.) Is there a list of all the items that have to be set to get it to work? Dwayne Martin James Madison University (ARS and client tools 7.1 patch 3, RH Linux server, Oracle 10.2 db)
Re: Error message in response to email template with attachments SOLVED
I sent this problem to BMC Support, and the technician suggested trying field number 57501. So I deleted field 100125, and created a new field 57501, and IT WORKED! After thanking the technician (Matias Campo) profusely I suggested entering this as a bug. The Remedy system itself created field number 100125. There is something wrong when the Remedy system creates a field number that the email engine can't recognize. Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ---BeginMessage--- Dear List, We are trying to submit attached documents via an email template. Our form has an attachment pool with four attachment fields. The template says: . . . Attachment 1 !100124!: something.docx Attachment 2 !100125!: somethingElse.doc Attachment 3 !100126!: Attachment 4 !100127!: . . . The two documents are attached to the email. But the email reply says: Message Number: 4900 Message Text: Invalid Value. Appended Text: Field ID is not related to this form: 100125 “100125” is very clearly the field id for Attachment 2. The template created entries before we tried adding attachments. Any idea what might be wrong? (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ---End Message---
Error message in response to email template with attachments
Dear List, We are trying to submit attached documents via an email template. Our form has an attachment pool with four attachment fields. The template says: . . . Attachment 1 !100124!: something.docx Attachment 2 !100125!: somethingElse.doc Attachment 3 !100126!: Attachment 4 !100127!: . . . The two documents are attached to the email. But the email reply says: Message Number: 4900 Message Text: Invalid Value. Appended Text: Field ID is not related to this form: 100125 “100125” is very clearly the field id for Attachment 2. The template created entries before we tried adding attachments. Any idea what might be wrong? (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Error message in response to email template with attachments
Thanks, Frederick, but the template is being submitted with Administrator permissions. Also, I think that with permission issues you get a message something like You do not have permission on submission to field. . .100125. Dwayne Original message Date: Thu, 15 Jan 2009 15:30:39 -0600 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Error message in response to email template with attachments To: arslist@ARSLIST.ORG Have you checked permissions to the attachment fields and the pool itself? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin Sent: Thursday, January 15, 2009 3:14 PM To: arslist@ARSLIST.ORG Subject: Error message in response to email template with attachments Dear List, We are trying to submit attached documents via an email template. Our form has an attachment pool with four attachment fields. The template says: . . . Attachment 1 !100124!: something.docx Attachment 2 !100125!: somethingElse.doc Attachment 3 !100126!: Attachment 4 !100127!: . . . The two documents are attached to the email. But the email reply says: Message Number: 4900 Message Text: Invalid Value. Appended Text: Field ID is not related to this form: 100125 “100125” is very clearly the field id for Attachment 2. The template created entries before we tried adding attachments. Any idea what might be wrong? (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Objects in Admin Tool off the Screen
I had a similar problem. My Active Link Guides would appear a full panel to the left of the Server Window. I don't see anything in ar.ini that looks like Active Link Guide. But there was a line that says: FrameWnd=-1174 152 960 710 1 I changed the 1174 to 174 and now my guides appear in front of the Server Window. Thanks, Fred, for the good advice. Dwayne Martin James Madison University Original message Date: Wed, 14 Jan 2009 10:13:53 -0600 From: Grooms, Frederick W frederick.w.gro...@xo.com Subject: Re: Objects in Admin Tool off the Screen To: arslist@ARSLIST.ORG I believe the window positions for the Admin tool are stored in the ar.ini file. Look in a section called [Admin-WinPositions] Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, January 14, 2009 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: Objects in Admin Tool off the Screen Its probably your font size on your windows settings that should be Small fonts set to 96 dpi. Joe From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE norm.kai...@eglin.af.mil To: arslist@ARSLIST.ORG Sent: Wednesday, January 14, 2009 10:53:30 AM Subject: Objects in Admin Tool off the Screen Help. I've had this happen before and I've fixed it before but, of course, I can't remember how. Somehow my Admin tool got set where whenever you double click a server object (AL, filter, etc.), the object's property window is somewhere way off the screen and the vertical and horizontal scrollbars are super long. So you can't see the object. Somehow you can reset the tool so that the default window coordinates are, like, 50, 50. Anyone know? Thanks, Norm ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: ADM: Other shoe just fell, no UserWorld 2009, so on with the ARSlist Awards
Great idea, David! Will there be time to go to the Grand Old Oprey, or will be too busy reminiscing and complaining? Count me in! Dwayne Martin James Madison University Original message Date: Tue, 6 Jan 2009 11:50:24 -0600 From: David.M Clark david.m.cl...@state.tn.us Subject: Re: ADM: Other shoe just fell, no UserWorld 2009, so on with the ARSlist Awards To: arslist@ARSLIST.ORG Okay, since BMC has dropped the ball on this we'll just have to handle it ourselves. Feel free to pencil in the week of September 14, 2009 to be in Nashville, TN for David's Remedy User Group. (DRUG '09... Time for a T-shirt design contest.) You can all stay at my place (bring a sleeping bag) and we'll order in pizza and sit around complaining about the current situation and reminiscing about Remedy days gone by. You're welcome, -D P.S. I'll have finished building a pretty elaborate playground in the backyard by that time, so feel free to bring the spouse and kids. P.P.S. Claire is right… I’ll need more chairs. You probably should bring your own. David M Clark Remedy Programmer/Analyst Daniel danielbl...@rogers.com 1/6/2009 10:01 AM Apparently not only did they botch up the 2008, They have decided to follow that up with just not trying for 2009 (they don't say it won't happen, just they will not host it which is not Necessarily the same thing, but this year probably is). Guess that makes the ARSlist the UserWorld 2009, meeting from now to the end of the year, At least for the BMC BSM/Atrium/Remedy crowd. I will let others discuss if this is a good fiscal move or not. I think the value Of the conference outweighs the costs, but I only have to pay the bill for me. In any event, or lack thereof, this means I will be doing the following: 1) Returning to the Vote for the ARSlist Awards for 2008 2) Planning for some set of events that can allow us to properly Do the ARSlist Awards 2009 and provide a method for us all to Share our discoveries of 2009. This may mean a multi-city simultaneous conference, Or setting up a virtual conference. 3) Exploring other on-line avenues to expand what the ARSlist/WWRUG can provide To replace our annual conference networking ability. The first is a FaceBook Group But if folks have other thoughts please let me know ... Daniel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2
We had a situation for months in which we would get server crashes several times a day for no reason. BMC Remedy support sent us a debug server that created a core dump when the server crashed. BMC analyzed this core dump and found it was due to a corrupted Active Link. Other times we've had corrupted links or filters that caused crashes, but have been able to track them down by workflow logging. Not saying that this is what is your problem, but it might be worth checking into. Dwayne Martin James Madison University Original message Date: Wed, 24 Dec 2008 16:08:05 + From: Ron Pierce swa...@live.com Subject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 To: arslist@ARSLIST.ORG ** Tauf, I had a similarissue, about exact actually, last week. It ended up being 1 User Tool Client that was crashing when any workflow kicked off and, somehow, it was crashing the ARS server as well. Once the single User Tool instance was identified and the User closed and restarted the UT everything went back to normal. Might not be the exact same thing for you of course but just to let you know things like this can happen. Ron Date: Wed, 24 Dec 2008 10:22:20 -0500 From: tauf.chowdh...@frx.com Subject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 To: arslist@ARSLIST.ORG ** Joe, Thanks for the quick response. I think RPC is the clue. The reason I think that is because after this happened, when I tried using RDP to remote into the ‘secondary’ AR server, I got an RPC error. RPC Unavailable. So what that leads me to believe is that because the 1 server could not execute RPC calls, it locked up and crashed… which in turn took down the other AR server as well. Does that sound logical? I will investigate with our windows admins. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Wednesday, December 24, 2008 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** Tauf, The RPC call GLEWF is a Get List Entry With Fields, a call that seems to be failing while trying to populate the form after a search with fields in the current entry as well as populate the Results List.. I would begin with asking djones what he or she did at the time when the error happened and then investigate why that search was failing.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Chowdhury, Tauf Sent: Wednesday, December 24, 2008 10:11 AM To: arslist@ARSLIST.ORG Subject: AR Server Crash - Not sure why... - ARS 7.1 patch 2 ** All, OK, this is a new issue that started this week. Environment: AR: Server group, win2k3, 2 AR servers. 2 Mid tier servers running exclusively on tomcat. Remote Oracle 10g DB on Unix cluster. ITSM 7.0.3 p7 ARS 7.1 patch 2, mid tier on tomcat 5.5.20. Symptoms: 1. Users cannot log in. 2. I verify. Cannot log in with user tool on either AR server. 3. AR System Service on both windows boxes are in Started state. 4. Ar error log shows: Tue Dec 23 15:55:03 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:03 2008 Timestamp: Tue Dec 23 2008 15:55:04.5320 Thread Id: 2420 Version: 7.1.00 Patch 002 200802011900 Feb 1 2008 20:12:40 ServerName: remedy-app Database: SQL -- Oracle Hardware: Intel Pentium OS: Windows NT 5.2 RPC Id: 365007 RPC Call: 73 (GLEWF) RPC Queue: 390635 Client: User djones from Mid-tier (protocol 13) at IP address 172.24.19.113 Logging On: Code: c005 Operation: read Access Addr: 0x2 Stack Begin: Stack End Tue Dec 23 15:55:04 2008 390635 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Tue Dec 23 15:55:04 2008 0xc005 Tue Dec 23 15:55:04 2008 390635 : AR System server terminated -- fatal error encountered (ARNOTE 21) 5. Had to restart services to regain connectivity. 6. A few hours went by and I pretty much had a repeat of Steps 1-5. Yes… step 4, the logs look exactly the same. Same user. 7. The next day, Steps 1-5 again, different time, same error but different user
“Save” button automatically set when editing form in Admin tool
Dear List, Forgive me for raising an issue that I know has already been discussed. (I saw it when I was on vacation and meant to check it out when I got back to work, but now I can’t find it. I would be happy if someone could point me to the archive discussion .) Sometimes when you open a form in the Admin tool, the “Save” button is already hi-lited, and if you close the display or switch to another view, it asks you if you want to save. (Not a devastating problem but one of life’s minor annoyances.) It seems to affect some forms but not others. Any idea of why this happens and what we can do about it? Dwayne Martin James Madison University (ARS and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db)
Re: “Save” button automatically set when editing form in Admin t ool
Thanks, everyone! Re: Save it once and you should be good. You are right. Once you save the form it stops complaining. Now that I know that there is a reason for this behavior, and a simple solution, I can concentrate on more urgent problems (of which I do have a few). Gratefully yours, Dwayne Original message Date: Thu, 4 Dec 2008 06:53:25 -0800 From: jham36 [EMAIL PROTECTED] Subject: Re: “Save” button automatically set when editing form in Admin t ool To: arslist@ARSLIST.ORG The only time I have seen this is if I upgrade my Admin Tool. Each form that is opened is asking to be saved under the newer admin tool. Save it once and you should be good. If it asks everytime for the same form(s), then you seem to have another issue. James On Dec 4, 9:43 am, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] wrote: I usually notice it when changing versions of remedy, it seems that it wants to 'adjust' some things. Also, I see it some times whenever I add a new object, the next time I open the form it does that. I usually just close it, ignoring the message, in the event I accidentally did something, then re-open it and save it right away. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, December 04, 2008 8:45 AM To: [EMAIL PROTECTED] Subject: “Save” button automatically set when editing form in Admin tool Dear List, Forgive me for raising an issue that I know has already been discussed. (I saw it when I was on vacation and meant to check it out when I got back to work, but now I can’t find it. I would be happy if someone could point me to the archive discussion .) Sometimes when you open a form in the Admin tool, the “Save” button is already hi-lited, and if you close the display or switch to another view, it asks you if you want to save. (Not a devastating problem but one of life’s minor annoyances.) It seems to affect some forms but not others. Any idea of why this happens and what we can do about it? Dwayne Martin James Madison University (ARS and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db)- Hide quoted text - - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can’t resize form view SOLVED
Thanks, Fred, When I read your letter my first reaction was, Come now, the User tool doesn't expand to display all the fields. I have fields off to the right of the display on all my forms. BUT it turns out that a Dialog window DOES expand to include all the fields (at least in the User tool, but apparently not in Mid-Tier). I had a display-only, hidden character field with no label that I couldn't even see in the Admin tool. I got rid of it, and now the views display normally. Thank you too, David, for your suggestion. Gratefully yours, Dwayne Original message Date: Fri, 21 Nov 2008 15:28:14 -0600 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Can’t resize form view To: arslist@ARSLIST.ORG Are there any fields at the right edge of those specific views? I seem to remember the User tool automatically expanding a view when there were fields to display. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Friday, November 21, 2008 3:26 PM To: arslist@ARSLIST.ORG Subject: Can’t resize form view Dear List, We have a Display-Only, Standard form that we use for dialogs. It has several views, most of which appear normally in the User tool. But two of the views (one is a copy of the other) are elongated horizontally. And no matter how often we re-size them in the Admin tool, they stay elongated in the User tool. But they display properly in Mid-Tier. After editing, we save our view before opening a new view, and when we close the form and re-display it, the views show their new size in the Admin tool, but not in the User tool. I cleared out the cache on my own computer, and displayed the views on a virgin computer that had never had Remedy installed on it before, but they still appear elongated. What am I missing? Dwayne Martin James Madison University (ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Can’t resize form view SOLVED
I was wrong. It wasn't a hidden field. But it was Display as Text which explains why I couldn't see it in the Admin tool Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ---BeginMessage--- Thanks, Fred, When I read your letter my first reaction was, Come now, the User tool doesn't expand to display all the fields. I have fields off to the right of the display on all my forms. BUT it turns out that a Dialog window DOES expand to include all the fields (at least in the User tool, but apparently not in Mid-Tier). I had a display-only, hidden character field with no label that I couldn't even see in the Admin tool. I got rid of it, and now the views display normally. Thank you too, David, for your suggestion. Gratefully yours, Dwayne Original message Date: Fri, 21 Nov 2008 15:28:14 -0600 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Can’t resize form view To: arslist@ARSLIST.ORG Are there any fields at the right edge of those specific views? I seem to remember the User tool automatically expanding a view when there were fields to display. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Friday, November 21, 2008 3:26 PM To: arslist@ARSLIST.ORG Subject: Can’t resize form view Dear List, We have a Display-Only, Standard form that we use for dialogs. It has several views, most of which appear normally in the User tool. But two of the views (one is a copy of the other) are elongated horizontally. And no matter how often we re-size them in the Admin tool, they stay elongated in the User tool. But they display properly in Mid-Tier. After editing, we save our view before opening a new view, and when we close the form and re-display it, the views show their new size in the Admin tool, but not in the User tool. I cleared out the cache on my own computer, and displayed the views on a virgin computer that had never had Remedy installed on it before, but they still appear elongated. What am I missing? Dwayne Martin James Madison University (ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ---End Message---
Can’t resize form view
Dear List, We have a Display-Only, Standard form that we use for dialogs. It has several views, most of which appear normally in the User tool. But two of the views (one is a copy of the other) are elongated horizontally. And no matter how often we re-size them in the Admin tool, they stay elongated in the User tool. But they display properly in Mid-Tier. After editing, we save our view before opening a new view, and when we close the form and re-display it, the views show their new size in the Admin tool, but not in the User tool. I cleared out the cache on my own computer, and displayed the views on a virgin computer that had never had Remedy installed on it before, but they still appear elongated. What am I missing? Dwayne Martin James Madison University (ARS, User and Admin tool 7.1 patch 3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Duplicate work log entries
Dear List, We have a customized call entry form with a Work Log Diary field. One of those entries has a Work Log with duplicate listings. The Log starts out (I’m shortening the text): Friday, October 17, 2008 11:16:51 AM delonfj Hardware Receipt printed and computer received at HelpDesk Wednesday, October 22, 2008 4:55:22 PM maonbk Checking out system now. Wednesday, October 22, 2008 5:28:21 PM maonbk Windows updates and running a full symantec scan now. Etc for seven entries. Then it starts with: 10/17/2008 11:16:51 AM delonfj Hardware Receipt printed and computer received at HelpDesk 10/22/2008 04:55:22 PM maonbk Checking out system now. 10/22/2008 05:28:21 PM maonbk Windows updates and running a full symantec scan now. Etc till it repeats all seven listings, but with a different date format. After that it enters all remaining listings normally, with the original date format, and there are no more repetitions. I tried to find other examples of this repetition but so far haven’t been able to. It isn't exactly a major problem, but it has me curious and I am wondering if anybody has seen anything like it or knows what would cause it. Dwayne Martin James Madison University (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db)
Re: OT:Friday Humor
Brilliant! I wonder who first discovered it. Dwayne Martin James Madison University Original message Date: Fri, 31 Oct 2008 11:18:41 -0700 From: Kevin Gallagher [EMAIL PROTECTED] Subject: OT:Friday Humor To: arslist@ARSLIST.ORG Q: Why do programmers celebrate Christmas on Halloween? A: Because Oct(31) == Dec(25) K. R. Gallagher Mailto: [EMAIL PROTECTED] http://www.krgallagher.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Email template won’t work for Selection field
Dear List, I have a form with a “Math Install type” Selection field, with possible values of “OfficeNetworked,” “OfficeStandAlone,” and “Home.” The field “ID Enumeration” is Linear, just in case that is a factor. We want to create entries in the form via an email template, using the code (I am including the previous and following lines just in case the problem is in one of them): Classification !561000366!: Mathematica Install type !563000665!: OfficeNetworked # Values: OfficeNetworked, OfficeStandAlone, Home College !561000365!: Administration But no matter what value I enter, the template reply comes back with: Message Number: 4944 Message Text: Invalid Enumerated Value supplied for selection field. Appended Text: 563000665: OfficeNetworked I even copied and pasted the choices from the “Value” section of the field definition into the template just to rule out typo’s. Any idea of what might be wrong? (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Email template won’t work for Selection field
Thanks, Matt. I tried removing the space and the comment line, but still get the same error. And the email is going to the server in plain text. Dwayne Original message Date: Thu, 30 Oct 2008 09:17:43 -0500 From: Matthew Perrault [EMAIL PROTECTED] Subject: Re: Email template won’t work for Selection field To: arslist@ARSLIST.ORG Dwayne, We just ran across the same problem and it seemed that outlook/exchange was removing a space character from the value we were passing to an enumerated field. We then sent it in plain text, and it worked for us. Also, I would try sending the following in plain text: Classification !561000366!: Mathematica Install type !563000665!:OfficeNetworked College !561000365!:Administration Remove the spaces in front of the values, and remove the comment section out of it. GL and HTH Matt Perrault -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, October 30, 2008 8:29 AM To: arslist@ARSLIST.ORG Subject: Email template won’t work for Selection field Dear List, I have a form with a “Math Install type” Selection field, with possible values of “OfficeNetworked,” “OfficeStandAlone,” and “Home.” The field “ID Enumeration” is Linear, just in case that is a factor. We want to create entries in the form via an email template, using the code (I am including the previous and following lines just in case the problem is in one of them): Classification !561000366!: Mathematica Install type !563000665!: OfficeNetworked # Values: OfficeNetworked, OfficeStandAlone, Home College !561000365!: Administration But no matter what value I enter, the template reply comes back with: Message Number: 4944 Message Text: Invalid Enumerated Value supplied for selection field. Appended Text: 563000665: OfficeNetworked I even copied and pasted the choices from the “Value” section of the field definition into the template just to rule out typo’s. Any idea of what might be wrong? (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Email Security Key not working
Dear List, We have an “AR System Email Security” entry where “Key” = “Boo” and “UserName” = “superUser.” “superUser” has “Administrator” permissions, and so should be able to submit any form. Our email templates begin like this. . . #AR-Message-BeginDo Not Delete This Line Schema: ET:SoftwareInstall Server: rem2.jmu.edu Key: Boo Action: Submit # Values: Submit, Query Format: Short # Values: Short, Full . . .and they always worked, till now. When the Schema is “ET:SoftwareInstall” as shown above, we get a return message saying : Message Number: 353 Message Text: You have no access to form Appended Text: ET:SoftwareInstall If I log in as “superUser” I can submit an “ET:SoftwareInstall” entry from the User tool. Any idea what could be happening? Yes, the “AR System Email Security/Status” is “Enabled.” (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
ARERR [286] Display only fields cannot be included in a query to the database
Dear List, We want to submit a form entry, and re-open it. In the process of being submitted the form creates some subfile form entries, so we can’t use “$LASTID$.” Instead we query the db for the “max(Request ID).” So in the Active Link, which runs “After Submit,” I set “display-only-field” equal to the value returned by the sql selection. Then it does a “Window Open” and brings up the form entry where “'Request ID' = $display-only-field$. This works in our test/development system, but in the live system I get: “ARERR [286] Display only fields cannot be included in a query to the database: 561000490,” and the window doesn’t open. (561000490 is the display-only-field id.) The error doesn’t appear in the Active Link (workflow.log), filter, or sql logs. I also tried the BMC KB with no luck. The Active Link log shows “display-only-field” being set to the correct value. By adding messages between the Active Link actions I see that the error happens on the “Window Open” command. I replaced “display-only-field” with a database field and that works. But I don’t like using data fields to store useless values. What is wrong with using a display-only field to select a record in an Open Window action? And why would it work OK in one system and not in another (supposedly identical) system? I’ll appreciate any suggestions. (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: ARERR [286] Display only fields cannot be included in a query to the database SOLVED
Thanks, Fred! That worked! Sometimes you have to do things the long cumbersome way before you see the simple and obvious. Or, as in this case, someone else points out the simple and obvious. I am still curious why the Open Window action wouldn't accept my display-only field as a qualifier. Dwayne Original message Date: Tue, 28 Oct 2008 12:19:50 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: ARERR [286] Display only fields cannot be included in a query to the database To: arslist@ARSLIST.ORG Since you are using an After Submit AL you can do it much easier. Just do your Window Open action using: 'Request ID' = $Request ID$ The correct Request ID is available in an After Submit Active Link Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, October 28, 2008 11:57 AM To: arslist@ARSLIST.ORG Subject: ARERR [286] Display only fields cannot be included in a query to the database Dear List, We want to submit a form entry, and re-open it. In the process of being submitted the form creates some subfile form entries, so we can't use $LASTID$. Instead we query the db for the max(Request ID). So in the Active Link, which runs After Submit, I set display-only-field equal to the value returned by the sql selection. Then it does a Window Open and brings up the form entry where 'Request ID' = $display-only-field$. This works in our test/development system, but in the live system I get: ARERR [286] Display only fields cannot be included in a query to the database: 561000490, and the window doesn't open. (561000490 is the display-only-field id.) The error doesn't appear in the Active Link (workflow.log), filter, or sql logs. I also tried the BMC KB with no luck. The Active Link log shows display-only-field being set to the correct value. By adding messages between the Active Link actions I see that the error happens on the Window Open command. I replaced display-only-field with a database field and that works. But I don't like using data fields to store useless values. What is wrong with using a display-only field to select a record in an Open Window action? And why would it work OK in one system and not in another (supposedly identical) system? I'll appreciate any suggestions. (ARS 7.1 patch 2, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating subfile records from list on submit
Thank you, Joe and Frederick ! I am trying the Application-Generate-GUID method. My Filter does a Set Fields that sets a Temp ID field to: $PROCESS$ Application-Generate-GUID I get, Error while performing filter action: Error 38 I couldn't find anything about Error 38 in the BMC Knowledge Base. I tried putting quotes around Application-Generate-GUID even tho I knew that was wrong, but got the same error. Any idea what I am doing wrong? Dwayne Original message Date: Wed, 15 Oct 2008 14:22:45 -0700 From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG ** You could also have the system generate a GUID on the parent record and store it in a hidden field that you could use to bind the child records to the parent record by pushing the GUID instead of the EntryID.. Create the GUID on opening the parent record if the GUID field is null, and use this. Use Application-Generate-GUID in a Set Fields Run process to generate it. Joe - Original Message From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, October 15, 2008 4:49:33 PM Subject: Re: Creating subfile records from list on submit We put a Display Only Processing ID field on the 3rd form and have the main form push to the 3rd form (Standard Phase 2 action). All workflow on the 3rd form takes into account if Processing ID is Null or not. i.e. Data validation takes place if Processing ID = $NULL$. If Processing ID != $NULL$ then it pushes data to the subform (again standard Phase 2 action). Just to keep things clear we rename Modified Date and Last Modified By to Touched Date and Touched By and have our own Modified Date and Last Modified By fields that are filled in by a filter when Processing ID = $NULL$. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, October 15, 2008 3:44 PM To: arslist@ARSLIST.ORG Subject: Creating subfile records from list on submit Dear List, I have a main form and a subfile form. The subfile has two (actually more, but this is just for illustration) fields, a Parent ID field that contains the Entry ID of the main form, and an Info field. On submission of the main form, I use a filter to retrieve a list from a third form, then process that list to create subfile entries. Eg, it would retrieve a list like: abcde hijkl mnopq Then if the main form Request ID is 87 it should produce subfile entries of: Parent ID: 87 Info: abdde Parent ID: 87 Info: hijkl Parent ID: 87 Info: mnopq. So, on submission of the main form, filters process the list, and move each entry on the list into a temp field and do a Push Field to create the subfile record. Here's the problem. Push Fields get deferred to phase 2, and by that time the temp field is overwritten so no subfile records get created. If I add `! to the end if the filter name, the filter runs in phase 1, but the main form Entry ID hasn't been created yet. The ideal would be to run the workflow in an Active Link After Submit, but there are times when the main form itself is created via Push Field action, so the Active Links won't run. Any suggestions? (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating subfile records from list on submit
Yes, it's 255. Dwayne Original message Date: Thu, 16 Oct 2008 11:26:07 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG Just off hand ... Is your Temp ID field at least 38 characters big? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, October 16, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: Creating subfile records from list on submit Thank you, Joe and Frederick ! I am trying the Application-Generate-GUID method. My Filter does a Set Fields that sets a Temp ID field to: $PROCESS$ Application-Generate-GUID I get, Error while performing filter action: Error 38 I couldn't find anything about Error 38 in the BMC Knowledge Base. I tried putting quotes around Application-Generate-GUID even tho I knew that was wrong, but got the same error. Any idea what I am doing wrong? Dwayne Original message Date: Wed, 15 Oct 2008 14:22:45 -0700 From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG ** You could also have the system generate a GUID on the parent record and store it in a hidden field that you could use to bind the child records to the parent record by pushing the GUID instead of the EntryID.. Create the GUID on opening the parent record if the GUID field is null, and use this. Use Application-Generate-GUID in a Set Fields Run process to generate it. Joe - Original Message From: Grooms, Frederick W [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, October 15, 2008 4:49:33 PM Subject: Re: Creating subfile records from list on submit We put a Display Only Processing ID field on the 3rd form and have the main form push to the 3rd form (Standard Phase 2 action). All workflow on the 3rd form takes into account if Processing ID is Null or not. i.e. Data validation takes place if Processing ID = $NULL$. If Processing ID != $NULL$ then it pushes data to the subform (again standard Phase 2 action). Just to keep things clear we rename Modified Date and Last Modified By to Touched Date and Touched By and have our own Modified Date and Last Modified By fields that are filled in by a filter when Processing ID = $NULL$. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, October 15, 2008 3:44 PM To: arslist@ARSLIST.ORG Subject: Creating subfile records from list on submit Dear List, I have a main form and a subfile form. The subfile has two (actually more, but this is just for illustration) fields, a Parent ID field that contains the Entry ID of the main form, and an Info field. On submission of the main form, I use a filter to retrieve a list from a third form, then process that list to create subfile entries. Eg, it would retrieve a list like: abcde hijkl mnopq Then if the main form Request ID is 87 it should produce subfile entries of: Parent ID: 87 Info: abdde Parent ID: 87 Info: hijkl Parent ID: 87 Info: mnopq. So, on submission of the main form, filters process the list, and move each entry on the list into a temp field and do a Push Field to create the subfile record. Here's the problem. Push Fields get deferred to phase 2, and by that time the temp field is overwritten so no subfile records get created. If I add `! to the end if the filter name, the filter runs in phase 1, but the main form Entry ID hasn't been created yet. The ideal would be to run the workflow in an Active Link After Submit, but there are times when the main form itself is created via Push Field action, so the Active Links won't run. Any suggestions? (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating subfile records from list on submit
Thanks, Fred! Re: You may have to look in the filter logs to see what is going on. That is where I got the Error while performing filter action: Error 38 message. I guess I should have said that. Dwayne Original message Date: Thu, 16 Oct 2008 12:24:15 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG Error 38 is Filter or escalation set field process returned an error. A filter or escalation was performing a Set Fields action using the option to run a process and return a value, but the process returned an error message. The text of the message returned is displayed with this error. The error terminates the operation being performed, and the current transaction is rejected. No update to the database occurs. The Filter Set Fields action is $PROCESS$ Application-Generate-GUID which is what you have. You may have to look in the filter logs to see what is going on. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, October 16, 2008 12:03 PM To: arslist@ARSLIST.ORG Subject: Re: Creating subfile records from list on submit Yes, it's 255. Dwayne Original message Date: Thu, 16 Oct 2008 11:26:07 -0500 From: Grooms, Frederick W Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG Just off hand ... Is your Temp ID field at least 38 characters big? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Thursday, October 16, 2008 11:21 AM To: arslist@ARSLIST.ORG Subject: Re: Creating subfile records from list on submit Thank you, Joe and Frederick ! I am trying the Application-Generate-GUID method. My Filter does a Set Fields that sets a Temp ID field to: $PROCESS$ Application-Generate-GUID I get, Error while performing filter action: Error 38 I couldn't find anything about Error 38 in the BMC Knowledge Base. I tried putting quotes around Application-Generate-GUID even tho I knew that was wrong, but got the same error. Any idea what I am doing wrong? Dwayne Original message Date: Wed, 15 Oct 2008 14:22:45 -0700 From: Joe DeSouza Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG ** You could also have the system generate a GUID on the parent record and store it in a hidden field that you could use to bind the child records to the parent record by pushing the GUID instead of the EntryID.. Create the GUID on opening the parent record if the GUID field is null, and use this. Use Application-Generate-GUID in a Set Fields Run process to generate it. Joe - Original Message From: Grooms, Frederick W To: arslist@ARSLIST.ORG Sent: Wednesday, October 15, 2008 4:49:33 PM Subject: Re: Creating subfile records from list on submit We put a Display Only Processing ID field on the 3rd form and have the main form push to the 3rd form (Standard Phase 2 action). All workflow on the 3rd form takes into account if Processing ID is Null or not. i.e. Data validation takes place if Processing ID = $NULL$. If Processing ID != $NULL$ then it pushes data to the subform (again standard Phase 2 action). Just to keep things clear we rename Modified Date and Last Modified By to Touched Date and Touched By and have our own Modified Date and Last Modified By fields that are filled in by a filter when Processing ID = $NULL$. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, October 15, 2008 3:44 PM To: arslist@ARSLIST.ORG Subject: Creating subfile records from list on submit Dear List, I have a main form and a subfile form. The subfile has two (actually more, but this is just for illustration) fields, a Parent ID field that contains the Entry ID of the main form, and an Info field. On submission of the main form, I use a filter to retrieve a list from a third form, then process that list to create subfile entries. Eg, it would retrieve a list like: abcde hijkl mnopq Then if the main form Request ID is 87 it should produce subfile entries of: Parent ID: 87 Info: abdde Parent ID: 87 Info: hijkl Parent ID: 87 Info: mnopq. So, on submission of the main form, filters process the list, and move each entry on the list into a temp field and do a Push Field to create the subfile record. Here's the problem. Push Fields get deferred to phase 2, and by that time the temp field is overwritten so no subfile records get created. If I add `! to the end if the filter name, the filter runs in phase 1, but the main form
Re: Creating subfile records from list on submit SOLVED
Field 179 did it! Thanks, Brian, and everyone else who responded. I didn’t know about that feature so for the benefit of anyone equally ignorant, I’ll copy what the manual says: “To auto-populate a field with a GUID, define a character field using field ID 179. A GUID is available through all filter phases. By contrast, the value of Request ID field is not available until an entry has been successfully committed to the database. You can set the attributes of the GUID field, except for field type, length, and ID.” I created a field called “F179” with an ID of 179. I have filters that end with `!, and during phase 1 they do “Push Fields” to create subfile records with a Parent ID equal to F179. Then at the very end a filter does a “Push Fields” to all subfile records where Parent ID = F179. This filter does not end with `!, so the Push Field runs in phase 2 when the Entry ID has been set, so it updates all the subfile “Parent ID” fields to the real Parent ID. One interesting feature of F179, if you look at the field you don't see any value, but if you follow the filter log you see a long string of gibberish getting pushed to other fields. Thanks again, everyone! Dwayne Original message Date: Thu, 16 Oct 2008 12:18:43 -0700 From: Brien Dieterle [EMAIL PROTECTED] Subject: Re: Creating subfile records from list on submit To: arslist@ARSLIST.ORG ** Right, I think Joe and I are trying to suggest using an ActiveLink and not a filter :-) Brien On Thu, Oct 16, 2008 at 11:34 AM, Grooms, Frederick W [EMAIL PROTECTED] wrote: A Filter does not use the @@: syntax (Evidenced by the v7.1.0 filter AR System Email GUID Generator) I pulled the 38 length from Field 179 on the stock ARS form AR System Email Association Dwayne, Out of curosity, try changing the field to 38 characters long (maybe the command does not like fields 255 characters long. Fred -Original Message- From: Action Request System discussion list(ARSList) __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Creating subfile records from list on submit
Dear List, I have a main form and a subfile form. The subfile has two (actually more, but this is just for illustration) fields, a Parent ID field that contains the Entry ID of the main form, and an Info field. On submission of the main form, I use a filter to retrieve a list from a third form, then process that list to create subfile entries. Eg, it would retrieve a list like: abcde hijkl mnopq Then if the main form Request ID is 87 it should produce subfile entries of: Parent ID: 87 Info: abdde Parent ID: 87 Info: hijkl Parent ID: 87 Info: mnopq. So, on submission of the main form, filters process the list, and move each entry on the list into a temp field and do a Push Field to create the subfile record. Here’s the problem. Push Fields get deferred to phase 2, and by that time the temp field is overwritten so no subfile records get created. If I add `! to the end if the filter name, the filter runs in phase 1, but the main form Entry ID hasn’t been created yet. The ideal would be to run the workflow in an Active Link “After Submit,” but there are times when the main form itself is created via Push Field action, so the Active Links won’t run. Any suggestions? (ARS 7.1, patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Highlighting table field rows
Several months ago I submitted an enhancement request to allow the selection of multiple rows. Is there any chance that if more people requested it they would actually do it? Dwayne Martin James Madison University Original message Date: Wed, 24 Sep 2008 07:10:37 -0500 From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] Subject: Re: Highlighting table field rows To: arslist@ARSLIST.ORG Since you can select all of them, is there a RP to de-select a row? Basically, you could start out by selecting all of the rows, then just deselect the rows you don't want.. I doubt there is one, but that would get around the issue you are having. It would make sense if they had one. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, September 23, 2008 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Highlighting table field rows ** There is an RP to select the contents of a table (all of them), and one to select the results, but no actual action to change the display characteristics of the row - that's what is missing from all of the strategies we've considered. I did consider an External, and even modifying the JSP or something, but I'm still left with either a very messy bunch of workflow and/or something that doesn't look right on the Mid-Tier. I may just have to do it old school and return a results list. Thanks, Joe. Rick On Tue, Sep 23, 2008 at 2:58 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Thats true. I think it allows only a single selection. I wonder if there is a RP to select the results of a query.. Just like the application delete RP can delete the results of a query.. If not it might be a good RFE.. And your workaround for now could be a table with a dynamic external qualification.. Not quite the look and feel of what you want to achieve though.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, September 23, 2008 5:25:48 PM Subject: Re: Highlighting table field rows ** I was just looking at the APIs and RPs. The only problem with PERFORM-ACTION-TABLE-SELECT-NODE, is that there still doesn't appear to be an action to actually highlight the row in sequence, much less allow this multiple times. Rick On Tue, Sep 23, 2008 at 2:16 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** What about Perform-Action-Table-Select-Node table field ID row number Do not use the optional arguments Column number and flag.. Joe - Original Message From: Mark Milke [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, September 23, 2008 4:53:59 PM Subject: Re: Highlighting table field rows Rick, as far I'm concerned this is not possible via Workflow. You can highlight only one row at a time. The only idea that I haven't tested yet would be to press the Shift Key via OLE while making the loop. Mark On Sep 23, 10:47 pm, Rick Cook [EMAIL PROTECTED] wrote: I have a table field on which I wish to hightlight only the selected rows that match a search field. The AL Guide is built, and the AL logs shows that it seems to be catching the correct records, but the rows aren't highlighting. What is the actual action in the AL to do that in the Guide? Rick __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Similar Group Names
Joe, Wouldn't '$GROUP$ like (100012; + %)' depend on 100012; being the first group on the list? How about '$GROUP$ like (100012; + %) or '$GROUP$ like (%;100012; + %)'? That would still eliminate 1100012. Dwayne Martin, James Madison University Original message Date: Wed, 17 Sep 2008 16:09:41 -0700 From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Similar Group Names To: arslist@ARSLIST.ORG ** Depending on how you have structured your Group ID's you are less likelier to get this error if you base your search criteria on the Group ID of the group. It is a good practice therefore to have a good group ID naming convention wherein a like search for a group say $GROUP$ like (100012; + %) would not result in finding another group that has its ID say 1100012. Remember to include the semi colon at the end of the Group ID as that is how the Group ID's are separated in the database in the C104 column of the T table belonging to the User schema.. Take a good look at the contents of the C104 column in your T table of the User schema to arrive at what might be the best search for you.. Joe - Original Message From: Robert Molenda [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, September 17, 2008 6:46:07 PM Subject: Re: Similar Group Names ** Don't you just have to love the LIKE %Groupname% functionality? That's HD 5x for you... it is because of the LIKE queries... To get around this in the past we put a non-descript character in the group name which is getting 'duplicated' so your your example if you change Quest to Quest. (with a period) that will correct (circumvent) the issue although people might not like it but you get what you got. HTH Robert On Thu, Sep 18, 2008 at 8:33 AM, Shane Buchholz [EMAIL PROTECTED] wrote: ** I ran into an interesting problem today with group names that are similar. One group is called Quest, and another group has the word Request in it. Members of the group with Request in the name are seeing tickets assigned to the group called Quest without actually being members of the group. When I change the group name to have anything other than just Quest it works correctly. Has anyone seen this before, and maybe know the cause? I could not find anything on the Remedy Support site or in the ARList Archives. Any help would be appreciated. AR System – 6.3 Help Desk – 5.6 Windows 2003 Server SP2 SQL 8.0 Thanks, Shane Buchholz Information Security Specialist Remedy Administrator Account Services – Information Services __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- If it were not for the gutter, my mind would be homeless! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Email Security key not working
Dear List, In our “AR System Email Security” form we have an entry with a “Key” value of “KeyName.” In “User Name” we have the Login Name of a person with “Administrator” permissions. In our email templates we have a line that says “Key: KeyName.” This works in our production system. But in our test system we get “You do not have write access (at create time) to field” for every field in the template. As far as I can see, the “AR System Email Security” and “AR System Email Mailbox Configuration” entries, and the email template are identical on both systems. I’ve checked the permissions of the “User Name” in both systems. Any idea what might be making the difference? (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Plain Text Body blank in ARS Email Messages entry replies to templates
Dear List, We have a test Remedy system, and have disabled the outgoing mailbox so that customers don’t get emails about test calls. If we want to see what mail would have gone out we can look at the “AR System Email Messages” entries, and the message will be in the “Plain Text Body” field. The one problem is in Email Engine replies to template submissions. We send a template to the Email Engine, and the Engine replies with details about the newly created entry, or an error message saying what went wrong. We want to see these replies, but the “Plain Text Body” field is blank. (So is HTML Body.) So where is the message stored in a reply to a template, and is there any way of reading it? (I tried running a Remedy Report on an entry, and even fields that showed data on display turned up blank in the report.) (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Plain Text Body blank in ARS Email Messages entry replies to templates SOLVED
Thanks, Christie! I didn't see anything under Variable Replacement, but under Attachment Alternatives I found something called RED56469.tmpl that has the message. (I never noticed it in all my poking around.) Thanks again, Dwayne Original message Date: Thu, 18 Sep 2008 10:41:38 -0700 From: Pargeter, Christie :CO IS [EMAIL PROTECTED] Subject: Re: Plain Text Body blank in ARS Email Messages entry replies to templates To: arslist@ARSLIST.ORG on the email messages screen select Display Advanced Options of Yes. Then go to the Advanced Options tab. The first sub tab will show you the names of your email templates. The Variable Replacement tab's Field Values will show you the fields that will be sent to the templates. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Thursday, September 18, 2008 10:41 AM To: arslist@ARSLIST.ORG Subject: Plain Text Body blank in ARS Email Messages entry replies to templates Dear List, We have a test Remedy system, and have disabled the outgoing mailbox so that customers don’t get emails about test calls. If we want to see what mail would have gone out we can look at the “AR System Email Messages” entries, and the message will be in the “Plain Text Body” field. The one problem is in Email Engine replies to template submissions. We send a template to the Email Engine, and the Engine replies with details about the newly created entry, or an error message saying what went wrong. We want to see these replies, but the “Plain Text Body” field is blank. (So is HTML Body.) So where is the message stored in a reply to a template, and is there any way of reading it? (I tried running a Remedy Report on an entry, and even fields that showed data on display turned up blank in the report.) (ARS 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
“Failed to perform Action” when exporting data in Mid-Tier
Dear List, We have a form from which we want to export data via Mid-Tier. If I put the report in my User Tool and export the data to a comma separated file (csv), the data exports and I can import it into Excel, open it, and see all the data. In Mid-Tier I select the “Report” form entry to which the file is attached, and try to export data and I get “Failed to perform Action.” There are no message in the Mid-Tier log. If I try to export the data to the “Screen,” Excel opens, but only shows seven (and not the first seven, they appear to be selected at random) of the 26 columns. The report displays to the screen OK. Other reports on this same form export data OK from Mid-Tier. I checked the “Report” form entries and don’t see any difference between this entry and the ones that work. Any idea what might be wrong? (ARS and Mid-Tier 7.1 patch 3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: I am new to ARS I need help
Another possibility. On Submit and Modify use the LENGTH() function to see how long the text is, and if it is 254 send an error message. Dwayne Martin James Madison University Original message Date: Thu, 14 Aug 2008 20:26:32 -0700 From: Rick Cook [EMAIL PROTECTED] Subject: Re: I am new to ARS I need help To: arslist@ARSLIST.ORG ** This may not seem so, but AR System has functioned that way for many years, and so it is not a bug. The only ways to get the excess data out of the field are: 1) Go into the DB and remove it there (recommended for DBAs only) 2) Increase the size of the field to accommodate the size of the data (consider the performance impact first) 3) Use one of the tools/utilities designed for situations like this. Search BMC's Developer Network or the ARSList archives for more information on that. In the meantime, don't do the cut/paste any more until you can verify that the field will hold the data being pasted. Rick On Thu, Aug 14, 2008 at 8:00 PM, gok's [EMAIL PROTECTED] wrote: There is a charcter field and data input is 254 which I gave and when I try to cut copy paste like more than 254 it's taking ...I in't want that .what i want is when ever any user is trying to cut copy more than 254 it should show error message ...lister ...guru's..pandits ..can you help me put here. TQ -- View this message in context: http://www.nabble.com/I-am-new-to-ARS-I-need-help-tp18947556p18947556.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to test yet disable Email on dev server
I have a filter on my development server that, on Submit changes the AR System Email Messages/To field to my email address, so all the emails come to me. It also adds the original To to the subject so I can see who it originally was supposed to go to. But, as Sharon II points out, you can simply look at the AR System Email Messages entries to see what email would have gone out, so most of the time we just leave the development mailbox disabled. Dwayne Martin James Madison University Original message Date: Tue, 12 Aug 2008 09:28:06 +0300 From: Sharon-Michal Mamon-Meged [EMAIL PROTECTED] Subject: Re: How to test yet disable Email on dev server To: arslist@ARSLIST.ORG Hi sharon , you say Emails are not visible in the AR System Email Messages form why ? email messages is the form that could give you the answer to your question . In this form you can see the html email template without email going out . Best Regards, sharon mamon-meged AR System administrator phone : 972-3-9165229 moblie : 050-9165229 Sharon Menachem [EMAIL PROTECTED] .COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list (ARSList)Subject [EMAIL PROTECTED] How to test yet disable Email on ORG dev server 11/08/2008 17:32 Please respond to [EMAIL PROTECTED] RG ** I have a dev server which being a complete copy of production generates outgoing emails exactly as the production server would. I have stopped the email service so that the emails don’t go out. (ARS 6.3 patch 24 on Win 2003, SQL 2000, Helpdesk 5) I am now tasked with sending out survey emails to confirm call closure etc. using email templates. Outgoing email configuration is set NOT to delete outgoing emails. The filters are running correctly in the log Emails are not visible in the AR System Email Messages form. How can I set up the server so that emails do not go out to the general population but in such a way that I can see the html email template that was generated? Thanks in advance, Sharon __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Send a Diary Field as an attachment.
Way back when the world was young I submitted a suggestion to make the database diary field content readable to workflow. I never heard anything about it. Maybe if more people requested it it might happen. Or maybe there is some reason why it isn't a good idea. Dwayne Martin James Madison University Original message Date: Wed, 16 Jul 2008 17:46:00 -0400 From: Reiser, John J [EMAIL PROTECTED] Subject: Re: Send a Diary Field as an attachment. To: arslist@ARSLIST.ORG ** Jason, I also run simple .csv reports. I was looking for a way to just dump one field from one record into one attachment without the runmacro and the batch file for cleaning the directory. I was concerned about putting a large diary field into the body of an email so I thought I'd use the Attachment. I guess I'll just have to grab that old set of escalations and make them filters. Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Wednesday, July 16, 2008 4:48 PM To: arslist@ARSLIST.ORG Subject: Re: Send a Diary Field as an attachment. ** Hi John, That sounds like pretty good solution. I have done something similar to automate emailing some basic reports (csv files) natively with only Remedy and OS commands. One note on your clean up, running an PERFORM-ACTION-DELETE-ATTACHMENT will not delete an attachment on the harddrive, only out of a Remedy attachment field. You can either do a run process that like RUN PROCESS del path\file.txt or create a small batch file that you can call from a filter and pass the file name to it. Another option would be to use Crystal Reports if you have them. Crystal Server can send various format attachments (pdf, doc, xls) on a schedule or on an event (but it takes a kind of hokey work around to make events work). If you have Crystal Reports but not Crystal Server you can use CRexporter (http://www.rainforestnet.com/crexport-download.htm). It is a free tool that can run a Crystal reports, export it in various formats. You can easly call it from a filter to run the report and email it. HTH, Jason On Tue, Jul 15, 2008 at 1:50 PM, Reiser, John J [EMAIL PROTECTED] wrote: Hello Listers, ARS 6.3 Patch 21 MS SQL Server 2000 MS Windows 2000 Am I missing something basic? I have been asked to forward the Call Log (Diary Field) along with a notification email as an attachment. The only way I can think of doing this is to 1. Use a RUN PROCESS runmacro.exe which runs a report to save the diary field to a text file. 2. Use a RUN PROCESS PERFORM-ACTION-ADD-ATTACHMENT attachment fieldID Path\File.txt 3. Use the Attachment field in the filter action that loads and sends a message from the AR System Email Messages form. It doesn't need to be in one filter. It just has to be transparent to the user and clean up after itself. RUN PROCESS PERFORM-ACTION-DELETE-ATTACHMENT and delete the path\file.txt Am I on the right path or do it follow the twisty path into the gnarled woods. go west Thanks, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARWARN 61 when submitting via Mid-Tier SOLVED
At BMC Supports suggestion I added Suppress-warnings: 61 to the ar.conf file. That solved it. I should have thot of that myself. Dwayne ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ---BeginMessage--- Dear List, We have a form with an “Email Log” diary field. The only workflow connected with it is two filters that push to the log whenever there is an email message about the entry. No workflow for the field fires on Submit. When someone without read permissions to the field submits a call via Mid-Tier, they get a message that says: “You do not have read access (for this entry) to field : Email log (ARWARN 61).” The entry is submitted OK. They do not get this message from the WUT. There are no errors or references to the field in the Active Link or Filter logs. The sql log shows: SELECT C536870931 FROM T575 WHERE C1 = 'ITR02912'. . .OK UPDATE T575 SET C536870931 = EMPTY_CLOB() WHERE C1 = 'ITR02912' …OK SELECT C536870931 FROM T575 WHERE C1 = 'ITR02912' FOR UPDATE. . .OK (575 is the schemaid and 536870931 the fielded.) both when run from Mid-Tier and the WUT. So why are users getting this error, and how can I stop it, other than by giving “Public” read permission to the field? (ARS 7.1 patch 3, Mid-Tier 7.1.00 Build 200708221849, RH Linux serve, Oracle 10.2 db) Dwayne Martin James Madison University ---End Message---
Re: Business Time
Tadeu, We have something similar. We use Log hours to calculate how many business hours it took a technician to solve a problem. Log hours = $PROCESS$ Application-Bus-Time2-Diff $begin time$ $TIMESTAMP$ Holidays Workday Holidays and Workday are defined in Business Time Segment entries with Holidays and Workday as the ID. This gives the value in seconds, so you have to divide by 3600 to get hours or 86400 to get days. One tricky feature is that to edit these entries after submission you have to check Draft then save to make the fields editable, then Publish and save. I don't know what happens if somebody tries to calculate Log hours during the time you are editing. We are at ARS 7.1. There are other ways of calculating business time that worked in previous versions. Good luck, Dwayne Martin James Madison University Original message Date: Tue, 15 Jul 2008 16:42:58 -0300 From: Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] Subject: Business Time To: arslist@ARSLIST.ORG ** Hello Dwayne... Thanks for your reply... I have an application/form that when I create a new record, my back-office operators have to close this record in 5 days, for example... we have a limit of days to leave this record open and then, close it! What I would like to do is to disconsider Weekends and Holidays for this case For example: If a record has been opened on Wednesdey (09/07/2008), It would be closed 5 days later (disconsidering weekends and/or holidays), i.e., it would be closed on next Wednesdey (16/07/2008) P.S.: We are not considering Hours of Work (such as 8:00 - 17:00)... We consider full day, i.e., 24hs per day. Thanks-in-advance! Any tips will be appreciated! Thanks again Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq - Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Reports don't display SORRY!
My stupid mistake! I was working in our test system, but in the configuration I had Report Server set to the live system. The reason the report wasn't displaying the report was that the Report entry wasn't defined in the live system. I seem to make that same mistake at least once a year. Some people just don't learn from experience. Sorry to bother everyone. Dwayne Original message Date: Tue, 15 Jul 2008 12:20:38 -0700 From: Janie [EMAIL PROTECTED] Subject: Re: Crystal Reports don't display To: arslist@ARSLIST.ORG Dwayne, Have you cycled the Crystal Enterprise server services? I have seen this happen many times when a Report gets stuck in the Crystal PageServer service. I've found that recycling all of the services seems to work the most efficiently, but one can try just stopping the Pageserver and restarting it. HTH, Janie -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, July 15, 2008 12:15 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports don't display Troy, Thank you for your reply. But no, the permissions haven't changed, and I am running as Administrator. The blank white screen only happens in Mid-Tier. In the WUT it shows the hour-glass for three seconds, but nothing else happens. I haven't changed any of the ODBC setting. But thanks for your suggestions. I'm grateful for any ideas I can get. Dwayne Original message Date: Tue, 15 Jul 2008 08:48:46 -0700 From: Troy Sasso [EMAIL PROTECTED] Subject: Re: Crystal Reports don't display To: arslist@ARSLIST.ORG Dwayne, Did any of the custom form permissions change by chance? I've had this happen in past where the CR runs perfectly. But when added and run from an entry in the WUT Report form, shows a blank screen. This turned out to be related to permissions on the custom form anf form fields. Or, have any of your ARServer settings, ODBC settings changed since Friday? Troy --- On Tue, 7/15/08, Dwayne Martin [EMAIL PROTECTED] wrote: From: Dwayne Martin [EMAIL PROTECTED] Subject: Crystal Reports don't display To: arslist@ARSLIST.ORG Date: Tuesday, July 15, 2008, 7:54 AM Dear List, We have a CallEntry form with four buttons. Each button calls its own Active Link, which displays its own Crystal Report for that particular entry. Each Crystal Report is attached to a Report form entry. Friday all four of them worked. Yesterday (and still today) one of the reports refused to display. You could click the button and the hour glass would appear for a few seconds, but no report. In Mid-Tier it displays a blank white page. The report still displays in Crystal itself, including the same entries that won't display in Remedy. The question is, Is the problem in the Crystal Report, or the Report entry? If I try the CR in a different Report entry that did display, it doesn't display there either. On the other hand, if I attach a Crystal Report that displays in other Report entries, to this Report entry, it doesn't display. It looks like both the Crystal Report AND the Report entry have gone bad. ( I also have another Report entry that doesn't work for no apparent reason no matter what Crystal Report I attach to it.) The workflow.log is identical for the reports that display and don't display. The Report entries that work and those that don't are identical except for Report Name and Report Set Name. I am running as Administrator, so there shouldn't be any permissions issue. I am totally stumped. Any suggestions? (ARS and WUT 7.1 patch 3, CR IX, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Crystal Reports don’t display
Dear List, We have a CallEntry form with four buttons. Each button calls its own Active Link, which displays its own Crystal Report for that particular entry. Each Crystal Report is attached to a “Report” form entry. Friday all four of them worked. Yesterday (and still today) one of the reports refused to display. You could click the button and the hour glass would appear for a few seconds, but no report. In Mid-Tier it displays a blank white page. The report still displays in Crystal itself, including the same entries that won’t display in Remedy. The question is, Is the problem in the Crystal Report, or the “Report” entry? If I try the CR in a different “Report” entry that did display, it doesn’t display there either. On the other hand, if I attach a Crystal Report that displays in other “Report” entries, to this “Report” entry, it doesn’t display. It looks like both the Crystal Report AND the “Report” entry have gone bad. ( I also have another “Report” entry that doesn’t work for no apparent reason no matter what Crystal Report I attach to it.) The workflow.log is identical for the reports that display and don’t display. The “Report” entries that work and those that don’t are identical except for Report Name and Report Set Name. I am running as Administrator, so there shouldn’t be any permissions issue. I am totally stumped. Any suggestions? (ARS and WUT 7.1 patch 3, CR IX, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Crystal Reports don’t display
Troy, Thank you for your reply. But no, the permissions haven't changed, and I am running as Administrator. The blank white screen only happens in Mid-Tier. In the WUT it shows the hour-glass for three seconds, but nothing else happens. I haven't changed any of the ODBC setting. But thanks for your suggestions. I'm grateful for any ideas I can get. Dwayne Original message Date: Tue, 15 Jul 2008 08:48:46 -0700 From: Troy Sasso [EMAIL PROTECTED] Subject: Re: Crystal Reports don’t display To: arslist@ARSLIST.ORG Dwayne, Did any of the custom form permissions change by chance? I've had this happen in past where the CR runs perfectly. But when added and run from an entry in the WUT Report form, shows a blank screen. This turned out to be related to permissions on the custom form anf form fields. Or, have any of your ARServer settings, ODBC settings changed since Friday? Troy --- On Tue, 7/15/08, Dwayne Martin [EMAIL PROTECTED] wrote: From: Dwayne Martin [EMAIL PROTECTED] Subject: Crystal Reports don’t display To: arslist@ARSLIST.ORG Date: Tuesday, July 15, 2008, 7:54 AM Dear List, We have a CallEntry form with four buttons. Each button calls its own Active Link, which displays its own Crystal Report for that particular entry. Each Crystal Report is attached to a “Report” form entry. Friday all four of them worked. Yesterday (and still today) one of the reports refused to display. You could click the button and the hour glass would appear for a few seconds, but no report. In Mid-Tier it displays a blank white page. The report still displays in Crystal itself, including the same entries that won’t display in Remedy. The question is, Is the problem in the Crystal Report, or the “Report” entry? If I try the CR in a different “Report” entry that did display, it doesn’t display there either. On the other hand, if I attach a Crystal Report that displays in other “Report” entries, to this “Report” entry, it doesn’t display. It looks like both the Crystal Report AND the “Report” entry have gone bad. ( I also have another “Report” entry that doesn’t work for no apparent reason no matter what Crystal Report I attach to it.) The workflow.log is identical for the reports that display and don’t display. The “Report” entries that work and those that don’t are identical except for Report Name and Report Set Name. I am running as Administrator, so there shouldn’t be any permissions issue. I am totally stumped. Any suggestions? (ARS and WUT 7.1 patch 3, CR IX, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Notification philosophy - Use the Group List or a data driven form.
John, I THINK that if the person is in the list more than once heesh will still only get one email. At least that has been my experience, but you'd better check rather than take my word for it. Dwayne Martin James Madison University Original message Date: Thu, 10 Jul 2008 12:47:22 -0400 From: Reiser, John J [EMAIL PROTECTED] Subject: Notification philosophy - Use the Group List or a data driven form. To: arslist@ARSLIST.ORG Hello Listers, ARS 6.3 Patch 21 SQL Server 2000 Windows 200 server I am reworking a small help desk application and I was wondering if there is a general philosophy for handling email lists. We are identifying a list of people types: Management Field Rep Ticket Expediter Warranty Clerk etc. There will be a few people in each type and the names can change frequently. More that once a month. And a person can be multiple types. ( Field Rep AND Warranty Clerk). We wouldn't want them getting two emails if both types were selected for notification. Usually I make a group and use it to send the notifications but I was concerned that adding a new type and the constant flexibility of the user community among the types would be better suited to a data driven form. I like the use of a Group in the email notification for expanding the addresses. I'm not sure if I have to worry about the To: field and a 255 character limit if I use a non-standard Notification workflow. Would dynamic or computed groups be a solution? My ultimate goal is to hand over the list maintenance to a power user. Thanks in Advance, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
ARWARN 61 when submitting via Mid-Tier
Dear List, We have a form with an “Email Log” diary field. The only workflow connected with it is two filters that push to the log whenever there is an email message about the entry. No workflow for the field fires on Submit. When someone without read permissions to the field submits a call via Mid-Tier, they get a message that says: “You do not have read access (for this entry) to field : Email log (ARWARN 61).” The entry is submitted OK. They do not get this message from the WUT. There are no errors or references to the field in the Active Link or Filter logs. The sql log shows: SELECT C536870931 FROM T575 WHERE C1 = 'ITR02912'. . .OK UPDATE T575 SET C536870931 = EMPTY_CLOB() WHERE C1 = 'ITR02912' …OK SELECT C536870931 FROM T575 WHERE C1 = 'ITR02912' FOR UPDATE. . .OK (575 is the schemaid and 536870931 the fielded.) both when run from Mid-Tier and the WUT. So why are users getting this error, and how can I stop it, other than by giving “Public” read permission to the field? (ARS 7.1 patch 3, Mid-Tier 7.1.00 Build 200708221849, RH Linux serve, Oracle 10.2 db) Dwayne Martin James Madison University
Re: Walking table, reading and setting hi-liting rows SOLVED
Since it is not possible to select multiple table rows via workflow I submitted that as an enhancement request. Then I basically followed Frederick's suggestion (see below). Two things I learned: 1 In order to set workflow based on double-clicking a table row you have to go to Display tab and un-check Table Drill Down. 2 On display, I needed to re-select the table rows based on the storage field, but I found that the table rows were getting set before the table was displayed, and then the display blew away the settings. So I un-checked Refresh on Entry Change, then on Display, did a Change Fields refresh, then set the rows. Thanks again, Frederick, and all others who responded. Dwayne Martin James Madison University From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows In-Reply-To: A[EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Like I said I could not highlite multiple rows thru workflow. My solution was to do the following: Add a Display Only field on the form (I used a 3 character field) Add this Display Only field as a column in the table (Yes you can add Display only fields from the form that holds the table as columns in the table). I called my column Selected In your Display workflow do the following Refresh the table walk the table while walking the table if 'your storage field' like % + 'Entry ID col' + % then set the display only field to Yes and set the column to Yes else clear the display only field I also changed it so that users double click on a row instead of multiple selecting and that set's the Selected column to Yes for that row (If Col = Yes clear the col and the Display Only else set both. Fred ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Including attachments in email template submission?
Dear List, Our users enter data into ASP web pages, which send email templates to the Remedy system to create Remedy call entries. Is it possible to have the user attach a file to a field in the web page, and have that file included in the template, and become an attachment in the resulting call entry? Dwayne Martin James Madison University (ARS 7.1, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Walking table, reading and setting hi-liting rows
Thad, Thanks for the idea. I'll give it a try. Dwayne Original message Date: Wed, 18 Jun 2008 15:16:58 -0700 From: Thad K Esser [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows To: arslist@ARSLIST.ORG ** Dwayne, Your original post said you are on version 7.1. I haven't played with it much, but page 368 of the Form and Application Objects manual says you can change the colors of rows in tables based on selection fields. If you combined that with Fred's suggestion below, you could set the foreground color to white and the background color to black when the status was Yes. It wouldn't truly be a selected row, but it would look that way to the user. I don't know how well that would play out in practice for what you are doing, but its crazy enough that it just might work. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach Grooms, Frederick WTo arslist@ARSLIST.ORG [EMAIL PROTECTED] cc Sent by: Action RequestSubject Re: Walking table, System discussion reading and setting list(ARSList) hi-liting rows arslist@ARSLIST.ORG 06/18/2008 02:47 PM +-+ | Please respond to | | arslist@ARSLIST.ORG | +-+ Like I said I could not highlite multiple rows thru workflow. My solution was to do the following: Add a Display Only field on the form (I used a 3 character field) Add this Display Only field as a column in the table (Yes you can add Display only fields from the form that holds the table as columns in the table). I called my column Selected In your Display workflow do the following Refresh the table walk the table while walking the table if 'your storage field' like % + 'Entry ID col' + % then set the display only field to Yes and set the column to Yes else clear the display only field I also changed it so that users double click on a row instead of multiple selecting and that set's the Selected column to Yes for that row (If Col = Yes clear the col and the Display Only else set both. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, June 18, 2008 2:45 PM To: arslist@ARSLIST.ORG Subject: Re: Walking table, reading and setting hi-liting rows Thank you, Frederick, Andrew and Frank, for your replies. I got waylaid and hope we haven't lost our train of thot. What I am trying to do is: 1. Let the user hi-lite some rows in a table. When the entry is saved, write a list of hi-lited rows into a field, which is saved with the record. 2. When the record is displayed, read the field and use the value in the field to hi-lite the same rows that were selected in the previous session. The first step turned out to ridiculously simple. All I had to do is have an Active Link call a guide that does a table loop and Table Loop Selected Rows Only, and it creates a neat little list of hi-lited rows. I think Step 2 is impossible. As Frederick has pointed out you [can] not set the highlite on multiple rows thru workflow, The Workflow Objects 7.1 manual, p223 shows how to select a row by setting the value of the table field to the desired row number. But it says nothing about selecting multiple rows (ie simulating a cntrl-click). It also appears that you can't even read a table on Display. My storage field keeps a list based on an Entry ID col field in the table. I set up an Active Link to set the table to 0 on Display (un-hilite the first row), then call a guide that walks the table, and if the field where I was storing the values is LIKE % + $Entry ID col$ + %, display a message with the value in the Entry ID col. The message displayed for every row, whether the values matched or not, but the Entry ID col value was null. The table didn't fill till the messages stopped displaying, and when it did, the first row was hi-lited. It appears that the Display Active Links fire before the tables are filled, so you really can't get any info from a table when a record is displayed. I am used to telling my customers that Remedy can do anything! But it looks like I have hit a dead end this time. Could someone please prove me wrong. Dwayne Martin Original message Date: Mon, 16 Jun 2008 09:28:47 -0500 From: Grooms, Frederick W [EMAIL
Re: Walking table, reading and setting hi-liting rows
Thanks, Carey, I did a search in the Form and Application and Workflow Objects manuals for extra column but didn't find anything. Where can I get more info? Dwayne Original message Date: Thu, 19 Jun 2008 10:03:22 -0400 From: Carey Matthew Black [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows To: arslist@ARSLIST.ORG I think you will find that the color is only set for the rows when the table is refreshed. Changing the selection value after refresh does not change the row color. (At least in v6.3 it did not work that way. Maybe 7.1 will be different, but I doubt it.) And frankly, given any ADA requirements, using color is a bad way to communicate with users. I personally prefer the extra column approach. You can even combine the two if you want to as well. The extra column could be 'Display Type' = Read Only-HTML and stuff HTML into each cell to color the page and add text to match the state for the row. So the background could be green and you could put the word green in the cell too. ( Just a thought) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Jun 18, 2008 at 6:16 PM, Thad K Esser [EMAIL PROTECTED] wrote: ** Dwayne, Your original post said you are on version 7.1. I haven't played with it much, but page 368 of the Form and Application Objects manual says you can change the colors of rows in tables based on selection fields. If you combined that with Fred's suggestion below, you could set the foreground color to white and the background color to black when the status was Yes. It wouldn't truly be a selected row, but it would look that way to the user. I don't know how well that would play out in practice for what you are doing, but its crazy enough that it just might work. Thad Esser Remedy Developer Argue for your limitations, and sure enough, they're yours.-- Richard Bach ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Walking table, reading and setting hi-liting rows
Excuse me, Carey. I misunderstood what you were saying. You were referring to Frederick’s solution below. That look’s do-able, and I’ll give it a try. Thank you, Carey, and Fred, and all others who responded. Dwayne Date: Thu, 19 Jun 2008 10:03:22 -0400 Reply-To: arslist@ARSLIST.ORG Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG From: Carey Matthew Black [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows In-Reply-To: [EMAIL PROTECTED] Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline I think you will find that the color is only set for the rows when the table is refreshed. Changing the selection value after refresh does not change the row color. (At least in v6.3 it did not work that way. Maybe 7.1 will be different, but I doubt it.) And frankly, given any ADA requirements, using color is a bad way to communicate with users. I personally prefer the extra column approach. You can even combine the two if you want to as well. The extra column could be 'Display Type' = Read Only-HTML and stuff HTML into each cell to color the page and add text to match the state for the row. So the background could be green and you could put the word green in the cell too. ( Just a thought) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. ** Date: Wed, 18 Jun 2008 16:47:29 -0500 Reply-To: arslist@ARSLIST.ORG Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows In-Reply-To: A[EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii Like I said I could not highlite multiple rows thru workflow. My solution was to do the following: Add a Display Only field on the form (I used a 3 character field) Add this Display Only field as a column in the table (Yes you can add Display only fields from the form that holds the table as columns in the table). I called my column Selected In your Display workflow do the following Refresh the table walk the table while walking the table if 'your storage field' like % + 'Entry ID col' + % then set the display only field to Yes and set the column to Yes else clear the display only field I also changed it so that users double click on a row instead of multiple selecting and that set's the Selected column to Yes for that row (If Col = Yes clear the col and the Display Only else set both. Fred
Re: Walking table, reading and setting hi-liting rows
Thank you, Frederick, Andrew and Frank, for your replies. I got waylaid and hope we haven’t lost our train of thot. What I am trying to do is: 1. Let the user hi-lite some rows in a table. When the entry is saved, write a list of hi-lited rows into a field, which is saved with the record. 2. When the record is displayed, read the field and use the value in the field to hi-lite the same rows that were selected in the previous session. The first step turned out to ridiculously simple. All I had to do is have an Active Link call a guide that does a table loop and “Table Loop Selected Rows Only,” and it creates a neat little list of hi-lited rows. I think Step 2 is impossible. As Frederick has pointed out “you [can] not set the highlite on multiple rows thru workflow,” The “Workflow Objects” 7.1 manual, p223 shows how to select a row by setting the value of the table field to the desired row number. But it says nothing about selecting multiple rows (ie simulating a cntrl-click). It also appears that you can’t even read a table on Display. My storage field keeps a list based on an “Entry ID col” field in the table. I set up an Active Link to set the table to 0 on Display (un-hilite the first row), then call a guide that walks the table, and if the field where I was storing the values is “LIKE “%” + $Entry ID col$ + “%”, display a message with the value in the “Entry ID col”. The message displayed for every row, whether the values matched or not, but the “Entry ID col” value was null. The table didn’t fill till the messages stopped displaying, and when it did, the first row was hi-lited. It appears that the “Display” Active Links fire before the tables are filled, so you really can’t get any info from a table when a record is displayed. I am used to telling my customers that “Remedy can do anything!” But it looks like I have hit a dead end this time. Could someone please prove me wrong. Dwayne Martin Original message Date: Mon, 16 Jun 2008 09:28:47 -0500 From: Grooms, Frederick W [EMAIL PROTECTED] Subject: Re: Walking table, reading and setting hi-liting rows To: arslist@ARSLIST.ORG ** In 6.3 I tried to do just what Dwayne is wanting and found you could not set the highlite on multiple rows thru workflow. I had to settle with making a Selected column and displaying that when re-displaying the list to the user. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Friday, June 13, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Walking table, reading and setting hi-liting rows ** I do not have the 7 docs handy but I know there is lot of information in the 6.3 docs about table walking, specifically about what you are asking. 1. Remedy knows if the row is selected using the $ROWSELECTED$ keyword. I believe it even knows which row was selected as the primary and which was selected as the secondary. 2. In order to highlite a row you need to reference the table name and a row number in a set fields action. Page 659 in 6.3 basic guide has everything you need to know. Look for a Workflow Extras section in the 7 docs. On Fri, Jun 13, 2008 at 2:43 PM, Dwayne Martin [EMAIL PROTECTED] wrote: Dear List, I am sure this is spelled out very plainly in the documentation, but I can't seem to find it. I want the user to be able to hi-lite table rows, save the entry, and have those same table rows hi-lited when the entry is re-displayed. So the user will cntl-click several rows to hi-lite them. Then on save, an Active Link Guide will walk the table, and if the row is hi-lited it will write the Entry ID for the row into a Char field. But how does it know if the row is hi-lited? On Display, another AL Guide will walk the table, and if Char Field is LIKE % + 'Entry ID col' + % it will hi-lite the row. But how does it do that? Actually, I'd be happy if somebody could point out where this is explained in the manual. (ARS 7.1, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___