Re: ARERR 400 - form does not hold a form definition
Thad, From what I understand about how ARS creates a new form the process is roughly something like this get the next schemaId value. Insert a form named FormN (01 is the norm, but you must have 01..06 so it went with 07). Then all the non-default properties are set for Form07 then at the end a Rename is done to move the name from Form07 to what ever you called it in the Admin Tool. I would also try to rename a form and see what happens then too. And on your dev server (that is working normally) repeat actions there and compare the SQL logs. That will most likely produce a Red Flag for what is NOT happening on prod. The root of this is likely very easy and centered around the form meta data. You might have issues like: The server things Form01..06 exist but they do not and it chokes because it tries to update it's cache and fails(something goes bang) to do so. Their is a VUI/field definition for an arschemaId that does not exist and ...bang... The hard part is you are well beyond what most of us can trouble shot from this end of emails. :( And your Prod server is where the problem is, but your Dev server is Happy. You also mentioned that your problems started with an import to the production server. what likely happened is that you tripped over a failure in ARS to be fully backwards compatible (or some other subtle thing) that you may not be able to fully duplicate. It might even have been something like the ARS server lost it's connection to the RDBMS during the object import and only part of the objects got there. Which might explain why the server thinks there are Form01..06 out there somewhere. I doubt BMC Level 1 Tech support will be of much help, but you should already be hammering them for help too. Good luck. -- 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 10/12/06, Thad Esser [EMAIL PROTECTED] wrote: ** Below is the SQL log for when I created the form. The thing I find odd is that I'm saving the form with a name like xxxJunk, but the sql shows Form07. Indeed, a Form07 is created, although when I open it, the admin tool has to adjust the fields to improve the view. schemaid in the control table was 606 before the save, and it was 607 after, so it looks like that part is working as it should. Do you guys/gals see anything else in these logs? Thanks, Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach snip Thad, My first though would be to turn on SQL logs as you try to create a new form. Then pick through the log and see what the ARS server is doing before it gives the error. It may be subtle to find, but I would hope that the SQL log would show you what is going on. -- 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 10/12/06, Thad Esser [EMAIL PROTECTED] wrote: ** Hello, Recently, when trying to import a def file, we started getting an ARERR 400. After searching the archives, I found where someone else had the same issue, but I didn't see that a solution was posted. Based on that conversation, I tried just creating a new regular form, with no modifications and saving it. On save we get the following error: The following item was not imported : xxxjunk (ARERR 55) The file specified for a form does not hold a form definition (ARERR 400) This is on our production server and doesn't happen on our dev server. Does anyone have any suggestions on where to start? Server: ARS 6.3, no patch Oracle: 9.2.0.6 OS: Win2k, sp4 Thanks, Thad ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Merges Vs. Submit and Modify for Filters
Hi Lisa - Can you tell me how you are able to update through an import? In reading this post, I'm interested in trying to figure out what you're doing b/c we have a number of instances where an update through a straight import would come in handy. Or - are you importing a file and handling your data matching via workflow? Just curious - thx. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
OT:Re: Keystroke command
I just noticed, in checking this out, that for some fields the menu pops open as soon as you click in the data-space, and for others it doesn't. Any idea why? Dwayne Martin James Madison University Original message Date: Thu, 12 Oct 2006 13:07:14 -0700 From: Thad Esser [EMAIL PROTECTED] Subject: Re: Keystroke command To: arslist@ARSLIST.ORG ** With focus in the field, ALT-up arrow or ALT-down arrow works. Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach CLB RemedyTo arslist@ARSLIST.ORG [EMAIL PROTECTED] cc Sent by: Action Request Subject Keystroke command System discussion list(ARSList) arslist@ARSLIST.ORG 10/12/2006 12:53 PM +-+ | Please respond to | | arslist@ARSLIST.ORG | +-+ ** Can anyone tell me if there is a keystroke command that can be performed to get the drop down boxes instead of clicking on the arrows? Thank you, Stacie Jerden (562) 570-6738 [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Error in identification process in recon engine
** Hello,Has you given a similar error in an reconlliation job log?[Fri Oct 13 14:17:24 2006] [DETAILS] [TID: 002574] : Getting attribute values for 1 instances[Fri Oct 13 14:17:24 2006] [ ERROR ] [TID: 002574] : Failed in getting parents for instance AGa629a7b0RS9Qvwp01rYA40IA of class BMC_ComputerSystem:: [Fri Oct 13 14:17:24 2006] [ ERROR ] [TID: 002574] : ARERR[120002] La clase no existe.[Fri Oct 13 14:17:24 2006] [ ERROR ] [TID: 002574] : AROS_WEAK_RELATIONSHIP:AROS_WEAK_RELATIONSHIPIf you have had an error similar, please reply me, I cannot find anything similar in the support web knowledge base or the arslist. Thank you very much.AIX 5.3 + ORACLE 9i + ARS 6.3 + ITSM 6.0 + CMDB 1 patch2 __20060125___This posting was submitted with HTML in it___
Re: Merges Vs. Submit and Modify for Filters
Cindy, It's really easy, I just create a file with the Request ID in one column and then the info that needs to be changed in the other columns. Save it to a .csv file and then use the Import Tool. You have to change your preferences (in the Import Tool) to Update Old Record with New Record's Data. This is extremely helpful when we need to make a lot of changes to multiple fields. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cindy Sapochetti Sent: Friday, October 13, 2006 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Merges Vs. Submit and Modify for Filters Hi Lisa - Can you tell me how you are able to update through an import? In reading this post, I'm interested in trying to figure out what you're doing b/c we have a number of instances where an update through a straight import would come in handy. Or - are you importing a file and handling your data matching via workflow? Just curious - thx. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Merges Vs. Submit and Modify for Filters
And as an added bonus... If you also export 'Last modified by' and 'Modified Date' fields then the change to the record will not update those fields. So the data can be updated without stomping on those values if you want to via a MERGE action. ( This however is not possible if you take the workflow approach as that is a MODIFY action.) HTH. -- 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 10/13/06, Kemes, Lisa [EMAIL PROTECTED] wrote: Cindy, It's really easy, I just create a file with the Request ID in one column and then the info that needs to be changed in the other columns. Save it to a .csv file and then use the Import Tool. You have to change your preferences (in the Import Tool) to Update Old Record with New Record's Data. This is extremely helpful when we need to make a lot of changes to multiple fields. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cindy Sapochetti Sent: Friday, October 13, 2006 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: Merges Vs. Submit and Modify for Filters Hi Lisa - Can you tell me how you are able to update through an import? In reading this post, I'm interested in trying to figure out what you're doing b/c we have a number of instances where an update through a straight import would come in handy. Or - are you importing a file and handling your data matching via workflow? Just curious - thx. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Duplicate Records
Title: Duplicate Records ** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil Sully Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788 __20060125___This posting was submitted with HTML in it___
Re: Duplicate Records
Title: Duplicate Records ** Sure ... You can do a simple Set Fields action to set a Display Only temp field as an indicator. A second filter then checks the indicator to see if the value exists. Example Scenario: Regular Remedy form called FormA with only default fields (plus a 15 char display only field called zTmpDupID). You want to make sureusers don't enter a short description twice. Submit version Filter 1 On Submit Action 1: Set fields Read value from FormA Set Fields If: 'Short Description' = $Short Description$ No Requests Match Set to $NULL$ Any Requests Match Use First Matching Set zTmpDupID = $Request ID$ Modifyversion Filter 1 On Modify Action 1: Set fields Read value from FormA Set Fields If: 'Short Description' = $Short Description$ and 'Request ID' != $Request ID$ No Requests Match Set to $NULL$ Any Requests Match Use First Matching Set zTmpDupID = $Request ID$ Filter 2 If zTmpDupID != $NULL$ Show Error to prevent save Hope this info helps Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF AFRL/SNOXSent: Friday, October 13, 2006 8:08 AMTo: arslist@ARSLIST.ORGSubject: Duplicate Records ** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil "Sully" Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788 __20060125___This posting was submitted with HTML in it___
Re: ARERR 400 - form does not hold a form definition
Thad, I'm not sure if this will be the case for you or not, but when we had a similar problem (I'm not sure if we had the 400 error) it turned out that the time on the AR server was significantly off from the database. I think it was like months (we were running on a VM), but once we changed the date, things started working for us again. Don't know if it will help, but it's one more thing to look at -Original Message- From: Thad Esser [EMAIL PROTECTED] To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: 10/12/06 4:56 PM Subject: Re: [ARSLIST] ARERR 400 - form does not hold a form definition Below is the SQL log for when I created the form. The thing I find odd is that I'm saving the form with a name like xxxJunk, but the sql shows Form07. Indeed, a Form07 is created, although when I open it, the admin tool has to adjust the fields to improve the view. schemaid in the control table was 606 before the save, and it was 607 after, so it looks like that part is working as it should. Do you guys/gals see anything else in these logs? Thanks, Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach SELECT checkInterval FROM servgrp_config COMMIT WORK SELECT name FROM servgrp_config COMMIT WORK SELECT schemaId FROM control UPDATE control SET schemaId = 607 INSERT INTO arschema (name,schemaId, schemaType,coreVersion,timestamp,numFields,defaultVui,numVuis,nextId,maxStatEnums,owner,lastChanged,safeGuard,nextFieldId,upgrdVersion) VALUES ('Form07',606,4,2,1160692477,0,'Default Admin View',0,1,0,'r610803','r610803','Q5ponDKxPvLxt6ZZ8xAWrAdnftlx8H79DFDedzb3S42Cmn7SyKYgh68JEledcnsOZWY4I1lX83kgt9ZjlRzsX9EmjQj12nvV',536870912,0) SELECT version,smObjProp from arschema WHERE schemaId = 606 UPDATE arschema SET numVuis=1,safeGuard='PllpvbdeLHs3h6LBQgBZoQ2ok3qcyNzsRfbLihD0tr8btUl/HVZPnBs6BmNpna+3rXWcxG0q7L2w6ber493lFvc/ImxeLr4r',timestamp=1160692477,lastChanged='r610803' WHERE schemaId = 606 INSERT INTO vui (schemaId,vuiId,vuiName,locale,vuiType,timestamp,owner,lastChanged) VALUES (606,536870912,'Default Admin View',NULL,1,1160692477,'r610803','r610803') INSERT INTO field_dispprop (schemaId,fieldId,listIndex,vuiId,propShort) VALUES (606,NULL,0,536870912,'1\20\4\18\Default Admin View\') SELECT 1 FROM control COMMIT WORK SELECT schemaId,memberA,memberB,options,queryShort,queryLong FROM schema_join WHERE schemaId=606 ORDER BY 1 ASC,2 ASC,3 ASC SELECT schemaId,tableName,keyField,queryShort,queryLong FROM schema_view WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,vendorName,tableName FROM schema_vendor WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,vuiId,vuiName,locale,vuiType,timestamp,owner,lastChanged FROM vui WHERE schemaId=606 ORDER BY 1 ASC,2 ASC SELECT schemaId,fieldId,fieldType,timestamp,owner,lastChanged,datatype,fOption,createMode,defaultValue,fieldName FROM field WHERE schemaId=606 ORDER BY 1 ASC,2 ASC SELECT schemaId,fieldId,memberIndex,mfieldId FROM join_mapping WHERE schemaId=606 ORDER BY 1 ASC,2 ASC SELECT schemaId,fieldId,extField FROM view_mapping WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,extField FROM vendor_mapping WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,rangeLow,rangeHigh FROM field_int WHERE schemaId=606 ORDER BY 1 ASC,2 ASC SELECT schemaId,fieldId,rangeLow,rangeHigh,arprecision FROM field_real WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,maxLength,menuStyle,qbeMatchOp,charMenu,pattern,fullTextOptions,isLong FROM field_char WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,fullTextOptions,isLong FROM field_diary WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,enumStyle,maxEnum,schemaName,serverName,nameField,numberField,queryShort,queryLong FROM field_enum WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,enumId,value FROM field_enum_values WHERE schemaId=606 ORDER BY 1 ASC,2 ASC,3 ASC SELECT schemaId,fieldId,maxSize,attachType FROM field_attach WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,rangeLow,rangeHigh,arprecision FROM field_dec WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,rangeLow,rangeHigh,arprecision,funcCurr,allowCurr FROM field_curr WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,numColumns,maxRetrieve,tfSchema,tfServer,queryShort,queryLong,sampleServer,sampleSchema FROM field_table WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,parent,dataField,colLength,dataSource FROM field_column WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,maxLength FROM field_view WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,maxLength,isLong FROM field_display WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,minDate,maxDate FROM field_date WHERE schemaId=606 ORDER BY 1 ASC SELECT schemaId,fieldId,vuiId,propShort,propLong FROM field_dispprop WHERE schemaId=606 ORDER BY 1 ASC,2 ASC,3 ASC SELECT schemaId,fieldId,groupId,permission FROM field_permissions WHERE schemaId=606 ORDER
Re: Keystroke command
Hi Dwayne, If a menu is attached to a field where the display type is set as Drop-Down List, clicking the field will cause it to open the menu. If a menu is attached to a field where the display type is set as Edit or Edit Masked, clicking the field will set focus to the field without opening the menu. Eric Cleereman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Friday, October 13, 2006 8:14 AM To: arslist@ARSLIST.ORG Subject: OT:Re: Keystroke command I just noticed, in checking this out, that for some fields the menu pops open as soon as you click in the data-space, and for others it doesn't. Any idea why? Dwayne Martin James Madison University Original message Date: Thu, 12 Oct 2006 13:07:14 -0700 From: Thad Esser [EMAIL PROTECTED] Subject: Re: Keystroke command To: arslist@ARSLIST.ORG ** With focus in the field, ALT-up arrow or ALT-down arrow works. Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach CLB RemedyTo arslist@ARSLIST.ORG [EMAIL PROTECTED] cc Sent by: Action Request Subject Keystroke command System discussion list(ARSList) arslist@ARSLIST.ORG 10/12/2006 12:53 PM +-+ | Please respond to | | arslist@ARSLIST.ORG | +-+ ** Can anyone tell me if there is a keystroke command that can be performed to get the drop down boxes instead of clicking on the arrows? Thank you, Stacie Jerden (562) 570-6738 [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Remedy Adminsitrator Engineer/Developer positions with Time Warner Cable
My name is Lynn Romano and I am a Senior Recruiter with Time Warner Cable in Herndon, VA. We currently have four full time opportunities within our Advanced Technology and Network Operations Groups for Remedy professionals. I am sending this email with the intention of expand my network within the Remedy community. Although the level of these positions may not be right for you, I am hoping that you would pass my contact information on to anyone who may be a good person to network with further. Please note there is relocation assistance is available for non-local candidates! For more information about these positions, please visit our www.timewarnercable.jobs and search requisition #s 64493BR, 65763BR, 5400BR, or 65401BR. Thank you in advance for your time. Regards, Lynn Romano Sr. Recruiter, Talent Acquisition Time Warner Cable 13241 Woodland Park Road Herndon, VA 20171 703.345.2580 Voice 571.230.2252 Cell 704-973-6120 Data (Right Fax) [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Remedy Developers, Engineers, Administrators - opportunities with Time Warner Cable
My name is Lynn Romano and I am a Senior Recruiter with Time Warner Cable in Herndon, VA. We currently have four full time opportunities within our Advanced Technology and Network Operations Groups for Remedy professionals. I am sending this email with the intention of expanding my network within the Remedy community. Although the level of these positions may not be right for you, I am hoping that you would pass my contact information on to anyone who may be a good person to network with further. Please note there is relocation assistance available for non-local candidates! For more information about these positions, please visit our website www.timewarnercable.jobs and search requisition #s 64493BR, 65763BR, 5400BR, or 65401BR. Thank you in advance for your time. Regards, Lynn Romano Sr. Recruiter, Talent Acquisition Time Warner Cable 13241 Woodland Park Road Herndon, VA 20171 703.345.2580 Voice 571.230.2252 Cell 704-973-6120 Data (Right Fax) [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
Axton, If it's an upgrade and not a patch then this is the one that we were also waiting for. We had gotten an email on the 5th that noted the release was going to be within the next week. I thought that there would have been more of a formal announcement from BMC/Remedy. At least a note on the What's Hot on the Support web site given the Tech Alert: Upgrade to ARS 7.0 Unicode is not yet possible note on the site. Thanks, Dave Date:Thu, 12 Oct 2006 09:56:26 -0400 From:Axton [EMAIL PROTECTED] Subject: Re: ARServer 7.0.1 Upgrade Installer 7.0.1 was released at the beginning of the month. This was not a patch, but an upgrade. I was assuming this was the release that support/engineering keeps referencing every time I've spoken with them in the last few months. Axton Grams Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Duplicate Records
You can combine the two Filter #1's below too. Use the second Set field If: Qualification (include AND 'Request ID' != $Request ID$). It will work just as well for Submit as it does modify. The basic idea is Test4Dup that was published back in the days of old in an RxPress. ( Circa 91? 92?) The only gotcha is that it does not work for multiple transaction that are taking place right now. (AKA: before the first transaction is committed to the RDBMS.) One POSSIBLE way to get around that is to do a Filter non-phased Push to a second form with data the you would us in the Test4Dup logic. Then issue a Application-Release-Pending and have your Test4Dup logic run on the target form for the Push action. I think that will catch the second record even if the first parent record is not yet committed to the RDBMS. (But I have not tested that idea. Bugs may abound...) -- 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 10/13/06, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Sure ... You can do a simple Set Fields action to set a Display Only temp field as an indicator. A second filter then checks the indicator to see if the value exists. Example Scenario: Regular Remedy form called FormA with only default fields (plus a 15 char display only field called zTmpDupID). You want to make sure users don't enter a short description twice. Submit version Filter 1 On Submit Action 1: Set fields Read value from FormA Set Fields If: 'Short Description' = $Short Description$ No Requests Match Set to $NULL$ Any Requests Match Use First Matching Set zTmpDupID = $Request ID$ Modify version Filter 1 On Modify Action 1: Set fields Read value from FormA Set Fields If: 'Short Description' = $Short Description$ and 'Request ID' != $Request ID$ No Requests Match Set to $NULL$ Any Requests Match Use First Matching Set zTmpDupID = $Request ID$ Filter 2 If zTmpDupID != $NULL$ Show Error to prevent save Hope this info helps Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF AFRL/SNOX Sent: Friday, October 13, 2006 8:08 AM To: arslist@ARSLIST.ORG Subject: Duplicate Records ** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil Sully Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Duplicate Records
Title: Duplicate Records ** Yes this works, but ensure you take into consideration that this will query the table with a match to that field, consider the QBE settings, and the total record count for the table. When we do this, we dont use a table query, we use direct sql which is better performance for high row count tables. Select count(*) from view where field = value Then compare the set-fields-returned-value != 0 then error Thanks-n-advance; HDT Platform Incident / Problem Manager Architect Robert Molenda IT OS PA Tel: +1 408 501 6310 Fax: +1 408 501 2410 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Friday, October 13, 2006 6:30 AM To: arslist@ARSLIST.ORG Subject: Re: Duplicate Records Sure ... You can do a simple Set Fields action to set a Display Only temp field as an indicator. A second filter then checks the indicator to see if the value exists. Example Scenario: Regular Remedy form called FormA with only default fields (plus a 15 char display only field called zTmpDupID). You want to make sureusers don't enter a short description twice. Submit version Filter 1 On Submit Action 1: Set fields Read value from FormA Set Fields If: 'Short Description' = $Short Description$ No Requests Match Set to $NULL$ Any Requests Match Use First Matching Set zTmpDupID = $Request ID$ Modifyversion Filter 1 On Modify Action 1: Set fields Read value from FormA Set Fields If: 'Short Description' = $Short Description$ and 'Request ID' != $Request ID$ No Requests Match Set to $NULL$ Any Requests Match Use First Matching Set zTmpDupID = $Request ID$ Filter 2 If zTmpDupID != $NULL$ Show Error to prevent save Hope this info helps Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sullivan, Neil G CTR USAF AFRL/SNOX Sent: Friday, October 13, 2006 8:08 AM To: arslist@ARSLIST.ORG Subject: Duplicate Records ** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil Sully Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARServer 7.0.1 Upgrade Installer
One would think there would have been some type of announcement. I have received confirmation from BMC that this is the maintenance release that is supposed to address the unicode upgrade issues. The problem is that the arupora utility dies due to a segmentation fault and core dumps. I'm working with BMC to resolve this issue, but it's rather slow going at this point. I'm hoping someone else in the community has or will attempt the following and share their experience: Upgrade from ARS 6.0.1 to ARS 7.0.1 App Server: SunOS 5.9 Database: Remote Oracle 9i Oracle Client on App Server: 10.2.0.whatever Db Charset: UTF-8 I am using the following for the LANG and NLS_LANG on the app server: LANG=en_US.UTF-8 NLS_LANG=american_america.AL32UTF8 ar_install calls a binary name arupora that is included with the install files. This program connects to the oracle db directly and gathers/updates a bunch of data. This program generates a segfault before it completes. The script exits with the following text: Running DB upgrade. This may take several minutes Running DB upgrade. /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 21 /* Fri Oct 13 10:03:35 2006 */ Upgrade old field-lengths codeset=0 'windows-1252' errorCode=0 An error was encountered during the upgrade of the ORACLE database ./ar_install: test: argument expected The core file is generated in the target installation directory. While running truss, I see the following output just before it core dumps: time() = 1160672159 lseek(3, 64878, SEEK_SET) = 64878 write(3, / * T h u O c t.., 123) = 123 write(6, \0ED\0\006\0\0\0\0\003 ^.., 237) = 237 read(6, 019B\0\006\0\0\0\0\01019.., 2064) = 411 time() = 1160672159 lseek(3, 65001, SEEK_SET) = 65001 write(3, / * T h u O c t.., 37) = 37 write(6, \015\0\006\0\0\0\0\00305.., 21) = 21 read(6, \0E0\0\006\0\0\0\0\00601.., 2064) = 224 Incurred fault #6, FLTBOUNDS %pc = 0xFE1872FC siginfo: SIGSEGV SEGV_MAPERR addr=0x Received signal #11, SIGSEGV [default] siginfo: SIGSEGV SEGV_MAPERR addr=0x If I attach a debugger to the arupora utility and execute it, I get the following: dbx arupora dbxenv suppress_startup_message 6.2 Reading arupora Reading ld.so.1 Reading libclntsh.so.10.1 Reading libnsl.so.1 Reading libsocket.so.1 Reading libgen.so.1 Reading libdl.so.1 Reading libaio.so.1 Reading librt.so.1 Reading libkstat.so.1 Reading libm.so.1 Reading libthread.so.1 Reading libw.so.1 Reading libc.so.1 Reading libicuucbmc.so.32 Reading libicui18nbmc.so.32 Reading libicudatabmc.so.32 Reading libiostream.so.1 Reading libCstd.so.1 Reading libCrun.so.1 Reading libnnz10.so Reading libsched.so.1 Reading libmp.so.2 Reading libmd5.so.1 Reading libpthread.so.1 Reading libc_psr.so.1 Reading libCstd_isa.so.1 detected a multithreaded program (/opt/SUNWspro/bin/../WS6U2/bin/sparcv9/dbx) run -c /prod/sys/remedyb/conf/ar.conf -d Running: arupora -c /prod/sys/remedyb/conf/ar.conf -d (process id 26336) SQL tracing initiated to file /usr/tmp/arsql.log signal SEGV (no mapping at the fault address) in lmsaicmt at 0xfef9fcec 0xfef9fcec: lmsaicmt+0x007c:lduh[%i5 + 0x24], %o3 The arupora program is generating a file in /var/tmp that is named aaasomegargledchars. This file looks to contain a bunch of updates, stored in xml format, e.g.: ?xml version=1.0 encoding=UTF-8? doc type=DIFF row table=arreference where=WHERE containerId=91 AND referenceId=4 col name=valueShort forceLong=1/ old9\1\282054 ... Axton Grams On 10/13/06, Shellman, David [EMAIL PROTECTED] wrote: Axton, If it's an upgrade and not a patch then this is the one that we were also waiting for. We had gotten an email on the 5th that noted the release was going to be within the next week. I thought that there would have been more of a formal announcement from BMC/Remedy. At least a note on the What's Hot on the Support web site given the Tech Alert: Upgrade to ARS 7.0 Unicode is not yet possible note on the site. Thanks, Dave Date:Thu, 12 Oct 2006 09:56:26 -0400 From:Axton [EMAIL PROTECTED] Subject: Re: ARServer 7.0.1 Upgrade Installer 7.0.1 was released at the beginning of the month. This was not a patch, but an upgrade. I was assuming this was the release that support/engineering keeps referencing every time I've spoken with them in the last few months. Axton Grams Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607
Re: Save Button - ARS 6.3 - HD 6 - Resolved!
** Joe, Thanks for adding the tip about the Change Flag - It helped me with a similar issue. Carolyn -Original Message-From: Joe DeSouza [mailto:[EMAIL PROTECTED]Sent: Thursday, October 12, 2006 01:51 PMTo: arslist@ARSLIST.ORGSubject: Re: Save Button - ARS 6.3 - HD 6 - Resolved!** Claire, You are welcome.. You would need to make sure though if you are going to use this, that none of your fields that the user can type values into directly, have the Change Flag property of the field in that view checked.. else the flag wont be dirtied and the save button would look gray even though the user typed stuff in that field... Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: "Sanford, Claire" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Thursday, October 12, 2006 4:46:26 PMSubject: Re: Save Button - ARS 6.3 - HD 6 - Resolved! Thank you Joe and Tim!ClaireFrom: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Thursday, October 12, 2006 3:35 PMTo: arslist@ARSLIST.ORGSubject: Re: Save Button - ARS 6.3 - HD 6** Claire,Make the Details Pane Banner visible..You will find this on your admin tool when you open up the form underForm - Current View - Properties - AppearanceHope this helpsJoe D'SouzaRemedy Developer / Consultant,Shyle Networks,New Jersey.- Original Message From: "Sanford, Claire" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Thursday, October 12, 2006 3:54:46 PMSubject: Save Button - ARS 6.3 - HD 6** How do I get the "Save" button back on the HPD:HelpDesk, CHG:Change, andCHG:Task forms?My users want the old style Save button rather than the yucky "Save"button at the bottom of the screen.It is there if I create a brandnew form...ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries- Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Keystroke command
Thanks, Eric! Dwayne Original message Date: Fri, 13 Oct 2006 09:49:25 -0400 From: Eric Cleereman (IT) [EMAIL PROTECTED] Subject: Re: Keystroke command To: arslist@ARSLIST.ORG Hi Dwayne, If a menu is attached to a field where the display type is set as Drop-Down List, clicking the field will cause it to open the menu. If a menu is attached to a field where the display type is set as Edit or Edit Masked, clicking the field will set focus to the field without opening the menu. Eric Cleereman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Friday, October 13, 2006 8:14 AM To: arslist@ARSLIST.ORG Subject: OT:Re: Keystroke command I just noticed, in checking this out, that for some fields the menu pops open as soon as you click in the data-space, and for others it doesn't. Any idea why? Dwayne Martin James Madison University Original message Date: Thu, 12 Oct 2006 13:07:14 -0700 From: Thad Esser [EMAIL PROTECTED] Subject: Re: Keystroke command To: arslist@ARSLIST.ORG ** With focus in the field, ALT-up arrow or ALT-down arrow works. Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach CLB RemedyTo arslist@ARSLIST.ORG [EMAIL PROTECTED] cc Sent by: Action Request Subject Keystroke command System discussion list(ARSList) arslist@ARSLIST.ORG 10/12/2006 12:53 PM +-+ | Please respond to | | arslist@ARSLIST.ORG | +-+ ** Can anyone tell me if there is a keystroke command that can be performed to get the drop down boxes instead of clicking on the arrows? Thank you, Stacie Jerden (562) 570-6738 [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___ Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org Dwayne Martin Computing Support James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Crystal Report timeout
** Hey all,We are having an issue with Crystal Reports that are timing out. They use the Remedy ODBC driver to get to the DB.The reporters want to be able to extend the timeout value. There isn't time right now to look at making the reports more efficient. After contacting Remedy, the best I got was to make changes to the AR.ini file which may or may not help.Anyone else fix this problem?Thanks Stephen ARS 7.0 Share your photos with the people who matter at Yahoo! Canada Photos __20060125___This posting was submitted with HTML in it___
Re: Crystal Report timeout
** Stephen: The only method that I know of to fix this is indexing. Sadly, the value used for database retrieval is fixed and is being exceeded. You don't state which database you are using either James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Stephen LuminiSent: Friday, October 13, 2006 9:46 AMTo: arslist@ARSLIST.ORGSubject: Crystal Report timeout ** Hey all, We are having an issue with Crystal Reports that are timing out. They use the Remedy ODBC driver to get to the DB. The reporters want to be able to extend the timeout value. There isn't time right now to look at making the reports more efficient. After contacting Remedy, the best I got was to make changes to the AR.ini file which may or may not help. Anyone else fix this problem? Thanks Stephen ARS 7.0 Share your photos with the people who matter at Yahoo! Canada Photos __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
RESOLVED Re: Crystal Report timeout
** Hey James, Thanks for the quick reply - even if I don't like the answer :-)Later Stephen"McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED] wrote: ** Stephen:The only method that I know of to fix this is indexing. Sadly, the value used for database retrieval is fixed and is being exceeded. You don't state which database you are using eitherJames McKenzie L-3 GSIFrom: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Stephen LuminiSent: Friday, October 13, 2006 9:46 AMTo: arslist@ARSLIST.ORGSubject: Crystal Report timeout ** Hey all,We are having an issue with Crystal Reports that are timing out. They use the Remedy ODBC driver to get to the DB.The reporters want to be able to extend the timeout value. There isn't time right now to look at making the reports more efficient. After contacting Remedy, the best I got was to make changes to the AR.ini file which may or may not help.Anyone else fix this problem?Thanks Stephen ARS 7.0 Share your photos with the people who matter at Yahoo! Canada Photos __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ Share your photos with the people who matter at Yahoo! Canada Photos __20060125___This posting was submitted with HTML in it___
Group Population List
** Happy Friday the 13th!!! Has anybody figured out a simple way to grab the population of groups? I want to only query a batch of groups and get the agents therein. Would really prefer not to have to go through the computed group list and hunt down each user. Any ideas? Thank You, Chris Doble Mobile:949-533-5346 Email:[EMAIL PROTECTED] Web: http://www.aisconsulting.net __20060125___This posting was submitted with HTML in it___
License Write Token Message
** Has anyone seen this before? We have plenty of licenses and have never exceeded the number we have. Not sure why he would get this message. From: Holgate, Jason Sent: Friday, October 13, 2006 12:44 PMTo: Sokol, BrianSubject: Remedy Error that I get every now and then over the past few weeks Good Afternoon Brian... At times when I go to create a new remedy ticket, I'll get this popup below.. I hit OK and I'm able to continue using Remedy without any problems. Just wanted to make you aware of this issue in case this is something you know a fix for. I currently have Remedy 7.00 installed. Thanks! Jason HolgateSenior Tech AnalystScholastic Book Fairs1080 Greenwood Blvd.Lake Mary, FL 32746(800) 874-4809 x8293 (Toll Free)(407) 829-8293 (Local) - (407) 805-9486 (Fax)[EMAIL PROTECTED] - E-mailScholastic Book Fairs Connects Kids to the Books They Want to Read.http://www.scholastic.com/bookfairs __20060125___This posting was submitted with HTML in it___
Re: License Write Token Message
Title: RE: License Write Token Message ** Brian: This is normal when the user was in read-only mode and shifted to write mode. However, I would look at how your licenses are actually used. James Mckenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sokol, Brian Sent: Friday, October 13, 2006 10:38 AM To: arslist@ARSLIST.ORG Subject: License Write Token Message ** Has anyone seen this before? We have plenty of licenses and have never exceeded the number we have. Not sure why he would get this message. From: Sent: Friday, October 13, 2006 12:44 PM To: Subject: Remedy Error that I get every now and then over the past few weeks Good Afternoon Brian... At times when I go to create a new remedy ticket, I'll get this popup below.. I hit OK and I'm able to continue using Remedy without any problems. Just wanted to make you aware of this issue in case this is something you know a fix for. I currently have Remedy 7.00 installed. Thanks! Jason Holgate __20060125___This posting was submitted with HTML in it___
Re: Group Population List
** Take a look to SHR:Assignment for non-permission groups. Thanks-n-advance; HDT Platform Incident / Problem Manager Architect Robert Molenda IT OS PA Tel: +1 408 501 6310 Fax: +1 408 501 2410 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Doble Sent: Friday, October 13, 2006 10:02 AM To: arslist@ARSLIST.ORG Subject: Group Population List Happy Friday the 13th!!! Has anybody figured out a simple way to grab the population of groups? I want to only query a batch of groups and get the agents therein. Would really prefer not to have to go through the computed group list and hunt down each user. Any ideas? Thank You, Chris Doble Mobile:949-533-5346 Email:[EMAIL PROTECTED] Web: http://www.aisconsulting.net __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Save Button - ARS 6.3 - HD 6 - Resolved!
** No problem... Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: Wixson Carolyn L PSNS [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Friday, October 13, 2006 11:58:02 AMSubject: Re: Save Button - ARS 6.3 - HD 6 - Resolved!** Joe, Thanks for adding the tip about the Change Flag - It helped me with a similar issue. Carolyn -Original Message-From: Joe DeSouza [mailto:[EMAIL PROTECTED]Sent: Thursday, October 12, 2006 01:51 PMTo: arslist@ARSLIST.ORGSubject: Re: Save Button - ARS 6.3 - HD 6 - Resolved!** Claire, You are welcome.. You would need to make sure though if you are going to use this, that none of your fields that the user can type values into directly, have the Change Flag property of the field in that view checked.. else the flag wont be dirtied and the save button would look gray even though the user typed stuff in that field... Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: "Sanford, Claire" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Thursday, October 12, 2006 4:46:26 PMSubject: Re: Save Button - ARS 6.3 - HD 6 - Resolved! Thank you Joe and Tim!ClaireFrom: Action Request System discussion list(ARSList)[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Thursday, October 12, 2006 3:35 PMTo: arslist@ARSLIST.ORGSubject: Re: Save Button - ARS 6.3 - HD 6** Claire,Make the Details Pane Banner visible..You will find this on your admin tool when you open up the form underForm - Current View - Properties - AppearanceHope this helpsJoe D'SouzaRemedy Developer / Consultant,Shyle Networks,New Jersey.- Original Message From: "Sanford, Claire" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Thursday, October 12, 2006 3:54:46 PMSubject: Save Button - ARS 6.3 - HD 6** How do I get the "Save" button back on the HPD:HelpDesk, CHG:Change, andCHG:Task forms?My users want the old style Save button rather than the yucky "Save"button at the bottom of the screen.It is there if I create a brandnew form...ARS 6.3 Patch 18 HD 6.0 Oracle 10 w/9 libraries- Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server __20060125___This posting was submitted with HTML in it___
Helpdesk 6.0 Support Panel displaying groups I am not a member of.
All, I am using ITSM 6.0 Helpdesk. We have created a lot of groups in the system that are very similar. The Remedy Support Panel is now displaying groups that individuals are not a member of due to the LIKE statements. (This happens when I select the Console View: Group) My question is, is their a way to change the qualification so that we don't have to change all of the group names? The qualification is: ((( 'zTmpKeyword' = MAINHELPDESK ) AND ( 'Status Integer' 4)) OR (( 'zTmpKeyword' = MAINCHANGE ) AND ( 'Status Integer' 6)) OR (( 'zTmpKeyword' = MAINTASK ) AND ( 'Status Integer' 4))) AND (( $zTmpShowAssignedReq$ = 'zTmpKeyword') OR ( $zTmpShowAssignedReq$ = All )) AND ((( $ConsoleViewBy$ = Myself) AND ( 'Assigned To' = $USER$)) OR (( $ConsoleViewBy$ = Group) AND ( 'Assigned To Group+' != $NULL$ ) AND ($GROUPS$ LIKE (( % + 'Assigned To Group+') + % ))) OR (( $ConsoleViewBy$ = Group Unassigned) AND ( 'Assigned To' = $NULL$ )) OR (( $ConsoleViewBy$ = Date) AND ( 'Requested Completion Date' = $zTmpDate1$)) OR ( $ConsoleViewBy$ = Any)) Thanks in advance and thank you all for your support in the past. Regards, Jackson Oracle 9 Solaris ARS 6.3 _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www.get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
I tracked the issue down to the data in the filter_sql table. When arupora is running, it logs to a file name /var/tmp/arsql.log. By viewing this file I could see what the last select was and concluded that the data returned by that select statement was causing the segfault. I removed all the data from filter_sql (15 records) and the installer completed successfully. Hope this helps someone. Axton Grams On 10/13/06, Axton [EMAIL PROTECTED] wrote: One would think there would have been some type of announcement. I have received confirmation from BMC that this is the maintenance release that is supposed to address the unicode upgrade issues. The problem is that the arupora utility dies due to a segmentation fault and core dumps. I'm working with BMC to resolve this issue, but it's rather slow going at this point. I'm hoping someone else in the community has or will attempt the following and share their experience: Upgrade from ARS 6.0.1 to ARS 7.0.1 App Server: SunOS 5.9 Database: Remote Oracle 9i Oracle Client on App Server: 10.2.0.whatever Db Charset: UTF-8 I am using the following for the LANG and NLS_LANG on the app server: LANG=en_US.UTF-8 NLS_LANG=american_america.AL32UTF8 ar_install calls a binary name arupora that is included with the install files. This program connects to the oracle db directly and gathers/updates a bunch of data. This program generates a segfault before it completes. The script exits with the following text: Running DB upgrade. This may take several minutes Running DB upgrade. /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 21 /* Fri Oct 13 10:03:35 2006 */ Upgrade old field-lengths codeset=0 'windows-1252' errorCode=0 An error was encountered during the upgrade of the ORACLE database ./ar_install: test: argument expected The core file is generated in the target installation directory. While running truss, I see the following output just before it core dumps: time() = 1160672159 lseek(3, 64878, SEEK_SET) = 64878 write(3, / * T h u O c t.., 123) = 123 write(6, \0ED\0\006\0\0\0\0\003 ^.., 237) = 237 read(6, 019B\0\006\0\0\0\0\01019.., 2064) = 411 time() = 1160672159 lseek(3, 65001, SEEK_SET) = 65001 write(3, / * T h u O c t.., 37) = 37 write(6, \015\0\006\0\0\0\0\00305.., 21) = 21 read(6, \0E0\0\006\0\0\0\0\00601.., 2064) = 224 Incurred fault #6, FLTBOUNDS %pc = 0xFE1872FC siginfo: SIGSEGV SEGV_MAPERR addr=0x Received signal #11, SIGSEGV [default] siginfo: SIGSEGV SEGV_MAPERR addr=0x If I attach a debugger to the arupora utility and execute it, I get the following: dbx arupora dbxenv suppress_startup_message 6.2 Reading arupora Reading ld.so.1 Reading libclntsh.so.10.1 Reading libnsl.so.1 Reading libsocket.so.1 Reading libgen.so.1 Reading libdl.so.1 Reading libaio.so.1 Reading librt.so.1 Reading libkstat.so.1 Reading libm.so.1 Reading libthread.so.1 Reading libw.so.1 Reading libc.so.1 Reading libicuucbmc.so.32 Reading libicui18nbmc.so.32 Reading libicudatabmc.so.32 Reading libiostream.so.1 Reading libCstd.so.1 Reading libCrun.so.1 Reading libnnz10.so Reading libsched.so.1 Reading libmp.so.2 Reading libmd5.so.1 Reading libpthread.so.1 Reading libc_psr.so.1 Reading libCstd_isa.so.1 detected a multithreaded program (/opt/SUNWspro/bin/../WS6U2/bin/sparcv9/dbx) run -c /prod/sys/remedyb/conf/ar.conf -d Running: arupora -c /prod/sys/remedyb/conf/ar.conf -d (process id 26336) SQL tracing initiated to file /usr/tmp/arsql.log signal SEGV (no mapping at the fault address) in lmsaicmt at 0xfef9fcec 0xfef9fcec: lmsaicmt+0x007c:lduh[%i5 + 0x24], %o3 The arupora program is generating a file in /var/tmp that is named aaasomegargledchars. This file looks to contain a bunch of updates, stored in xml format, e.g.: ?xml version=1.0 encoding=UTF-8? doc type=DIFF row table=arreference where=WHERE containerId=91 AND referenceId=4 col name=valueShort forceLong=1/ old9\1\282054 ... Axton Grams On 10/13/06, Shellman, David [EMAIL PROTECTED] wrote: Axton, If it's an upgrade and not a patch then this is the one that we were also waiting for. We had gotten an email on the 5th that noted the release was going to be within the next week. I thought that there would have been more of a formal announcement from BMC/Remedy. At least a note on the What's Hot on the Support web site given the Tech Alert: Upgrade to ARS 7.0 Unicode is not yet possible note on the site. Thanks, Dave Date:Thu, 12 Oct 2006 09:56:26 -0400 From:Axton [EMAIL PROTECTED] Subject: Re: ARServer 7.0.1 Upgrade Installer 7.0.1 was
Re: Duplicate Records
** Yes, Scan through the table for conditions that will cause a record to be duplicate butmake an exceptionto skip records thathave a NULL value in that field. Then if it finds any match, return the Entry-IDof that record to a temporary field. If at the end of the search the Temp field is NULL, you know you haven't found a duplicate. If its not NULL return the duplicate record error you want to return and prevent the save of that record.. Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: "Sullivan, Neil G CTR USAF AFRL/SNOX" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Friday, October 13, 2006 9:07:56 AMSubject: Duplicate Records** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil "Sully" Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788 __20060125___This posting was submitted with HTML in it___
Re: Duplicate Records
** Joe: If the entry is NULL, then the results should be NULL. You are right. I think this is another one that deserves the 'field' != $NULL$ treatment. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Friday, October 13, 2006 11:09 AMTo: arslist@ARSLIST.ORGSubject: Re: Duplicate Records ** Yes, Scan through the table for conditions that will cause a record to be duplicate butmake an exceptionto skip records thathave a NULL value in that field. Then if it finds any match, return the Entry-IDof that record to a temporary field. If at the end of the search the Temp field is NULL, you know you haven't found a duplicate. If its not NULL return the duplicate record error you want to return and prevent the save of that record.. Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. - Original Message From: "Sullivan, Neil G CTR USAF AFRL/SNOX" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Friday, October 13, 2006 9:07:56 AMSubject: Duplicate Records** Listers, Is there any way possible to use workflow to check for duplicate records in a form without using a unique index? I can't use an index because some of the values in the field will be null. Any help is appreciated. Neil "Sully" Sullivan Remedy Developer/Administrator AFRL/SNOX Wright Patterson AFB, OH 45433 937-904-9788__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Crystal Report timeout
** One thing you might look at would be putting the ODBC users on their RPC thread. I know this won't help with timeouts (maybe if it is Remedy timing out) but at least those users won't be tying up database threads that are being utilized by end users within the application. On 10/13/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Stephen: The only method that I know of to fix this is indexing. Sadly, the value used for database retrieval is fixed and is being exceeded. You don't state which database you are using either James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stephen LuminiSent: Friday, October 13, 2006 9:46 AMTo: arslist@ARSLIST.ORGSubject: Crystal Report timeout ** Hey all, We are having an issue with Crystal Reports that are timing out. They use the Remedy ODBC driver to get to the DB. The reporters want to be able to extend the timeout value. There isn't time right now to look at making the reports more efficient. After contacting Remedy, the best I got was to make changes to the AR.ini file which may or may not help. Anyone else fix this problem? Thanks Stephen ARS 7.0 Share your photos with the people who matter at Yahoo! Canada Photos __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ -- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Group Population List
** Hi Chris, I created a join form between the Group and User forms. Before I could create the join, this required adding a field to the Group form to store the string equivalent of the group ID integer, and some additional workflow to populate the character field. There is a thread in the archives titled "Displaying users groups" from April 2006 that describes the method I used to accomplish this in more detail. HTH, Thomas - Original Message - From: Chris Doble Newsgroups: gmane.comp.crm.arsystem.general Sent: Friday, October 13, 2006 12:01 Subject: Group Population List ** Happy Friday the 13th!!! Has anybody figured out a simple way to grab the population of groups? I want to only query a batch of groups and get the agents therein. Would really prefer not to have to go through the computed group list and hunt down each user . Any ideas? Thank You, Chris Doble Mobile:949-533-5346 Email:[EMAIL PROTECTED] Web: http://www.aisconsulting.net __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Helpdesk 6.0 Support Panel displaying groups I am not a member of.
Hi Jackson, We had a similar problem. Here's one approach to take care of it: - Create a hidden field called AssignedToGroupID on form(s) containing the records. - Create workflow to populate this field for any future records. - Populate this field for existing records via SQL, an escalation, whatever works best for you. - Create a hidden temp field on the form containing the table, called zTmpGroupIDs. - Populate this field using an SQL query against USER_X (the User form). The groups for a given user are stored as Group IDs at the database level, in the following format: ID1;ID2;ID3;etc; - Change your qualification to: ( (('zTmpKeyword'=MAINHELPDESK) AND ('Status Integer'4)) OR (('zTmpKeyword'=MAINCHANGE) AND ('Status Integer'6)) OR (('zTmpKeyword'=MAINTASK) AND ('Status Integer'4)) ) AND (($zTmpShowAssignedReq$='zTmpKeyword') OR ($zTmpShowAssignedReq$=All)) AND ( (($ConsoleViewBy$=Myself) AND ('Assigned To'=$USER$)) OR (($ConsoleViewBy$=Group) AND ( ('AssignedToGroupID'=$NULL$) OR ($zTmpGroupIDs$ LIKE (+'AssignedToGroupID'+;%)) OR ($zTmpGroupIDs$ LIKE (%;+'AssignedToGroupID'+;%)) ) OR (($ConsoleViewBy$=Group Unassigned) AND ('Assigned To'=$NULL$)) OR (($ConsoleViewBy$=Date) AND ('Requested Completion Date'=$zTmpDate1$)) OR ($ConsoleViewBy$ = Any) ) This takes advantage of the group IDs always having a semicolon after them. So while 1000 would be like 100%, 1000; would not be like 100%; Eric Cleereman -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jack Samson Sent: Friday, October 13, 2006 2:05 PM To: arslist@ARSLIST.ORG Subject: Helpdesk 6.0 Support Panel displaying groups I am not a member of. All, I am using ITSM 6.0 Helpdesk. We have created a lot of groups in the system that are very similar. The Remedy Support Panel is now displaying groups that individuals are not a member of due to the LIKE statements. (This happens when I select the Console View: Group) My question is, is their a way to change the qualification so that we don't have to change all of the group names? The qualification is: ((( 'zTmpKeyword' = MAINHELPDESK ) AND ( 'Status Integer' 4)) OR (( 'zTmpKeyword' = MAINCHANGE ) AND ( 'Status Integer' 6)) OR (( 'zTmpKeyword' = MAINTASK ) AND ( 'Status Integer' 4))) AND (( $zTmpShowAssignedReq$ = 'zTmpKeyword') OR ( $zTmpShowAssignedReq$ = All )) AND ((( $ConsoleViewBy$ = Myself) AND ( 'Assigned To' = $USER$)) OR (( $ConsoleViewBy$ = Group) AND ( 'Assigned To Group+' != $NULL$ ) AND ($GROUPS$ LIKE (( % + 'Assigned To Group+') + % ))) OR (( $ConsoleViewBy$ = Group Unassigned) AND ( 'Assigned To' = $NULL$ )) OR (( $ConsoleViewBy$ = Date) AND ( 'Requested Completion Date' = $zTmpDate1$)) OR ( $ConsoleViewBy$ = Any)) Thanks in advance and thank you all for your support in the past. Regards, Jackson Oracle 9 Solaris ARS 6.3 _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http://www.get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ServiceDesk 7.0 test data
Howard, I think you are looking for the SYS:Notification Messages form to find and modify the text of the automated messages. HTH, Brian Baker Software Engineer Cisco Remote Operations Services From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richter, Howard Sent: Friday, October 13, 2006 1:05 PM To: arslist@ARSLIST.ORG Subject: ServiceDesk 7.0 test data ** Happy Friday to all, As I start to play with ServiceDesk, I am starting to find that even by reading the manual I can find things. Like what form (if it is a form) controls the out going e-mail messages that are trigged after a new incident is opened, Anyone have any ideas what form might hold this data? Also have a great weekend, hbr Howard Richter Remedy ServiceDesk Manager CedarCrestone Managed Services Center [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Picture (Metafile) __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
SOLVED: Group Population List
** I did basically what you described working quite well. TY Thank You, Chris Doble Mobile:949-533-5346 Email:[EMAIL PROTECTED] Web: http://www.aisconsulting.net From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean Sent: Friday, October 13, 2006 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Group Population List Hi Chris, I created a join form between the Group and User forms. Before I could create the join, this required adding a field to the Group form to store the string equivalent of the group ID integer, and some additional workflow to populate the character field. There is a thread in the archives titled Displaying users groups from April 2006 that describes the method I used to accomplish this in more detail. HTH, Thomas - Original Message - From: Chris Doble Newsgroups: gmane.comp.crm.arsystem.general Sent: Friday, October 13, 2006 12:01 Subject: Group Population List ** Happy Friday the 13th!!! Has anybody figured out a simple way to grab the population of groups? I want to only query a batch of groups and get the agents therein. Would really prefer not to have to go through the computed group list and hunt down each user. Any ideas? Thank You, Chris Doble Mobile:949-533-5346 Email:[EMAIL PROTECTED] Web: http://www.aisconsulting.net __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: License Write Token Message (U)
** Yes he has a floating license. I believe that you are not given a write token till it is actually needed but we have never gotten this pop up message before. Is there a way to suppress it? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Melissa J CTR OSD-CIOSent: Friday, October 13, 2006 1:42 PMTo: arslist@ARSLIST.ORGSubject: Re: License Write Token Message (U) ** UNCLASSIFIED Looks like the user has a floating license assigned instead of a fixed. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, BrianSent: Friday, October 13, 2006 1:38 PMTo: arslist@ARSLIST.ORGSubject: License Write Token Message ** Has anyone seen this before? We have plenty of licenses and have never exceeded the number we have. Not sure why he would get this message. From: Holgate, Jason Sent: Friday, October 13, 2006 12:44 PMTo: Sokol, BrianSubject: Remedy Error that I get every now and then over the past few weeks Good Afternoon Brian... At times when I go to create a new remedy ticket, I'll get this popup below.. I hit OK and I'm able to continue using Remedy without any problems. Just wanted to make you aware of this issue in case this is something you know a fix for. I currently have Remedy 7.00 installed. Thanks! Jason HolgateSenior Tech AnalystScholastic Book Fairs1080 Greenwood Blvd.Lake Mary, FL 32746(800) 874-4809 x8293 (Toll Free)(407) 829-8293 (Local) - (407) 805-9486 (Fax)[EMAIL PROTECTED] - E-mailScholastic Book Fairs Connects Kids to the Books They Want to Read.http://www.scholastic.com/bookfairs __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: License Write Token Message (U)
Title: RE: License Write Token Message (U) ** Brian: You can suppress the message. However, you should also look into the usage of your Float licenses. This message only appears if an action that would use a Write token had occurred and none were available. By examining who and what is being done and the relationship to the use of float licenses, you can be proactive. It is not nice to get a call from an aggravated manager James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sokol, Brian Sent: Friday, October 13, 2006 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: License Write Token Message (U) ** Yes he has a floating license. I believe that you are not given a write token till it is actually needed but we have never gotten this pop up message before. Is there a way to suppress it? __20060125___This posting was submitted with HTML in it___
Crystal Reports developer - Tampa area
'Just spoke with my manager. We're looking for a Crystal Reports developer, preferably with some ARS experience. I'm not sure if it'll start as a contracted position, but the objective is to hire a full time employee. I'm our senior Remedy developer/administrator, but have no Crystal Reports experience. We haven't integrated Crystal Reports with our ARS applications, and would look to our new hire to help pursue this. My manager is working with HR on the job posting. I wanted to check with you guys in the meantime so I can help steer it if there's any interest. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Helpdesk 6.0 Support Panel displaying groups I am not a member of.
We worked through this same issue recently with tech support and the bottom line answer was no. We tried a lot of different variations on the query even though BMC said it couldn't be done and eventually I had to admit that I couldn't prove them wrong. Fortunately, we only had 3 group names we had to change. You just have to make sure that no complete group name is a part of any other group name. For example, we couldn't have both 'Production Support' and 'IDX Production Support' because the complete name of one is part of the other. Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jack Samson Sent: Friday, October 13, 2006 11:05 AM To: arslist@ARSLIST.ORG Subject: Helpdesk 6.0 Support Panel displaying groups I am not a member of. All, I am using ITSM 6.0 Helpdesk. We have created a lot of groups in the system that are very similar. The Remedy Support Panel is now displaying groups that individuals are not a member of due to the LIKE statements. (This happens when I select the Console View: Group) My question is, is their a way to change the qualification so that we don't have to change all of the group names? The qualification is: ((( 'zTmpKeyword' = MAINHELPDESK ) AND ( 'Status Integer' 4)) OR (( 'zTmpKeyword' = MAINCHANGE ) AND ( 'Status Integer' 6)) OR (( 'zTmpKeyword' = MAINTASK ) AND ( 'Status Integer' 4))) AND (( $zTmpShowAssignedReq$ = 'zTmpKeyword') OR ( $zTmpShowAssignedReq$ = All )) AND ((( $ConsoleViewBy$ = Myself) AND ( 'Assigned To' = $USER$)) OR (( $ConsoleViewBy$ = Group) AND ( 'Assigned To Group+' != $NULL$ ) AND ($GROUPS$ LIKE (( % + 'Assigned To Group+') + % ))) OR (( $ConsoleViewBy$ = Group Unassigned) AND ( 'Assigned To' = $NULL$ )) OR (( $ConsoleViewBy$ = Date) AND ( 'Requested Completion Date' = $zTmpDate1$)) OR ( $ConsoleViewBy$ = Any)) Thanks in advance and thank you all for your support in the past. Regards, Jackson Oracle 9 Solaris ARS 6.3 _ Share your special moments by uploading 500 photos per month to Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp007001msn/direct/01/?href=http:/ /www.get.live.com/spaces/features ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org MMS firsthealth.com made the following annotations. -- This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message. == ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: License Write Token Message (U)
Title: RE: License Write Token Message (U) ** Hi James, I would agree except I have Server Statistics turned on and gathering info every 20 minutes. The highest my floating license count has gotten is 26. We have 33 floating licenses. The server stats also show 0 float license token denied. That is why I am confused??? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Friday, October 13, 2006 3:29 PMTo: arslist@ARSLIST.ORGSubject: Re: License Write Token Message (U) ** Brian: You can suppress the message. However, you should also look into the usage of your Float licenses. This message only appears if an action that would use a Write token had occurred and none were available. By examining who and what is being done and the relationship to the use of float licenses, you can be proactive. It is not nice to get a call from an aggravated manager James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sokol, Brian Sent: Friday, October 13, 2006 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: License Write Token Message (U) ** Yes he has a floating license. I believe that you are not given a write token till it is actually needed but we have never gotten this pop up message before. Is there a way to suppress it?__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
OT: Try this out...
** I'm almost positive I know the 'real reason' to this, a friend of mine who is not really from an IT background sent me a mail saying that even engineers at Microsoft do not know the answer to this (which I find hard to believe). Reason being after he sent me that mailI immediatly guessed the reason behind this, and I am willing to bet I am right about it.. Wanted to see if anyone here can figure it out... Try this out.. Try creating a directoryor a file (with no extension)named con and it wont let you.. while creating a directoryusing the GUI it simply wont let you create it(no error displayed)but if you try using DOS it will return an error -invalid name.. Similary if you create a file and try to name it con, it says this name is 'reserved for a device'.. Personally I donot think this is reserved for a device as such. It is reserved for 'something else'.At least thats my guess... Does anyone know why you cantname a file or directory namedcon? I have a good guess and am willing to bet I'm right... Just want to compare my guess to that of others around here... Write to me off list... Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. __20060125___This posting was submitted with HTML in it___
Re: AR System AREA LDAP with multiple forests
I know that the v7 functionality makes this a snap. In v6.3, and likely in v6, look in the manual for AREA Authentication Chaining. -Brian -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dolores McGuinness Sent: Wednesday, October 11, 2006 6:10 AM To: arslist@ARSLIST.ORG Subject: AR System AREA LDAP with multiple forests We are attempting to implement AREA LDAP so that it can authenticate to multiple forests, that each have multiple domains. We can get to the domains within the first forest, but cannot get to the second forest, when a match is not found in the first forest. We are using Remedy 6.03 patch 11, Solaris, Unix and Oracle. Has anyone been successful at implementing AREA LDAP with Multiple Forests? ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: License Write Token Message (U)
Title: RE: License Write Token Message (U) ** Brian: The message you refer to is one that is sent when there were no tokens available when a user logged on and then was given one later. That is why I'm confused I would suggest looking into the use of rrrLicense as it will tell you if and when you ran out of Float Write tokens (licenses). James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sokol, Brian Sent: Friday, October 13, 2006 1:03 PM To: arslist@ARSLIST.ORG Subject: Re: License Write Token Message (U) ** Hi James, I would agree except I have Server Statistics turned on and gathering info every 20 minutes. The highest my floating license count has gotten is 26. We have 33 floating licenses. The server stats also show 0 float license token denied. That is why I am confused??? __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out...
** Isn't con the output stream for the console in DOS. Similar to stdout in *nix? From a DOS prompt: echo xxx con puts xxx on the screen anyway. Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach Joe DeSouza [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/13/2006 01:15 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject OT: Try this out... ** I'm almost positive I know the 'real reason' to this, a friend of mine who is not really from an IT background sent me a mail saying that even engineers at Microsoft do not know the answer to this (which I find hard to believe). Reason being after he sent me that mail I immediatly guessed the reason behind this, and I am willing to bet I am right about it.. Wanted to see if anyone here can figure it out... Try this out.. Try creating a directory or a file (with no extension) named con and it wont let you.. while creating a directory using the GUI it simply wont let you create it (no error displayed) but if you try using DOS it will return an error - invalid name.. Similary if you create a file and try to name it con, it says this name is 'reserved for a device'.. Personally I do not think this is reserved for a device as such. It is reserved for 'something else'. At least thats my guess... Does anyone know why you cant name a file or directory named con? I have a good guess and am willing to bet I'm right... Just want to compare my guess to that of others around here... Write to me off list... Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out...
** http://mjsabby.com/2005/10/windows-xp-con-folderfile-bug.php http://whoelsebutdalieu.wordpress.com/2006/08/23/microsoft-is-just-funny-like-that/ It's because of the old days of DOS. CON is for the console (screen), PRN for printer, NUL basically means NULL or nothing. Try typing in DIR PRN into a command window. The directory listing will print. DIR NUL will not show anything. (In the old days programmers would run commands and have the output go to NUL so that they ran "transparently.") Looks like con, prn, nul can not be used. Now for the real reason: http://www.microsoft.com/technet/security/bulletin/fq00-017.mspx What's this bulletin about?Microsoft Security Bulletin MS00-017 announces the availability of a patch that eliminates a vulnerability in Microsoft Windows 95, Windows 98, and Windows 98 Second Edition. Under certain circumstances, the vulnerability could cause affected systems to crash. Microsoft is committed to protecting customers' information, and is providing the bulletin to inform customers of the vulnerability and what they can do about it. What causes the vulnerability?The vulnerability results because of a flaw in the way Windows 95 and 98 (including Windows 98 Second Edition) parse file path names. Device names such as COM1, CON or LPT1 are reserved words, and they can't be used as folder or file names. When parsing a reference to a path, Windows 95 and 98 check for the presence of a single DOS device name in the path. If one is found, the path is correctly treated as invalid and an error is returned. However, neither Windows 95 nor 98 check for multiple DOS device names. This is the source of the vulnerability. If a read or write operation is attempted to a path whose name contains multiple DOS device names, it will cause Windows 95 and 98 to attempt to access invalid resources. In some cases, the effect of this invalid access would be to cause the application that supplied the path to hang, but the more likely effect is that the machine would present a blue debug screen and crash. Axton Grams On 10/13/06, Thad Esser [EMAIL PROTECTED] wrote: ** Isn't con the output stream for the console in DOS. Similar to stdout in *nix? From a DOS prompt: echo xxx con puts xxx on the screen anyway. ThadArgue for your limitations, and sure enough, they're yours.-- Richard Bach Joe DeSouza [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/13/2006 01:15 PM Please respond toarslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject OT: Try this out... ** I'm almost positive I know the 'real reason' to this, a friend of mine who is not really from an IT background sent me a mail saying that even engineers at Microsoft do not know the answer to this (which I find hard to believe). Reason being after he sent me that mail I immediatly guessed the reason behind this, and I am willing to bet I am right about it.. Wanted to see if anyone here can figure it out... Try this out.. Try creating a directory or a file (with no extension) named con and it wont let you.. while creating a directory using the GUI it simply wont let you create it (no error displayed) but if you try using DOS it will return an error - invalid name.. Similary if you create a file and try to name it con, it says this name is 'reserved for a device'.. Personally I do not think this is reserved for a device as such. It is reserved for 'something else'. At least thats my guess... Does anyone know why you cant name a file or directory named con? I have a good guess and am willing to bet I'm right... Just want to compare my guess to that of others around here... Write to me off list... Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
64bit OS Install Issue
** Has anyone had any issues installing CMDB or any other ITSM application onto a Windows Server 2003 R2 64-bit OS?-- Alan AbramsRemedy ConsultantXinify Technologies __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out...
** A little different from what I thought the reason was... Interesting links though... Joe. - Original Message From: Axton [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Friday, October 13, 2006 4:33:19 PMSubject: Re: OT: Try this out...** http://mjsabby.com/2005/10/windows-xp-con-folderfile-bug.php http://whoelsebutdalieu.wordpress.com/2006/08/23/microsoft-is-just-funny-like-that/ It's because of the old days of DOS. CON is for the console (screen), PRN for printer, NUL basically means NULL or nothing. Try typing in DIR PRN into a command window. The directory listing will print. DIR NUL will not show anything. (In the old days programmers would run commands and have the output go to NUL so that they ran "transparently.") Looks like con, prn, nul can not be used. Now for the real reason: http://www.microsoft.com/technet/security/bulletin/fq00-017.mspx What's this bulletin about?Microsoft Security Bulletin MS00-017 announces the availability of a patch that eliminates a vulnerability in Microsoft® Windows® 95, Windows 98, and Windows 98 Second Edition. Under certain circumstances, the vulnerability could cause affected systems to crash. Microsoft is committed to protecting customers' information, and is providing the bulletin to inform customers of the vulnerability and what they can do about it. What causes the vulnerability?The vulnerability results because of a flaw in the way Windows 95 and 98 (including Windows 98 Second Edition) parse file path names. Device names such as COM1, CON or LPT1 are reserved words, and they can't be used as folder or file names. When parsing a reference to a path, Windows 95 and 98 check for the presence of a single DOS device name in the path. If one is found, the path is correctly treated as invalid and an error is returned. However, neither Windows 95 nor 98 check for multiple DOS device names. This is the source of the vulnerability. If a read or write operation is attempted to a path whose name contains multiple DOS device names, it will cause Windows 95 and 98 to attempt to access invalid resources. In some cases, the effect of this invalid access would be to cause the application that supplied the path to hang, but the more likely effect is that the machine would present a blue debug screen and crash. Axton Grams On 10/13/06, Thad Esser [EMAIL PROTECTED] wrote: ** Isn't con the output stream for the "con"sole in DOS. Similar to stdout in *nix? From a DOS prompt: echo xxx con puts xxx on the screen anyway. Thad"Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Joe DeSouza" [EMAIL PROTECTED] Sent by: "Action Request System discussion list(ARSList)" arslist@ARSLIST.ORG 10/13/2006 01:15 PM Please respond toarslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject OT: Try this out... ** I'm almost positive I know the 'real reason' to this, a friend of mine who is not really from an IT background sent me a mail saying that even engineers at Microsoft do not know the answer to this (which I find hard to believe). Reason being after he sent me that mail I immediatly guessed the reason behind this, and I am willing to bet I am right about it.. Wanted to see if anyone here can figure it out... Try this out.. Try creating a directory or a file (with no extension) named con and it wont let you.. while creating a directory using the GUI it simply wont let you create it (no error displayed) but if you try using DOS it will return an error - invalid name.. Similary if you create a file and try to name it con, it says this name is 'reserved for a device'.. Personally I do not think this is reserved for a device as such. It is reserved for 'something else'. At least thats my guess... Does anyone know why you cant name a file or directory named con? I have a good guess and am willing to bet I'm right... Just want to compare my guess to that of others around here... Write to me off list... CheersJoe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out... Null ADM:Friday Humour
** I once worked with an organization that accidentally instead of sending all email that had no valid recipient to NUL, they sent it to Null. As it turned out, there was a very upset Nancy Null trying to figure out where all this spam email was coming from. . Daniel -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of AxtonSent: October 13, 2006 16:33To: arslist@ARSLIST.ORGSubject: Re: OT: Try this out...** http://mjsabby.com/2005/10/windows-xp-con-folderfile-bug.php http://whoelsebutdalieu.wordpress.com/2006/08/23/microsoft-is-just-funny-like-that/ It's because of the old days of DOS. CON is for the console (screen), PRN for printer, NUL basically means NULL or nothing. Try typing in DIR PRN into a command window. The directory listing will print. DIR NUL will not show anything. (In the old days programmers would run commands and have the output go to NUL so that they ran "transparently.") Looks like con, prn, nul can not be used. __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out... Null ADM:Friday Humour
Title: RE: OT: Try this out... Null ADM:Friday Humour ** Daniel: That must have been fun to troubleshoot. BTW, where is our usual Friday Humor? I know it was not MY turn to provide it. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 13, 2006 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Try this out... Null ADM:Friday Humour ** I once worked with an organization that accidentally instead of sending all email that had no valid recipient to NUL, they sent it to Null. As it turned out, there was a very upset Nancy Null trying to figure out where all this spam email was coming from. . Daniel __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out... Friday Humour
** I just got this one this morning: -- How Smart Is Your Right Foot? This is so funny that it will boggle your mind. And you will keep trying it at least 50 more times to see if you can outsmart your foot. But you can't. 1. While sitting at your desk, lift your right foot off the floor and make clockwise circles with it. 2. Now, while doing this, draw the number 6 in the air with your right hand. Your foot will change directions. I told you so...And there is nothing you can do about it. Make sure you pass this on to your friends. They won't be able to do it either. -- Thad Argue for your limitations, and sure enough, they're yours.-- Richard Bach McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/13/2006 02:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: OT: Try this out... Null ADM:Friday Humour ** Daniel: That must have been fun to troubleshoot. BTW, where is our usual Friday Humor? I know it was not MY turn to provide it. James McKenzie From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 13, 2006 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Try this out... Null ADM:Friday Humour ** I once worked with an organization that accidentally instead of sending all email that had no valid recipient to NUL, they sent it to Null. As it turned out, there was a very upset Nancy Null trying to figure out where all this spam email was coming from. . Daniel __20060125___This posting was submitted with HTML in it___ ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out...
** Hi Joe, If you really want a file named con inWindows, trytyping the name as follows: press c press o press n press and hold ALT press 2 on the number pad (not the numbers above the alpha section) press 5 on the number pad press 5 on the number pad release ALT This actually creates a file named con[hard space]. The hard space is different than a conventional space, so Windows will allow it at the end of a file name, but it will still display it as if it were a space. If you want two files named con, you can use the same trick as above, but end with two hard spaces, or a space and a hard space: C:\dir|find "con" 10/13/2006 05:01 PM 0 con 10/13/2006 05:02 PM 0 con Eric Cleereman -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Joe DeSouzaSent: Friday, October 13, 2006 4:53 PMTo: arslist@ARSLIST.ORGSubject: Re: OT: Try this out...** A little different from what I thought the reason was... Interesting links though... Joe. - Original Message From: Axton [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Friday, October 13, 2006 4:33:19 PMSubject: Re: OT: Try this out...** http://mjsabby.com/2005/10/windows-xp-con-folderfile-bug.php http://whoelsebutdalieu.wordpress.com/2006/08/23/microsoft-is-just-funny-like-that/ It's because of the old days of DOS. CON is for the console (screen), PRN for printer, NUL basically means NULL or nothing. Try typing in DIR PRN into a command window. The directory listing will print. DIR NUL will not show anything. (In the old days programmers would run commands and have the output go to NUL so that they ran "transparently.") Looks like con, prn, nul can not be used. Now for the real reason: http://www.microsoft.com/technet/security/bulletin/fq00-017.mspx What's this bulletin about?Microsoft Security Bulletin MS00-017 announces the availability of a patch that eliminates a vulnerability in Microsoft® Windows® 95, Windows 98, and Windows 98 Second Edition. Under certain circumstances, the vulnerability could cause affected systems to crash. Microsoft is committed to protecting customers' information, and is providing the bulletin to inform customers of the vulnerability and what they can do about it. What causes the vulnerability?The vulnerability results because of a flaw in the way Windows 95 and 98 (including Windows 98 Second Edition) parse file path names. Device names such as COM1, CON or LPT1 are reserved words, and they can't be used as folder or file names. When parsing a reference to a path, Windows 95 and 98 check for the presence of a single DOS device name in the path. If one is found, the path is correctly treated as invalid and an error is returned. However, neither Windows 95 nor 98 check for multiple DOS device names. This is the source of the vulnerability. If a read or write operation is attempted to a path whose name contains multiple DOS device names, it will cause Windows 95 and 98 to attempt to access invalid resources. In some cases, the effect of this invalid access would be to cause the application that supplied the path to hang, but the more likely effect is that the machine would present a blue debug screen and crash. Axton Grams On 10/13/06, Thad Esser [EMAIL PROTECTED] wrote: ** Isn't con the output stream for the "con"sole in DOS. Similar to stdout in *nix? From a DOS prompt: echo xxx con puts xxx on the screen anyway. Thad"Argue for your limitations, and sure enough, they're yours."-- Richard Bach "Joe DeSouza" [EMAIL PROTECTED] Sent by: "Action Request System discussion list(ARSList)" arslist@ARSLIST.ORG 10/13/2006 01:15 PM Please respond toarslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject OT: Try this out... ** I'm almost positive I know the 'real reason' to this, a friend of mine who is not really from an IT background sent me a mail saying that even engineers at Microsoft do not know the answer to this (which I find hard to believe). Reason being after he sent me that mail I immediatly guessed the reason behind this, and I am willing to bet I am right about it.. Wanted to see if anyone here can figure it out... Try this out.. Try creating a directory or a file (with no extension) named con and it wont let you.. while creating a directory using the GUI it simply wont
Re: ARS Version 7.0 Objectstore newer version
Hi All, We are trying to install Incident Management 7.0. We have installed version CMDB 2.0 Patch 001. We are getting an error about the Objectstore is a newer version and can't continue. Do we need to install the non patch of CMDB first? Thanks, Jackson Windows XP SQL Server 2000 _ The next generation of Searchsay hello! http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-usFORM=WLMTAG ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: OT: Try this out... Friday Humour
Title: RE: OT: Try this out... Friday Humour ** Thad: You are so right James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Friday, October 13, 2006 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Try this out... Friday Humour ** I just got this one this morning: -- How Smart Is Your Right Foot? This is so funny that it will boggle your mind. And you will keep trying it at least 50 more times to see if you can outsmart your foot. But you can't. 1. While sitting at your desk, lift your right foot off the floor and make clockwise circles with it. 2. Now, while doing this, draw the number 6 in the air with your right hand. Your foot will change directions. I told you so...And there is nothing you can do about it. Make sure you pass this on to your friends. They won't be able to do it either. -- Thad __20060125___This posting was submitted with HTML in it___
search result
** I want to include a search result from a form in a notification andemail a user on a daily basis. The search result I am getting from a form is between 150 to 200 records.The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out... Friday Humour
** Depends on how slow you draw the 6 in the air, or maybe I'm not normal (there said it before anyone else grin) You can also draw the 6 clockwise (I know people that make their 6s that way. Start at the top left of the circle part of the 6 and make the circle clockwise. When you get to the starting point continue upward to make the top.) Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thad EsserSent: Friday, October 13, 2006 4:06 PMTo: arslist@ARSLIST.ORGSubject: Re: OT: Try this out... Friday Humour ** I just got this one this morning: -- How Smart Is Your Right Foot?This is so funny that it will boggle your mind. And you will keeptrying it at least 50 more times to see if you can outsmart your foot.But you can't.1. While sitting at your desk, lift your right foot off the floor andmake clockwise circles with it.2. Now, while doing this, draw the number "6" in the air with yourright hand. Your foot will change directions.I told you so...And there is nothing you can do about it. Make sure youpass this on to your friends. They won't be able to do it either.-- Thad"Argue for your limitations, and sure enough, they're yours."-- Richard Bach __20060125___This posting was submitted with HTML in it___
Re: Try this out...
** My guess was the same as LJ's If con was allowed as a directory or file name in DOS,then the command copy con A would evaluate to 2 possible interprtation by the system - 1) to create a file A, or to copy the contents of file con to file A, if there was a file called conwithin the directory... so at least somebody thinks like me out there :-) I was begining to wonder why it would spit out an error that itsa reserved device name.. Butmaybe the others are right though.. consoles are devices so if its because conrepresents consoles thatwe are not allowed to name a file con.. Have a nice weekend guys and thanks for replying to a totally unrelated thread... It wasn't a spam.. just thought it was Friday and since I was curious about this topic thought I'd share it with some of the brains out here on the list... Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Network, New Jersey. - Original Message From: L. J. Head [EMAIL PROTECTED]To: Joe DeSouza [EMAIL PROTECTED]Sent: Friday, October 13, 2006 4:29:38 PMSubject: RE: Try this out... In case this isn't spam...and your truly curious con stands for console...or in today's world command prompt. A quick easy way to create text or batch files is to type copy con abc.txt when you hit enter it starts recording what is typed on the console into the file...then when you are done writing the file you hit Ctrl-Z and hit enter and the file is saved...not much of a mystery for people involved in puters since the dos days...and BTW...the 's around abc.txt are not typed... L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouzaSent: Friday, October 13, 2006 2:15 PMTo: arslist@ARSLIST.ORGSubject: OT: Try this out... ** I'm almost positive I know the 'real reason' to this, a friend of mine who is not really from an IT background sent me a mail saying that even engineers at Microsoft do not know the answer to this (which I find hard to believe). Reason being after he sent me that mailI immediatly guessed the reason behind this, and I am willing to bet I am right about it.. Wanted to see if anyone here can figure it out... Try this out.. Try creating a directoryor a file (with no extension)named con and it wont let you.. while creating a directoryusing the GUI it simply wont let you create it(no error displayed)but if you try using DOS it will return an error -invalid name.. Similary if you create a file and try to name it con, it says this name is 'reserved for a device'.. Personally I donot think this is reserved for a device as such. It is reserved for 'something else'.At least thats my guess... Does anyone know why you cantname a file or directory namedcon? I have a good guess and am willing to bet I'm right... Just want to compare my guess to that of others around here... Write to me off list... Cheers Joe D'Souza Remedy Developer / Consultant, Shyle Networks, New Jersey. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: OT: Try this out... Friday Humour
** Very interesting :-) Joe. - Original Message From: "McKenzie, James J C-E LCMC HQISEC/L3" [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Friday, October 13, 2006 5:14:27 PMSubject: Re: OT: Try this out... Friday Humour** Thad: You are so right James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Thad Esser Sent: Friday, October 13, 2006 2:06 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Try this out... Friday Humour ** I just got this one this morning: -- How Smart Is Your Right Foot? This is so funny that it will boggle your mind. And you will keep trying it at least 50 more times to see if you can outsmart your foot. But you can't. 1. While sitting at your desk, lift your right foot off the floor and make clockwise circles with it. 2. Now, while doing this, draw the number "6" in the air with your right hand. Your foot will change directions. I told you so...And there is nothing you can do about it. Make sure you pass this on to your friends. They won't be able to do it either. -- Thad __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: search result
** Have you tried submitting a query email?I've never used one...but the old email engine provided capability to email the remedy server with a query and it would return the results in the body of the emailor you could generate a report macro...and have the escalation generate that csv and then email the csv to them L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 3:15 PMTo: arslist@ARSLIST.ORGSubject: search result ** I want to include a search result from a form in a notification andemail a user on a daily basis. The search result I am getting from a form is between 150 to 200 records.The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: search result
** L.J,I am not familiar with the submittinga query email, but how can I get the esclation to generatethe csv after I generate a report macro?"L. J. Head" [EMAIL PROTECTED] wrote: ** Have you tried submitting a query email?I've never used one...but the old email engine provided capability to email the remedy server with a query and it would return the results in the body of the emailor you could generate a report macro...and have the escalation generate that csv and then email the csv to themL. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis SolomonSent: Friday, October 13, 2006 3:15 PMTo: arslist@ARSLIST.ORGSubject: search result ** I want to include a search result from a form in a notification andemail a user on a daily basis. The search result I am getting from a form is between 150 to 200 records.The data changes every day. What is the best way to include the search result in the escalation so the user can receive one single email everyday? I will appreciate your help. kind regards Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates. __20060125___This posting was submitted with HTML in it___
Re: License Write Token Message (U)
Look in the aruser.log file for floating token usage. Depending on the interval set in the server statistics, it may have not captured the peak usage. Axton Grams On 10/13/06, McKenzie, James J C-E LCMC HQISEC/L3 [EMAIL PROTECTED] wrote: ** Brian: The message you refer to is one that is sent when there were no tokens available when a user logged on and then was given one later. That is why I'm confused I would suggest looking into the use of rrrLicense as it will tell you if and when you ran out of Float Write tokens (licenses). James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sokol, Brian Sent: Friday, October 13, 2006 1:03 PM To: arslist@ARSLIST.ORG Subject: Re: License Write Token Message (U) ** Hi James, I would agree except I have Server Statistics turned on and gathering info every 20 minutes. The highest my floating license count has gotten is 26. We have 33 floating licenses. The server stats also show 0 float license token denied. That is why I am confused??? __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
Axton, Thanks for the info. I'll keep this in mind if we upgrade our SUN servers instead of going to Windows. Before folks ask, we are looking at moving to Windows for many of the same reasons that James's is looking at moving to SUN. We have had more issues with down time since we went into a SUN Cluster than when we ever had on a stand alone SUN box. Issues have been disk related, human error, corruption of files for another database that crashed the storage array, etc. Throw on top of it a very controlling UNIX admin that uses SOX and Audits as justification for complete control. It took me a little over 6 months to document a fairly simple 6.3 installation and create a installation package for them to execute. It's time to move back to stand alone servers. Dave Date:Fri, 13 Oct 2006 14:07:43 -0400 From:Axton [EMAIL PROTECTED] Subject: Re: ARServer 7.0.1 Upgrade Installer I tracked the issue down to the data in the filter_sql table. When arupora is running, it logs to a file name /var/tmp/arsql.log. By viewing this file I could see what the last select was and concluded that the data returned by that select statement was causing the segfault. I removed all the data from filter_sql (15 records) and the installer completed successfully. Hope this helps someone. Axton Grams Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Merges Vs. Submit and Modify for Filters
Lisa - Well whaddya know! I'm glad I asked - b/c I didn't even notice that option! I was under the impression that you couldn't key on any data for an update, so this is great news. Thanks! Cindy ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org