Forum Stats

  • 3,782,436 Users
  • 2,254,645 Discussions
  • 7,880,078 Comments

Discussions

ORA-12801: error signaled in parallel query server P006

orabits
orabits Member Posts: 202
edited Oct 22, 2008 5:32PM in General Database Discussions
Hi

I'm using Oracle9i.
i got this error when i'm trying to execute the procedure through our front-end application. what this could be?

ORA-12801: error signaled in parallel query server P006
ORA-01502: index 'INSIGHT.DAY_ACT_IDX_04' or

any idea, i have no idea what means this.

please i'll appreciate your help.
Tagged:

Comments

  • 247514
    247514 Member Posts: 10,875 Bronze Trophy
    edited Jun 19, 2008 1:17PM
    The problem is from ORA-01502
    Follow the action to rebuild index 'INSIGHT.DAY_ACT_IDX_04'
    ORA-01502: index "string.string" or partition of such 
    index is in unusable state

    Cause: An attempt has been made to access an index or
    index partition that has been marked unusable by a
    direct load or by a DDL operation

    Action: DROP the specified index, or REBUILD the
    specified index, or REBUILD the unusable index partition
  • 9904
    9904 Member Posts: 33
    easy lookup of documentation

    http://download.oracle.com/docs/cd/B28359_01/server.111/b28278/e1500.htm#sthref802


    ORA-01502: index 'string.string' or partition of such index is in unusable state
    Cause: An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation
    Action: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition
  • 548692
    548692 Member Posts: 2
    Hi,

    I wrote the code to uploada to a flat file (.txt format) by using UTL_FILE package in PLSQL. In that code I redirected errors to a error file.
    It is uploading the correct data to the file, and also generating a error file with the below error message.

    Upload Type: cat Error Code: -12801 System Message: 10/21/2008 13:19:39 Oracle Message: ORA-12801: error signaled in parallel query server P026, ins.

    here the word 'cat' is part of my file name passing through exception part in PLSQL code.

    Below is exception part of my PLSQL program:
    EXCEPTION
    WHEN VALUE_ERROR
    THEN
    p_write_to_upload_log ('cat', TO_CHAR (SQLCODE), 'Value error reading Retail upload', SQLERRM);
    WHEN UTL_FILE.invalid_filehandle
    THEN
    p_write_to_upload_log ('cat', TO_CHAR (SQLCODE), 'Write error on upload file', SQLERRM);
    WHEN UTL_FILE.invalid_operation
    THEN
    p_write_to_upload_log ('cat', TO_CHAR (SQLCODE), 'Upload file is not open', SQLERRM);
    WHEN UTL_FILE.read_error
    THEN
    p_write_to_upload_log ('cat', TO_CHAR (SQLCODE), 'OS error during file read', SQLERRM);
    WHEN OTHERS
    THEN
    p_write_to_upload_log ('cat', TO_CHAR (SQLCODE), TO_CHAR (SYSDATE, 'MM/DD/RRRR HH24:MI:SS'), SQLERRM);

    END p_cat_upload;

    Please let me know if you need any more information on this.

    Appriciate your help in resolving this error message.

    Thanks and Regards
    Vedaprakash N
This discussion has been closed.