Hi listers,

ARS 6.01
Sybase 12.5.3
Sun solaris 5.9

I deleted data on the DB.
I try now to import data into my form with arimport tool.
No way. I get all the time " The value(s) for this entry violate a
unique index that has been defined for this form (ARERR 382)"
I can't get where these indexes are stored.
I though in some cache. So I restarted the server.
Nothing helps.
Will be anyone kind enough to give a help on that ?
Thank you.

--

Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

When you deleted the data at the database level did you remember to delete all the data in the H and B tables as well?

Richard



From: Action Request System discussion list(ARSList) on behalf of Serouche Rahimpour
Sent: Wed 9/28/2005 7:11 AM
To: arslist@ARSLIST.ORG
Subject: somewhere ...



Hi listers,

ARS 6.01
Sybase 12.5.3
Sun solaris 5.9

I deleted data on the DB.
I try now to import data into my form with arimport tool.
No way. I get all the time " The value(s) for this entry violate a
unique index that has been defined for this form (ARERR 382)"
I can't get where these indexes are stored.
I though in some cache. So I restarted the server.
Nothing helps.
Will be anyone kind enough to give a help on that ?
Thank you.

--

Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

no. Oups I missed somehting?!?
I should maybe check the Remedy database reference ... or some sort of
documentation ... ???


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



Richard Brooks wrote:

>When you deleted the data at the database level did you remember to delete all the data in the H and B tables as well?
>
>Richard
>
>
>
>From: Action Request System discussion list(ARSList) on behalf of Serouche Rahimpour
>Sent: Wed 9/28/2005 7:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

** Whenever you delete data from the DB directly, you must not only remove the data from the T tables, but from the H and B tables as well. They will have the same number as the T table that you removed data from (i.e. T35 with have an H35 and B35).


On 9/28/05, Serouche Rahimpour wrote:

no. Oups I missed somehting?!?
I should maybe check the Remedy database reference ... or some sort of
documentation ... ???


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



Richard Brooks wrote:

>When you deleted the data at the database level did you remember to delete all the data in the H and B tables as well?
>
>Richard
>
>
>
>From: Action Request System discussion list(ARSList) on behalf of Serouche Rahimpour
>Sent: Wed 9/28/2005 7:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto: support@arslist.org )
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



This posting was submitted via the Web interface

Serouche:

Did you delete the data through the Remedy User Tool or through SQL code
applied directly to the database?

If it is the latter, it is possible that the database is out of sync with
the values stored in the Remedy database tables.

If you deleted entries in the T table, you MUST delete the
corresponding entries in the B and h
tables as well as any data in any extended data tables.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 5:11 AM
To: arslist@ARSLIST.ORG
Subject: somewhere ...


Hi listers,

ARS 6.01
Sybase 12.5.3
Sun solaris 5.9

I deleted data on the DB.
I try now to import data into my form with arimport tool.
No way. I get all the time " The value(s) for this entry violate a
unique index that has been defined for this form (ARERR 382)"
I can't get where these indexes are stored.
I though in some cache. So I restarted the server.
Nothing helps.
Will be anyone kind enough to give a help on that ?
Thank you.

--

Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

many thanks to you and also to Alan for these explanations.
I think I should really get more into these database considerations.


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
Serouche,

You might consider deleting records through the user tool and then the system takes care of those considerations for you. It is another option depending on what you're doing.

Susan


On 9/28/05, Serouche Rahimpour wrote:

many thanks to you and also to Alan for these explanations.
I think I should really get more into these database considerations.


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



This posting was submitted via the Web interface

thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

You can import the file in a distinct form , and using filters, check the
differences between the imported and the existing data. If there are
differences, update the user form. If not, do nothing.

A few years ago I used this to update the People information in my system, but I
never did it in the User form. I suppose this should not be a problem.

Hope this Helps;

Jose Manuel Viejo Lobato
josemanuel@viejolobato.com
http://ars.viejolobato.com


> thanks again.
> I have another issue of this kind which is the following:
> - I have to update everyday the user form with new data.
> - data can be of course updated but it can be the same
> - the output is in csv format
> - my user form has one index on emails
> The problem is that when I use the arimport to import the csv file into
> my form, it always ask to generate new entry-ids. Which I don't want to.
> So every day I delete the whole data in the form. I then import the data
> and that works fine.
> Is there another way of getting round into this?
> I mean this must be something to set... maybe in the form or an AL...
> Any idea?
>
>
> Serouche Rahimpour
> DCS Site Manager - Munich
>
> Phone +49(0) 89-3200-6673
> Fax +49(0) 89-3200-6898
> Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
> McKenzie, James J C-E LCMC HQISEC/L3 wrote:
>
> >Serouche:
> >
> >Did you delete the data through the Remedy User Tool or through SQL code
> >applied directly to the database?
> >
> >If it is the latter, it is possible that the database is out of sync with
> >the values stored in the Remedy database tables.
> >
> >If you deleted entries in the T table, you MUST delete the
> >corresponding entries in the B and h
> >tables as well as any data in any extended data tables.
> >
> >James McKenzie
> >Remedy Engineer
> >C-E LCMC HQISEC, US Army
> >L-3 GSI
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> >Sent: Wednesday, September 28, 2005 5:11 AM
> >To: arslist@ARSLIST.ORG
> >Subject: somewhere ...
> >
> >
> >Hi listers,
> >
> >ARS 6.01
> >Sybase 12.5.3
> >Sun solaris 5.9
> >
> >I deleted data on the DB.
> >I try now to import data into my form with arimport tool.
> >No way. I get all the time " The value(s) for this entry violate a
> >unique index that has been defined for this form (ARERR 382)"
> >I can't get where these indexes are stored.
> >I though in some cache. So I restarted the server.
> >Nothing helps.
> >Will be anyone kind enough to give a help on that ?
> >Thank you.
> >
> >--
> >
> >Serouche Rahimpour
> >DCS Site Manager - Munich
> >
> >Phone +49(0) 89-3200-6673
> >Fax +49(0) 89-3200-6898
> >Mob +49(0)176-2946-7484
> >
> > http://www.dcs.ch
> >
> >
> >
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
>
>
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
> >
> >
>
>

> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Serouche:

Is there a way that you can 'fake' the Entry ID field into your CSV file?
This way you can UPDATE the current record with new data every night.
Otherwise you are stuck clearing out the form and importing the new data.
Just a thought about how you could best handle this situation.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 8:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

You are just wanting to update the existing records?
One of the options in arimport is to "update existing"

Mark Blankenship
ars@mainhelpdesk.com
http://ars.mainhelpdesk.com
----- Original Message -----
From: "Serouche Rahimpour"
Newsgroups: public.remedy.arsystem.general
To:
Sent: Wednesday, September 28, 2005 10:36 AM
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Serouche,
To replace old record with new, field id 1 must be mapped. If the
replacement data (.csv) doesn't come from User, it probably won't have
field id 1.
You can build a form to house imported records, generating new ids for
each, and use filters to update corresponding records in User.
APPLICATION-DELETE-ENTRY can be used clean-up the imported records.

Mike White
Office: 813-978-2192
E-mail: mike.white@verizon.com



"Serouche
Rahimpour" To: arslist@ARSLIST.ORG
ur@DCS.CH> Subject: Re: somewhere ...
Sent by: "Action
Request System
discussion
list(ARSList)"
ORG>


09/28/2005 11:36
Please respond to
arslist






thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>


>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>


>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

I use SQL Server Data Transformation Services to pull data from remote sources into local database tables. The tables are then scanned against their corresponding Remedy forms to determine if the data needs to be updated. Each table has a RequestID column that is populated from a query against the Remedy form. If the RequestID column is NULL, then the record is exported to a new.csv file. If the RequestID is NOT NULL, then the record is exported to an update.csv file. There are then 2 jobs that kick off arimportcmd. 1 job imports using a Generate New ID mapping for the new.csv file. The other job imports using an Update Existing Record mapping for the update.csv file.

With this method I don't have to worry about the system being unavailable while the data refreshes. While the SQL Statements within the DTS Package can be intense, it ensures that the workload required by Remedy is reduced. I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I queried the list about the other week. After increasing the Maximum Filters I was happy with server utilization. It did, however, take 17 hours to process 60,000 of 300,000 records, during which time the Escalation Thread was tied up. Now the process runs in about 45 minutes and the escalation thread is only tied up for a few milliseconds. Thanks for everyone's input on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Mark:

Update Existing Record with New Data will only work if Field ID 1 (Entry ID)
is mapped. If you do not/cannot map this field then the Import Tool will
ask to generate new IDs for all 'new' records no matter what else you map.

I like the suggestion to use a new form based on the User form and import
data into that form, use filters to update the User form and then use an
Escalation to delete records after the information in the record is updated.
Safe and actually partially reversible.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Mark Blankenship
Sent: Wednesday, September 28, 2005 9:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


