We are in a process of upgrading all remedy modules to 8.1 from 7.6.04. First
we ran the installer for AR server and it upgraded but with 1 severe message
saying that approval server sanity check failed. Then we ran the atrium core
installer and it's in same state from the last 18 hours. It got
You could also use the native search functionality of Dev Studio for find all
occurrences of z1D Action and/or z1D_Action in the Run If qualifications of
Filters (and perhaps active links) to compile this list
Regards,
-Original Message-
From: Action Request System discussion list(ARSLi
(jumping the gun) Finally this is resolved . Thanks Pascale for all the
help.
Sumarize:
Issue:SW00439379 When you upgraded to BMC Remedy AR System 7.6.04 SP4, the
login page went in a continuous loop when you use Mozilla FireFox, Safari, or
Google Chrome browsers
Resolution:
Apply Pa
Hi,
I am trying to remove specific records from a table (T350).
If I run a SQL query on a Remedy form that has a T-table (T350) with a
B-table (B350) attachments,
Am I going to be able to delete the data in both tables?
My query:
Select C8 from T350
Where C8 = 'Reconciliation'
My
Don't forget your H350 table too. But the C1 from T350 if I remember
right is the C1 from H350 & B350.
Also, can't you do this with an escalation or filter? If you do this
with workflow the system will get all the sub tables for you.
From: Action Request System discussion list(ARSList)
[m
Kathy,
Is this about the RE:Job Runs form?
Use ARSystem to do the delete. It will clean up H and B tables for you. Did you
create the filter to do the delete?
Are you having an issue deleting the RE:Job runs records?
Regards,
Ryan.
From: Action Request System discussion list(ARSList)
[mailto
Is there any reason you can't remove them using the client?
You would have to do a compound query and do the B and H table(s) first before
deleting from the T table
i.e.
Select C1
>From B350
Where C1 in (Select C1 from T350 Where C8 = 'Reconciliation' )
Select ENTRYID
>From B350C536870923
Where
**
Our performance is so poor right now that we are doing this directly thru
SQL.
I did not do a query on C1, I queried C8. Is there something that need to
do with C1?
We are trying to stabilize things because a lot of records are created in
the table and it's degrading performance right now.
Kathy,
Unless you need to keep the records in this form.perform a truncate on the
T H and B tables
If it is the RE:Job Runs form the records on only for referencenothing
else..
Regards,
Ryan.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf
OK, put on your thinking caps for this one, it's a good one
I had a situation where our database was experiencing user locks for a specific
sql transaction that was causing fast threads to get hung in a waiting state,
some for days, so for the background:
Our environment:
We are running a four
Hi,
We are trying to delete data from 3 forms.
RE: Job Runs
RE: Job Events
Application Pending
Our team Project Manager wants to run a history report on the data that was
in Job Runs to measure how long reconciliation jobs are running (instead of
adding another 10 Gig of Memory). To pre
We are not using the client because it was hanging, and I tried the
escalation to delete the entries however it hung.
Thanks
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, August 15, 2013 10:36 AM
To: arslist@A
***
What is B350C536870923?
When I entered this value B30+the column - the query did not work for me.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Thursday, August 15, 2013 10:36 AM
To: arslist@ARSLIST.ORG
Subject:
I was just giving an example (the 536870923 was an example of a field ID) . If
you look in your database you should see a B350Cx table. That holds the
actual attachment.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris
Sent: Thu
Server reboot helped, now fast as expected…☺
// Lars
Från: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] För Danny Kellett
Skickat: den 14 augusti 2013 09:48
Till: arslist@ARSLIST.ORG
Ämne: Re: Slow import
**
Lars
Have you run this query outside the AR system? E
I already have the Request ID Block Size set to 50 on this form and the form
it does a push to. I've seen transaction locks on a insert/update statements
before, but not on a select.
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederi
Paul,
I've experienced locks on select before, when there are a large number of
(or a number taking a large amount of time) inserts/updates taking place,
the select doesn't want to give you 'dirty' data, so it waits till they are
done. To avoid these, you can try using the NOLOCK DB Hint
On
Do NOT use an escalation. It will review all the rows. Unless you are
running it on a different table that doesn't have a lot of rows and doing a
delete from that.
You want to make sure you do a multi thread delete and not a single thread
delete.
What DB are you using?
If you are using Oracle
I had to shut off the escalations because our system was hung. There were
over 36,000 records. Yesterday there were over 500,000 records. I did know
there was a multi thread delete. Is this in Oracle?
Thanks so much. I have been struggling with this all day.
From: Action Request Sys
I noticed yesterday that when tickets were assigned to groups, we were getting
"Undeliverable" messages back from the mail server. All of these were
notifications (A ticket has been assigned to your group...) that appear to have
been sent to users who are no longer with the organization, and wh
Sono fuori dall'ufficio fino a 02/09/2013
Risponderò al messaggio al mio ritorno.
Nota: Questa è una risposta automatizzata al messaggio "Email notifications
being sent to obsolete users? Remedy 7.5" inviata il 16/08/2013 1.41.29.
Questa è l'unica notifica che verrà ricevuta mentre la pers
We are currently looking for several Remedy Developers to fill various
positions on our Federal Government contracts in the Washington DC area.
Below is a list of the open positions:
ITSM 6.0 to ITSM 7.6.04 upgrade project. Asset Management, Change Management,
and BMC Analytics experience a m
22 matches
Mail list logo
