[ https://issues.jboss.org/browse/TEIID-5799?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5799: --------------------------------------- Hello Steven, the relevant line with the missing END statement is between line 527 and 528. I attached the vdb file here again. it is the ELSE IF path in the following sniped: {code:java} ELSE IF (new.fkDatabaseKey = 2) BEGIN IF(CHANGING.fkProfile AND CHANGING.AddedDateTime AND CHANGING.MealNumber AND CHANGING.AmountInG AND CHANGING.product_name AND CHANGING.energy_100g AND CHANGING.carbohydrates_100g AND CHANGING.proteins_100g AND CHANGING.fat_100g) BEGIN -- we first check if max amount of quickly added products for this user account is already reached vNumRecords = SELECT COUNT(*) FROM QuicklyAddedProducts WHERE fkProfile = new.fkProfile; IF(vNumRecords > 15000) BEGIN DECLARE EXCEPTION e = SQLEXCEPTION 'Limit for QuicklyAddedProducts user records reached' SQLSTATE '45000'; RAISE e; END -- create a new record in products, as this is this results in a common primary key -- for all product databases INSERT INTO Products(fkDatabaseKey) VALUES (new.fkDatabaseKey); -- retrieve generated key vIdProduct = cast(generated_key('idProduct') as long); -- first we create a new record for the quickly added product INSERT INTO QuicklyAddedProducts(fkProduct, fkProfile, product_name, energy_100g, carbohydrates_100g, proteins_100g, fat_100g) VALUES (vIdProduct, new.fkProfile, new.product_name, new.energy_100g, new.carbohydrates_100g, new.proteins_100g, new.fat_100g); -- finaly create the relevant Diary entry INSERT INTO Diary_SRC(fkProfile, AddedDateTime, fkProduct, MealNumber, AmountInG) VALUES (new.fkProfile, new.AddedDateTime, vIdProduct, new.MealNumber, new.AmountInG); -- set primary key vIdDiaryEntry = cast(generated_key('idDiaryEntry') as long); key.idDiaryEntry = vIdDiaryEntry; END ELSE IF (new.fkDatabaseKey = 3) {code} [^svc-vdb.ddl] -- This message was sent by Atlassian Jira (v7.12.1#712002)