intermittent db timeout errors occurring
Hi all, We are a custom shop running on AR Server 7.6.04 SP3, Mid-Tier Version 7.6.04 SP3 201209071045 Hotfix, Oracle 11g We are starting to receive intermittent DB timeout errors, usually the lock is occurring on a synonym calling a java class object, which leads me to believe its related to mid-tier in some way. Has anyone else seen these types of errors intermittently? Are there any configurations that I should check having to do with java timeouts? Thanks, Amanda ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Job Opening: Remedy Developer Position Opening Up Soon
You are correct, this is in Atlanta, GA USA (not remote). Full Time Employee position, I will respond with a link directly as soon as it is posted on our Turner.com website for applications. I just wanted to get it out there as soon as possible to receive feedback of interest. Thanks to you all, Amanda Pierce -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jase Brandon Sent: Thursday, December 05, 2013 7:34 PM To: arslist@ARSLIST.ORG Subject: Re: Job Opening: Remedy Developer Position Opening Up Soon TBS??? I bet one dollar it's in Atlanta and no remote. :-) Sent from my iPhone On Dec 5, 2013, at 4:22 PM, Misi Mladoniczky m...@rrr.se wrote: LJ, Don't forget that for some of us the actual country might also be of interest ;-) Best Regards - Misi, RRR AB, http://rrr.se Amanda, It might help people potentially interested in knowing where in the country the job is located, of if it's remote possible. On Thu, Dec 5, 2013 at 2:19 PM, Pierce, Amanda (TBS) amanda.pie...@turner.com wrote: ** I will have a Remedy Developer position opening up soon. Custom Development experience is necessary, ITSM knowledge is a plus. Please send me an email with your resume if you are interested or if you know anyone looking. Thank you, Amanda Pierce Turner Broadcasting System, Inc. amanda.pie...@turner.com _ARSlist: 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 __ _ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Job Opening: Remedy Developer Position Opening Up Soon
I will have a Remedy Developer position opening up soon. Custom Development experience is necessary, ITSM knowledge is a plus. Please send me an email with your resume if you are interested or if you know anyone looking. Thank you, Amanda Pierce Turner Broadcasting System, Inc. amanda.pie...@turner.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
JOB: Remedy Developer Needed
Looking for a seasoned Remedy Developer with experience in customization, Version 7.5 on Oracle 10gR2. Advanced PL/SQL and Business Objects knowledge a plus! Location - Atlanta, GA Position Type - Full Time/Permanent Employee To see a detailed job description and to apply please visit http://www.turner.com/careers#/careers/job-details/125959BR. You can also send a copy of your resume to amanda.pie...@turner.com and rick.dei...@turner.com Amanda Pierce Enterprise Applications Turner Broadcasting System, Inc ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Notify Action Missing Field Values in Subject
Hello All, We are upgrading to the 7.5 patch 006 BMC AR System Server Platform, in my testing I have noticed something strange with Notify Action Subject lines missing field values. Has anyone seen this happen before? Is this a bug with 7.5? i.e Filter w/ Notify Action Subject: Assigned $Priority$ $ShortID$ $Group$ Text: Assigned - $Priority$ - $ShortID$ - $Group$ Requester: $ReqLastName$, $ReqFirstName$, $ReqLocation$, $ReqPhone$ Customer: $CustLastName$, $CustFirstName$, $CustLocation$, $CustPhone$ Status: $Status$ Summary: $Summary$ Description: $Description$ Result: Subject: Assigned Text: Assigned - Medium - 698 - Group X Requestor: Pierce, Amanda, Location, Phone Customer: Pierce, Amanda, Location, Phone Status: Assigned Summary: This is a test Description: This is a test Thanks in advance for any help! Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Last Modified By Question
Hello All, Has anyone ever fired a filter off of the Last Modified By field changing? I have set up a filter to do this, but its not firing...seems like a filter will not fire off of this modification. I couldn't find anything in the documentation that would say if it was possible or not... Thanks in Advance for any help/guidance! Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Last Modified By Question
Chuck,
I have a scenario where I need to send a notification when an external system
modifies a record. So, I have a filter firing on Modify with Run If: 'Last
Modified By' != 'DB.Last Modified By' AND 'Last Modified By' = SCIB
I see a record being modified by this USER, however, my filter will not
fire...seems like it is not actually seeing the system stamp of Last Modified
By as a change.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Chuck
Sent: Thursday, May 27, 2010 8:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Last Modified By Question
A filter fires off of the following submit, modify, get entry,
service, Delete.
Why do you want to fire offf of Modify Date changing? Are you checking
the Before and After time of the Date?
Example: Firing filter on Modify if Modified Dates differ greater than
1 Day.
Execute On: Modify or Get Entry or Service or Delete
Run-If: 'TR.Modified Date' ('DB.Modified Date' + (3600 *24))
Since Modified Date always changes on successfull update, the TR value
is never null.
On May 27, 7:03 am, Pierce, Amanda (TBS) amanda.pie...@turner.com
wrote:
Hello All,
Has anyone ever fired a filter off of the Last Modified By field
changing?
I have set up a filter to do this, but its not firing...seems like a
filter will not fire off of this modification. I couldn't find anything
in the documentation that would say if it was possible or not...
Thanks in Advance for any help/guidance!
Amanda Pierce
___
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
RESOLVED: Last Modified By Question
Thank you all for your assistance!
I was able to use $USER$ = SCIB in the qualification to make it fire exactly
when I needed it to.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Thursday, May 27, 2010 9:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: Last Modified By Question
Try the following on a Modify filter: $USER$ = SCIB
That should only fire when a record is being modified and the user is the one
you want
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Pierce, Amanda (TBS)
Sent: Thursday, May 27, 2010 8:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Last Modified By Question
Chuck,
I have a scenario where I need to send a notification when an external system
modifies a record. So, I have a filter firing on Modify with Run If: 'Last
Modified By' != 'DB.Last Modified By' AND 'Last Modified By' = SCIB
I see a record being modified by this USER, however, my filter will not
fire...seems like it is not actually seeing the system stamp of Last Modified
By as a change.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Chuck
Sent: Thursday, May 27, 2010 8:47 AM
To: arslist@ARSLIST.ORG
Subject: Re: Last Modified By Question
A filter fires off of the following submit, modify, get entry,
service, Delete.
Why do you want to fire offf of Modify Date changing? Are you checking
the Before and After time of the Date?
Example: Firing filter on Modify if Modified Dates differ greater than
1 Day.
Execute On: Modify or Get Entry or Service or Delete
Run-If: 'TR.Modified Date' ('DB.Modified Date' + (3600 *24))
Since Modified Date always changes on successfull update, the TR value
is never null.
On May 27, 7:03 am, Pierce, Amanda (TBS) amanda.pie...@turner.com
wrote:
Hello All,
Has anyone ever fired a filter off of the Last Modified By field
changing?
I have set up a filter to do this, but its not firing...seems like a
filter will not fire off of this modification. I couldn't find anything
in the documentation that would say if it was possible or not...
Thanks in Advance for any help/guidance!
Amanda Pierce
___
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
7.5 Mid Tier Object List Question
I have imported the Mid Tier Object List form/workflow, when I log in as a regular user with restricted permissions I can see ALL forms even if I don't have permission to view them i.e AR System forms. Is there any way to restrict the visibility of these forms the same way the client does based on Permission Visible/Hidden? Thanks in advance for any help! Amanda Pierce EA Technical: Remedy Enterprise Applications Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos/ to submit a technology request. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Disable Mid-Tier Set Refresh Interval on tables
Has anyone found a way to disable the Set Refresh Interval on tables WITHOUT removing the entire option for preferences? Also, as a plus, I would like to do this globally and not on each individual table if there is a way. Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Email Error Log Question...
All, I have a process in place to where certain emails are forwarded to our server email from another account. Based on the TO information, I have a filter that picks up this email and creates an Incident. I am currently setting the Body of the email into a description field that is 5000 characters long. If by chance, the Body of the email is 5000 chr, the email engine submits a record to the Email Error Log that says: MessageType: 2 MessageNum: 306 MessageText: Value does not fall within the limits specified for the field AppendedText: (Maximum length- 5000) : TTS:HlpDskTkt : Description Message will be deleted without logging in email messages form because there is an error on submit. And, obviously it deletes the Email record. Is there any way for me to capture who the email was sent From, contents of the email or anything so that I can at least send an email back to them letting them know the incident was not submitted and they need to shorten the email? ARS 7.0.01 patch 002 Oracle 10gR2 Thank you! Amanda ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Multiple Instance Install Server License Issue
All, I am trying to setup a dev application server to run multiple instances of AR System Server to test upgrades/patches and am having an issue with a real license being shared with the second instance which is causing them both to not recognize a license and act as a demo license. Here is my setup: Server1 - license (member of server group) - points to remdevdb Server2a -license (member of server group) - points to remdevdb Server2b - demo (only used for testing upgrades/patches) - points to remupgdb When installing Server2b, I did install in a separate directory and the config files for both Server2a/Server2b both have the line: Multiple-ARSystem-Servers: T What am I missing here? Is there a separation of the multilicense file in the directory that I need to split up somehow? AR System 7.0.1 patch 002 Oracle 10gR2 Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos/ to submit a technology request. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Multiple Instance Install Server License Issue
Ah, thank you, I was actually reading the install doc and didn't see that. Thanks for the heads up! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rune Sorlid Sent: Thursday, January 24, 2008 7:56 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** Hi. Have you read the Configuration Manual? On Page 179: Important: Server group functionality is not supported for multiple servers on one machine. /Rune Sorlid 2008/1/24, Pierce, Amanda (TBS) [EMAIL PROTECTED]: ** All, I am trying to setup a dev application server to run multiple instances of AR System Server to test upgrades/patches and am having an issue with a real license being shared with the second instance which is causing them both to not recognize a license and act as a demo license. Here is my setup: Server1 - license (member of server group) - points to remdevdb Server2a -license (member of server group) - points to remdevdb Server2b - demo (only used for testing upgrades/patches) - points to remupgdb When installing Server2b, I did install in a separate directory and the config files for both Server2a/Server2b both have the line: Multiple-ARSystem-Servers: T What am I missing here? Is there a separation of the multilicense file in the directory that I need to split up somehow? AR System 7.0.1 patch 002 Oracle 10gR2 Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos/ to submit a technology request. __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Multiple Instance Install Server License Issue
I'll respond to both in one email: Yes, we gave it a different server name and there are 2 services listed on that one box. If that is your interpretation below, then I would love to see if someone else has been able to implement this same scenario... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, January 24, 2008 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** I think what that statement is referring to is having two nodes of the same server group installed on the same serverbut that's just my interpretation of that section of documentation From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rune Sorlid Sent: Thursday, January 24, 2008 5:56 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** Hi. Have you read the Configuration Manual? On Page 179: Important: Server group functionality is not supported for multiple servers on one machine. /Rune Sorlid 2008/1/24, Pierce, Amanda (TBS) [EMAIL PROTECTED]: ** All, I am trying to setup a dev application server to run multiple instances of AR System Server to test upgrades/patches and am having an issue with a real license being shared with the second instance which is causing them both to not recognize a license and act as a demo license. Here is my setup: Server1 - license (member of server group) - points to remdevdb Server2a -license (member of server group) - points to remdevdb Server2b - demo (only used for testing upgrades/patches) - points to remupgdb When installing Server2b, I did install in a separate directory and the config files for both Server2a/Server2b both have the line: Multiple-ARSystem-Servers: T What am I missing here? Is there a separation of the multilicense file in the directory that I need to split up somehow? AR System 7.0.1 patch 002 Oracle 10gR2 Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos/ to submit a technology request. __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Multiple Instance Install Server License Issue
Neither instance is set to use portmapper.
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Thursday, January 24, 2008 11:08 AM
To: arslist@ARSLIST.ORG
Subject: Re: Multiple Instance Install Server License Issue
**
Also are both Server2a and Server2b trying to use portmapper? One of
the servers (probably 2b) must be set not to use portmapper. Instead it
must be set to use a defined port.
Check your config on 2b for lines of:
Multiple-ARSystem-Servers: T
Register-With-Portmapper: F
TCD-Specific-Port: 12345 {replace 12345 with your specific TCP/IP port
for 2b}
We currently run 3 ARS servers on the same physical box
(Dev/Test/Training). Training is the only one that uses portmapper.
Fred
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pierce, Amanda (TBS)
Sent: Thursday, January 24, 2008 9:55 AM
To: arslist@ARSLIST.ORG
Subject: Re: Multiple Instance Install Server License Issue
**
I'll respond to both in one email:
Yes, we gave it a different server name and there are 2 services listed
on that one box.
If that is your interpretation below, then I would love to see if
someone else has been able to implement this same scenario...
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Thursday, January 24, 2008 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Re: Multiple Instance Install Server License Issue
**
I think what that statement is referring to is having two nodes of the
same server group installed on the same serverbut that's just my
interpretation of that section of documentation
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Rune Sorlid
Sent: Thursday, January 24, 2008 5:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: Multiple Instance Install Server License Issue
**
Hi.
Have you read the Configuration Manual?
On Page 179:
Important:
Server group functionality is not supported for multiple servers
on one machine.
/Rune Sorlid
2008/1/24, Pierce, Amanda (TBS) [EMAIL PROTECTED]:
**
All,
I am trying to setup a dev application server to run multiple instances
of AR System Server to test upgrades/patches and am having an issue with
a real license being shared with the second instance which is causing
them both to not recognize a license and act as a demo license.
Here is my setup:
Server1 - license (member of server group) - points to remdevdb
Server2a -license (member of server group) - points to remdevdb
Server2b - demo (only used for testing upgrades/patches) - points to
remupgdb
When installing Server2b, I did install in a separate directory and the
config files for both Server2a/Server2b both have the line:
Multiple-ARSystem-Servers: T
What am I missing here? Is there a separation of the multilicense file
in the directory that I need to split up somehow?
AR System 7.0.1 patch 002
Oracle 10gR2
Amanda Pierce
PDS Client Systems Development
Technology Services
Turner Broadcasting System, Inc
404-827-2959
Please use http://sos http://sos/ to submit a technology request.
__Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/
ARSlist: Where the Answers Are html___
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
html___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Multiple Instance Install Server License Issue
Yes, understood. What I meant was for some reason, when I login to 2a and apply that server license, it magically appears for 2b as well. I don't want it to, that is my dilemma. How/Where do I point Server2b to get its license information from a separate location than Server2a? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, January 24, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** Okwhen you stated that a 'real license' is being shared between themyou do realize that each server install needs its own license, correct?which means in your scenario you need 3 server license keys to get this situation working, you have 3 correct?not trying to run server2a and 2b with the same server key? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pierce, Amanda (TBS) Sent: Thursday, January 24, 2008 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** I'll respond to both in one email: Yes, we gave it a different server name and there are 2 services listed on that one box. If that is your interpretation below, then I would love to see if someone else has been able to implement this same scenario... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Thursday, January 24, 2008 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** I think what that statement is referring to is having two nodes of the same server group installed on the same serverbut that's just my interpretation of that section of documentation From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rune Sorlid Sent: Thursday, January 24, 2008 5:56 AM To: arslist@ARSLIST.ORG Subject: Re: Multiple Instance Install Server License Issue ** Hi. Have you read the Configuration Manual? On Page 179: Important: Server group functionality is not supported for multiple servers on one machine. /Rune Sorlid 2008/1/24, Pierce, Amanda (TBS) [EMAIL PROTECTED]: ** All, I am trying to setup a dev application server to run multiple instances of AR System Server to test upgrades/patches and am having an issue with a real license being shared with the second instance which is causing them both to not recognize a license and act as a demo license. Here is my setup: Server1 - license (member of server group) - points to remdevdb Server2a -license (member of server group) - points to remdevdb Server2b - demo (only used for testing upgrades/patches) - points to remupgdb When installing Server2b, I did install in a separate directory and the config files for both Server2a/Server2b both have the line: Multiple-ARSystem-Servers: T What am I missing here? Is there a separation of the multilicense file in the directory that I need to split up somehow? AR System 7.0.1 patch 002 Oracle 10gR2 Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos/ to submit a technology request. __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Remedy 7.0.1 patch 001 Upgrade Problem
All,
We are upgrading from Remedy 6.0.1 to Remedy 7.0.1 patch 001. We are on
an Oracle 10.2.3 database. When we go to install Remedy 7.0.1 patch 001
we see the following error in our sql log:
/* Tue Mar 13 16:32:26 2007 */ SQL Trace Log -- ON
/* Tue Mar 13 16:32:26 2007 */ CONNECT ARAdmin
/* Tue Mar 13 16:32:26 2007 */ SELECT BANNER FROM V$VERSION
/* Tue Mar 13 16:32:26 2007 */ OK
/* Tue Mar 13 16:32:26 2007 */ ALTER SESSION SET NLS_COMP=BINARY
/* Tue Mar 13 16:32:26 2007 */ OK
/* Tue Mar 13 16:32:26 2007 */ ALTER SESSION SET NLS_SORT=BINARY
/* Tue Mar 13 16:32:26 2007 */ OK
/* Tue Mar 13 16:32:26 2007 */ SELECT dbVersion FROM control
/* Tue Mar 13 16:32:26 2007 */ OK
/* Tue Mar 13 16:32:26 2007 */ COMMIT WORK
/* Tue Mar 13 16:32:26 2007 */ INSERT INTO servgrp_op_mstr VALUES
('Reconciliation Engine', -1, 'Reconciliation-Engine-Suspended:',
'SG-Check-Config', 'Reconciliation-CHK-CONFIG;Reconciliation')
/* Tue Mar 13 16:32:27 2007 */ OK
/* Tue Mar 13 16:32:27 2007 */ INSERT INTO servgrp_op_mstr VALUES
('CMDB', -1, 'CMDB-Service-Suspended:', 'SG-Check-Config',
'CMDB-CHK-CONFIG;CMDB')
/* Tue Mar 13 16:32:27 2007 */ OK
/* Tue Mar 13 16:32:27 2007 */ DELETE FROM servgrp_op_mstr WHERE
operation = 'Full Text Index'
/* Tue Mar 13 16:32:27 2007 */ OK
/* Tue Mar 13 16:32:27 2007 */ SELECT schemaId FROM field WHERE
fieldId = 731
/* Tue Mar 13 16:32:27 2007 */ OK
/* Tue Mar 13 16:32:27 2007 */ COMMIT WORK
/* Tue Mar 13 16:32:27 2007 */ UPDATE control SET dbVersion = 21
/* Tue Mar 13 16:32:27 2007 */ OK
/* Tue Mar 13 16:32:27 2007 */ COMMIT WORK
/* Tue Mar 13 16:32:27 2007 */ ALTER TABLE support_file MODIFY (
fileContent blob )
/* Tue Mar 13 16:32:28 2007 */ OK
/* Tue Mar 13 16:32:28 2007 */ ALTER INDEX support_file_ind REBUILD
/* Tue Mar 13 16:32:28 2007 */ OK
/* Tue Mar 13 16:32:28 2007 */ ALTER TABLE field_attach ADD (
fullTextOptions number(15,0) NULL )
/* Tue Mar 13 16:32:28 2007 */ OK
/* Tue Mar 13 16:32:28 2007 */ CREATE TABLE user_cacheY22 (serverId
number(15,0) not null,entryId varchar(15) not null,userName varchar(254)
not null,password varchar(255) NULL,authUserName varchar(254)
NULL,shortAuthString varchar(255) NULL,longAuthString clob
NULL,licensePool varchar(30) NULL,email varchar(255) NULL,notifyMech
number(15,0) NULL,licType number(15,0) NULL,licTypeFText number(15,0)
NULL,licTypeReserv1 number(15,0) NULL,licTypeApp clob NULL,timestamp
number(15,0) NULL,validateKey varchar(30) NULL,shortGroup varchar(255)
NULL,longGroup clob NULL,shortCompGroup varchar(255) NULL,longCompGroup
clob NULL,fixedLicChange clob NULL,badPwd number(15,0) NULL,badPwdTotal
number(15,0) NULL,pwdChange number(15,0) NULL)
/* Tue Mar 13 16:32:28 2007 */ OK
/* Tue Mar 13 16:32:28 2007 */ CREATE UNIQUE INDEX user_cache_ind6 ON
user_cacheY22 (userName)
/* Tue Mar 13 16:32:28 2007 */ OK
/* Tue Mar 13 16:32:28 2007 */ INSERT INTO user_cacheY22 (serverId,
entryId,
userName,password,authUserName,shortAuthString,licensePool,email,
notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,timestamp,vali
dateKey,shortGroup,longGroup,shortCompGroup,longCompGroup,fixedLicChange
,badPwd,badPwdTotal,pwdChange) SELECT serverId, entryId,
userName,password,authUserName,authString,licensePool,email,
notifyMech,licType,licTypeFText,licTypeReserv1,licTypeApp,timestamp,vali
dateKey,shortGroup,longGroup,shortCompGroup,longCompGroup,fixedLicChange
,badPwd,badPwdTotal,pwdChange FROM user_cache
/* Tue Mar 13 16:32:29 2007 */ ROLLBACK WORK
/* Tue Mar 13 16:32:29 2007 */ CREATE TABLE support_fileY22(fileType
number(15,0) not null,id number(15,0) not null,id2 number(15,0) not
null,fileId number(15,0) not null,timestamp number(15,0) not
null,fileContent long raw NULL)
/* Tue Mar 13 16:32:29 2007 */ OK
/* Tue Mar 13 16:32:29 2007 */ INSERT INTO support_fileY22
(fileType,id,id2,fileId,timestamp,fileContent) SELECT
fileType,id,id2,fileId,timestamp,fileContent FROM support_file
/* Tue Mar 13 16:32:29 2007 */ *** ERROR *** ORA-22835: Buffer too
small for CLOB to CHAR or BLOB to RAW conversion (actual: 38400,
maximum: 2000)
/* Tue Mar 13 16:32:29 2007 */ ROLLBACK WORK
/* Tue Mar 13 16:32:29 2007 */ DROP TABLE support_fileY22
/* Tue Mar 13 16:32:29 2007 */ OK
/* Tue Mar 13 16:32:29 2007 */ ALTER TABLE field_attach DROP COLUMN
fullTextOptions
/* Tue Mar 13 16:32:29 2007 */ OK
/* Tue Mar 13 16:32:29 2007 */ DROP TABLE user_cacheY22
/* Tue Mar 13 16:32:29 2007 */ OK
/* Tue Mar 13 16:32:29 2007 */ COMMIT WORK RELEASE
/* Tue Mar 13 16:32:29 2007 */ SQL Trace Log - OFF
Has anyone else experienced this issue Is there anything we can do
to bypass this?
Amanda Pierce
PDS Client Systems Development
Technology Services
Turner Broadcasting System, Inc
404-827-2959
Please use http://sos http://sos to submit a technology request.
Email Security Key Issue
All, We are in the process of upgrading from Remedy 6.0.1 to Remedy 7.0.1 patch 001, we have a couple of customers who submit tickets via the Email Template method. This works fine in v6, however in v7 we get this error when using the Security Key assigned to this user: Missing AR System User Information. automated process If I use a different account in my Security Key, like my own, then it goes through parsing successfully. Has anyone experienced this or has any ideas as to why this is happening or a fix? Thanks! Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: email template and carriage returns
Steve, We do the same thing and we experienced the same issue. I got around it by inserting || instead of a carriage return in the template. Then I have a filter on submit of the record to the ticket that replaces the || with an actual carriage return. Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Steven Pataray Sent: Thursday, March 08, 2007 5:00 PM To: arslist@ARSLIST.ORG Subject: email template and carriage returns ** I just upgraded from ARS 4.03 to ARS 6.3. I've been using asp forms to send the email templates to my remedy email address to my HPD:HelpDesk form with no problems, pretty simple. I'm learned from trial and error that the new engine has the email instructions form and email template form to help process the new template schema. The problem I'm currently having is Carriage returns. When my email templates gets sent I append fields together to form the Description field formatted in an orderly matter. When I want a new line in my asp forms I just use the vbCrLf _ to create a hard return and the continuation line. For some reason when it gets parsed into the Email engine it doesn't know what to do. I read in prior posts that it will not take words like Name: in the fields because it'll translate it to a keyword. But I have not read any limitations to carriage returns or how to include it so the engine will like it. Does anyone have any experience with this? I just noticed that my Description field is unlimited (0 input length). Could that be some sort of reason? It's only affecting the Description field. Thanks Steve - ARS 6.3 HelpDesk 6.3 Oracle 10gR1 on separate clustered database server Windows server 2003 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Help! Email Notifications not going out
All, We are upgrading to 7.0.1 patch 001 and we are having issues with Email Notifications. Regular Outgoing emails are running fine, going through an smtp gateway. The filter notifications are not going out??? Is there anything we can check? Anyone hear of this yet? Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos to submit a technology request. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.gif Description: image001.gif
Remedy 7.0.1 patch 001 Core Field Data Lengths
All, We have home grown Remedy applications. I noticed with the new version 7 that the Submitter/Modified By/Assigned To fields now have a default db length value of 70, which puts the expand box on. Anyone have a nice quick way of changing all of these fields to have the expand box property set to Hide? Just curious, otherwise I will be going through all of my forms manually to hide them... Thanks! Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Notify Action on a Filter
All, I am experiencing a weird issue in my test environment. I have an Outgoing mailbox set up and it is set to the default. If I have workflow that does a Push Fields to the ARSystem Email Message form the emails go out fine. If I do a Filter Notify action, the emails are not sending out. Anyone here of this happening? I am puzzled... Any help would be appreciated! Thanks Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.0.01 Group form problem
I am having this same issue, so any answers you receive I would really appreciate knowing them as well. Thanks! Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos to submit a technology request. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, February 26, 2007 11:52 PM To: arslist@ARSLIST.ORG Subject: ARS 7.0.01 Group form problem We recently upgraded from version 5 to 6.3 and then onto 7.0.01. Most everything seems to work fine, but our other admin called me today to tell me we have a problem with Group form. It appears that now if you attempt to make a change to the group form (any change) you receive the following message: Please confirm that you wish to save the form with the following fields deleted: Box Group Details, Box System Generated, Modify, New Request, New Search Query, SHOW MEMBERS, Submit, Text Group Details If you choose to cancel, the above changes to the form will not be saved. Anyone have any ideas on this one? I am not really sure where to go from here. I happen to be in Atlanta this week for the ARS 7.X admin part 2, so I plan on asking the instructor tomorrow what he thinks. The Instructor is William (Willkie) McKelvey. Is anyone familiar with him? He seems like a pretty knowledgeable guy, be he is fairly new to ARS. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.0.01 Group form problem
Actually, I have some additional tables that I added to the User form and it is not wanting to include them at all. Even when I bring them over from Fields Not in View...it gives an error on save that says the table has invalid properties. I use this right now in 6.0.1 so I am not sure what has changed to make the properties invalid. Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos to submit a technology request. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, February 27, 2007 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.01 Group form problem Chances are these are fields that are left over from previous versions. When the installer imports the group form, it does an import in place, which removes any fields not in the definition out of all views. Since these are trim/display only fields, performing a save with none of them in the view will cause a delete of the fields. You can take the approach mentioned previously to add them to a view and save the form; or you can delete the fields. Either approach is safe; I would opt for the latter, because who wants pointless fields hanging around on their forms. Axton Grams On 2/27/07, Pierce, Amanda (TBS) [EMAIL PROTECTED] wrote: I am having this same issue, so any answers you receive I would really appreciate knowing them as well. Thanks! Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos to submit a technology request. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, February 26, 2007 11:52 PM To: arslist@ARSLIST.ORG Subject: ARS 7.0.01 Group form problem We recently upgraded from version 5 to 6.3 and then onto 7.0.01. Most everything seems to work fine, but our other admin called me today to tell me we have a problem with Group form. It appears that now if you attempt to make a change to the group form (any change) you receive the following message: Please confirm that you wish to save the form with the following fields deleted: Box Group Details, Box System Generated, Modify, New Request, New Search Query, SHOW MEMBERS, Submit, Text Group Details If you choose to cancel, the above changes to the form will not be saved. Anyone have any ideas on this one? I am not really sure where to go from here. I happen to be in Atlanta this week for the ARS 7.X admin part 2, so I plan on asking the instructor tomorrow what he thinks. The Instructor is William (Willkie) McKelvey. Is anyone familiar with him? He seems like a pretty knowledgeable guy, be he is fairly new to ARS. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS 7.0.01 Group form problem
Okay, so I submitted a support ticket but I just couldn't wait to find out. So, I took a chance... I exported my Group/User form from v6.0.1 and then imported in place for v7. That cleared up everything. Here is a screenshot of the error I was getting in case anyone else has seen this: Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos to submit a technology request. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, February 27, 2007 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.01 Group form problem Chances are these are fields that are left over from previous versions. When the installer imports the group form, it does an import in place, which removes any fields not in the definition out of all views. Since these are trim/display only fields, performing a save with none of them in the view will cause a delete of the fields. You can take the approach mentioned previously to add them to a view and save the form; or you can delete the fields. Either approach is safe; I would opt for the latter, because who wants pointless fields hanging around on their forms. Axton Grams On 2/27/07, Pierce, Amanda (TBS) [EMAIL PROTECTED] wrote: I am having this same issue, so any answers you receive I would really appreciate knowing them as well. Thanks! Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos to submit a technology request. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Monday, February 26, 2007 11:52 PM To: arslist@ARSLIST.ORG Subject: ARS 7.0.01 Group form problem We recently upgraded from version 5 to 6.3 and then onto 7.0.01. Most everything seems to work fine, but our other admin called me today to tell me we have a problem with Group form. It appears that now if you attempt to make a change to the group form (any change) you receive the following message: Please confirm that you wish to save the form with the following fields deleted: Box Group Details, Box System Generated, Modify, New Request, New Search Query, SHOW MEMBERS, Submit, Text Group Details If you choose to cancel, the above changes to the form will not be saved. Anyone have any ideas on this one? I am not really sure where to go from here. I happen to be in Atlanta this week for the ARS 7.X admin part 2, so I plan on asking the instructor tomorrow what he thinks. The Instructor is William (Willkie) McKelvey. Is anyone familiar with him? He seems like a pretty knowledgeable guy, be he is fairly new to ARS. Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are attachment: image003.jpg
ARS Email Engine 7.0.1 patch 001 Memory Errors
All, We have installed the email engine 7.0.1 patch 001 and are getting Memory Errors in our log files. The email engine is currently taking up an entire CPU to run. This doesn't sound normal. Anyone else having this issue? We put in a support ticket and they are looking into it, but was hoping someone out here can help. ARS 7.0.1 patch 001 Windows 2003 server Java 1.5.06 Oracle 10.2 Thank you! Amanda Pierce ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ARS Email Engine 7.0.1 patch 001 Memory Errors
That fixed it!!! Thank you so much!! Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos to submit a technology request. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, February 16, 2007 12:58 PM To: arslist@ARSLIST.ORG Subject: Re: ARS Email Engine 7.0.1 patch 001 Memory Errors ** The 7.0.01 email engine changed they way it starts. It attempts to cache all user/group info; this takes a massive amount of cpu and memory because it fetches 100 users at a time. There is a settings you set in the EmailDaemon.properties to disable this behavior and restore it back to the original behavior (evaluating user/group membership at notification time). com.remedy.arsys.emaildaemon.FetchUserGroupInfoOnDemand=true Set this in EmailDaemon.properties and restart the email engine. I think you will see this addresses your issue. Axton Grams On 2/16/07, Pierce, Amanda (TBS) [EMAIL PROTECTED] wrote: ** All, We have installed the email engine 7.0.1 patch 001 and are getting Memory Errors in our log files. The email engine is currently taking up an entire CPU to run. This doesn't sound normal. Anyone else having this issue? We put in a support ticket and they are looking into it, but was hoping someone out here can help. ARS 7.0.1 patch 001 Windows 2003 server Java 1.5.06 Oracle 10.2 Thank you! Amanda Pierce __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.gif Description: image001.gif
Problems with Mid-Tier 7.0.1
We have this installed and we are having problems getting the jsp pages to work under IIS. We have created the virtual directory under IIS and configured the isapi filter under iis. Any ideas Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos to submit a technology request. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.gif Description: image001.gif
Remedy 7.0.1 patch 001 under a Load Balancer
All, We are setting up a new infrastructure for our Remedy environment. We are going to be using a Load Balancer on top of 2 ARS Servers (Windows 2003). I was hoping to chat with someone else who may have an environment similar to this about some questions I have concerning the configuration of the ARS Servers, etc. Thanks! Amanda Pierce PDS Client Systems Development Technology Services Turner Broadcasting System, Inc 404-827-2959 Please use http://sos http://sos to submit a technology request. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are image001.gif Description: image001.gif
