IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

Administration Oracle Discussion :

[10.2.0.4] OCI Error : ORA-14400: inserted partition key does not map to any partition


Sujet :

Administration Oracle

  1. #1
    Membre régulier
    Homme Profil pro
    Administrateur de base de données
    Inscrit en
    Août 2003
    Messages
    148
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Âge : 60
    Localisation : Etats-Unis

    Informations professionnelles :
    Activité : Administrateur de base de données
    Secteur : Conseil

    Informations forums :
    Inscription : Août 2003
    Messages : 148
    Points : 118
    Points
    118
    Par défaut [10.2.0.4] OCI Error : ORA-14400: inserted partition key does not map to any partition
    Bonjour,

    Nous avons une erreur ci-dessous lors de l'exécution d'une application sur la base de données oracle 10g, quelqu'un a une idée sur la cause exacte de ce problème et comment le résoudre :
    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    [20100719 - 16:39:50] INFO: Restoring messages ...
    [ERROR] OCIStmtExecute failed for query [BEGIN
    ldProcessMesg( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91);
    END;] :
     ** OCI Error : ORA-14400: inserted partition key does not map to any partition
    ORA-06512: at "SIDE.LDPROCESSMESG", line 300
    ORA-06512: at line 2
     
    [20100719 - 16:39:50] ERROR: (1/3) Execute query on rMesg : record 0 Error : ORA-14400: inserted partition key does not map to any partition
    ORA-06512: at "SIDE.LDPROCESSMESG", line 300
    ORA-06512: at line 2
     
     
    [20100719 - 16:39:50] ERROR: (2/3) Execute query on rMesg : Header
    "47747","mesg_s_umid","mesg_validation_requested","mesg_validation_passed","mesg_class","mesg_related_s_umid","mesg_is_text_readonly","mesg_is_delete_inhibited","mesg_is_text_modified","mesg_is_partial","mesg_status","mesg_crea_appl_serv_name","mesg_crea_mpfn_name","mesg_crea_rp_name","mesg_crea_oper_nickname","mesg_crea_date_time","mesg_mod_oper_nickname","mesg_mod_date_time","mesg_verf_oper_nickname","mesg_data_last","mesg_token",":E:mesg_appl_sender_reference",":E:mesg_batch_reference",":E:mesg_cas_sender_reference",":E:mesg_cas_target_rp_name",":E:mesg_ccy_amount",":E:mesg_copy_service_id",":E:mesg_data_keyword1",":E:mesg_data_keyword2",":E:mesg_data_keyword3",":E:mesg_delv_overdue_warn_req",":E:mesg_fin_ccy_amount",":E:mesg_fin_value_date",":E:mesg_frmt_name",":E:mesg_identifier",":E:mesg_is_live",":E:mesg_is_retrieved",":E:mesg_mesg_user_group",":E:mesg_nature",":E:mesg_network_appl_ind",":E:mesg_network_delv_notif_req",":E:mesg_network_obso_period",":E:mesg_network_priority",":E:mesg_payload_type",":E:mesg_possible_dup_creation",":E:mesg_receiver_alia_name",":E:mesg_receiver_swift_address",":E:mesg_recovery_accept_info",":E:mesg_rel_trn_ref",":E:mesg_release_info",":E:mesg_request_type",":E:mesg_requestor_dn",":E:mesg_security_iapp_name",":E:mesg_security_required",":E:mesg_sender_X1",":E:mesg_sender_X2",":E:mesg_sender_X3",":E:mesg_sender_X4",":E:mesg_sender_branch_info",":E:mesg_sender_city_name",":E:mesg_sender_corr_type",":E:mesg_sender_ctry_code",":E:mesg_sender_ctry_name",":E:mesg_sender_institution_name",":E:mesg_sender_location",":E:mesg_sender_swift_address",":E:mesg_service",":E:mesg_signature_digest_reference",":E:mesg_signature_digest_value",":E:mesg_sub_format",":E:mesg_syntax_table_ver",":E:mesg_template_name",":E:mesg_trn_ref",":E:mesg_type",":E:mesg_use_pki_signature",":E:mesg_user_issued_as_pde",":E:mesg_user_priority_code",":E:mesg_user_reference_text",":E:mesg_uumid",":E:mesg_uumid_suffix",":E:mesg_xml_query_ref1",":E:mesg_xml_query_ref2",":E:mesg_xml_query_ref3",":E:mesg_zz41_is_possible_dup",
     
     
    [20100719 - 16:39:50] ERROR: (3/3) Execute query on rMesg : Data
    "63657","33D59260FFFEE160","VAL_MINIMUM","VAL_MINIMUM","MESG_NORMAL","","FALSE","FALSE","FALSE","FALSE","COMPLETED","SWIFT Support","_SS_alarm_creation","_SS_alarm_creation","SYSTEM","29/06/10 23:58:56","SYSTEM","29/06/10 23:58:56","","0","12401","","","","","","","","","","FALSE","","","Swift","fin.999","FALSE","","","TEXT_MSG","FIN","FALSE","","PRI_NORMAL","","","","SOGEGB22XGAP","","","","","","","","ZYIBGB20XXX","","","","","","CORR_TYPE_INSTITUTION","","","","","ZYIBGB20AXXX","swift.fin","","","INPUT","0905","","SAAS6063","999","","","","","ISOGEGB22GAP999SAAS6063","73375","","","","TRUE",
    Cordialement.

  2. #2
    Modérateur
    Avatar de Waldar
    Homme Profil pro
    Customer Success Manager @Vertica
    Inscrit en
    Septembre 2008
    Messages
    8 452
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Âge : 46
    Localisation : France, Val de Marne (Île de France)

    Informations professionnelles :
    Activité : Customer Success Manager @Vertica
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Septembre 2008
    Messages : 8 452
    Points : 17 820
    Points
    17 820
    Par défaut
    Il faudrait la requête qui essaie de faire l'insert, et le script de création de la table cible (avec ses partitions).

+ Répondre à la discussion
Cette discussion est résolue.

Discussions similaires

  1. ORA-27101: shared memory realm does not exist
    Par Mella dans le forum Connexions aux bases de données
    Réponses: 21
    Dernier message: 13/01/2013, 15h06
  2. Réponses: 1
    Dernier message: 29/05/2009, 14h23
  3. ORA-00942: table or view does not exist
    Par xoco dans le forum Langage SQL
    Réponses: 9
    Dernier message: 12/01/2009, 20h11
  4. Réponses: 0
    Dernier message: 30/12/2008, 11h19
  5. ORA-27101: shared memory realm does not exist.
    Par mogweys dans le forum Oracle
    Réponses: 4
    Dernier message: 20/06/2006, 12h56

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo