GEL Import CSV - not all Rows Importing

book

Article ID: 196321

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

  • I have a CSV file I am importing into a staging table in Clarity. There are 11,519 records in the file.
  • I have a loop to write these to the staging table and I only get up to 8,459 rows.
  • Is this due to a memory limit that prevents more records from being run?

Cause

This can be due to a field length being longer than the field size of the field in the database.

Environment

Release : All Supported Releases

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

Correct the field size, then the records should import.

Additional Information

See KB: 141061 for tips on how to optimize use of Self Service for Clarity PPM