FLoad error: Unable to obtain Data Signature

Tools & Utilities
Enthusiast

FLoad error: Unable to obtain Data Signature

Hello

I am a newbie to teradata

I was trying to FLoad a file but it gives this error "UNABLE TO OBTAIN DATA SIGNATURE" and the data doesnot load into the table

Here is my FLoad Script:

***********************

FLoad Script

***********************

.LOGON teradb/db,pwd;

BEGIN LOADING

db.table

ERRORFILES

db.table_er1, db.table_er2;

SET RECORD VARTEXT ",";

DEFINE

BRC_ID (VARCHAR(50)),

BRC (VARCHAR(50)),

SHOPPING_EVENT_ID (VARCHAR(50)),

FW_SEE_ESTIMATE_ID (VARCHAR(50)),

LOCATION_ID (VARCHAR(50)),

SPLC_ID (VARCHAR(50)),

EQUIPMENT_ID (VARCHAR(50)),

DOCUMENT_ID (VARCHAR(50)),

RECORD_TYPE (VARCHAR(50)),

INVOICING_PARTY (VARCHAR(50)),

INVOICED_PARTY (VARCHAR(50)),

INVOICE_NUMBER (VARCHAR(50)),

ACCOUNT_DATE (VARCHAR(50)),

REPAIR_DATE (VARCHAR(50)),

REPAIR_PARTY (VARCHAR(50)),

RP_INVOICE_NUMBER (VARCHAR(50)),

RP_REFERENCE_NUMBER (VARCHAR(50)),

RP_FACILITY_TYPE (VARCHAR(50)),

LOAD_EMPTY_INDICATOR (VARCHAR(50)),

CURRENCY_INDICATOR (VARCHAR(50)),

REFERENCE_NUMBER (VARCHAR(50)),

DEFECT_CARD_PARTY (VARCHAR(50)),

DEFECT_CARD_DATE (VARCHAR(50)),

ACTIVE (VARCHAR(50)),

REVISED (VARCHAR(50)),

ADJUSTMENT (VARCHAR(50)),

COMMENTS (VARCHAR(255)),

LABOR_RATE (VARCHAR(50)),

FW_RAE_STATUS_ID (VARCHAR(50)),

FW_RAE_STATUS_USER_ID (VARCHAR(50)),

FW_RAE_STATUS_DATE (VARCHAR(50)),

FW_RAE (VARCHAR(50)),

INVOICING_PARTY_ID (VARCHAR(50)),

INVOICED_PARTY_ID (VARCHAR(50)),

RAILCAR_TYPE_CODE (VARCHAR(50)),

SOURCE_CLIENT_ID (VARCHAR(50)),

INVOICE_ID (VARCHAR(50)),

UPDATED_DATE (VARCHAR(50)),

REMITTANCE_EXPORT_DATE (VARCHAR(50)),

FINAL_DOLLAR_BRC (VARCHAR(50)),

CREATED_DATE (VARCHAR(50))

FILE = C:\...\table_data.txt;

INSERT INTO db.table

(

:BRC_ID,

:BRC,

:SHOPPING_EVENT_ID,

:FW_SEE_ESTIMATE_ID,

:LOCATION_ID,

:SPLC_ID,

:EQUIPMENT_ID,

:DOCUMENT_ID,

:RECORD_TYPE,

:INVOICING_PARTY,

:INVOICED_PARTY,

:INVOICE_NUMBER,

:ACCOUNT_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

:REPAIR_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

:REPAIR_PARTY,

:RP_INVOICE_NUMBER,

:RP_REFERENCE_NUMBER,

:RP_FACILITY_TYPE,

:LOAD_EMPTY_INDICATOR,

:CURRENCY_INDICATOR,

:REFERENCE_NUMBER,

:DEFECT_CARD_PARTY,

:DEFECT_CARD_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

:ACTIVE,

:REVISED,

:ADJUSTMENT,

:COMMENTS,

:LABOR_RATE,

:FW_RAE_STATUS_ID,

:FW_RAE_STATUS_USER_ID,

:FW_RAE_STATUS_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

:FW_RAE,

:INVOICING_PARTY_ID,

:INVOICED_PARTY_ID,

:RAILCAR_TYPE_CODE,

:SOURCE_CLIENT_ID,

:INVOICE_ID,

:UPDATED_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

:REMITTANCE_EXPORT_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

:FINAL_DOLLAR_BRC,

:CREATED_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss')

);

ENDLOADING;

.LOGOFF

*************************

