All Forums Teradata Studio
12 Jul 2016
TD Studio data transfer unexpected token

I'm creating a test for transfering data using TD Studio 15.10.11 running on an iMac OS X 10.11.5 with lots of memory and disk.
On the same machine, I have a TD VM Express 1TB version 14.10
On a second machine, an Mac Mini runnint OS X 10.11.5 with 16 GB memory and 2TB disk, I have another TD VM Express 1TB version 14.10.  I'm trying to move transfer data from the iMac to the Mac Mini.  Very small table, 1 column 3 rows.  I am constantly getting the following.  Any help would be appreciated.
Thanks.
 
Copy Table Data Task

Opening connection...

Writing data...

Starting Export...

Data extracted successfully with Warning(s)

3 Rows Exported

 

 

Export Warning(s):

SQL WARNING from statement: State = HY000, Error Code = 1298, Warning = java.sql.SQLWarning: [Teradata JDBC Driver] [TeraJDBC 15.10.00.09] [Error 1298] [SQLState HY000] FastExport WITH NO SPOOL is being used for statement SELECT  test_result FROM SMS_Data_pi.dim_test_result;

Starting Load...

CopyJob: Error trying to copy data from MACMINI_TESTDB.dim_test_result : Error inserting data.

Load Error Occurred: Message = Unexpected Token

Load Failed 

 

Garrett Sienkiewicz
fgrimmer 553 posts Joined 04/09
12 Jul 2016

Garrett, This issue may be that the source table has more columns than the destination or visa versa. Can you confirm that the tables have the same number of columns or you have mapped to appropriate column types for copy?

12 Jul 2016

I've tried this multiple times: where the source file doesn't exist and is created and where the source file exists.  The number of columns is correct.

Garrett Sienkiewicz

12 Jul 2016

Also, FYI, I recently installed the latest version of TD TTU and Studio on a Windows 10 machine. I thought I'd try a different environment so see if it would work.  TD Studio 15.11 on the Windows machine wouldn't open the query perspective.  I received an error.

Garrett Sienkiewicz

fgrimmer 553 posts Joined 04/09
12 Jul 2016

Garrett, Are you doing a Copy or Fast Load from a file?

fgrimmer 553 posts Joined 04/09
12 Jul 2016

Garrett, If you are doing a Data> Load on the table then you want to make sure you have chosen the correct EOL and delimeters.

12 Jul 2016

This is Teradata to Teradata.

Garrett Sienkiewicz

12 Jul 2016

On another machine, MacBook Pro, I installed TD Studio 15.11.  Same result.

Garrett Sienkiewicz

fgrimmer 553 posts Joined 04/09
12 Jul 2016

Garrett, OK, so you are doing a Copy from one Teradata system to another. Does the destination table exist? If it does, then you want to make sure that you map the columns from source to compatible column types in the destination. Can you share the DDL for the source and destination tables?

12 Jul 2016

CREATE SET TABLE SMS_Data_pi.dim_test_result ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      test_result VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
UNIQUE PRIMARY INDEX ( test_result );
 
 
CREATE SET TABLE MACMINI_TESTDB.dim_test_result ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      test_result VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC)
 
UNIQUE PRIMARY INDEX ( test_result );
 
The MACMINI_TESTDB is the target and it's empty.  I noticed that these are SET tables (need to fix that).  I recreated the source table with a different name as a MULTISET table, loaded it and had the same results.

Garrett Sienkiewicz

fgrimmer 553 posts Joined 04/09
13 Jul 2016

Garrett, I created the two tables in separate Teradata Database systems, loaded the source table with 23 rows of data and left destination table empty. Then, in the Data Transfer perspective, dragged the source table and dropped it in the Transfer View showing destination table. It copied successfully. I also tested the Data>Export option and chose Teradata as my Destination and it also copied successfully.  
It is just one column. Is there anything different about the data you were copying? I loaded various numberic values, including commas and spaces. Are there any exceptions during the copy in the error logs (located in your workspace/.metadata/.log and workspace/.metadata/Teradata/teradata.log.

13 Jul 2016

There seem to be a number of issues.  I've attached 3 screen shots.  I've created a new table, xxx, to avoid confusion.  Here's my step by step:
1)  Tried the drag and drop method.  TD Studio complained that the source and target were the same name. Screen shot: iMac TD Studio complains 2016-07-13 at 1.49.59 PM
2)  Used Administrative perspective to drop the target table.  Results screen shot: iMac TD Studio Administraction Perspective 2016-07-13 at 1.52.40 PM
3) I went back to the transfer perspective, and saw that the table continues to appear in TD Studio.  I refresed the display at multiple levels including the table level, and the table still appears.  Screen shot: iMac TD Studio Data Transfer Perspective 2016-07-13 at 1.54.07 PM
4) I went to the VM, fired up TD express to check to see if the table exists.  It doesn't.  Screen shot: MacMini TD Express 2016-07-13 at 1.57.57 PM
Net net, the table appears in the transfer perspective but it doesn't exist.  
I've spent over an hour trying to load screen shots but the rotating clock never stops so I don't think they're attached.  Please let me know if you want to see them and there's another way to get them to you.  Should you want to correspond by email, garrett@data-modeling-services.com.
Thanks.

Garrett Sienkiewicz

fgrimmer 553 posts Joined 04/09
13 Jul 2016

Garrett, I will send you an email. Thanks.

You must sign in to leave a comment.