Error API-1002 When SQL Query Has Over 50 Attributes

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When SQLQuery exceeds 50 attributes, the import to the target system is failing with error API-1002: Can only process 50 records at a time.

Steps to Reproduce:

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 Results: Data provider is imported with all 170 attributes for metadata

Actual Results: 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

This issue has been fixed in Clarity 16.4.2.