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 = Invalid column name '*** Example ****'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. Invalid column name '*** Example ****'. Invalid column name '*** Example ****'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. Invalid column name '*** Example ****'. Invalid column name '*** Example ****'. Invalid column name '*** Example ****'. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. ;

I fixed this by rebuilding the data warehouse.

Datawarehouse MPSync / Pending Association

CaterhamITSupport Member Advanced IT Monkey ✭✭✭

April 2020 in General Discussion

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 '*** Example ****'.

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 '*** Example ****'.

Invalid column name '*** Example ****'.

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 '*** Example ****'.

Invalid column name '*** Example ****'.

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

Best Answer

CaterhamITSupport Member Advanced IT Monkey ✭✭✭

May 2020 edited May 2020 Answer ✓

I fixed this by rebuilding the data warehouse.

0

Answers

CaterhamITSupport Member Advanced IT Monkey ✭✭✭

May 2020 edited May 2020 Answer ✓

I fixed this by rebuilding the data warehouse.

0

Datawarehouse MPSync / Pending Association

Best Answer

Answers

CIRESON COMMUNITY WEB SITE