DSXchange

I am trying to compile a job with a transformer stage and seeing the below error. This is the first time a job is being compiled after datastage installation. Please help me.

##I IIS-DSEE-TFCN-00006 09:44:02(001) <main_program> conductor uname: -s=Windows Server 2008 R2; -r=Service Pack 1; -v=6.1; -n=cognos-02; -m=x86-Intel
##I IIS-DSEE-TOSH-00002 09:44:02(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 09:44:02(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 09:44:02(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 09:44:02(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00068 09:44:02(009) <main_program> Error when checking composite operator: Failure forking subprocess: No such file or directory.
##E IIS-DSEE-TFSR-00019 09:44:02(010) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 09:44:02(011) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##I IIS-DSEE-TBLD-00079 09:44:02(012) <transform> Error when checking composite operator: cl /Ox /D NDEBUG /IG:\IBM\InformationServer\Server\PXEngine\include /D APT_USE_ANSI_IOSTREAMS /D _WIN32 /D _MBCS /nologo /W3 /WX- /Gm- /EHa /MD /GS- /fp:precise /Zc:wchar_t- /Zc:forScope /Gd /TP /Zi /Oy- /c G:\IBM\InformationServer\Server\Projects\Cognos_Sample01\RT_BP1.O\V0S1_Test_Job01_Transformer_1.C /FoG:\IBM\InformationServer\Server\Projects\Cognos_Sample01\RT_BP1.O\V0S1_Test_Job01_Transformer_1.tmp.o /FdG:\IBM\InformationServer\Server\Projects\Cognos_Sample01\RT_BP1.O\V0S1_Test_Job01_Transformer_1.pdb.
##E IIS-DSEE-TCOS-00029 09:44:02(013) <main_program> Creation of a step finished with status = FAILED. (Test_Job01.Transformer_1)

start from something basic.

RowGen->Transformer->Peek


Sounds like this is the first time you are compiling a job with a transformer in a newly setup environment. If that is the case, you might have invalid settings on your project compiler variables, or perhaps your compiler is not supported for that release level of datastage.

Tell us how the basic job goes.

yes this is the first time I am compiling the job.

I compiled the RowGen -> Transformer -> Peek Job. It is giving the same error as above.


I made sure that the compiler environment variables are set correctly.

I checked that the Microsoft Visual C++ 2013 is installed in the programs (which is supported by Datastage 11.3) but I am not sure if it is installed correctly. (I mean the directories are referred correctly in the datastage). Is there a way to confirm that?

Go into the Admin client and select your project, then properties. Then click on the Environment button. It will bring up a list of environment variables.

Look in the Parallel -> Reporting section for a variable called APT_PERFORMANCE_DATA. Make sure it is unset (empty). Then hit ok a couple of times to save the change. Hopefully that will resolve your problem.

I'm not a Windows DataStage admin... nor do I want to be... but you should also ensure that your environment has the compiler in the execution path and the libraries as well.

Make sure you add that stuff in the dsenv settings so that they will be present upon each bounce of the engine.

This may be because you have not installed a supported C++ compiler on the engine tier machine, or perhaps that your compiler version is not supported.

Thanks for the responses!

Looks like C++ compiler was not installed properly. I am installing it now. I will update the outcome here.

Installed Microsoft Visual C++ compiler again and job compiles and runs fine!

Thanks for the responses!

As a rule of thumb, I always like to reboot an environment after doing a product install to see if it survives and still works. So before you tell your downstream customers that it's all good... reboot and test.

chandu2016 wrote:I am trying to compile a job with a transformer stage and seeing the below error. This is the first time a job is being compiled after datastage installation. Please help me.

##I IIS-DSEE-TFCN-00006 09:44:02(001) <main_program> conductor uname: -s=Windows Server 2008 R2; -r=Service Pack 1; -v=6.1; -n=cognos-02; -m=x86-Intel
##E IIS-DSEE-TCOS-00029 09:44:02(013) <main_program> Creation of a step finished with status = FAILED. (Test_Job01.Transformer_1)

I faced the same issue, you have to install visual C++ 2010 express edition and be sure that this environement variable system is added

var VS100COMNTOOLS

value c:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\

for all the verifications must see this
https://www.ibm.com/support/pages/datas ... ndows-2008