Close popover
andrew krutke (andrewk3838)
Express Scripts

Express Scripts
andrewk3838 Member since 2018 1 post
Express Scripts
Posted: May 8, 2018
Last activity: May 9, 2018

Extracting to Teradata VIA BIX error

I'm currently extracting multiple tables from Pega to teradata using BIX. When I select to have more than 1 row updated at a time I receive this error

Severe SQL Exception: [Teradata JDBC Driver] [TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty

regardless if I select 2, 3, 10, 15 etc records to be updated at a time. This problem is occurring more frequently when I extract a Work class and accompanying Data classes (these generate separate tables in the DB.)

To clarify, this error does not happen when only one record is updated at a time.

We are running pega version 7.21

Any advice at where to look to find the root cause of this issue?


***Edited by Moderator Marissa to update categories***

System Administration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.