DSXchange

Hi Guys

I am getting a compilation errror. Here is the details of environment.

1. Datastage 8.5 64 Bit
2. SQL Server 2008 64 Bit
3. SQL Client is 32 Bit.
4. Windows 2008 64 Bit.

I ran a sample job which doesnt have Transformer and it ran fine. When i included Transformer ( just direct move - no conversion ) it is giving error . Below is the Log :

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 13:24:29(000) <main_program>



Any help is greatly appreciated.

Thanks
Manish
IBM WebSphere DataStage Enterprise Edition 8.5.0.5746
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 13:24:29(001) <main_program> conductor uname: -s=Windows_NT; -r=1; -v=6; -n=372378-DEV3; -m=Pentium
##I IIS-DSEE-TOSH-00002 13:24:29(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:24:29(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:24:29(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:24:29(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 13:24:31(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 13:24:31(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 13:24:31(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 13:24:31(003) <main_program> Error when checking composite operator: Output from subprocess: C:/Program Files (x86)/Microsoft Visual Studio 9.0/VC/include\exception(85) : warning C4985: 'strcpy_s': attributes not present on previous declaration.
C:/PROGRA~2/MKSTOO~1/include\string.h(90) : see declaration of 'strcpy_s'
C:\IBM\InformationServer\Server\PXEngine\include\apt_util/keylookup.h(1151) : warning C4251: 'APT_KeyLookupRange::rangeOptions_' : class 'std::vector<_Ty>' needs to have dll-interface to be used by clients of class 'APT_KeyLookupRange'
with
[
_
##I IIS-DSEE-TBLD-00000 13:24:31(004) <main_program> Error when checking composite operator: Output from subprocess: Ty=APT_KeyLookupRange::rangeOption
]
C:\IBM\InformationServer\Server\PXEngine\include\apt_components/transformop/transformbase.h(185) : warning C4244: 'argument' : conversion from 'APT_UInt64' to 'unsigned int', possible loss of data
C:\IBM\InformationServer\Server\PXEngine\include\apt_components/transformop/transformbase.h(185) : warning C4334: '<<' : result of 32-bit shift implicitly converted to 64 bits (was 64-bit shift intended?)
C:\IBM\InformationServer\Server\PXEngine\include\apt_componen
##W IIS-DSEE-TFEV-00025 13:24:31(005) <transform> Error when checking composite operator: Converting number to ustring.
##W IIS-DSEE-TFEV-00023 13:24:31(006) <transform> Error when checking composite operator: Implicit conversion from source type "UInt64" to result type "UString".
##I IIS-DSEE-TBLD-00000 13:24:31(007) <main_program> Error when checking composite operator: Output from subprocess: ts/transformop/transformbase.h(185) : warning C4800: 'unsigned __int64' : forcing value to bool 'true' or 'false' (performance warning)
C:\IBM\InformationServer\Server\PXEngine\include\apt_components/transformop/transformbase.h(186) : warning C4244: 'argument' : conversion from 'APT_UInt64' to 'unsigned int', possible loss of data
C:\IBM\InformationServer\Server\PXEngine\include\apt_components/transformop/transformbase.h(186) : warning C4334: '<<' : result of 32-bit shift implicitly converted to 64 bits (
##I IIS-DSEE-TBLD-00000 13:24:31(008) <main_program> Error when checking composite operator: Output from subprocess: was 64-bit shift intended?)
C:\IBM\InformationServer\Server\PXEngine\include\apt_components/transformop/transformbase.h(187) : warning C4244: 'argument' : conversion from 'APT_UInt64' to 'unsigned int', possible loss of data
C:\IBM\InformationServer\Server\Projects\DSMatrix\RT_BP2.O\V0S12_Pj_ggc_pl_poc_X_Ods_Coda.C(206) : warning C4101: 'output' : unreferenced local variable
C:\IBM\InformationServer\Server\Projects\DSMatrix\RT_BP2.O\V0S12_Pj_ggc_pl_poc_X_Ods_Coda.C(201) : warning C4101: 'input' : unrefer
##W IIS-DSEE-TFEV-00023 13:24:31(009) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00023 13:24:31(010) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##I IIS-DSEE-TBLD-00000 13:24:31(011) <main_program> Error when checking composite operator: Output from subprocess: enced local variable

##I IIS-DSEE-TBLD-00079 13:24:31(012) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/DSMatrix/RT_BP2.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -W/Zc:wchar_t- -lliborchnt -lliborchcorent -lliborchbuildopnt C:/IBM/InformationServer/Server/Projects/DSMatrix/RT_BP2.O/V0S12_Pj_ggc_pl_poc_X_Ods_Coda.tmp.o -o C:/IBM/InformationServer/Server/Projects/DSMatrix/RT_BP2.O/V0S12_Pj_ggc_pl_poc_X_Ods_Coda.dll.
##I IIS-DSEE-TBLD-00000 13:24:31(013) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'kernel32.lib'

##E IIS-DSEE-TCOS-00029 13:24:31(014) <main_program> Creation of a step finished with status = FAILED. (Pj_ggc_pl_poc.X_Ods_Coda)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S12_Pj_ggc_pl_poc_Transformer_12 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 Cpo_ods_coda;
0007: outputname 0 Xo_ods_coda;
0008:
0009: initialize {
0010: // define our control variables
0011: int8 RowRejected0;
0012: int8 NullSetVar0;
0013:
0014: // define and initialise each link row count variable required
0015: uint64 RowCount0_0;
0016: RowCount0_0 = 0;
0017:
0018: }
0019:
0020: mainloop {
0021:
0022: // declare our intermediate variables for this section
0023: int64 InterVar0_0;
0024:
0025: // initialise the rejected row variable
0026: RowRejected0 = 1;
0027:
0028: // evaluate constraint and columns for link: Xo_ods_coda
0029: InterVar0_0 = RowRejected0;
0030: if (InterVar0_0)
0031: {
0032: writerecord 0;
0033: RowRejected0 = 0;
0034: RowCount0_0 = RowCount0_0 + 1;
0035: }
0036: }
0037:
0038: finish {
0039: // Log warnings for any reject links
0040: ustring LogMsg0;
0041: ustring LogLink0;
0042: if (RowCount0_0 > 0) {
0043: LogMsg0 = RowCount0_0;
0044: LogLink0 = " rows written to reject link: ";
0045: LogMsg0 = LogMsg0 + LogLink0;
0046: LogLink0 = "Xo_ods_coda";
0047: LogMsg0 = LogMsg0 + LogLink0;
0048: u_print_message(LogMsg0);
0049: }
0050:
0051: }
0052:
*** End of Internal Generated Transformer Code

please check that Microsoft Visual Studio 9.0 is installed properly on the system or not.

It should be the starting point for me!

Read through the appropriate instructions available at <a href="http://publib.boulder.ibm.com/infocente ... html">this link</a> in the IBM Information Center for IIS 8.5.

Regards,