synchronization de termenologie

kiki232
2006-11-03
2013-05-02
  • kiki232

    kiki232 - 2006-11-03

    bonjour,
    j'essaye de traduire Compiere,lors de l'import y a pas de probléme sauf que une fois je commence le processus de synchronization de termenologie le probleme se pose:

    ""Le traitement a échoué: Reading parameters:02292:integrity constraint
    (compiere.AD_Column_Field)violated-child record found-).
    """"""

    merci de me dire comment corriger ce probleme.

     
    • Vincent Harcq

      Vincent Harcq - 2006-11-16

      Lancer les cripts ci dessous

      Ensuite recommence

      Il faut toujours un lien 1:1 entre le ColumnName d'une Column et celle de l'Element correspondant

      update ad_column cc set cc.ad_element_id = (select e.ad_element_id from ad_element e where e.columnname = cc.columnname)
      where cc.ad_element_id <> (select e.ad_element_id from ad_element e where e.columnname = cc.columnname);

      update ad_column cc set cc.columnname = (select ee.columnname from ad_element ee where ee.AD_ELEMENT_ID = cc.ad_element_id)
      where ad_column_id in
      (SELECT ad_column_id FROM AD_COLUMN c
      inner join ad_table t on t.ad_table_id = c.ad_table_id
      WHERE
      (c.COLUMNNAME <> (select columnname from ad_element e where e.ad_element_id = c.ad_element_id))
      );

      update ad_column cc set cc.name = (select ee.name from ad_element ee where ee.AD_ELEMENT_ID = cc.ad_element_id)
      where ad_column_id in
      (SELECT ad_column_id FROM AD_COLUMN c
      inner join ad_table t on t.ad_table_id = c.ad_table_id
      WHERE
      (c.NAME <> (select NAME from ad_element e where e.ad_element_id = c.ad_element_id))
      );

       

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks