Re: Friday Humor

2010-07-19 Thread Danny Kellett 
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

2010-07-19 Thread Richard Copits 
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

2010-07-19 Thread 
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:

  error when running a web service
  yellarth; nested exception is:
java.net.ConnectException: Connection timed out
   Error while performing filter action: Error 9130
   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 (?:?) - 
java.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.(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 
:

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 immediately and delete the original.  Any other 
use of the email by you is prohibited.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

SLM Upgrade 7.03 to 7.6

2010-07-19 Thread Kevin Begosh 
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

2010-07-19 Thread strauss 
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

2010-07-19 Thread Kevin Begosh 
okay thanks.

On Mon, Jul 19, 2010 at 10:28 AM, strauss  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

2010-07-19 Thread Kendhammer, Mike 
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.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: Document Save from Database

2010-07-19 Thread LJ LongWing 
Naveen,
I think option 2 would be your best...and you control the return of the Java
Run-process by doing a Set-Field $PROCESS$ instead of a 'Run Process'
actionthe set-field process will wait for the external process to
completewhich means you have to adjust your server process settings to
be long enough for your process to complete within that timeout value.

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of NNMN
Sent: Saturday, July 17, 2010 12:18 PM
To: arslist@ARSLIST.ORG
Subject: Document Save from Database

Hi ARSers,

Below is a situation which i am trying to sort out.
1. I have two systems, a Remedy system and a custom application which
generates documents and stores it as blob.
2. I have access to read this blob from the Remedy system and save into an
attachment.

These are the methods which i have thought about, although i am not sure
about its feasibility and .
Method 1: Document generated will be read by calling a procedure using the
Direct SQL from the blob data(although i don't know how to do this via PLQL
if at all if its possible - if anyone knows please lemme know) and save into
the filesystem. As soon as it is saved, i will call the
PERFORM-ACTION-ADD-ATTACHMENT and save it into the required attachment
field.
Method 2: Document generated will be read by a java program which access the
data and saves it as a file in a location which will be called by RUN
PROCESS command line. As soon as it is saved, i will call the
PERFORM-ACTION-ADD-ATTACHMENT and save it into the required attachment
field. Now in this I am not sure how and when the return is going to happen
when i call the RUN PROCESS to execute the java code. 

I would like to have your views, inputs and anything useful regarding this.

Cheers,
Naveen

-
With Warm Regards,
Naveen
-- 
View this message in context:
http://old.nabble.com/Document-Save-from-Database-tp29192886p29192886.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: About the installing problem

2010-07-19 Thread LJ LongWing 
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

2010-07-19 Thread Grooms, Frederick W 
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.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

2010-07-19 Thread Kendhammer, Mike 
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.com

___
UNSUBSCRIBE or access

Re: ARS 7.0.1 to 7.5.0 Upgrade Issue

2010-07-19 Thread Grooms, Frederick W 
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 b

Re: ARS 7.0.1 to 7.5.0 Upgrade Issue

2010-07-19 Thread Kendhammer, Mike 
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*

2010-07-19 Thread Mueller, Doug 
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 
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 
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 
mailto: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, 
mailto: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 from this form as current value and creates entries in AR system 
email messages for

Re: ERROR (1291053)

2010-07-19 Thread Mauro Monteiro 
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 

> 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 
>
> 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

Re: Schrödinger's Active Links on the Mid Tier

2010-07-19 Thread William Rentfrow 
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 
 . 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

2010-07-19 Thread Chintan Shah 
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  wrote:

From: jham36 
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  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

2010-07-19 Thread William Rentfrow 
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  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

2010-07-19 Thread Kathy Morris 
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

2010-07-19 Thread Joe DeSouza 
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 
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

2010-07-19 Thread LJ LongWing 
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 
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"

 

_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

2010-07-19 Thread Joe DeSouza 
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 
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 
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

2010-07-19 Thread Martinez, Marcelo A 
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

2010-07-19 Thread Easter, David 
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

2010-07-19 Thread Mark Lev 
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

2010-07-19 Thread Easter, David 
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"