Error messages "could not find user by id or identity"/"unable to locate user in this version"

General
1

Backendless Version (3.x / 5.x, Online / Managed / Pro )

Client SDK (REST / Android / Objective-C / Swift / JS )

Application ID: 78F75A56-2A68-C11B-FFD7-2EAB41C0CB00

Expected Behavior

Please describe the expected behavior of the issue, starting from the first action.

1.Four users added via CSV file in zip folder. Unique identifiers are utn = 830401001, 830402001, 830403001 and 830404001.
2.Some error occurred during upload
3.Now we can’t amend or delete these users in any way
4. We uploaded them again using same CSV template/zip - same result, now duplicates of all four visible/searchable on Backendless dashboard but not on our remote terminals.

Actual Behavior

  1. These 8 users are not amendable or deletable - attempts generate one of the error messages shown in the subject line.
  2. We uploaded one of them again using Backendless dashboard > New function. This one is amendable and deletable but is not accessible by our remote terminals unlike all other users in the app.

Reproducible Test Case

Please provide a simple code that could be run in a new clean app and reproduce the issue.
Sorry I don’t know how to do that!
Action requested:

  1. BE team, please delete all these “ghost” users. Search for them in the utn column and remove them entirely.
  2. Tell us what might have caused this error so we don’t repeat it.
  3. Tell us how, if it did occur again, we could delete them.
2

Hello @Educators_International,

2.Some error occurred during upload
Could you attach a log with the error?

using the query:

utn in ('830401001', '830402001', '830403001','830404001')

I see 9 users, should we remove all of them? I am asking because you have reported about 8 users.

3

Yes Please.

when I uploaded these users this was the log report:

16:35:18 IMPORT_DATA Importing Started.
16:35:18 IMPORT_DATA Preparing files to import
16:35:18 IMPORT_DATA Copying of Users.csv, size: 0.0 MiB.
16:35:18 IMPORT_DATA Creating temporary tables
16:35:18 IMPORT_DATA Creating user’s tables
16:35:18 IMPORT_DATA Preparing Users table: initializing columns.
16:35:22 IMPORT_DATA Preparing Users table: updating column related IDs.
16:35:22 IMPORT_DATA Preparing Users table: initializing relations.
16:35:22 IMPORT_DATA Checking denied and duplicate columns.
16:35:22 IMPORT_DATA Resolving related table.
16:35:22 IMPORT_DATA Getting meta-info about insetable tables.
16:35:22 IMPORT_DATA Start import table: Users
16:35:22 IMPORT_DATA Ignores rows with values [P4, null, 36949, Adongo Bawa, 36949, 542036949, 50731 Excellence College , 5073140008, , , , , 1].
Invalid date format
16:35:22 IMPORT_DATA Table ‘Users’ was imported at 0 seconds. Saved 0 records.
16:35:22 IMPORT_DATA Finish import table: Users
16:35:22 IMPORT_DATA Started restoring relations.
16:35:22 IMPORT_DATA Clearing user data table cache.
16:35:23 IMPORT_DATA Deleting temporary tables.
16:35:23 IMPORT_DATA Finishing pointers export.
16:35:23 IMPORT_DATA Restoring expiration tasks for DeviceRegistrations.
16:35:23 IMPORT_DATA Importing Finished.

4

It says that you have provided invalid date, make sure that csv file contains correct date.

do you created csv file by your self, or exported from backendless app?

5

It was the same csv file that I used to upload all the previous users.

6

Furthermore the same issue has arisen for a different country. The utns to be removed from there are:
10261411001
1026141001

7

The log for the users upload for that issue is:
09:58:52 IMPORT_DATA Importing Started.
09:58:52 IMPORT_DATA Preparing files to import
09:58:52 IMPORT_DATA Copying of Users.csv, size: 0.0 MiB.
09:58:52 IMPORT_DATA Creating temporary tables
09:58:52 IMPORT_DATA Creating user’s tables
09:58:52 IMPORT_DATA Preparing Users table: initializing columns.
09:58:55 IMPORT_DATA Preparing Users table: updating column related IDs.
09:58:55 IMPORT_DATA Preparing Users table: initializing relations.
09:58:55 IMPORT_DATA Checking denied and duplicate columns.
09:58:55 IMPORT_DATA Resolving related table.
09:58:55 IMPORT_DATA Getting meta-info about insetable tables.
09:58:55 IMPORT_DATA Start import table: Users
09:58:55 IMPORT_DATA Table ‘Users’ was imported at 0 seconds. Saved 1 records.
09:58:55 IMPORT_DATA Finish import table: Users
09:58:55 IMPORT_DATA Started restoring relations.
09:58:55 IMPORT_DATA Importing 1 relations.
09:58:55 IMPORT_DATA Importing 1 relations from ‘Users(adminClasses)’ to ‘Users’.
09:58:55 IMPORT_DATA Cannot insert big 10k batch for table 8CBF116D-D211-CFEB-F.8CBF116D-D211-CFEB-F.4946C
09:58:55 IMPORT_DATA Cannot insert 1k batch for table 8CBF116D-D211-CFEB-F.8CBF116D-D211-CFEB-F.4946C
09:58:56 IMPORT_DATA Cannot insert relation for table 8CBF116D-D211-CFEB-F.8CBF116D-D211-CFEB-F.4946C.
SQL [insert into 8CBF116D-D211-CFEB-F.8CBF116D-D211-CFEB-F.4946C values (?, ?) on duplicate key update rel_from = ?, rel_to = ?]; Cannot add or update a child row: a foreign key constraint fails (BD0781FE-AEF5-99A8-FF85-80DFCC400700.8CBF116D-D211-CFEB-F.8CBF116D-D211-CFEB-F.4946C, CONSTRAINT 6BF746FD-CAAA-1FA3-FFB7-D6155EDB8D00_ibfk_1 FOREIGN KEY (rel_from) REFERENCES `udt.User)
09:58:56 IMPORT_DATA Imported 0 relations from ‘Users(adminClasses)’ to ‘Users’.
09:58:56 IMPORT_DATA Total imported relations: 0
09:58:56 IMPORT_DATA Clearing user data table cache.
09:58:56 IMPORT_DATA Deleting temporary tables.
09:58:56 IMPORT_DATA Finishing pointers export.
09:58:56 IMPORT_DATA Start import pointers for table: Users
09:58:56 IMPORT_DATA Finished import of table: Users
09:58:56 IMPORT_DATA Restoring expiration tasks for DeviceRegistrations.
09:58:56 IMPORT_DATA Importing Finished.

8

please attach zip or csv file that you try to import

9

I was able to remove this objects using bulk delete operation with query

0D02EF15-354B-4976-BAC0-AF7BDE8D4D74