Re: ERROR (1291053)
Hi All, First of all, thanks everyone for your help! I did some tests and I think that I figure out the reason for the error message. As I said before, I am trying to update some information related to incidents that already exist in my Remedy environment. These incidents don't have the assignee information filled in. So, my idea is to assign some users to this field (assignee). Now, I noted that the filter HPD:INC:ValidateAsgneeShft_055 has the criteria below (I highlighted what I think it the reason for this issue); (( 'Assigned Support Company' != 'DB.Assigned Support Company') OR ( 'Assigned Support Organization' != 'DB.Assigned Support Organization') OR ( 'Assigned Group' != 'DB.Assigned Group') OR ( 'Assigned Group ID' != 'DB.Assigned Group ID') OR ( 'Assigned Group Shift Name' != 'DB.Assigned Group Shift Name') OR ( 'Assigned Group Shift ID' != 'DB.Assigned Group Shift ID') *OR ( 'Assignee' != 'DB.Assignee') OR ( 'Assignee Login ID' != 'DB.Assignee Login ID')*) AND ( 'Assignee' != $NULL$ ) AND ( 'Assigned Group Shift Name' != $NULL$ ) AND ( 'z1D Char01' = $NULL$ ) According to my understanding, the RUNIF is comparing the current value value for fields (for instance, both highlighted above) with the value stored in database. In my case, I am trying to set some value for Assignee field but this value in database is null. So, these conditions is true which means that the filter runs. I removed both conditions from filter and I got successful to update the incidents. If it is true, the same error should happened when you do it through GUI. Don't you agree? My concerns are: How does the GUI dealt with this? Does it disable the filter before creating/updating the incidents? 2010/7/16 Doug Blair d...@blairing.com Mauro, This is a common error message construction in a lot of the BMC ITSM applications. The z1DChar01 field is just a temporary field that holds the results of some other query. This error message construction usually consists of two filters with almost identical RUNIF's. The first filter tests for some condition by (for example) looking up the contents of a field to see if that text is valid for this ticket. If it is valid some text is set into the z1DChar01 field and if it's not valid (no match is found in the lookup) the z1DChar01 field is set to NULL. In the second filter the same RUNIF is used with one additional qualification added, testing to see if the z1DChar01 field is NULL. If it is NULL then a message is displayed and the transaction is stopped. If it's not NULL then the transaction continues. These two filters execute one after the other with no other intervening workflow so that the only thing that will change z1DChar01 is the first filter and it will be immediately tested by the second filter. BMC usually includes the EXECUTION ORDER NUMBER in the name of the filter. The one which displays your error message ends in 053, so I would look at the filter that ends in 052 to determine what check is being performed. That will probably tell you what the data error is.. Hope this helps.. Doug Blair On Jul 15, 2010, at 8:23 PM, Mauro Monteiro wrote: ** Hi All, After some investigations I found a filter named 'HPD:INC:ValidateAsgneeShft_053' which is responsible for showing the error message I sent before. Apparently, I must set the field 'Assigned Group Shift Name', I did it a very similar error happened - ERROR (1291055). Now, the issue seems to be related to the field named 'z1D Char01' because the new error is set on field named 'HPD:INC:ValidateAsgneeShft_055' which has the following criteria: *(( 'Assigned Support Company' != 'DB.Assigned Support Company') OR ( 'Assigned Support Organization' != 'DB.Assigned Support Organization') OR ( 'Assigned Group' != 'DB.Assigned Group') OR ( 'Assigned Group ID' != 'DB.Assigned Group ID') OR ( 'Assigned Group Shift Name' != 'DB.Assigned Group Shift Name') OR ( 'Assigned Group Shift ID' != 'DB.Assigned Group Shift ID') OR ( 'Assignee' != 'DB.Assignee') OR ( 'Assignee Login ID' != 'DB.Assignee Login ID')) AND ( 'Assignee' != $NULL$ ) AND ( 'Assigned Group Shift Name' != $NULL$ ) AND ( 'z1D Char01' = $NULL$ )* I tried to found this field 'z1D Char01' in the form HPD:Help Desk but I have not found it. Does anyone know where this field is defined? How can I set a value for it? Cheers, Mauro 2010/7/15 Mauro Monteiro maumontesi...@gmail.com Hi Chemys, I don't have so experience with Remedy. How can I enable the trace to figure out all filters running ? Is there a wad to loogin it? Cheers, Mauro 2010/7/15 chernys ben.cher...@softwaretoolhouse.com ** What you need to do in the API program you are using is the same as the user tool does. Turn on logging in the user tool and do the assignment change. Then you will see the hidden fields that are being set by the workflow. Set those fields and
Re: Friday Humor
That was a genuine laugh out loud moment. Thanks From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Phil Bautista Sent: 17 July 2010 08:10 To: arslist@ARSLIST.ORG Subject: OT: Friday Humor ** A sales rep, an administration clerk, and the manager are walking to lunch when they find an antique oil lamp. They rub it and a Genie comes out.. The Genie says, 'I'll give each of you just one wish.' 'Me first! Me first!' says the admin clerk. 'I want to be in the Bahamas , driving a speedboat, without a care in the world.' Puff! She's gone. 'Me next! Me next!' says the sales rep. 'I want to be in Hawaii , relaxing on the beach with my personal masseuse, an endless supply of Pina Coladas and the love of my life.' Puff! He's gone. 'OK, you're up,' the Genie says to the manager. The manager says, 'I want those two back in the office after Lunch.' Moral of the story: Always let your boss have the first say Phil Bautista, WWRUG10 Advisory Board 512-731-0304 http://www.linkedin.com/in/philbautista http://www.wwrug.org/wwrug10/contact_phil.html _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: About the installing problem
If you're using a named instance use a different port number than 1433. That may work... -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of honormine Sent: Sunday, July 18, 2010 1:26 AM To: arslist@ARSLIST.ORG Subject: About the installing problem Today I wanted to reinstall the AR Server(which is installed before),while I was installing ,the error it is: For security reasons, your password will not be displayed. What is your AR User Password for ARAdmin? [*] I typed the password but the install process will not go on and stop there I tested the sqlplus and conneted to the database and it showed all good. SQL conn aradmin/ar#adm...@itildb Connected. -- View this message in context: http://old.nabble.com/About-the-installing-problem-tp29195345p29195345.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Connection Time out While Consuming Web service
Hi All, We have written a filter set field action to consume an external web service. When that filter is fired we are getting Timeout error. Error message from filter log is as below: FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 620 USER: yellarth error when running a web service FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 620 USER: yellarth; nested exception is: java.net.ConnectException: Connection timed out FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 620 USER: yellarth Error while performing filter action: Error 9130 FLTR TID: 1080056128 RPC ID: 002379 Queue: Fast Client-RPC: 390 620 USER: yellarth Filter PMT: SDO_100sm_SolveDirectOutputCal The error message from arjavaplugin.log file is as below: 2010-07-19 08:36:52,754 ERROR [pool-2-thread-4] com.bmc.arsys.pluginsvr.plugins.ARPluginContext (?:?) - ARSYS.ARF.WEBSERVICEjava.net.ConnectException: Connection timed out AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: java.net.ConnectException: Connection timed out faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:java.net.ConnectException: Connection timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:525) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:550) at com.sun.net.ssl.internal.ssl.SSLSocketImpl.lt;initgt;(SSLSocketImpl.java:353) at com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:71) at org.apache.axis.components.net.JSSESocketFactory.create(JSSESocketFactory.java:92) at org.apache.axis.transport.http.HTTPSender.getSocket(HTTPSender.java:191) at org.apache.axis.transport.http.HTTPSender.writeToSocket(HTTPSender.java:404) at org.apache.axis.transport.http.HTTPSender.invoke(HTTPSender.java:138) at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32) at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118) at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83) at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165) at org.apache.axis.client.Call.invokeEngine(Call.java:2784) at org.apache.axis.client.Call.invoke(Call.java:2767) at org.apache.axis.client.Call.invoke(Call.java:1910) at com.bmc.arsys.ws.client.WebServiceSoapClient.call(Unknown Source) at com.bmc.arsys.ws.plugin.WSPlugin.filterAPICall(Unknown Source) at com.bmc.arsys.pluginsvr.plugins.ARFilterAPIPluginRepository.ARFilterApiCall(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_5(Unknown Source) at com.bmc.arsys.pluginsvr.a.ArEsFilterApi_4(Unknown Source) at com.bmc.arsys.arrpc.ARPluginServerDispatcher.dispatchOncRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.dispatchCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.if(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler.processRpcCall(Unknown Source) at com.bmc.arsys.arrpc.nio.ArRpcCallHandler$Processor.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) ar.conf settings is as bellow: Server-Plugin-Alias: ARSYSTEM.ARF.WEBSERVICE ARSYSTEM.ARF.WEBSERVICE servername: ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/arapi75.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/log4j-1.2.14.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/arapiext75.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/arregistryplugin75.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/websvcjava75.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/pluginsvr/WSRegistryAPI7.5.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/bin/commons-logging-1.0.4.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/api/lib/ardoc75.jar ARF-Java-Class-Path: /opt/bmc/ARSystem/bin/wsdl4j.jar Plugin-Log-Level: 100 How to debug this issue?, we have noticed this on our new environment 7.5 where we have migrated our application from 6.3 environment, we are using the same wsdls in new environment too. Regards, Prashanth Bhagawat This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender
SLM Upgrade 7.03 to 7.6
Does anyone know if you can upgrade from SLM 7.03 to 7.6 Patch 1 or do you have to install 7.6 first? -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: SLM Upgrade 7.03 to 7.6
The SLM 7.6 Patch 1 is just a patch, not the full app like ITSM 7.6.00.001. You have to install the 7.6.00 distribution, then run the patch (which is of negligible size - adds a couple of active links and updates others). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kevin Begosh Sent: Monday, July 19, 2010 9:25 AM To: arslist@ARSLIST.ORG Subject: SLM Upgrade 7.03 to 7.6 ** Does anyone know if you can upgrade from SLM 7.03 to 7.6 Patch 1 or do you have to install 7.6 first? -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: SLM Upgrade 7.03 to 7.6
okay thanks. On Mon, Jul 19, 2010 at 10:28 AM, strauss stra...@unt.edu wrote: ** The SLM 7.6 Patch 1 is just a patch, not the full app like ITSM 7.6.00.001. You have to install the 7.6.00 distribution, then run the patch (which is of negligible size – adds a couple of active links and updates others). Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Kevin Begosh *Sent:* Monday, July 19, 2010 9:25 AM *To:* arslist@ARSLIST.ORG *Subject:* SLM Upgrade 7.03 to 7.6 ** Does anyone know if you can upgrade from SLM 7.03 to 7.6 Patch 1 or do you have to install 7.6 first? -- Kevin Begosh _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ARS 7.0.1 to 7.5.0 Upgrade Issue
Hello, Last week, I began trying to upgrade our 7.0.1 test environment to 7.5.0 patch 4. After finally getting through the installer, I am getting the following error when trying to do the arsystem start command. 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) 390600 : Failure during SQL operation to the database (ARERR 552) ORA-00904: SHVIEWNAME: invalid identifier 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) (ARNOTE 0) Unable to receive indication that server is up. We are on HP-UX 11.31 and Oracle 11.2.0.1. I have tried running the installer twice, the second time after performing an uninstall. I have a ticket into BMC Support but the response has been a bit slow. They did mention that it seems some database objects weren't created, one being a LICENSE_CACHE table but I haven't got much further than that. Any suggestions on what I can try doing to resolve this? Thanks! Mike Mike Kendhammer Support Systems Enterprse Services Ingersoll Rand 3600 Pammel Creek Rd, La Crosse WI 54601 Office: +1 608.787.3078 Email: mkendham...@trane.commailto:mkendham...@trane.com The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please immediately notify the sender, and delete the original message and attachments. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: About the installing problem
Honormine, Remember that the default password is AR#Admin#, not ar#admin# -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of honormine Sent: Saturday, July 17, 2010 11:26 PM To: arslist@ARSLIST.ORG Subject: About the installing problem Today I wanted to reinstall the AR Server(which is installed before),while I was installing ,the error it is: For security reasons, your password will not be displayed. What is your AR User Password for ARAdmin? [*] I typed the password but the install process will not go on and stop there I tested the sqlplus and conneted to the database and it showed all good. SQL conn aradmin/ar#adm...@itildb Connected. -- View this message in context: http://old.nabble.com/About-the-installing-problem-tp29195345p29195345.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS 7.0.1 to 7.5.0 Upgrade Issue
If you don't already have logging turned on, edit your ar.conf file to enable logging on the arsql.log. This way you can see exactly which statements are failing. Debug-mode: 1(page 333 of the Configuration Guide pdf) SQL-Log-File: Full_Path_to_log_File Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 9:48 AM To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 to 7.5.0 Upgrade Issue Hello, Last week, I began trying to upgrade our 7.0.1 test environment to 7.5.0 patch 4. After finally getting through the installer, I am getting the following error when trying to do the arsystem start command. 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) 390600 : Failure during SQL operation to the database (ARERR 552) ORA-00904: SHVIEWNAME: invalid identifier 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) (ARNOTE 0) Unable to receive indication that server is up. We are on HP-UX 11.31 and Oracle 11.2.0.1. I have tried running the installer twice, the second time after performing an uninstall. I have a ticket into BMC Support but the response has been a bit slow. They did mention that it seems some database objects weren't created, one being a LICENSE_CACHE table but I haven't got much further than that. Any suggestions on what I can try doing to resolve this? Thanks! Mike Mike Kendhammer Support Systems Enterprse Services Ingersoll Rand 3600 Pammel Creek Rd, La Crosse WI 54601 Office: +1 608.787.3078 Email: mkendham...@trane.commailto:mkendham...@trane.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ARS 7.0.1 to 7.5.0 Upgrade Issue
Hi Fred, Here is the output from the log file... */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT COUNT(*) FROM user_cache WHERE userName = 'Action Request Installer Account' */OK */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT MAX(serverId) FROM server_cache */OK */SELECT dbUpdate FROM control */OK */COMMIT WORK */SELECT groupId,groupName,groupType,groupCategory FROM group_cache ORDER BY 1 ASC */OK */SELECT groupType,MAX(timestamp) FROM group_cache GROUP BY groupType */OK */select count (*) from arschema */OK */SELECT name,schemaId,schemaType,coreVersion,timestamp,numFields,defaultVui,numVuis,nextFieldId,upgrdVersion,version,smObjProp,safeGuard,nextId,objProp,viewName, shViewName FROM arschema ORDER BY 2 ASC */*** ERROR *** ORA-00904: SHVIEWNAME: invalid identifier */ORA-00904: SHVIEWNAME: invalid identifier */SQL Trace Log -- OFF It seems that the some steps of the installation did not successfully complete... Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, July 19, 2010 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue If you don't already have logging turned on, edit your ar.conf file to enable logging on the arsql.log. This way you can see exactly which statements are failing. Debug-mode: 1(page 333 of the Configuration Guide pdf) SQL-Log-File: Full_Path_to_log_File Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 9:48 AM To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 to 7.5.0 Upgrade Issue Hello, Last week, I began trying to upgrade our 7.0.1 test environment to 7.5.0 patch 4. After finally getting through the installer, I am getting the following error when trying to do the arsystem start command. 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) 390600 : Failure during SQL operation to the database (ARERR 552) ORA-00904: SHVIEWNAME: invalid identifier 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) (ARNOTE 0) Unable to receive indication that server is up. We are on HP-UX 11.31 and Oracle 11.2.0.1. I have tried running the installer twice, the second time after performing an uninstall. I have a ticket into BMC Support but the response has been a bit slow. They did mention that it seems some database objects weren't created, one being a LICENSE_CACHE table but I haven't got much further than that. Any suggestions on what I can try doing to resolve this? Thanks! Mike Mike Kendhammer Support Systems Enterprse Services Ingersoll Rand 3600 Pammel Creek Rd, La Crosse WI 54601 Office: +1 608.787.3078 Email: mkendham...@trane.commailto:mkendham...@trane.com ___ UNSUBSCRIBE or access ARSlist
Re: ARS 7.0.1 to 7.5.0 Upgrade Issue
It looks like it is all items added by 7.1.0. I wonder if the 7.5.0 patch 4 HP installer is missing things. Can you upgrade to 7.1.0 and then to 7.5? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue Hi Fred, Here is the output from the log file... */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT COUNT(*) FROM user_cache WHERE userName = 'Action Request Installer Account' */OK */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT MAX(serverId) FROM server_cache */OK */SELECT dbUpdate FROM control */OK */COMMIT WORK */SELECT groupId,groupName,groupType,groupCategory FROM group_cache ORDER BY 1 ASC */OK */SELECT groupType,MAX(timestamp) FROM group_cache GROUP BY groupType */OK */select count (*) from arschema */OK */SELECT name,schemaId,schemaType,coreVersion,timestamp,numFields,defaultVui,numVuis,nextFieldId,upgrdVersion,version,smObjProp,safeGuard,nextId,objProp,viewName, shViewName FROM arschema ORDER BY 2 ASC */*** ERROR *** ORA-00904: SHVIEWNAME: invalid identifier */ORA-00904: SHVIEWNAME: invalid identifier */SQL Trace Log -- OFF It seems that the some steps of the installation did not successfully complete... Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, July 19, 2010 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue If you don't already have logging turned on, edit your ar.conf file to enable logging on the arsql.log. This way you can see exactly which statements are failing. Debug-mode: 1(page 333 of the Configuration Guide pdf) SQL-Log-File: Full_Path_to_log_File Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 9:48 AM To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 to 7.5.0 Upgrade Issue Hello, Last week, I began trying to upgrade our 7.0.1 test environment to 7.5.0 patch 4. After finally getting through the installer, I am getting the following error when trying to do the arsystem start command. 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) 390600 : Failure during SQL operation to the database (ARERR 552) ORA-00904: SHVIEWNAME: invalid identifier 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) (ARNOTE 0) Unable to receive indication that server is up. We are on HP-UX 11.31 and Oracle 11.2.0.1. I have tried running the installer twice, the second time after performing an uninstall. I have a ticket into BMC Support but the response has been a bit slow. They did mention that it seems some database objects weren't created, one being a LICENSE_CACHE table but I
Re: ARS 7.0.1 to 7.5.0 Upgrade Issue
Yes, I could upgrade to 7.1. I was hoping to avoid that though... I am guessing that I would have to revert back to 7.0.1 first, then upgrade to 7.1, then 7.5??? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, July 19, 2010 11:22 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue It looks like it is all items added by 7.1.0. I wonder if the 7.5.0 patch 4 HP installer is missing things. Can you upgrade to 7.1.0 and then to 7.5? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue Hi Fred, Here is the output from the log file... */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT COUNT(*) FROM user_cache WHERE userName = 'Action Request Installer Account' */OK */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT MAX(serverId) FROM server_cache */OK */SELECT dbUpdate FROM control */OK */COMMIT WORK */SELECT groupId,groupName,groupType,groupCategory FROM group_cache ORDER BY 1 ASC */OK */SELECT groupType,MAX(timestamp) FROM group_cache GROUP BY groupType */OK */select count (*) from arschema */OK */SELECT name,schemaId,schemaType,coreVersion,timestamp,numFields,defaultVui,numVuis,nextFieldId,upgrdVersion,version,smObjProp,safeGuard,nextId,objProp,viewName, shViewName FROM arschema ORDER BY 2 ASC */*** ERROR *** ORA-00904: SHVIEWNAME: invalid identifier */ORA-00904: SHVIEWNAME: invalid identifier */SQL Trace Log -- OFF It seems that the some steps of the installation did not successfully complete... Mike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, July 19, 2010 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue If you don't already have logging turned on, edit your ar.conf file to enable logging on the arsql.log. This way you can see exactly which statements are failing. Debug-mode: 1(page 333 of the Configuration Guide pdf) SQL-Log-File: Full_Path_to_log_File Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 9:48 AM To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 to 7.5.0 Upgrade Issue Hello, Last week, I began trying to upgrade our 7.0.1 test environment to 7.5.0 patch 4. After finally getting through the installer, I am getting the following error when trying to do the arsystem start command. 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) 390600 : Failure during SQL operation to the database (ARERR 552) ORA-00904: SHVIEWNAME: invalid identifier 390600 : AR System server terminated --
Re: Remedy Email Notification Subject Line is Blank*Resolved*
Prashanth, Just a note that the issue was a permission issue. The fact that changing permission made it work shows that. The issue is to remember that you are talking about TWO different users here. First, the user who is the person performing the operation that is triggering the operation that causes the notification. They may have access to all kinds of things. They in your case had access to the field that was going into the subject. Second, the use who is being notified. They may have completely different permissions than the user who is doing the operation that triggers the notification. And, we don't necessarily know the user name -- often, we just have an email address so no user. If we know the user, we should be using that user (when possible) to determine access. When we don't know the user, we have to assume no permission so just Public access. In your case, it is this SECOND user whose permissions are being used -- and if it is just an email address, it means only Public fields. This is critical so that we don't send information in a notification that the user is not allowed to see (or that you have used workflow to transfer to a field that is public for this particular notification). This is a good example where casual treatment is actually a security hole where you can get data you should not be getting as a side effect of notification. We default to not sending data unless we know we are allowed to send it. Hopefully, this makes sense. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Prashanth Bhagawat Sent: Sunday, July 18, 2010 9:56 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Email Notification Subject Line is Blank*Resolved* ** Hi All, This issue is resolved, as suggested in the arlist I added public permissions to Subject field on one of our custom email messages form (IMPT Messages) after this change I was able to see subject line in the ar system email messages form, am sure this was not a permission issue since I was able to display the subject line content using a message action in the filter just before the notify action. Not to worry much about permissions, this work around has fixed the problem right now. So thanks a lot for Arslist community members. Regards, Prashanth Bhagawat From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Arner, Todd Sent: Friday, July 16, 2010 7:56 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Email Notification Subject Line is Blank Is it possible that the subject field is set to Display Only? I have ran into problems pushing data to an email from a display only field... Just a thought. Todd Arner From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Prashanth Bhagawat Sent: Friday, July 16, 2010 1:00 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Email Notification Subject Line is Blank ** -- Hi Thad, There is no filter which is clearing the subject line, and permission isn't an issue to, it has got similar permission to that of the body which is getting set on AR system email messages form. Br, Prashanth From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Thad Esser Sent: Thursday, July 15, 2010 8:47 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy Email Notification Subject Line is Blank ** Prasanth, If permissions aren't the issue, maybe phasing is. As notify actions are phase 3 actions, could there be any other workflow resetting the subject before the notify actually happens? One other unlikely thing to check is the execution order of your filters. Filters with the same execution order could fire in any order. By migrating to a new server you change the modified date (which is the not-quite-so-random piece of how they fire), and that could change the order in which they fire such that the notify happens before the set fields. Good luck, Thad On Thu, Jul 15, 2010 at 5:00 AM, Terry Bootsma tboot...@objectpath.commailto:tboot...@objectpath.com wrote: ** Change the permission of the field which you are copying to the subject in the ARSystem Email Messages form to public (ie. the source field) . You should find this will work... Had the same issue here a few days ago. Terry On Jul 15, 2010, prashanth.bhaga...@accenture.commailto:prashanth.bhaga...@accenture.com wrote: ** Hi All, we got an issue related to email notification , subject line of the email generated in ar system email messages is blank. we have custom built applications, there is IPMT email messages a custom built email notification form where we store all the emails generated there first then a filter on this form has got notify action which reads subject, body and user related information
Re: ERROR (1291053)
Hi All, Thanks very much for your help. With all help found here I figured out the reason of my issue. Basically, I was supposed to set the field Login ID before trying to set the Assignee because the filter HPD:INC:ValidateAsgneeShft_054 uses Login ID to set the temp field z1D Char01. So, after the execution of filter HPD:INC:ValidateAsgneeShft_054 I could execute my updates. Thanks! []'s Mauro 2010/7/19 Mauro Monteiro maumontesi...@gmail.com Hi All, First of all, thanks everyone for your help! I did some tests and I think that I figure out the reason for the error message. As I said before, I am trying to update some information related to incidents that already exist in my Remedy environment. These incidents don't have the assignee information filled in. So, my idea is to assign some users to this field (assignee). Now, I noted that the filter HPD:INC:ValidateAsgneeShft_055 has the criteria below (I highlighted what I think it the reason for this issue); (( 'Assigned Support Company' != 'DB.Assigned Support Company') OR ( 'Assigned Support Organization' != 'DB.Assigned Support Organization') OR ( 'Assigned Group' != 'DB.Assigned Group') OR ( 'Assigned Group ID' != 'DB.Assigned Group ID') OR ( 'Assigned Group Shift Name' != 'DB.Assigned Group Shift Name') OR ( 'Assigned Group Shift ID' != 'DB.Assigned Group Shift ID') *OR ( 'Assignee' != 'DB.Assignee') OR ( 'Assignee Login ID' != 'DB.Assignee Login ID')*) AND ( 'Assignee' != $NULL$ ) AND ( 'Assigned Group Shift Name' != $NULL$ ) AND ( 'z1D Char01' = $NULL$ ) According to my understanding, the RUNIF is comparing the current value value for fields (for instance, both highlighted above) with the value stored in database. In my case, I am trying to set some value for Assignee field but this value in database is null. So, these conditions is true which means that the filter runs. I removed both conditions from filter and I got successful to update the incidents. If it is true, the same error should happened when you do it through GUI. Don't you agree? My concerns are: How does the GUI dealt with this? Does it disable the filter before creating/updating the incidents? 2010/7/16 Doug Blair d...@blairing.com Mauro, This is a common error message construction in a lot of the BMC ITSM applications. The z1DChar01 field is just a temporary field that holds the results of some other query. This error message construction usually consists of two filters with almost identical RUNIF's. The first filter tests for some condition by (for example) looking up the contents of a field to see if that text is valid for this ticket. If it is valid some text is set into the z1DChar01 field and if it's not valid (no match is found in the lookup) the z1DChar01 field is set to NULL. In the second filter the same RUNIF is used with one additional qualification added, testing to see if the z1DChar01 field is NULL. If it is NULL then a message is displayed and the transaction is stopped. If it's not NULL then the transaction continues. These two filters execute one after the other with no other intervening workflow so that the only thing that will change z1DChar01 is the first filter and it will be immediately tested by the second filter. BMC usually includes the EXECUTION ORDER NUMBER in the name of the filter. The one which displays your error message ends in 053, so I would look at the filter that ends in 052 to determine what check is being performed. That will probably tell you what the data error is.. Hope this helps.. Doug Blair On Jul 15, 2010, at 8:23 PM, Mauro Monteiro wrote: ** Hi All, After some investigations I found a filter named 'HPD:INC:ValidateAsgneeShft_053' which is responsible for showing the error message I sent before. Apparently, I must set the field 'Assigned Group Shift Name', I did it a very similar error happened - ERROR (1291055). Now, the issue seems to be related to the field named 'z1D Char01' because the new error is set on field named 'HPD:INC:ValidateAsgneeShft_055' which has the following criteria: *(( 'Assigned Support Company' != 'DB.Assigned Support Company') OR ( 'Assigned Support Organization' != 'DB.Assigned Support Organization') OR ( 'Assigned Group' != 'DB.Assigned Group') OR ( 'Assigned Group ID' != 'DB.Assigned Group ID') OR ( 'Assigned Group Shift Name' != 'DB.Assigned Group Shift Name') OR ( 'Assigned Group Shift ID' != 'DB.Assigned Group Shift ID') OR ( 'Assignee' != 'DB.Assignee') OR ( 'Assignee Login ID' != 'DB.Assignee Login ID')) AND ( 'Assignee' != $NULL$ ) AND ( 'Assigned Group Shift Name' != $NULL$ ) AND ( 'z1D Char01' = $NULL$ )* I tried to found this field 'z1D Char01' in the form HPD:Help Desk but I have not found it. Does anyone know where this field is defined? How can I set a value for it? Cheers, Mauro 2010/7/15 Mauro Monteiro
Re: Schrödinger's Active Links on the Mid Tier
This could actually be something else. I had something very similar happen back in version 7.0 - and it ended up being tied to the sticky' setting on a load balancer. I would log in as user A but see user B in the logs, etc. The fact that turning on mid-tier Active Link logging also forces the Remedy server to re-read the preference record, which may also force it to correct itself somehow since it's updating the active user's information. If you're using a load balancer - check it out too. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Blog: www.williamrentfrow.com O 715-592-5185 C 715-410-8056 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, July 16, 2010 2:09 PM To: arslist@ARSLIST.ORG Subject: Schrödinger's Active Links on the Mid Tier ** Ok folks, here is a weird one. I am having an issue with a custom application that started after we upgraded the Mid Tier from 7.1 to 7.5 patch 4. Basically, I have a console with a table field and an external qualification. That qualification is set on Window Open, and it is based on what permission group you are in. If you are in the CS group, it should show CS tickets, if you are in the MH group, it should show MH tickets. This works fine in most scenarios, except for the one that we normally operate in. Here are the ways I've tested it: 1. If I access the Mid Tier as the end user, I see the wrong group's tickets. 2. If I access the Windows User Tool as the end user, I see the correct group's tickets. 3. If I access the Mid Tier as the end user *with active link logging enabled*, I see the correct group's tickets. Granted, I am trying other ways of logging what is going on, but this sounds like a bug in the Mid Tier to me. I've been able to reproduce this several times and have a ticket open with BMC Support, but I wanted to see if anyone else has run into issues like this before. Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access hyperlink, please e-mail sender. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: SQL equivalent of DISTINCT in Remedy
Hi James, Unfortunately, a View form is not available as an option to choose from in Join Wizard. We are on 7.1 patch 07. Thanks Chintan --- On Fri, 7/16/10, jham36 jha...@gmail.com wrote: From: jham36 jha...@gmail.com Subject: Re: SQL equivalent of DISTINCT in Remedy To: arslist@ARSLIST.ORG Date: Friday, July 16, 2010, 1:53 PM I'm thinking that a join form might work. I'm going to check the documentation on inner and outer joins. Maybe join the view form to itself. Then use the join form in your table field. James On Jul 16, 4:30 pm, Chintan Shah cbss...@yahoo.com wrote: Hello, I have a table field that represents a view form. Now, I need to get only unique rows in that table. The problem is for a particular ID(on view form) there could be multiple email addresses and I want to get DISTINCT email in table field before walking through it and extracting required infor. I dont see any option available under Table/Tree Property for doing this. In a nutshell, here's scenario. 1. View form pointing to an external DB that holds multiple email addresses as separate rows for a particular ID(this ID is different from primary key of table). 2. A table field that queries this view form with qualification: $ID$='ID'. 3. Now, this returns a result set that has multiple rows in it with column name of NAME,EMAIL. I can do table walk and get required information, but how do I extract only unique rows? e.g. if result set is as below ID NAME EMAIL SOME OTHER COLUMN 1 A X Z 1 B Y Z 1 A X P how can I refine it to just A-X, B-Y? Regardless of value in SOME OTHER COLUMN, I need to use only A-X,B-Y. Basically, I am looking for SQL equivalent of DISTINCT in Remedy that can be used with Table Field qual. Any help is appreciated. Thanks Chintan. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org attend wwrug10www.wwrug.comARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Corrupt Attachments
This is not that same system - it's completely separate. The method of saving in the database is not the culprit - I can save a standard Word document as an attachment and go to another machine, pull up the record with the attachment and open it correctly. Mail Merge documents on the other hand - not so much. They are always corrupt when we do this same test. We've tried a save as and every other trick we can think of, including some off-the-shelf utilities for examining files to see why they are corrupt. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Blog: www.williamrentfrow.com O 715-592-5185 C 715-410-8056 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Miller Sent: Friday, July 16, 2010 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: Corrupt Attachments Hi William, Is this the same 4 AR Server group that you mention in the Preference Server in a Server Group (7.5) thread? I know your users do not have access a individual server but do you? If you do, does this same issue happen when connected to an AR Server directly? It doesn't make much sense to me that an attachment without a mail merge would work fine through the load balancer and one with mail merge gets scrambled but the LB and virtual name is an extra layer of complexity that would be nice to rule out. Jason On 7/15/10, Jason Miller jason.mil...@gmail.com wrote: I don't know what might be happening but just wanted to pass on a observation of attachment behavior. The attachment is opened from the local machine until the records is saved. So before step 4 everything with the attachment is happening on the local machine. To verify add the attachment to the attachment pool, change the name of the file on the disk and then try to save. You will receive an error that the file cannot be found. Something that might help pinpoint it being a issue with how the attachment is being compressed/uncompressed and rule out pre step 4 workflow... Save a record in a form with an attachment field, open the record in a modify mode, add a mail merged attachment and open the attachment, it should be fine. Then save the record (committing the attachment to the db), without refreshing the record try to open the attachment again. My thought is the attachment will now be corrupt. Have you tried saving the attachment to disk and seeing if the error still happens? Maybe it is more of an issue with the temp file that is written to the disk when opening directly from the attachment pool? Also what client are you using? Have you tried in the opposite client to see if the behavior is consistent? Jason On Thu, Jul 15, 2010 at 1:56 PM, William Rentfrow wrentf...@stratacominc.com wrote: ** Hello listers... We have an interesting issue - a while back a customization to Remedy was performed. Essentially the following happens in IM 7.03: 1.) Agents clicks a button 2.) System takes a template Word DOC and performs a mail merge with the current ticket/person info 3.) Document becomes attached to the Incident Work Log At this point everything is fine - the document can be opened and viewed as expected...but then... 4.) Agent saves the Incident When the Incident is re-opened the attachment is corrupt. Research into the corruption appears to show Microsoft smart tags are corrupted but we can't figure out why. If a normal document (no mail merge) is saved with the Work Log and re-opened it is fine - only the mail merge ones are affected. I'm not even 100% sure this is a Remedy problem because of the last fact. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
CMDB Status Questions
Hi, If Server1 has a status of In Inventory in the production CMDB.ASSET. The host is decommissioned and flagged as in inventory. Discovery goes out and discovery Server1, and the server is not pingable 2X. Our deletion policy is delete after 2 tries. Would this Server1 asset be marked as deleted in the CMDB.ASSET gold set? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: About the installing problem
It really doesn't make a difference on Oracle. Oracle user name and passwords are case insensitive.. I think you specifically need to set them as case sensitive to override the default that they are not case sensitive.. Joe From: LJ LongWing lj.longw...@gmail.com To: arslist@ARSLIST.ORG Sent: Mon, July 19, 2010 11:26:11 AM Subject: Re: About the installing problem Honormine, Remember that the default password is AR#Admin#, not ar#admin# -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of honormine Sent: Saturday, July 17, 2010 11:26 PM To: arslist@ARSLIST.ORG Subject: About the installing problem Today I wanted to reinstall the AR Server(which is installed before),while I was installing ,the error it is: For security reasons, your password will not be displayed. What is your AR User Password for ARAdmin? [*] I typed the password but the install process will not go on and stop there I tested the sqlplus and conneted to the database and it showed all good. SQL conn aradmin/ar#adm...@itildb Connected. -- View this message in context: http://old.nabble.com/About-the-installing-problem-tp29195345p29195345.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: About the installing problem
J..was a gotcha that got us when we upgraded from SQL Server 2000 to 2005, SQL Server went from insensitive to sensitive on the passwords..screwed up some of our integrations J From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 19, 2010 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: About the installing problem ** It really doesn't make a difference on Oracle. Oracle user name and passwords are case insensitive.. I think you specifically need to set them as case sensitive to override the default that they are not case sensitive.. Joe _ From: LJ LongWing lj.longw...@gmail.com To: arslist@ARSLIST.ORG Sent: Mon, July 19, 2010 11:26:11 AM Subject: Re: About the installing problem Honormine, Remember that the default password is AR#Admin#, not ar#admin# -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of honormine Sent: Saturday, July 17, 2010 11:26 PM To: arslist@ARSLIST.ORG Subject: About the installing problem Today I wanted to reinstall the AR Server(which is installed before),while I was installing ,the error it is: For security reasons, your password will not be displayed. What is your AR User Password for ARAdmin? [*] I typed the password but the install process will not go on and stop there I tested the sqlplus and conneted to the database and it showed all good. SQL conn aradmin/ar#adm...@itildb Connected. -- View this message in context: http://old.nabble.com/About-the-installing-problem-tp29195345p29195345.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com http://nabble.com/ . ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: About the installing problem
Changes on the MS-SQL server have been far more inconsistent with previously adhered conventions when it comes to case sensitivity while logging in. Oracle has been far more consistent at every version / patch change since I've known Oracle since about 1998. Even with the current version of Oracle, the default is that the login user name and password is not case sensitive.. Joe From: LJ LongWing lj.longw...@gmail.com To: arslist@ARSLIST.ORG Sent: Mon, July 19, 2010 4:51:23 PM Subject: Re: About the installing problem ** J….was a gotcha that got us when we upgraded from SQL Server 2000 to 2005, SQL Server went from insensitive to sensitive on the passwords….screwed up some of our integrations J From:Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Monday, July 19, 2010 2:20 PM To: arslist@ARSLIST.ORG Subject: Re: About the installing problem ** It really doesn't make a difference on Oracle. Oracle user name and passwords are case insensitive.. I think you specifically need to set them as case sensitive to override the default that they are not case sensitive.. Joe From:LJ LongWing lj.longw...@gmail.com To: arslist@ARSLIST.ORG Sent: Mon, July 19, 2010 11:26:11 AM Subject: Re: About the installing problem Honormine, Remember that the default password is AR#Admin#, not ar#admin# -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of honormine Sent: Saturday, July 17, 2010 11:26 PM To: arslist@ARSLIST.ORG Subject: About the installing problem Today I wanted to reinstall the AR Server(which is installed before),while I was installing ,the error it is: For security reasons, your password will not be displayed. What is your AR User Password for ARAdmin? [*] I typed the password but the install process will not go on and stop there I tested the sqlplus and conneted to the database and it showed all good. SQL conn aradmin/ar#adm...@itildb Connected. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
atrium SSO
Can someone tell me what BMC Atrium Single Sign-On - Windows Version 1.0.00 is??? I am about to start setting up a new 7.5 server and came across this application... not sure if I need it.. Thanks, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: atrium SSO
BMC Atrium SSO is a solution currently shipping with the Dashboard and Analytics products. It is a core solution that will eventually enable users to cross launch from one BMC product to another and be logged in without having to provide their login credentials a second time. The solution also includes some initial integrations with industry standard enterprise-wide SSO solutions as authentication sources. This would then enable those customers with an enterprise-wise third-party SSO solution to have just one point of integration with all BMC products - namely Atrium SSO. Additional integrations would be expected in later releases. AR System does not currently have an out-of-the-box integration with this Atrium SSO solution, but one is expected to release before the end of the year based on AR System 7.6.03. Documentation for Atrium SSO can be found here: BMC Atrium Single Sign-On Administrator's Guide Describes an authentication system that supports many authentication protocols, how to install, and how to use. 21-May-2010 http://documents.bmc.com/supportu/documents/29/39/132939/132939.pdf -David J. Easter Sr. Product Manager, Enterprise Service 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. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Monday, July 19, 2010 3:56 PM To: arslist@ARSLIST.ORG Subject: atrium SSO Can someone tell me what BMC Atrium Single Sign-On - Windows Version 1.0.00 is??? I am about to start setting up a new 7.5 server and came across this application... not sure if I need it.. Thanks, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: atrium SSO
David, Thank you for this information. Is this included with product(s) it supports or does this have an additional license/cost? Also, will this support DoD CAC OOB? Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Easter, David Sent: Monday, July 19, 2010 7:26 PM To: arslist@ARSLIST.ORG Subject: Re: atrium SSO BMC Atrium SSO is a solution currently shipping with the Dashboard and Analytics products. It is a core solution that will eventually enable users to cross launch from one BMC product to another and be logged in without having to provide their login credentials a second time. The solution also includes some initial integrations with industry standard enterprise-wide SSO solutions as authentication sources. This would then enable those customers with an enterprise-wise third-party SSO solution to have just one point of integration with all BMC products - namely Atrium SSO. Additional integrations would be expected in later releases. AR System does not currently have an out-of-the-box integration with this Atrium SSO solution, but one is expected to release before the end of the year based on AR System 7.6.03. Documentation for Atrium SSO can be found here: BMC Atrium Single Sign-On Administrator's Guide Describes an authentication system that supports many authentication protocols, how to install, and how to use. 21-May-2010 http://documents.bmc.com/supportu/documents/29/39/132939/132939.pdf -David J. Easter Sr. Product Manager, Enterprise Service 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. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Monday, July 19, 2010 3:56 PM To: arslist@ARSLIST.ORG Subject: atrium SSO Can someone tell me what BMC Atrium Single Sign-On - Windows Version 1.0.00 is??? I am about to start setting up a new 7.5 server and came across this application... not sure if I need it.. Thanks, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: atrium SSO
It is part of Atrium Core, so it is included with the BMC product(s) it supports. DoD CAC is one of the tentatively expected integrations to be provided in a future release. To be more specific, it's expected to be an integration with ActiveIdentity (http://www.actividentity.com/) which has been identified as the primary provider of CAC SSO solutions for the DoD. Note also that in line with the recent Statement of Direction, the Atrium SSO integration expected for AR System will be for the web client only. An OOB integration with Atrium SSO for the Remedy User client is not expected. However, since the integration with AR System and Atrium SSO utilizes the same mechanism as any other SSO integration (i.e. AREA Plug-in, etc.), a customer/partner could create their own integration with Atrium SSO for Remedy User. -David J. Easter Sr. Product Manager, Enterprise Service 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. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Lev Sent: Monday, July 19, 2010 6:55 PM To: arslist@ARSLIST.ORG Subject: Re: atrium SSO David, Thank you for this information. Is this included with product(s) it supports or does this have an additional license/cost? Also, will this support DoD CAC OOB? Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Easter, David Sent: Monday, July 19, 2010 7:26 PM To: arslist@ARSLIST.ORG Subject: Re: atrium SSO BMC Atrium SSO is a solution currently shipping with the Dashboard and Analytics products. It is a core solution that will eventually enable users to cross launch from one BMC product to another and be logged in without having to provide their login credentials a second time. The solution also includes some initial integrations with industry standard enterprise-wide SSO solutions as authentication sources. This would then enable those customers with an enterprise-wise third-party SSO solution to have just one point of integration with all BMC products - namely Atrium SSO. Additional integrations would be expected in later releases. AR System does not currently have an out-of-the-box integration with this Atrium SSO solution, but one is expected to release before the end of the year based on AR System 7.6.03. Documentation for Atrium SSO can be found here: BMC Atrium Single Sign-On Administrator's Guide Describes an authentication system that supports many authentication protocols, how to install, and how to use. 21-May-2010 http://documents.bmc.com/supportu/documents/29/39/132939/132939.pdf -David J. Easter Sr. Product Manager, Enterprise Service 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. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: Monday, July 19, 2010 3:56 PM To: arslist@ARSLIST.ORG Subject: atrium SSO Can someone tell me what BMC Atrium Single Sign-On - Windows Version 1.0.00 is??? I am about to start setting up a new 7.5 server and came across this application... not sure if I need it.. Thanks, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are