Re: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction
$GROUPS$ is shaped like this: ;Administrator;1002442300; So groups always start and end by semicolon. But my recommendation is NOT to use the $GROUP$ clause, but to provide permissions to the AL and forms. Menu will inherits the permissions of the forms. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 04:40, gok's gmedise...@yahoo.com wrote: Hi John, I will try this string and let me test and let me reply here as soon as possible. Thanks G John Sundberg wrote: Just wondering - what if your group is at the beginning? Or - at the end…. $GROUPS$ like %;100140;% I think the above query assumes your group is in the middle of a group list? So - you would have to do something like: $GROUPS$ like %;100140;% OR $GROUPS$ like 100140;% OR $GROUPS$ like %;100140 I am not positive -- just mentioning… I did do something similar to this recently - and I did have to consider the case I mentioned. -John On Mon, Mar 12, 2012 at 8:10 PM, gok's gmedise...@yahoo.com wrote: I have fixed this now all the values are showing up. What i did was like this i have give as Jose said $GROUPS$ like %;100140;% and also gave the $GROUPS$ like %;100140;% in menus. it is working showing all the values. gok's wrote: Environment ARServer 7.5 patch 4 DB:2005 SQL I have created a simple active link for certain group like XYZ changes a search menu values to read/write only A.l Display Qualification:$GROUPS$ like XYZ IfAction:Change Field Read/Write mode it is working for the group but in the search menu there are no values are showing up . The user's who are in this group are not Adminstrators they are having Infra Change Manager,Task Manager,application level permissions like that . can any one guide me am I missing any thing. Thanks -- View this message in context: http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-menus.can-some-guide-me-in-right-direction-tp33476035p33491582.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *Recipient of: **WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- View this message in context: http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-menus.can-some-guide-me-in-right-direction-tp33476035p33491920.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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 image002.jpgimage004.jpgimage001.jpgimage003.jpg
Re: CMDB 7.6.04 SP2 Error
rant So...anyone have any idea on when CMDB 7.6.04 SP3 is being released? I see that the Remedy Server Sp3 has been released which is great...however it doesnt solve this problem. And for the life of me I cannot find out when BMC plan (or if they even are going to ) to release CMDB 7.6.40 SP3. Our Support partner also cannot find out. I honestly cannot wait for the next visit from a BMC representative so that I can ask them to please explain to me how they expect us to plan our roadmap, upgrades as well as resolve important bugs when they will not let us know when a patch is expected. This error that we have is forcing us to keep delaying our upgrade to 7.6.04 as we are waiting for SP3 and is giving Remedy such a bad name it is past being funny. All the work that we have done to build this product up as a reliable, fast solution is going out the window. /rant On Thu, Feb 2, 2012 at 8:23 PM, Basil Webster ba...@remex.co.za wrote: ** Hi, ** ** I know it’s a little late but we logged an issue about a month ago referencing the SW mentioned below. I immediately got a reply saying that we should wait for SP3 but they could not provide a date. Long story short, I escalated this via our partner support and received an mail today saying that they hope to have SP3 out by March but are looking into a special release to SP2 before then. ** ** I suggest you log that ticket asking for the special release. ** ** * * *Regards,* * * * * *Basil Webster *| *Support Manager *| *Remex Group* *Email**: **ba...@remex.co.za *| www.remex.co.za *Tel: +27 (0) 12 756 4227/8 *| *Cell: +27 (0) 82 452 9389 *| *Fax: +27 (0) 86 540 9224 *| *Centurion Close* | *Suite 2C* | *119 Gerhard Street *| *Centurion CBD* | *South Africa* | ** ** [image: Description: Description: Description: Description: Description: REMEX GROUP - White Background - 30] ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *BradRemedy *Sent:* 12 January 2012 02:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: CMDB 7.6.04 SP2 Error ** ** ** Hi Mark Thanks for that Just had a look and it does seem to be related. Dont suppose anyone has any idea on when SP3 is being released? The only other thing I can try is to use SP1 and see if the same error occurs. At the end of the day we would prefer not to have to wait months for SP3 as it will delay our upgrade plans we have for the year - and we havent even start with ITSM and SRM yet :-(. On Thu, Jan 12, 2012 at 2:25 PM, Walters, Mark mark_walt...@bmc.com wrote: ** There’s a very similar looking defect that looks likely to be fixed in 7.6.04 SP3. I suggest you open an issue with BMC and reference defect SW00416229, support should be able to confirm whether it’s the same problem. Mark *I work for BMC, I don’t speak for them* *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *BradRemedy *Sent:* 12 January 2012 11:54 *To:* arslist@ARSLIST.ORG *Subject:* CMDB 7.6.04 SP2 Error ** Hi We have run into a wierd error that we cannot find any reference to on the ARSList, Manuals or Support web. Hopefully someone here can offer some suggestions on what we can try next as we are quickly running out of ideas and have tried this upgrade a few times. Firstly some background information. We have a Test server running Windows Server 2008 Enterprise with a seperate DB Server running SQL 2008. We also have a third server acting as a Mid Tier server also running Windows Server 2008. We are testing our upgrade strategy on upgrading from ARS Core 7.5 Patch 003, CMDB 7.6 Patch 001 to ARS Core 7.6.04 SP2 and CMDB 7.6.04 SP2. We are also running ITSM 7.6 and SRM 7.6 Patch 001 however these 2 applications will only be upgraded at a later stage and we want to leave them on their current versions. Now, we have run the Upgrade for ARS core to 7.6.04 SP2 with no errors. Every looks and works as expected. We then ran the ugprade for CMDB to 7.6.04 SP2 which also completed successfully. The mid tier server is also ugprade to 7.6.04 SP2 and all applications (Incident, Problem, Change, SRM) are working correctly, with the exception to this one problem. When we click on any CI in the Asset Management Application and click on the *Explore CI*' option, the BMC Atrium Explorer opens and attempts to load some screens - however we then get this error - Error when calling getRelatedComponentsAndRelationshipsOverlay https://communities.bmc.com/communities/servlet/JiveServlet/showImage/2-220993-25778/Error.jpg https://communities.bmc.com/communities/servlet/JiveServlet/showImage/2-220993-25778/Error.jpg Any suggestions or advice on where we
Re: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction
Hi John, Interesting that you say this. I saw an issue where an ITSM 6 had its ARS upgraded to 7.1 and this issue popped up as prior to 7.1 the groups values were as you describe (but not on every record!). Problem was fixed with a 5 minute Meta-Update script to update said records into the correct format. Since 7.1, ARS enforces the group list fields syntax so that %;x;% will work. Cheers Ben Chernys http://www.softwaretoolhouse.com www.softwaretoolhouse.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: March-13-12 03:27 To: arslist@ARSLIST.ORG Subject: Re: Using $GROUPS$ like not showing data in search menus.can some guide me in right direction ** Just wondering - what if your group is at the beginning? Or - at the end.. $GROUPS$ like %;100140;% I think the above query assumes your group is in the middle of a group list? So - you would have to do something like: $GROUPS$ like %;100140;% OR $GROUPS$ like 100140;% OR $GROUPS$ like %;100140 I am not positive -- just mentioning. I did do something similar to this recently - and I did have to consider the case I mentioned. -John On Mon, Mar 12, 2012 at 8:10 PM, gok's gmedise...@yahoo.com wrote: I have fixed this now all the values are showing up. What i did was like this i have give as Jose said $GROUPS$ like %;100140;% and also gave the $GROUPS$ like %;100140;% in menus. it is working showing all the values. gok's wrote: Environment ARServer 7.5 patch 4 DB:2005 SQL I have created a simple active link for certain group like XYZ changes a search menu values to read/write only A.l Display Qualification:$GROUPS$ like XYZ IfAction:Change Field Read/Write mode it is working for the group but in the search menu there are no values are showing up . The user's who are in this group are not Adminstrators they are having Infra Change Manager,Task Manager,application level permissions like that . can any one guide me am I missing any thing. Thanks -- View this message in context: http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-men us.can-some-guide-me-in-right-direction-tp33476035p33491582.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.com http://www.kineticdata.com/ www.kineticdata.com I http://community.kineticdata.com/ community.kineticdata.com _attend WWRUG12 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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%
Here is the list from ITSM 7.6.03p002 CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin CTM:People CTM:People Attachments CTM:People Attributes CTM:People Audit CTM:People Benefit Info CTM:People Education CTM:People HR Attendance Mgmt CTM:People HR Time Management CTM:People IT Skills CTM:People LookUp CTM:People Management Console CTM:People Organization CTM:People Organization Search CTM:People Permission Groups CTM:People Profile CTM:People Search CTM:People Search-Supp. Staff CTM:People Template CTM:People Template NTE CTM:People Template PG CTM:People Template SG CTM:People Template SG Lookup CTM:People Travel Profile CTM:People Wallet CTM:People WorkLog CTM:PeopleITSkillsJoin CTM:PeoplePermissionGrpUnique CTM:PeoplePermissionJoin CTM:PeoplePermissionJoin_PMC CTM:PeopleSelfJoin CTM:PeopleSyncConsole CTM:PeopleUser CTM:PeopleUserSupportGroupFunctionalRole CTM:People_Template_Child CTM:People_Template_SFR CTM:People_Template_SFR_Lookup On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: ** I do not have a vanilla system to compare our moderately customized system with and I know for a fact there are some new custom forms created for integration purposes to LDAP, that begin with CTM:PPL and although for the most part the past developers have post fixed new custom forms with the abbreviation of the site name, I do not want to assume that’s been the case consistently.. So could someone help me with a list of all forms that begin with CTM:Ppl or CTM:PPL that are out of the box?? Joe _attend WWRUG12 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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%
For the 7.6.04 list, I refer you to Software Tool House’s Freebies page: www.softwaretoolhouse.com For 7.6.03 or other servers, simply fill out a Meta-Update trial request, participate in the “Live Install” service and presentation (under 1 hr.), and then generate the form and field spreadsheets for your ARS server (which will include your customisations). From the posting to the list of Tue, 2012-Feb-21: Hi Folks, A lot of you have asked for fields and labels of ITSM. To help out, we’re offering a free Excel 2010 Spreadsheet taken from a Pre-configured Stack Installed ITSM 7.6.04. As you all know, ITSM is big, some 235,000 fields. We’ve made the original CSV files also available to you. This will allow you to take slices (say by form name or prefix) when you are running previous Excel releases. Instructions for this are included. Please check out the new “Freebies” section of our web http://www.softwaretoolhouse.com www.softwaretoolhouse.com and get the ITSM 7.6.04 Schema and Fields spreadsheet. The spreadsheet was generated using Meta-Schema with the English locale and selecting the Default Views for the field labels. Field labels are used in Queries and are view dependent. All Meta-Update utilities accept ARS Field Names as well as labels and ids in query qualifications. There are duplicates as well as fields not in view. Meta-Schema is bundled with Meta-Update. If you want to run the utility against your server, please request a Meta-Update trial. We sincerely hope you use and this spreadsheet. Cheers Ben Chernys Senior Software Architect Description: Description: logoSthInc-sm Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: March-13-12 08:15 To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL% ** Here is the list from ITSM 7.6.03p002 CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin CTM:People CTM:People Attachments CTM:People Attributes CTM:People Audit CTM:People Benefit Info CTM:People Education CTM:People HR Attendance Mgmt CTM:People HR Time Management CTM:People IT Skills CTM:People LookUp CTM:People Management Console CTM:People Organization CTM:People Organization Search CTM:People Permission Groups CTM:People Profile CTM:People Search CTM:People Search-Supp. Staff CTM:People Template CTM:People Template NTE CTM:People Template PG CTM:People Template SG CTM:People Template SG Lookup CTM:People Travel Profile CTM:People Wallet CTM:People WorkLog CTM:PeopleITSkillsJoin CTM:PeoplePermissionGrpUnique CTM:PeoplePermissionJoin CTM:PeoplePermissionJoin_PMC CTM:PeopleSelfJoin CTM:PeopleSyncConsole CTM:PeopleUser CTM:PeopleUserSupportGroupFunctionalRole CTM:People_Template_Child CTM:People_Template_SFR CTM:People_Template_SFR_Lookup On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: ** I do not have a vanilla system to compare our moderately customized system with and I know for a fact there are some new custom forms created for integration purposes to LDAP, that begin with CTM:PPL and although for the most part the past developers have post fixed new custom forms with the abbreviation of the site name, I do not want to assume that’s been the case consistently.. So could someone help me with a list of all forms that begin with CTM:Ppl or CTM:PPL that are out of the box?? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 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 image001.jpg
Re: Remedy 7.6.04 - BRIE Timeouts
Hi, We get something along those lines when rebuilding service targets. The only way out of it is to restart arserver and then tomcat. However, we have found that if we shutdown tomcat on our first (admin) server and then trigger the rebuilds from the other server, we don't see the timeout issues. This seems to be the least disruptive way of maintaining a service to our users, but its far from ideal. Regards -MikeDate: Mon, 12 Mar 2012 15:34:40 -0400 From: christopher.j.wil...@stls.frb.org Subject: Remedy 7.6.04 - BRIE Timeouts To: arslist@ARSLIST.ORG We are implementing new 7.6.04 SP2 environments and we seem to experience BRIE timeouts sporatically on our ARS servers. The timeouts seem to be triggered by user activity, however, it does not take much activity to activate the timeouts. When timeouts are experieced, current users experience an hourglass and new users cannot login. Once the timeouts start, we must recycle the application server(s) experiencing the issue to restore service. We are experiencing this issue in our DEV, QA and PROD 7.6.04 environments. Anyone else experiencing this issue? We are also running ARS 7.5 Patch 6 with no timeout issues. Thanks, Chris Wilson ___ 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: Where does $DATE$ come from?
How many of us are waiting for someone to say... $DATE$ come from $PALMTREE$ (Due to recent time zone changes it is now Friday!) I couldn't resist, sorry. Doug -- Doug Blair Sent from my iPhone4, typographic errors likely +1-224-558-5462 On Mar 12, 2012, at 11:28 AM, Brittain, Mark mbritt...@navisite.com wrote: ** Hi All, Where does the $DATE$ function get the date/time information, the OS server or the database server. This may seem like a strange question but yesterday I had a case where $TIMESTAMP$ was work correctly and diary field entries were correct but the $DATE$ was on hour behind as 3/10/2012 23:00:00 PM. Strangely today, it working correctly as 3/12/2012 00:00:00 AM ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite – A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-317-2897 This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _attend WWRUG12 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
BMC_GLOBAL_DEFAULT_SRVC CI
Hi All, CMDB 7.6.04 SP2 The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the Infrastructure Change form. BMC tells us that this CI should never be deleted. Does anyone know precisely what it is for? I guess it's to do with the Service Catalog functionality in Atrium Core. I can set the status of this CI from its out-of-the-box value of 'Ordered' to 'End of Life' to remove it from the menu but would this affect the functionality that the CI is there to support? Cheers Peter ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC_GLOBAL_DEFAULT_SRVC CI
I love those: do not delete or remove No reason why, no solution if you accidentally did.. Gotta love it Sent from my iPhone On Mar 13, 2012, at 7:17, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: Hi All, CMDB 7.6.04 SP2 The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the Infrastructure Change form. BMC tells us that this CI should never be deleted. Does anyone know precisely what it is for? I guess it's to do with the Service Catalog functionality in Atrium Core. I can set the status of this CI from its out-of-the-box value of 'Ordered' to 'End of Life' to remove it from the menu but would this affect the functionality that the CI is there to support? Cheers Peter ___ 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: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction
Why not use the run process Application-Confirm-Group group_ID to test if they are a member of the group concerned? David Sanders Solution Architect Enterprise Service Suite @ Work / e-ServiceSuite tel +44 1494 468980 mobile +44 7710 377761 email david.sand...@westoverconsulting.co.uk web http://www.westoverconsulting.co.uk http://www.westoverconsulting.co.uk/ http://www.e-servicesuite.co.uk http://www.e-servicesuite.co.uk/ http://e-servicesuite.com/ Description: cid:image001.gif@01CCE023.38E7E320 ITIL - SaaS - On Premise From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys Sent: 13 March 2012 06:58 To: arslist@ARSLIST.ORG Subject: Re: Using $GROUPS$ like not showing data in search menus.can some guide me in right direction ** Hi John, Interesting that you say this. I saw an issue where an ITSM 6 had its ARS upgraded to 7.1 and this issue popped up as prior to 7.1 the groups values were as you describe (but not on every record!). Problem was fixed with a 5 minute Meta-Update script to update said records into the correct format. Since 7.1, ARS enforces the group list fields syntax so that %;x;% will work. Cheers Ben Chernys http://www.softwaretoolhouse.com www.softwaretoolhouse.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: March-13-12 03:27 To: arslist@ARSLIST.ORG Subject: Re: Using $GROUPS$ like not showing data in search menus.can some guide me in right direction ** Just wondering - what if your group is at the beginning? Or - at the end.. $GROUPS$ like %;100140;% I think the above query assumes your group is in the middle of a group list? So - you would have to do something like: $GROUPS$ like %;100140;% OR $GROUPS$ like 100140;% OR $GROUPS$ like %;100140 I am not positive -- just mentioning. I did do something similar to this recently - and I did have to consider the case I mentioned. -John On Mon, Mar 12, 2012 at 8:10 PM, gok's gmedise...@yahoo.com wrote: I have fixed this now all the values are showing up. What i did was like this i have give as Jose said $GROUPS$ like %;100140;% and also gave the $GROUPS$ like %;100140;% in menus. it is working showing all the values. gok's wrote: Environment ARServer 7.5 patch 4 DB:2005 SQL I have created a simple active link for certain group like XYZ changes a search menu values to read/write only A.l Display Qualification:$GROUPS$ like XYZ IfAction:Change Field Read/Write mode it is working for the group but in the search menu there are no values are showing up . The user's who are in this group are not Adminstrators they are having Infra Change Manager,Task Manager,application level permissions like that . can any one guide me am I missing any thing. Thanks -- View this message in context: http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-men us.can-some-guide-me-in-right-direction-tp33476035p33491582.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.com http://www.kineticdata.com/ www.kineticdata.com I http://community.kineticdata.com/ community.kineticdata.com _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 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 image001.gif
Re: Using $GROUPS$ like not showing data in search menus.....can some guide me in right direction
Because BMC recommends not to use process if it can be done by other workflow. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 13:06, David Sanders david.sand...@westoverconsulting.co.uk wrote: ** Why not use the run process *Application-Confirm-Group **group_ID *to test if they are a member of the group concerned? ** ** David Sanders Solution Architect *Enterprise Service Suite @ Work / e-ServiceSuite * tel +44 1494 468980 mobile +44 7710 377761 email david.sand...@westoverconsulting.co.uk web http://www.westoverconsulting.co.uk http://www.e-servicesuite.co.uk [image: Description: cid:image001.gif@01CCE023.38E7E320]http://e-servicesuite.com/ *ITIL – SaaS – On Premise* ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Ben Chernys *Sent:* 13 March 2012 06:58 *To:* arslist@ARSLIST.ORG *Subject:* Re: Using $GROUPS$ like not showing data in search menus.can some guide me in right direction ** ** ** Hi John, ** ** Interesting that you say this. ** ** I saw an issue where an ITSM 6 had its ARS upgraded to 7.1 and this issue popped up as prior to 7.1 the groups values were as you describe (but not on every record!). Problem was fixed with a 5 minute Meta-Update script to update said records into the correct format. ** ** Since 7.1, ARS enforces the group list fields syntax so that “%;x;%” will work. ** ** Cheers Ben Chernys www.softwaretoolhouse.com ** ** *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* March-13-12 03:27 *To:* arslist@ARSLIST.ORG *Subject:* Re: Using $GROUPS$ like not showing data in search menus.can some guide me in right direction ** ** ** Just wondering - what if your group is at the beginning? ** ** Or - at the end…. ** ** $GROUPS$ like %;100140;% ** ** I think the above query assumes your group is in the middle of a group list? ** ** So - you would have to do something like: ** ** $GROUPS$ like %;100140;% OR $GROUPS$ like 100140;% OR $GROUPS$ like %;100140 ** ** I am not positive -- just mentioning… ** ** I did do something similar to this recently - and I did have to consider the case I mentioned. ** ** ** ** -John ** ** ** ** On Mon, Mar 12, 2012 at 8:10 PM, gok's gmedise...@yahoo.com wrote: I have fixed this now all the values are showing up. What i did was like this i have give as Jose said $GROUPS$ like %;100140;% and also gave the $GROUPS$ like %;100140;% in menus. it is working showing all the values. gok's wrote: Environment ARServer 7.5 patch 4 DB:2005 SQL I have created a simple active link for certain group like XYZ changes a search menu values to read/write only A.l Display Qualification:$GROUPS$ like XYZ IfAction:Change Field Read/Write mode it is working for the group but in the search menu there are no values are showing up . The user's who are in this group are not Adminstrators they are having Infra Change Manager,Task Manager,application level permissions like that . can any one guide me am I missing any thing. Thanks -- View this message in context: http://old.nabble.com/Using-%24GROUPS%24-like-not-showing-data-in-search-menus.can-some-guide-me-in-right-direction-tp33476035p33491582.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ** ** -- *John Sundberg* *Kinetic Data, Inc.* *Your Business. Your Process.* *Recipient of:** WWRUG10 Best Customer Service/Support
Re: ResetKickbackCount Escalation question .... out of the box escalation seems to be updating every incident older than 31 days
I looked more into this escalation to see what it is doing and what fields that it uses and why. I found a filter (HPD:INC:SetFromResolved_Kickback) that fires when a ticket is reopened that increases the count in the Kickback count field. Then on the first of the month this escalation fire and reset everything back to zero. My best guess is that this process is used for some out of the box report. I think I'm going to recommend to just disable the escalation. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail Joe Martin D'Souza jdso...@shyle.net Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/12/2012 10:36 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** I completely agree that bypassing the application layer is never a good idea unless absolutely necessary.. the second option of a custom Last Modified Date2 set by custom workflow is a better idea as the framework of its implementation stays within the applications context. Direct SQL’s if used, MUST be used CAREFULLY. The only reason I thought of it in this case is that I’m almost 100% sure a Direct SQL when used within workflow to update a record, does not alter the Last Modified Date or Last Modified By field. It just updates what is asked to update and bypasses the application layer altogether and does not update these system fields even if the SQL was designed to update a AR record. Out of curiosity (I didn’t have the time to find out the purpose of this Escalation), what does it do? Joe From: Jose Huerta Sent: Monday, March 12, 2012 7:31 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** I think that change a set action to a direct SQL to avoid normal ARS behavior is a bad practice and you'll pay it at the future. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Mon, Mar 12, 2012 at 21:25, Joe Martin D'Souza jdso...@shyle.net wrote: Three may be a workaround provided HPD:INC:ResetKickbackCount does not trigger any filters that sets other fields.. Instead of the set field operation use Direct SQL in the Escalation. Direct SQL's will not touch the Last Modified Date to the best of my knowledge. The side effect is that they will not trigger any workflow either set for modify action of a filter. You could try UPDATE KickBack_Count from HPD:Help_Desk where Entry_ID = $1$ z1D Action is a display only field which is set to RESETKICKBACK, so you would need to check all the filters that run on Escalations that get triggered on this value of z1D Action, and see if those actions can be replicated by direct SQL's too.. That way you could potentially modify the record without touching the Last Modified Date. ALTERNATELY, created a Last Modified Date2 field that gets set on Modifications only when the user is not AR_ESCALATOR. Joe -Original Message- From: John Atherly Sent: Monday, March 12, 2012 3:13 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: HPD:INC:ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days I have a report the looks for all Incidents modified in the last 10 days that runs and the escalation called HPD:INC:ResetKickbackCount is killing my report since it modifies all incidents. Does anyone know any thing about kick back. __ This email has been scanned by the Symantec Email Security.cloud service. __ _attend WWRUG12 www.wwrug.com
Question: oracle clob in a row scenario
Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: CMDB 7.6.04 SP2 Error
I kinda got the idea was that sp3 is core only.. period.. I also got the idea they were focused on 7.7, \but I would love to hear otherwise.. Silence is not golden... It's nerve racking.. 8-P On Tue, Mar 13, 2012 at 2:52 AM, BradRemedy bradrem...@gmail.com wrote: ** rant So...anyone have any idea on when CMDB 7.6.04 SP3 is being released? I see that the Remedy Server Sp3 has been released which is great...however it doesnt solve this problem. And for the life of me I cannot find out when BMC plan (or if they even are going to ) to release CMDB 7.6.40 SP3. Our Support partner also cannot find out. I honestly cannot wait for the next visit from a BMC representative so that I can ask them to please explain to me how they expect us to plan our roadmap, upgrades as well as resolve important bugs when they will not let us know when a patch is expected. This error that we have is forcing us to keep delaying our upgrade to 7.6.04 as we are waiting for SP3 and is giving Remedy such a bad name it is past being funny. All the work that we have done to build this product up as a reliable, fast solution is going out the window. /rant On Thu, Feb 2, 2012 at 8:23 PM, Basil Webster ba...@remex.co.za wrote: ** Hi, ** ** I know it’s a little late but we logged an issue about a month ago referencing the SW mentioned below. I immediately got a reply saying that we should wait for SP3 but they could not provide a date. Long story short, I escalated this via our partner support and received an mail today saying that they hope to have SP3 out by March but are looking into a special release to SP2 before then. ** ** I suggest you log that ticket asking for the special release. ** ** * * *Regards,* * * * * *Basil Webster *| *Support Manager *| *Remex Group* *Email**: **ba...@remex.co.za *| www.remex.co.za *Tel: +27 (0) 12 756 4227/8 *| *Cell: +27 (0) 82 452 9389 *| *Fax: +27 (0) 86 540 9224 *| *Centurion Close* | *Suite 2C* | *119 Gerhard Street *| *Centurion CBD*| *South Africa* | ** ** [image: Description: Description: Description: Description: Description: REMEX GROUP - White Background - 30] ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *BradRemedy *Sent:* 12 January 2012 02:58 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: CMDB 7.6.04 SP2 Error ** ** ** Hi Mark Thanks for that Just had a look and it does seem to be related. Dont suppose anyone has any idea on when SP3 is being released? The only other thing I can try is to use SP1 and see if the same error occurs. At the end of the day we would prefer not to have to wait months for SP3 as it will delay our upgrade plans we have for the year - and we havent even start with ITSM and SRM yet :-(. On Thu, Jan 12, 2012 at 2:25 PM, Walters, Mark mark_walt...@bmc.com wrote: ** There’s a very similar looking defect that looks likely to be fixed in 7.6.04 SP3. I suggest you open an issue with BMC and reference defect SW00416229, support should be able to confirm whether it’s the same problem. Mark *I work for BMC, I don’t speak for them* *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *BradRemedy *Sent:* 12 January 2012 11:54 *To:* arslist@ARSLIST.ORG *Subject:* CMDB 7.6.04 SP2 Error ** Hi We have run into a wierd error that we cannot find any reference to on the ARSList, Manuals or Support web. Hopefully someone here can offer some suggestions on what we can try next as we are quickly running out of ideas and have tried this upgrade a few times. Firstly some background information. We have a Test server running Windows Server 2008 Enterprise with a seperate DB Server running SQL 2008. We also have a third server acting as a Mid Tier server also running Windows Server 2008. We are testing our upgrade strategy on upgrading from ARS Core 7.5 Patch 003, CMDB 7.6 Patch 001 to ARS Core 7.6.04 SP2 and CMDB 7.6.04 SP2. We are also running ITSM 7.6 and SRM 7.6 Patch 001 however these 2 applications will only be upgraded at a later stage and we want to leave them on their current versions. Now, we have run the Upgrade for ARS core to 7.6.04 SP2 with no errors. Every looks and works as expected. We then ran the ugprade for CMDB to 7.6.04 SP2 which also completed successfully. The mid tier server is also ugprade to 7.6.04 SP2 and all applications (Incident, Problem, Change, SRM) are working correctly, with the exception to this one problem. When we click on any CI in the Asset Management Application and click on the *Explore CI*' option, the BMC Atrium Explorer opens and attempts to load some screens - however we then get this error - Error when calling
Re: ResetKickbackCount Escalation question .... out of the box escalation seems to be updating every incident older than 31 days
My recommendation about customizations is to add and not to delete or disable objects ( http://theremedyforit.com/2012/03/best-practices-for-customizations/ ) So I continue to recommend to create another last modified by and date fields. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 13:40, John Atherly john.athe...@schneider-electric.com wrote: ** I looked more into this escalation to see what it is doing and what fields that it uses and why. I found a filter (HPD:INC:SetFromResolved_Kickback) that fires when a ticket is reopened that increases the count in the Kickback count field. Then on the first of the month this escalation fire and reset everything back to zero. My best guess is that this process is used for some out of the box report. I think I'm going to recommend to just disable the escalation. _ * John Atherly* | * APC by Schneider Electric ** | Information, Process Organization (IPO)* | *Remedy Administrator / Developer* * Phone:* +305-266-5005 ext. 237 | * Email:* *john.athe...@apcc.com* +john.athe...@apcc.com | *Site:**www.apc.com/ * http://www.apc.com/ | *Address:* 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail *Joe Martin D'Souza jdso...@shyle.net* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/12/2012 10:36 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** I completely agree that bypassing the application layer is never a good idea unless absolutely necessary.. the second option of a custom Last Modified Date2 set by custom workflow is a better idea as the framework of its implementation stays within the applications context. Direct SQL’s if used, MUST be used CAREFULLY. The only reason I thought of it in this case is that I’m almost 100% sure a Direct SQL when used within workflow to update a record, does not alter the Last Modified Date or Last Modified By field. It just updates what is asked to update and bypasses the application layer altogether and does not update these system fields even if the SQL was designed to update a AR record. Out of curiosity (I didn’t have the time to find out the purpose of this Escalation), what does it do? Joe *From:* *Jose Huerta* jose.hue...@sm2baleares.es *Sent:* Monday, March 12, 2012 7:31 PM *Newsgroups:* public.remedy.arsystem.general *To:* *arslist@ARSLIST.ORG* arslist@ARSLIST.ORG *Subject:* Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** I think that change a set action to a direct SQL to avoid normal ARS behavior is a bad practice and you'll pay it at the future. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Mon, Mar 12, 2012 at 21:25, Joe Martin D'Souza *jdso...@shyle.net*jdso...@shyle.net wrote: Three may be a workaround provided HPD:INC:ResetKickbackCount does not trigger any filters that sets other
Re: BMC_GLOBAL_DEFAULT_SRVC CI
I'm pretty sure it's tied to the default services that come with SRM. Sent from my iPhone On Mar 13, 2012, at 6:17 AM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: Hi All, CMDB 7.6.04 SP2 The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the Infrastructure Change form. BMC tells us that this CI should never be deleted. Does anyone know precisely what it is for? I guess it's to do with the Service Catalog functionality in Atrium Core. I can set the status of this CI from its out-of-the-box value of 'Ordered' to 'End of Life' to remove it from the menu but would this affect the functionality that the CI is there to support? Cheers Peter ___ 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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%
I see 5 different naming conventions. How many do you see? -John On Tue, Mar 13, 2012 at 2:15 AM, patchsk vamsi...@gmail.com wrote: ** Here is the list from ITSM 7.6.03p002 CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin CTM:People CTM:People Attachments CTM:People Attributes CTM:People Audit CTM:People Benefit Info CTM:People Education CTM:People HR Attendance Mgmt CTM:People HR Time Management CTM:People IT Skills CTM:People LookUp CTM:People Management Console CTM:People Organization CTM:People Organization Search CTM:People Permission Groups CTM:People Profile CTM:People Search CTM:People Search-Supp. Staff CTM:People Template CTM:People Template NTE CTM:People Template PG CTM:People Template SG CTM:People Template SG Lookup CTM:People Travel Profile CTM:People Wallet CTM:People WorkLog CTM:PeopleITSkillsJoin CTM:PeoplePermissionGrpUnique CTM:PeoplePermissionJoin CTM:PeoplePermissionJoin_PMC CTM:PeopleSelfJoin CTM:PeopleSyncConsole CTM:PeopleUser CTM:PeopleUserSupportGroupFunctionalRole CTM:People_Template_Child CTM:People_Template_SFR CTM:People_Template_SFR_Lookup On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: ** I do not have a vanilla system to compare our moderately customized system with and I know for a fact there are some new custom forms created for integration purposes to LDAP, that begin with CTM:PPL and although for the most part the past developers have post fixed new custom forms with the abbreviation of the site name, I do not want to assume that’s been the case consistently.. So could someone help me with a list of all forms that begin with CTM:Ppl or CTM:PPL that are out of the box?? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *Recipient of: **WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ResetKickbackCount Escalation question .... out of the box escalation seems to be updating every incident older than 31 days
I agree I don't like to disable workflow but in this case with the escalation doing a modify all records and with the number of records in my system and plus the fact we are not using this report. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail Jose Huerta jose.hue...@sm2baleares.es Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/13/2012 08:45 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** My recommendation about customizations is to add and not to delete or disable objects ( http://theremedyforit.com/2012/03/best-practices-for-customizations/ ) So I continue to recommend to create another last modified by and date fields. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 13:40, John Atherly john.athe...@schneider-electric.com wrote: ** I looked more into this escalation to see what it is doing and what fields that it uses and why. I found a filter (HPD:INC:SetFromResolved_Kickback) that fires when a ticket is reopened that increases the count in the Kickback count field. Then on the first of the month this escalation fire and reset everything back to zero. My best guess is that this process is used for some out of the box report. I think I'm going to recommend to just disable the escalation. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail Joe Martin D'Souza jdso...@shyle.net Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/12/2012 10:36 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** I completely agree that bypassing the application layer is never a good idea unless absolutely necessary.. the second option of a custom Last Modified Date2 set by custom workflow is a better idea as the framework of its implementation stays within the applications context. Direct SQL’s if used, MUST be used CAREFULLY. The only reason I thought of it in this case is that I’m almost 100% sure a Direct SQL when used within workflow to update a record, does not alter the Last Modified Date or Last Modified By field. It just updates what is asked to update and bypasses the application layer altogether and does not update these system fields even if the SQL was designed to update a AR record. Out of curiosity (I didn’t have the time to find out the purpose of this Escalation), what does it do? Joe From: Jose Huerta Sent: Monday, March 12, 2012 7:31 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ResetKickbackCount Escalation question out of the box escalation seems to be updating every incident older than 31 days ** I think that change a set action to a direct SQL to avoid normal ARS behavior is a bad practice and you'll pay it at the future. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está
Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%
A year ago I started to write my own best practices (And I published a lot of them on my blog) because I couldn't find any BMC's best practices guide. I know why BMC doesn't publish a best practices guide, because they don't have it! Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 13:48, John Sundberg john.sundb...@kineticdata.comwrote: ** I see 5 different naming conventions. How many do you see? -John On Tue, Mar 13, 2012 at 2:15 AM, patchsk vamsi...@gmail.com wrote: ** Here is the list from ITSM 7.6.03p002 CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin CTM:People CTM:People Attachments CTM:People Attributes CTM:People Audit CTM:People Benefit Info CTM:People Education CTM:People HR Attendance Mgmt CTM:People HR Time Management CTM:People IT Skills CTM:People LookUp CTM:People Management Console CTM:People Organization CTM:People Organization Search CTM:People Permission Groups CTM:People Profile CTM:People Search CTM:People Search-Supp. Staff CTM:People Template CTM:People Template NTE CTM:People Template PG CTM:People Template SG CTM:People Template SG Lookup CTM:People Travel Profile CTM:People Wallet CTM:People WorkLog CTM:PeopleITSkillsJoin CTM:PeoplePermissionGrpUnique CTM:PeoplePermissionJoin CTM:PeoplePermissionJoin_PMC CTM:PeopleSelfJoin CTM:PeopleSyncConsole CTM:PeopleUser CTM:PeopleUserSupportGroupFunctionalRole CTM:People_Template_Child CTM:People_Template_SFR CTM:People_Template_SFR_Lookup On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: ** I do not have a vanilla system to compare our moderately customized system with and I know for a fact there are some new custom forms created for integration purposes to LDAP, that begin with CTM:PPL and although for the most part the past developers have post fixed new custom forms with the abbreviation of the site name, I do not want to assume that’s been the case consistently.. So could someone help me with a list of all forms that begin with CTM:Ppl or CTM:PPL that are out of the box?? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- *John Sundberg* Kinetic Data, Inc. Your Business. Your Process. *Recipient of: **WWRUG10 Best Customer Service/Support Award* *WWRUG09 Innovator of the Year Award* * * 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com _attend WWRUG12 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 image002.jpgimage003.jpgimage004.jpgimage001.jpg
Re: Avoiding pop-ups while requiring input
Thanks LJ and Chris, (Sorry, forgot to say I was on ARS 7.5.) I looked around and couldn't find the option, and it turns out it's not a 7.5 feature - don't see it in the 7.5 docs, but I do see it in 7.6.4 docs. David -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, March 12, 2012 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Avoiding pop-ups while requiring input David, If you are running 7.5 I think it was...you can configure everything to go to the 'prompt bar'that's not a popup :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 3:29 PM To: arslist@ARSLIST.ORG Subject: Avoiding pop-ups while requiring input We're rolling out an app for staff that normally don't use Remedy, and a usability concern is browser pop-up blockers. (I know the login page warns about pop-ups, but I've seen it ignored I've done it myself.) This is a rather detailed Remedy form, and if they get a pop-up have to reload the page, the user input is lost. I took out message actions from my workflow to avoid this, but there are still Required fields: if left blank, they use a pop-up box. Does anyone have a creative way for getting around this for required fields? Maybe some trick where the fields are not really required on the database side, but not sure how ensure they are populated without using a message to the user. Or something else I can do? David --- David Durling durl...@uga.edu Enterprise IT Services 706-542-0223 University of Georgia __ __ ___ 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: CMDB 7.6.04 SP2 Error
We wanted to fix the issue with CMDB 7.6.04 allowing duplicate reconciliation id's in the same dataset and were advised to wait for CMDB 7.6.04 SP3 which is due in March (i.e. this month) From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: 13 March 2012 12:44 To: arslist@ARSLIST.ORG Subject: Re: CMDB 7.6.04 SP2 Error ** I kinda got the idea was that sp3 is core only.. period.. I also got the idea they were focused on 7.7, \but I would love to hear otherwise.. Silence is not golden... It's nerve racking.. 8-P On Tue, Mar 13, 2012 at 2:52 AM, BradRemedy bradrem...@gmail.com wrote: ** rant So...anyone have any idea on when CMDB 7.6.04 SP3 is being released? I see that the Remedy Server Sp3 has been released which is great...however it doesnt solve this problem. And for the life of me I cannot find out when BMC plan (or if they even are going to ) to release CMDB 7.6.40 SP3. Our Support partner also cannot find out. I honestly cannot wait for the next visit from a BMC representative so that I can ask them to please explain to me how they expect us to plan our roadmap, upgrades as well as resolve important bugs when they will not let us know when a patch is expected. This error that we have is forcing us to keep delaying our upgrade to 7.6.04 as we are waiting for SP3 and is giving Remedy such a bad name it is past being funny. All the work that we have done to build this product up as a reliable, fast solution is going out the window. /rant On Thu, Feb 2, 2012 at 8:23 PM, Basil Webster ba...@remex.co.za wrote: ** Hi, I know it's a little late but we logged an issue about a month ago referencing the SW mentioned below. I immediately got a reply saying that we should wait for SP3 but they could not provide a date. Long story short, I escalated this via our partner support and received an mail today saying that they hope to have SP3 out by March but are looking into a special release to SP2 before then. I suggest you log that ticket asking for the special release. Regards, Basil Webster | Support Manager | Remex Group Email: ba...@remex.co.za | www.remex.co.za http://www.remex.co.za/ Tel: +27 (0) 12 756 4227/8 | Cell: +27 (0) 82 tel:%2B27%20%280%29%2082%C2%A0452%209389 452 9389 | Fax: +27 (0) 86 tel:%2B27%20%280%29%2086%C2%A0540%209224 540 9224 | Centurion Close | Suite 2C | 119 Gerhard Street | Centurion CBD | South Africa | From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy Sent: 12 January 2012 02:58 PM To: arslist@ARSLIST.ORG Subject: Re: CMDB 7.6.04 SP2 Error ** Hi Mark Thanks for that Just had a look and it does seem to be related. Dont suppose anyone has any idea on when SP3 is being released? The only other thing I can try is to use SP1 and see if the same error occurs. At the end of the day we would prefer not to have to wait months for SP3 as it will delay our upgrade plans we have for the year - and we havent even start with ITSM and SRM yet :-(. On Thu, Jan 12, 2012 at 2:25 PM, Walters, Mark mark_walt...@bmc.com wrote: ** There's a very similar looking defect that looks likely to be fixed in 7.6.04 SP3. I suggest you open an issue with BMC and reference defect SW00416229, support should be able to confirm whether it's the same problem. Mark I work for BMC, I don't speak for them From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of BradRemedy Sent: 12 January 2012 11:54 To: arslist@ARSLIST.ORG Subject: CMDB 7.6.04 SP2 Error ** Hi We have run into a wierd error that we cannot find any reference to on the ARSList, Manuals or Support web. Hopefully someone here can offer some suggestions on what we can try next as we are quickly running out of ideas and have tried this upgrade a few times. Firstly some background information. We have a Test server running Windows Server 2008 Enterprise with a seperate DB Server running SQL 2008. We also have a third server acting as a Mid Tier server also running Windows Server 2008. We are testing our upgrade strategy on upgrading from ARS Core 7.5 Patch 003, CMDB 7.6 Patch 001 to ARS Core 7.6.04 SP2 and CMDB 7.6.04 SP2. We are also running ITSM 7.6 and SRM 7.6 Patch 001 however these 2 applications will only be upgraded at a later stage and we want to leave them on their current versions. Now, we have run the Upgrade for ARS core to 7.6.04 SP2 with no errors. Every looks and works as expected. We then ran the ugprade for CMDB to 7.6.04 SP2 which also completed successfully. The mid tier server is also ugprade to 7.6.04 SP2 and all applications (Incident, Problem, Change, SRM) are working correctly, with the exception to this one problem. When we click on any CI in the Asset Management Application and click on the Explore CI' option, the BMC Atrium Explorer opens and attempts to load some screens -
Mid-Tier Caching Endeavors
Hi all Mid-Tier Admins! I have had a series of frustrating issues with Mid-Tier 7.6.04 SP2 caching, that I think I have now come to grips with. What I did was to create a Group (STUGUN) and a Role (STUGUN) to be used in customization of the application Remedy Incident Management. The role granted access to a set of ACTLs. What happened was that Mid-Tier failed to recache things sometimes, and some users with this group (STUGUN) got access to the ACTLs, and some did not. The same user could get different results depending on which Mid-Tier he accessed. My error, I think, is that the STUGUN-Group was set defined as a None-Group. As it was mapped to a Role, it worked fine to assign permission to it, and it also worked fine in Remedy User. When Mid-Tier does its caching, it will create a unique Group-combination based on each users unique combination of Groups. For example if a user belongs to: 20213 = Service Request User (Change) 10001 = STUGUN (None, this is my group) 20003 = Incident User (Change) 2 = General Access (Change) 20032 = Asset Viewer (Change) 100021 = 100021 (None) - this is a Support Group The Unique combination here will be ;2;20003;20032;20213; where the two groups with Group-Type None has been stripped out. This is because None-groups should not be able to change access in any way, except for row-level-access, but that is calculated in another way. So depending on if the first User with the unique permission map ;2;20003;20032;20213; belonged to my STUGUN-group or not, the cached file included/excluded permission to thos STUGUN-Active-Links! SOLUTION: Change the None-Group to View or Change CONCLUSION: Never map a None-Group to a Role Please let me know if my deductions seems flawed in any 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Avoiding pop-ups while requiring input
Hi Ian, The issue would be stopping things before I hit a submit or modify action, I think - because then the system will generate a pop-up (on 7.5). So, like Joe suggested, I think I'll try a custom submit/modify button and display the text/color like you mention if the needed fields are null. This avoids any submit or modify action actually being initiated until the needed fields are filled in. I guess I could even leave the fields as Required and do this. Thanks guys, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ian Trimnell Sent: Tuesday, March 13, 2012 1:42 AM To: arslist@ARSLIST.ORG Subject: Re: Avoiding pop-ups while requiring input ** David, One way to avoid pop-ups could be as follows: * parse the form on submit and check if any of the required fields are blank * if so, make a hidden warning text field visible saying something like please enter required data * change the label colour on the fields that are required. Would that fit the bill? Ian Ian Trimnell Systems Programmer, Distributed Systems Information Technology Berrill Building, Level 1 North Phone: 01908 6 53741 web: http://www.open.ac.uk/ On 12/03/2012 21:28, David Durling wrote: We're rolling out an app for staff that normally don't use Remedy, and a usability concern is browser pop-up blockers. (I know the login page warns about pop-ups, but I've seen it ignored I've done it myself.) This is a rather detailed Remedy form, and if they get a pop-up have to reload the page, the user input is lost. I took out message actions from my workflow to avoid this, but there are still Required fields: if left blank, they use a pop-up box. Does anyone have a creative way for getting around this for required fields? Maybe some trick where the fields are not really required on the database side, but not sure how ensure they are populated without using a message to the user. Or something else I can do? David --- David Durling durl...@uga.edumailto:durl...@uga.edu Enterprise IT Services 706-542-0223 University of Georgia ___ 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 -- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England Wales and a charity registered in Scotland (SC 038302). _attend WWRUG12 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: Question: oracle clob in a row scenario
Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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
Cannot establish a network connection to the AR System server
Hi All, I am unable to access the server i am getting below error : ARERR [90] Cannot establish a network connection to the AR System server : servera : RPC: Miscellaneous tli error - System error (Connection refused). When i am trying to restart the server below error i am getting. ld.so.1: arserverd: fatal: libclntsh.so.9.0: open failed: No such file or directory. In arrerror log file Below errors: Tue Mar 13 09:34:57 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSNOTE 3001) Tue Mar 13 09:34:58 2012 Distrib : Error while writing to a file (ARDSERR 301) Tue Mar 13 09:34:58 2012 /opt/ar/itm104/db/ardist.log Tue Mar 13 09:37:18 2012 Distrib : AR System Server is not currently available -- will retry connection (ARDSNOTE 3004) Tue Mar 13 09:39:54 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Tue Mar 13 09:39:54 2012 15 Tue Mar 13 09:39:55 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSNOTE 3001) Tue Mar 13 09:40:18 2012 Distrib : Error while writing to a file (ARDSERR 301) Tue Mar 13 09:40:18 2012 /opt/ar/itm104/db/ardist.log Tue Mar 13 09:42:38 2012 Distrib : AR System Server is not currently available -- will retry connection (ARDSNOTE 3004) Could you please help me on this . Thanks Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Cannot establish a network connection to the AR System server
Since you are getting errors like Error while writing to file and no file found I would guess that you are not running the AR System as the correct unix user. libclntsh.so.9.0 is part of the Oracle client libraries (so your PATH and LD_LIBRARY_PATH environment variables are not set correctly) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of vidyasagar kommu Sent: Tuesday, March 13, 2012 9:18 AM To: arslist@ARSLIST.ORG Subject: Cannot establish a network connection to the AR System server Hi All, I am unable to access the server i am getting below error : ARERR [90] Cannot establish a network connection to the AR System server : servera : RPC: Miscellaneous tli error - System error (Connection refused). When i am trying to restart the server below error i am getting. ld.so.1: arserverd: fatal: libclntsh.so.9.0: open failed: No such file or directory. In arrerror log file Below errors: Tue Mar 13 09:34:57 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSNOTE 3001) Tue Mar 13 09:34:58 2012 Distrib : Error while writing to a file (ARDSERR 301) Tue Mar 13 09:34:58 2012 /opt/ar/itm104/db/ardist.log Tue Mar 13 09:37:18 2012 Distrib : AR System Server is not currently available -- will retry connection (ARDSNOTE 3004) Tue Mar 13 09:39:54 2012 Distrib : AR System Distributed Server terminated when a signal was received by the server (ARDSNOTE 3000) Tue Mar 13 09:39:54 2012 15 Tue Mar 13 09:39:55 2012 Distrib : AR System Distributed Server terminated -- fatal error encountered (ARDSNOTE 3001) Tue Mar 13 09:40:18 2012 Distrib : Error while writing to a file (ARDSERR 301) Tue Mar 13 09:40:18 2012 /opt/ar/itm104/db/ardist.log Tue Mar 13 09:42:38 2012 Distrib : AR System Server is not currently available -- will retry connection (ARDSNOTE 3004) Could you please help me on this . Thanks Sagar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: oracle clob in a row scenario
I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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 -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: oracle clob in a row scenario
Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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 -- Patrick Zandi ___ 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: Avoiding pop-ups while requiring input
Sorry I missed the version :)...we moved to 7.5, and then about 6 months later went to 7.6.4...so it's hard to keep track of what was in each release. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Tuesday, March 13, 2012 7:19 AM To: arslist@ARSLIST.ORG Subject: Re: Avoiding pop-ups while requiring input Thanks LJ and Chris, (Sorry, forgot to say I was on ARS 7.5.) I looked around and couldn't find the option, and it turns out it's not a 7.5 feature - don't see it in the 7.5 docs, but I do see it in 7.6.4 docs. David -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, March 12, 2012 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Avoiding pop-ups while requiring input David, If you are running 7.5 I think it was...you can configure everything to go to the 'prompt bar'that's not a popup :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Monday, March 12, 2012 3:29 PM To: arslist@ARSLIST.ORG Subject: Avoiding pop-ups while requiring input We're rolling out an app for staff that normally don't use Remedy, and a usability concern is browser pop-up blockers. (I know the login page warns about pop-ups, but I've seen it ignored I've done it myself.) This is a rather detailed Remedy form, and if they get a pop-up have to reload the page, the user input is lost. I took out message actions from my workflow to avoid this, but there are still Required fields: if left blank, they use a pop-up box. Does anyone have a creative way for getting around this for required fields? Maybe some trick where the fields are not really required on the database side, but not sure how ensure they are populated without using a message to the user. Or something else I can do? David --- David Durling durl...@uga.edu Enterprise IT Services 706-542-0223 University of Georgia __ __ ___ 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: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%
Thank you (and others who responded – Ben Chernys, John Sundberg and Jose Huerta)! Appreciate it.. I was interested in this list (beginning with CTM:PPL or CTM:Ppl) so I could ignore looking at these unless there are customizations within them.. CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin Thank you’ll for the information.. Joe From: patchsk Sent: Tuesday, March 13, 2012 3:15 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL% ** Here is the list from ITSM 7.6.03p002 CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin CTM:People CTM:People Attachments CTM:People Attributes CTM:People Audit CTM:People Benefit Info CTM:People Education CTM:People HR Attendance Mgmt CTM:People HR Time Management CTM:People IT Skills CTM:People LookUp CTM:People Management Console CTM:People Organization CTM:People Organization Search CTM:People Permission Groups CTM:People Profile CTM:People Search CTM:People Search-Supp. Staff CTM:People Template CTM:People Template NTE CTM:People Template PG CTM:People Template SG CTM:People Template SG Lookup CTM:People Travel Profile CTM:People Wallet CTM:People WorkLog CTM:PeopleITSkillsJoin CTM:PeoplePermissionGrpUnique CTM:PeoplePermissionJoin CTM:PeoplePermissionJoin_PMC CTM:PeopleSelfJoin CTM:PeopleSyncConsole CTM:PeopleUser CTM:PeopleUserSupportGroupFunctionalRole CTM:People_Template_Child CTM:People_Template_SFR CTM:People_Template_SFR_Lookup On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: ** I do not have a vanilla system to compare our moderately customized system with and I know for a fact there are some new custom forms created for integration purposes to LDAP, that begin with CTM:PPL and although for the most part the past developers have post fixed new custom forms with the abbreviation of the site name, I do not want to assume that’s been the case consistently.. So could someone help me with a list of all forms that begin with CTM:Ppl or CTM:PPL that are out of the box?? Joe ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL%
That actually led me to posting this although there is an internal convention here to postfix customizations with our customer abbreviations.. I wanted to make sure that the some of the 5 different conventions were not indeed customizations that the developer missed putting a prefix to. I thought it was weird too and there is almost no reason why they should have not stuck to just 2 conventions here CTM:PeopleX and CTM:PPL-X. I would have felt more confident separating the OTB from customized flow. The only other way to reassure if its an OTB object is looking at the Change History on the object where BMC owned objects have something like: “9/10/2009 9:19:53 PMBMC Copyright (c) 1991 - 2009 BMC Software, Inc. all rights reserved BMCVer=7.6.00” This too, I wonder if its consistent really.. I wouldn’t be surprised if there are a vast number of BMC owned objects that do not have that ‘signature’ in the Change History. Joe From: John Sundberg Sent: Tuesday, March 13, 2012 8:48 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL% ** I see 5 different naming conventions. How many do you see? -John On Tue, Mar 13, 2012 at 2:15 AM, patchsk vamsi...@gmail.com wrote: ** Here is the list from ITSM 7.6.03p002 CTM:PPL-SptGrpAssoc-ITSkills CTM:PPL-SptGrpFuncRole-ITSkills CTM:PPLSupptGrpAscFcnRoleLkUp CTM:Ppl Search-PermissionGrp CTM:Ppl Search-SupportGrpAssoc CTM:Ppl Search-SupportGrpFuncR CTM:Ppl Search-Worklog CTM:PplPermissionSupGrpFuncRoleJoin CTM:PplPermissionSupGrpJoin CTM:People CTM:People Attachments CTM:People Attributes CTM:People Audit CTM:People Benefit Info CTM:People Education CTM:People HR Attendance Mgmt CTM:People HR Time Management CTM:People IT Skills CTM:People LookUp CTM:People Management Console CTM:People Organization CTM:People Organization Search CTM:People Permission Groups CTM:People Profile CTM:People Search CTM:People Search-Supp. Staff CTM:People Template CTM:People Template NTE CTM:People Template PG CTM:People Template SG CTM:People Template SG Lookup CTM:People Travel Profile CTM:People Wallet CTM:People WorkLog CTM:PeopleITSkillsJoin CTM:PeoplePermissionGrpUnique CTM:PeoplePermissionJoin CTM:PeoplePermissionJoin_PMC CTM:PeopleSelfJoin CTM:PeopleSyncConsole CTM:PeopleUser CTM:PeopleUserSupportGroupFunctionalRole CTM:People_Template_Child CTM:People_Template_SFR CTM:People_Template_SFR_Lookup On Monday, March 12, 2012 4:17:37 PM UTC-5, Joe Martin D'Souza wrote: ** I do not have a vanilla system to compare our moderately customized system with and I know for a fact there are some new custom forms created for integration purposes to LDAP, that begin with CTM:PPL and although for the most part the past developers have post fixed new custom forms with the abbreviation of the site name, I do not want to assume that’s been the case consistently.. So could someone help me with a list of all forms that begin with CTM:Ppl or CTM:PPL that are out of the box?? Joe _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- John Sundberg Kinetic Data, Inc. Your Business. Your Process. Recipient of: WWRUG10 Best Customer Service/Support Award WWRUG09 Innovator of the Year Award 651-556-0930 I john.sundb...@kineticdata.com www.kineticdata.com I community.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Avoiding pop-ups while requiring input
Do not forget to disable the change flag on every field that gets a value (hidden field or otherwise), else the default form submit button will get enabled. It may also be a good idea to hide the form bar, so that button is not visible, in which case it is not necessary to turn off the change flag on fields... Joe From: David Durling Sent: Tuesday, March 13, 2012 9:35 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Avoiding pop-ups while requiring input ** Hi Ian, The issue would be stopping things before I hit a submit or modify action, I think – because then the system will generate a pop-up (on 7.5). So, like Joe suggested, I think I’ll try a custom submit/modify button and display the text/color like you mention if the needed fields are null. This avoids any submit or modify action actually being initiated until the needed fields are filled in. I guess I could even leave the fields as Required and do this. Thanks guys, David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ian Trimnell Sent: Tuesday, March 13, 2012 1:42 AM To: arslist@ARSLIST.ORG Subject: Re: Avoiding pop-ups while requiring input ** David, One way to avoid pop-ups could be as follows: a.. parse the form on submit and check if any of the required fields are blank b.. if so, make a hidden warning text field visible saying something like please enter required data c.. change the label colour on the fields that are required. Would that fit the bill? Ian Ian Trimnell Systems Programmer, Distributed Systems Information Technology Berrill Building, Level 1 North Phone: 01908 6 53741 web: http://www.open.ac.uk/ On 12/03/2012 21:28, David Durling wrote: We're rolling out an app for staff that normally don't use Remedy, and a usability concern is browser pop-up blockers. (I know the login page warns about pop-ups, but I've seen it ignored I've done it myself.) This is a rather detailed Remedy form, and if they get a pop-up have to reload the page, the user input is lost. I took out message actions from my workflow to avoid this, but there are still Required fields: if left blank, they use a pop-up box. Does anyone have a creative way for getting around this for required fields? Maybe some trick where the fields are not really required on the database side, but not sure how ensure they are populated without using a message to the user. Or something else I can do? David ---David Durling durling@uga.eduEnterprise IT Services 706-542-0223University of Georgia ___UNSUBSCRIBE or access ARSlist Archives at www.arslist.orgattend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England Wales and a charity registered in Scotland (SC 038302). ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: oracle clob in a row scenario
That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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 -- Patrick Zandi ___ 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 -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: oracle clob in a row scenario
You may run into timeouts if a table is locked for a long enough period of time and workflow, or a user, try to update a record in that table. The same problems that apply to oracle errors in general apply to this scenario. Axton Grams On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi remedy...@gmail.com wrote: ** That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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 -- Patrick Zandi ___ 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 -- Patrick Zandi _attend WWRUG12 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: Question: oracle clob in a row scenario
Actually,, this is what I was wondering... so do I run the whole job again, or is there some way to run this somehow that I know it will finish.. I thought about running this from an escalation, then I thought better.. an escalation thread running for 3 days.. this is probably a bad idea... ROFL.. On Tue, Mar 13, 2012 at 11:35 AM, Axton axton.gr...@gmail.com wrote: You may run into timeouts if a table is locked for a long enough period of time and workflow, or a user, try to update a record in that table. The same problems that apply to oracle errors in general apply to this scenario. Axton Grams On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi remedy...@gmail.com wrote: ** That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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 -- Patrick Zandi ___ 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 -- Patrick Zandi _attend WWRUG12 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 -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: oracle clob in a row scenario
I know some of the Alter commands are Implicit commits.. so I think the data is ok.. On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi remedy...@gmail.com wrote: Actually,, this is what I was wondering... so do I run the whole job again, or is there some way to run this somehow that I know it will finish.. I thought about running this from an escalation, then I thought better.. an escalation thread running for 3 days.. this is probably a bad idea... ROFL.. On Tue, Mar 13, 2012 at 11:35 AM, Axton axton.gr...@gmail.com wrote: You may run into timeouts if a table is locked for a long enough period of time and workflow, or a user, try to update a record in that table. The same problems that apply to oracle errors in general apply to this scenario. Axton Grams On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi remedy...@gmail.com wrote: ** That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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 -- Patrick Zandi ___ 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 -- Patrick Zandi _attend WWRUG12 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 -- Patrick Zandi -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Remedy 7.6.04 - BRIE Timeouts
Hello, Here is the thread/queue information for our 7.6.04 SP2 application server environment: Admin Server: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 4 (Escalations) Private-RPC-Socket: 390620 12 20 (Fast) Private-RPC-Socket: 390621 2 20 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 18 20 (List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 AR Server 1: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 (Escalations) Private-RPC-Socket: 390620 4 10(Fast) Private-RPC-Socket: 390621 2 8 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 4 12(List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 AR Server 2: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 (Escalations) Private-RPC-Socket: 390620 4 10(Fast) Private-RPC-Socket: 390621 2 8 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 4 12(List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 AR Server 3: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 (Escalations) Private-RPC-Socket: 390620 4 10(Fast) Private-RPC-Socket: 390621 2 8 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 4 12(List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 Application Server Specifications: Virtual Server Windows 2008 Enterprise Server R2 64-bit (6) Intel Xeon X5650 2.67 Ghz Virtual CPUs 16 GB of RAM Thanks, Chris From: Axton axton.gr...@gmail.com To: arslist@ARSLIST.ORG Date: 03/12/2012 03:17 PM Subject:Re: Remedy 7.6.04 - BRIE Timeouts Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Turn on cumulative and individual queue server statistics collection on the servers. Look for queue blocked items in the recorded statistics. What is your queue/thread configuration on arserver and what subsystems use which queues? Axton Grams On Mon, Mar 12, 2012 at 2:34 PM, Chris Wilson christopher.j.wil...@stls.frb.org wrote: We are implementing new 7.6.04 SP2 environments and we seem to experience BRIE timeouts sporatically on our ARS servers. The timeouts seem to be triggered by user activity, however, it does not take much activity to activate the timeouts. When timeouts are experieced, current users experience an hourglass and new users cannot login. Once the timeouts start, we must recycle the application server(s) experiencing the issue to restore service. We are experiencing this issue in our DEV, QA and PROD 7.6.04 environments. Anyone else experiencing this issue? We are also running ARS 7.5 Patch 6 with no timeout issues. Thanks, Chris Wilson ___ 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
Job Senior Programmer Analyst (ICS) Orlando Utilities Commission Orlando, Florida 32802
Please send resumes to saugusti...@agile1.com mailto:saugusti...@agile1.com Senior Programmer Analyst (ICS) Orlando Utilities Commission Orlando, Florida 32802 Dept: IT/Integrated Customer Systems NATURE OF WORK: To provide Information Technology support and solutions for all application systems and for all areas of the Commission. The Senior Programmer Analyst serves as a companywide resource for projects involving Information Technology. The Senior Programmer Analyst is responsible for designing, developing, and maintaining software integration solutions using the Software AG webMethods Integration Platform when applicable. Responsible for maintaining the webMethods Integration Platform system's integrity, availability, accessibility, security and current patch levels. Install and maintain software packages purchased by OUC. Responsible for administering existing production non-production environments. BASIC JOB DUTIES: As a Sr. Programmer Analyst, you will be responsible for the following: *Perform software development duties as part of a team *Thorough analysis, specifications and application design *All forms of testing inclusive of unit, integration, system and user acceptance with proper documentation *Coordinate and work with internal and external team members to understand technical and functional requirements and identify and resolve issues and risks. *Provide technical guidance to junior developers. *Provide second tier on call support in the event there are production outages during and after business hours *Projects include the development and implementation of automated systems, back-office systems, integration middleware, web services, web development. *Install and maintain software packages purchased by OUC. *Coordinate the implementation and completion of recommended specifications for all new systems, system changes, and problem correction. *Deploy developed software projects through the different stages such as test, user acceptance, and production environments. *Responsibilities including; installing, configuring, supporting, maintaining, administering, and documenting the webMethods environments *Identify problems, troubleshooting, and solution implementation in a production environment. *Develop and demonstrate a good understanding and use of monitoring tools and webMethods Administration Consoles. *Monitor the application health using monitoring tools and custom procedures. *Monitor alerts thrown by the applications via monitoring alerts and take appropriate action *Develop and demonstrate a good understanding of the Change Management process. *Prepare unit test data, test and debug webMethods solutions *Deploy the software release using webMethods Deployer and appropriate tools. *Interact with software, network, database, and Unix administrators to seamlessly implement solutions to complex technical issues *Participate in incident management and problem management discussions and support incident manager in submitting root cause analysis reports and to resolve application issues. *Working with various multiple application teams, application developers, adapting SOA and Middle-Tier standards. *Implementing security policies. *Will be expected to follow web services standards and provide intelligent and experienced feedback on standards improvements *Must be able to communicate clearly with UML diagrams and data flow patterns *Provide detailed time estimates of the work to be done and regular progress updates as required to the Team Leader and/or Project Manager *Perform other related duties as directed REQUIREMENTS: * B.S. in Computer Science or related field. Minimum seven (7) years software development experience (in multiple environments) employing formal software development methodologies. * Experience and understanding of network devices within a DMZ and corporate architecture that includes load balancers, firewalls and XML Gateways * Experience with relational databases (Oracle and SQL Server required) and client/server environment (HP Unix and MS Windows 2008 Server). * Strong knowledge of integration technologies including but not limited to HTML, ASP, .NET, JAVA, EJB, J2EE, XSLT, XML, JMS, ODBC, JDBC, JNDI, SOAP, Web Services, WSDL, and WS-* specifications, UML diagrams * 2+ Years developing integration solutions with the Software AG webMethods Integration Platform version 7.x and greater including Integration Server, Broker, Deployer, and My WebMethods Server (Portal) and Developer/Designer. * Experience is designing of an enterprise canonical message models and object oriented design * Experience in enterprise messaging and integration design, analysis, and development techniques using the Software AG webMethods Integration Platform. * Must be
Re: Mid-Tier Caching Endeavors
I'd be curious to know what you see with this in SP3, since as near as I can tell it made significant changes to how the mid-tier ehcache handles users and groups, and changed prefetch from push to pull. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Tuesday, March 13, 2012 8:30 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier Caching Endeavors Hi all Mid-Tier Admins! I have had a series of frustrating issues with Mid-Tier 7.6.04 SP2 caching, that I think I have now come to grips with. What I did was to create a Group (STUGUN) and a Role (STUGUN) to be used in customization of the application Remedy Incident Management. The role granted access to a set of ACTLs. What happened was that Mid-Tier failed to recache things sometimes, and some users with this group (STUGUN) got access to the ACTLs, and some did not. The same user could get different results depending on which Mid-Tier he accessed. My error, I think, is that the STUGUN-Group was set defined as a None-Group. As it was mapped to a Role, it worked fine to assign permission to it, and it also worked fine in Remedy User. When Mid-Tier does its caching, it will create a unique Group-combination based on each users unique combination of Groups. For example if a user belongs to: 20213 = Service Request User (Change) 10001 = STUGUN (None, this is my group) 20003 = Incident User (Change) 2 = General Access (Change) 20032 = Asset Viewer (Change) 100021 = 100021 (None) - this is a Support Group The Unique combination here will be ;2;20003;20032;20213; where the two groups with Group-Type None has been stripped out. This is because None-groups should not be able to change access in any way, except for row-level-access, but that is calculated in another way. So depending on if the first User with the unique permission map ;2;20003;20032;20213; belonged to my STUGUN-group or not, the cached file included/excluded permission to thos STUGUN-Active-Links! SOLUTION: Change the None-Group to View or Change CONCLUSION: Never map a None-Group to a Role Please let me know if my deductions seems flawed in any 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. ___ 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: Remedy 7.6.04 - BRIE Timeouts
Check the server statistics too. Your queue/thread configuration appears to be sufficient for some load, but the queue blocked items in the server stats will confirm that it's enough. I've been practicing setting the minimum threads to 1 and the max to wherever it needs to be. This lets the arserver create new threads for each pool as needed. The exercise of trying to allocate a thread from a pool and creating a new one if all the threads are occupied is relatively simple and the arserver seems to have implemented it well, so setting a minimum of 1 and letting the server drive the thread count saves resources where it can. The only exception is the escalation queue, which needs the min threads defined at a value greater than 1. There are 4 servers total. Am I correct in assuming that all servers are in a server group, and all but the admin server are behind a load balancer? I am still curious about the following things, to complete the picture: - server group ranking - rpc program used by each subsystem (e.g., 390621 is used by the approval server; 390624 is used by the mid-tier, etc.) - the server statistics queue blocked count - With this server count, I am curious if the hanging occurs on all servers or just one server at a time Do keep in mind that cache operations can wreak havoc on your servers, because they are all in a server group together. Regards, Axton Grams On Tue, Mar 13, 2012 at 11:45 AM, Chris Wilson christopher.j.wil...@stls.frb.org wrote: ** Hello, Here is the thread/queue information for our 7.6.04 SP2 application server environment: Admin Server: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 4 (Escalations) Private-RPC-Socket: 390620 12 20 (Fast) Private-RPC-Socket: 390621 2 20 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 18 20 (List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 AR Server 1: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 (Escalations) Private-RPC-Socket: 390620 4 10 (Fast) Private-RPC-Socket: 390621 2 8 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 4 12 (List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 AR Server 2: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 (Escalations) Private-RPC-Socket: 390620 4 10 (Fast) Private-RPC-Socket: 390621 2 8 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 4 12 (List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 AR Server 3: Private-RPC-Socket: 390601 1 1 Private-RPC-Socket: 390603 1 1 (Escalations) Private-RPC-Socket: 390620 4 10 (Fast) Private-RPC-Socket: 390621 2 8 Private-RPC-Socket: 390626 2 5 Private-RPC-Socket: 390635 4 12 (List) Private-RPC-Socket: 390680 1 4 (Approvals) Plugin-Loopback-RPC-Socket: 390626 Approval-RPC-Socket: 390680 External-Authentication-RPC-Socket: 390695 Application Server Specifications: Virtual Server Windows 2008 Enterprise Server R2 64-bit (6) Intel Xeon X5650 2.67 Ghz Virtual CPUs 16 GB of RAM Thanks, Chris From: Axton axton.gr...@gmail.com To: arslist@ARSLIST.ORG Date: 03/12/2012 03:17 PM Subject: Re: Remedy 7.6.04 - BRIE Timeouts Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Turn on cumulative and individual queue server statistics collection on the servers. Look for queue blocked items in the recorded statistics. What is your queue/thread configuration on arserver and what subsystems use which queues? Axton Grams On Mon, Mar 12, 2012 at 2:34 PM, Chris Wilson christopher.j.wil...@stls.frb.org wrote: We are implementing new 7.6.04 SP2 environments and we seem to experience BRIE timeouts sporatically on our ARS servers. The timeouts seem to be triggered by user activity, however, it does not take much activity to activate the timeouts. When timeouts are experieced, current users experience an hourglass and new users cannot login. Once the timeouts start, we must recycle the application server(s) experiencing the issue to restore service. We are experiencing this issue in our DEV, QA and PROD 7.6.04 environments. Anyone else experiencing this issue? We are also running ARS 7.5 Patch 6 with no timeout issues. Thanks, Chris Wilson ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the
AR Server 7.6.04 patch 3 Installer and Reflection X Manager
I am at a loss here and was hoping someone on the list has encountered this issue. I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an xterm session using the Reflection X Manager and do an export DISPLAY=IP Address and start the AR Server 7.6.03 installer and it will bring up the installer on my desktop display. This works great when I am directly logged onto my desktop. However, the issue I am having is when I am using Remove Desktop Connection (RDC) connected remotely to my desktop and perform that same steps to export the DISPLAY to my IP Address of my desktop it will not display the AR Server 7.6.03 installer. Is there some setting or trick I am missing to let me see the AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone through all the settings on the Reflection X Manager and nothing is obvious that I need to set to make the AR Server 7.6.03 installer display when using RDC. Reflection X Manager version 14.1.0 AR Server 7.6.04 patch 3 Installer SUN OS 5.9 Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager
ok, this I know.. if you are logging in as the same person installing it.. it should display back, however if you are installing as root, after logging in, you need to set the enviorment to ensure it knows where to go.. So .. Login as joesmith (sorry joe, to use your name again) env |grep -i display DISPLAY=localhost:10.0 su - to get to root export DISPLAY=localhost:10.0 export HOME=~joesmith run command.. Now you have to make sure your application is allowing X to come back to the desktop and is authorized to display back.. Hope that helps.. On Tue, Mar 13, 2012 at 1:48 PM, Pruitt, Christopher (Bank of America Account) christopher.pru...@hp.com wrote: I am at a loss here and was hoping someone on the list has encountered this issue. I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an xterm session using the Reflection X Manager and do an export DISPLAY=IP Address and start the AR Server 7.6.03 installer and it will bring up the installer on my desktop display. This works great when I am directly logged onto my desktop. However, the issue I am having is when I am using Remove Desktop Connection (RDC) connected remotely to my desktop and perform that same steps to export the DISPLAY to my IP Address of my desktop it will not display the AR Server 7.6.03 installer. Is there some setting or trick I am missing to let me see the AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone through all the settings on the Reflection X Manager and nothing is obvious that I need to set to make the AR Server 7.6.03 installer display when using RDC. Reflection X Manager version 14.1.0 AR Server 7.6.04 patch 3 Installer SUN OS 5.9 Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Question: oracle clob in a row scenario
If you ran and you want to confirm, take a look in the oracle data dictionary to see the state of the lob storage parameter for each column. select table_name || '.' || column_name as column from user_lobs where in_row = 'NO' / The integrity of the data will be fine, but if the alter table statement takes 10 minutes to complete for a given column and some other sql (from the arserver) tries to perform and update on that column while the alter table is running, arserver only waits so long for the database to response (5 minutes I think). If you hit that threshold, arserverd will throw and error that the database is not responding. It is not unreasonable to assume that some of the alter table statements will take a long time (more than 5 minutes) to run if the total time of the alterations is 24 hours. Other things can/will slow down your conversion as well, such as backups. Also, the redo space required for the conversion will need to be rather large. The script you are using may not be as efficient as it could be. These hints/changes can make a big difference in the execution time: - parallel hint - nologging (don't generate redo logs) - direct-path INSERT (bypass the buffer cache) I don't know how you are doing the conversion, but each of the things above are worth looking into. Axton Grams On Tue, Mar 13, 2012 at 11:30 AM, patrick zandi remedy...@gmail.com wrote: ** I know some of the Alter commands are Implicit commits.. so I think the data is ok.. On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi remedy...@gmail.com wrote: Actually,, this is what I was wondering... so do I run the whole job again, or is there some way to run this somehow that I know it will finish.. I thought about running this from an escalation, then I thought better.. an escalation thread running for 3 days.. this is probably a bad idea... ROFL.. On Tue, Mar 13, 2012 at 11:35 AM, Axton axton.gr...@gmail.com wrote: You may run into timeouts if a table is locked for a long enough period of time and workflow, or a user, try to update a record in that table. The same problems that apply to oracle errors in general apply to this scenario. Axton Grams On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi remedy...@gmail.com wrote: ** That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours.. This is why I am asking... thanks.. -- Patrick Zandi ___ 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: Report error on web report drill-down
Thanks for the suggestion, Joe. Your comment makes me question how a form could have been deleted when we're using an out of the box Remedy build, and there has never been any development performed. I am the only administrator and I've never done any development on our system. Is there a way to identify which form is missing, and is it really possible for a form to have been deleted? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 3:12 PM To: arslist@ARSLIST.ORG Subject: Re: Report error on web report drill-down Try flushing the Mid-Tier cache. My hunch is you may have deleted the original form that table field was pointing to, and created a new form, to point it to. Even if that is not the case, refreshing your Mid-Tier cache would never hurt. Cheers Joe -Original Message- From: Kay W Sent: Monday, March 12, 2012 3:01 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Report error on web report drill-down When running a web report, the report generates fine but when clicking on the hyperlink to drill down to a specific record in the report, Internet Explorer 8 is generating an error that the page cannot be found. This is a simple web report created within Reports Console of an out-of-box installation of Remedy 7.6.04. Any trouble-shooting advice? Thanks, Kay ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are Your Comments: Peckham is committed to delivering the highest levels of customer service. Your comments help us to reach this goal. If you would like to provide feedback, please email our continuous improvement team at comme...@peckham.org . Thank you for the opportunity to serve you better. CONFIDENTIALITY: The information contained in this electronic mail message and any attachments is intended only for the use of the individual or entity to whom it is addressed and may contain legally privileged, confidential information or work product. If the reader of this message is not the intended recipient, you are hereby notified that any use, dissemination, distribution, or forwarding of this email message is strictly prohibited. If you have received this message in error, please notify confidential...@peckham.org immediately and delete the original message from your system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager
I have seen issues with xWindows windows and RDC (it actually displays on the PC but RDC does not send that window across because the xWindows app is running in the console session and RDP is actually a new user login in another session). Try connecting to your PC thru RDC in a console session mstsc.exe /console (or mstsc.exe /admin) or alternatively set the DISPLAY environment to the second session DISPLAY=IP:1.0 (You can see what sessions there are by running qwinsta in a dos window on the PC) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Tuesday, March 13, 2012 12:48 PM To: arslist@ARSLIST.ORG Subject: AR Server 7.6.04 patch 3 Installer and Reflection X Manager I am at a loss here and was hoping someone on the list has encountered this issue. I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an xterm session using the Reflection X Manager and do an export DISPLAY=IP Address and start the AR Server 7.6.03 installer and it will bring up the installer on my desktop display. This works great when I am directly logged onto my desktop. However, the issue I am having is when I am using Remove Desktop Connection (RDC) connected remotely to my desktop and perform that same steps to export the DISPLAY to my IP Address of my desktop it will not display the AR Server 7.6.03 installer. Is there some setting or trick I am missing to let me see the AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone through all the settings on the Reflection X Manager and nothing is obvious that I need to set to make the AR Server 7.6.03 installer display when using RDC. Reflection X Manager version 14.1.0 AR Server 7.6.04 patch 3 Installer SUN OS 5.9 Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ 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: Question: oracle clob in a row scenario
no rows selected: so it worked.. Ya know.. I believe All I did was timeout.. I killed the sqplus, went to another sqlplus session, did it again.. and in 15 min it returned.. ran what you sent below .. working.. so I really do not know how long it too.. I am doing 1 more test on this.. it should give me some real numbers.. On Tue, Mar 13, 2012 at 1:57 PM, Axton axton.gr...@gmail.com wrote: If you ran and you want to confirm, take a look in the oracle data dictionary to see the state of the lob storage parameter for each column. select table_name || '.' || column_name as column from user_lobs where in_row = 'NO' / The integrity of the data will be fine, but if the alter table statement takes 10 minutes to complete for a given column and some other sql (from the arserver) tries to perform and update on that column while the alter table is running, arserver only waits so long for the database to response (5 minutes I think). If you hit that threshold, arserverd will throw and error that the database is not responding. It is not unreasonable to assume that some of the alter table statements will take a long time (more than 5 minutes) to run if the total time of the alterations is 24 hours. Other things can/will slow down your conversion as well, such as backups. Also, the redo space required for the conversion will need to be rather large. The script you are using may not be as efficient as it could be. These hints/changes can make a big difference in the execution time: - parallel hint - nologging (don't generate redo logs) - direct-path INSERT (bypass the buffer cache) I don't know how you are doing the conversion, but each of the things above are worth looking into. Axton Grams On Tue, Mar 13, 2012 at 11:30 AM, patrick zandi remedy...@gmail.com wrote: ** I know some of the Alter commands are Implicit commits.. so I think the data is ok.. On Tue, Mar 13, 2012 at 12:26 PM, patrick zandi remedy...@gmail.com wrote: Actually,, this is what I was wondering... so do I run the whole job again, or is there some way to run this somehow that I know it will finish.. I thought about running this from an escalation, then I thought better.. an escalation thread running for 3 days.. this is probably a bad idea... ROFL.. On Tue, Mar 13, 2012 at 11:35 AM, Axton axton.gr...@gmail.com wrote: You may run into timeouts if a table is locked for a long enough period of time and workflow, or a user, try to update a record in that table. The same problems that apply to oracle errors in general apply to this scenario. Axton Grams On Tue, Mar 13, 2012 at 10:34 AM, patrick zandi remedy...@gmail.com wrote: ** That is what I want.. On Tue, Mar 13, 2012 at 10:44 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, You should see a significant size reduction as well as performance improvement on inserts/updates :-) The size was reduced to less than half in the system I was working on, and the bulk of the data left was actually attachments. 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. I think I have around 120 Gig of LOB, that is going from out to in.. I need to put in row, it is getting out of control.. On Tue, Mar 13, 2012 at 9:45 AM, Misi Mladoniczky m...@rrr.se wrote: Hi, I have done that a couple of times without any real problems. It did take a lot less than 24 hours though, so these systems were probably much smaller. About 10-15GB if I remember right, and much bigger with out-row storage. 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. Hey all , Odd question, from a person who is not normal.. which is normal.. lol If you have a production system and you are taking an existing system that is up and running online and you do the modify all the lob's from out-row to in-row is there any issues with doing this while everyone is using it ? I see nothing obviously stated that you should not run this while doing audits, or anything.. Does Oracle take care of that scenario, while moving from one way to the other.. I did one system that took almost 24 hours..
Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager
Does your desktop have multiple monitors? Whenever I do this the X window always seems to open on one of the non-visible( via RDP) monitors, although the X session appears on the taskbar, and so I have to alt+spacebar to get the window menu and Move it back to the main screen so that I can see it. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: 13 March 2012 17:48 To: arslist@ARSLIST.ORG Subject: AR Server 7.6.04 patch 3 Installer and Reflection X Manager I am at a loss here and was hoping someone on the list has encountered this issue. I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an xterm session using the Reflection X Manager and do an export DISPLAY=IP Address and start the AR Server 7.6.03 installer and it will bring up the installer on my desktop display. This works great when I am directly logged onto my desktop. However, the issue I am having is when I am using Remove Desktop Connection (RDC) connected remotely to my desktop and perform that same steps to export the DISPLAY to my IP Address of my desktop it will not display the AR Server 7.6.03 installer. Is there some setting or trick I am missing to let me see the AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone through all the settings on the Reflection X Manager and nothing is obvious that I need to set to make the AR Server 7.6.03 installer display when using RDC. Reflection X Manager version 14.1.0 AR Server 7.6.04 patch 3 Installer SUN OS 5.9 Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ 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: Report error on web report drill-down
Its an assumption at this point that it may not be the issue. I forgot to mention that it could perhaps be renamed too. From the description of your environment, it is unlikely that these may be the issues. No experienced Remedy developer would delete or rename an already deployed form - but accidents can happen.. That’s a unforgivable crime in our world when it happens :-) Maybe you could use Ben Cherny's Meta-Update tool to perform a comparison with what you have on your server, to what's usually available OTB as he has a spreadsheet with all OTB forms documented. He was just discussing that on another thread ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL% that I had started... Not everything missing from the difference you see may mean a problem as some of the differences could be because of the components you have installed, opposed to those that were installed when that spreadsheet was generated. Also the patch you are on would also make a difference.. In the end, flushing the cache should resolve the problem.. Joe -Original Message- From: Kay Wilthew Sent: Tuesday, March 13, 2012 2:00 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Report error on web report drill-down Thanks for the suggestion, Joe. Your comment makes me question how a form could have been deleted when we're using an out of the box Remedy build, and there has never been any development performed. I am the only administrator and I've never done any development on our system. Is there a way to identify which form is missing, and is it really possible for a form to have been deleted? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 3:12 PM To: arslist@ARSLIST.ORG Subject: Re: Report error on web report drill-down Try flushing the Mid-Tier cache. My hunch is you may have deleted the original form that table field was pointing to, and created a new form, to point it to. Even if that is not the case, refreshing your Mid-Tier cache would never hurt. Cheers Joe -Original Message- From: Kay W Sent: Monday, March 12, 2012 3:01 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Report error on web report drill-down When running a web report, the report generates fine but when clicking on the hyperlink to drill down to a specific record in the report, Internet Explorer 8 is generating an error that the page cannot be found. This is a simple web report created within Reports Console of an out-of-box installation of Remedy 7.6.04. Any trouble-shooting advice? Thanks, Kay ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Web Service GetList issue
Hi all, I am having issue with a web service with Getlist operation. Created the web service with Getlist operation to search multiple rows on a form. Removed the startRecord and maxLimit from Input mapping as I don't want to use those limits. However, I am seeing these values under qualification field with no values entered. When I try to consume the web service, it does not return any data. Any help would be appreciated. Thanks, Wirasat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Web Service GetList issue
I think that you must give a value. It isn't mandatory to publish these values at the input, but you need to provide a value for them. So put 0, 0 in order to not limit the response. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi wirasat_sidd...@ao.uscourts.gov wrote: ** Hi all, I am having issue with a web service with Getlist operation. Created the web service with Getlist operation to search multiple rows on a form. Removed the startRecord and maxLimit from Input mapping as I don't want to use those limits. However, I am seeing these values under qualification field with no values entered. When I try to consume the web service, it does not return any data. Any help would be appreciated. Thanks, Wirasat _attend WWRUG12 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 image003.jpgimage004.jpgimage002.jpgimage001.jpg
Re: Web Service GetList issue
This is what I get when I give 0. 0 is not valid selection for Maximum Limit., 5158, 0 is not valid selection for Start Record., 5158, Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov From: Jose Huerta jose.hue...@sm2baleares.es To: arslist@ARSLIST.ORG Date: 03/13/2012 03:58 PM Subject:Re: Web Service GetList issue Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** I think that you must give a value. It isn't mandatory to publish these values at the input, but you need to provide a value for them. So put 0, 0 in order to not limit the response. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi wirasat_sidd...@ao.uscourts.gov wrote: ** Hi all, I am having issue with a web service with Getlist operation. Created the web service with Getlist operation to search multiple rows on a form. Removed the startRecord and maxLimit from Input mapping as I don't want to use those limits. However, I am seeing these values under qualification field with no values entered. When I try to consume the web service, it does not return any data. Any help would be appreciated. Thanks, Wirasat _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 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 image/jpegimage/jpegimage/jpegimage/jpeg
Re: Web Service GetList issue
You removed it from the inbound mapping? Did you also remove it from the qualifications? And is your server set up to allow unqualified searches? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Tuesday, March 13, 2012 3:03 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service GetList issue ** This is what I get when I give 0. 0 is not valid selection for Maximum Limit., 5158, 0 is not valid selection for Start Record., 5158, Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov -Original Message- From: Jose Huerta To: arslist@ARSLIST.ORG Date: 03/13/2012 03:58 PM Subject: Re: Web Service GetList issue Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** I think that you must give a value. It isn't mandatory to publish these values at the input, but you need to provide a value for them. So put 0, 0 in order to not limit the response. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca -Original Message- On Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi wrote: ** Hi all, I am having issue with a web service with Getlist operation. Created the web service with Getlist operation to search multiple rows on a form. Removed the startRecord and maxLimit from Input mapping as I don't want to use those limits. However, I am seeing these values under qualification field with no values entered. When I try to consume the web service, it does not return any data. Any help would be appreciated. Thanks, Wirasat ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Web Service GetList issue
Yes, I have removed them from Input Mapping. And yes server is configured to allow unqualified searches. Thanks, Wirasat From: Grooms, Frederick W frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Date: 03/13/2012 04:09 PM Subject:Re: Web Service GetList issue Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG You removed it from the inbound mapping? Did you also remove it from the qualifications? And is your server set up to allow unqualified searches? Fred -Original Message- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Wirasat Siddiqi Sent: Tuesday, March 13, 2012 3:03 PM To: arslist@ARSLIST.ORG Subject: Re: Web Service GetList issue ** This is what I get when I give 0. 0 is not valid selection for Maximum Limit., 5158, 0 is not valid selection for Start Record., 5158, Thanks, Wirasat Siddiqi Remedy Development Team Desk Phone: 202-502-3204 Cell: 202-368-7190 Email: wirasat_sidd...@ao.uscourts.gov -Original Message- From:Jose Huerta To:arslist@ARSLIST.ORG Date:03/13/2012 03:58 PM Subject:Re: Web Service GetList issue Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** I think that you must give a value. It isn't mandatory to publish these values at the input, but you need to provide a value for them. So put 0, 0 in order to not limit the response. Jose M. Huerta Project Manager Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca -Original Message- On Tue, Mar 13, 2012 at 20:07, Wirasat Siddiqi wrote: ** Hi all, I am having issue with a web service with Getlist operation. Created the web service with Getlist operation to search multiple rows on a form. Removed the startRecord and maxLimit from Input mapping as I don't want to use those limits. However, I am seeing these values under qualification field with no values entered. When I try to consume the web service, it does not return any data. Any help would be appreciated. Thanks, Wirasat ___ 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 Server 7.6.04 patch 3 Installer and Reflection X Manager
Everyone thanks for your input. It turns out Fred's suggestion worked best. I used export DISPLAY=IP:1.0 and now I can see the installer GUI. Again, thanks to everyone for your very valuable feedback. Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.com www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, March 13, 2012 1:11 PM To: arslist@ARSLIST.ORG Subject: Re: AR Server 7.6.04 patch 3 Installer and Reflection X Manager I have seen issues with xWindows windows and RDC (it actually displays on the PC but RDC does not send that window across because the xWindows app is running in the console session and RDP is actually a new user login in another session). Try connecting to your PC thru RDC in a console session mstsc.exe /console (or mstsc.exe /admin) or alternatively set the DISPLAY environment to the second session DISPLAY=IP:1.0 (You can see what sessions there are by running qwinsta in a dos window on the PC) Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of America Account) Sent: Tuesday, March 13, 2012 12:48 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: AR Server 7.6.04 patch 3 Installer and Reflection X Manager I am at a loss here and was hoping someone on the list has encountered this issue. I am trying to do a AR Server upgrade on a SUN UNIX server. I can start an xterm session using the Reflection X Manager and do an export DISPLAY=IP Address and start the AR Server 7.6.03 installer and it will bring up the installer on my desktop display. This works great when I am directly logged onto my desktop. However, the issue I am having is when I am using Remove Desktop Connection (RDC) connected remotely to my desktop and perform that same steps to export the DISPLAY to my IP Address of my desktop it will not display the AR Server 7.6.03 installer. Is there some setting or trick I am missing to let me see the AR Server 7.6.03 installer when I am using RDC into my desktop? I have gone through all the settings on the Reflection X Manager and nothing is obvious that I need to set to make the AR Server 7.6.03 installer display when using RDC. Reflection X Manager version 14.1.0 AR Server 7.6.04 patch 3 Installer SUN OS 5.9 Christopher Pruitt Business Consulting III HP Enterprises Services christopher.pru...@hp.commailto:christopher.pru...@hp.com www.hp.comhttp://www.hp.com Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ 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 ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC_GLOBAL_DEFAULT_SRVC CI
Same for Problem or SLM Service field, the menu qualification do not filter only the CI-Asset related to the current company.. I suggest to change the menus attached to the Service Field.. On Tue, Mar 13, 2012 at 6:47 AM, Tauf Chowdhury taufc...@gmail.com wrote: I'm pretty sure it's tied to the default services that come with SRM. Sent from my iPhone On Mar 13, 2012, at 6:17 AM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: Hi All, CMDB 7.6.04 SP2 The BMC_GLOBAL_DEFAULT_SRVC CI appears in the Service field menu on the Infrastructure Change form. BMC tells us that this CI should never be deleted. Does anyone know precisely what it is for? I guess it's to do with the Service Catalog functionality in Atrium Core. I can set the status of this CI from its out-of-the-box value of 'Ordered' to 'End of Life' to remove it from the menu but would this affect the functionality that the CI is there to support? Cheers Peter ___ 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: Report error on web report drill-down
Hi what form are you running the report on? Are you sure that the form is not a Join Form? If it is a join form a drill down may give you this error. Shafqat Ayaz From: Joe Martin D'Souza jdso...@shyle.net To: arslist@ARSLIST.ORG Sent: Tuesday, March 13, 2012 6:53 PM Subject: Re: Report error on web report drill-down Its an assumption at this point that it may not be the issue. I forgot to mention that it could perhaps be renamed too. From the description of your environment, it is unlikely that these may be the issues. No experienced Remedy developer would delete or rename an already deployed form - but accidents can happen.. That’s a unforgivable crime in our world when it happens :-) Maybe you could use Ben Cherny's Meta-Update tool to perform a comparison with what you have on your server, to what's usually available OTB as he has a spreadsheet with all OTB forms documented. He was just discussing that on another thread ITSM 7.6.03 OTB forms that begin with CTM:Ppl% or CTM:PPL% that I had started... Not everything missing from the difference you see may mean a problem as some of the differences could be because of the components you have installed, opposed to those that were installed when that spreadsheet was generated. Also the patch you are on would also make a difference.. In the end, flushing the cache should resolve the problem.. Joe -Original Message- From: Kay Wilthew Sent: Tuesday, March 13, 2012 2:00 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Report error on web report drill-down Thanks for the suggestion, Joe. Your comment makes me question how a form could have been deleted when we're using an out of the box Remedy build, and there has never been any development performed. I am the only administrator and I've never done any development on our system. Is there a way to identify which form is missing, and is it really possible for a form to have been deleted? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Monday, March 12, 2012 3:12 PM To: arslist@ARSLIST.ORG Subject: Re: Report error on web report drill-down Try flushing the Mid-Tier cache. My hunch is you may have deleted the original form that table field was pointing to, and created a new form, to point it to. Even if that is not the case, refreshing your Mid-Tier cache would never hurt. Cheers Joe -Original Message- From: Kay W Sent: Monday, March 12, 2012 3:01 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Report error on web report drill-down When running a web report, the report generates fine but when clicking on the hyperlink to drill down to a specific record in the report, Internet Explorer 8 is generating an error that the page cannot be found. This is a simple web report created within Reports Console of an out-of-box installation of Remedy 7.6.04. Any trouble-shooting advice? Thanks, Kay ___ 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
SRM Read-Only Questions
Has anyone been successful in finding a way to provide a read-only question to the end user on an SRD? I know that it might not make sense but this is the situation we have. We have few questions on an SRD and we need to include a text field with a disclaimer for the customer to read it and confirm acknowledgement by checking a check box. The only caveat is that the text box cannot be read-only. It's either required, hidden or optional. Environment Specs: Oracle 10.2 SRM 7.6.02 ITSM 7.6.0 ARS 7.5.04 Regards, Moe. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are