Hi @Anonymous User,
I know this is an old post but in case anyone else is running into this issue, I'm posting this update here:
If you have a multiple choice question with Other option where question name and one of the choices share more than 31 characters, question/choice names (field names) will be truncated when trying to create an offline area since the maximum field length is 30 characters in SQLite database, which will create two fields with the same name which causes failure.
In order to work around this issue, you can modify the schema in Survey123 website before publishing and rename the fields so that they have different names.
Similar issues may happen in other situations with Single Choice Grid questions so checking the attribute fields on the hosted feature layer in AGOL under Data tab will help identifying fields with names longer than 31 characters that may cause this issue.
Best,
MJ