SRM 7.6.03 - error with handling attachments
Hi, When the attachment is added to the service request form I'm supposed to see a note in the work info of the fulfilment application just to refer to the service request for the attachment. But it doesn't work. There is no log in the work info. No matter if it's standard or advanced form and the fulfilment application is incident or work order. I'm pretty sure that there was no customization to the workflow. If I look into the CAI:Events form there is that entry (Event: SRM_OUT_UPDATE_APP_REQUEST_WORKLOG) with the error message: 99011: There is no entry matching qualification. Update failed., ; and the arjavaplugin log displays: ERROR [pool-2-thread-1] com.bmc.itsm.cai.filterapi.cai.worker.UpdateEventWorker (UpdateEventWorker.java:59) - Qualification of Update Event:SR001a648a8258J8OfTgAGJK5AVbCh matches 0 entries, there is nothing to update several times. So all the retries of updating failed. I can make it work by modifying that entry (changing the value of RetryCounter) from CAI:Events -then the log in the work info appears The question is why at the time of workflow the CAI mechanism cannot find the proper record. thanks, Marek ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to get the Users's license? [I]
Sorry - I was referring to Paul's message. BUT - you did solve my problem!! So, I copied the table field from 'AR System Administration: Manage User Licences' and put it on the form where I want to find the users's licence. I removed all the columns except 'Write Licence'. I set the table qualification to: ('licuserinfolicensecategory' = 0) AND ('licuserinfocurrentregdtype' = 0) AND ('licuserinfolictype' = 0) AND ('licuserinfousername' = $USER$) Hey presto - I can refresh that table and at any point find the current user's licence! Thanks Misi! Kerry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Database Upgrade - 10g to 11g [I]
Classification: For internal use only ARSListers, We are currently evaluating an upgrade to Oracle 11g from 10g (Remedy ARS 7.1 platform) and would be interested in people experience of doing the same. Any issues or areas of concern to be aware of? Regards, Paul --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Database Upgrade - 10g to 11g [I]
For your version u still use client 10 remotely even if on same box... Works fine Sent from my iPhone so typo's or funky words can and do happen! On Oct 20, 2011, at 5:46 AM, Paul Nicolaides paul.nicolai...@db.com wrote: ** Classification: For internal use only ARSListers, We are currently evaluating an upgrade to Oracle 11g from 10g (Remedy ARS 7.1 platform) and would be interested in people experience of doing the same. Any issues or areas of concern to be aware of? Regards, Paul --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to get the Users's license? [I]
Hi, Perfect, and good to hear that ('licuserinfousername' = $USER$) was indeed supported! Best Regards - Misi, RRR AB, http://rrr.se Sorry - I was referring to Paul's message. BUT - you did solve my problem!! So, I copied the table field from 'AR System Administration: Manage User Licences' and put it on the form where I want to find the users's licence. I removed all the columns except 'Write Licence'. I set the table qualification to: ('licuserinfolicensecategory' = 0) AND ('licuserinfocurrentregdtype' = 0) AND ('licuserinfolictype' = 0) AND ('licuserinfousername' = $USER$) Hey presto - I can refresh that table and at any point find the current user's licence! Thanks Misi! Kerry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Database Upgrade - 10g to 11g [I]
We use 7.5 and upgraded from 10g to 11g. It was a non-event. On Thu, Oct 20, 2011 at 6:04 AM, Patrick Zandi remedy...@gmail.com wrote: ** For your version u still use client 10 remotely even if on same box... Works fine Sent from my iPhone so typo's or funky words can and do happen! On Oct 20, 2011, at 5:46 AM, Paul Nicolaides paul.nicolai...@db.com wrote: ** Classification: For internal use only ARSListers, We are currently evaluating an upgrade to Oracle 11g from 10g (Remedy ARS 7.1 platform) and would be interested in people experience of doing the same. Any issues or areas of concern to be aware of? Regards, Paul --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ -- Rebecca Boyd Application Administrator Wake Forest University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
ok, it finished: I ran it over night// had several warnings.. but no failures.. off to the logs.. total time :: 7.5 hours On Wed, Oct 19, 2011 at 3:09 PM, strauss stra...@unt.edu wrote: ** My installs are failing after only 70 or 80 minutes. I cleaned up the first defect and it has now failed on another. Apparently SP2 depends on things that failed to happen properly during my 7.6.03 upgrades from earlier versions, so it is unable to complete. Nothing here to instill confidence for planning a rapid move to SP2 in the production environment. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Wednesday, October 19, 2011 1:56 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** OK back at it again::: According to Support::: so now I am asking again::: ENV: 64 cpu's 32 gig of ram How many hours is the task update suppose to take? 6 - 8 - 12 - 24 hours? Cause were over 5 already.. On Tue, Oct 18, 2011 at 6:11 PM, Patrick Zandi remedy...@gmail.com wrote: So they broke it twice ! Lol Sent from my iPhone so typo's or funky words can and do happen! On Oct 18, 2011, at 6:02 PM, strauss stra...@unt.edu wrote: ** BMC Support indicates that there is a known defect with a view ID that basically prevents the ITSM SP2 installer from completing successfully. It looks like it will affect all of my available environments. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *strauss *Sent:* Tuesday, October 18, 2011 1:43 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** The rik.err error was: Definition File (D:\Program Files (x86)\BMC Software\BMCRemedyITSMSuite\ITSMT01\Workflow\install\7.6.04_sp2_overlay_install\systems\fnd\workflow\en\.\fnd_deplapp.def) import failed with error code (392) :- (Field/VUI name must be unique for the form -- there is already a field or VUI using this name) Since there are almost 300 forms in that def file, I’m going to let BMC figured out what they did wrong. The only form I overlaid on the server is HPD:Help Desk (one field, Reported Source was given Other as a Default value) and one of the 7.6.04 upgrades added an overlay for HPD:HelpDesk_AuditLogSystem, and neither of those is in the problematic def file. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *strauss *Sent:* Tuesday, October 18, 2011 1:19 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Oh, I doubt that (that there is any hope for me)… my downloads are from last week. The Atrium SP2 applied clean on the second try, but the ITSM SP2 just completed with a failure. So far the SP2 installers are NOT looking good at all. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, October 18, 2011 1:11 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** you will not believe it:: LIKE THIS HAS NEVER HAPPENED Files uploaded to the download site are BAD::: they just replaced them with the correct files yesterday?!? I guess.. Go Figure.. So I have re reinstall everything Again.. Wonderful.. So there is hope for ya Chris!!! LOL On Tue, Oct 18, 2011 at 1:29 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: ** Do you have an SQL log?? It looks like it is updating 1 record at a time* *** Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Tuesday, October 18, 2011 11:57 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** OK, 3 hours of this::: NOW WHAT (Oct 18 2011 03:54:07.112 PM +),INFO,com.bmc.install.product.rik.statement.RIKLoadApplicationStatement, LOG EVENT {Description=[Code],Detail=[550]} (Oct 18 2011 03:54:07.113 PM
Re: What does CTM stand for
Thanks -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Lander Sent: Wednesday, October 19, 2011 5:04 PM To: arslist@ARSLIST.ORG Subject: Re: What does CTM stand for Hi Ken, I emailed you the word document but for those on the arslist (and bear in mind that although this is quite old, it should still cover most of the modules): ITSM 7.x Object Prefixes AP: Approval Server APR: Approval Server APW: Approval Server ASE: Assignment Engine AST: Asset Management BMC.AM: BMC Asset Management Namespace BMC.CORE.CONFIG: CMDB Configuration BMC.CORE: CMDB Classes BSM: Not part of ITSM 7.0. Part of the CMDB Atrium CMDB Console deployable application CAI: Command Automation Interface CBK: Charge Back CFB: Change Management Flashboards CFG: Configuration CHG: Change Management CMDB: Configuration Management Database CMS: Configuration Management System COM: Company CTM: Contact Management FB: Flashboards (base AR) FIN: Financial HPD: Help Desk (Incident Management) KMS: Knowledge Management System LIC: License NTE: Notification Engine OBJSTR: CMDB, Object Store PBM: Problem PCT: Product Catalog PDL: Product Dictionary Library RAC: Application Administration Console RE: Reconciliation Engine RMG: Time Segments (Foundation system) RQC: Requester Console RRC: Reporting SHR: Shared SIT: Site SLM: Service Level Management SRM: Service Request Management SYS: System TMS: Task Management System VIS: Process Visualizer (Foundation system) Cheers, J ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
OT - Batch scripting
Sorry for placing this here, but i know that this is one of the most suitables places to find real gurus and not only for ARS :-); I'm facing an error that it seems to be a logic error (from myself) or lack of knowledge in regards Batch scripting (I've always been Unix guy), so hope someone could give me some light on this. I'm setting a monitor (not exactly, because is reactive) process on a VM - Win2003 pro, for corrective purposes of Tomcat process, itself only monitors the established connnections within server and users, and if it finds more than 80 established connections, will store that first violation, and wait for certain time to run again, if it finds more than 80 connections 3 consecutive times, then will stop Tomcat Server and start up again the processes. So far I've the structure of the code but I'm finding a couple of issues that kept me hitting my head against the keyboard. 1.- In the monitor log, If I found more than 80 open connections at that time I send an ECHO 1 C:\Somedirectory\Sompepath\openconnections.log, but when I check the log file found that it writes 1 (the 1 and a blank space after and a return); is there a way to only write the file with a flat '1' with no extra characters? 2.- Once the file is created the program will read the information and assign that to a variable: SET /P mycounter =C:\Somedirectory\Sompepath\openconnections.log I placed a ECHO output for that and I'm seeing that is getting the information as expected 1 , and then 3.- I peform the validation against my flag to stop tomcat servies IF [%mycounter%] EQU [%maxtries%] CALL rebootscript.bat However, the validation is always true, an ECHO output for this last code line showed me [1 ] EQU [111]; my understanding is that I'm doing a string to string comparisson, but i can't figure out why DOS is assuming that 1 is the same as 111 not the same string lenght, neither value..., I'm pretty sure I'm missing something here, but can't figure out what is that small piece I'm doing wrong. Cheers. Hugo Ruesga Software Development Advisor MX +52 (55) 4353.9802 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 Filter Objects being cached?
I’ve been experiencing on our Dev server which is a single server. Haven’t yet tried in our QA / Prod environments which are server groups. Nathan Aker ITSM Solution Architect McAfee, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Wednesday, October 19, 2011 10:45 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 Filter Objects being cached? ** If you are running on a server group, then it is a known defect.At least for 7.6.03. Seems like it is impacting 7.6.04. Did you try patch2? It was fixed in 7.6.03 patch002, so I guess it might have rolled out in 7.6.04 patch002 also if they already knew. SW00374664 The administrative AR System server in a server group did not propagate the server objects’ time stamps (which follow) to other AR System servers on which administrative operations were disabled: Last changed Last created Last deleted As a result, the Sync Cache process in BMC Remedy Mid Tier failed. We did upgrade to patch002 and still see sometimes it takes a while to get the other servers recahce with the changes or sometimes it wont. So we started restarting all our servers after code migration as a precaution. On the midtier side some times flushing the midtier cache only does not work. We had to flush IE cache, cookies and temp files to see the new changes. _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: OT - Batch scripting
Try something like this @echo off SET maxcount=30 SET increment=10 SET countfile=c:\count.txt REM get the current count (or start at zero if no current count) IF EXIST %countfile% SET /P mycounter=%countfile% IF NOT EXIST %countfile% SET mycounter=0 REM increment counter SET /a mycounter=%mycounter%+%increment% ECHO Counter incremented to: %mycounter% ECHO %mycounter%%countfile% REM Check to see if the service needs to be restarted IF %mycounter%==%maxcount% GOTO RESTART GOTO END :RESTART REM Restart the service here ECHO Reset Service REM Reset the count DEL /Q %countfile% :END Ken From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hyunkel v2.0 Sent: Thursday, October 20, 2011 9:25 AM To: arslist@ARSLIST.ORG Subject: OT - Batch scripting ** Sorry for placing this here, but i know that this is one of the most suitables places to find real gurus and not only for ARS :-); I'm facing an error that it seems to be a logic error (from myself) or lack of knowledge in regards Batch scripting (I've always been Unix guy), so hope someone could give me some light on this. I'm setting a monitor (not exactly, because is reactive) process on a VM - Win2003 pro, for corrective purposes of Tomcat process, itself only monitors the established connnections within server and users, and if it finds more than 80 established connections, will store that first violation, and wait for certain time to run again, if it finds more than 80 connections 3 consecutive times, then will stop Tomcat Server and start up again the processes. So far I've the structure of the code but I'm finding a couple of issues that kept me hitting my head against the keyboard. 1.- In the monitor log, If I found more than 80 open connections at that time I send an ECHO 1 C:\Somedirectory\Sompepath\openconnections.log, but when I check the log file found that it writes 1 (the 1 and a blank space after and a return); is there a way to only write the file with a flat '1' with no extra characters? 2.- Once the file is created the program will read the information and assign that to a variable: SET /P mycounter =C:\Somedirectory\Sompepath\openconnections.log I placed a ECHO output for that and I'm seeing that is getting the information as expected 1 , and then 3.- I peform the validation against my flag to stop tomcat servies IF [%mycounter%] EQU [%maxtries%] CALL rebootscript.bat However, the validation is always true, an ECHO output for this last code line showed me [1 ] EQU [111]; my understanding is that I'm doing a string to string comparisson, but i can't figure out why DOS is assuming that 1 is the same as 111 not the same string lenght, neither value..., I'm pretty sure I'm missing something here, but can't figure out what is that small piece I'm doing wrong. Cheers. Hugo Ruesga Software Development Advisor MX +52 (55) 4353.9802 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ITSM 7.5.0 upgrade attempt
I'm running Remedy on a Windows 2003 server using SQL. I'm attempting to upgrade ITSM from 7.0.0 to 7.5.0. The install said it completed successfully but when I look at the install log I see a boat load of warnings; more than I can paste here (179 to be exact). I'm trying to decipher what these warnings mean; they all appear to be the related, I think. As I've discovered from past upgrades warnings maybe okay but they usually come back to haunt me with the next upgrade. Can someone point me in the right direction on how to decipher these warnings? (Oct 19 2011 03:40:27.345 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:27 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:27.361 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Executing],Detail=[RIK command]}]} (Oct 19 2011 03:40:27.361 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:27 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:27.377 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Command array],Detail=[C:\DOCUME~1\LARBAR~1\LOCALS~1\Temp\Utilities\rik\rik.exe veradmin -x cdav5apprmd01 -t 0 -u Demo -p not_displayed -l D:\ITSMSU~1\CDAV5A~1\REMEDY~1\Logs\ITSMEX~1 -s 0 -B -L -C]}]} (Oct 19 2011 03:40:28.814 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:28.830 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Execution result [resultType=COMPLETED,exitCode=0]]}]} (Oct 19 2011 03:40:28.830 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:28.845 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Completed executing],Detail=[RIK command]}]} (Oct 19 2011 03:40:28.861 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.install.product.atriumfoundation.extloader.task.ExtLoaderARServe rCredentialValidations]} (Oct 19 2011 03:40:28.861 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[AR Server administrator validation succeeded],Detail=[Result = 0]}]} (Oct 19 2011 03:40:28.877 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:28.877 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Executing],Detail=[RIK command]}]} Thanks for your time, Larry B. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.5.0 upgrade attempt
Submit them to BMC Support - they have tools that you/we don't to review the logs for errors that must be corrected. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Larry Barnes Sent: Thursday, October 20, 2011 9:52 AM To: arslist@ARSLIST.ORG Subject: ITSM 7.5.0 upgrade attempt ** I'm running Remedy on a Windows 2003 server using SQL. I'm attempting to upgrade ITSM from 7.0.0 to 7.5.0. The install said it completed successfully but when I look at the install log I see a boat load of warnings; more than I can paste here (179 to be exact). I'm trying to decipher what these warnings mean; they all appear to be the related, I think. As I've discovered from past upgrades warnings maybe okay but they usually come back to haunt me with the next upgrade. Can someone point me in the right direction on how to decipher these warnings? (Oct 19 2011 03:40:27.345 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:27 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:27.361 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Executing],Detail=[RIK command]}]} (Oct 19 2011 03:40:27.361 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:27 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:27.377 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Command array],Detail=[C:\DOCUME~1\LARBAR~1\LOCALS~1\Temp\Utilities\rik\rik.exe veradmin -x cdav5apprmd01 -t 0 -u Demo -p not_displayed -l D:\ITSMSU~1\CDAV5A~1\REMEDY~1\Logs\ITSMEX~1 -s 0 -B -L -C]}]} (Oct 19 2011 03:40:28.814 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:28.830 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Execution result [resultType=COMPLETED,exitCode=0]]}]} (Oct 19 2011 03:40:28.830 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:28.845 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Completed executing],Detail=[RIK command]}]} (Oct 19 2011 03:40:28.861 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.install.product.atriumfoundation.extloader.task.ExtLoaderARServerCredentialValidations]} (Oct 19 2011 03:40:28.861 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[AR Server administrator validation succeeded],Detail=[Result = 0]}]} (Oct 19 2011 03:40:28.877 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[Oct 19, 2011 3:40:28 PM com.bmc.smbu.install.common.rule.engine.rik.RikCommand]} (Oct 19 2011 03:40:28.877 PM -0700),WARNING,com.bmc.install.utility.platform.CommandLineHelper, LOG EVENT {Description=[INFO: LOG EVENT {Description=[Executing],Detail=[RIK command]}]} Thanks for your time, Larry B. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Job: ADDM 8.x Developer/Administrator New Jersey
Hi, Contract location: New Jersey Starts: by 10/31/11 Long term Contract. We have a project for ADDM 8.x (Tideway) Developer/Administrator in the New Jersey office. The person would be configuring ADDM to discover assets. Not sure what the future will bring, however this is not a full time job at this point. Please forward your resume if you are interested. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AR System API Downloads (C and Java)
Thank you Misi, we are lucky to have you as a contributor! Susan On Thu, Oct 20, 2011 at 10:12 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have now published a more complete set of the AR API:s, for all our convenience: http://rrr.se/download/arapi/ Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to get the Users's license? [I]
Kerry, Just to take this one step further. If you have a table field, that means you are searching a form. If you can change the qualifier of the table, that means that is a search criteria for the form. So, you could use a Set Fields operation to just pull back the data directly to a field rather than having to have a table field and then walk it to get the information. This may be a further simplification of the work you need to do. Just an idea in case it is useful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Thursday, October 20, 2011 2:29 AM To: arslist@ARSLIST.ORG Subject: Re: How to get the Users's license? [I] Sorry - I was referring to Paul's message. BUT - you did solve my problem!! So, I copied the table field from 'AR System Administration: Manage User Licences' and put it on the form where I want to find the users's licence. I removed all the columns except 'Write Licence'. I set the table qualification to: ('licuserinfolicensecategory' = 0) AND ('licuserinfocurrentregdtype' = 0) AND ('licuserinfolictype' = 0) AND ('licuserinfousername' = $USER$) Hey presto - I can refresh that table and at any point find the current user's licence! Thanks Misi! Kerry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AR System API Downloads (C and Java)
+1 Misi is huge ! Matt Laurenceau Senior Community Ambassador, BMC Communities matthieu_laurenc...@bmc.com Follow me @Matt_L Skype: matt.laurenceau On 20 oct. 2011, at 18:20, Susan Palmer suzanpal...@gmail.com wrote: ** Thank you Misi, we are lucky to have you as a contributor! Susan On Thu, Oct 20, 2011 at 10:12 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have now published a more complete set of the AR API:s, for all our convenience: http://rrr.se/download/arapi/ Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AR System API Downloads (C and Java)
There is one star on the arslist universe and that is Misi, thnx !!! From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Matt Laurenceau Sent: Thursday, October 20, 2011 6:44 PM To: arslist@ARSLIST.ORG Subject: Re: AR System API Downloads (C and Java) ** +1 Misi is huge ! Matt Laurenceau Senior Community Ambassador, BMC Communities matthieu_laurenc...@bmc.commailto:matthieu_laurenc...@bmc.com Follow me @Matt_L Skype: matt.laurenceau On 20 oct. 2011, at 18:20, Susan Palmer suzanpal...@gmail.commailto:suzanpal...@gmail.com wrote: ** Thank you Misi, we are lucky to have you as a contributor! Susan On Thu, Oct 20, 2011 at 10:12 AM, Misi Mladoniczky m...@rrr.semailto:m...@rrr.se wrote: Hi, I have now published a more complete set of the AR API:s, for all our convenience: http://rrr.se/download/arapi/ Best Regards - Misi, RRR AB, http://www.rrr.sehttp://www.rrr.se/ (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.sehttp://rrr.se/. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org/ attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com/ ARSList: Where the Answers Are _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG11 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)11 206 5606 | Midridge Office Estate, International Business Gateway, cnr New Road Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: How to get the Users's license? [I]
Hi Doug, It all depends on which calls that specific ARDBC-plugin has implemented. When I played around with these things quite some time ago, it turned out that the GetListEntry-call used in Set-Fields was NOT implemented, but the GetListEntryWithFields-call was. This is the reason for my recommendation earlier. Another thing to note is that all fields may not be searchable in an ARDBC-form, this also depends on how the functions has been implemented in the plugin. BMC usually only implements the calls/search-fields needed at the moment. So Kerry, please go ahead and try the Set-Fields version, and let us know how it works out. Another issue with Active-Link Set-Fields are that they issue different calls in different versions of the AR System, and also behaves differently between Mid-Tier and the Windows-client... But a filter-set-fields should always work in the same way. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Kerry, Just to take this one step further. If you have a table field, that means you are searching a form. If you can change the qualifier of the table, that means that is a search criteria for the form. So, you could use a Set Fields operation to just pull back the data directly to a field rather than having to have a table field and then walk it to get the information. This may be a further simplification of the work you need to do. Just an idea in case it is useful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Thursday, October 20, 2011 2:29 AM To: arslist@ARSLIST.ORG Subject: Re: How to get the Users's license? [I] Sorry - I was referring to Paul's message. BUT - you did solve my problem!! So, I copied the table field from 'AR System Administration: Manage User Licences' and put it on the form where I want to find the users's licence. I removed all the columns except 'Write Licence'. I set the table qualification to: ('licuserinfolicensecategory' = 0) AND ('licuserinfocurrentregdtype' = 0) AND ('licuserinfolictype' = 0) AND ('licuserinfousername' = $USER$) Hey presto - I can refresh that table and at any point find the current user's licence! Thanks Misi! Kerry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Escape Characters for Forward Slash
** Wild guess - try = "N" + "/" + "A" Kelly DeaverL-3 Stratis / FAA Contractor kdea...@kellydeaver.com (ARSlist mail)kelly.ctr.dea...@faa.gov(Business mail) Original Message Subject: Re: Escape Characters for Forward SlashFrom: Drew Shuller drew.shul...@gmail.comDate: Wed, October 19, 2011 3:37 pmTo: arslist@ARSLIST.ORGThe backslash causes Remedy to ignore the forward slash after it.On Wed, Oct 19, 2011 at 2:21 PM, Drew Shuller drew.shul...@gmail.com wrote: That's giving me an unexpected character at position 3 error. Trying a backslash. On Wed, Oct 19, 2011 at 2:12 PM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: Try N//A Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Drew Shuller Sent: Wednesday, October 19, 2011 3:11 PM To: arslist@ARSLIST.ORG Subject: Escape Characters for Forward Slash Good afternoon everyone. I'm having a brain fade and can't find anything in the docs. I'm mapping a character field in a Dialog window on open. The value I want is N/A but it appears as NA. Is there an escape character for the forward slash? Thanks in advance! Drew Shuller (my real name) Soto Cano Air Base Honduras, CA ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"___UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgattend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Outgoing email address rejection list
Of course - the email engine query is mailbox-specific; I forgot that. (I'm trying to reduce size of that nasty NOT IN query it runs.) That's an excellent solution, Fred. Thanks! Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, October 19, 2011 5:51 PM To: arslist@ARSLIST.ORG Subject: Re: Outgoing email address rejection list ** Not if the configuration for that new Invalid mailbox is set to Disabled in the AR System Email Mailbox Configuration form. Then the messages should sit in the Email Messages form where you can use other workflow to delete them. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: Wednesday, October 19, 2011 3:17 PM To: arslist@ARSLIST.ORG Subject: Re: Outgoing email address rejection list ** Interesting thought, Fred, but I believe the email would still be in the mailbox and scanned as outgoing though, which I am trying to avoid. Jason - thanks for the 'To' swap idea. That's pretty much my last resort, as it would require sending the emails then deleting them, which is such a waste. Doesn't it seem odd though that there is no way to simply stop an outgoing email? And that whatever is changing the 'Send Message' field back to Yes doesn't show up on the logs? Just as odd - I tried setting the 'Status' as well to Rejected as a flag, and found that while the filters ran, the 'Status' field on the new entry was set back to New. What is doing this? Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, October 19, 2011 3:40 PM To: arslist@ARSLIST.ORG Subject: Re: Outgoing email address rejection list ** How about if you change to a different mailbox name with Submit filters Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: Wednesday, October 19, 2011 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: Outgoing email address rejection list ** Or perhaps others can't comment. :^) Thanks for the confirmation on this issue, David; it helps to know that it is related to something normal in Remedy and not another custom code issue. I can't throw an error though, because that would error out the originating Incident transaction, which I don't want to do. (Thank you Marcelo as well, but the list is of invalid addresses that aren't connected to contacts. Please don't ask me why it's necessary for our custom code to set invalid email addresses, I won't have a pleasant or printable answer. ;^) Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Tuesday, October 18, 2011 5:29 PM To: arslist@ARSLIST.ORG Subject: Re: Outgoing email address rejection list ** I'm not a mail guru at all, but I have seen that issue with a message going out even after I manually set 'Send Message' to No - maybe ARS 6.0 and perhaps 7.5, too. Sometimes I think it's a timing issue with the mail processing.
Re: OT - Batch scripting
Thank you so much Ken; But when I declare the Variable for the file I receive the filepath\filename was unexpected at this time. Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Thu, 20 Oct 2011 10:37:24 -0400 From: kce...@hubbell.com Subject: Re: OT - Batch scripting To: arslist@ARSLIST.ORG ** Try something like this…. @echo off SET maxcount=30SET increment=10SET countfile=c:\count.txt REM get the current count (or start at zero if no current count)IF EXIST %countfile% SET /P mycounter=%countfile%IF NOT EXIST %countfile% SET mycounter=0 REM increment counterSET /a mycounter=%mycounter%+%increment%ECHO Counter incremented to: %mycounter%ECHO %mycounter%%countfile% REM Check to see if the service needs to be restartedIF %mycounter%==%maxcount% GOTO RESTART GOTO END :RESTARTREM Restart the service hereECHO Reset Service REM Reset the countDEL /Q %countfile% :END Ken From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hyunkel v2.0 Sent: Thursday, October 20, 2011 9:25 AM To: arslist@ARSLIST.ORG Subject: OT - Batch scripting ** Sorry for placing this here, but i know that this is one of the most suitables places to find real gurus and not only for ARS :-); I'm facing an error that it seems to be a logic error (from myself) or lack of knowledge in regards Batch scripting (I've always been Unix guy), so hope someone could give me some light on this. I'm setting a monitor (not exactly, because is reactive) process on a VM - Win2003 pro, for corrective purposes of Tomcat process, itself only monitors the established connnections within server and users, and if it finds more than 80 established connections, will store that first violation, and wait for certain time to run again, if it finds more than 80 connections 3 consecutive times, then will stop Tomcat Server and start up again the processes. So far I've the structure of the code but I'm finding a couple of issues that kept me hitting my head against the keyboard. 1.- In the monitor log, If I found more than 80 open connections at that time I send an ECHO 1 C:\Somedirectory\Sompepath\openconnections.log, but when I check the log file found that it writes 1 (the 1 and a blank space after and a return); is there a way to only write the file with a flat '1' with no extra characters? 2.- Once the file is created the program will read the information and assign that to a variable: SET /P mycounter =C:\Somedirectory\Sompepath\openconnections.log I placed a ECHO output for that and I'm seeing that is getting the information as expected 1 , and then 3.- I peform the validation against my flag to stop tomcat servies IF [%mycounter%] EQU [%maxtries%] CALL rebootscript.bat However, the validation is always true, an ECHO output for this last code line showed me [1 ] EQU [111]; my understanding is that I'm doing a string to string comparisson, but i can't figure out why DOS is assuming that 1 is the same as 111 not the same string lenght, neither value..., I'm pretty sure I'm missing something here, but can't figure out what is that small piece I'm doing wrong. Cheers.Hugo Ruesga Software Development Advisor MX +52 (55) 4353.9802P Please consider the environment before printing this emailThe information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
Re: OT - Batch scripting
Nevermind I made a typo error :) Thanks for the help :D Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. Date: Thu, 20 Oct 2011 10:37:24 -0400 From: kce...@hubbell.com Subject: Re: OT - Batch scripting To: arslist@ARSLIST.ORG ** Try something like this…. @echo off SET maxcount=30SET increment=10SET countfile=c:\count.txt REM get the current count (or start at zero if no current count)IF EXIST %countfile% SET /P mycounter=%countfile%IF NOT EXIST %countfile% SET mycounter=0 REM increment counterSET /a mycounter=%mycounter%+%increment%ECHO Counter incremented to: %mycounter%ECHO %mycounter%%countfile% REM Check to see if the service needs to be restartedIF %mycounter%==%maxcount% GOTO RESTART GOTO END :RESTARTREM Restart the service hereECHO Reset Service REM Reset the countDEL /Q %countfile% :END Ken From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hyunkel v2.0 Sent: Thursday, October 20, 2011 9:25 AM To: arslist@ARSLIST.ORG Subject: OT - Batch scripting ** Sorry for placing this here, but i know that this is one of the most suitables places to find real gurus and not only for ARS :-); I'm facing an error that it seems to be a logic error (from myself) or lack of knowledge in regards Batch scripting (I've always been Unix guy), so hope someone could give me some light on this. I'm setting a monitor (not exactly, because is reactive) process on a VM - Win2003 pro, for corrective purposes of Tomcat process, itself only monitors the established connnections within server and users, and if it finds more than 80 established connections, will store that first violation, and wait for certain time to run again, if it finds more than 80 connections 3 consecutive times, then will stop Tomcat Server and start up again the processes. So far I've the structure of the code but I'm finding a couple of issues that kept me hitting my head against the keyboard. 1.- In the monitor log, If I found more than 80 open connections at that time I send an ECHO 1 C:\Somedirectory\Sompepath\openconnections.log, but when I check the log file found that it writes 1 (the 1 and a blank space after and a return); is there a way to only write the file with a flat '1' with no extra characters? 2.- Once the file is created the program will read the information and assign that to a variable: SET /P mycounter =C:\Somedirectory\Sompepath\openconnections.log I placed a ECHO output for that and I'm seeing that is getting the information as expected 1 , and then 3.- I peform the validation against my flag to stop tomcat servies IF [%mycounter%] EQU [%maxtries%] CALL rebootscript.bat However, the validation is always true, an ECHO output for this last code line showed me [1 ] EQU [111]; my understanding is that I'm doing a string to string comparisson, but i can't figure out why DOS is assuming that 1 is the same as 111 not the same string lenght, neither value..., I'm pretty sure I'm missing something here, but can't figure out what is that small piece I'm doing wrong. Cheers.Hugo Ruesga Software Development Advisor MX +52 (55) 4353.9802P Please consider the environment before printing this emailThe information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ *** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
Congratulations! Could somebody from BMC explain what is happening during this time where nothing appears to be happening? I remember having the same experience during the 7.5 to 7.6.04 SP1 upgrade. The logs do not indicate that anything is happening and a db trace shows very little activity. You just have to hold your breath, have faith and hope for the best. Below is a snippet of our production upgrade notes the times of each install. Fortunately I was able to take the system down for two days because we only had three people using this new system for production data (contracts). We finished just a hair past our 9 AM time to return to production (I got lucky). Run ARSystem_7604SP1_Windows (5/25/2011 14:02 - 16:00) • A handful of errors: § arerror.log § Wed May 25 15:01:05 2011 390600 : Could not find or read the tags file. (ARNOTE 452) § Wed May 25 15:01:05 2011 C:\Program Files\Common Files\AR System\Licenses\servername\arsystem.tag § Wed May 25 15:02:03 2011 390600 : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) § Wed May 25 15:02:02 2011 390600 : Creation of an application form failed. (ARERR 4550) § An error regarding the email engine. Run atrium7604SP1.win (5/25/2011 23:17 - 5/26/2011 13:21) • RIK hung at 00:23, acknowledged and process started again at 08:03 • Finished without further error • The issues in test with Active Link guides after Atrium Core did not happen in production • Create Windows symbolic link to account for AIE directory change § mklink /J D:\Program Files (x86)\BMC Software\AtriumCore\aie\service D:\Program Files (x86)\BMC Software\AtriumCore\aie\service64 Run BMCRemedyITSMSuite7604SP1.windows (5/26/2011 14:00 - 5/27/2011 07:33) Run ServiceLevelManagement7.6.04.SP1.windows (5/27/2011 08:07 - 09:02) Run BmcRkm7604SP1.windows (5/29/2001 23:30 - 5/30/2011 02:04) Run atriumintegrator7604SP1.client_server.win / atriumintegrator7604.server.win (6/4/2011 20:56 - 21:30) Jason On Thu, Oct 20, 2011 at 5:38 AM, patrick zandi remedy...@gmail.com wrote: ** ok, it finished: I ran it over night// had several warnings.. but no failures.. off to the logs.. total time :: 7.5 hours On Wed, Oct 19, 2011 at 3:09 PM, strauss stra...@unt.edu wrote: ** My installs are failing after only 70 or 80 minutes. I cleaned up the first defect and it has now failed on another. Apparently SP2 depends on things that failed to happen properly during my 7.6.03 upgrades from earlier versions, so it is unable to complete. Nothing here to instill confidence for planning a rapid move to SP2 in the production environment. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Wednesday, October 19, 2011 1:56 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** OK back at it again::: According to Support::: so now I am asking again::: ENV: 64 cpu's 32 gig of ram How many hours is the task update suppose to take? 6 - 8 - 12 - 24 hours? Cause were over 5 already.. On Tue, Oct 18, 2011 at 6:11 PM, Patrick Zandi remedy...@gmail.com wrote: So they broke it twice ! Lol Sent from my iPhone so typo's or funky words can and do happen! On Oct 18, 2011, at 6:02 PM, strauss stra...@unt.edu wrote: ** BMC Support indicates that there is a known defect with a view ID that basically prevents the ITSM SP2 installer from completing successfully. It looks like it will affect all of my available environments. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *strauss *Sent:* Tuesday, October 18, 2011 1:43 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** The rik.err error was: Definition File (D:\Program Files (x86)\BMC Software\BMCRemedyITSMSuite\ITSMT01\Workflow\install\7.6.04_sp2_overlay_install\systems\fnd\workflow\en\.\fnd_deplapp.def) import failed with error code (392) :- (Field/VUI name must be unique for the form -- there is already a field or VUI using this name) Since there are almost 300 forms in that def file, I’m going to let BMC figured out what they did wrong. The only form I overlaid on the server is HPD:Help Desk (one field, Reported Source was given Other as a Default value) and one of the 7.6.04 upgrades added an overlay for
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went over 6%... had tons of ram too... not sure what the answer is ? BMC Engineering might have a better clue... On Thu, Oct 20, 2011 at 3:25 PM, Jason Miller jason.mil...@gmail.comwrote: ** Congratulations! Could somebody from BMC explain what is happening during this time where nothing appears to be happening? I remember having the same experience during the 7.5 to 7.6.04 SP1 upgrade. The logs do not indicate that anything is happening and a db trace shows very little activity. You just have to hold your breath, have faith and hope for the best. Below is a snippet of our production upgrade notes the times of each install. Fortunately I was able to take the system down for two days because we only had three people using this new system for production data (contracts). We finished just a hair past our 9 AM time to return to production (I got lucky). Run ARSystem_7604SP1_Windows (5/25/2011 14:02 - 16:00) • A handful of errors: § arerror.log § Wed May 25 15:01:05 2011 390600 : Could not find or read the tags file. (ARNOTE 452) § Wed May 25 15:01:05 2011 C:\Program Files\Common Files\AR System\Licenses\servername\arsystem.tag § Wed May 25 15:02:03 2011 390600 : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) § Wed May 25 15:02:02 2011 390600 : Creation of an application form failed. (ARERR 4550) § An error regarding the email engine. Run atrium7604SP1.win (5/25/2011 23:17 - 5/26/2011 13:21) • RIK hung at 00:23, acknowledged and process started again at 08:03 • Finished without further error • The issues in test with Active Link guides after Atrium Core did not happen in production • Create Windows symbolic link to account for AIE directory change § mklink /J D:\Program Files (x86)\BMC Software\AtriumCore\aie\service D:\Program Files (x86)\BMC Software\AtriumCore\aie\service64 Run BMCRemedyITSMSuite7604SP1.windows (5/26/2011 14:00 - 5/27/2011 07:33) Run ServiceLevelManagement7.6.04.SP1.windows (5/27/2011 08:07 - 09:02) Run BmcRkm7604SP1.windows (5/29/2001 23:30 - 5/30/2011 02:04) Run atriumintegrator7604SP1.client_server.win / atriumintegrator7604.server.win (6/4/2011 20:56 - 21:30) Jason On Thu, Oct 20, 2011 at 5:38 AM, patrick zandi remedy...@gmail.comwrote: ** ok, it finished: I ran it over night// had several warnings.. but no failures.. off to the logs.. total time :: 7.5 hours On Wed, Oct 19, 2011 at 3:09 PM, strauss stra...@unt.edu wrote: ** My installs are failing after only 70 or 80 minutes. I cleaned up the first defect and it has now failed on another. Apparently SP2 depends on things that failed to happen properly during my 7.6.03 upgrades from earlier versions, so it is unable to complete. Nothing here to instill confidence for planning a rapid move to SP2 in the production environment. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Wednesday, October 19, 2011 1:56 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** OK back at it again::: According to Support::: so now I am asking again::: ENV: 64 cpu's 32 gig of ram How many hours is the task update suppose to take? 6 - 8 - 12 - 24 hours? Cause were over 5 already.. On Tue, Oct 18, 2011 at 6:11 PM, Patrick Zandi remedy...@gmail.com wrote: So they broke it twice ! Lol Sent from my iPhone so typo's or funky words can and do happen! On Oct 18, 2011, at 6:02 PM, strauss stra...@unt.edu wrote: ** BMC Support indicates that there is a known defect with a view ID that basically prevents the ITSM SP2 installer from completing successfully. It looks like it will affect all of my available environments. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *strauss *Sent:* Tuesday, October 18, 2011 1:43 PM *To:* arslist@ARSLIST.ORG *Subject:*
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
Okay, 5 hours for ITSM 7.6.04 SP2 on an SP1 test system. The install succeeded, but on restart the logs are filling up with this error, even after a reboot: Thu Oct 20 15:50:23 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:23 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:39 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : FTS Plugin is not available -- will retry connection. (ARERR 685) The FTS entry in ar.cfg is NOT different from before: Server-Plugin-Alias: ARSYS.ARF.FTS ARSYS.ARF.FTS itsmt01.unt.edu:9998 The FTS entry in the armonitor.cfg is only slightly different: C:\Program Files\Java\jre6\bin\java -Xms1024m -Xmx3072m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem -m Versus old version: C:\Program Files\Java\jre6\bin\java -Xmx512m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem -m It picked up a -Xmx3072m parameter... Fun, fun, fun! I shut it down for now. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Thursday, October 20, 2011 3:09 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _supposed_ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. - which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging - until SP2. The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we'll see how long it takes, but this is on a low powered VM and isn't a good measure of what it will take on production grade equipment. From what you're saying, Pat, it doesn't do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Thursday, October 20, 2011 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went over 6%... had tons of ram too... not sure what the answer is ? BMC Engineering might have a better clue... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
I think that is why BMC is starting to promote the idea of doing the time consuming work on a staging server and then promoting that to production in a shorter outage window. It is an upgrade, just on an offline system then do a delta sync of the data to bring it up-to-date. Since this environment is very lightly used I skipped creating two more environments for upgrade and reference and took the 48 hour downtime (because I could at the time). On Thu, Oct 20, 2011 at 12:48 PM, patrick zandi remedy...@gmail.com wrote: ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went over 6%... had tons of ram too... not sure what the answer is ? BMC Engineering might have a better clue... On Thu, Oct 20, 2011 at 3:25 PM, Jason Miller jason.mil...@gmail.comwrote: ** Congratulations! Could somebody from BMC explain what is happening during this time where nothing appears to be happening? I remember having the same experience during the 7.5 to 7.6.04 SP1 upgrade. The logs do not indicate that anything is happening and a db trace shows very little activity. You just have to hold your breath, have faith and hope for the best. Below is a snippet of our production upgrade notes the times of each install. Fortunately I was able to take the system down for two days because we only had three people using this new system for production data (contracts). We finished just a hair past our 9 AM time to return to production (I got lucky). Run ARSystem_7604SP1_Windows (5/25/2011 14:02 - 16:00) • A handful of errors: § arerror.log § Wed May 25 15:01:05 2011 390600 : Could not find or read the tags file. (ARNOTE 452) § Wed May 25 15:01:05 2011 C:\Program Files\Common Files\AR System\Licenses\servername\arsystem.tag § Wed May 25 15:02:03 2011 390600 : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) § Wed May 25 15:02:02 2011 390600 : Creation of an application form failed. (ARERR 4550) § An error regarding the email engine. Run atrium7604SP1.win (5/25/2011 23:17 - 5/26/2011 13:21) • RIK hung at 00:23, acknowledged and process started again at 08:03 • Finished without further error • The issues in test with Active Link guides after Atrium Core did not happen in production • Create Windows symbolic link to account for AIE directory change § mklink /J D:\Program Files (x86)\BMC Software\AtriumCore\aie\service D:\Program Files (x86)\BMC Software\AtriumCore\aie\service64 Run BMCRemedyITSMSuite7604SP1.windows (5/26/2011 14:00 - 5/27/2011 07:33) Run ServiceLevelManagement7.6.04.SP1.windows (5/27/2011 08:07 - 09:02) Run BmcRkm7604SP1.windows (5/29/2001 23:30 - 5/30/2011 02:04) Run atriumintegrator7604SP1.client_server.win / atriumintegrator7604.server.win (6/4/2011 20:56 - 21:30) Jason On Thu, Oct 20, 2011 at 5:38 AM, patrick zandi remedy...@gmail.comwrote: ** ok, it finished: I ran it over night// had several warnings.. but no failures.. off to the logs.. total time :: 7.5 hours On Wed, Oct 19, 2011 at 3:09 PM, strauss stra...@unt.edu wrote: ** My installs are failing after only 70 or 80 minutes. I cleaned up the first defect and it has now failed on another. Apparently SP2 depends on things that failed to happen properly during my 7.6.03 upgrades from earlier versions, so it is unable to complete. Nothing here to instill confidence for planning a rapid move to SP2 in the production environment. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Wednesday, October 19, 2011 1:56 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** OK back at it again::: According to Support::: so now I am asking again::: ENV: 64 cpu's 32 gig of ram How many hours is the task update suppose to take? 6 - 8 - 12 - 24 hours? Cause were over 5 already.. On Tue, Oct 18, 2011 at 6:11 PM, Patrick Zandi remedy...@gmail.com wrote: So they broke it twice ! Lol Sent from my iPhone so typo's or funky words can and do happen! On Oct 18, 2011, at 6:02 PM, strauss stra...@unt.edu wrote: ** BMC
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
Chris fts is a required licensed for this version right: could that be it? It is from the RKM. Mod. Sent from my iPhone so typo's or funky words can and do happen! On Oct 20, 2011, at 5:04 PM, strauss stra...@unt.edu wrote: ** Okay, 5 hours for ITSM 7.6.04 SP2 on an SP1 test system. The install succeeded, but on restart the logs are filling up with this error, even after a reboot: Thu Oct 20 15:50:23 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:23 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:39 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : FTS Plugin is not available -- will retry connection. (ARERR 685) The FTS entry in ar.cfg is NOT different from before: Server-Plugin-Alias: ARSYS.ARF.FTS ARSYS.ARF.FTS itsmt01.unt.edu:9998 The FTS entry in the armonitor.cfg is only slightly different: C:\Program Files\Java\jre6\bin\java -Xms1024m -Xmx3072m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m Versus old version: C:\Program Files\Java\jre6\bin\java -Xmx512m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m It picked up a -Xmx3072m parameter… Fun, fun, fun! I shut it down for now. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Thursday, October 20, 2011 3:09 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _supposed_ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. – which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging – until SP2. The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we’ll see how long it takes, but this is on a low powered VM and isn’t a good measure of what it will take on production grade equipment. From what you’re saying, Pat, it doesn’t do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Thursday, October 20, 2011 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went over 6%... had tons of ram too... not
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
RKM is on there and FTS _was_ working until ITSM SP2; there were no errors after applying SP2 to ARS (which includes FTS) or Atrium. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Patrick Zandi Sent: Thursday, October 20, 2011 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Chris fts is a required licensed for this version right: could that be it? It is from the RKM. Mod. Sent from my iPhone so typo's or funky words can and do happen! On Oct 20, 2011, at 5:04 PM, strauss stra...@unt.edumailto:stra...@unt.edu wrote: ** Okay, 5 hours for ITSM 7.6.04 SP2 on an SP1 test system. The install succeeded, but on restart the logs are filling up with this error, even after a reboot: Thu Oct 20 15:50:23 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:23 2011 itsmt01.unt.eduhttp://itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:39 2011 itsmt01.unt.eduhttp://itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : FTS Plugin is not available -- will retry connection. (ARERR 685) The FTS entry in ar.cfg is NOT different from before: Server-Plugin-Alias: ARSYS.ARF.FTS ARSYS.ARF.FTS itsmt01.unt.edu:9998 The FTS entry in the armonitor.cfg is only slightly different: C:\Program Files\Java\jre6\bin\java -Xms1024m -Xmx3072m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m Versus old version: C:\Program Files\Java\jre6\bin\java -Xmx512m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m It picked up a -Xmx3072m parameter… Fun, fun, fun! I shut it down for now. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Thursday, October 20, 2011 3:09 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _supposed_ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. – which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging – until SP2. The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we’ll see how long it takes, but this is on a low powered VM and isn’t a good measure of what it will take on production grade equipment. From what you’re saying, Pat, it doesn’t do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Thursday, October 20, 2011 2:49 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most
Re: How to get the Users's license? [I]
With 7.5, only glewf and gle work with that ardbc plugin. Ge does not work. The devs only implemented what they needed for their purposes. On Oct 20, 2011 12:12 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Doug, It all depends on which calls that specific ARDBC-plugin has implemented. When I played around with these things quite some time ago, it turned out that the GetListEntry-call used in Set-Fields was NOT implemented, but the GetListEntryWithFields-call was. This is the reason for my recommendation earlier. Another thing to note is that all fields may not be searchable in an ARDBC-form, this also depends on how the functions has been implemented in the plugin. BMC usually only implements the calls/search-fields needed at the moment. So Kerry, please go ahead and try the Set-Fields version, and let us know how it works out. Another issue with Active-Link Set-Fields are that they issue different calls in different versions of the AR System, and also behaves differently between Mid-Tier and the Windows-client... But a filter-set-fields should always work in the same way. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Kerry, Just to take this one step further. If you have a table field, that means you are searching a form. If you can change the qualifier of the table, that means that is a search criteria for the form. So, you could use a Set Fields operation to just pull back the data directly to a field rather than having to have a table field and then walk it to get the information. This may be a further simplification of the work you need to do. Just an idea in case it is useful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Thursday, October 20, 2011 2:29 AM To: arslist@ARSLIST.ORG Subject: Re: How to get the Users's license? [I] Sorry - I was referring to Paul's message. BUT - you did solve my problem!! So, I copied the table field from 'AR System Administration: Manage User Licences' and put it on the form where I want to find the users's licence. I removed all the columns except 'Write Licence'. I set the table qualification to: ('licuserinfolicensecategory' = 0) AND ('licuserinfocurrentregdtype' = 0) AND ('licuserinfolictype' = 0) AND ('licuserinfousername' = $USER$) Hey presto - I can refresh that table and at any point find the current user's licence! Thanks Misi! Kerry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
The hardware size appears to have little to do with the install times. Of course there is some type of relation between hardware and time but I can't figure it out. In our case the production db is a physical server with 24 cores and 48 gb of ram and test is a VM with 4 CPUs assigned and 8 gb of ram. The production app server is a VM with 2 cores and 6 gb of ram and test is a VM with 2 cores and 4 gb of ram. There is a little more data in the production db vs. the test db. I would think this would fairly negligible since both were not really being used. I scheduled our production outage for 48 hours (with a little extra time) based on the time it took to perform the same steps in test with the additional step of running BPCU (I skipped this in production since we had about 6 custom/modified objects that I converted manually). Test took a little less than 48 hours and this included ironing out the process and had the extra BPCU time. I was pretty certain upgrading production would be much faster. It turns out that it took production longer than a lighter weight test environment. Jason On Thu, Oct 20, 2011 at 1:09 PM, strauss stra...@unt.edu wrote: ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: ** ** Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _*supposed*_ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. ** ** Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. – which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging – until SP2. ** ** The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we’ll see how long it takes, but this is on a low powered VM and isn’t a good measure of what it will take on production grade equipment. From what you’re saying, Pat, it doesn’t do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Thursday, October 20, 2011 2:49 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went over 6%... had tons of ram too... not sure what the answer is ? BMC Engineering might have a better clue... On Thu, Oct 20, 2011 at 3:25 PM, Jason Miller jason.mil...@gmail.com wrote: ** Congratulations! Could somebody from BMC explain what is happening during this time where nothing appears to be happening? I remember having the same experience during the 7.5 to 7.6.04 SP1 upgrade. The logs do not indicate that anything is happening and a db trace shows very little activity. You just have to hold your breath, have faith and hope for the best. Below is a snippet of our production upgrade notes the times of each install. Fortunately I was able to take the system down for two days because we only had three people using this new system for production data (contracts). We finished just a hair past our 9 AM time to return to production (I got lucky). Run ARSystem_7604SP1_Windows (5/25/2011 14:02 - 16:00) • A handful of errors: § arerror.log § Wed May 25 15:01:05 2011 390600 : Could not find or read the tags file. (ARNOTE 452) § Wed May 25 15:01:05 2011 C:\Program Files\Common Files\AR System\Licenses\servername\arsystem.tag § Wed May 25 15:02:03 2011 390600 : The value(s) for this entry
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
I remember seeing a lot of plug-in server time out error too when we went to 7.6.04 SP1. On Thu, Oct 20, 2011 at 2:04 PM, strauss stra...@unt.edu wrote: ** Okay, 5 hours for ITSM 7.6.04 SP2 on an SP1 test system. ** ** The install succeeded, but on restart the logs are filling up with this error, even after a reboot: ** ** Thu Oct 20 15:50:23 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:23 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:39 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : FTS Plugin is not available -- will retry connection. (ARERR 685) ** ** The FTS entry in ar.cfg is NOT different from before: Server-Plugin-Alias: ARSYS.ARF.FTS ARSYS.ARF.FTS itsmt01.unt.edu:9998 ** ** The FTS entry in the armonitor.cfg is only slightly different: ** ** C:\Program Files\Java\jre6\bin\java -Xms1024m -Xmx3072m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m ** ** Versus old version: C:\Program Files\Java\jre6\bin\java -Xmx512m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m ** ** It picked up a -Xmx3072m parameter… ** ** Fun, fun, fun! I shut it down for now. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *strauss *Sent:* Thursday, October 20, 2011 3:09 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: ** ** Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _*supposed*_ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. ** ** Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. – which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging – until SP2. ** ** The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we’ll see how long it takes, but this is on a low powered VM and isn’t a good measure of what it will take on production grade equipment. From what you’re saying, Pat, it doesn’t do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. ** ** Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *patrick zandi *Sent:* Thursday, October 20, 2011 2:49 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** ** ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went
remove
___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
I have seen this as well Sent from my iPhone so typo's or funky words can and do happen! On Oct 20, 2011, at 6:03 PM, Jason Miller jason.mil...@gmail.com wrote: ** I remember seeing a lot of plug-in server time out error too when we went to 7.6.04 SP1. On Thu, Oct 20, 2011 at 2:04 PM, strauss stra...@unt.edu wrote: ** Okay, 5 hours for ITSM 7.6.04 SP2 on an SP1 test system. The install succeeded, but on restart the logs are filling up with this error, even after a reboot: Thu Oct 20 15:50:23 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:23 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : Cannot establish a network connection to the AR System Plug-In server (ARERR 8760) Thu Oct 20 15:50:39 2011 itsmt01.unt.edu (9998) ARSYS.ARF.FTS : RPC: Miscellaneous tli error - System error (Connection refused) Thu Oct 20 15:50:39 2011 390602 : FTS Plugin is not available -- will retry connection. (ARERR 685) The FTS entry in ar.cfg is NOT different from before: Server-Plugin-Alias: ARSYS.ARF.FTS ARSYS.ARF.FTS itsmt01.unt.edu:9998 The FTS entry in the armonitor.cfg is only slightly different: C:\Program Files\Java\jre6\bin\java -Xms1024m -Xmx3072m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m Versus old version: C:\Program Files\Java\jre6\bin\java -Xmx512m -classpath D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\fts;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr;D:\Program Files (x86)\BMC Software\ARSystem\pluginsvr\arpluginsvr7604_build002.jar com.bmc.arsys.pluginsvr.ARPluginServerMain -x ITSMT01 -i D:\Program Files (x86)\BMC Software\ARSystem –m It picked up a -Xmx3072m parameter… Fun, fun, fun! I shut it down for now. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of strauss Sent: Thursday, October 20, 2011 3:09 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _supposed_ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. – which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging – until SP2. The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we’ll see how long it takes, but this is on a low powered VM and isn’t a good measure of what it will take on production grade equipment. From what you’re saying, Pat, it doesn’t do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Thursday, October 20, 2011 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue...
Re: ARS 7.6.04 SP2 Solaris installer Oracle db.
You may want to compare the data in the system between your test and prod envs. I'm not a DBA, but what I've seen seems to be that the more rows in your db that need to have columns added / changed / etc, the longer it takes. - Original Message - From: Jason Miller jason.mil...@gmail.com To: arslist@ARSLIST.ORG Sent: Thursday, October 20, 2011 6:01:43 PM Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** The hardware size appears to have little to do with the install times. Of course there is some type of relation between hardware and time but I can't figure it out. In our case the production db is a physical server with 24 cores and 48 gb of ram and test is a VM with 4 CPUs assigned and 8 gb of ram. The production app server is a VM with 2 cores and 6 gb of ram and test is a VM with 2 cores and 4 gb of ram. There is a little more data in the production db vs. the test db. I would think this would fairly negligible since both were not really being used. I scheduled our production outage for 48 hours (with a little extra time) based on the time it took to perform the same steps in test with the additional step of running BPCU (I skipped this in production since we had about 6 custom/modified objects that I converted manually). Test took a little less than 48 hours and this included ironing out the process and had the extra BPCU time. I was pretty certain upgrading production would be much faster. It turns out that it took production longer than a lighter weight test environment. Jason On Thu, Oct 20, 2011 at 1:09 PM, strauss stra...@unt.edu wrote: ** I restored my test/sample data system back to where ITSM was still SP1 (ARS and Atrium at SP2) and performed two manual interventions before kicking off ITSM 7.6.04 SP2 again: Delete join form VIS:Status_Stage_Flow_TransitionRulesLookup which is carrying an outdated View ID for the Default Administrator View (the only view present) I am told that this was _ supposed _ to have been changed in the upgrade to 7.6.03, but none of my systems reflect that change. Delete all existing records in DLD:SYS:DataLoadStatus that were preventing SP2 from creating a unique index on InstanceId There were 126 old records in there with GUIDs that are NOT UNIQUE on a case-insensitive system (SQL Server). Looking at the production system which had no records in that form, it actually looks like the unique index was created by the upgrade to 7.6.04. – which is when I have been told it was introduced. Somehow, my test system got past that and SP1 both without the installation hanging – until SP2. The installation of ITSM 7.6.04 SP2 has been running since 10:30 AM; we’ll see how long it takes, but this is on a low powered VM and isn’t a good measure of what it will take on production grade equipment. From what you’re saying, Pat, it doesn’t do very well on MUCH higher-powered servers, either. I guess the Thanksgiving holiday will be my first window of opportunity for applying a service pack that runs for hours and hours and hours to the production environment. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of patrick zandi Sent: Thursday, October 20, 2011 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.6.04 SP2 Solaris installer Oracle db. ** Yeah::: Upgrades look like they are going to disappear for the create a new server and migrate data option soon. Most change windows: especially Enterprise wise:: could they really go down for 5-7 hours? NO! not happening.. so My guess is there is some sort of single FIFO job process single Java thread into the server needs to be change to something a little more robust. don't know what the answer is.. but I can see this as an issue... I have 64 CPU's and it took forever.. cpu never went over 6%... had tons of ram too... not sure what the answer is ? BMC Engineering might have a better clue... On Thu, Oct 20, 2011 at 3:25 PM, Jason Miller jason.mil...@gmail.com wrote: ** Congratulations! Could somebody from BMC explain what is happening during this time where nothing appears to be happening? I remember having the same experience during the 7.5 to 7.6.04 SP1 upgrade. The logs do not indicate that anything is happening and a db trace shows very little activity. You just have to hold your breath, have faith and hope for the best. Below is a snippet of our production upgrade notes the times of each install. Fortunately I was able to take the system down for two days because we only had three people using this new system for production data (contracts). We finished just a hair past our 9 AM time to return to production (I got lucky). Run
Re: How to get the Users's license? [I]
Hi, Yes, my memory was a little bit mixed up... In ARDBC you typically implement these two functions: 1. ARDBCGetListEntryWithFields - for searching entries 2. ARDBCGetEntry - for retrieving one complete entry with all fields As BMC only wanted to show a list, the ARDBCGetEntry was not really needed. But if you want to do a Set-Fields, both of these calls needs to be implemented. As a Set-Field first searches using ARDBCGetListEntryWithFields, and then retrieves the selected/first record using ARDBCGetEntry. So do you know how it is in this particular case? Have they added ARDBCGetEntry in version after 7.5? Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. With 7.5, only glewf and gle work with that ardbc plugin. Ge does not work. The devs only implemented what they needed for their purposes. On Oct 20, 2011 12:12 PM, Misi Mladoniczky m...@rrr.se wrote: Hi Doug, It all depends on which calls that specific ARDBC-plugin has implemented. When I played around with these things quite some time ago, it turned out that the GetListEntry-call used in Set-Fields was NOT implemented, but the GetListEntryWithFields-call was. This is the reason for my recommendation earlier. Another thing to note is that all fields may not be searchable in an ARDBC-form, this also depends on how the functions has been implemented in the plugin. BMC usually only implements the calls/search-fields needed at the moment. So Kerry, please go ahead and try the Set-Fields version, and let us know how it works out. Another issue with Active-Link Set-Fields are that they issue different calls in different versions of the AR System, and also behaves differently between Mid-Tier and the Windows-client... But a filter-set-fields should always work in the same way. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Kerry, Just to take this one step further. If you have a table field, that means you are searching a form. If you can change the qualifier of the table, that means that is a search criteria for the form. So, you could use a Set Fields operation to just pull back the data directly to a field rather than having to have a table field and then walk it to get the information. This may be a further simplification of the work you need to do. Just an idea in case it is useful, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kerry Murdock Sent: Thursday, October 20, 2011 2:29 AM To: arslist@ARSLIST.ORG Subject: Re: How to get the Users's license? [I] Sorry - I was referring to Paul's message. BUT - you did solve my problem!! So, I copied the table field from 'AR System Administration: Manage User Licences' and put it on the form where I want to find the users's licence. I removed all the columns except 'Write Licence'. I set the table qualification to: ('licuserinfolicensecategory' = 0) AND ('licuserinfocurrentregdtype' = 0) AND ('licuserinfolictype' = 0) AND ('licuserinfousername' = $USER$) Hey presto - I can refresh that table and at any point find the current user's licence! Thanks Misi! Kerry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are