[GUACAMOLE-1176] Using PL/SQL developer in the rdp protocol link cannot export a complete Excel file to a mapped disk.

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.0.0, 1.2.0
• Component/s: guacamole, RDP
• Environment: Debian GNU/Linux 7 (wheezy) ,windows server2012R2,PL/SQL developer 11.0.2
• Assignee: Unassigned
• Reporter: cpandx
• Created: 10/Sep/20 02:46
• Updated: 18/Jan/21 02:30

Description

Configure the rdp link to the windows2012server and use pl/sql developer to export the query results as an Excel file and found that only part of the data was transferred.
The log is as follows:

guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp" to "\test.xlsx.tmp".guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp" to "\test.xlsx.tmp".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp" as file_id=2guacd[3755]: DEBUG: guac_rdpdr_fs_process_create: [file_id=2] desired_access=0x80, file_attributes=0x0, create_disposition=0x1, create_options=0x200000, path="\test.xlsx.tmp"guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_basic_info: [file_id=2]guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=2]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp" (file_id=2)guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl\workbook.xml", access=0x80, file_attributes=0x0, create_disposition=0x1, create_options=0x200000guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl\workbook.xml" to "\test.xlsx.tmp\xl\workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl\workbook.xml" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl\workbook.xml" as file_id=3guacd[3755]: DEBUG: guac_rdpdr_fs_process_create: [file_id=3] desired_access=0x80, file_attributes=0x0, create_disposition=0x1, create_options=0x200000, path="\test.xlsx.tmp\xl\workbook.xml"guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_basic_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=3]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl\workbook.xml" (file_id=3)guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl", access=0x100001, file_attributes=0x0, create_disposition=0x1, create_options=0x21guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl" to "\test.xlsx.tmp\xl".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl" as file_id=2guacd[3755]: DEBUG: guac_rdpdr_fs_process_create: [file_id=2] desired_access=0x100001, file_attributes=0x0, create_disposition=0x1, create_options=0x21, path="\test.xlsx.tmp\xl"guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_directory: [file_id=2] initial_query=1, dir_pattern="\test.xlsx.tmp\xl\workbook.xml"guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl\workbook.xml", access=0x1, file_attributes=0x0, create_disposition=0x1, create_options=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl\workbook.xml" to "\test.xlsx.tmp\xl\workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl\workbook.xml" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl\workbook.xml" as file_id=3guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_both_directory_info: [file_id=3 (entry_name="workbook.xml")]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl\workbook.xml" (file_id=3)guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=2]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl" (file_id=2)guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl", access=0x100001, file_attributes=0x0, create_disposition=0x1, create_options=0x21guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl" to "\test.xlsx.tmp\xl".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl" as file_id=3guacd[3755]: DEBUG: guac_rdpdr_fs_process_create: [file_id=3] desired_access=0x100001, file_attributes=0x0, create_disposition=0x1, create_options=0x21, path="\test.xlsx.tmp\xl"guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_directory: [file_id=3] initial_query=1, dir_pattern="\test.xlsx.tmp\xl\workbook.xml"guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl\workbook.xml", access=0x1, file_attributes=0x0, create_disposition=0x1, create_options=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl\workbook.xml" to "\test.xlsx.tmp\xl\workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl\workbook.xml" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl\workbook.xml" as file_id=2guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_both_directory_info: [file_id=2 (entry_name="workbook.xml")]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl\workbook.xml" (file_id=2)guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=3]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl" (file_id=3)guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl\workbook.xml", access=0x80, file_attributes=0x0, create_disposition=0x1, create_options=0x200000guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl\workbook.xml" to "\test.xlsx.tmp\xl\workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl\workbook.xml" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl\workbook.xml" as file_id=2guacd[3755]: DEBUG: guac_rdpdr_fs_process_create: [file_id=2] desired_access=0x80, file_attributes=0x0, create_disposition=0x1, create_options=0x200000, path="\test.xlsx.tmp\xl\workbook.xml"guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_basic_info: [file_id=2]guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=2]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl\workbook.xml" (file_id=2)guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=4]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl" (file_id=4)guacd[3755]: DEBUG: guac_rdpdr_fs_process_set_end_of_file_info: [file_id=1] size=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_set_allocation_info: [file_id=1] size=0guacd[3755]: DEBUG: guac_rdp_fs_open: path="\test.xlsx.tmp\xl\workbook.xml", access=0x120089, file_attributes=0x80, create_disposition=0x1, create_options=0x60guacd[3755]: DEBUG: guac_rdp_fs_open: Normalized path "\test.xlsx.tmp\xl\workbook.xml" to "\test.xlsx.tmp\xl\workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: Translated path "\test.xlsx.tmp\xl\workbook.xml" to "/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml".guacd[3755]: DEBUG: guac_rdp_fs_open: native open: real_path="/var/log/simp_fort/session/share/159596279475519037624272/test.xlsx.tmp/xl/workbook.xml", flags=0x0guacd[3755]: DEBUG: guac_rdp_fs_open: Opened "\test.xlsx.tmp\xl\workbook.xml" as file_id=3guacd[3755]: DEBUG: guac_rdpdr_fs_process_create: [file_id=3] desired_access=0x120089, file_attributes=0x80, create_disposition=0x1, create_options=0x60, path="\test.xlsx.tmp\xl\workbook.xml"guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=30, offset=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=15, offset=30guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_read: [file_id=3] length=455, offset=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=271, offset=45guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=3]guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=30, offset=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=1]guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=3]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx.tmp\xl\workbook.xml" (file_id=3)guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=1]guacd[3755]: DEBUG: guac_rdpdr_fs_process_set_end_of_file_info: [file_id=1] size=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_set_allocation_info: [file_id=1] size=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=11, offset=46guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=57guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=24, offset=103guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=127guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=16, offset=173guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=189guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=17, offset=235guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=252guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=19, offset=298guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=317guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=26, offset=363guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=389guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=20, offset=435guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=455guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=13, offset=501guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=514guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=15, offset=560guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=22, offset=575guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=49, offset=597guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=1]guacd[3755]: DEBUG: guac_rdpdr_fs_process_query_standard_info: [file_id=1]guacd[3755]: DEBUG: guac_rdpdr_fs_process_set_end_of_file_info: [file_id=1] size=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_set_allocation_info: [file_id=1] size=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=0guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=11, offset=46guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=57guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=24, offset=103guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=127guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=16, offset=173guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=189guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=17, offset=235guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=252guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=19, offset=298guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=317guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=26, offset=363guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=389guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=20, offset=435guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=455guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=13, offset=501guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=46, offset=514guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=15, offset=560guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=22, offset=575guacd[3755]: DEBUG: guac_rdpdr_fs_process_write: [file_id=1] length=49, offset=597guacd[3755]: DEBUG: guac_rdpdr_fs_process_close: [file_id=1]guacd[3755]: DEBUG: guac_rdp_fs_close: Closed "\test.xlsx" (file_id=1)guacd[3755]: DEBUG: guac_rdp_fs_open: path="\", access=0x100081, file_attributes=0x0, create_disposition=0x1, create_options=0x20guacd[3755]: DEBUG: 

 

The detailed log information is too long to be placed in the attached log.log.

According to the log information, I guessed whether the Excel file was created according to certain rules when PL/SQL was exported, and many intermediate files were created to store data in the middle instead of directly reading and writing like copying files, resulting in incomplete Excel transmission.