ARS 7604 Custom App and Reporting Issues
hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7604 Custom App and Reporting Issues
The issue could be at two levels. a) How much time database takes to complete the execution of SQLs? It depends on how complex your queries and how much data you are running these queries on. You may improve this timing by getting the raw sqls for your report calculations and do a cost analysis and creating respective indexes. Sometimes even though you have indexed fields the db may think differently and may not make use of the indexed fields. Rerunning the database stats could help here. Also DBAs can do some settings to force database to use a different plan than the default one. This all depends on how your cost analysis of the sqls look like. b) How much data being generated in the results set and the amount of time it takes to transfer that data into client machine? Infrastructure on cloud will definitely makes a difference here. Specifically for reports. Basically the more further you are, the more network latency and hence the more the time it takes to render the reports with more data. Apart from above, I would suggest: 1. Use a private thread to run these reports. That way you would not impact regular users. Especially when your production system is also the reporting system. You can specify the private threads on your ODBC settings. 2. If the formulas are really complicated and they are the bottleneck even after creating indexes, instead of doing all those calculations at run time, run cronjobs/escalations/etl jobs to pre-calculate the formulas and populate the results into summarized tables. And use those tables for your reporting purpose. 3. Check your ARServer, DB Server memory and temp space size to make sure you are not breaching the limits. Since you mentioned you saw this happening even with user tool, increasing the midtier JVM does not help you here. Working closely with the DBAs would fetch you a lot for these kind of issues. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: WWRUG12 - Session Question - Database Moving
With Unix it is easy, you can just do a find command on IP or hostname in remedy folders to find all the references and make changes accordingly. But with windows not sure if the same approach will work with registries etc.. In either case I would suggest once your admins copy the VMs just remove/uninstall all remedy components/folders and just reinstall those again as a server group option. That way you would not miss any conf file or registry server name references. Since you are not really doing any upgrade install, just reinstalling same version the installer should not take much time. May be couple of hrs for the entire ITSM suite. Not sure how much it would help you the following. We had to rollout new ITSM env few years ago and we had to copy the db from preprod to prod during the cutover. So I went through several postings in arslist,bmc support site, bmc communities and made a list of items to do before and after. Some of the steps might be outdated or may not valid depending on the specific version so take it with grain of salt. Restore db from Development to Production: Pre db copy: 1. In production servers disable email engine,escalations in ar.conf 2. In dev server disable email mail boxes 3. Delete all pending or unwanted email entries Post db copy: 1. Update the default web path 2. Update Servername, Servergroupname, servergroup ranking entries 3. Form data changes: -- Report form entries with new Server Name -- change server name to development.fqdn or development -- SHARE:Application_Properties, HelpFile URL pointers -- SYS:Application form -- Survey URL -- CAI Application Registry -- In Connection tab, change all Server names from production.fqdn to development.fqdn -- SHR:Association -- The server name is stored in two fields on the form - Server 1 and Server 2 -- Configure Custom Form Info -- SYS:Attachments form -- CMS Configuration Management -- AP:Notifications - Check any custom notifications with Server links -- AP:Rule Definition (Server = @) -- AR System Server Group Operation Ranking -- AR System User Preferences -- Change Report Server values from production to development for any user account you are going to log in with on development -- AR System Administrator Preferences -- Partial List Settings - Partial List Details:Other - Pack List Settings -- AR System Searches Preference -- Delete records from original server -- AR System User Central File -- Delete records for user -- KMS:Administration_Integration-- Change Server Name and Short Description -- SRD:STAGE:MasterDataMappingList -- SRM:ApplicationSettings, if SRM installed, to point to correct web path -- AST:ARServerConnection -- AR Login Info -- AST:ComplianceARBased_Advanced--AR System License Type Compliance -- SYS:Escalations -- SYS:Attachments -- SLM:ConfigPreferences -- Update Dashboard MidTier URL -- SLM:RuleActionSetValue_base -- Found four records to change with SLA_destination Server Name = production.fqdn,Changed all of them to @ -- SLA data sources, service agreements, and service targets with milestones, after the db had been restored -- CHG:CCMCalendar:PrintActionWUT -- Active Links that contain server references -- AREmail Configuration -- update with production email accounts -- Table fields -- check with sql select distinct tfserver from field_table -- AIS:GlobalPreferences form (Atrium Impact Simulator) -- AIE EIE:ApplicationSettings form (field name: Help File Path) -- AIE EIE:BackUpLoadFlag form entries (field names: Host, Internal Instance Name,InstanceName) -- AIE EIE:DataExchange form entries (field names: Instance Name, zTmpInstanceAlias) -- BMC.CORE.CONFIG:BMC_FederatedInterface records (Field name: ARServerName) -- IEORA:RuleHelper (field name: Path) -- EIE:CommonDialog (Help File Path) -- Reinstall and Reconfigure AIE and all Data Exchanges -- Check in remedy metadata(AL,FL tables) to see any hard code server references. 4.The mid-tier configuration, where you specify the Data Visualization server 5.If you have customised any of the OOB notification messages to include a hardcoded a url then you need to change the server name reference. 6. Make sure all the integrations (webservices,scripts,apis,dblinks) pointing to correct environments. 7.Enable email engine,escalations. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Flush Cache with 2 Mid-Tiers load balanced
Hi All, I have 2 ARS 7.6.04 servers in a server group and 2 mid-tier servers. Starting with a VIP 2 load balancers 2 mid-tiers 2 load balancers 2 ARS Servers. After I have made changes on the ARS server, do I need to flush cache on both mid-tiers? Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.commailto:mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Flush Cache with 2 Mid-Tiers load balanced
To answer your question, yes if the changes are form/client side workflow related. However, why do you have 2 load balancers in front of the 2 mid tiers? Sent from my iPhone On Nov 1, 2012, at 9:24 AM, Brittain, Mark mbritt...@navisite.com wrote: ** Hi All, I have 2 ARS 7.6.04 servers in a server group and 2 mid-tier servers. Starting with a VIP 2 load balancers 2 mid-tiers 2 load balancers 2 ARS Servers. After I have made changes on the ARS server, do I need to flush cache on both mid-tiers? Thanks Mark *Mark Brittain* Remedy Developer ITILv3 Foundation *NaviSite – **A Time Warner Cable Company* mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 -- 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
Re: Flush Cache with 2 Mid-Tiers load balanced
Assuming two ARS Servers are sharing single database if you make any client side code change (Form/Menu/AL/Groups etc) yes you need to flush cache on all the midtiers. if you just made server side code change(Esc,FL) then no flush to midtier is needed. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7604 Custom App and Reporting Issues
From a strictly database viewpoint... 1. If you need the report often, the I would create a view in your database and have your report access that. Do all of your computations in the view. 2. If you only need the data once per month or so, I would create a stored procedure that does all of the calculations and call that from your report. In short, I would not use Crystal or AR to do the calculations. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Thursday, November 01, 2012 4:44 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7604 Custom App and Reporting Issues ** The issue could be at two levels. a) How much time database takes to complete the execution of SQLs? It depends on how complex your queries and how much data you are running these queries on. You may improve this timing by getting the raw sqls for your report calculations and do a cost analysis and creating respective indexes. Sometimes even though you have indexed fields the db may think differently and may not make use of the indexed fields. Rerunning the database stats could help here. Also DBAs can do some settings to force database to use a different plan than the default one. This all depends on how your cost analysis of the sqls look like. b) How much data being generated in the results set and the amount of time it takes to transfer that data into client machine? Infrastructure on cloud will definitely makes a difference here. Specifically for reports. Basically the more further you are, the more network latency and hence the more the time it takes to render the reports with more data. Apart from above, I would suggest: 1. Use a private thread to run these reports. That way you would not impact regular users. Especially when your production system is also the reporting system. You can specify the private threads on your ODBC settings. 2. If the formulas are really complicated and they are the bottleneck even after creating indexes, instead of doing all those calculations at run time, run cronjobs/escalations/etl jobs to pre-calculate the formulas and populate the results into summarized tables. And use those tables for your reporting purpose. 3. Check your ARServer, DB Server memory and temp space size to make sure you are not breaching the limits. Since you mentioned you saw this happening even with user tool, increasing the midtier JVM does not help you here. Working closely with the DBAs would fetch you a lot for these kind of issues. _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: ARS 7604 Custom App and Reporting Issues
Hi Vikrant, It doesn't really sound like your report should be taking too long to run. There may be some kind of design issue or fault somewhere.Most of the issues you outline can only really have marginal improvements. One common issue when using crystal is that you cannot really use the Remedy ODBC driver to do joins. In practice doing a join within the crystal report involves the application server doing a large number of individual queries and the overhead is massive. If you need to join 2 or more tables together then you should use a Remedy ARS join to do it and report against the join. Subreports work well when using the Remedy ODBC driver. Each subreport is effectively another query to ARS. Subreports give you a handy option to have a query defined from within Crystal itself. Perhaps if you give us a bit more information on the query and formulas you are having trouble with along with some rough row counts we may be able to help more. Rod On 1 November 2012 14:38, Vikrant vkulka...@columnit.com wrote: hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ 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
Mid Tier and Potential Proxy Issues
Good morning, For the past two weeks, we've seen issues within a specific subset of the users accessing the Mid Tier. Basically what happens is that they log in to Remedy (we have SSO so they don't actually log in), sometimes they can see the Home Page, sometimes they can't. Other times it's an issue opening a specific form, where you can see the framework of the landing page, but just a big grey area in the middle where an Incident or Change Request or Contract should be. This happens randomly, but I have suspicions about what causes it. Firstly, it is limited to Internet Explorer. Since we are in the process of upgrading to Windows 7 from XP, I've seen it happen regardless of what version of IE. It never happens in Firefox or Chrome, although they have their own issues rendering things sometimes. As I mentioned, there is a specific subset of the users that it is happening to, and unfortunately those users are people that I am not able to remote control their PCs to see what is going on. Secondly, I've been told through the grapevine that those users are being set up to have a proxy server, using Microsoft Forefront Threat Management Gateway. Again, this is something I can't verify right now since the users I am dealing with aren't really willing to work with me or give me access to their machines. I have an idea of how I can verify whether this is or isn't the case though. Given this background, the reason I contacted the ARSList is to see if anyone has had similar issues to what my users are experiencing, and if so how to resolve it. Also, if you haven't experienced these types of issues what steps would you use to troubleshoot them, whether or not you had access to their PCs? I'm assuming I will be able to get access to one of their computers so I will check their proxy settings as well as perform a traceroute, but is there anything else I should look for? Thanks, Shawn Pierson Remedy Developer | Energy Transfer Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Escape Character - Remedy Data Import Tool
Hi Kali, That does appear to be an issue with the import tool. I guess one thing you could do is convert the lowercase n to upper. I'm assuming you are on Windows and the file path is therefore not case sensitive. Rod On 31 October 2012 14:26, Kali Obsum kali.ob...@macquarie.com wrote: ** Hi Rod, ** ** Yep, we already tried that. It still converted \n to newline and retained one \. ** ** Regards, *Kali * ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Rod Harris *Sent:* Wednesday, October 31, 2012 1:35 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Escape Character - Remedy Data Import Tool ** ** ** Hi Kali, have you tried replacing each \ with 2? eg \\ Rod On 31 October 2012 12:53, Kali Obsum kali.ob...@macquarie.com wrote: ** Hi, We need to update a field via the Remedy Data Import Tool (v7.6.03). However the field values contain file paths and what happens is if the Import Tool sees a \n (e.g. app\new\temp), it erroneously converts it to a new line. Is there an escape char we can use so that it doesn’t get converted into a new line? Regards, *Kali * NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Mid Tier and Potential Proxy Issues
Shawn Can you get a Fiddler trace of a working and non-working example and send them to me? John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM - Issue with Draft Records (ARERR-150)
Hi, There can be a situation such as some customized macro is running while opening SR in draft mode which needs login info (Server name). While searching for resolution of this issue I got this work around. So please check that is this useful ? Regarding ARERR 150 - A server name must be supplied in the control record. The server field of the ARControlStruct parameter is empty. Supply the name of the server to reference in this field. Solution ARERR150 indicates that a server name reference that is required is missing. You may have recorded a macro and when recording it you had the prompt for log in turned on in the User Tool (In server info. -System - General - Server Information - Configuration tab ). Now when you run the macro it is looking for a server name and one is not supplied in the config file, or there was a config/utconfig file referenced, however that file is either no longer available or does not have a server name present. To solve this problem, you can either re-record the macro and include a login action, or with Prompt for login turned off log into the user tool to create a new config/utconfig file with appropriate information. The Prompt for Login option can also be constrained by a server setting which can be adjusted in Remedy Administrator. Make sure the server is configured to handle the Prompt for login situation By Preference -- then you will be able to properly configure the user tool. HTH -- Regards, Mayur Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Email: [hidden email] http://ars-action-request-system.1093659.n2.nabble.com/user/SendEmail.jtp?t ype=nodenode=7583733i=0 || Web Site: www.vyomlabs.com Follow Vyom Labs http://twitter.com/#!/vyomlabs http://twitter.com/#%21/vyomlabs || http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mohamed Abdelaziz Sent: Thursday, November 01, 2012 3:24 AM To: arslist@ARSLIST.ORG Subject: SRM - Issue with Draft Records (ARERR-150) ** Hello, As part of SRDs migration, I migrated all records we have in CFG Configuration AIF form from Dev to QA using arx format. Then, migrated all SRDs and related workflow. Now, everything seems to be working fine except when attempting to open an SR in Draft, I receive ARERR 150 A server name must be supplied in the control record. When I add the server name to the AIF configuration form, it works and let me open a Draft SR. However, upon closing the form, the AR Object List form pops up. I tried to delete the record from CFG AIF form and recreate it, but still behaves the same way. Has anyone encountered this issue before? Would really appreciate it if anyone can shed some light on what needs to be done to fix this issue. Thanks in Advance, Mohamed _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
Total Individual Transfers
Does anyone know how total transfers and individual transfers is calculated. Based on some of the incidents I am seeing the numbers don't add up as to what I think they should be. [Description: Description: Description: cid:image001.png@01CB1CFE.724B27B0] IT Accounts ITSM Enterprise Applications Manager University of New Hampshire Client Services Primary: (603) 862-2377 Alternate: (603) 862-4242 paul.hodg...@unh.edumailto:paul.hodg...@unh.edu http://accounts.unh.eduhttp://accounts.unh.edu/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.jpg
ITSM 8.0 will be slow in IE 8
Hello, I came across the following information about IE 8 and ITSM 8.0 1. Task Viewer feature is not supported with MS Internet Explorer 8. Also, 2. ITSM UI performance is slower for MS Internet Explorer 8 than for later versions of MS Internet Explorer Have anyone installed ITSM 8.0 and using IE 8 as browser, can let me know 1. About the UI performance? and 2. Is their any updates available in IE 8 that i can use to improve the UI performance.? we are in process for gathering requirments to upgrade to 8.0 currently we are using the IE 8.0.7601.17514 Thanks Ravi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
CRQ Implementer group.
We're on AR 7.5 and ITSM 7.6 and we're using the system mostly OOTB. I just ran into an oddity. When creating a CRQ, the 'implementer group' is being auto populated by a support group that has nothing to do with the CRQ or the submitter. On the CRQ itself, there's no field/ability to set/change the implementer group but on the approval screen, the field is there and displays the unrelated group. All of our CRQ's have the same implementer group assigned. Any idea where this is configured and why it's being set in this way? Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ITSM 8.0 will be slow in IE 8
there is suppose to be a patch out soon, for ITSM.. I do not know if that will help much, I suspect not.. you need to put in a support ticket to see if there is another patch soon for midtier .. or ars.. that will help.. IMHO On Thu, Nov 1, 2012 at 11:57 AM, SUBSCRIBE arslist prasad rpnampa...@gmail.com wrote: Hello, I came across the following information about IE 8 and ITSM 8.0 1. Task Viewer feature is not supported with MS Internet Explorer 8. Also, 2. ITSM UI performance is slower for MS Internet Explorer 8 than for later versions of MS Internet Explorer Have anyone installed ITSM 8.0 and using IE 8 as browser, can let me know 1. About the UI performance? and 2. Is their any updates available in IE 8 that i can use to improve the UI performance.? we are in process for gathering requirments to upgrade to 8.0 currently we are using the IE 8.0.7601.17514 Thanks Ravi ___ 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: CRQ Implementer group.
This is most likely due to an assignment mapping. While the fields aren't visible in the Best Practices view, they are visible in the older version of the Change Management form. I don't recall what I had to do to fix this, but I believe it involved changing the mappings so that the same groups get assigned as the Change Coordinator and the Change Implementer. Thanks, Shawn Pierson Remedy Developer | Energy Transfer 5051 Westheimer Rd. Houston, TX 77056 | 713.989.7226 If you would like to report an issue with Remedy, please navigate to http://remedy/issue.html From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Thursday, November 01, 2012 11:10 AM To: arslist@ARSLIST.ORG Subject: CRQ Implementer group. ** We're on AR 7.5 and ITSM 7.6 and we're using the system mostly OOTB. I just ran into an oddity. When creating a CRQ, the 'implementer group' is being auto populated by a support group that has nothing to do with the CRQ or the submitter. On the CRQ itself, there's no field/ability to set/change the implementer group but on the approval screen, the field is there and displays the unrelated group. All of our CRQ's have the same implementer group assigned. Any idea where this is configured and why it's being set in this way? Thanks _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [EXTERNAL] CRQ Implementer group.
I believe that happens due to the Assignment Rules. If you have an AR with an Event of -General- and that assignment rule is turned on for Change Management, it assigns the specified Support Group as the Implementer Group, which as Shawn indicated, is visible only on the Classic view. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Peters, Ron Sent: Thursday, November 01, 2012 10:10 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] CRQ Implementer group. ** We're on AR 7.5 and ITSM 7.6 and we're using the system mostly OOTB. I just ran into an oddity. When creating a CRQ, the 'implementer group' is being auto populated by a support group that has nothing to do with the CRQ or the submitter. On the CRQ itself, there's no field/ability to set/change the implementer group but on the approval screen, the field is there and displays the unrelated group. All of our CRQ's have the same implementer group assigned. Any idea where this is configured and why it's being set in this way? Thanks _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: Flush Cache with 2 Mid-Tiers load balanced
That makes sense. Thanks Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Thursday, November 01, 2012 9:29 AM To: arslist@ARSLIST.ORG Subject: Re: Flush Cache with 2 Mid-Tiers load balanced ** Assuming two ARS Servers are sharing single database if you make any client side code change (Form/Menu/AL/Groups etc) yes you need to flush cache on all the midtiers. if you just made server side code change(Esc,FL) then no flush to midtier is needed. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ 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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7604 Custom App and Reporting Issues
VikrantYou have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting a remote DB is not recommended for ARS setup. There are more than 10-12 known issues and defects on reporting for SP1 and SP2 Using report cause CPU spike, Does not account maxGetList, large report generation cause out of memory error, Null pointer exception, downloading report is very slow etc etc list is very big. You might want to check the Release doc specifically around reports. Thanks Ravi Rai Date: Thu, 1 Nov 2012 02:38:17 -0400 From: vkulka...@columnit.com Subject: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ 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: SRM - Issue with Draft Records (ARERR-150)
Hello, This looks like an edited version of BMC KA360782. Cheers, John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
OT: BMC Good news.. buyback
http://www.bloomberg.com/news/2012-10-31/bmc-software-plans-1-billion-share-buyback-after-exploring-sale.html?cmpid=yhoo -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: SRM - Issue with Draft Records (ARERR-150)
Correction KA331904 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARS 7604 Custom App and Reporting Issues
Ø Setting a remote DB is not recommended for ARS setup. That is not an accurate statement as it is phrased. The vast majority of our customers install AR System server on a different machine then where their database is running - and that is the recommended configuration. If you meant something different, you may wish to rephrase for accuracy. -David J. Easter Manager of Product Management, AR System BSM Atrium Solutions Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: Thursday, November 01, 2012 9:30 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7604 Custom App and Reporting Issues ** Vikrant You have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting a remote DB is not recommended for ARS setup. There are more than 10-12 known issues and defects on reporting for SP1 and SP2 Using report cause CPU spike, Does not account maxGetList, large report generation cause out of memory error, Null pointer exception, downloading report is very slow etc etc list is very big. You might want to check the Release doc specifically around reports. Thanks Ravi Rai Date: Thu, 1 Nov 2012 02:38:17 -0400 From: vkulka...@columnit.com Subject: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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
Re: ARS 7604 Custom App and Reporting Issues
Ravi, Where do you see this recommendation? Unless you are running a sandbox or demo virtual machine, running AR and DB on the same machine isn't recommended. Sent from my iPhone On Nov 1, 2012, at 12:30 PM, ravi rai ravira...@hotmail.com wrote: ** Vikrant You have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting a remote DB is not recommended for ARS setup. There are more than 10-12 known issues and defects on reporting for SP1 and SP2 Using report cause CPU spike, Does not account maxGetList, large report generation cause out of memory error, Null pointer exception, downloading report is very slow etc etc list is very big. You might want to check the Release doc specifically around reports. Thanks Ravi Rai Date: Thu, 1 Nov 2012 02:38:17 -0400 From: vkulka...@columnit.com Subject: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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
Re: Work info in task
Hello :) Sent from my iPhone On Nov 1, 2012, at 1:43 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Hello listers _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: Work info in task
Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Work info in task
Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _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: Work info in task
One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _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
Re: Work info in task
Does it work on the web then or same issue? Sent from my iPhone On Nov 1, 2012, at 1:57 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: [EXTERNAL] Re: Work info in task
I'm not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I've seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don't have the problem there, you can try clearing the User Tool's cache on the affected machine. Where you go to look for the User Tool's cache depends on what operating system your computer has and what version of the User Tool you're running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 11:57 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.commailto:rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.commailto:rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _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: [EXTERNAL] Re: Work info in task
There is a 7.6.04 user tool Thick client. We are currently using it Thank you, Pascale Sterrett nkst...@sandia.gov Sent by: arslist@ARSLIST.ORG 11/01/2012 11:21 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [EXTERNAL] Re: Work info in task ** I’m not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I’ve seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don’t have the problem there, you can try clearing the User Tool’s cache on the affected machine. Where you go to look for the User Tool’s cache depends on what operating system your computer has and what version of the User Tool you’re running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2008 – SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 11:57 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: HP UX: Upgrading install Oracle failed to connect the database.
Hi Patrick, Sorrywent for vacation. Still the same issue we are facing today Failed to connect database and in installer log we found following line. LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=INVALID_OCI_ORACLE_CONNECTION_UNIX]} We tried to fix by all possibilities from our side but no luck. Seems something is missing still some where. LD_LIBRARY_PATH is pointing now to the 64bit. I am able to do sqlplus and tnsping as well. Please suggest. -- Sandeep Pandey Remedy Developer On Thu, Oct 25, 2012 at 1:27 AM, patrick zandi remedy...@gmail.com wrote: ** Can I assume.. you are working sir ? On Tue, Oct 23, 2012 at 9:42 AM, patrick zandi remedy...@gmail.comwrote: it should say something like 11.2.0/lib On Tue, Oct 23, 2012 at 9:40 AM, patrick zandi remedy...@gmail.comwrote: There is your problem right there.. LD_LIBRARY_PATH=/ems/u01/ product/10.2.0/lib: 10.2 is 32bit -- not 64bit.. so it looks like your DBA are blowing smoke.. On Tue, Oct 23, 2012 at 9:29 AM, Sandeep Pandey sandeep.rem...@gmail.com wrote: ** Hi Patrick, Able to do sqlplus and TNSPING as well. We did LD_LIBRARY_PATH is pointing to the 64bit as per dbs confirms, but no hope. LD_LIBRARY_PATH=/ems/u01/product/10.2.0/lib:/ems/u01/product/10.2.0/lib32 is set like this currently. -- Sandeep Pandey Remedy Developer On Tue, Oct 23, 2012 at 5:59 PM, patrick zandi remedy...@gmail.comwrote: ** prior to installing can you use sqlplus and login, can you do a TNSPING? if those are working -- off the 64bit side.. then you should be fine.. but if you LD_LIBRARY_PATH is pointing to the 32bit, first, and not the 64bit first.. and you cannot use the sqlplus from the 11.. this is a great start On Tue, Oct 23, 2012 at 8:27 AM, Sandeep Pandey sandeep.rem...@gmail.com wrote: ** Yes Patrick, You are correct. Yes we are pointing new oracle client 64 bit for install upgrade. Do you know any fix or solution for this? -- Sandeep Pandey Remedy Developer On Tue, Oct 23, 2012 at 5:50 PM, Patrick Zandi remedy...@gmail.comwrote: ** But you are using 7.1 : that does not use 64 bit, so here is the thought. Is you box with oracle 32 bit client 10 let's say and 11.2 in the same box, so is your selection for the install pointing to the new client? Just asking. 2 different paths... Just a thought Sent from my iPhone On Oct 23, 2012, at 7:49, Sandeeps Pandey sandeep.rem...@gmail.com wrote: ** Hi Patrick, We are using 64 bit clients only. But not able to proceed. Checked everything tnsnames.ora, listner, env etc in place and running fine. -- Sandeep Pandey Remedy Developer On Tue, Oct 23, 2012 at 5:08 PM, Patrick Zandi remedy...@gmail.comwrote: ** 64 bit libraries You went from 32 to 64 You need 64bit client looks like ur issue Sent from my iPhone On Oct 23, 2012, at 6:55, Karthik karthik...@gmail.com wrote: ** I had this issue way back when i was installing 5.x on HP UX and it was issue with oracle binaries being wrongly installed. Did you check the compatibility matrix and install the correct binaries? Double check this please as the error says the same here - Karthik On 23 October 2012 16:10, Sandeep Pandey sandeep.rem...@gmail.comwrote: ** Dear List, We are facing one issue when we trying to upgrade the 7.1 P11 to 7.6.04 SP 3 ARS on HP-UX i3. We are running installer and one point of time getting below error. Warning! Failed to connect to the database. Possible causes: tnsnames.ora does not exist or has incorrect connection details Missing 64 bit Oracle client libraries Insufficient privileges for oracle client libraries. Error in insall log: LOG EVENT {Description=[SET PROPERTY BMC_LEGACY_ARCFG_EXISTS],Detail=[true]} (Oct 22 2012 12:49:22.319 PM +0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[INVALID_OCI_ORACLE_CONNECTION_UNIX]} (Oct 22 2012 12:49:22.329 PM +0200),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseOptionsValidationTask, LOG EVENT {Description=[Validation error],Detail=[INVALID_OCI_ORACLE_CONNECTION_UNIX]} (Oct 22 2012 12:49:22.764 PM +0200),CONFIG,com.bmc.install.builder.installanywhere.InstallationTaskAction, LOG EVENT {Description=[COMPLETED InstallationTask],Detail=[com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseOptionsValidationTask]} (Oct 22 2012 12:51:12.791 PM +0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[VALIDATION_SUCCESS]} (Oct 22 2012 12:51:12.811 PM +0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, LOG EVENT {Description=[SET PROPERTY VALIDATION_FEATURE],Detail=[]} We did so many things but no help. Anyone see or fix? -- Sandeep Pandey Remedy Developer
Re: Work info in task
Hello, I haven't on web, but i assume it will not there also On Nov 1, 2012 11:28 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Does it work on the web then or same issue? Sent from my iPhone On Nov 1, 2012, at 1:57 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: [EXTERNAL] Re: Work info in task
Yes, there is a client, but ITSM 7.6.04 does not work 'fully' in the client. I believe that is what they were referring to. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.com Sent: Thursday, November 01, 2012 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Re: Work info in task There is a 7.6.04 user tool Thick client. We are currently using it Thank you, Pascale Sterrett nkst...@sandia.gov Sent by: arslist@ARSLIST.ORG 11/01/2012 11:21 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [EXTERNAL] Re: Work info in task ** I’m not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I’ve seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don’t have the problem there, you can try clearing the User Tool’s cache on the affected machine. Where you go to look for the User Tool’s cache depends on what operating system your computer has and what version of the User Tool you’re running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2008 – SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 11:57 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation. ___ 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: [EXTERNAL] Re: Work info in task
Thanks for the input natalie I have scenario on user as well as mine machine as where he login doea not work but mine does. Note this is not happening for nor only one user but its been report by few when woek on tasks On Nov 1, 2012 11:51 PM, Stroud, Natalie K nkst...@sandia.gov wrote: ** I’m not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. ** ** And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I’ve seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don’t have the problem there, you can try clearing the User Tool’s cache on the affected machine. ** ** Where you go to look for the User Tool’s cache depends on what operating system your computer has and what version of the User Tool you’re running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. ** ** Good luck! ** ** *Natalie Stroud* SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2008 – SQL Server 2008 ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Rajesh Nair *Sent:* Thursday, November 01, 2012 11:57 AM *To:* arslist@ARSLIST.ORG *Subject:* [EXTERNAL] Re: Work info in task ** ** ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote:* *** Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: [EXTERNAL] Re: Work info in task
We use client version7.5 But changing the version of the client cannot be a solution? I doudt the workflow written on the work info for task. It does not returns on double click as it does for other module. We have to select one by one and say view.for me it work as gems but for not consultant they are able to view only the first entry On Nov 1, 2012 11:59 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.mil wrote: Yes, there is a client, but ITSM 7.6.04 does not work 'fully' in the client. I believe that is what they were referring to. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.com Sent: Thursday, November 01, 2012 12:23 PM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Re: Work info in task There is a 7.6.04 user tool Thick client. We are currently using it Thank you, Pascale Sterrett nkst...@sandia.gov Sent by: arslist@ARSLIST.ORG 11/01/2012 11:21 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: [EXTERNAL] Re: Work info in task ** I’m not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I’ve seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don’t have the problem there, you can try clearing the User Tool’s cache on the affected machine. Where you go to look for the User Tool’s cache depends on what operating system your computer has and what version of the User Tool you’re running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2008 – SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 11:57 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ If you are not the intended addressee, please inform us immediately that you have received this e-mail in error, and delete it. We thank you for your cooperation. ___ 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: [EXTERNAL] Re: Work info in task
Rajesh, Just a thought - are users logging into the Preference Server? (I don't recall if that's relevant to 7.1.)If so, how about removing or renaming their entry in the AR System User Preference form to see if it helps, since this is occurring on differenct machines. David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 2:34 PM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Re: Work info in task ** Thanks for the input natalie I have scenario on user as well as mine machine as where he login doea not work but mine does. Note this is not happening for nor only one user but its been report by few when woek on tasks On Nov 1, 2012 11:51 PM, Stroud, Natalie K nkst...@sandia.govmailto:nkst...@sandia.gov wrote: ** I'm not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I've seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don't have the problem there, you can try clearing the User Tool's cache on the affected machine. Where you go to look for the User Tool's cache depends on what operating system your computer has and what version of the User Tool you're running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 11:57 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.commailto:rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.commailto:rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _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
Runmacro
What is the replacement for runmacro in 8.0? I use it in Command Line dumps from forms. It makes it real easy to integrate it into scheduled jobs Gordon Frank ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [EXTERNAL] Re: Work info in task
Rajesh: No, you do not need to change your client version right now. I'm having a little trouble understanding your English, but I will try to explain better. Can you have your consultant log in via the 7.5 client on a different computer and try viewing the task? When you log in on your computer and it works for you, that is one test and it is a good one to start with. However, that cannot tell us if the problem is with your consultant's computer. So if you have the consultant log in via the 7.5 client on a different computer, we can see if the problem happens ONLY on their computer. You can also try deleting your consultant's Preference file like David suggested. Thanks, Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Re: Work info in task ** We use client version7.5 But changing the version of the client cannot be a solution? I doudt the workflow written on the work info for task. It does not returns on double click as it does for other module. We have to select one by one and say view.for me it work as gems but for not consultant they are able to view only the first entry On Nov 1, 2012 11:59 PM, Longwing, LJ CTR MDA/IC lj.longwing@mda.milmailto:lj.longwing@mda.mil wrote: Yes, there is a client, but ITSM 7.6.04 does not work 'fully' in the client. I believe that is what they were referring to. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.commailto:pascale.sterr...@daimler.com Sent: Thursday, November 01, 2012 12:23 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] Re: Work info in task There is a 7.6.04 user tool Thick client. We are currently using it Thank you, Pascale Sterrett nkst...@sandia.govmailto:nkst...@sandia.gov Sent by: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG 11/01/2012 11:21 AM Please respond to arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG To arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG cc Subject Re: [EXTERNAL] Re: Work info in task ** I'm not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I've seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don't have the problem there, you can try clearing the User Tool's cache on the affected machine. Where you go to look for the User Tool's cache depends on what operating system your computer has and what version of the User Tool you're running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh Nair Sent: Thursday, November 01, 2012 11:57 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.commailto:taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.commailto:rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.commailto:rajesh.nair@gmail.com wrote: Hello listers _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the
Re: [EXTERNAL] Re: Work info in task
They are not using preference server. But yes i have not checked if thier is a entry thier On Nov 2, 2012 12:19 AM, David Durling durl...@uga.edu wrote: ** Rajesh, ** ** Just a thought – are users logging into the Preference Server? (I don’t recall if that’s relevant to 7.1.)If so, how about removing or renaming their entry in the AR System User Preference form to see if it helps, since this is occurring on differenct machines. ** ** David ** ** David Durling University of Georgia ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Rajesh Nair *Sent:* Thursday, November 01, 2012 2:34 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: [EXTERNAL] Re: Work info in task ** ** ** Thanks for the input natalie I have scenario on user as well as mine machine as where he login doea not work but mine does. Note this is not happening for nor only one user but its been report by few when woek on tasks On Nov 1, 2012 11:51 PM, Stroud, Natalie K nkst...@sandia.gov wrote:** ** ** I’m not sure offhand whether 7.1 is supposed to work with the User Tool (client). I know 7.6 is mid-tier only. And the User Tool does create a cache that occasionally gets corrupted by changes developers make on the servers. I’ve seen all sorts of odd behavior from that. Have you had the user who has this problem try logging in via the client on a different machine? If they don’t have the problem there, you can try clearing the User Tool’s cache on the affected machine. Where you go to look for the User Tool’s cache depends on what operating system your computer has and what version of the User Tool you’re running, but the location is usually the home directory associated with the installation of the User Tool (where the arcmds folder is located) Log out of Remedy, delete all folders in the home directory except for arcmds and NONE of the individual files, then have them log in and try again. Good luck! *Natalie Stroud* SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2008 – SQL Server 2008 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Rajesh Nair *Sent:* Thursday, November 01, 2012 11:57 AM *To:* arslist@ARSLIST.ORG *Subject:* [EXTERNAL] Re: Work info in task ** One mor thing missed out tauf it via client On Nov 1, 2012 11:23 PM, Tauf Chowdhury taufc...@gmail.com wrote: ** Rajesh, It sounds like it could be a browser or browser cache issue. Did you try clearing cache and/or using different browser? Sent from my iPhone On Nov 1, 2012, at 1:48 PM, Rajesh Nair rajesh.nair@gmail.com wrote: ** Soory for the incomplete mail Have an issue seen very recently In task management if any tries to open the work info add he/she is able to open only the first work info, if we try to open the any othet then the systemdoes not select the entry. Only the first one get selected As an admin it works fine for me. I tried give the user task admin manager permission but still it does work Any ideas? Is it a defect Arsystem 7.1 itsm 7.1 On Nov 1, 2012 11:13 PM, Rajesh Nair rajesh.nair@gmail.com wrote:* *** Hello listers _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _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
Re: HP UX: Upgrading install Oracle failed to connect the database.
When you run the SQLPLUS does it come up and show it is the Oracle 11 version? # sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 1 13:45:36 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. If I remember correctly you also need to go in and add a symbolic link in the oracle library directory. To check do the following: # cd $ORACLE_HOME/lib # ls -al libclntsh* You will see something like: -rwxrwxr-x 1 {user} {group} 45396816 Sep 9 2010 libclntsh.so.11.1 lrwxrwxrwx 1 {user} {group}17 Jan 6 2011 libclntsh.so - libclntsh.so.11.1 lrwxrwxrwx 1 {user} {group}12 Jan 6 2011 libclntsh.so.10.1 - libclntsh.so In your case you probably only have libclntsh.so.11.1. If so then create the 2 symbolic links: # ln -s libclntsh.so.11.1 libclntsh.so # ln -s libclntsh.so libclntsh.so.10.1 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Thursday, November 01, 2012 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: HP UX: Upgrading install Oracle failed to connect the database. ** Hi Patrick, Sorrywent for vacation. Still the same issue we are facing today Failed to connect database and in installer log we found following line. LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=INVALID_OCI_ORACLE_CONNECTION_UNIX]} We tried to fix by all possibilities from our side but no luck. Seems something is missing still some where. LD_LIBRARY_PATH is pointing now to the 64bit. I am able to do sqlplus and tnsping as well. Please suggest. -- Sandeep Pandey Remedy Developer -Original Message- On Thu, Oct 25, 2012 at 1:27 AM, patrick zandi wrote: ** Can I assume.. you are working sir ? -Original Message- On Tue, Oct 23, 2012 at 9:42 AM, patrick zandi wrote: it should say something like 11.2.0/lib -Original Message- On Tue, Oct 23, 2012 at 9:40 AM, patrick zandi wrote: There is your problem right there.. LD_LIBRARY_PATH=/ems/u01/ product/10.2.0/lib: 10.2 is 32bit -- not 64bit.. so it looks like your DBA are blowing smoke.. -Original Message- On Tue, Oct 23, 2012 at 9:29 AM, Sandeep Pandey wrote: ** Hi Patrick, Able to do sqlplus and TNSPING as well. We did LD_LIBRARY_PATH is pointing to the 64bit as per dbs confirms, but no hope. LD_LIBRARY_PATH=/ems/u01/product/10.2.0/lib:/ems/u01/product/10.2.0/lib32 is set like this currently. -- Sandeep Pandey Remedy Developer -Original Message- On Tue, Oct 23, 2012 at 5:59 PM, patrick zandi wrote: ** prior to installing can you use sqlplus and login, can you do a TNSPING? if those are working -- off the 64bit side.. then you should be fine.. but if you LD_LIBRARY_PATH is pointing to the 32bit, first, and not the 64bit first.. and you cannot use the sqlplus from the 11.. this is a great start On Tue, Oct 23, 2012 at 8:27 AM, Sandeep Pandey sandeep.rem...@gmail.com wrote: ** Yes Patrick, You are correct. Yes we are pointing new oracle client 64 bit for install upgrade. Do you know any fix or solution for this? -- Sandeep Pandey Remedy Developer -Original Message- On Tue, Oct 23, 2012 at 5:50 PM, Patrick Zandi wrote: ** But you are using 7.1 : that does not use 64 bit, so here is the thought. Is you box with oracle 32 bit client 10 let's say and 11.2 in the same box, so is your selection for the install pointing to the new client? Just asking. 2 different paths... Just a thought Sent from my iPhone -Original Message- On Oct 23, 2012, at 7:49, Sandeeps Pandey wrote: ** Hi Patrick, We are using 64 bit clients only. But not able to proceed. Checked everything tnsnames.ora, listner, env etc in place and running fine. -- Sandeep Pandey Remedy Developer -Original Message- On Tue, Oct 23, 2012 at 5:08 PM, Patrick Zandi wrote: ** 64 bit libraries You went from 32 to 64 You need 64bit client looks like ur issue Sent from my iPhone -Original Message- On Oct 23, 2012, at 6:55, Karthik wrote: ** I had this issue way back when i was installing 5.x on HP UX and it was issue with oracle binaries being wrongly installed. Did you check the compatibility matrix and install the correct binaries? Double check this please as the error says the same here - Karthik -Original Message- On 23 October 2012 16:10, Sandeep Pandey wrote: ** Dear List, We are facing one issue when we trying to upgrade the 7.1 P11 to 7.6.04 SP 3 ARS on HP-UX i3. We are running installer and one point of time getting below error. Warning! Failed to connect to the database. Possible causes: tnsnames.ora does not exist or has incorrect connection details Missing 64 bit Oracle client libraries Insufficient privileges for oracle client libraries. Error in insall log: LOG EVENT {Description=[SET PROPERTY
Re: Runmacro
Hi, You still have runmacro. You also have a arexport.sh that exports data which uses the artools java class (didn't try it yet). And, if it's not enough, you also have Data Integration (Pentaho Spoon+Kettle) that is nice for this kind of jobs. :) On Thu, Nov 1, 2012 at 7:54 PM, Gordon Frank gjj...@comcast.net wrote: ** What is the replacement for runmacro in 8.0? I use it in Command Line dumps from forms. It makes it real easy to integrate it into scheduled jobs Gordon Frank _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: HP UX: Upgrading install Oracle failed to connect the database.
Hi Fred, Please see following output. Looks okay below configuration. please suggest. Thanks. sqlplus SQL*Plus: Release 11.2.0.3.0 Production on To Nov 1 20:46:44 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. cd $ORACLE_HOME/lib ls -al libclntsh* lrwxr-xr-x 1 oraars oinstall 45 okt 8 08:45 libclntsh.so - /ems/u01/product/11.2.0/lib/libclntsh.so.11.1 lrwxr-xr-x 1 oraars oinstall 12 okt 8 08:39 libclntsh.so.10.1 - libclntsh.so -rwxr-xr-x 1 oraars oinstall 120559664 okt 8 08:46 libclntsh.so.11.1 -rwxr-xr-x 1 oraars oinstall 120559664 okt 8 08:39 libclntsh_nopthread.so -- Sandeep Pandey Remedy Developer On Fri, Nov 2, 2012 at 1:08 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: When you run the SQLPLUS does it come up and show it is the Oracle 11 version? # sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 1 13:45:36 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. If I remember correctly you also need to go in and add a symbolic link in the oracle library directory. To check do the following: # cd $ORACLE_HOME/lib # ls -al libclntsh* You will see something like: -rwxrwxr-x 1 {user} {group} 45396816 Sep 9 2010 libclntsh.so.11.1 lrwxrwxrwx 1 {user} {group}17 Jan 6 2011 libclntsh.so - libclntsh.so.11.1 lrwxrwxrwx 1 {user} {group}12 Jan 6 2011 libclntsh.so.10.1 - libclntsh.so In your case you probably only have libclntsh.so.11.1. If so then create the 2 symbolic links: # ln -s libclntsh.so.11.1 libclntsh.so # ln -s libclntsh.so libclntsh.so.10.1 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Thursday, November 01, 2012 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: HP UX: Upgrading install Oracle failed to connect the database. ** Hi Patrick, Sorrywent for vacation. Still the same issue we are facing today Failed to connect database and in installer log we found following line. LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=INVALID_OCI_ORACLE_CONNECTION_UNIX]} We tried to fix by all possibilities from our side but no luck. Seems something is missing still some where. LD_LIBRARY_PATH is pointing now to the 64bit. I am able to do sqlplus and tnsping as well. Please suggest. -- Sandeep Pandey Remedy Developer -Original Message- On Thu, Oct 25, 2012 at 1:27 AM, patrick zandi wrote: ** Can I assume.. you are working sir ? -Original Message- On Tue, Oct 23, 2012 at 9:42 AM, patrick zandi wrote: it should say something like 11.2.0/lib -Original Message- On Tue, Oct 23, 2012 at 9:40 AM, patrick zandi wrote: There is your problem right there.. LD_LIBRARY_PATH=/ems/u01/ product/10.2.0/lib: 10.2 is 32bit -- not 64bit.. so it looks like your DBA are blowing smoke.. -Original Message- On Tue, Oct 23, 2012 at 9:29 AM, Sandeep Pandey wrote: ** Hi Patrick, Able to do sqlplus and TNSPING as well. We did LD_LIBRARY_PATH is pointing to the 64bit as per dbs confirms, but no hope. LD_LIBRARY_PATH=/ems/u01/product/10.2.0/lib:/ems/u01/product/10.2.0/lib32 is set like this currently. -- Sandeep Pandey Remedy Developer -Original Message- On Tue, Oct 23, 2012 at 5:59 PM, patrick zandi wrote: ** prior to installing can you use sqlplus and login, can you do a TNSPING? if those are working -- off the 64bit side.. then you should be fine.. but if you LD_LIBRARY_PATH is pointing to the 32bit, first, and not the 64bit first.. and you cannot use the sqlplus from the 11.. this is a great start On Tue, Oct 23, 2012 at 8:27 AM, Sandeep Pandey sandeep.rem...@gmail.com wrote: ** Yes Patrick, You are correct. Yes we are pointing new oracle client 64 bit for install upgrade. Do you know any fix or solution for this? -- Sandeep Pandey Remedy Developer -Original Message- On Tue, Oct 23, 2012 at 5:50 PM, Patrick Zandi wrote: ** But you are using 7.1 : that does not use 64 bit, so here is the thought. Is you box with oracle 32 bit client 10 let's say and 11.2 in the same box, so is your selection for the install pointing to the new client? Just asking. 2 different paths... Just a thought Sent from my iPhone -Original Message- On Oct 23, 2012, at 7:49, Sandeeps Pandey wrote: ** Hi Patrick, We are using 64 bit clients only. But not able to proceed. Checked everything tnsnames.ora, listner, env etc in place and running fine. -- Sandeep Pandey Remedy Developer -Original Message- On Tue, Oct 23, 2012 at 5:08 PM, Patrick Zandi wrote: ** 64 bit libraries You went from 32 to 64 You need 64bit client looks like ur issue Sent from my iPhone -Original Message- On Oct 23, 2012, at 6:55, Karthik wrote: ** I had this issue way back when i was installing 5.x on HP
Re: ARS 7604 Custom App and Reporting Issues
Tauf, I am not suggesting to run DB and ARS on Same Machine but Vikrant is saying Remote SQL server Defination of Remote is not clear. Vikrant can suggest how remote it is. Thanks Ravi Rai Date: Thu, 1 Nov 2012 13:32:14 -0400 From: taufc...@gmail.com Subject: Re: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG ** Ravi, Where do you see this recommendation? Unless you are running a sandbox or demo virtual machine, running AR and DB on the same machine isn't recommended. Sent from my iPhone On Nov 1, 2012, at 12:30 PM, ravi rai ravira...@hotmail.com wrote: ** Vikrant You have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting a remote DB is not recommended for ARS setup. There are more than 10-12 known issues and defects on reporting for SP1 and SP2 Using report cause CPU spike, Does not account maxGetList, large report generation cause out of memory error, Null pointer exception, downloading report is very slow etc etc list is very big. You might want to check the Release doc specifically around reports. Thanks Ravi Rai Date: Thu, 1 Nov 2012 02:38:17 -0400 From: vkulka...@columnit.com Subject: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _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
Re: ARS 7604 Custom App and Reporting Issues
David, My point was not to install AR and Db on the same machine If ARS amd DB are remote enogh it will cause overhead on network and have performance issues, which he is complaining My interpretation of Remote was may be they are differnet location\Building \network causing overhead on Network vikrant can check and confirm how remote is the DB :) If you run remote database servers, you increase the traffic over your network, resulting in slower system performance. In addition, remote databases consume other operating system resources on the local machines, such as memory. Make sure that your network does not decrease performance if you run a remote database. Thanks Ravi Rai Date: Thu, 1 Nov 2012 12:23:48 -0500 From: david_eas...@bmc.com Subject: Re: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG ** Ø Setting a remote DB is not recommended for ARS setup. That is not an accurate statement as it is phrased. The vast majority of our customers install AR System server on a different machine then where their database is running – and that is the recommended configuration. If you meant something different, you may wish to rephrase for accuracy. -David J. Easter Manager of Product Management, AR System BSM Atrium Solutions Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai Sent: Thursday, November 01, 2012 9:30 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7604 Custom App and Reporting Issues ** Vikrant You have mentioned REMOTE SQL 2008 DB. That might be the cause. Setting a remote DB is not recommended for ARS setup. There are more than 10-12 known issues and defects on reporting for SP1 and SP2 Using report cause CPU spike, Does not account maxGetList, large report generation cause out of memory error, Null pointer exception, downloading report is very slow etc etc list is very big. You might want to check the Release doc specifically around reports. Thanks Ravi Rai Date: Thu, 1 Nov 2012 02:38:17 -0400 From: vkulka...@columnit.com Subject: ARS 7604 Custom App and Reporting Issues To: arslist@ARSLIST.ORG hi Everyone, We are facing some issues in crystal report for one of our client. The crystal report is a call details report with about 30 fields in it which included about 10 formula fields. The issue we are facing is that it takes a lot of time to extract a single report and at a time we can only extract report for a time span of 30 days if we increase the time span it just gets stuck and we get nothing the user tool just gets stuck. The application is a complete custom application and we are not using anything OOTB apart from foundation part(people form, user form etc). The AR architecture is such that we have only 1 application server (ARS 7.6.0.4 SP2) which is our reporting server as well. Then we have a remote SQL 2008 DB and a stand alone MT ARS 7.6.0.4. The configurations of the above servers is as below ARS/Reporting Server = 32GB RAM 100Gb HDD 2.6Ghz dual core 2 processors. SQL or DB server = 16GB RAM 500GB HDD 2.6Ghz dual core 2 processors. MT Server = 16GB RAM 100GB HDD 2.6Ghz dual core 2 processors. Now there are few things that we plan to configure to improve performance on the system and would like some opinion on the same from you guys so as to what more can be done on the same. Things we plan to do : 1) Threads and queues to be configured : Gradually increase the number of threads from the default value (not sure about the number) 2) Indexes : To set 6-7 fields as indexes on the form on which the reports runs. 3) Disable unwanted escalation : Don't know if this will help but will try to disable most of the unwanted OOTB escalations which we do not use. 4) MT JVM memory check : Its already set to max = 1024 MB not sure how much can we increase it more. 5) Check for DB side configuration : This is something new we are trying to find out things that we can configure on DB side to get better performance. Also we think this all infrastructure being on cloud would make a difference as well am I right? Thanks in advance for the replies. Regards, Vikrant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_
No Lock Setting on AR CFG
Hi, We are getting few DB lock cases and planning to implement READ-COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION (Long term) There was a recent thread on NO Lock in Ar.cfg. Planning to add No Lock for short term What impact it has on performance of the system. Anyone implemented it faced any issues BMC suggested:NOLOCK should NOT be enabled – this is contrary to our guides, but is the correct settings per BMC Performance and deployment teams Please suggest Thanks Ravi Rai ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: HP UX: Upgrading install Oracle failed to connect the database.
Try running ldd on the 7.6.04 arserverd file ldd arserverd That should tell you if all shared libraries are able to be found Running file on the 7.6.04 arserverd binary file should tell you the version of the file file arserverd Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Thursday, November 01, 2012 3:01 PM To: arslist@ARSLIST.ORG Subject: Re: HP UX: Upgrading install Oracle failed to connect the database. ** Hi Fred, Please see following output. Looks okay below configuration. please suggest. Thanks. sqlplus SQL*Plus: Release 11.2.0.3.0 Production on To Nov 1 20:46:44 2012 Copyright (c) 1982, 2011, Oracle. All rights reserved. cd $ORACLE_HOME/lib ls -al libclntsh* lrwxr-xr-x 1 oraars oinstall 45 okt 8 08:45 libclntsh.so - /ems/u01/product/11.2.0/lib/libclntsh.so.11.1 lrwxr-xr-x 1 oraars oinstall 12 okt 8 08:39 libclntsh.so.10.1 - libclntsh.so -rwxr-xr-x 1 oraars oinstall 120559664 okt 8 08:46 libclntsh.so.11.1 -rwxr-xr-x 1 oraars oinstall 120559664 okt 8 08:39 libclntsh_nopthread.so -- Sandeep Pandey Remedy Developer -Original Message- On Fri, Nov 2, 2012 at 1:08 AM, Grooms, Frederick W wrote: When you run the SQLPLUS does it come up and show it is the Oracle 11 version? # sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 1 13:45:36 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved. If I remember correctly you also need to go in and add a symbolic link in the oracle library directory. To check do the following: # cd $ORACLE_HOME/lib # ls -al libclntsh* You will see something like: -rwxrwxr-x 1 {user} {group} 45396816 Sep 9 2010 libclntsh.so.11.1 lrwxrwxrwx 1 {user} {group} 17 Jan 6 2011 libclntsh.so - libclntsh.so.11.1 lrwxrwxrwx 1 {user} {group} 12 Jan 6 2011 libclntsh.so.10.1 - libclntsh.so In your case you probably only have libclntsh.so.11.1. If so then create the 2 symbolic links: # ln -s libclntsh.so.11.1 libclntsh.so # ln -s libclntsh.so libclntsh.so.10.1 Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Thursday, November 01, 2012 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: HP UX: Upgrading install Oracle failed to connect the database. ** Hi Patrick, Sorrywent for vacation. Still the same issue we are facing today Failed to connect database and in installer log we found following line. LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=INVALID_OCI_ORACLE_CONNECTION_UNIX]} We tried to fix by all possibilities from our side but no luck. Seems something is missing still some where. LD_LIBRARY_PATH is pointing now to the 64bit. I am able to do sqlplus and tnsping as well. Please suggest. -- Sandeep Pandey Remedy Developer -Original Message- On 23 October 2012 16:10, Sandeep Pandey wrote: ** Dear List, We are facing one issue when we trying to upgrade the 7.1 P11 to 7.6.04 SP 3 ARS on HP-UX i3. We are running installer and one point of time getting below error. Warning! Failed to connect to the database. Possible causes: tnsnames.ora does not exist or has incorrect connection details Missing 64 bit Oracle client libraries Insufficient privileges for oracle client libraries. Error in insall log: LOG EVENT {Description=[SET PROPERTY BMC_LEGACY_ARCFG_EXISTS],Detail=[true]} (Oct 22 2012 12:49:22.319 PM +0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[INVALID_OCI_ORACLE_CONNECTION_UNIX]} (Oct 22 2012 12:49:22.329 PM +0200),INFO,com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseOptionsValidationTask, LOG EVENT {Description=[Validation error],Detail=[INVALID_OCI_ORACLE_CONNECTION_UNIX]} (Oct 22 2012 12:49:22.764 PM +0200),CONFIG,com.bmc.install.builder.installanywhere.InstallationTaskAction, LOG EVENT {Description=[COMPLETED InstallationTask],Detail=[com.bmc.install.product.arsuitekit.platforms.arsystemservers.arserver.ARServerDatabaseOptionsValidationTask]} (Oct 22 2012 12:51:12.791 PM +0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, LOG EVENT {Description=[SET PROPERTY VALIDATION_ERROR_RESULT],Detail=[VALIDATION_SUCCESS]} (Oct 22 2012 12:51:12.811 PM +0200),CONFIG,com.bmc.install.task.InstallationPropertiesHelper, LOG EVENT {Description=[SET PROPERTY VALIDATION_FEATURE],Detail=[]} We did so many things but no help. Anyone see or fix? -- Sandeep Pandey Remedy Developer ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are