Unable to add Dataflow to Development package

[#1]

Hello Community,

I was trying to add SampleDataflow2 to Development package which leads me to an error message as follows:

this dataflow failed to compile . please open the dataflow to fix the error

please find the attached too.

So, I try to run it and find it compile succeeded but failed at execution as follows    :

Compile Succeeded!

Executable: etask.exe

Arguments:  -x SampleDataflow2 -d 1 -i 1

Working Directory: C:\Users\IrfanGhori\Documents\expressor\Workspaces\Expressor_Integrate_Qlikview_Demo\Metadata\E_I_QV_Demo.0\dfp\SampleDataflow2\external

__compat_layer = ElevateCreateProcess

allusersprofile = C:\ProgramData

appdata = C:\Users\IrfanGhori\AppData\Roaming

commonprogramfiles = C:\Program Files (x86)\Common Files

commonprogramfiles(x86) = C:\Program Files (x86)\Common Files

commonprogramw6432 = C:\Program Files\Common Files

computername = IRFANGHORI-PC

comspec = C:\Windows\system32\cmd.exe

exp_home = C:\Program Files (x86)\expressor\expressor3\

exp_studio_running_version = 3.7.1

exp_token = FNkerJPNUC2hwIXNiEQzAUesgnYOM6SZNrv0XM6D358=

fp_no_host_check = NO

homedrive = C:

homepath = \Users\IrfanGhori

localappdata = C:\Users\IrfanGhori\AppData\Local

logonserver = \\IRFANGHORI-PC

number_of_processors = 2

os = Windows_NT

path = C:\Program Files (x86)\expressor\expressor3\usr\lib;C:\Program Files (x86)\expressor\expressor3\lib;C:\Program Files (x86)\expressor\expressor3\usr\local\bin;C:\Program Files (x86)\expressor\expressor3\usr\bin;C:\Program Files (x86)\expressor\expressor3\bin;C:\Program Files (x86)\expressor\expressor3\Studio;C:\Program Files (x86)\expressor\expressor3\Repository\bin;C:\Program Files (x86)\expressor\expressor3\Studio\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\;C:\Users\IrfanGhori\AppData\Local\Smartbar\Application\

pathext = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

processor_architecture = x86

processor_architew6432 = AMD64

processor_identifier = Intel64 Family 6 Model 23 Stepping 10, GenuineIntel

processor_level = 6

processor_revision = 170a

programdata = C:\ProgramData

programfiles = C:\Program Files (x86)

programfiles(x86) = C:\Program Files (x86)

programw6432 = C:\Program Files

psmodulepath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\

public = C:\Users\Public

sessionname = Console

systemdrive = C:

systemroot = C:\Windows

temp = C:\Users\IRFANG~1\AppData\Local\Temp

tmp = C:\Users\IRFANG~1\AppData\Local\Temp

userdomain = IrfanGhori-PC

username = IrfanGhori

userprofile = C:\Users\IrfanGhori

windir = C:\Windows

windows_tracing_flags = 3

windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log

dataflow controller - ETASK-0017-N: Using Desktop license for an unknown expressor product; resource utilization limited. (etask.controller)

expressor dataflow execution utility (etask) 3.7.1.22531 n (Build 22531) Aug 15 2012

<task dataflow="SampleDataflow2">

<!-- project.home[(null)], project[..] -->

<step id="0" step_name="Step_1" process="9648" run="0" status="ok" start="2012-09-09T14:14:27">

Read Header File - OPERATOR-0050-F: toolId 1.0, name 'Read Header File' - Exception 'ChannelIOException' occurred in the 'initialize' function. (SampleDataflow2.Step_1)

Read Header File - CHANNELIO-0011-A: Open failed for file 'D:\New_Demo\salesOrderHeader.txt'  - 2 (The system cannot find the file specified.). (SampleDataflow2.Step_1)

Read Header File - OPERATOR-0003-F: toolId 1.0, name 'Read Header File' - the 'initialize' function failed. (SampleDataflow2.Step_1)

Read Header File - ETOOL-0006-F: operator 1.0, type in-file, name 'Read Header File': etool failed, phase runInitialize. (SampleDataflow2.Step_1)

Read Header File - ETOOL-0016-A: operator 1.0, type in-file, pid 7432 - initialize() failed. (SampleDataflow2.Step_1)

  <status>failed</status>

</step>

<statistic>3.380</statistic>

</task>

dataflow controller - ETASK-0038-F: Processing has completed abnormally. (SampleDataflow2.controller)

Is it the issue because of license?

[#2]

I installed your project, opened the deployment package, and removed all the dataflows.

Then I added the dataflows back in and had no issues compiling the deployment package.

So, I don't know what issue you are having.

**

Incidentally, to submit a project, do not use an archiving program to 'zip' up the project directories.  Studio will do this for you.  Simply select Studio -> Export Projects... and Studio will prepare a zip file with one or more projects included.  The advantage of this approach is that Studio can then import the project without the need to manually unzip.

[#3]

Hello John,

I have issue when I select the sampledataflow2 or sampledataflow3 and hit the start button in order to execute the dataflow.

it listing me out the same error as posted before.

Read Details File - TRANSLITERATE-1007-A: Error converting field 'SalesOrderID' into attribute 'SalesOrderID': The input string '07/01/01' could not be converted to a type of 'integer'. The formatting parameters are 'unformatted' (SampleDataflow2.Step_1)

[#4]

This is the same issue in posts 7 and 8 above.

[#5]

Hello John,

Yes its the same as 7 and 8 post. Did you try to execute the Dataflow.

I try perform the work around with excel read files as same contents as they have in txt files.

And I find its working fine with excel file. So as conclusion its a issue with txt files.

I wish to figure out with txt files.

[#6]

There is a problem that I've reported to engineering.

When you add the second attribute to the composite type, do not create a mapping line between the input and output.  When I try to run your dataflows, I see the error.  After I remove the mapping lines for the RevisionNumber and SalesOrderDetailID entries, your dataflows run fine.

[#7]

Thanks John,

I try it and its working fine.

When can we expect the latest version of expressor.