while looking at the Remedy website came across this...
-
- BMC Atrium Integrator Server is not detected | BMC CommunitiesApr 15, 2014
... Getting the error message "BMC Atrium integrator Server is not ... You need
to install atrium integrator which is a desperate download on the ...desperate
download indeed!!
-
-
Shafqat Ayaz
From: "Grooms, Frederick W" <frederick.w.gro...@xo.com>
To: arslist@ARSLIST.ORG
Sent: Monday, June 8, 2015 5:24 PM
Subject: Re: Set field SQL statement correction
You should be able to search the forms "AR System Metadata: actlink_sql" and
"AR System Metadata: filter_sql" looking for the double quotes. From those
forms you can take the Actlink ID or Filter ID to the Actlink or filter
metadata forms to find the workflow to update
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of MalviyaSaurabh
Sent: Friday, June 05, 2015 10:07 AM
To: arslist@ARSLIST.ORG
Subject: Set field SQL statement correction
Hi All,
We have migrated our custom (non-ITSM) ARS application from 7.1
(Solaris-Sybase) to 8.1 (Linux-Oracle).
Currently facing issues with Set Field SQL action in various workflows due
to difference in SQL statments in Sybase and Oracle.
For instance in one of the activelinks,
on sybase
select Install_History from CM_Change_Mgmt where Change_Request__ =
"$Change_RequetID$"
which gets error on Oracle, to rectify it I made the below change
select Install_History from AOL_CM_Change_Mgmt where Change_Request__ =
'$Change_RequetID$'
single-quote
Since I don't know for the presence of "double-quotes" in the workflows for
similar actions, what would be the best way to rectify the set-fields
actions,push field, direct sql??
Regards,
Saurabh
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