You are just wanting to update the existing records?
One of the options in arimport is to "update existing"

Mark Blankenship
ars@mainhelpdesk.com
http://ars.mainhelpdesk.com
----- Original Message -----
From: "Serouche Rahimpour"
Newsgroups: public.remedy.arsystem.general
To:
Sent: Wednesday, September 28, 2005 10:36 AM
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Daniel:

Nice solution, if you are using MSSQL Server, but Serouche is not, nor am I.
I'm guessing that Oracle has a competing product as well as Sybase, so your
comments are definately not out of line. However, I recommend using Remedy
processes whenever possible to reduce the possibility of data corruption.
Of course, creating a csv file from data external to Remedy is a good thing
to do.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Daniel Hill
Sent: Wednesday, September 28, 2005 9:16 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

It sounds to me like that all he may need to do is reset the nextID back to 1 for the import forms. It's easy to do, and the instructions are in the docs.




Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253) 278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote sources into local database tables. The tables are then scanned against their corresponding Remedy forms to determine if the data needs to be updated. Each table has a RequestID column that is populated from a query against the Remedy form. If the RequestID column is NULL, then the record is exported to a new.csv file. If the RequestID is NOT NULL, then the record is exported to an update.csv file. There are then 2 jobs that kick off arimportcmd. 1 job imports using a Generate New ID mapping for the new.csv file. The other job imports using an Update Existing Record mapping for the update.csv file.

With this method I don't have to worry about the system being unavailable while the data refreshes. While the SQL Statements within the DTS Package can be intense, it ensures that the workload required by Remedy is reduced. I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I queried the list about the other week. After increasing the Maximum Filters I was happy with server utilization. It did, however, take 17 hours to process 60,000 of 300,000 records, during which time the Escalation Thread was tied up. Now the process runs in about 45 minutes and the escalation thread is only tied up for a few milliseconds. Thanks for everyone's input on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.





Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)





UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

...and your point is...? There's nothing inherent in the User form that prohibits this action. If he's trying to re-import that which he deleted, he needs to:

*
tell his import mechanism to disregard the entry ID and just force the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately, or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that there are), then it should be pretty easy to see what they are and compare them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value - duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.





Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)





UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)






UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Rick:

I would not try to do certain things with the User form, at least not
directly. The indirect approach appears to be the best method for changing
data in this form. I know that the User form is 'just another form', but
delete your adminstrators and see what you have to go through to fix it.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 10:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


...and your point is...? There's nothing inherent in the User form that
prohibits this action. If he's trying to re-import that which he deleted,
he needs to:

*
tell his import mechanism to disregard the entry ID and just force
the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately,
or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that
there are), then it should be pretty easy to see what they are and compare
them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value -
duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.





Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)





UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)







UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Rick,

I think his point was that "reset the nextID back to 1" is not a good thing.

MAYBE... "reset the nextID back to 2" would work. However it would
only work if your import uses the user record in the "000000000000001"
record.

:)


But while I am chipping my two cents in on the topic...

I would suggest the import to an intermediate form approach. Then use
filter workflow to push values to the User form.

Here is why:
) When the record really does not change, then do not change it.
Making changes to the User (and Group) data does *special* things to
the in memory ARS server cache. The less thrashing you have here the
better. (IMHO)
) It lets you do things like monitor how many record actually
mattered every day
) It would (in theory) let you not change everyones password every
day. :) But I am guessing that AREA might be serving that needed in
this specific case too.
) It lets you better control thing like preventing someone from
sneaking in a new Admin account on you in tomorrows data file. :)
) You do not have to do any direct SQL against the ARS db. (Always
a good thing to avoid whenever possible.)
) It allows for changes in the processing to done with ARS
workflow changes instead of script changes. :)
) It requires the least amount of "outside ARS workflow"
development. (improved maintainability.)


And I will stop there and get back to my 9 to 5. :)

--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)

Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.


On 9/28/05, Rick Cook wrote:
> ...and your point is...?

> Rick


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
No one asks where the new data is coming from.
Could the user form entry id be inserted into wherever that data is coming from?
Why does it have to be updated everynight?
Is it external customers as opposed to internal staff?
What are they logging into?

Now I haven't looked this up but in v6+ can't you import based on another field other than entry id? I'm only on 5.1.2 and somehow I've been looking forward to that feature, although it might just have been a dream ...lol

Susan




On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3 wrote:

Rick:

I would not try to do certain things with the User form, at least not
directly. The indirect approach appears to be the best method for changing
data in this form. I know that the User form is 'just another form', but
delete your adminstrators and see what you have to go through to fix it.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 10:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


...and your point is...? There's nothing inherent in the User form that
prohibits this action. If he's trying to re-import that which he deleted,
he needs to:

*
tell his import mechanism to disregard the entry ID and just force
the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately,
or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that
there are), then it should be pretty easy to see what they are and compare
them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value -
duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.





Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)





UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)







UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



This posting was submitted via the Web interface

**

Serouche,

Another option is to create a staging form. i.e. User TEMP. Import the records from your CSV file to this form instead. Note: It's okay to let new entry id's to be created.

Then, create a filter with the following info:

Form Name: User TEMP
Execute On: MERGE
Run If: 'Email Address' != $NULL$

If Action:
Push Field
Push Value To: User
Push Field If: 'Email Address' = $Email Address$
If No Request Match: Create a New Request
If Any Requests Match: Modify First Matching Request
Fields: Push the fields you need to update and/or to create new entries.

In this option, you don't need to worry about the entry id's at all. You also avoid deleting records directly from the User form. When the migration is done, you simply delete the records in the User TEMP or you can keep them for your records or reporting purposes.

I hope this helps.


-Alvin Cruz
acruz@xactresults.com
http://www.xactresults.com




-------- Original Message --------
Subject: Re: somewhere ...
From: Serouche Rahimpour
Date: Wed, September 28, 2005 8:36 am
To: arslist@ARSLIST.ORG

thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

This posting was submitted via the Web interface

Deleting an administraor user is not that hard to fix.

--
Jarl

