Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
kartikdharia
Contributor

Not able to Retrieve Schema from Teradata

I am not able to retrieve schema from Teradata tables. 

 

The connection is successful but when I select any of the table it says "Failed" on the status. When I clicked next , I get the error as 

Error encountered when retrieving schema.
[Teradata Database] [TeraJDBC 15.10.00.33] [Error 2646] [SQLState HY000] No more spool space in <MYUSERID>.

 

I am using talend real time big data platform 6.4.1 

 

Labels (3)
2 Replies
Anonymous
Not applicable

Hi,

 

    It seems to be a spool error from Teradata DB for the specific user id.

 

    Could you please query any table from the Teradata DB though Teradata SQL Assistant Utility using same user id which you are trying to use in Talend? Most probably it will also throw error due to lack of spool space. In that case, please get assistance from Teradata DBAs to increase the spool space.

 

    If the answer has helped you, could you please mark the topic as resolved?

 

Warm Regards,

 

Nikhil Thampi

 

kartikdharia
Contributor
Author

No, there is no issue with Teradata.

 

I am able to query the table and do all the operations from Teradata Studio. Also I am able to read the data from talend

 

The issue is with retrieve schema feature of Talend.