Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-00947: not enough values; or ORA-00913: too many values **MASTER RECORD**

    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Problem Symptoms:
    You see these errors in trying to create a record in ALEPH:
    Oracle error: io_znn_write
    ORA-00947: not enough values

    Or
    ORA-00913: too many values

    Cause:
    The 00947 message indicates that the record which you are trying to send to Oracle lacks one or more of the columns which was included at the time the table was created.
    The 00913 message indicates that the record which you are trying to send to Oracle includes more columns than were included at the time the table was created.

    Diagnosis:  Confirm that util f/4 for the table shows the error.  Also, trying updating the record by some other method.  (For example, if the error occurred in  a batch job, then try reproducing the problem in the GUI.)

    Assuming the problem occurs in these cases as well, then proceed to the Resolution.  If not, the situation is more complicated.  Contact Ex Libris Aleph Support.  

        
    Resolution:
    Either error indicates that a change has occurred to the table in the ./alephm/sql_tab between the time that the table was last defined to Oracle and now.
    Compare the columns in the ./sql_tab/znn_create.sql to the columns you see in the SQL> desc znn. In any case this is a system problem; it should not happen. If the table is empty, then you may be able to do util a/17/1 on the table to recreate it with correct values.  Or, if the data in the table doesn't need to be preserved, you could do util a/17/1 even though there *is* data in the table.

     

    If the table getting the error is an optional table, which you don't really use, you may able to drop the table or turn off writing to it.  For example, in the case of the Z30H table you could change the xxx50 tab100 to:

    CREATE-Z30H=N

     

     


    • Article last edited: 10/8/2013