On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
> Rick:
>
> I would not try to do certain things with the User form, at least not
> directly. The indirect approach appears to be the best method for changing
> data in this form. I know that the User form is 'just another form', but
> delete your adminstrators and see what you have to go through to fix it.
>
> James McKenzie
> Remedy Engineer
> C-E LCMC HQISEC, US Army
> L-3 GSI
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
> Sent: Wednesday, September 28, 2005 10:45 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> ...and your point is...? There's nothing inherent in the User form that
> prohibits this action. If he's trying to re-import that which he deleted,
> he needs to:
>
> *
> tell his import mechanism to disregard the entry ID and just force
> the records into existing slots that may or may not match, or
> *
> find a way to map the entry ID and update the record appropriately,
> or
> *
> reset the nextID and pretend it's an initial install.
>
> If there are existing records (which, from the error msg, it appears that
> there are), then it should be pretty easy to see what they are and compare
> them to his import file, perhaps merge the two, and go from there.
>
> Of course, the Unique Index error may also be a product of a NULL value -
> duplicate NULLs will spawn that error, too.
>
>
> Rick
>
>
>
> From: Action Request System discussion list(ARSList) on behalf of McKenzie,
> James J C-E LCMC HQISEC/L3
> Sent: Wed 9/28/2005 10:02 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
>
>
> Rick:
>
> This is the USER form.
>
> James McKenzie
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
> Sent: Wednesday, September 28, 2005 9:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> It sounds to me like that all he may need to do is reset the nextID back to
> 1 for the import forms. It's easy to do, and the instructions are in the
> docs.
>
>
>
>
>
> Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
> 278-4112
>
>
>
> From: Action Request System discussion list(ARSList) on behalf of Daniel
> Hill
> Sent: Wed 9/28/2005 9:15 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
>
>
> I use SQL Server Data Transformation Services to pull data from remote
> sources into local database tables. The tables are then scanned against
> their corresponding Remedy forms to determine if the data needs to be
> updated. Each table has a RequestID column that is populated from a query
> against the Remedy form. If the RequestID column is NULL, then the record
> is exported to a new.csv file. If the RequestID is NOT NULL, then the
> record is exported to an update.csv file. There are then 2 jobs that kick
> off arimportcmd. 1 job imports using a Generate New ID mapping for the
> new.csv file. The other job imports using an Update Existing Record mapping
> for the update.csv file.
>
> With this method I don't have to worry about the system being unavailable
> while the data refreshes. While the SQL Statements within the DTS Package
> can be intense, it ensures that the workload required by Remedy is reduced.
> I have this running on 6 feeds currently and it works like a charm.
>
> P.S. - This method was used to overcome the Maximum Filter Operations I
> queried the list about the other week. After increasing the Maximum Filters
> I was happy with server utilization. It did, however, take 17 hours to
> process 60,000 of 300,000 records, during which time the Escalation Thread
> was tied up. Now the process runs in about 45 minutes and the escalation
> thread is only tied up for a few milliseconds. Thanks for everyone's input
> on the Maximum Filters.
>
> - Daniel
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> Sent: Wednesday, September 28, 2005 11:37 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> thanks again.
> I have another issue of this kind which is the following:
> - I have to update everyday the user form with new data.
> - data can be of course updated but it can be the same
> - the output is in csv format
> - my user form has one index on emails
> The problem is that when I use the arimport to import the csv file into
> my form, it always ask to generate new entry-ids. Which I don't want to.
> So every day I delete the whole data in the form. I then import the data
> and that works fine.
> Is there another way of getting round into this?
> I mean this must be something to set... maybe in the form or an AL...
> Any idea?
>
>
> Serouche Rahimpour
> DCS Site Manager - Munich
>
> Phone +49(0) 89-3200-6673
> Fax +49(0) 89-3200-6898
> Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
> McKenzie, James J C-E LCMC HQISEC/L3 wrote:
>
> >Serouche:
> >
> >Did you delete the data through the Remedy User Tool or through SQL code
> >applied directly to the database?
> >
> >If it is the latter, it is possible that the database is out of sync with
> >the values stored in the Remedy database tables.
> >
> >If you deleted entries in the T table, you MUST delete the
> >corresponding entries in the B and h
> >tables as well as any data in any extended data tables.
> >
> >James McKenzie
> >Remedy Engineer
> >C-E LCMC HQISEC, US Army
> >L-3 GSI
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> >Sent: Wednesday, September 28, 2005 5:11 AM
> >To: arslist@ARSLIST.ORG
> >Subject: somewhere ...
> >
> >
> >Hi listers,
> >
> >ARS 6.01
> >Sybase 12.5.3
> >Sun solaris 5.9
> >
> >I deleted data on the DB.
> >I try now to import data into my form with arimport tool.
> >No way. I get all the time " The value(s) for this entry violate a
> >unique index that has been defined for this form (ARERR 382)"
> >I can't get where these indexes are stored.
> >I though in some cache. So I restarted the server.
> >Nothing helps.
> >Will be anyone kind enough to give a help on that ?
> >Thank you.
> >
> >--
> >
> >Serouche Rahimpour
> >DCS Site Manager - Munich
> >
> >Phone +49(0) 89-3200-6673
> >Fax +49(0) 89-3200-6898
> >Mob +49(0)176-2946-7484
> >
> > http://www.dcs.ch
> >
> >
>
> >
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
>
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
> >
> >
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
> ===================================================================
> NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
> privileged and confidential information and is intended only for the
> addressee named above. If you received this message in error,
> please immediately notify the sender by return e-mail and delete the
> original message; any distribution, copying or use of this e-mail
> by you is strictly prohibited and may be unlawful.
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
Hi All

Just one word of warning about using the staging form to import User records - Remedy recognizes the User (and Group, Business Time etc.) forms by the fieldIds of certain fields in the form. You can have multiple copies of the User form and Group forms on your system (but NOT the Business Time forms - that'll cause you problems) and the consolidated entries from multiple forms are stored in the usercache or groupcache tables.

So, when you set up your staging form, do not use the same fieldIds as those in the User form, otherwise you've created a real User form which will consume licenses, cause server re-caches etc.

HTH

David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application

tel +44 1494 468980
mobile +44 7710 377761
email david.sanders@westoverconsulting.co.uk

web http://www.westoverconsulting.co.uk


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]On Behalf Of Alvin Cruz
Sent: Wednesday, September 28, 2005 7:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


**

Serouche,

Another option is to create a staging form. i.e. User TEMP. Import the records from your CSV file to this form instead. Note: It's okay to let new entry id's to be created.

Then, create a filter with the following info:

Form Name: User TEMP
Execute On: MERGE
Run If: 'Email Address' != $NULL$

If Action:
Push Field
Push Value To: User
Push Field If: 'Email Address' = $Email Address$
If No Request Match: Create a New Request
If Any Requests Match: Modify First Matching Request
Fields: Push the fields you need to update and/or to create new entries.

In this option, you don't need to worry about the entry id's at all. You also avoid deleting records directly from the User form. When the migration is done, you simply delete the records in the User TEMP or you can keep them for your records or reporting purposes.

I hope this helps.


-Alvin Cruz
acruz@xactresults.com
http://www.xactresults.com




-------- Original Message --------
Subject: Re: somewhere ...
From: Serouche Rahimpour
Date: Wed, September 28, 2005 8:36 am
To: arslist@ARSLIST.ORG

thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

This posting was submitted via the Web interface

This posting was submitted via the Web interface

**
You're both right, but I think we're all just throwing spaghetti at the wall trying to help with a not-very-well-defined problem.

Can the original poster give some more specifics as to the state of the User table's data?


Rick



From: Action Request System discussion list(ARSList) on behalf of Jarl Grøneng
Sent: Wed 9/28/2005 11:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...





Deleting an administraor user is not that hard to fix.

--
Jarl

On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
> Rick:
>
> I would not try to do certain things with the User form, at least not
> directly. The indirect approach appears to be the best method for changing
> data in this form. I know that the User form is 'just another form', but
> delete your adminstrators and see what you have to go through to fix it.
>
> James McKenzie
> Remedy Engineer
> C-E LCMC HQISEC, US Army
> L-3 GSI
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
> Sent: Wednesday, September 28, 2005 10:45 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> ...and your point is...? There's nothing inherent in the User form that
> prohibits this action. If he's trying to re-import that which he deleted,
> he needs to:
>
> *
> tell his import mechanism to disregard the entry ID and just force
> the records into existing slots that may or may not match, or
> *
> find a way to map the entry ID and update the record appropriately,
> or
> *
> reset the nextID and pretend it's an initial install.
>
> If there are existing records (which, from the error msg, it appears that
> there are), then it should be pretty easy to see what they are and compare
> them to his import file, perhaps merge the two, and go from there.
>
> Of course, the Unique Index error may also be a product of a NULL value -
> duplicate NULLs will spawn that error, too.
>
>
> Rick
>
>
>
> From: Action Request System discussion list(ARSList) on behalf of McKenzie,
> James J C-E LCMC HQISEC/L3
> Sent: Wed 9/28/2005 10:02 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
>
>
> Rick:
>
> This is the USER form.
>
> James McKenzie
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
> Sent: Wednesday, September 28, 2005 9:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> It sounds to me like that all he may need to do is reset the nextID back to
> 1 for the import forms. It's easy to do, and the instructions are in the
> docs.
>
>
>
>
>
> Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
> 278-4112
>
>
>
> From: Action Request System discussion list(ARSList) on behalf of Daniel
> Hill
> Sent: Wed 9/28/2005 9:15 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
>
>
> I use SQL Server Data Transformation Services to pull data from remote
> sources into local database tables. The tables are then scanned against
> their corresponding Remedy forms to determine if the data needs to be
> updated. Each table has a RequestID column that is populated from a query
> against the Remedy form. If the RequestID column is NULL, then the record
> is exported to a new.csv file. If the RequestID is NOT NULL, then the
> record is exported to an update.csv file. There are then 2 jobs that kick
> off arimportcmd. 1 job imports using a Generate New ID mapping for the
> new.csv file. The other job imports using an Update Existing Record mapping
> for the update.csv file.
>
> With this method I don't have to worry about the system being unavailable
> while the data refreshes. While the SQL Statements within the DTS Package
> can be intense, it ensures that the workload required by Remedy is reduced.
> I have this running on 6 feeds currently and it works like a charm.
>
> P.S. - This method was used to overcome the Maximum Filter Operations I
> queried the list about the other week. After increasing the Maximum Filters
> I was happy with server utilization. It did, however, take 17 hours to
> process 60,000 of 300,000 records, during which time the Escalation Thread
> was tied up. Now the process runs in about 45 minutes and the escalation
> thread is only tied up for a few milliseconds. Thanks for everyone's input
> on the Maximum Filters.
>
> - Daniel
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> Sent: Wednesday, September 28, 2005 11:37 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> thanks again.
> I have another issue of this kind which is the following:
> - I have to update everyday the user form with new data.
> - data can be of course updated but it can be the same
> - the output is in csv format
> - my user form has one index on emails
> The problem is that when I use the arimport to import the csv file into
> my form, it always ask to generate new entry-ids. Which I don't want to.
> So every day I delete the whole data in the form. I then import the data
> and that works fine.
> Is there another way of getting round into this?
> I mean this must be something to set... maybe in the form or an AL...
> Any idea?
>
>
> Serouche Rahimpour
> DCS Site Manager - Munich
>
> Phone +49(0) 89-3200-6673
> Fax +49(0) 89-3200-6898
> Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
> McKenzie, James J C-E LCMC HQISEC/L3 wrote:
>
> >Serouche:
> >
> >Did you delete the data through the Remedy User Tool or through SQL code
> >applied directly to the database?
> >
> >If it is the latter, it is possible that the database is out of sync with
> >the values stored in the Remedy database tables.
> >
> >If you deleted entries in the T table, you MUST delete the
> >corresponding entries in the B and h
> >tables as well as any data in any extended data tables.
> >
> >James McKenzie
> >Remedy Engineer
> >C-E LCMC HQISEC, US Army
> >L-3 GSI
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> >Sent: Wednesday, September 28, 2005 5:11 AM
> >To: arslist@ARSLIST.ORG
> >Subject: somewhere ...
> >
> >
> >Hi listers,
> >
> >ARS 6.01
> >Sybase 12.5.3
> >Sun solaris 5.9
> >
> >I deleted data on the DB.
> >I try now to import data into my form with arimport tool.
> >No way. I get all the time " The value(s) for this entry violate a
> >unique index that has been defined for this form (ARERR 382)"
> >I can't get where these indexes are stored.
> >I though in some cache. So I restarted the server.
> >Nothing helps.
> >Will be anyone kind enough to give a help on that ?
> >Thank you.
> >
> >--
> >
> >Serouche Rahimpour
> >DCS Site Manager - Munich
> >
> >Phone +49(0) 89-3200-6673
> >Fax +49(0) 89-3200-6898
> >Mob +49(0)176-2946-7484
> >
> > http://www.dcs.ch
> >
> >
>
> >
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
>
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
> >
> >
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
> ===================================================================
> NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
> privileged and confidential information and is intended only for the
> addressee named above. If you received this message in error,
> please immediately notify the sender by return e-mail and delete the
> original message; any distribution, copying or use of this e-mail
> by you is strictly prohibited and may be unlawful.
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