Data for FLoad

*************************

2825110,'X',52767,3043,637,110639,85447,1,1,'TIVT','DOWX','117-12209','01-JAN-12 12.00.00 AM','31-JAN-12 12.00.00 AM','TIVT','117-12209',null,'CS','E','U',null,null,null,1,0,0,null,54,1,1,'31-JAN-12 03.45.35 PM',0,1925,1963,null,1963,1,'31-JAN-12 03.45.35 PM',null,0,'19-SEP-12 06.41.24 PM'

************************

FLoad whole run file

************************

0001 .LOGON teradb/db,

**** 10:46:38 Teradata Database Release: 14.00.00.09

**** 10:46:38 Teradata Database Version: 14.00.00.09

**** 10:46:38 Current CLI or RDBMS allows maximum row size: 64K

**** 10:46:38 Character set for this job: ASCII

0002 BEGIN LOADING

     db.table

     ERRORFILES

     db.table_er1, db.table_er2;

**** 10:46:49 Number of FastLoad sessions connected = 8

**** 10:46:49 FDL4808 LOGON successful

**** 10:46:50 Number of AMPs available: 8

**** 10:46:50 BEGIN LOADING COMPLETE

0003 SET RECORD VARTEXT ",";

**** 10:46:50 Now set to read 'Variable-Length Text' records

**** 10:46:50 Delimiter character(s) is set to ','

**** 10:46:50 Command completed successfully

0004 DEFINE

     BRC_ID (VARCHAR(50)),

     BRC (VARCHAR(50)),

     SHOPPING_EVENT_ID (VARCHAR(50)),

     FW_SEE_ESTIMATE_ID (VARCHAR(50)),

     LOCATION_ID (VARCHAR(50)),

     SPLC_ID (VARCHAR(50)),

     EQUIPMENT_ID (VARCHAR(50)),

     DOCUMENT_ID (VARCHAR(50)),

     RECORD_TYPE (VARCHAR(50)),

     INVOICING_PARTY (VARCHAR(50)),

     INVOICED_PARTY (VARCHAR(50)),

     INVOICE_NUMBER (VARCHAR(50)),

     ACCOUNT_DATE (VARCHAR(50)),

     REPAIR_DATE (VARCHAR(50)),

     REPAIR_PARTY (VARCHAR(50)),

     RP_INVOICE_NUMBER (VARCHAR(50)),

     RP_REFERENCE_NUMBER (VARCHAR(50)),

     RP_FACILITY_TYPE (VARCHAR(50)),

     LOAD_EMPTY_INDICATOR (VARCHAR(50)),

     CURRENCY_INDICATOR (VARCHAR(50)),

     REFERENCE_NUMBER (VARCHAR(50)),

     DEFECT_CARD_PARTY (VARCHAR(50)),

     DEFECT_CARD_DATE (VARCHAR(50)),

     ACTIVE (VARCHAR(50)),

     REVISED (VARCHAR(50)),

     ADJUSTMENT (VARCHAR(50)),

     COMMENTS (VARCHAR(255)),

     LABOR_RATE (VARCHAR(50)),

     FW_RAE_STATUS_ID (VARCHAR(50)),

     FW_RAE_STATUS_USER_ID (VARCHAR(50)),

     FW_RAE_STATUS_DATE (VARCHAR(50)),

     FW_RAE (VARCHAR(50)),

     INVOICING_PARTY_ID (VARCHAR(50)),

     INVOICED_PARTY_ID (VARCHAR(50)),

     RAILCAR_TYPE_CODE (VARCHAR(50)),

     SOURCE_CLIENT_ID (VARCHAR(50)),

     INVOICE_ID (VARCHAR(50)),

     UPDATED_DATE (VARCHAR(50)),

     REMITTANCE_EXPORT_DATE (VARCHAR(50)),

     FINAL_DOLLAR_BRC (VARCHAR(50)),

     CREATED_DATE (VARCHAR(50))

     FILE = C:\...\table_data.txt;

**** 10:46:51 FDL4803 DEFINE statement processed

     ===================================================================

     =                                                                 =

     =          Insert Phase                                           =

     =                                                                 =

     ===================================================================

