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)