Does anybody have experience of the following:

Trying to create a couple of new fields on one form, receive the
message:

Failure during SQL operation to the database ORA-01430: column being
added already exists in table. ARERR 552.

I have had the DBA check if these columns exist and they do not, an
export of the definitions does not contain the two fields i am trying
to add.

ARS 4.01
Oracle 8.03
HP-UX 10.20

Cheers,
Ian.


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

I ran into the same situation here. We had a table field on a form, and
when we went to add a new field, we got the same message. The problem was
the field's DB name and a column label were the same. We changed the column
label and were then able to add the field.

Regards,

Tom Worth

-----Original Message-----
From: Ian Burley [mailto:Ian_Burley@SEAGRAM.COM]
Sent: Tuesday, December 28, 1999 11:26 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Help! Remedy/Database error


All,

Does anybody have experience of the following:

Trying to create a couple of new fields on one form, receive the
message:

Failure during SQL operation to the database ORA-01430: column being
added already exists in table. ARERR 552.

I have had the DBA check if these columns exist and they do not, an
export of the definitions does not contain the two fields i am trying
to add.

ARS 4.01
Oracle 8.03
HP-UX 10.20

Cheers,
Ian.


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Remember that every text, line, box etc is yet another field. So I got rid of a few "cosmetic" fields.

An easy way to test is to remove just one field and see if you can then add one new one.

We are still ARS 3.01 server, HPUX 10.1 and Oracle 7.?? (Yeah I know they're all old).

Tom Griggs
Information Services Department
Bridgeport Hospital
267 Grant St., Bridgeport, CT 06610
203-384-3133 Fax at 203-384-4198
email: ztgrig@bpthosp.org


-----Original Message-----
From: Ian Burley [SMTP:Ian_Burley@SEAGRAM.COM]
Sent: Tuesday, December 28, 1999 11:26 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Help! Remedy/Database error

All,

Does anybody have experience of the following:

Trying to create a couple of new fields on one form, receive the
message:

Failure during SQL operation to the database ORA-01430: column being
added already exists in table. ARERR 552.

I have had the DBA check if these columns exist and they do not, an
export of the definitions does not contain the two fields i am trying
to add.

ARS 4.01
Oracle 8.03
HP-UX 10.20

Cheers,
Ian.


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

Trim fields (buttons, lines, etc) as well as display-only fields don't
count toward the 255 field limit...since they don't actually store any
data, they aren't considered columns by the database.

I've got 400+ fields on one of my schemas, but only 200 of these fields
are actual data fields (char, int, etc)



--- "Griggs, Thomas" wrote:
> This happened to me recently - I had hit the max (255 I believe) of
> fields
> that may be defined in a single schema.
>
> Remember that every text, line, box etc is yet another field. So I got
> rid
> of a few "cosmetic" fields.
>
> An easy way to test is to remove just one field and see if you can then
> add
> one new one.
>
> We are still ARS 3.01 server, HPUX 10.1 and Oracle 7.?? (Yeah I know
> they're
> all old).
>
> Tom Griggs
> Information Services Department
> Bridgeport Hospital
> 267 Grant St., Bridgeport, CT 06610
> 203-384-3133 Fax at 203-384-4198
> email: ztgrig@bpthosp.org
>
>
> > -----Original Message-----
> > From: Ian Burley [SMTP:Ian_Burley@SEAGRAM.COM]
> > Sent: Tuesday, December 28, 1999 11:26 AM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Help! Remedy/Database error
> >
> > All,
> >
> > Does anybody have experience of the following:
> >
> > Trying to create a couple of new fields on one form, receive the
> > message:
> >
> > Failure during SQL operation to the database ORA-01430: column
> being
> > added already exists in table. ARERR 552.
> >
> > I have had the DBA check if these columns exist and they do not,
> an
> > export of the definitions does not contain the two fields i am
> trying
> > to add.
> >
> > ARS 4.01
> > Oracle 8.03
> > HP-UX 10.20
> >
> > Cheers,
> > Ian.
> >
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
>

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://messenger.yahoo.com


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

I wonder if my experience could be related to ARS 3.x (3.0.1 in my case ?). Or perhaps the facts are not what I guessed them to be.

Regards, Tom

-----Original Message-----
From: Erick Field [SMTP:erickfield@YAHOO.COM]
Sent: Wednesday, December 29, 1999 8:45 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Help! Remedy/Database error

Hi Tom,

Trim fields (buttons, lines, etc) as well as display-only fields don't
count toward the 255 field limit...since they don't actually store any
data, they aren't considered columns by the database.

I've got 400+ fields on one of my schemas, but only 200 of these fields
are actual data fields (char, int, etc)



--- "Griggs, Thomas" wrote:
> This happened to me recently - I had hit the max (255 I believe) of
> fields
> that may be defined in a single schema.
>
> Remember that every text, line, box etc is yet another field. So I got
> rid
> of a few "cosmetic" fields.
>
> An easy way to test is to remove just one field and see if you can then
> add
> one new one.
>
> We are still ARS 3.01 server, HPUX 10.1 and Oracle 7.?? (Yeah I know
> they're
> all old).
>
> Tom Griggs
> Information Services Department
> Bridgeport Hospital
> 267 Grant St., Bridgeport, CT 06610
> 203-384-3133 Fax at 203-384-4198
> email: ztgrig@bpthosp.org
>
>
> > -----Original Message-----
> > From: Ian Burley [SMTP:Ian_Burley@SEAGRAM.COM]
> > Sent: Tuesday, December 28, 1999 11:26 AM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Help! Remedy/Database error
> >
> > All,
> >
> > Does anybody have experience of the following:
> >
> > Trying to create a couple of new fields on one form, receive the
> > message:
> >
> > Failure during SQL operation to the database ORA-01430: column
> being
> > added already exists in table. ARERR 552.
> >
> > I have had the DBA check if these columns exist and they do not,
> an
> > export of the definitions does not contain the two fields i am
> trying
> > to add.
> >
> > ARS 4.01
> > Oracle 8.03
> > HP-UX 10.20
> >
> > Cheers,
> > Ian.
> >
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
>

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://messenger.yahoo.com


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

The info I provided is based on v3.2 (and I'm assuming it would also hold
true for v4.0)

If you'd like to find out how many data vs trim fields you have:

1) data fields