This posting was submitted via the Web interface

Susan:

Simple answer is no, you cannot import based on a different field than field
id 1, and I don't think this will change anytime soon as field id 1 is the
only field that will be unique on each and every form.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
Sent: Wednesday, September 28, 2005 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


**
No one asks where the new data is coming from.
Could the user form entry id be inserted into wherever that data is coming
from?
Why does it have to be updated everynight?
Is it external customers as opposed to internal staff?
What are they logging into?

Now I haven't looked this up but in v6+ can't you import based on another
field other than entry id? I'm only on 5.1.2 and somehow I've been looking
forward to that feature, although it might just have been a dream ...lol

Susan




On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
Rick:

I would not try to do certain things with the User form, at least not
directly. The indirect approach appears to be the best method for changing
data in this form. I know that the User form is 'just another form', but
delete your adminstrators and see what you have to go through to fix it.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 10:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


...and your point is...? There's nothing inherent in the User form that
prohibits this action. If he's trying to re-import that which he deleted,
he needs to:

*
tell his import mechanism to disregard the entry ID and just force
the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately,
or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that
there are), then it should be pretty easy to see what they are and compare
them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value -
duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.






Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)






UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)








UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


This posting was submitted via the Web
interface


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Jarl:

However, fixing a deleted administrator is not something you want to do on a
daily basis either. I think of the scenario met by the adminstrator who
comes in with his/her favorite morning beverage only to be met by the CIO
who is not speaking highly of the efforts to merge in one record of new data
into the User form which caused the entire Remedy system to lock up at 1
a.m.

I agree that the intermediate form is the best practice method at this time
for anyone to use to merge in external data into the User and/or Group form.
You don't want that 1 a.m. phone call (and yes, I've received one or two in
my time and they were NOT pretty.)

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Jarl Grøneng
Sent: Wednesday, September 28, 2005 11:31 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


Deleting an administraor user is not that hard to fix.

--
Jarl


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

**
Actually, that's been true for the life of ARS, but is changing. Soon (or already, depending on your version, every record in every form will have a GUID that will be completely unique, not just to the form, but to the system.




Rick Cook • Senior Remedy Consultant • Denali Advanced Integration • (253) 278-4112



From: McKenzie, James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 2:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...



Susan:

Simple answer is no, you cannot import based on a different field than field
id 1, and I don't think this will change anytime soon as field id 1 is the
only field that will be unique on each and every form.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
Sent: Wednesday, September 28, 2005 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


**
No one asks where the new data is coming from.
Could the user form entry id be inserted into wherever that data is coming
from?
Why does it have to be updated everynight?
Is it external customers as opposed to internal staff?
What are they logging into?

Now I haven't looked this up but in v6+ can't you import based on another
field other than entry id? I'm only on 5.1.2 and somehow I've been looking
forward to that feature, although it might just have been a dream ...lol

Susan




On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
Rick:

I would not try to do certain things with the User form, at least not
directly. The indirect approach appears to be the best method for changing
data in this form. I know that the User form is 'just another form', but
delete your adminstrators and see what you have to go through to fix it.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 10:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


...and your point is...? There's nothing inherent in the User form that
prohibits this action. If he's trying to re-import that which he deleted,
he needs to:

*
tell his import mechanism to disregard the entry ID and just force
the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately,
or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that
there are), then it should be pretty easy to see what they are and compare
them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value -
duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.






Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)






UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)








UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


This posting was submitted via the Web
interface


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)
This posting was submitted via the Web interface

Rick:

I agree the GUID is a 'good thing' but you will still have to map to it from
external data. The problem is that the OP was trying to import without any
identifying data from Remedy. At the present time, this is not possible and
I don't forsee any changes in the future. This is good thing, especially
with the User and Group forms, because you don't want two, three or more
individual entries for the same event in the ARS database.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 3:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


**
Actually, that's been true for the life of ARS, but is changing. Soon (or
already, depending on your version, every record in every form will have a
GUID that will be completely unique, not just to the form, but to the
system.


Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112


From: McKenzie, James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 2:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


Susan:

Simple answer is no, you cannot import based on a different field than field
id 1, and I don't think this will change anytime soon as field id 1 is the
only field that will be unique on each and every form.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
Sent: Wednesday, September 28, 2005 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


**
No one asks where the new data is coming from.
Could the user form entry id be inserted into wherever that data is coming
from?
Why does it have to be updated everynight?
Is it external customers as opposed to internal staff?
What are they logging into?

Now I haven't looked this up but in v6+ can't you import based on another
field other than entry id? I'm only on 5.1.2 and somehow I've been looking
forward to that feature, although it might just have been a dream ...lol

Susan




On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
Rick:

I would not try to do certain things with the User form, at least not
directly. The indirect approach appears to be the best method for changing
data in this form. I know that the User form is 'just another form', but
delete your adminstrators and see what you have to go through to fix it.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 10:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


...and your point is...? There's nothing inherent in the User form that
prohibits this action. If he's trying to re-import that which he deleted,
he needs to:

*
tell his import mechanism to disregard the entry ID and just force
the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately,
or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that
there are), then it should be pretty easy to see what they are and compare
them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value -
duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.






Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)






UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)








UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


This posting was submitted via the Web
interface



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

This posting was submitted via the Web
interface


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Using Meta-Update as the import tool, it IS possible and easy to import
based on ANY criteria that is unique to the form and can be expressed as a
Remedy Query.

For example, in the User form, say you want the full name field and email
address to match before a new record will be created.

With Meta-Update, you process each record of the import file and issue a
query to determine the update record. If no records match you can create a
record using different assignments. If one record matches it will update
that record. It will skip the update (optionally overridden) if there are
no data changes because of the intended update. If more then one record
matches an error is declared.

You may also chose only to create new records and skip updates of old record
so that when you process a file only those record not matching will cause
new ARS records to be created and those records matching will be skipped -
though this is not needed as there will be no update when no data has
changed.

Further, you can get much more complex than this if you wish. For example,
depending on the import data, the data in the update record, any other data
records you may load in this process from any ARS servers, you can elect to
update other tables as well. So for example, the import can update both
SHR:People and User.

Imports can be done as Merges (like the import tool) or Submits (not
possible in the import tool).

Please see www.softwaretoolhouse.com for more information or contact me off
list.

Ben Chernys

Senior Software Architect
Software Tool House Inc

Canada / Deutschland / Germany
Phone: +49 (089) 982 47935 GMT + 1
Mobile: +49 (0162) 175 0956
Email: mailto:Ben.Chernys@softwaretoolhouse.com
Web: http://www.softwaretoolhouse.com

A free notepad for Diary fields:
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS integration, import, batch facility:
http://www.softwaretoolhouse.com/products/SthMupd

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of McKenzie, James J C-E LCMC
HQISEC/L3
Sent: Wednesday, September 28, 2005 11:21 PM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


