Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

MDSERR310029

March 25, 2018 by neal Leave a Comment

MDSERR310029|The status of the specified batch is not valid.

This error occurs when using the entity-based staging process (leaf tables). If multiple entries of the same BatchTag value are executed concurrently, this error can appear. It can happen in the same entity or different entities or models.

The best solution I’ve found is to update mdm.tblStgBatch and set the status_id for the BatchTag to completed. You can then update the BatchTag name in the leaf and reset the ImportStatus_ID back to 0 and reprocess the batch.

An alternative is to append a timestamp to the BatchTag to make it unique. That should keep this from happening.

Credit on this to James Serra, who has a good post on this error, and to Microsoft.

Filed Under: MDS Tagged With: Batch, Entity-based staging, Error Messages, Leaf Tables

Default value for “ErrorCode”

March 15, 2018 by neal Leave a Comment

MDS 2016 is a big improvement over the previous versions. There are many enhancements in almost every area. One change I had not noticed in MDS 2016 is that a default value has been added for the “ErrorCode” attribute in the staging tables.

One situation where this may be an issue is when SSIS is used to stage data. If the “Keep nulls” value is checked in the Destination configuration, the insert will result in an error.

Filed Under: MDS, SSIS Tagged With: Entity-based staging, Leaf Tables

April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Mar    

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

Aereo Atlanta Microsoft BI Backups BA Conference Batch blog Business Rules Certification Chicago coffee Coursera Data Modeling Data Quality Data Warehouse DAX DVR Entity-based staging Error Messages ETL Excel Goals google Headphones HTPC Leaf Tables MDM MDS news OT PASS Healthcare VC Power BI Power Pivot Power View review Roku SQLSaturday SQL Saturday 272 SQL Server SSIS Subscription View Tabular Tech Training Validation Work

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2021 · Minimum Pro Theme on Genesis Framework · WordPress · Log in