Have you tried with a different version of Android. Seems like this version is not compatible with your Android version. What version of Android are you using?
Please try the same version of the collect with a lower version of the collect and if that works, then it may be something to do with the android version 9. This is quite normal when a new version of OS or App version releases it may not compatible with each other and hope this will be fixed on the next release of collect if there is a bug.
This looks to me like you have a corrupt database file. What happens when you tap 'ok'? Did you run another ODK-derived client like KoboCollect before getting this error?
If you're able to tap ok and you don't have any unsubmitted data on your device, go to the top right three dots, Admin Settings and then Reset application.... Select "Saved forms" and reset. Any saved forms will be deleted so only do this if you don't have unsubmitted data. If you have unsubmitted data we can help you get it off another way.
It doesn't allow me click OK, trying to do that it closes up the app. This is also happening to Kobo collect. I don't have any data on there, just trying to learn ODK and set it up.
ODK Collect works well with Android 9. This is definitely a database corruption issue with this specific device.
Kobo Collect is an older version of ODK Collect that uses the same database so it can cause corruption when both are used on the same device. Start by uninstalling Kobo Collect. You shouldn't need it, again, it's just an old version of ODK Collect. Then kill ODK Collect. If you're not sure how to do this, this article should help. Relaunch ODK Collect and see if that works. I'm trying to force it to run a database migration if it hasn't.
If that doesn't work, you're going to need to remove your instances database file and I can write up some instructions for that.
I have installed Collect on my Huawei Tablet operating Android 7 and it works. But Collect still not working on its equivalent android 9 mobile phone even with force kill, its still not working
You will need to remove your instances database and let Collect regenerate it. I think the easiest way to do that is to browse to it using a file navigation app and delete it. You can see this article about how to navigate the files on your device. You will need to navigate to Device storage (may also be called "local storage"), then the odk folder, then the metadata folder. In that folder, you should see a file named instances.db. Delete that file and then launch Collect again.
Deleting that file means you will lose all status information about submissions so you won't know which are sent, which are unfinalized, when they were created, when their status last changed, etc. However, you won't lose any data.