Susan:

Simple answer is no, you cannot import based on a different field than field
id 1, and I don't think this will change anytime soon as field id 1 is the
only field that will be unique on each and every form.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
Sent: Wednesday, September 28, 2005 11:26 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


**
No one asks where the new data is coming from.
Could the user form entry id be inserted into wherever that data is coming
from?
Why does it have to be updated everynight?
Is it external customers as opposed to internal staff?
What are they logging into?

Now I haven't looked this up but in v6+ can't you import based on another
field other than entry id? I'm only on 5.1.2 and somehow I've been looking
forward to that feature, although it might just have been a dream ...lol

Susan




On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
wrote:
Rick:

I would not try to do certain things with the User form, at least not
directly. The indirect approach appears to be the best method for changing
data in this form. I know that the User form is 'just another form', but
delete your adminstrators and see what you have to go through to fix it.

James McKenzie
Remedy Engineer
C-E LCMC HQISEC, US Army
L-3 GSI

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 10:45 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


...and your point is...? There's nothing inherent in the User form that
prohibits this action. If he's trying to re-import that which he deleted,
he needs to:

*
tell his import mechanism to disregard the entry ID and just force
the records into existing slots that may or may not match, or
*
find a way to map the entry ID and update the record appropriately,
or
*
reset the nextID and pretend it's an initial install.

If there are existing records (which, from the error msg, it appears that
there are), then it should be pretty easy to see what they are and compare
them to his import file, perhaps merge the two, and go from there.

Of course, the Unique Index error may also be a product of a NULL value -
duplicate NULLs will spawn that error, too.


Rick



From: Action Request System discussion list(ARSList) on behalf of McKenzie,
James J C-E LCMC HQISEC/L3
Sent: Wed 9/28/2005 10:02 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




Rick:

This is the USER form.

James McKenzie


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
Sent: Wednesday, September 28, 2005 9:54 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


It sounds to me like that all he may need to do is reset the nextID back to
1 for the import forms. It's easy to do, and the instructions are in the
docs.






Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
278-4112



From: Action Request System discussion list(ARSList) on behalf of Daniel
Hill
Sent: Wed 9/28/2005 9:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...




I use SQL Server Data Transformation Services to pull data from remote
sources into local database tables. The tables are then scanned against
their corresponding Remedy forms to determine if the data needs to be
updated. Each table has a RequestID column that is populated from a query
against the Remedy form. If the RequestID column is NULL, then the record
is exported to a new.csv file. If the RequestID is NOT NULL, then the
record is exported to an update.csv file. There are then 2 jobs that kick
off arimportcmd. 1 job imports using a Generate New ID mapping for the
new.csv file. The other job imports using an Update Existing Record mapping
for the update.csv file.

With this method I don't have to worry about the system being unavailable
while the data refreshes. While the SQL Statements within the DTS Package
can be intense, it ensures that the workload required by Remedy is reduced.
I have this running on 6 feeds currently and it works like a charm.

P.S. - This method was used to overcome the Maximum Filter Operations I
queried the list about the other week. After increasing the Maximum Filters
I was happy with server utilization. It did, however, take 17 hours to
process 60,000 of 300,000 records, during which time the Escalation Thread
was tied up. Now the process runs in about 45 minutes and the escalation
thread is only tied up for a few milliseconds. Thanks for everyone's input
on the Maximum Filters.

- Daniel

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
Sent: Wednesday, September 28, 2005 11:37 AM
To: arslist@ARSLIST.ORG
Subject: Re: somewhere ...


thanks again.
I have another issue of this kind which is the following:
- I have to update everyday the user form with new data.
- data can be of course updated but it can be the same
- the output is in csv format
- my user form has one index on emails
The problem is that when I use the arimport to import the csv file into
my form, it always ask to generate new entry-ids. Which I don't want to.
So every day I delete the whole data in the form. I then import the data
and that works fine.
Is there another way of getting round into this?
I mean this must be something to set... maybe in the form or an AL...
Any idea?


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



McKenzie, James J C-E LCMC HQISEC/L3 wrote:

>Serouche:
>
>Did you delete the data through the Remedy User Tool or through SQL code
>applied directly to the database?
>
>If it is the latter, it is possible that the database is out of sync with
>the values stored in the Remedy database tables.
>
>If you deleted entries in the T table, you MUST delete the
>corresponding entries in the B and h
>tables as well as any data in any extended data tables.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 5:11 AM
>To: arslist@ARSLIST.ORG
>Subject: somewhere ...
>
>
>Hi listers,
>
>ARS 6.01
>Sybase 12.5.3
>Sun solaris 5.9
>
>I deleted data on the DB.
>I try now to import data into my form with arimport tool.
>No way. I get all the time " The value(s) for this entry violate a
>unique index that has been defined for this form (ARERR 382)"
>I can't get where these indexes are stored.
>I though in some cache. So I restarted the server.
>Nothing helps.
>Will be anyone kind enough to give a help on that ?
>Thank you.
>
>--
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>

>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>

>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



===================================================================
NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
privileged and confidential information and is intended only for the
addressee named above. If you received this message in error,
please immediately notify the sender by return e-mail and delete the
original message; any distribution, copying or use of this e-mail
by you is strictly prohibited and may be unlawful.



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)






UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)




UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)








UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


This posting was submitted via the Web
interface



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Hi listers,

sorry that I didn't answer earlier.
Thanks to all who have answered to my initial question.
I posted few (dummy??) questions to which nobody answered so that I was
a bit feeling like in ... Twillight Zone or something like this ...
This time my question raised so many ideas so I was back again to the
real world.
Anyway, to answer to everybody, I make it short:
1- the data comes from an internal source to the company but with
specific information needed only by one department.
2- it is produced everynight by the ADS.
3- we are still on Remedy 4 (very soon on Remedy 6)
4- by the time being to implement a LDAP connector between the ARS and
the ADS, I get a txt file
5- I convert this one into csv
6- I insert all data into my form.

Many thanks to Alvin, James, Daniel, Rick and the others for clear
explanations.
Finally I have a filter which runs on merge, if Email != $NULL and which
update/create the entrie. That works just fine.

I have another big concern which is the following:
- I am migrating form Remedy 4 to Remedy 6. Of course arimport tool is
nice to migrate also the data. Idea: put the database into read only.
Use arimport to migrate the data. Put back the database into normal mode.
I am just wondering whether this could not be done easily with some SQL
procedures on our Sybase server 12.5.3 ?!?!
No doubt Meta-Update is a nice tool, but my boss is not willing to give
me some money for it. And ASA I remember it does not run on Sun OS 5.9.
Is it?

Other new and fresh ideas are welcome !
:-)


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



Ben Chernys wrote:

