c.com
>>
>> Office: 715-204-3061 or 701-232-5697x25
>>
>> Cell: 715-498-5056
>>
>>
>>
>> *From:* Action Request System discussion list(ARSList) [mailto:
>> arslist@ARSLIST.ORG] *On Behalf Of *Terry Bootsma
>> *Sent:* Monday, Oct
inc.com
>
> Office: 715-204-3061 or 701-232-5697x25
>
> Cell: 715-498-5056
>
>
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Terry Bootsma
> *Sent:* Monday, October 27, 2014 5:41 PM
> *To:*
Behalf Of Terry Bootsma
Sent: Monday, October 27, 2014 5:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: One Server from Server Group getting SQL error
**
Sounds definitely like an Oracle configuration issue.
Would be interesting to open multiple sqlplus sessions using your Oracle
Remedy-account, an
Goralczyk
Sent: October-27-14 4:24 PM
To: arslist@ARSLIST.ORG
Subject: One Server from Server Group getting SQL error
**
Any ideas or suggestions on what to look at would be GREATLY appreciated.
I have two servers in a server group. When one is brought up we are fine.
When we bring the second one up
Server from Server Group getting SQL error
**
Any ideas or suggestions on what to look at would be GREATLY appreciated.
I have two servers in a server group. When one is brought up we are fine.
When we bring the second one up, it seems to steal the DB connection. If we
recycle the first one it
Any ideas or suggestions on what to look at would be GREATLY appreciated.
I have two servers in a server group. When one is brought up we are fine.
When we bring the second one up, it seems to steal the DB connection. If
we recycle the first one it will take back the connection. And the server
, February 20, 2014 9:23 AM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Error when Refreshing Incident Console
**
This is a definite sign that someone is monkeying around with your database.
Have you asked your DBAs to help with performance tuning on Remedy lately?
Thanks,
Shawn Pierson
Remedy Developer
RSLIST.ORG
Subject: Re: SQL Error when Refreshing Incident Console
**
This is a definite sign that someone is monkeying around with your database.
Have you asked your DBAs to help with performance tuning on Remedy lately?
Thanks,
Shawn Pierson
Remedy Developer | Energy Transfer
From: Action Requ
] On Behalf Of Tommy Morris
Sent: Thursday, February 20, 2014 9:10 AM
To: arslist@ARSLIST.ORG
Subject: SQL Error when Refreshing Incident Console
**
I am receiving "ARERR [552] The SQL database operation failed. : ORA-38141: SQL
plan baseline SYS_SQL_PLAN_19c5fd83b7bfd1e7 does not exist&
I am receiving "ARERR [552] The SQL database operation failed. : ORA-38141: SQL
plan baseline SYS_SQL_PLAN_19c5fd83b7bfd1e7 does not exist" when refreshing the
Incident Console. When the Console first opens and the table refreshes it
returns the error, when I hit the Refresh icon it returns. How
Hi Vaibhav
�
gsql was not recognized option?
�
Atul
Original Message
Subject: Re: SQL error ORA-00911 when a sql executed from a filter but works in
sqlplus
From: "vaibhav wadekar"
Date: Wed, April 24, 2013 10:26 am
T
Can you run the same SQL via driver which will help you understand the
problem
./driver
Log
Provide the credential
Init
gsql
Type the SQL statement
Hope this helps
Regards/Vaibhav
On Wednesday, April 24, 2013, Atul Vohra wrote:
> **
>
> All,
>
> I am trying to parse a remedy field ex:
>
> Rem
I unfortunately can't tell you what's wrong with that statement...but I CAN
tell you that there is a RegEx Plugin that may do what you are looking for
https://communities.bmc.com/thread/53307?start=0&tstart=0
On Wed, Apr 24, 2013 at 7:51 AM, Atul Vohra wrote:
> **
>
> All,
>
> I am trying to pa
All,
I am trying to parse a remedy field ex:
Remedy Field X =�'SMITH^ALLENX^WARD^JONES'
�
Output saved in 4 different remedy fields
�
SMITH � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �
� � � � � � � � �
� � � � � � � � � � � � � � � � � � � �
ALLENX � � � �
To check if it is related to error 302, you must check the error log file
at the server. If it is 302, you will see a lot of logs of this error.
In our case we didn't solved it yet. For us its a problem investigation
with a proposed workaround (repeat the search). I think that it is related
to the
Yes.
Repeating the operation is clearing the issue.But we are coming across nearly
30 to 40 Service requests stuck because
of this reason.It would be really helpful if you can suggest any solution to
avoid this.
Thanks in Advance
Vinay
_
What's the error?
I used to receive error 302, that solved at repeating the operation.
Regards,
Jose Manuel Huerta
http://theremedyforit.com/
On Wed, Aug 29, 2012 at 7:00 PM, vinay kumar
wrote:
> Service requests are frequently getting stuck at WO generation because
> of SQL data operation
Service requests are frequently getting stuck at WO generation because
of SQL data operation error.
When i retry using 'retry' button,WO gets generated and SR moves to next stage.
Can anyone resolve it.
Thanks in advance
Vinay
_
That did it, the max text repl size, thanks a lot for the help on this, I
really appreciate it!
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of ravi rai
Sent: Monday, May 07, 2012 5:34 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 7.6.04 SQL Error
This is related to max text repl size Server Configuration
Check: http://msdn.microsoft.com/en-us/library/ms179573.aspx
Ravi
> Date: Mon, 7 May 2012 15:11:18 -0400
> From: jdso...@shyle.net
> Subject: Re: Remedy 7.6.04 SQL Error Message
> To: arslist@ARSLIST.ORG
>
>
Mike Hocks
Sent: Monday, May 07, 2012 2:46 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Remedy 7.6.04 SQL Error Message
After installing Analytics and we are now seeing the following error message
when trying to attach a file larger than 65536...any idea in SQL whe
I do not know this error off the cuff: something to remember:: mysql
install has a bug: (X86) install directory. I.E C:\program files(X86)\. the
characters ( ) cannot be in the install directory structure..
Ensure you put it in a special name.. we did something like bubbajoe
instead.. d:\bubbajoe\
After installing Analytics and we are now seeing the following error message
when trying to attach a file larger than 65536...any idea in SQL where to
adjust this size constraint?
"The SQL database operation failed. : The statement has been terminated.Length
of LOB data (549551) to be replicate
Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Martinez, Marcelo A
Sent: Monday, September 19, 2011 4:02 PM
To: arslist@ARSLIST.ORG
Subject: ARERR [552] - SQL Error 402
Receiving the following error.
I'm trying to run an ad-hoc report in INC module a
Receiving the following error.
I'm trying to run an ad-hoc report in INC module and am receiving this error.
The error is not specific to any field on the INC form I am trying to report on.
After I click OK, I receive the following Warning
I am the assignee on the incident. I can modify the
: Trapping SQL error in an active link
Hi Joe,
I don't know much about the internal structures of an Oracle database,
but in Sybase, each database has a table called "sysobjects" and
information about tables is stored in there:
Name Owner
Hi Joe,
I don't know much about the internal structures of an Oracle database,
but in Sybase, each database has a table called "sysobjects" and
information about tables is stored in there:
Name Owner Object_type
-- ---
@ARSLIST.ORG
Sent: Wednesday, February 4, 2009 4:08:42 PM
Subject: Re: Trapping SQL error in an active link
Hi Folks,
Thanks for all of the great suggestions. I ended up implementing a combination
of Jiri's and Joe's suggestions. I wrote a stored procedure that pokes around
in the system
on that allows me to
"ignore" this error in the active link. As far as I can tell, I
can control what happens if "no requests match" and if "multiple
requests match", but there is no way to trap the SQL error
condition and choose to ignore it.
About the only thing I h
ontrol what happens if "no requests match" and if "multiple
> requests match", but there is no way to trap the SQL error
> condition and choose to ignore it.
>
> About the only thing I have been able to come up with so far is
> to run a cron job periodically th
From: L G Robinson
To: arslist@ARSLIST.ORG
Sent: Tuesday, February 3, 2009 9:51:14 AM
Subject: Trapping SQL error in an active link
Hi Folks,
I have a problem with an active link set field action that utilizes an SQL
statement. The problem stems from the fact that the SQL
: 03 February 2009 14:51
To: arslist@ARSLIST.ORG
Subject: Trapping SQL error in an active link
Hi Folks,
I have a problem with an active link set field action that
utilizes an SQL statement. The problem stems from the fact that
the SQL command is issued against a database table that is
maintained
p the issue
you are experiencing.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of L G Robinson
Sent: Tuesday, February 03, 2009 7:51 AM
To: arslist@ARSLIST.ORG
Subject: Trapping SQL error in an active link
Hi Folks,
I have a pr
; this error in the active link. As far as I can tell, I
can control what happens if "no requests match" and if "multiple
requests match", but there is no way to trap the SQL error
condition and choose to ignore it.
About the only thing I have been able to come up with so far is
HTH
>
> Leonard Neely
> Column Technologies
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio M.
> Sent: Thursday, June 26, 2008 6:11 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Request
: arslist@ARSLIST.ORG
Subject: Re: Request ID "In Process" .. again, SQL Error
Hi Scott,
We´ve done several tests and unfortunately, a free text field is not
the problem, we have tested with the very same summary values and free
text input, but it doesn´t make the trick. It works for some users
t; Scott Parrish
> IT Prophets, LLC
> (770) 653-5203
> www.itprophets.com
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio M.
> Sent: Friday, June 20, 2008 9:15 PM
> To: arslist@ARSL
ehalf Of Mauricio M.
Sent: Friday, June 20, 2008 9:15 PM
To: arslist@ARSLIST.ORG
Subject: Request ID "In Process" .. again, SQL Error
Dear All,
I´d appreciate your help with this odd issue regarding incident
generation from the Requester Console, thanks in advance for your help
as al
Dear All,
I´d appreciate your help with this odd issue regarding incident
generation from the Requester Console, thanks in advance for your help
as always...
When I push the New Request button, the Incident ID will not be
created and the Incident will not be pushed to Helpdesk form. The ID
gets s
her form?
>
>C1,C2,C561000203,C8
>
>Fred
>
>-Original Message-
>From: Action Request System discussion list(ARSList)
>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
>Sent: Tuesday, October 30, 2007 3:05 PM
>To: arslist@ARSLIST.ORG
>Subject: ORA-01406 SQL error
)
[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin
Sent: Tuesday, October 30, 2007 3:05 PM
To: arslist@ARSLIST.ORG
Subject: ORA-01406 SQL error in Active Link
Hello Everyone,
I am getting an error in an Active Link that says,
"ARERR [552] Failure during SQL operation to the database : ORA-
Hello Everyone,
I am getting an error in an Active Link that says,
"ARERR [552] Failure during SQL operation to the database : ORA-01406: fetched
column value was truncated."
This happens during a Set Fields operation where it is reading a value from
another form. The Set Field is very similar
Has anyone seen this (or this type) of error before?
*/INSERT INTO actlink_group_ids (actlinkId,groupId) VALUES (23376,0)
*/*** ERROR *** INSERT failed because the following SET options have incorrect
settings: 'CONCAT_NULL_YIELDS_NULL'. Verify that SET options are correct for
use with indexe
Has anyone seen this error before? All of a sudden we can't save any
workflow in the admin tool
Failure during SQL operation to the database : The ROLLBACK TRANSACTION
request has no corresponding BEGIN TRANSACTION. (SQL Server 3903) (ARERR
552).
Welton Bryant MCSE,MCP
Sr. Business Appli
_
From: L. J. Head [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 09, 2007 10:22 AM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Strange SQL Error
Looks like we were still strangely unpatched...I took it up to SP4
_
From: Action Request System discussion list(ARSList)
[mailto:[E
Looks like we were still strangely unpatched...I took it up to SP4
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mahesh Patil
Sent: Tuesday, January 09, 2007 9:39 AM
To: arslist@ARSLIST.ORG
Subject: Re: Strange SQL Error
**
Hi,
You can
I will definitely try that...I'll bring it up to 19
_
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Robert Molenda
Sent: Tuesday, January 09, 2007 9:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Strange SQL Error
**
I've seen this
G
Sent: Tuesday, January 9, 2007 8:32:42 PM
Subject: Strange SQL Error
**
ARS 6.3
Windows 2003
SQL Server 2000
For awhile we have been receiving this error on our dev system...when it occurs
it happens every 30 seconds...a bounce of the arsystem service brings dev back
to functionality...remedy r
ECTED] On Behalf Of L. J. Head
Sent: Tuesday, January 09, 2007 7:03 AM
To: arslist@ARSLIST.ORG
Subject: Strange SQL Error
ARS 6.3
Windows 2003
SQL Server 2000
For awhile we have been receiving this error on our dev system...when it
occurs it happens every 30 seconds...a bounce of the arsyste
ARS 6.3
Windows 2003
SQL Server 2000
For awhile we have been receiving this error on our dev system...when it
occurs it happens every 30 seconds...a bounce of the arsystem service brings
dev back to functionality...remedy resides on separate box from db...any
suggestions?
Tue Jan 09 07:54:14 2
50 matches
Mail list logo
