Not able to Retrieve Schema from Teradata

Four Stars

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 

 

Employee

Re: Not able to Retrieve Schema from Teradata

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

 

Four Stars

Re: Not able to Retrieve Schema from Teradata

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.

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now