SQL WARNING from statement: State = HY000, Error Code = 1298

Teradata Studio
Enthusiast

SQL WARNING from statement: State = HY000, Error Code = 1298

Friends, I need to export a table between two servers, but I get the following error in trasnfer history:

Starting Load...

Starting Export...

Copy Table Data Task

Opening connection...

Writing data...

Data extracted successfully with Warning(s)

539133 Rows Exported

Export Warning(s):

SQL WARNING from statement: State = HY000, Error Code = 1298, Warning = java.sql.SQLWarning: [Teradata JDBC Driver] [TeraJDBC 15.00.00.09] [Error 1298] [SQLState HY000] FastExport WITH NO SPOOL is being used for statement SELECT Address_Id, Address_Type_Cd, LoadNBR FROM CERT_KOMPASS_REL_TB.ADDRESS

could help me solve this problem?  Thansks
Tags (2)
11 REPLIES
Senior Apprentice

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

This is just a warning, indicating that the export used NO SPOOL mode.

Simply ignore it :-)

Enthusiast

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

I receive the same error message. There are 70k rows in the source table, after the trasfer runs, there are no records in the target table. I don't think this falls into the "simply ignore it" category. Any other suggestions.

Enthusiast

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

Upon further investigation I have found that I can append rows to the destination table, I just can't use the replace existing. There is no error that I receive when trying to use replace existing, just the warning as shown by the OP. For now, I have resolved the issue by manually deleting records in my destination table, and by then running the data load using the append data method.

Senior Apprentice

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

You got the exactly the same error message: "FastExport WITH NO SPOOL is being used"?

Then you can still ignore it, there must be something else.

Btw, FastExport doesn't load, so there's no target table.

Senior Apprentice

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

Oops, I didn't notice that it's a transfer using TD Studio, of course then there's a target table :)

Strange, replace existing used to work for me....

Teradata Employee

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

Jason, Are there any exceptions in the error log? These should also show in the Job Output for the Data Transfer.

Enthusiast

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

No exceptions, just the same NO SPOOL warning. I'm posting this message with the little timer still spinning next to my upload. I'm hoping it attaches.

Teradata Employee

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

Jason, The replace option will do what you are doing manually, delete all the rows and insert. I am wondering if the 'Delete table' is failing. There are 2 error logs in your workspace /.metadata directory. One is .log and the other is in /Teradata/teradata.log. 

Enthusiast

Re: SQL WARNING from statement: State = HY000, Error Code = 1298

I am wondering if the 'Delete table' is failing.

If the process actually deletes the table, then it probably is silently failing, becuase I wouldn't think that I'd have that ability, even in test. My understanding of replace existing would be since we've just clicked 'export data', that only the data would be deleted, not the structure.

The .log didn't seem to have anything of relevance, but the teradata.log had some items that might be of interest. I saw both of these messages, multiple times, and since I tried to export data using the replace existing method multiple times, that makes sense. (BTW this forum does not make pasting into a post very easy ;)

Teradata Datatools [Thread-33] ERROR com.teradata.datatools.dtp.fastload - A null update count was returned! (x 288)

                                                          c.t.datatools.transfer.progress - Pipe broken ...

                                                          ....

                                                          c.teradata.datatools.dtp.fastexport - java.io.IOException: Read end dead

Hope this helps drive someone else trying to figure this out to the thread as well.