select count(*) from field where schemaid = xx and datatype < 31

- where xx is the Schema Id (aka table number) that Remedy associates with
your schema. If you don't know what it is, you can use:

select schemaid from arschema where name = 'The-SchemaName'


2. trim fields

select count(*) from field where schemaid = xx and datatype >= 31




--- "Griggs, Thomas" wrote:
> Hi Erick
>
> I wonder if my experience could be related to ARS 3.x (3.0.1 in my case
> ?).
> Or perhaps the facts are not what I guessed them to be.
>
> Regards, Tom
>
> > -----Original Message-----
> > From: Erick Field [SMTP:erickfield@YAHOO.COM]
> > Sent: Wednesday, December 29, 1999 8:45 AM
> > To: ARSLIST@LISTSERV.VISTAIT.COM
> > Subject: Re: Help! Remedy/Database error
> >
> > Hi Tom,
> >
> > Trim fields (buttons, lines, etc) as well as display-only fields don't
> > count toward the 255 field limit...since they don't actually store any
> > data, they aren't considered columns by the database.
> >
> > I've got 400+ fields on one of my schemas, but only 200 of these
> fields
> > are actual data fields (char, int, etc)
> >
> >
> >
> > --- "Griggs, Thomas" wrote:
> > > This happened to me recently - I had hit the max (255 I believe) of
> > > fields
> > > that may be defined in a single schema.
> > >
> > > Remember that every text, line, box etc is yet another field. So I
> got
> > > rid
> > > of a few "cosmetic" fields.
> > >
> > > An easy way to test is to remove just one field and see if you can
> then
> > > add
> > > one new one.
> > >
> > > We are still ARS 3.01 server, HPUX 10.1 and Oracle 7.?? (Yeah I know
> > > they're
> > > all old).
> > >
> > > Tom Griggs
> > > Information Services Department
> > > Bridgeport Hospital
> > > 267 Grant St., Bridgeport, CT 06610
> > > 203-384-3133 Fax at 203-384-4198
> > > email: ztgrig@bpthosp.org
> > >
> > >
> > > > -----Original Message-----
> > > > From: Ian Burley [SMTP:Ian_Burley@SEAGRAM.COM]
> > > > Sent: Tuesday, December 28, 1999 11:26 AM
> > > > To: ARSLIST@LISTSERV.VISTAIT.COM
> > > > Subject: Help! Remedy/Database error
> > > >
> > > > All,
> > > >
> > > > Does anybody have experience of the following:
> > > >
> > > > Trying to create a couple of new fields on one form, receive
> the
> > > > message:
> > > >
> > > > Failure during SQL operation to the database ORA-01430:
> column
> > > being
> > > > added already exists in table. ARERR 552.
> > > >
> > > > I have had the DBA check if these columns exist and they do
> not,
> > > an
> > > > export of the definitions does not contain the two fields i
> am
> > > trying
> > > > to add.
> > > >
> > > > ARS 4.01
> > > > Oracle 8.03
> > > > HP-UX 10.20
> > > >
> > > > Cheers,
> > > > Ian.
> > > >
> > > >
> > > > To Unsubscribe send e-mail to:
> > > > body of text is: unsubscribe arslist
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Talk to your friends online with Yahoo! Messenger.
> > http://messenger.yahoo.com
> >
> >
> > To Unsubscribe send e-mail to:
> > body of text is: unsubscribe arslist
>

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://messenger.yahoo.com


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist

I just had this problem yesterday, My problem was a field not in the view?
I happened to look around and found in the menus fields in view and sure
enough the duplicate field was in there. I put it in the view and then
deleted it.
good luck and have a happy Y2K

"Ian Burley" wrote in message
news:<9A0D3C1DFCBFD111AC3700A0C989996404B1DB@cogniza.com>...
> All,
>
> Does anybody have experience of the following:
>
> Trying to create a couple of new fields on one form, receive the
> message:
>
> Failure during SQL operation to the database ORA-01430: column being
> added already exists in table. ARERR 552.
>
> I have had the DBA check if these columns exist and they do not, an
> export of the definitions does not contain the two fields i am trying
> to add.
>
> ARS 4.01
> Oracle 8.03
> HP-UX 10.20
>
> Cheers,
> Ian.
>
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist