CLI 306 Error using Fastload

Database

CLI 306 Error using Fastload

Good afternoon.

 

I am running a Fastload script, but I am getting the error "CLI 306 Error: Completed Successfully". I don't have a clue what this error is about, since it says the command is completed successfully. The log file goes as the following:

 


===================================================================
= =
= Logon/Connection =
= =
===================================================================

0005 .LOGON 10.238.5.7/R327154,

**** 17:20:22 Teradata Database Release: 15.00.05.07
**** 17:20:22 Teradata Database Version: 15.00.05.09a
**** 17:20:22 Number of AMPs available: 336
**** 17:20:22 Current CLI or RDBMS allows maximum row size: 64K
**** 17:20:22 Character set for this job: ASCII

**** 17:20:25 Warning: EOF on INPUT stream.


0006 DROP TABLE P_LEDKSTGDB.TAB_VENDAS_VIVO2;

**** 17:20:29 Command completed successfully

0007 DROP TABLE P_LEDKSTGDB.RE_TEST_FAST_ERROR_SGEND311;

**** 17:20:39 Command completed successfully

0008 DROP TABLE P_LEDKSTGDB.RE_TEST_FAST_ERROR_SGEND321;

**** 17:20:45 Command completed successfully


0009 CREATE MULTISET TABLE P_LEDKSTGDB.TAB_VENDAS_VIVO2, NO FALLBACK
(
ID_MES VARCHAR(50)
,DT_VENDA VARCHAR(50)
,DT_ATIVACAO_SIEBEL VARCHAR(50)
,DT_DESCONEXAO_SIEBEL VARCHAR(50)
,PRODUTO VARCHAR(50)
,RPON VARCHAR(50)
,RPON_ASSOCIADO VARCHAR(50)
,PON_VENDA VARCHAR(50)
,ID_CONTA_SERVICO VARCHAR(50)
,TERMINAL VARCHAR(50)
,TERMINAL_ASSOCIADO VARCHAR(50)
,DOCUMENTO VARCHAR(50)
,MODALIDADE_ATUAL VARCHAR(50)
,MODALIDADE_VENDA VARCHAR(50)
,PLANO_SIEBEL VARCHAR(50)
,ID_PLANO_PRECO VARCHAR(50)
,GRUPO_CANAL VARCHAR(50)
,STATUS_INSTANCIA VARCHAR(50)
,TIPO_TECNOLOGIA VARCHAR(50)
,TIPO_ACESSO_SIEBEL VARCHAR(50)
,PLANO_VENDA VARCHAR(50)
,UF VARCHAR(50)
,CIDADE VARCHAR(100)
/*,BAIRRO VARCHAR(100)*/
,ID_LOCALIDADE VARCHAR(50)
,CEP VARCHAR(50)
/*,ENDERECO VARCHAR(255)*/
,STATUS_VENDA VARCHAR(50)
,BRUTO_TOTAL VARCHAR(50)
,PRECO_LIQUIDO VARCHAR(50)
,STATUS_CLIENTE VARCHAR(50)
)UNIQUE PRIMARY INDEX(DT_VENDA,RPON);

**** 17:20:50 Command completed successfully


0010 SET RECORD VARTEXT ";";

**** 17:20:50 Now set to read 'Variable-Length Text' records
**** 17:20:50 Delimiter character(s) is set to ';'
**** 17:20:50 Command completed successfully


/*SET RECORD UNFORMATTED ;*/
/*RECORD 2; */
0011 DEFINE
ID_MES (VARCHAR(50))
,DT_VENDA (VARCHAR(50))
,DT_ATIVACAO_SIEBEL (VARCHAR(50))
,DT_DESCONEXAO_SIEBEL (VARCHAR(50))
,PRODUTO (VARCHAR(50))
,RPON (VARCHAR(50))
,RPON_ASSOCIADO (VARCHAR(50))
,PON_VENDA (VARCHAR(50))
,ID_CONTA_SERVICO (VARCHAR(50))
,TERMINAL (VARCHAR(50))
,TERMINAL_ASSOCIADO (VARCHAR(50))
,DOCUMENTO (VARCHAR(50))
,MODALIDADE_ATUAL (VARCHAR(50))
,MODALIDADE_VENDA (VARCHAR(50))
,PLANO_SIEBEL (VARCHAR(50))
,ID_PLANO_PRECO (VARCHAR(50))
,GRUPO_CANAL (VARCHAR(50))
,STATUS_INSTANCIA (VARCHAR(50))
,TIPO_TECNOLOGIA (VARCHAR(50))
,TIPO_ACESSO_SIEBEL (VARCHAR(50))
,PLANO_VENDA (VARCHAR(50))
,UF (VARCHAR(50))
,CIDADE (VARCHAR(100))
/*,BAIRRO (VARCHAR(100))*/
,ID_LOCALIDADE (VARCHAR(50))
,CEP (VARCHAR(50))
/*,ENDERECO (VARCHAR(366))*/
,STATUS_VENDA (VARCHAR(50))
,BRUTO_TOTAL (VARCHAR(50))
,PRECO_LIQUIDO (VARCHAR(50))
,STATUS_CLIENTE (VARCHAR(50))
FILE= D:\JOBS_VPC\JOBS_PERIODICOS\BL_por_Tecnologia\FTTC_Vivo2\Bases\Venda
s_Vivo2.txt;

**** 17:20:50 FDL4803 DEFINE statement processed


0012 BEGIN LOADING P_LEDKSTGDB.TAB_VENDAS_VIVO2 ERRORFILES P_LEDKSTGDB.RE_TEST_F
AST_ERROR_SGEND311, P_LEDKSTGDB.RE_TEST_FAST_ERROR_SGEND321;

**** 17:20:50 Session count 41 returned by the DBS overrides
user-requested session count
**** 17:21:28 Number of FastLoad sessions requested = 41
**** 17:21:28 Number of FastLoad sessions connected = 41
**** 17:21:28 FDL4808 LOGON successful
**** 17:21:33 Number of AMPs available: 336
**** 17:21:33 BEGIN LOADING COMPLETE


===================================================================
= =
= Insert Phase =
= =
===================================================================

0013 INSERT INTO P_LEDKSTGDB.TAB_VENDAS_VIVO2 (
ID_MES
,DT_VENDA
,DT_ATIVACAO_SIEBEL
,DT_DESCONEXAO_SIEBEL
,PRODUTO
,RPON
,RPON_ASSOCIADO
,PON_VENDA
,ID_CONTA_SERVICO
,TERMINAL
,TERMINAL_ASSOCIADO
,DOCUMENTO
,MODALIDADE_ATUAL
,MODALIDADE_VENDA
,PLANO_SIEBEL
,ID_PLANO_PRECO
,GRUPO_CANAL
,STATUS_INSTANCIA
,TIPO_TECNOLOGIA
,TIPO_ACESSO_SIEBEL
,PLANO_VENDA
,UF
,CIDADE
/*,BAIRRO*/
,ID_LOCALIDADE
,CEP
/*,ENDERECO*/
,STATUS_VENDA
,BRUTO_TOTAL
,PRECO_LIQUIDO
,STATUS_CLIENTE
)
VALUES(
:ID_MES
,:DT_VENDA
,:DT_ATIVACAO_SIEBEL
,:DT_DESCONEXAO_SIEBEL
,:PRODUTO
,:RPON
,:RPON_ASSOCIADO
,:PON_VENDA
,:ID_CONTA_SERVICO
,:TERMINAL
,:TERMINAL_ASSOCIADO
,:DOCUMENTO
,:MODALIDADE_ATUAL
,:MODALIDADE_VENDA
,:PLANO_SIEBEL
,:ID_PLANO_PRECO
,:GRUPO_CANAL
,:STATUS_INSTANCIA
,:TIPO_TECNOLOGIA
,:TIPO_ACESSO_SIEBEL
,:PLANO_VENDA
,:UF
,:CIDADE
/*,:BAIRRO*/
,:ID_LOCALIDADE
,:CEP
/*,:ENDERECO*/
,:STATUS_VENDA
,:BRUTO_TOTAL
,:PRECO_LIQUIDO
,:STATUS_CLIENTE
);

**** 17:21:37 Number of recs/msg: 42
**** 17:21:37 Starting to send to RDBMS with record 1
**** 17:21:59 Starting row 100000
**** 17:22:18 CLI Error 306: Completed successfully.

 

 

Can someone help me with it?

1 REPLY
Teradata Employee

Re: CLI 306 Error using Fastload

The Messages manual (from info.teradata.com) says a CLI 306 error is:

BADPARCEL Invalid parcel received.
Explanation: An invalid parcel was received.
Remedy: Contact the system administrator.

This suggests that maybe you have some bad data in one of the records after the 99,999th record.  Why it says "Completed successfully" is a mystery to me - that might be a bug, and you could open an incident to get an official answer on that.