ORA-01430: Column being added already exists in table.

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System Server



    PROBLEM:

    I have custom form where, whenever I try to add a new field to the form then save I receive an error. Failure during SQL operation to the database ORA-01430 Column being added already exists in table. 

    Also when we copy same field ID from working form and paste into non working field it shows field is already 


    SOLUTION:

    We need to run below sql commands to update the numfield count.

    1)select schemaid from arschema where name = 'FORM NAME'; 
    2) select count(*) from field where schemaid = '<OUTPUT OF 1ST COMMAND>'; 
    3) select numfields from arschema where schemaid = '<OUTPUT OF 1ST COMMAND>'; 

    then we need to run update command to correct the mismatch count.

    For example:-- 

    1) select schemaid from arschema where name = 'CID:Ticket';         output: 627
    2)select count(*) from field where schemaid = '627';                         output: 429 
    3) select numfields from arschema where schemaid = '627';             output: 423 

    We need to update numfields matching with field. 

    4) update arschema set numfields = 429 where schemaid = '627'; 
    5) commit; 

    Then restart ARServer service to take this into effect.
     

    NOTE: This article is also available in Spanish, use the link below or search by Article Number 000165065. / NOTA: Este artículo también est disponible en Español, usar el siguiente enlace o buscar por el Número de Artículo 000165065.

      

    ORA-01430: La columna que se est agregando ya existe en la tabla.

     


    Article Number:

    000130061


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles