Archives of the TeradataForum

Message Posted: Thu, 07 May 2015 @ 16:57:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I am using the TPT Wizard.

The error is occurring just before the script is generated.

It says there were script generation errors.

FYI: It happens with only this one table. I have done some table copy from prod to dev before and after this error.

And I have checked if there any reserve keyword column names in the table, but couldn't find any. Everything is fine.

I have also tried recreating the table in different database with different table name but no use.

Here is the table definition

     CREATE SET TABLE DBA_BACKUP.RAGHU1 ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           SC_DWNLD_PRIORITY INTEGER,
           SC_SERVICE_CENTER INTEGER,
           SC_POLICY_NUM VARCHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           CHG_EFF_DT DATE FORMAT 'YY/MM/DD' NOT NULL,
           CHG_EXP_DT DATE FORMAT 'YY/MM/DD' NOT NULL,
           SC_FLT_ITEM VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           SC_FILE_TYPE INTEGER,
           SC_REC_TRANS_CODE INTEGER,
           SC_TRANS_DATE DATE FORMAT 'YY/MM/DD',
           SC_TRANS_TYPE INTEGER,
           PC_ALPHA_CODE VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_NAME_1 VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_NAME_2 VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_ADDRESS_1 VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_ADDRESS_2 VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_CITYST VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_ZIP VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_TAX_CODE VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_AGENT INTEGER,
           PC_MEMBER_NUMBER VARCHAR(8) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_RATE_CODE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_ENCUMBRANCE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_PREM_FIN VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_MORT_IND VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_COMPANY VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
           PC_INCEPT_DATE DATE FORMAT 'YY/MM/DD',
           PC_EXP_DATE DATE FORMAT 'YY/MM/DD',
           PC_EFF_DATE DATE FORMAT 'YY/MM/DD',
           PC_STATUS VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_TOT_PREM DECIMAL(9,2),
           SMLN_REWRITE_IND VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_REWRITE_DT DATE FORMAT 'YY/MM/DD',
           SMLN_OUTST_AMT DECIMAL(9,2),
           SMLN_OUTST_TYPE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_OUTST_DATE DATE FORMAT 'YY/MM/DD',
           SMLN_OUTST_PD_DATE DATE FORMAT 'YY/MM/DD',
           SMLN_SUSPENSE_CD VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SUSPENSE_CAN VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SSN_1 VARCHAR(11) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SSN_2 VARCHAR(11) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_UW_REVIEW_DT DATE FORMAT 'YY/MM/DD',
           SMLN_UW_INITIALS VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_NAME_1 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_NAME_2 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_ADD_1 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_ADD_2 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_CTYST VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_ZIP VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_STATE VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MORT_TYPE INTEGER,
           SMLN_CANC_CODE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SP5_ENDR_IND VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_LOAN_NUM VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SLOAN_NUM VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_NAME_1 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_NAME_2 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_ADD_1 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_ADD_2 VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_CTYST VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_ZIP VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SMORT_TYPE INTEGER,
           SMLN_PREMIUM_1 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_PREMIUM_2 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_PREMIUM_3 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_PREMIUM_4 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_PREMIUM_5 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_PREMIUM_6 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_PREMIUM_7 VARCHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_COVERAGE_1 INTEGER,
           SMLN_COVERAGE_2 INTEGER,
           SMLN_COVERAGE_3 INTEGER,
           SMLN_COVERAGE_4 INTEGER,
           SMLN_COVERAGE_5 INTEGER,
           SMLN_COVERAGE_6 INTEGER,
           SMLN_COVERAGE_7 INTEGER,
           SMLN_COVERAGE_8 INTEGER,
           SMLN_T_MODEL_YEAR INTEGER,
           SMLN_T_MAKE VARCHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_T_OCCUPANCY VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_T_UNDERPIN VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_T_CLASS VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_POL_TYPE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SP_BT_CLASS VARCHAR(9) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_FC_NUM_ACRES INTEGER,
           SMLN_FC_NUM_EMP INTEGER,
           SMLN_FC_PAYROLL INTEGER,
           SMLN_FC_CUST_FARM INTEGER,
           SMLN_FC_ADD_PREM INTEGER,
           SMLN_FC_RES_MAINT INTEGER,
           SMLN_FC_ADD_INSRD INTEGER,
           SMLN_FC_ADD_RENT INTEGER,
           SMLN_DEDUCTIBLE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_HALF_TERM_BP INTEGER,
           SMLN_FULL_TERM_BP INTEGER,
           SMLN_TRANSFER_DATE DATE FORMAT 'YY/MM/DD',
           SMLN_MB_TYPE VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_MB_ACCT_NUM VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_SC_LIAB_PRD_I VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
           SMLN_GL_COV_TYPE VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
           FEED_IND CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           ECTL_BATCH_ID INTEGER NOT NULL,
           ECTL_ORIG_INS_TS TIMESTAMP(6) NOT NULL,
           ECTL_MODIFY_TS TIMESTAMP(6) NOT NULL,
           ECTL_SRC_ID SMALLINT NOT NULL,
           ECTL_SRC_INST_ID SMALLINT NOT NULL,
           ECTL_PRGM_ID INTEGER NOT NULL,
           ECTL_TX_CD CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           ECTL_START_DATE DATE FORMAT 'YY/MM/DD' NOT NULL,
           ECTL_END_DATE DATE FORMAT 'YY/MM/DD' NOT NULL) PRIMARY INDEX ( SC_POLICY_NUM,CHG_EFF_DT );

Raghu Maram
Teradata DBA

	<Prev	Next>		<<First	<Prev	Next>	Last>>