Can't compiles jobs with Transformer Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
MarkStewart
Participant
Posts: 17
Joined: Mon Nov 28, 2005 12:44 pm
Contact:

Can't compiles jobs with Transformer Stage

Post by MarkStewart »

Hello, all of a sudden we can't compile jobs with a Transformer stage. Anyone run into this before?

Output from transformer compilation follows:

##I TFCN 000001 12:59:39(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.1r2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 12:59:39(001) <main_program> The open files limit is 100; raising to 1023.
##I TOSH 000002 12:59:39(002) <main_program> orchgeneral: loaded
##I TOSH 000002 12:59:39(003) <main_program> orchsort: loaded
##I TOSH 000002 12:59:39(004) <main_program> orchstats: loaded
##I TFSC 000001 12:59:39(007) <main_program> APT configuration file: /app/dsadm/Ascential/DataStage/Configurations/default.apt
##I TFSC 000000 12:59:39(008) <main_program>
This step has no datasets.

It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##W TFPA 000017 12:59:39(009) <main_program> Warning: the value of the PWD environment variable (/app/dsadm/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/app/dsadm/Ascential/DataStage/Projects/ReDSTest). The current working directory will be used, but if your ORCHESTRATE job does not start up correctly, you should set your PWD environment variable to a value that will work on all nodes of your system.
##E TBLD 000000 12:59:46(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256
##E TFSR 000019 12:59:46(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 12:59:46(002) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##W TFCP 000000 12:59:46(003) <transform> Error when checking composite operator: Function "decimal_from_string [line 39,character 15]" returns decimal, default precision is used
##W TFCP 000000 12:59:46(004) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "Int64".
##W TBLD 000000 12:59:46(005) <main_program> Error when checking composite operator: Output from subprocess: Write failure on /app/dsadm/Ascential/DataStage/Projects/ReDSTest/RT_BP3440.O/V55S3_rds_iex_agent_loginout_data_string_to_decimal.tmp.o : No space left on device

##I TFCP 000008 12:59:46(006) <transform> Error when checking composite operator: /opt/SUNWspro/bin/CC -KPIC -I/app/dsadm/Ascential/DataStage/PXEngine/include -dalign -g -PIC -library=iostream -c /app/dsadm/Ascential/DataStage/Projects/ReDSTest/RT_BP3440.O/V55S3_rds_iex_agent_loginout_data_string_to_decimal.C -o /app/dsadm/Ascential/DataStage/Projects/ReDSTest/RT_BP3440.O/V55S3_rds_iex_agent_loginout_data_string_to_decimal.tmp.o
##E TCOS 000029 12:59:46(007) <main_program> Creation of step finished with status = FAILED (rds_iex_agent_loginout_data.string_to_decimal)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V55S3_rds_iex_agent_loginout_data_string_to_decimal transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 Read_Source;
0007: outputname 0 send_to_target;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: // declare our intermediate variables for this section
0017: string InterVar0_0;
0018: string InterVar0_1;
0019: string InterVar0_2;
0020:
0021: // initialise constant values which require conversion
0022: InterVar0_0 = "CURRENT_RUN_DATE";
0023: InterVar0_1 = "SOURCE_ID";
0024: InterVar0_2 = "N";
0025: }
0026:
0027: mainloop {
0028: // initialise our row rejected variable
0029: RowRejected0 = 1;
0030:
0031: // declare our intermediate variables for this section
0032: int64 InterVar0_3;
0033:
0034: // evaluate columns (no constraints) for link: send_to_target
0035: send_to_target.RDS_CREATED_DATE = timestamp_from_string(get_environment(InterVar0_0));
0036: send_to_target.RDS_SOURCE_ID = get_environment(InterVar0_1);
0037: send_to_target.RDS_DELETED_FLAG = InterVar0_2;
0038: send_to_target.IEX_AGENT_LOCATION = Read_Source.IEX_AGENT_LOCATION;
0039: InterVar0_3 = decimal_from_string(Read_Source.ACDID);
0040: send_to_target.ACDID = InterVar0_3;
0041: writerecord 0;
0042: RowRejected0 = 0;
0043: }
0044:
0045: finish {
0046: }
0047:
*** End of Internal Generated Transformer Code



Thanks.
Mark Stewart
Business Intelligence
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Hmm, I wonder if this part of your output could mean something
...No space left on device ...
trammohan
Participant
Posts: 47
Joined: Thu Nov 13, 2003 12:47 pm

Post by trammohan »

Can you check the space in /tmp ...may have reached 100%...
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Umm.. no need to check /tmp for space - I only pointed out the last part of the error message for brevity's sake. The whole line reads
/app/dsadm/Ascential/DataStage/Projects/ReDSTest/RT_BP3440.O/V55S3_rds_iex_agent_loginout_data_string_to_decimal.tmp.o : No space left on device
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

u might need to install the C++ compiler
hi sam here
myotoo
Participant
Posts: 17
Joined: Sun Dec 04, 2005 11:19 pm

Post by myotoo »

How can I install C++ Compiler in Unix? Is it coming from PX server installer? Is there any specific about datastage version and C++ compiler version?

Thanks
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

myotoo - please start a new thread with this question, as it really has nothing to do with the specific problem in this thread.
trammohan
Participant
Posts: 47
Joined: Thu Nov 13, 2003 12:47 pm

Post by trammohan »

Hi,

Provide the default precision in the decimal ...
like decimal(11,2) in the field definition....
<transform> Error when checking composite operator: Function "decimal_from_string [line 39,character 15]" returns decimal, default precision is used
Post Reply