Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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)
This is the same issue in posts 7 and 8 above.
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.
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.
Thanks John,
I try it and its working fine.
When can we expect the latest version of expressor.