java.sql.SQLException: Column 'id' cannot be null in Joget log.
The error was caused by a missing id in the appDefinition.xml of the exported app.
To fix this, go to the exported app .jwa file and open appDefinition.xml, this requires you to search id one-by-one to check if there's an id with no value.Image Removed
Image Added
In the figure above, in line 1441, an Environment Variable id's value is not set. In this sample case, we will set the id with "test".
Image RemovedImage Added
Replace the "<id>test</id>" with the correctly declared one from your original app to avoid possible conflict / mismatch, save it in your .jwa file and test the app import again.