When SQL Query has over 50 attributes, error API-1002: Can only process 50 records at a time

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When SQLQuery exceeds 50 attributes, the import to the target system is failing with API-1002

STR

1. Create data provider, enable Include Queries
2. Create simple query
   1. select * from dwh_inv_investment
3. In the case of our staging environment, this creates 170 attributes
4. Add the query as an object
5. Publish the data provider
6. Set a migration key
7. Export the data provider
8. Import the data provider

Expected: Data provider is imported with all 170 attributes for metadata

Actual: Data provider import fails with error message:

Data Provider Import Unsuccessful

API-1002: Can only process 50 records at a time

Environment

Clarity 16.4.1

Cause

DE181565

Resolution

In Review with Engineering