Home General Discussion

Datawarehouse MPSync / Pending Association

Dear All,

On our datawarehouse i am getting the following errors, any help on this please? The reporting is not working due to this.

Thanks

Daniel

Job Failed. JobName = Transform.Common; JobCategory = Transform; BatchId = 154067; WorkitemId = 41578521; ModuleName = TransformIncidentDim; ErrorDetails = <Errors><Error EventTime="2020-03-25T10:34:12.6320454Z">Invalid column name &apos;*** Example ****&apos;.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.</Error><Error EventTime="2020-03-25T10:34:13.8351173Z">Invalid column name &apos;*** Example ****&apos;.

Invalid column name &apos;*** Example ****&apos;.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.</Error><Error EventTime="2020-03-25T10:34:15.0070348Z">Invalid column name &apos;*** Example ****&apos;.

Invalid column name &apos;*** Example ****&apos;.

Invalid column name &apos;*** Example ****&apos;.

Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.</Error></Errors>;

Best Answer

  • CaterhamITSupportCaterhamITSupport Member IT Monkey ✭
    edited May 1 Accepted Answer

    I fixed this by rebuilding the data warehouse.

Answers

  • CaterhamITSupportCaterhamITSupport Member IT Monkey ✭
    edited May 1 Accepted Answer

    I fixed this by rebuilding the data warehouse.

Sign In or Register to comment.