Description |
STEPS
Update to 20.1.0729.1444
ISSUE
* *** Could not deploy package.
* Error SQL72014: .Net SqlClient Data Provider: Msg 209, Level 16, State 1, Procedure vyuRKCurrencyExposureSearch, Line 14 Ambiguous column name 'intCurrencyId'.
* Error SQL72045: Script execution error. The executed script:
* CREATE VIEW [dbo].[vyuRKCurrencyExposureSearch]
* AS
* SELECT intCurrencyExposureId,
* strBatchName,
* dtmBatchDate,
* intWeightUnit,
* ic.strUnitMeasure,
* e.intCompanyId,
* e.intCommodityId,
* c.strCommodityCode,
* dtmFutureClosingDate,
* intCurrencyId,
* cur.strCurrency,
* e.intConcurrencyId
* FROM tblRKCurrencyExposure AS e
* LEFT OUTER JOIN
* tblICCommodity AS c
* ON c.intCommodityId = e.intCommodityId
* LEFT OUTER JOIN
* tblICUnitMeasure AS ic
* ON ic.intUnitMeasureId = e.intWeightUnit
* LEFT OUTER JOIN
* tblSMCurrency AS cur
* ON cur.intCurrencyID = e.intCurrencyId;
{noformat}ACCEPTED{noformat}
Scripts should work in new company db
|