DF-M17249-Error Code 264 inserting allocation after adding Source (giftsource) field to Allocation Insert screen template
INSERT INTO gifts_full (giftprocdt, gifteffdat, giftbatch, gifttender, giftsolic, giftcurr, giftanon, giftpotflg, gifthnrmkr, giftchckno, giftsecure, giftsource, gifttype, giftaba, giftdepost, giftrevoke, giftfrnamt, giftbnkact, giftbnkaty, giftacctgp, giftexrate, giftsumkey, giftsec1, giftsec2,giftrest, gift8020, giftamount, giftcamp, giftcampyr, giftclass1, giftclass2, giftcomm, giftsource, giftallkey, giftid) SELECT giftprocdt, gifteffdat, giftbatch, gifttender, giftsolic, giftcurr, giftanon, giftpotflg, gifthnrmkr, giftchckno, giftsecure, giftsource, gifttype, giftaba, giftdepost, giftrevoke, giftfrnamt, giftbnkact, giftbnkaty, giftacctgp, giftexrate, giftsumkey, giftsec1, giftsec2,'sm1', 'N', 60.00, 'c ', '2014', ' ', ' ', '', 'blast ', '2605438644', '0000000264' FROM gifts_full WHERE giftkey = 2605438644
SQL_ERROR
[Microsoft][ODBC SQL Server Driver][SQL Server] The column name 'giftsource' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'giftsource' may appear twice in the view definition.
EN-Relationship row does not get the Begin / End Date that was specified in the Employment row
DF-M16675-SoftEdit user’s insert via default generates 5004 - No Name Found for ID 5004
Manually accepting a SoftEdit user’s insert via default generates 5004 - No Name Found for ID 5004 in the section header and generates the following error when accepting the pending records:
Error Message -- Insert
INSERT INTO attribute_full(attrstrt, attrstop, attrsource, attrdescr1, attrdescr2, attrpositn, attrcomm, attrtypenm, attrtype, attrlnkfil, attrdate1, attrdate2, attrlook1, attrlook2, attrlook3, attrtext, attrdate3, attrdate4, attrdate5, attrdate6, attrdate7, attrdate8, attrdate9, attrdte10, attrdte11, attrdte12, attrtxt1, attrtxt2, attrtxt3, attrtxt4, attrtxt5, attrlook4, attrlook5, attrlook6, attradesrc, attrid) VALUES ('Jun 29, 2012', null, 'self ', ' ', ' ', '', 'test soft edit users insert via default', 'Cancer Research', 'can', '', null, null, ' ', ' ', ' ', '', null, null, null, null, null, null, null, null, null, null, '', '', '', '', '', ' ', ' ', ' ', 'Soft Edit', '5004')
SQL_ERROR
[Microsoft][ODBC SQL Server Driver][SQL Server] The INSERT statement conflicted with the FOREIGN KEY constraint "fk_attrid". The conflict occurred in database "millsample", table "dbo.corebio", column 'coreid'.
Error Code 547