search cancel

Microsoft SQL Server Development Tools SSDT/SSIS is failing to pull more than 2000 rows after upgrade to 16.0.1: 401 exception

book

Article ID: 237894

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

After the upgrade to Clarity 16.0.1, SQL Server Integration Services fails to pull more than 2000 rows due to a 401 error.

Cause

HDP Helm Chart configuration is wrong on the Broadcom Clarity SaaS environment

Environment

Release : 16.0.1

Component : Clarity Data Warehouse

Resolution

Broadcom Engineering and DevOps teams corrected a network routing issue in Google Cloud Platform.  Updated the "HDP helm chart"

This fix has been implemented for all customers, Prod and Sandbox.

This is now fixed in 16.0.1 and 16.0.2

Additional Information

Excel still works

Postman still works

Tableau also fails

Fiddler is the best tool to troubleshoot this type of Odata issue