>Using Meta-Update as the import tool, it IS possible and easy to import
>based on ANY criteria that is unique to the form and can be expressed as a
>Remedy Query.
>
>For example, in the User form, say you want the full name field and email
>address to match before a new record will be created.
>
>With Meta-Update, you process each record of the import file and issue a
>query to determine the update record. If no records match you can create a
>record using different assignments. If one record matches it will update
>that record. It will skip the update (optionally overridden) if there are
>no data changes because of the intended update. If more then one record
>matches an error is declared.
>
>You may also chose only to create new records and skip updates of old record
>so that when you process a file only those record not matching will cause
>new ARS records to be created and those records matching will be skipped -
>though this is not needed as there will be no update when no data has
>changed.
>
>Further, you can get much more complex than this if you wish. For example,
>depending on the import data, the data in the update record, any other data
>records you may load in this process from any ARS servers, you can elect to
>update other tables as well. So for example, the import can update both
>SHR:People and User.
>
>Imports can be done as Merges (like the import tool) or Submits (not
>possible in the import tool).
>
>Please see www.softwaretoolhouse.com for more information or contact me off
>list.
>
>Ben Chernys
>
>Senior Software Architect
>Software Tool House Inc
>
>Canada / Deutschland / Germany
>Phone: +49 (089) 982 47935 GMT + 1
>Mobile: +49 (0162) 175 0956
>Email: mailto:Ben.Chernys@softwaretoolhouse.com
>Web: http://www.softwaretoolhouse.com
>
>A free notepad for Diary fields:
>http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
>An ARS integration, import, batch facility:
>http://www.softwaretoolhouse.com/products/SthMupd
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of McKenzie, James J C-E LCMC
>HQISEC/L3
>Sent: Wednesday, September 28, 2005 11:21 PM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>Susan:
>
>Simple answer is no, you cannot import based on a different field than field
>id 1, and I don't think this will change anytime soon as field id 1 is the
>only field that will be unique on each and every form.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
>Sent: Wednesday, September 28, 2005 11:26 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>**
>No one asks where the new data is coming from.
>Could the user form entry id be inserted into wherever that data is coming
>from?
>Why does it have to be updated everynight?
>Is it external customers as opposed to internal staff?
>What are they logging into?
>
>Now I haven't looked this up but in v6+ can't you import based on another
>field other than entry id? I'm only on 5.1.2 and somehow I've been looking
>forward to that feature, although it might just have been a dream ...lol
>
>Susan
>
>
>
>
>On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
> wrote:
>Rick:
>
>I would not try to do certain things with the User form, at least not
>directly. The indirect approach appears to be the best method for changing
>data in this form. I know that the User form is 'just another form', but
>delete your adminstrators and see what you have to go through to fix it.
>
>James McKenzie
>Remedy Engineer
>C-E LCMC HQISEC, US Army
>L-3 GSI
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
>Sent: Wednesday, September 28, 2005 10:45 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>...and your point is...? There's nothing inherent in the User form that
>prohibits this action. If he's trying to re-import that which he deleted,
>he needs to:
>
>*
> tell his import mechanism to disregard the entry ID and just force
>the records into existing slots that may or may not match, or
>*
> find a way to map the entry ID and update the record appropriately,
>or
>*
> reset the nextID and pretend it's an initial install.
>
>If there are existing records (which, from the error msg, it appears that
>there are), then it should be pretty easy to see what they are and compare
>them to his import file, perhaps merge the two, and go from there.
>
>Of course, the Unique Index error may also be a product of a NULL value -
>duplicate NULLs will spawn that error, too.
>
>
>Rick
>
>
>
>From: Action Request System discussion list(ARSList) on behalf of McKenzie,
>James J C-E LCMC HQISEC/L3
>Sent: Wed 9/28/2005 10:02 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>
>
>Rick:
>
>This is the USER form.
>
>James McKenzie
>
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
>Sent: Wednesday, September 28, 2005 9:54 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>It sounds to me like that all he may need to do is reset the nextID back to
>1 for the import forms. It's easy to do, and the instructions are in the
>docs.
>
>
>
>
>
>
>Rick Cook * Senior Remedy Consultant * Denali Advanced Integration * (253)
>278-4112
>
>
>
>From: Action Request System discussion list(ARSList) on behalf of Daniel
>Hill
>Sent: Wed 9/28/2005 9:15 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>
>
>I use SQL Server Data Transformation Services to pull data from remote
>sources into local database tables. The tables are then scanned against
>their corresponding Remedy forms to determine if the data needs to be
>updated. Each table has a RequestID column that is populated from a query
>against the Remedy form. If the RequestID column is NULL, then the record
>is exported to a new.csv file. If the RequestID is NOT NULL, then the
>record is exported to an update.csv file. There are then 2 jobs that kick
>off arimportcmd. 1 job imports using a Generate New ID mapping for the
>new.csv file. The other job imports using an Update Existing Record mapping
>for the update.csv file.
>
>With this method I don't have to worry about the system being unavailable
>while the data refreshes. While the SQL Statements within the DTS Package
>can be intense, it ensures that the workload required by Remedy is reduced.
>I have this running on 6 feeds currently and it works like a charm.
>
>P.S. - This method was used to overcome the Maximum Filter Operations I
>queried the list about the other week. After increasing the Maximum Filters
>I was happy with server utilization. It did, however, take 17 hours to
>process 60,000 of 300,000 records, during which time the Escalation Thread
>was tied up. Now the process runs in about 45 minutes and the escalation
>thread is only tied up for a few milliseconds. Thanks for everyone's input
>on the Maximum Filters.
>
>- Daniel
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>Sent: Wednesday, September 28, 2005 11:37 AM
>To: arslist@ARSLIST.ORG
>Subject: Re: somewhere ...
>
>
>thanks again.
>I have another issue of this kind which is the following:
>- I have to update everyday the user form with new data.
>- data can be of course updated but it can be the same
>- the output is in csv format
>- my user form has one index on emails
>The problem is that when I use the arimport to import the csv file into
>my form, it always ask to generate new entry-ids. Which I don't want to.
>So every day I delete the whole data in the form. I then import the data
>and that works fine.
>Is there another way of getting round into this?
>I mean this must be something to set... maybe in the form or an AL...
>Any idea?
>
>
>Serouche Rahimpour
>DCS Site Manager - Munich
>
>Phone +49(0) 89-3200-6673
>Fax +49(0) 89-3200-6898
>Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
>McKenzie, James J C-E LCMC HQISEC/L3 wrote:
>
>
>
>>Serouche:
>>
>>Did you delete the data through the Remedy User Tool or through SQL code
>>applied directly to the database?
>>
>>If it is the latter, it is possible that the database is out of sync with
>>the values stored in the Remedy database tables.
>>
>>If you deleted entries in the T table, you MUST delete the
>>corresponding entries in the B and h
>>tables as well as any data in any extended data tables.
>>
>>James McKenzie
>>Remedy Engineer
>>C-E LCMC HQISEC, US Army
>>L-3 GSI
>>-----Original Message-----
>>From: Action Request System discussion list(ARSList)
>>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>>Sent: Wednesday, September 28, 2005 5:11 AM
>>To: arslist@ARSLIST.ORG
>>Subject: somewhere ...
>>
>>
>>Hi listers,
>>
>>ARS 6.01
>>Sybase 12.5.3
>>Sun solaris 5.9
>>
>>I deleted data on the DB.
>>I try now to import data into my form with arimport tool.
>>No way. I get all the time " The value(s) for this entry violate a
>>unique index that has been defined for this form (ARERR 382)"
>>I can't get where these indexes are stored.
>>I though in some cache. So I restarted the server.
>>Nothing helps.
>>Will be anyone kind enough to give a help on that ?
>>Thank you.
>>
>>--
>>
>>Serouche Rahimpour
>>DCS Site Manager - Munich
>>
>>Phone +49(0) 89-3200-6673
>>Fax +49(0) 89-3200-6898
>>Mob +49(0)176-2946-7484
>>
>> http://www.dcs.ch
>>
>>
>>
>>
>
>
>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>
>
>
>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>
>>
>>
>
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>===================================================================
>NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
>privileged and confidential information and is intended only for the
>addressee named above. If you received this message in error,
>please immediately notify the sender by return e-mail and delete the
>original message; any distribution, copying or use of this e-mail
>by you is strictly prohibited and may be unlawful.
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>
>
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>This posting was submitted via the Web
>interface
>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Alan, James et al,

You might want to experiment with the -e option of arimportcmd.

According to page 560-564 of the Advanced Guide for 6.3, -e will let you
specify a field ID to be tested for duplicate ID's. Assuming that the
case-matching issues have been resolved you could run arimportcmd -e 101
(and some other arguments for mapping and file name) to test the login name
field to be a duplicate entry instead of testing field 1, Request ID. When
field 101 determines that the incoming data is a duplicate record (or not),
then I assume that your mapping's behavior for updating the existing record
or creating a new one would apply. The field you choose should be unique and
ideally indexed (it has always bothered me that the User and group forms
have no indexes by default).

I haven't actually tried this yet, and there is minor historic precedent for
documentation being out of step with the tool's behavior, but I think this
should work.

If I had to solve this problem I would favor use of a staging form because
you can use workflow to clean up the data, format email addresses and so
forth, and to avoid the potential task of recovering Remedy administrator
accounts. If you import into the User form from (for example) a daily export
CSV from the HR department, you'd also need some mechanism to periodically
delete (or render useless) records that were not in the file. Presumably
those would be employees no longer with the company.

Doug Blair

> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J
> C-E LCMC HQISEC/L3
> Sent: Wednesday, September 28, 2005 4:21 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
> Susan:
>
> Simple answer is no, you cannot import based on a different
> field than field
> id 1, and I don't think this will change anytime soon as
> field id 1 is the
> only field that will be unique on each and every form.
>
> James McKenzie
> Remedy Engineer
> C-E LCMC HQISEC, US Army
> L-3 GSI
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
> Sent: Wednesday, September 28, 2005 11:26 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> **
> No one asks where the new data is coming from.
> Could the user form entry id be inserted into wherever that
> data is coming
> from?
> Why does it have to be updated everynight?
> Is it external customers as opposed to internal staff?
> What are they logging into?
>
> Now I haven't looked this up but in v6+ can't you import
> based on another
> field other than entry id? I'm only on 5.1.2 and somehow
> I've been looking
> forward to that feature, although it might just have been a
> dream ...lol
>
> Susan
>
>
>
>
> On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
> wrote:
> Rick:
>
> I would not try to do certain things with the User form, at least not
> directly. The indirect approach appears to be the best
> method for changing
> data in this form. I know that the User form is 'just
> another form', but
> delete your adminstrators and see what you have to go through
> to fix it.
>
> James McKenzie
> Remedy Engineer
> C-E LCMC HQISEC, US Army
> L-3 GSI
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
> Sent: Wednesday, September 28, 2005 10:45 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> ...and your point is...? There's nothing inherent in the
> User form that
> prohibits this action. If he's trying to re-import that
> which he deleted,
> he needs to:
>
> *
> tell his import mechanism to disregard the entry ID
> and just force
> the records into existing slots that may or may not match, or
> *
> find a way to map the entry ID and update the record
> appropriately,
> or
> *
> reset the nextID and pretend it's an initial install.
>
> If there are existing records (which, from the error msg, it
> appears that
> there are), then it should be pretty easy to see what they
> are and compare
> them to his import file, perhaps merge the two, and go from there.
>
> Of course, the Unique Index error may also be a product of a
> NULL value -
> duplicate NULLs will spawn that error, too.
>
>
> Rick
>
>
>
> From: Action Request System discussion list(ARSList) on
> behalf of McKenzie,
> James J C-E LCMC HQISEC/L3
> Sent: Wed 9/28/2005 10:02 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
>
>
> Rick:
>
> This is the USER form.
>
> James McKenzie
>
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
> Sent: Wednesday, September 28, 2005 9:54 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> It sounds to me like that all he may need to do is reset the
> nextID back to
> 1 for the import forms. It's easy to do, and the
> instructions are in the
> docs.
>
>
>
>
>
>
>
> Rick Cook * Senior Remedy Consultant * Denali Advanced
> Integration * (253)
> 278-4112
>
>
>
> From: Action Request System discussion list(ARSList) on
> behalf of Daniel
> Hill
> Sent: Wed 9/28/2005 9:15 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
>
>
> I use SQL Server Data Transformation Services to pull data from remote
> sources into local database tables. The tables are then
> scanned against
> their corresponding Remedy forms to determine if the data needs to be
> updated. Each table has a RequestID column that is populated
> from a query
> against the Remedy form. If the RequestID column is NULL,
> then the record
> is exported to a new.csv file. If the RequestID is NOT
> NULL, then the
> record is exported to an update.csv file. There are then 2
> jobs that kick
> off arimportcmd. 1 job imports using a Generate New ID mapping for the
> new.csv file. The other job imports using an Update Existing
> Record mapping
> for the update.csv file.
>
> With this method I don't have to worry about the system being
> unavailable
> while the data refreshes. While the SQL Statements within the
> DTS Package
> can be intense, it ensures that the workload required by
> Remedy is reduced.
> I have this running on 6 feeds currently and it works like a charm.
>
> P.S. - This method was used to overcome the Maximum Filter
> Operations I
> queried the list about the other week. After increasing the
> Maximum Filters
> I was happy with server utilization. It did, however, take 17 hours to
> process 60,000 of 300,000 records, during which time the
> Escalation Thread
> was tied up. Now the process runs in about 45 minutes and the
> escalation
> thread is only tied up for a few milliseconds. Thanks for
> everyone's input
> on the Maximum Filters.
>
> - Daniel
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> Sent: Wednesday, September 28, 2005 11:37 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: somewhere ...
>
>
> thanks again.
> I have another issue of this kind which is the following:
> - I have to update everyday the user form with new data.
> - data can be of course updated but it can be the same
> - the output is in csv format
> - my user form has one index on emails
> The problem is that when I use the arimport to import the csv
> file into
> my form, it always ask to generate new entry-ids. Which I
> don't want to.
> So every day I delete the whole data in the form. I then
> import the data
> and that works fine.
> Is there another way of getting round into this?
> I mean this must be something to set... maybe in the form or an AL...
> Any idea?
>
>
> Serouche Rahimpour
> DCS Site Manager - Munich
>
> Phone +49(0) 89-3200-6673
> Fax +49(0) 89-3200-6898
> Mob +49(0)176-2946-7484
>
> http://www.dcs.ch
>
>
>
> McKenzie, James J C-E LCMC HQISEC/L3 wrote:
>
> >Serouche:
> >
> >Did you delete the data through the Remedy User Tool or
> through SQL code
> >applied directly to the database?
> >
> >If it is the latter, it is possible that the database is out
> of sync with
> >the values stored in the Remedy database tables.
> >
> >If you deleted entries in the T table, you MUST delete the
> >corresponding entries in the B and h
> >tables as well as any data in any extended data tables.
> >
> >James McKenzie
> >Remedy Engineer
> >C-E LCMC HQISEC, US Army
> >L-3 GSI
> >-----Original Message-----
> >From: Action Request System discussion list(ARSList)
> >[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
> >Sent: Wednesday, September 28, 2005 5:11 AM
> >To: arslist@ARSLIST.ORG
> >Subject: somewhere ...
> >
> >
> >Hi listers,
> >
> >ARS 6.01
> >Sybase 12.5.3
> >Sun solaris 5.9
> >
> >I deleted data on the DB.
> >I try now to import data into my form with arimport tool.
> >No way. I get all the time " The value(s) for this entry violate a
> >unique index that has been defined for this form (ARERR 382)"
> >I can't get where these indexes are stored.
> >I though in some cache. So I restarted the server.
> >Nothing helps.
> >Will be anyone kind enough to give a help on that ?
> >Thank you.
> >
> >--
> >
> >Serouche Rahimpour
> >DCS Site Manager - Munich
> >
> >Phone +49(0) 89-3200-6673
> >Fax +49(0) 89-3200-6898
> >Mob +49(0)176-2946-7484
> >
> > http://www.dcs.ch
> >
> >
>
>
> >
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
>
>
> >UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> >(Support: mailto:support@arslist.org)
> >
> >
> >
> >
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
> ===================================================================
> NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
> privileged and confidential information and is intended only for the
> addressee named above. If you received this message in error,
> please immediately notify the sender by return e-mail and delete the
> original message; any distribution, copying or use of this e-mail
> by you is strictly prohibited and may be unlawful.
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
>
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>
>
> This posting was submitted via the Web
> interface
>
>
>
> UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org)
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

my grandma used to say: " from birth to the grave, just learn, learn and
learn". What I try to do everyday of my life.
Thanks to you guys and also to the Remedy documentation.
Another concern is I am just wondering whether for my upgrade I could
just run sql queries on the database form one server to another, things
like "insert into DBDest.Txxx select from DBSource.Txxx"
I am wondering whether it would be enough? I mean I have tables with
same column on both databases.
Main differences are in the indexes.
Do you know if on Sybase my data stored in the tables is also affected
by the indexes?
I mean for example if my View Alpha is build on tables T123 and B123,
and if I synchronize at the database level my tables T123, B123 and H123
from one server to the other (keeping in mind that the database source
is Sybase 12.0 and database dest. is Sybase 12.5.3), is that enough to
have same data? Will be the integrity saved?
I am wondering whether you might have an answer.
That would be nice if you coud have an answer.
Thanks in advance.


Serouche Rahimpour
DCS Site Manager - Munich

Phone +49(0) 89-3200-6673
Fax +49(0) 89-3200-6898
Mob +49(0)176-2946-7484

http://www.dcs.ch



Doug Blair wrote:

