As mentioned in the error-message message, the problem was aboutwith storing the metadata. So whatever this metadata actually is in this case, disabling the "Persist layer metadata"-option will make the export work and the DBF-file is created. Also ensure you uncheck any geometry-field from the export.
Finally the SHPT-field should be left empty (although that won't prevent the export from functioning, but just creates a table having an empty geometry-column).
Be aware, though, that the new table isn't directly added to the map even though the "Add saved file to map"-option option is active, probably because we didn't really create a shapefile, although we requested QGIS to do so. So you have to manually add it via Layer- -> Add Layer- ->Add> Add vector layer (strange, I know), and here you can add any arbitrary file:

