Inaccessible Data | Troubleshooting | Teradata Access Module for OLE DB - Inaccessible Data After Errors - Access Module

Teradata® Tools and Utilities Access Module Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Access Module
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-06-12
dita:mapPath
cya1691484517272.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
hjf1479308836950
Product Category
Teradata Tools and Utilities

Problem: Access is locked to the portion of a table that was loaded before an error occurs.

Solution: When a FastLoad job halts due to an error during the loading phase, the job is put into the paused state. In this state, the table that was being loaded and the two error tables are locked and cannot be accessed. To unlock these tables, submit a FastLoad job that contains a BEGIN LOADING command and an END LOADING command.

After executing the END LOADING command, you will be able to access the tables, but the original job cannot be restarted.