DF-FA-27279- Database Fails Upgrading from 21.1 to 21.2 on Missing Default

Submitted by Stacie_Ray on
Symptom

When attempting to upgrade a database the following error is produce:

 ExecuteNonQuery failed for Database ‘NpsSqlSys’.

 An exception occurred while executing a Transect-SQL statement or batch

 

Column ‘tblPREarnCode.sW2Code’ has no default

Column ‘tblPRDeductCode.sW2Code’ has no default

Column ‘tblPRBeneCode.sW2Code’ has no default

Product Line

DF-FA-030445-Incorrect syntax error when entering Accounts Payable Manual Checks

Submitted by Stacie_Ray on
Symptom

When attempting to save an AP Manual Check entry the following message displays:  Incorrect syntax near ‘23’.  Unclosed quotation mark after the character string ‘ AND (sCodeIDF_0 = (SELECT sCodeIDf_0 FROM ##TempSegmentValues” OR (SELECT sCodeIDf_0 FROM

 

Incorrect Syntax ….

Product Line