Page 1 of 1
creating Routine in IIS 8.0.1
Posted: Tue Nov 04, 2008 5:41 am
by Geetha_M
Hi,
I want to create a routine for Datastage 8.0 version.
I have followed the steps given for datastage7.5 as specified inone of the posts of this forum.
Im getting the following error :
NuTCRACKER not properly installed. The pathname:
C:/PROGRA~1/MKSTOO~1/include
is missing from the 'INCLUDE' environment variable.
Please let me know if have to follow the same steps,if so how to resolve this problem or let me know the steps to be follwed for 8.0
Other problem is in 8.0 version there is no manager so, how to create the routines.
Thanks in advance...
Posted: Tue Nov 04, 2008 6:23 am
by hamzaqk
its seems like the nutcracker is going nuts :D.. not installed properly ?
Posted: Tue Nov 04, 2008 6:24 am
by hamzaqk
its seems like the nutcracker is going nuts :D.. not installed properly ?
Posted: Tue Nov 04, 2008 7:47 am
by chulett
Yes, a search for "NuTCRACKER not properly installed" here seems to imply a faulty installation that needs to be repeated.
Re: creating Routine in IIS 8.0.1
Posted: Tue Nov 18, 2008 4:15 am
by 4friends
hi In DS8, U had manager merged with designer and u got the routines inside the repository in the designer so u can create ur custom routines in that
Posted: Tue Nov 18, 2008 3:05 pm
by ray.wurlod
I happen to know that U is currently involved in a server-only project, so that your advice is not appropriate.
Posted: Wed Nov 19, 2008 12:29 am
by Geetha_M
Now im able to create routines and but getting following error when trying to compile the job.
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 12:01:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:01:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:01:40(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:01:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 12:01:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:01:44(002) <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-00000 12:01:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\demo_geetha\RT_BP29.O\V0S1_routine_test_Transformer_1.C(316) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
##I IIS-DSEE-TBLD-00079 12:01:44(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -lliborchnt -lliborchcorent -lliborchbuildopnt D:/geetha/mike.obj.o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.tmp.o -o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.dll.
##I IIS-DSEE-TBLD-00000 12:01:44(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'D:\geetha\mike.obj.o'
##E IIS-DSEE-TCOS-00029 12:01:44(006) <main_program> Creation of a step finished with status = FAILED. (routine_test.Transformer_1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_routine_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern uint32 mike(uint32 mike);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink3;
0010: outputname 0 DSLink4;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: }
0020:
0021: mainloop {
0022: // initialise our row rejected variable
0023: RowRejected0 = 1;
0024:
0025: // declare our intermediate variables for this section
0026: uint32 InterVar0_0;
0027:
0028: // evaluate columns (no constraints) for link: DSLink4
0029: InterVar0_0 = DSLink3.id;
0030: DSLink4.id = mike(InterVar0_0);
0031: writerecord 0;
0032: RowRejected0 = 0;
0033: }
0034:
0035: finish {
0036: }
0037:
*** End of Internal Generated Transformer Code
Posted: Wed Nov 19, 2008 12:31 am
by Geetha_M
Now im able to create routines and but getting following error when trying to compile the job.
Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 12:01:40(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4665
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved
##I IIS-DSEE-TOSH-00002 12:01:40(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 12:01:40(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 12:01:40(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 12:01:44(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 12:01:44(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 12:01:44(002) <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-00000 12:01:44(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util\keylookup.h(1148) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\Projects\demo_geetha\RT_BP29.O\V0S1_routine_test_Transformer_1.C(316) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
##I IIS-DSEE-TBLD-00079 12:01:44(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -lliborchnt -lliborchcorent -lliborchbuildopnt D:/geetha/mike.obj.o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.tmp.o -o C:/IBM/InformationServer/Server/Projects/demo_geetha/RT_BP29.O/V0S1_routine_test_Transformer_1.dll.
##I IIS-DSEE-TBLD-00000 12:01:44(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'D:\geetha\mike.obj.o'
##E IIS-DSEE-TCOS-00029 12:01:44(006) <main_program> Creation of a step finished with status = FAILED. (routine_test.Transformer_1)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_routine_test_Transformer_1 transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern uint32 mike(uint32 mike);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink3;
0010: outputname 0 DSLink4;
0011:
0012: initialize {
0013: // define our row rejected variable
0014: int8 RowRejected0;
0015:
0016: // define our null set variable
0017: int8 NullSetVar0;
0018:
0019: }
0020:
0021: mainloop {
0022: // initialise our row rejected variable
0023: RowRejected0 = 1;
0024:
0025: // declare our intermediate variables for this section
0026: uint32 InterVar0_0;
0027:
0028: // evaluate columns (no constraints) for link: DSLink4
0029: InterVar0_0 = DSLink3.id;
0030: DSLink4.id = mike(InterVar0_0);
0031: writerecord 0;
0032: RowRejected0 = 0;
0033: }
0034:
0035: finish {
0036: }
0037:
*** End of Internal Generated Transformer Code
Posted: Wed Nov 19, 2008 12:54 am
by ray.wurlod
Please advise how this issue was Resolved
Posted: Wed Nov 19, 2008 3:24 am
by Geetha_M
when i used the command
cxx -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c mike.c
to compile it gave the following error :
NuTCRACKER not properly installed. The pathname:
C:/PROGRA~1/MKSTOO~1/include
is missing from the 'INCLUDE' environment variable.
But when i tried compiling with command CC -O -c mike.c -o mike
the object code mike.obj was generated.
From the IIS designer ->routines ->right click ->new->parallel routines
Icould create the routine .