After selecting a software in the Inventory Software page and clicking, Choose Action, then create report. An error will appear when saving the report:
mysqli error: [1054: Unknown column 'HAS_FILE' in 'order clause'] in EXECUTE( "select DISPLAY_NAME, PUBLISHER, DISPLAY, VERSION, (select count(distinct MACHINE_ID) from MACHINE_SOFTWARE_JT WHERE SOFTWARE_ID=SOFTWARE.ID) as MACHINES_AFFECTED from SOFTWARE left join SOFTWARE_LABEL_JT on SOFTWARE_LABEL_JT.SOFTWARE_ID = SOFTWARE.ID left join LABEL on LABEL.ID = SOFTWARE_LABE_JT.LABEL_ID where (1 = 1) group by SOFTWARE.ID order by HAS_FILE desc, DONT_REPLICATE desc, DISPLAY_NAME asc LIMIT 0")
This issue has been identified as K1C-3433.
The cause of the issue is due to an incorrect SQL coding sequence in the back end. The issue affects K1000 server versions 6.0, 6.2, and 6.3.