You could use the database session info within your trigger to find out which
server & process is generating the deletes. That will at least let you confirm
that it's an arserverd in your server group or not. e.g.
select sys_context('USERENV', 'HOST') from dual;
select process, program from v$
Hello,
Starting from the position that databases are a relic of the 1980s, and
date/time/timezone fields are a persistent nightmare, don't use them. Store all
your dates as a number of seconds or milliseconds since 1970 (ie epoch), and
then display them appropriately. The timezone element is on
: Brian Goralczyk
Sent: Thursday, March 29, 2012 6:16 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Sort of OT: Question for timezone experts out there..
** Joe,
The only way for that to happen (in my experience) is something performing
outside of the system
Joe...just a shot in the dark here...did you check web services? Maybe
some web service against an external employee dbase? Again...just a
thought. Hope this helps...
On 3/29/12, Joe Martin D'Souza wrote:
> We are having an issue with our Remedy application, where it appears that
> there is an up
se logs?
>>
>> Joe
>>
>> *From:* patchsk
>> *Sent:* Thursday, March 29, 2012 5:44 PM
>> *Newsgroups:* public.remedy.arsystem.general
>> *To:* arslist@ARSLIST.ORG
>> *Subject:* Re: Sort of OT: Question for timezone experts out there..
>>
>
: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Sort of OT: Question for timezone experts out there..
**
You might have checked this already.
Just for my understanding when these records got deleted did you notice if
there are any changes to CTM:People record: Last Modified By etc?
On
gt; goes on either on the AIE, CMDB, or any other AR System owned processes
> that may escape those logs?
>
> Joe
>
> *From:* patchsk
> *Sent:* Thursday, March 29, 2012 5:44 PM
> *Newsgroups:* public.remedy.arsystem.general
> *To:* arslist@ARSLIST.ORG
> *Subject:*
goes on either on
the AIE, CMDB, or any other AR System owned processes that may escape those
logs?
Joe
From: patchsk
Sent: Thursday, March 29, 2012 5:44 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Sort of OT: Question for timezone experts out there
.general
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Sort of OT: Question for timezone experts out there..
>
> **
> I'm not an expert at the DB timestamps. The way I read the data though is
> that it is 27 Mar 2012 at 12:05:05 AM and the dat
2 3:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: Sort of OT: Question for timezone experts out there..
**
Thanks. I just had a colleague confirm what you just said.. the –4:00 is to get
the Greenwich time, and that 12:05:05 AM is the actual local time that the
delete transaction happened..
Are
Dave
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, March 29, 2012 4:29 PM
To: arslist@ARSLIST.ORG
Subject: Sort of OT: Question for timezone experts out there..
**
We are having an issue with
slist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Thursday, March 29, 2012 4:29 PM
To: arslist@ARSLIST.ORG
Subject: Sort of OT: Question for timezone experts out there..
**
We are having an issue with our Remedy application, where it appears that there
is an update on our 'CTM:Pe
We are having an issue with our Remedy application, where it appears that there
is an update on our ‘CTM:People Permission Groups’ form where certain entries
are ‘disappearing mysteriously’ apparently with no explanation as to what's
causing them to disappear. I turned on API, SQL, Escalation an
13 matches
Mail list logo