compilation errors
Posted: Fri Mar 11, 2005 3:13 am
I have the following error while compiling a job (file - trasformer - file):
Anyone could hel me?
Thanks!
Output from transformer compilation follows:
##I TFCN 000000 17:37:40(000) <main_program>
DataStage XE Parallel Extender V6.0.1
Copyright (C) 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TOSH 000010 17:37:40(001) <main_program> orchgeneral: loaded
##I TOSH 000010 17:37:40(002) <main_program> orchsort: loaded
##I TOSH 000010 17:37:40(003) <main_program> orchstats: loaded
##I TFSC 000000 17:37:41(000) <main_program> APT configuration file: /softwcetl2/app/Ascential/Ascential/DataStage/Configurations/conf8Nodi.apt
##E TFPM 020198 17:37:41(001) <main_program> ERROR: gethostbyname(ptgnl2) returned null; node node2 cannot be used.
##E TFPM 020123 17:37:41(002) <main_program> Unable to define node 'node2'.
Probable configuration problem; contact Orchestrate system administrator.
##E TFSR 000002 17:37:41(003) <main_program> Step execution finished with status = FAILED.
(Q01PCOPTestFatturaNSFVScarti.T1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the Job_T1 transform operator.
0003: // (Generated on 10/03/2005 17.37.59)
0004: //
0005:
0006: // define our input/output link names
0007: inputname 0 L_Reject;
0008: outputname 0 L_Insert;
0009:
0010: global {
0011: // Job parameter declaration
0012: string PCOSEQ;
0013: }
0014:
0015: initialize {
0016: // define our row rejected variable
0017: int8 RowRejected0;
0018:
0019: // define our null set variable
0020: int8 NullSetVar0;
0021:
0022: // Stage variable declaration and initialisation
0023: string StageVar0_StageVar;
0024: StageVar0_StageVar = "";
0025: }
0026:
0027: mainloop {
0028: // initialise our row rejected variable
0029: RowRejected0 = 1;
0030:
0031: // evaluate the stage variables first
0032: StageVar0_StageVar = ((string_from_date(date_from_string(substring_1(system_time_date() , 10 , 11) , "%dd-%mmm-%yyyy")) + " ") + substring_1(system_time_date() , 1 , );
0033:
0034: // evaluate columns (no constraints) for link: L_Insert
0035: L_Insert.D_TMS_VARIAZIONE = L_Reject.V_TMS_VARIAZIONE;
0036: L_Insert.C_FLG_VARIAZIONE = L_Reject.V_FLG_VARIAZIONE;
0037: L_Insert.N_NUM_FATTURA = L_Reject.N_NUM_FATTURA;
0038: L_Insert.V_COD_ARBOR_NUMBER = "*ND";
0039: L_Insert.V_COD_ARBOR_RESETS = "*ND";
0040: L_Insert.V_COD_ACLI = L_Reject.V_COD_ACLI;
0041: L_Insert.V_COD_CFA = "*ND";
0042: L_Insert.V_COD_CICLO_MESE = "*ND";
0043: L_Insert.V_COD_CICLO_ANNO = "*ND";
0044: L_Insert.V_DAT_EMISSIONE_FATT = L_Reject.D_DAT_EMISSIONE_FATT;
0045: L_Insert.V_DAT_INI_DECORRENZA_FATT = "9999-12-31";
0046: L_Insert.V_DAT_SCADENZA_FATT = L_Reject.D_DAT_SCADENZA_FATT;
0047: L_Insert.V_IMP_TOT_IMPONIBILE_ADDEB = L_Reject.N_IMP_TOT_IMPONIBILE_ADDEB;
0048: L_Insert.V_IMP_TOT_IMPONIBILE_ACCR = L_Reject.N_IMP_TOT_IMPONIBILE_ACCR;
0049: L_Insert.V_IMP_TOT_IVA_ADDEB = L_Reject.N_IMP_TOT_IVA_ADDEB;
0050: L_Insert.V_IMP_TOT_IVA_ACCR = L_Reject.N_IMP_TOT_IVA_ACCR;
0051: L_Insert.V_IMP_ARROTON_PRECEDENTE = "*ND";
0052: L_Insert.V_IMP_ARROTON_ATTUALE = "*ND";
0053: L_Insert.V_IMP_TOT_PAGARE_FATTURA = L_Reject.N_IMP_TOT_PAGARE_FATTURA;
0054: L_Insert.V_COD_METODO_PAGAMENTO = "*ND";
0055: L_Insert.V_FLG_TIPO_ACCOUNT = "*";
0056: L_Insert.V_COD_AZZERAMENTO_FATTURA = "*ND";
0057: L_Insert.V_DES_AZZERAMENTO_FATTURA = "*ND";
0058: L_Insert.V_COD_TIPO_FATTURAZIONE = "*ND";
0059: L_Insert.N_NUM_ACCOUNT = "0";
0060: L_Insert.V_DAT_INI_COMPETENZA = "9999-12-31";
0061: L_Insert.V_DAT_END_COMPETENZA = "9999-12-31";
0062: L_Insert.V_COD_PAGAMENTO_BOLLO = "*ND";
0063: L_Insert.V_FLG_EMISSIONE = "*";
0064: L_Insert.V_COD_STATO_CFA = "*ND";
0065: L_Insert.V_COD_CONTOCREDITO = "*ND";
0066: L_Insert.V_COD_SISTEMA = L_Reject.V_COD_SISTEMA;
0067: L_Insert.V_COD_CT_EMITTENTE = L_Reject.V_COD_CT_EMITTENTE;
0068: L_Insert.V_COD_JOB = "Q01PCOPTestataFatturaNSFVScarti";
0069: L_Insert.D_DATA = timestamp_from_string(StageVar0_StageVar);
0070: L_Insert.V_COD_ERROR = "ERR";
0071: L_Insert.N_DWH_SEQ_CARICO_INS = PCOSEQ;
0072: L_Insert.N_DWH_SEQ_CARICO_AGG = PCOSEQ;
0073: L_Insert.V_DWH_COD_SISTEMA_FONTE = "NSFV";
0074: writerecord 0;
0075: RowRejected0 = 0;
0076: }
0077:
0078: finish {
0079: }
0080:
*** End of Internal Generated Transformer Code
Anyone could hel me?
Thanks!
Output from transformer compilation follows:
##I TFCN 000000 17:37:40(000) <main_program>
DataStage XE Parallel Extender V6.0.1
Copyright (C) 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TOSH 000010 17:37:40(001) <main_program> orchgeneral: loaded
##I TOSH 000010 17:37:40(002) <main_program> orchsort: loaded
##I TOSH 000010 17:37:40(003) <main_program> orchstats: loaded
##I TFSC 000000 17:37:41(000) <main_program> APT configuration file: /softwcetl2/app/Ascential/Ascential/DataStage/Configurations/conf8Nodi.apt
##E TFPM 020198 17:37:41(001) <main_program> ERROR: gethostbyname(ptgnl2) returned null; node node2 cannot be used.
##E TFPM 020123 17:37:41(002) <main_program> Unable to define node 'node2'.
Probable configuration problem; contact Orchestrate system administrator.
##E TFSR 000002 17:37:41(003) <main_program> Step execution finished with status = FAILED.
(Q01PCOPTestFatturaNSFVScarti.T1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the Job_T1 transform operator.
0003: // (Generated on 10/03/2005 17.37.59)
0004: //
0005:
0006: // define our input/output link names
0007: inputname 0 L_Reject;
0008: outputname 0 L_Insert;
0009:
0010: global {
0011: // Job parameter declaration
0012: string PCOSEQ;
0013: }
0014:
0015: initialize {
0016: // define our row rejected variable
0017: int8 RowRejected0;
0018:
0019: // define our null set variable
0020: int8 NullSetVar0;
0021:
0022: // Stage variable declaration and initialisation
0023: string StageVar0_StageVar;
0024: StageVar0_StageVar = "";
0025: }
0026:
0027: mainloop {
0028: // initialise our row rejected variable
0029: RowRejected0 = 1;
0030:
0031: // evaluate the stage variables first
0032: StageVar0_StageVar = ((string_from_date(date_from_string(substring_1(system_time_date() , 10 , 11) , "%dd-%mmm-%yyyy")) + " ") + substring_1(system_time_date() , 1 , );
0033:
0034: // evaluate columns (no constraints) for link: L_Insert
0035: L_Insert.D_TMS_VARIAZIONE = L_Reject.V_TMS_VARIAZIONE;
0036: L_Insert.C_FLG_VARIAZIONE = L_Reject.V_FLG_VARIAZIONE;
0037: L_Insert.N_NUM_FATTURA = L_Reject.N_NUM_FATTURA;
0038: L_Insert.V_COD_ARBOR_NUMBER = "*ND";
0039: L_Insert.V_COD_ARBOR_RESETS = "*ND";
0040: L_Insert.V_COD_ACLI = L_Reject.V_COD_ACLI;
0041: L_Insert.V_COD_CFA = "*ND";
0042: L_Insert.V_COD_CICLO_MESE = "*ND";
0043: L_Insert.V_COD_CICLO_ANNO = "*ND";
0044: L_Insert.V_DAT_EMISSIONE_FATT = L_Reject.D_DAT_EMISSIONE_FATT;
0045: L_Insert.V_DAT_INI_DECORRENZA_FATT = "9999-12-31";
0046: L_Insert.V_DAT_SCADENZA_FATT = L_Reject.D_DAT_SCADENZA_FATT;
0047: L_Insert.V_IMP_TOT_IMPONIBILE_ADDEB = L_Reject.N_IMP_TOT_IMPONIBILE_ADDEB;
0048: L_Insert.V_IMP_TOT_IMPONIBILE_ACCR = L_Reject.N_IMP_TOT_IMPONIBILE_ACCR;
0049: L_Insert.V_IMP_TOT_IVA_ADDEB = L_Reject.N_IMP_TOT_IVA_ADDEB;
0050: L_Insert.V_IMP_TOT_IVA_ACCR = L_Reject.N_IMP_TOT_IVA_ACCR;
0051: L_Insert.V_IMP_ARROTON_PRECEDENTE = "*ND";
0052: L_Insert.V_IMP_ARROTON_ATTUALE = "*ND";
0053: L_Insert.V_IMP_TOT_PAGARE_FATTURA = L_Reject.N_IMP_TOT_PAGARE_FATTURA;
0054: L_Insert.V_COD_METODO_PAGAMENTO = "*ND";
0055: L_Insert.V_FLG_TIPO_ACCOUNT = "*";
0056: L_Insert.V_COD_AZZERAMENTO_FATTURA = "*ND";
0057: L_Insert.V_DES_AZZERAMENTO_FATTURA = "*ND";
0058: L_Insert.V_COD_TIPO_FATTURAZIONE = "*ND";
0059: L_Insert.N_NUM_ACCOUNT = "0";
0060: L_Insert.V_DAT_INI_COMPETENZA = "9999-12-31";
0061: L_Insert.V_DAT_END_COMPETENZA = "9999-12-31";
0062: L_Insert.V_COD_PAGAMENTO_BOLLO = "*ND";
0063: L_Insert.V_FLG_EMISSIONE = "*";
0064: L_Insert.V_COD_STATO_CFA = "*ND";
0065: L_Insert.V_COD_CONTOCREDITO = "*ND";
0066: L_Insert.V_COD_SISTEMA = L_Reject.V_COD_SISTEMA;
0067: L_Insert.V_COD_CT_EMITTENTE = L_Reject.V_COD_CT_EMITTENTE;
0068: L_Insert.V_COD_JOB = "Q01PCOPTestataFatturaNSFVScarti";
0069: L_Insert.D_DATA = timestamp_from_string(StageVar0_StageVar);
0070: L_Insert.V_COD_ERROR = "ERR";
0071: L_Insert.N_DWH_SEQ_CARICO_INS = PCOSEQ;
0072: L_Insert.N_DWH_SEQ_CARICO_AGG = PCOSEQ;
0073: L_Insert.V_DWH_COD_SISTEMA_FONTE = "NSFV";
0074: writerecord 0;
0075: RowRejected0 = 0;
0076: }
0077:
0078: finish {
0079: }
0080:
*** End of Internal Generated Transformer Code