>Alan, James et al,
>
>You might want to experiment with the -e option of arimportcmd.
>
>According to page 560-564 of the Advanced Guide for 6.3, -e will let you
>specify a field ID to be tested for duplicate ID's. Assuming that the
>case-matching issues have been resolved you could run arimportcmd -e 101
>(and some other arguments for mapping and file name) to test the login name
>field to be a duplicate entry instead of testing field 1, Request ID. When
>field 101 determines that the incoming data is a duplicate record (or not),
>then I assume that your mapping's behavior for updating the existing record
>or creating a new one would apply. The field you choose should be unique and
>ideally indexed (it has always bothered me that the User and group forms
>have no indexes by default).
>
>I haven't actually tried this yet, and there is minor historic precedent for
>documentation being out of step with the tool's behavior, but I think this
>should work.
>
>If I had to solve this problem I would favor use of a staging form because
>you can use workflow to clean up the data, format email addresses and so
>forth, and to avoid the potential task of recovering Remedy administrator
>accounts. If you import into the User form from (for example) a daily export
>CSV from the HR department, you'd also need some mechanism to periodically
>delete (or render useless) records that were not in the file. Presumably
>those would be employees no longer with the company.
>
>Doug Blair
>
>
>
>>-----Original Message-----
>>From: Action Request System discussion list(ARSList)
>>[mailto:arslist@ARSLIST.ORG] On Behalf Of McKenzie, James J
>>C-E LCMC HQISEC/L3
>>Sent: Wednesday, September 28, 2005 4:21 PM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>Susan:
>>
>>Simple answer is no, you cannot import based on a different
>>field than field
>>id 1, and I don't think this will change anytime soon as
>>field id 1 is the
>>only field that will be unique on each and every form.
>>
>>James McKenzie
>>Remedy Engineer
>>C-E LCMC HQISEC, US Army
>>L-3 GSI
>>
>>-----Original Message-----
>>From: Action Request System discussion list(ARSList)
>>[mailto:arslist@ARSLIST.ORG]On Behalf Of Susan Palmer
>>Sent: Wednesday, September 28, 2005 11:26 AM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>
>>**
>>No one asks where the new data is coming from.
>>Could the user form entry id be inserted into wherever that
>>data is coming
>>from?
>>Why does it have to be updated everynight?
>>Is it external customers as opposed to internal staff?
>>What are they logging into?
>>
>>Now I haven't looked this up but in v6+ can't you import
>>based on another
>>field other than entry id? I'm only on 5.1.2 and somehow
>>I've been looking
>>forward to that feature, although it might just have been a
>>dream ...lol
>>
>>Susan
>>
>>
>>
>>
>>On 9/28/05, McKenzie, James J C-E LCMC HQISEC/L3
>> wrote:
>>Rick:
>>
>>I would not try to do certain things with the User form, at least not
>>directly. The indirect approach appears to be the best
>>method for changing
>>data in this form. I know that the User form is 'just
>>another form', but
>>delete your adminstrators and see what you have to go through
>>to fix it.
>>
>>James McKenzie
>>Remedy Engineer
>>C-E LCMC HQISEC, US Army
>>L-3 GSI
>>
>>-----Original Message-----
>>From: Action Request System discussion list(ARSList)
>>[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
>>Sent: Wednesday, September 28, 2005 10:45 AM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>
>>...and your point is...? There's nothing inherent in the
>>User form that
>>prohibits this action. If he's trying to re-import that
>>which he deleted,
>>he needs to:
>>
>>*
>> tell his import mechanism to disregard the entry ID
>>and just force
>>the records into existing slots that may or may not match, or
>>*
>> find a way to map the entry ID and update the record
>>appropriately,
>>or
>>*
>> reset the nextID and pretend it's an initial install.
>>
>>If there are existing records (which, from the error msg, it
>>appears that
>>there are), then it should be pretty easy to see what they
>>are and compare
>>them to his import file, perhaps merge the two, and go from there.
>>
>>Of course, the Unique Index error may also be a product of a
>>NULL value -
>>duplicate NULLs will spawn that error, too.
>>
>>
>>Rick
>>
>>
>>
>>From: Action Request System discussion list(ARSList) on
>>behalf of McKenzie,
>>James J C-E LCMC HQISEC/L3
>>Sent: Wed 9/28/2005 10:02 AM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>
>>
>>
>>Rick:
>>
>>This is the USER form.
>>
>>James McKenzie
>>
>>
>>-----Original Message-----
>>From: Action Request System discussion list(ARSList)
>>[mailto:arslist@ARSLIST.ORG]On Behalf Of Rick Cook
>>Sent: Wednesday, September 28, 2005 9:54 AM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>
>>It sounds to me like that all he may need to do is reset the
>>nextID back to
>>1 for the import forms. It's easy to do, and the
>>instructions are in the
>>docs.
>>
>>
>>
>>
>>
>>
>>
>>Rick Cook * Senior Remedy Consultant * Denali Advanced
>>Integration * (253)
>>278-4112
>>
>>
>>
>>From: Action Request System discussion list(ARSList) on
>>behalf of Daniel
>>Hill
>>Sent: Wed 9/28/2005 9:15 AM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>
>>
>>
>>I use SQL Server Data Transformation Services to pull data from remote
>>sources into local database tables. The tables are then
>>scanned against
>>their corresponding Remedy forms to determine if the data needs to be
>>updated. Each table has a RequestID column that is populated
>>from a query
>>against the Remedy form. If the RequestID column is NULL,
>>then the record
>>is exported to a new.csv file. If the RequestID is NOT
>>NULL, then the
>>record is exported to an update.csv file. There are then 2
>>jobs that kick
>>off arimportcmd. 1 job imports using a Generate New ID mapping for the
>>new.csv file. The other job imports using an Update Existing
>>Record mapping
>>for the update.csv file.
>>
>>With this method I don't have to worry about the system being
>>unavailable
>>while the data refreshes. While the SQL Statements within the
>>DTS Package
>>can be intense, it ensures that the workload required by
>>Remedy is reduced.
>>I have this running on 6 feeds currently and it works like a charm.
>>
>>P.S. - This method was used to overcome the Maximum Filter
>>Operations I
>>queried the list about the other week. After increasing the
>>Maximum Filters
>>I was happy with server utilization. It did, however, take 17 hours to
>>process 60,000 of 300,000 records, during which time the
>>Escalation Thread
>>was tied up. Now the process runs in about 45 minutes and the
>>escalation
>>thread is only tied up for a few milliseconds. Thanks for
>>everyone's input
>>on the Maximum Filters.
>>
>>- Daniel
>>
>>-----Original Message-----
>>From: Action Request System discussion list(ARSList)
>>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>>Sent: Wednesday, September 28, 2005 11:37 AM
>>To: arslist@ARSLIST.ORG
>>Subject: Re: somewhere ...
>>
>>
>>thanks again.
>>I have another issue of this kind which is the following:
>>- I have to update everyday the user form with new data.
>>- data can be of course updated but it can be the same
>>- the output is in csv format
>>- my user form has one index on emails
>>The problem is that when I use the arimport to import the csv
>>file into
>>my form, it always ask to generate new entry-ids. Which I
>>don't want to.
>>So every day I delete the whole data in the form. I then
>>import the data
>>and that works fine.
>>Is there another way of getting round into this?
>>I mean this must be something to set... maybe in the form or an AL...
>>Any idea?
>>
>>
>>Serouche Rahimpour
>>DCS Site Manager - Munich
>>
>>Phone +49(0) 89-3200-6673
>>Fax +49(0) 89-3200-6898
>>Mob +49(0)176-2946-7484
>>
>> http://www.dcs.ch
>>
>>
>>
>>McKenzie, James J C-E LCMC HQISEC/L3 wrote:
>>
>>
>>
>>>Serouche:
>>>
>>>Did you delete the data through the Remedy User Tool or
>>>
>>>
>>through SQL code
>>
>>
>>>applied directly to the database?
>>>
>>>If it is the latter, it is possible that the database is out
>>>
>>>
>>of sync with
>>
>>
>>>the values stored in the Remedy database tables.
>>>
>>>If you deleted entries in the T table, you MUST delete the
>>>corresponding entries in the B and h
>>>tables as well as any data in any extended data tables.
>>>
>>>James McKenzie
>>>Remedy Engineer
>>>C-E LCMC HQISEC, US Army
>>>L-3 GSI
>>>-----Original Message-----
>>>From: Action Request System discussion list(ARSList)
>>>[mailto:arslist@ARSLIST.ORG]On Behalf Of Serouche Rahimpour
>>>Sent: Wednesday, September 28, 2005 5:11 AM
>>>To: arslist@ARSLIST.ORG
>>>Subject: somewhere ...
>>>
>>>
>>>Hi listers,
>>>
>>>ARS 6.01
>>>Sybase 12.5.3
>>>Sun solaris 5.9
>>>
>>>I deleted data on the DB.
>>>I try now to import data into my form with arimport tool.
>>>No way. I get all the time " The value(s) for this entry violate a
>>>unique index that has been defined for this form (ARERR 382)"
>>>I can't get where these indexes are stored.
>>>I though in some cache. So I restarted the server.
>>>Nothing helps.
>>>Will be anyone kind enough to give a help on that ?
>>>Thank you.
>>>
>>>--
>>>
>>>Serouche Rahimpour
>>>DCS Site Manager - Munich
>>>
>>>Phone +49(0) 89-3200-6673
>>>Fax +49(0) 89-3200-6898
>>>Mob +49(0)176-2946-7484
>>>
>>> http://www.dcs.ch
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>>
>>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>>(Support: mailto:support@arslist.org)
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>>(Support: mailto:support@arslist.org)
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>===================================================================
>>NOTICE - CONFIDENTIAL AND PRIVILEGED - This e-mail may contain
>>privileged and confidential information and is intended only for the
>>addressee named above. If you received this message in error,
>>please immediately notify the sender by return e-mail and delete the
>>original message; any distribution, copying or use of this e-mail
>>by you is strictly prohibited and may be unlawful.
>>
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>This posting was submitted via the Web
>>interface
>>
>>
>>
>>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>>(Support: mailto:support@arslist.org)
>>
>>
>>
>
>
>UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
>(Support: mailto:support@arslist.org)
>
>
>
>


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)