Rowset contains "com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3" instead of data

Post any question you may have in regards to GoAnywhere MFT and let our talented support staff and other users assist you.
2 posts Page 1 of 1

pcbaart

Posts: 1
Joined: Wed Nov 07, 2018 9:47 am

Post by pcbaart » 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:
Code: Select all
<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>
Job Log:
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

Support_Josh

User avatar
Posts: 12
Joined: Thu Feb 16, 2017 11:20 am

Post by Support_Josh » Thu Nov 15, 2018 3:57 pm
I believe I can explain the behavior you are seeing.

Since you are using the Read Flat File task, there is no guarantee to MFT of how many rows and columns it will have to store. Therefore, MFT will create a rowset of pointers to account for the undetermined number both of rows and columns. That is why printing out the variable ${vFolderList} or ${vCurfolder} results in the output “com.linoma.ga.projects.tasks.converters.flatfile.FlatFileRowSet@7f80f2a3” or something similar as MFT is storing the pointer to the data rather than the data itself.

In order to get the data out of the inner rowset, you can use the Current Item variable subscripted by the first column to grab that cell of data. The correct notation for this is as follows: ${vCurfolder[1]}.

Give that a shot and you should see the correct output!
Joshua Przybysz
Senior Support Analyst
e. goanywhere.support@helpsystems.com
p. 1.800.949.4696
w. HelpSystems.com
2 posts Page 1 of 1