#19992 - 12/09/99 01:29 PM
Re: Help! Incoherence Between Remedy View and Oracle Table (I thi nk ).
|
Stealth Member
Registered: 06/12/01
Posts: 39
|
not be very convenient for you.
I can't offer any ideas on why this is happening, but I have an idea for
trying to eliminate the problematic field #.
Perhaps if you export that form and code, and then re-import it, the
offending field will disappear. Before you re-import, you may want to check
the .def file to see if that field # exists, just for kicks and giggles.
Hope this helps...
Best Regards,
Ann Zbylut
Remedy Programmer Analyst
SMS Technical Services, Sutter Health
ZbylutA@sutterhealth.org
http://remedyweb
> -----Original Message-----
> From: Tom Grosman [SMTP:grosman@AONIX.FR]
> Sent: Thursday, December 09, 1999 9:22 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Help! Incoherence Between Remedy View and Oracle Table (I
> think ).
>
> I have a form and when I try to add a new field, I get an error message
> "Failure during SQL operation, column being added already exists in
> Table (ORA-01430)"
>
> The SQL log is attached. I believe the relavent lines are-
> ALTER TABLE T5 ADD (C536871022 varchar(255) NULL)
> *** ERROR *** ORA-01430: column being added already exists in table
> (Oracle -1430)
>
> Using the HTML ARSERVER cross reference tool, I see that the field
> 536871022 DOES NOT exist.
>
> ...
> AREV_STRS_INC 536871007 char Optional
> Old CIS Key [CIS] 536871008 char Optional
> EnableContactInfo 536871009 char Display only
> First Name (CI)2 536871010 char Display only
> Company2 536871011 char Display only
> Phone Number (CI)2 536871012 char Display only
> FaxNumber (CI)2 536871013 char Display only
> Email (CI)2 536871014 char Display only
> Last Name (CI)2 536871015 cha Display only
> Site Key (Sit) 536871023 char Display only
> Box2 536871026 trim Display only
> Family 536871027 char Required
> Platform 536871028 char Optional
> Product 536871029 char Optional
> Type 536871030 char Optional
> Product Name 536871031 char Optional
> ...
>
>
> In Oracle Schema Manager under Schema Objects-
> ARS->Views->ARADMIN->CUSTOMER_ISSUE I see that the column C536871022
> DOES NOT exist (If I am correctly interpreting the information.)
> SELECT
> T5.C1,C2,C3,C4,C5,C6,C7,C8,C14,C536870912,C536870913,C536870914,C536870915
> ,C536870916,C536870917,C536870919,C536870920,C536870921,C536870922,C536870
> 923,C536870925,C536870928,C536870929,C536870930,C536870931,C536870933,C536
> 870934,C536870936,C536870937,C536870938,C536870939,C536870940,C536870941,C
> 536870942,C536870943,C536870944,C536870945,C536870946,C536870959,C53687096
> 1,C536870963,C536870964,C536870965,C536870966,C536870968,C536870969,C53687
> 0970,C536870975,C536870990,C536870991,C536870992,C536870993,C536870994,C53
> 6870995,C536870996,C536870997,C536870998,C536870999,C536871000,C536871001,
> C536871002,C536871003,C536871004,C536871005,C536871006,C536871007,C5368710
> 08,C536871027,C536871028,C536871029,C536871030,C536871031,C536871032,C5368
> 71034
> FROM T5,T5C536870929,T5C536870970 WHERE T5.C1 = T5C536870929.entryId AND
> T5.C1 = T5C536870970.entryId
>
> In Oracle Schema Manager under Schema Objects-
> ARS->Tables->T5->Indexes-> I see that the Column C536871022 DOES exist
> under "Table Columns".
>
> What I think is happening is that Remedy has picked a name it believes
> is available based on either the view or an internal Remedy table (which
> I deduce must exist by the presence of the display only fields which
> don't show up in the Oracle Table/View). It does not check the Oracle
> table. Somehow, a field in a Remedy table or Oracle view got deleted
> without deleting the column in the underlying Oracle table. This must
> have been introduced by remedy, since I've never touched the ORACLE
> table or view directly. Using SQL+ I verified that all rows of that
> column are NULL.
>
> Questions
>
> 1) Have you seen this error before?
> 2) Is my analysis correct? (I'm scheduled for Oracle training Q1 2000.
> It will be much welcomed).
> 3) How do I recover? Can I manually delete the Oracle Column(s) that are
> not in the view without disastrous side effects?
>
> Thanks for your help.
>
> Tom Grosman << File: arsql.log.bak >>
To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist
|
|
Top
|
|
|
|
|
|
#19993 - 12/09/80 01:59 PM
Re: Help! Incoherence Between Remedy View and Oracle Table (I thi nk ).
[Re: speralta]
|
Stealth Member
Registered: 06/12/01
Posts: 37
|
You might want to check to see if there is a H table associated with this
form and there you might find that this column already exist there and you
will then have to remove the H table and import the form again creating the
T table and all associated tables.
Corye Clarke
CSC Technologies Group, Inc.
Senior Remedy Consultant
clarkec@csctechnologies.com
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Zbylut, Ann
Sent: Thursday, December 09, 1999 2:29 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Help! Incoherence Between Remedy View and Oracle Table (I
thi nk ).
I don't know if this is a development or production server, so my answer may
not be very convenient for you.
I can't offer any ideas on why this is happening, but I have an idea for
trying to eliminate the problematic field #.
Perhaps if you export that form and code, and then re-import it, the
offending field will disappear. Before you re-import, you may want to check
the .def file to see if that field # exists, just for kicks and giggles.
Hope this helps...
Best Regards,
Ann Zbylut
Remedy Programmer Analyst
SMS Technical Services, Sutter Health
ZbylutA@sutterhealth.org
http://remedyweb
> -----Original Message-----
> From: Tom Grosman [SMTP:grosman@AONIX.FR]
> Sent: Thursday, December 09, 1999 9:22 AM
> To: ARSLIST@LISTSERV.VISTAIT.COM
> Subject: Help! Incoherence Between Remedy View and Oracle Table (I
> think ).
>
> I have a form and when I try to add a new field, I get an error message
> "Failure during SQL operation, column being added already exists in
> Table (ORA-01430)"
>
> The SQL log is attached. I believe the relavent lines are-
> ALTER TABLE T5 ADD (C536871022 varchar(255) NULL)
> *** ERROR *** ORA-01430: column being added already exists in table
> (Oracle -1430)
>
> Using the HTML ARSERVER cross reference tool, I see that the field
> 536871022 DOES NOT exist.
>
> ...
> AREV_STRS_INC 536871007 char Optional
> Old CIS Key [CIS] 536871008 char Optional
> EnableContactInfo 536871009 char Display only
> First Name (CI)2 536871010 char Display only
> Company2 536871011 char Display only
> Phone Number (CI)2 536871012 char Display only
> FaxNumber (CI)2 536871013 char Display only
> Email (CI)2 536871014 char Display only
> Last Name (CI)2 536871015 cha Display only
> Site Key (Sit) 536871023 char Display only
> Box2 536871026 trim Display only
> Family 536871027 char Required
> Platform 536871028 char Optional
> Product 536871029 char Optional
> Type 536871030 char Optional
> Product Name 536871031 char Optional
> ...
>
>
> In Oracle Schema Manager under Schema Objects-
> ARS->Views->ARADMIN->CUSTOMER_ISSUE I see that the column C536871022
> DOES NOT exist (If I am correctly interpreting the information.)
> SELECT
> T5.C1,C2,C3,C4,C5,C6,C7,C8,C14,C536870912,C536870913,C536870914,C536870915
> ,C536870916,C536870917,C536870919,C536870920,C536870921,C536870922,C536870
> 923,C536870925,C536870928,C536870929,C536870930,C536870931,C536870933,C536
> 870934,C536870936,C536870937,C536870938,C536870939,C536870940,C536870941,C
> 536870942,C536870943,C536870944,C536870945,C536870946,C536870959,C53687096
> 1,C536870963,C536870964,C536870965,C536870966,C536870968,C536870969,C53687
> 0970,C536870975,C536870990,C536870991,C536870992,C536870993,C536870994,C53
> 6870995,C536870996,C536870997,C536870998,C536870999,C536871000,C536871001,
> C536871002,C536871003,C536871004,C536871005,C536871006,C536871007,C5368710
> 08,C536871027,C536871028,C536871029,C536871030,C536871031,C536871032,C5368
> 71034
> FROM T5,T5C536870929,T5C536870970 WHERE T5.C1 = T5C536870929.entryId AND
> T5.C1 = T5C536870970.entryId
>
> In Oracle Schema Manager under Schema Objects-
> ARS->Tables->T5->Indexes-> I see that the Column C536871022 DOES exist
> under "Table Columns".
>
> What I think is happening is that Remedy has picked a name it believes
> is available based on either the view or an internal Remedy table (which
> I deduce must exist by the presence of the display only fields which
> don't show up in the Oracle Table/View). It does not check the Oracle
> table. Somehow, a field in a Remedy table or Oracle view got deleted
> without deleting the column in the underlying Oracle table. This must
> have been introduced by remedy, since I've never touched the ORACLE
> table or view directly. Using SQL+ I verified that all rows of that
> column are NULL.
>
> Questions
>
> 1) Have you seen this error before?
> 2) Is my analysis correct? (I'm scheduled for Oracle training Q1 2000.
> It will be much welcomed).
> 3) How do I recover? Can I manually delete the Oracle Column(s) that are
> not in the view without disastrous side effects?
>
> Thanks for your help.
>
> Tom Grosman << File: arsql.log.bak >>
To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist
To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist
|
|
Top
|
|
|
|
|
|
|
Previous Topic
Index