Rowset contains "com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3" instead of data
Posted: Thu Nov 08, 2018 11:41 am
Could anybody give some solution for the below described issue?
I am using Read Flat File and subsequently select and print the different rows.
The content of the rows are not the values of the inputfile, but: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@6cff5077
Project XML:
2018-11-07 19:03:49 INFO Start Date and Time: 2018-11-07 19:03:49
2018-11-07 19:03:49 INFO Job Number: 1000000010746
2018-11-07 19:03:49 INFO Project Name: /ontw/list folders2
2018-11-07 19:03:49 INFO Submitted By: root
2018-11-07 19:03:49 INFO Submitted From: Administrator UI
2018-11-07 19:03:49 INFO GoAnywhere 5.7.4 running on Windows Server 2012 6.2 (amd64)
2018-11-07 19:03:49 INFO Executing project 'list folders2'
2018-11-07 19:03:49 INFO Project location: \\productie.umca.nl\app\GoAnywhere\ACC\userdata\projects\ontw\list folders2.xml
2018-11-07 19:03:49 INFO Executing module 'Main'
2018-11-07 19:03:49 INFO Executing task 'createWorkspace 1.0'
2018-11-07 19:03:49 INFO Workspace directory for this job is set to '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746'.
2018-11-07 19:03:49 INFO Finished task 'createWorkspace 1.0'
2018-11-07 19:03:49 INFO Executing task 'print 1.0 (make dirlist command)'
2018-11-07 19:03:49 INFO Finished task 'print 1.0 (make dirlist command)'
2018-11-07 19:03:49 INFO Executing task 'exec 1.0 (determine subfolders)'
2018-11-07 19:03:49 INFO Preparing to execute the native command '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.bat'
2018-11-07 19:03:49 INFO
2018-11-07 19:03:49 INFO C:\Program Files\HelpSystems\GoAnywhere>dir \\amc.intra\opslag\onderzoek\divg\kg\MFT\acceptatie\Test /AD /B 1>\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.txt
2018-11-07 19:03:50 INFO The native command '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.bat' finished with a return code of '0'
2018-11-07 19:03:50 INFO Finished task 'exec 1.0 (determine subfolders)'
2018-11-07 19:03:50 INFO Executing task 'readFlatFile 1.0 (read subfolders)'
2018-11-07 19:03:50 INFO Data parsed successfully and the rowset variable 'vFolderList' was created
2018-11-07 19:03:50 INFO Finished task 'readFlatFile 1.0 (read subfolders)'
2018-11-07 19:03:50 INFO Entering loop 'forEachLoop (for each subfolder found)'
2018-11-07 19:03:50 INFO Opening file '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.txt'
2018-11-07 19:03:50 INFO Executing task 'print 1.0'
2018-11-07 19:03:50 INFO folder we could delete: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3
2018-11-07 19:03:50 INFO Finished task 'print 1.0'
2018-11-07 19:03:50 INFO Executing task 'print 1.0'
2018-11-07 19:03:50 INFO folder we could delete: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3
2018-11-07 19:03:50 INFO Finished task 'print 1.0'
2018-11-07 19:03:50 INFO Executing task 'print 1.0'
2018-11-07 19:03:50 INFO folder we could delete: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3
2018-11-07 19:03:50 INFO Finished task 'print 1.0'
2018-11-07 19:03:50 INFO Exiting loop 'forEachLoop (for each subfolder found)'
2018-11-07 19:03:50 INFO Executing task 'deleteWorkspace 1.0'
2018-11-07 19:03:50 INFO Workspace directory '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746' was deleted successfully
2018-11-07 19:03:50 INFO Finished task 'deleteWorkspace 1.0'
2018-11-07 19:03:50 INFO Finished module 'Main'
2018-11-07 19:03:50 INFO Finished project 'list folders2'
2018-11-07 19:03:50 INFO End Date and Time: 2018-11-07 19:03:50
I am using Read Flat File and subsequently select and print the different rows.
The content of the rows are not the values of the inputfile, but: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@6cff5077
Project XML:
Code: Select all
Job Log:<project name="list folders2" mainModule="Main" version="2.0" logLevel="verbose">
<module name="Main" description="List subfolders and delete them">
<createWorkspace version="1.0" />
<print label="make dirlist command" file="${system.job.workspace}\dirlist.bat" version="1.0">
<![CDATA[dir \\amc.intra\opslag\onderzoek\divg\kg\MFT\acceptatie\Test /AD /B > ${system.job.workspace}\dirlist.txt]]>
</print>
<exec label="determine subfolders" executable="${system.job.workspace}\dirlist.bat" version="1.0" disabled="false" />
<readFlatFile label="read subfolders" inputFile="${system.job.workspace}\dirlist.txt" outputRowSetVariable="vFolderList" recordDelimiter="LF" trim="both" version="1.0" logLevel="verbose" disabled="false" />
<print version="1.0">
<![CDATA[${vFolderList}]]>
</print>
<forEachLoop label="for each subfolder found" itemsVariable="${vFolderList}" currentItemVariable="vCurfolder" logLevel="verbose" disabled="false">
<print version="1.0">
<![CDATA[folder we could delete: ${vCurfolder}]]>
</print>
<delete dir="${folder}" version="1.0" disabled="true" />
</forEachLoop>
</module>
</project>
2018-11-07 19:03:49 INFO Start Date and Time: 2018-11-07 19:03:49
2018-11-07 19:03:49 INFO Job Number: 1000000010746
2018-11-07 19:03:49 INFO Project Name: /ontw/list folders2
2018-11-07 19:03:49 INFO Submitted By: root
2018-11-07 19:03:49 INFO Submitted From: Administrator UI
2018-11-07 19:03:49 INFO GoAnywhere 5.7.4 running on Windows Server 2012 6.2 (amd64)
2018-11-07 19:03:49 INFO Executing project 'list folders2'
2018-11-07 19:03:49 INFO Project location: \\productie.umca.nl\app\GoAnywhere\ACC\userdata\projects\ontw\list folders2.xml
2018-11-07 19:03:49 INFO Executing module 'Main'
2018-11-07 19:03:49 INFO Executing task 'createWorkspace 1.0'
2018-11-07 19:03:49 INFO Workspace directory for this job is set to '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746'.
2018-11-07 19:03:49 INFO Finished task 'createWorkspace 1.0'
2018-11-07 19:03:49 INFO Executing task 'print 1.0 (make dirlist command)'
2018-11-07 19:03:49 INFO Finished task 'print 1.0 (make dirlist command)'
2018-11-07 19:03:49 INFO Executing task 'exec 1.0 (determine subfolders)'
2018-11-07 19:03:49 INFO Preparing to execute the native command '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.bat'
2018-11-07 19:03:49 INFO
2018-11-07 19:03:49 INFO C:\Program Files\HelpSystems\GoAnywhere>dir \\amc.intra\opslag\onderzoek\divg\kg\MFT\acceptatie\Test /AD /B 1>\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.txt
2018-11-07 19:03:50 INFO The native command '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.bat' finished with a return code of '0'
2018-11-07 19:03:50 INFO Finished task 'exec 1.0 (determine subfolders)'
2018-11-07 19:03:50 INFO Executing task 'readFlatFile 1.0 (read subfolders)'
2018-11-07 19:03:50 INFO Data parsed successfully and the rowset variable 'vFolderList' was created
2018-11-07 19:03:50 INFO Finished task 'readFlatFile 1.0 (read subfolders)'
2018-11-07 19:03:50 INFO Entering loop 'forEachLoop (for each subfolder found)'
2018-11-07 19:03:50 INFO Opening file '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746\dirlist.txt'
2018-11-07 19:03:50 INFO Executing task 'print 1.0'
2018-11-07 19:03:50 INFO folder we could delete: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3
2018-11-07 19:03:50 INFO Finished task 'print 1.0'
2018-11-07 19:03:50 INFO Executing task 'print 1.0'
2018-11-07 19:03:50 INFO folder we could delete: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3
2018-11-07 19:03:50 INFO Finished task 'print 1.0'
2018-11-07 19:03:50 INFO Executing task 'print 1.0'
2018-11-07 19:03:50 INFO folder we could delete: com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3
2018-11-07 19:03:50 INFO Finished task 'print 1.0'
2018-11-07 19:03:50 INFO Exiting loop 'forEachLoop (for each subfolder found)'
2018-11-07 19:03:50 INFO Executing task 'deleteWorkspace 1.0'
2018-11-07 19:03:50 INFO Workspace directory '\\productie.umca.nl\app\GoAnywhere\ACC\userdata\workspace\1000000010746' was deleted successfully
2018-11-07 19:03:50 INFO Finished task 'deleteWorkspace 1.0'
2018-11-07 19:03:50 INFO Finished module 'Main'
2018-11-07 19:03:50 INFO Finished project 'list folders2'
2018-11-07 19:03:50 INFO End Date and Time: 2018-11-07 19:03:50