error en linea 124 script: 012_activity_translate.sql

10 views
Skip to first unread message

Felix Bolivar

unread,
Apr 9, 2013, 9:20:41 PM4/9/13
to adempier...@googlegroups.com
Corriendo los scripts de adempiere-lve-361/migration_LVE_361/LVE_361/361/postgresql/012_activity_translate.sql
me arroja error column ad_printformatitem_trl.name does not exist

Corregi el script de la siguiente forma:
UPDATE adempiere.AD_PRINTFORMATITEM_TRL 
SET printName = (SELECT e.Name FROM adempiere.AD_ELEMENT_TRL e, adempiere.AD_COLUMN c, adempiere.AD_PRINTFORMATITEM p WHERE e.AD_LANGUAGE=AD_PRINTFORMATITEM_TRL.AD_LANGUAGE AND e.AD_Element_ID=c.AD_Element_ID AND c.AD_Column_ID=p.AD_Column_ID AND p.AD_PrintFormatItem_ID=AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID),
 Updated = CURRENT_TIMESTAMP WHERE EXISTS (SELECT 1 FROM adempiere.AD_PRINTFORMATITEM p, adempiere.AD_ELEMENT_TRL e, adempiere.AD_COLUMN c
  WHERE AD_PRINTFORMATITEM_TRL.AD_PrintFormatItem_ID=p.AD_PrintFormatItem_ID AND p.AD_Column_ID=c.AD_Column_ID AND c.AD_Element_ID=e.AD_Element_ID AND c.AD_Process_ID IS NULL AND AD_PRINTFORMATITEM_TRL.AD_LANGUAGE=e.AD_LANGUAGE AND p.IsCentrallyMaintained='Y' AND p.IsActive='Y' AND (AD_PRINTFORMATITEM_TRL.printName <> e.Name))
;

Saludos

Reply all
Reply to author
Forward
0 new messages