0005 INSERT INTO db.table

     (

     :BRC_ID,

     :BRC,

     :SHOPPING_EVENT_ID,

     :FW_SEE_ESTIMATE_ID,

     :LOCATION_ID,

     :SPLC_ID,

     :EQUIPMENT_ID,

     :DOCUMENT_ID,

     :RECORD_TYPE,

     :INVOICING_PARTY,

     :INVOICED_PARTY,

     :INVOICE_NUMBER,

     :ACCOUNT_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :REPAIR_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :REPAIR_PARTY,

     :RP_INVOICE_NUMBER,

     :RP_REFERENCE_NUMBER,

     :RP_FACILITY_TYPE,

     :LOAD_EMPTY_INDICATOR,

     :CURRENCY_INDICATOR,

     :REFERENCE_NUMBER,

     :DEFECT_CARD_PARTY,

     :DEFECT_CARD_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :ACTIVE,

     :REVISED,

     :ADJUSTMENT,

     :COMMENTS,

     :LABOR_RATE,

     :FW_RAE_STATUS_ID,

     :FW_RAE_STATUS_USER_ID,

     :FW_RAE_STATUS_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :FW_RAE,

     :INVOICING_PARTY_ID,

     :INVOICED_PARTY_ID,

     :RAILCAR_TYPE_CODE,

     :SOURCE_CLIENT_ID,

     :INVOICE_ID,

     :UPDATED_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :REMITTANCE_EXPORT_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :FINAL_DOLLAR_BRC,

     :CREATED_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss')

     );

**** 10:46:51 I/O Error on File Checkpoint: 42, Text: Unable to obtain

              data signature

     ===================================================================

     =                                                                 =

     =          Logoff/Disconnect                                      =

     =                                                                 =

     ===================================================================

**** 10:46:51 Logging off all sessions

**** 10:46:52 Total processor time used = '3.82813 Seconds'

     .        Start : Mon Oct 28 10:46:33 2013

     .        End   : Mon Oct 28 10:46:52 2013

     .        Highest return code encountered = '12'.

**** 10:46:52 FastLoad Paused

Please help me resolve this issue.

Thank you

Nikhilesh

14 REPLIES
Enthusiast

Re: FLoad error: Unable to obtain Data Signature

Hi Thomas,

Both of the data file and the script file are in the same folder, could you please elaborate on the new line character and the one record per line you were talking about.

Thank you

Teradata Employee

Re: FLoad error: Unable to obtain Data Signature

Hi Nikhilesh,

Could you save the data file to a different file. Then recreate the file in ASCII using a text editor.

Then rerun the script again.

I tried to run your script using fasload 14.00 and it works fine!

====================

0009 INSERT INTO devx

     (

     :BRC_ID,

     :BRC,

     :SHOPPING_EVENT_ID,

     :FW_SEE_ESTIMATE_ID,

     :LOCATION_ID,

     :SPLC_ID,

     :EQUIPMENT_ID,

     :DOCUMENT_ID,

     :RECORD_TYPE,

     :INVOICING_PARTY,

     :INVOICED_PARTY,

     :INVOICE_NUMBER,

     :ACCOUNT_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :REPAIR_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :REPAIR_PARTY,

     :RP_INVOICE_NUMBER,

     :RP_REFERENCE_NUMBER,

     :RP_FACILITY_TYPE,

     :LOAD_EMPTY_INDICATOR,

     :CURRENCY_INDICATOR,

     :REFERENCE_NUMBER,

     :DEFECT_CARD_PARTY,

     :DEFECT_CARD_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :ACTIVE,

     :REVISED,

     :ADJUSTMENT,

     :COMMENTS,

     :LABOR_RATE,

     :FW_RAE_STATUS_ID,

     :FW_RAE_STATUS_USER_ID,

     :FW_RAE_STATUS_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :FW_RAE,

     :INVOICING_PARTY_ID,

     :INVOICED_PARTY_ID,

     :RAILCAR_TYPE_CODE,

     :SOURCE_CLIENT_ID,

     :INVOICE_ID,

     :UPDATED_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :REMITTANCE_EXPORT_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss'),

     :FINAL_DOLLAR_BRC,

     :CREATED_DATE (FORMAT 'yyyy-mm-ddbhh:mi:ss')

     );

**** 14:50:07 Number of recs/msg: 28

**** 14:50:07 Starting to send to RDBMS with record 1

**** 14:50:07 Sending row 1

**** 14:50:07 Finished sending rows to the RDBMS

**** 14:50:07 Acquisition Phase statistics:

              Elapsed time: 00:00:00 (in hh:mm:ss)

              CPU time:     0 Seconds

              MB/sec:       N/A

              MB/cpusec:    N/A

     ===================================================================

     =                                                                 =

     =          End Loading Phase                                      =

     =                                                                 =

     ===================================================================

0010 END LOADING;

**** 14:50:09 END LOADING COMPLETE

     Total Records Read              =  1

     Total Error Table 1             =  0  ---- Table has been dropped

     Total Error Table 2             =  0  ---- Table has been dropped

     Total Inserts Applied           =  1

     Total Duplicate Rows            =  0

     Start:   Mon Oct 28 14:50:08 2013

     End  :   Mon Oct 28 14:50:09 2013

**** 14:50:09 Application Phase statistics:

              Elapsed time: 00:00:01 (in hh:mm:ss)

Enthusiast

Re: FLoad error: Unable to obtain Data Signature

HI Thomas

I have copied the data into another text document and saved it with word wrap on and tried running, but still i get the same error.

Teradata Employee

Re: FLoad error: Unable to obtain Data Signature

Nukalanikhilesh,

Check your data file again. It's very likely EOF is encountered before the end of record.

Try "od -c table_data.txt", and check if it's ended with  \r\n or \n, that looks like:

[C:/JUNK/TRY] od -c table_data.txt

0000000000     2   8   2   5   1   1   0   ,   '   X   '   ,   5   2   7   6

0000000020     7   ,   3   0   4   3   ,   6   3   7   ,   1   1   0   6   3

0000000040     9   ,   8   5   4   4   7   ,   1   ,   1   ,   '   T   I   V

0000000060     T   '   ,   '       D   O   W   X   '   ,   '   1   1   7   -

0000000100     1   2   2   0   9   '   ,   '   0   1   -   J   A   N   -   1

0000000120     2       1   2   .   0   0   .   0   0       A   M   '   ,   '

0000000140     3   1   -   J   A   N   -   1   2       1   2   .   0   0   .

0000000160     0   0       A   M   '   ,   '   T   I   V   T   '   ,   '   1

0000000200     1   7   -   1   2   2   0   9   '   ,   n   u   l   l   ,   '

0000000220     C   S   '   ,   '   E   '   ,   '   U   '       ,   n   u   l

0000000240     l   ,   n   u   l   l   ,   n   u   l   l   ,   1   ,   0   ,

0000000260     0   ,   n   u   l   l   ,   5   4   ,   1   ,   1   ,   '   3

0000000300     1   -   J   A   N   -   1   2       0   3   .   4   5   .   3

0000000320     5       P   M   '   ,   0   ,   1   9   2   5   ,   1   9   6

0000000340     3   ,   n   u   l   l   ,   1   9   6   3   ,   1   ,   '   3

0000000360     1   -   J   A   N   -   1   2       0   3   .   4   5   .   3

0000000400     5       P   M   '   ,   n   u   l   l   ,   0   ,   '   1   9

0000000420     -   S   E   P   -   1   2       0   6   .   4   1   .   2   4

0000000440         P   M   '  \r  \n

=========================

The data signature error is issued by Data Connector. I talked to the Data Connector developer, he said that  "User needs to use DataConnector 14.00.00.008 or above Efix versions to get a detailed error description regarding the errors which  occur while obtaining data signature."

Thomas

Enthusiast

Re: FLoad error: Unable to obtain Data Signature

Hi Thomas

I have tried using the od command from cmd prompt, but it says

'od' is not recognized as an internal or external command,

operable program or batch file.

I seriously do not understand this issue, is there any way that we can meet on webex or something so that you can clearly show me what you are doing.

Thnak you

Teradata Employee

Re: FLoad error: Unable to obtain Data Signature

Nikhilesh,

You can use a hex editor and see the contents of your data file since od command is not available on your system.

What is your email address? I will send you my data file and see if it works.

The Client Architect in my group thinks that it seems a bug in the Data Connector's data signature feature. If EOF is being encountered before the end of record then there should be no data signature retrieval and no error would be returned. We will discuss about it and keep you posted.

Thanks,

Thomas

Enthusiast

Re: FLoad error: Unable to obtain Data Signature

E-mail: nukalanikhilesh@gmail.com

Let me look into the hex editor thing and see if it helps.

Thank you

Enthusiast

Re: FLoad error: Unable to obtain Data Signature

I have opened the data file in hex editor and this is how it looks like.

it did not end with either of \n or \r \n

Teradata Employee

Re: FLoad error: Unable to obtain Data Signature

I just sent you my data file.

Your file does not end with \n or \r\n, it's the reason you get the data signature error!

Did you create your file by cut and paste the data in WordPad and save it, not by entering hand?

You can use hex editor to edit your file or use my file just sent.