View Issue Details

IDProjectCategoryView StatusLast Update
0004342SymmetricDSBugpublic2020-05-20 13:30
Reporterjordanl010Assigned Toelong 
Priorityhigh 
Status feedbackResolutionopen 
Product Version3.11.7 
Target VersionFixed in Version 
Summary0004342: Could not find the target table
Descriptionhave a new issue that I am not sure if it's a bug or what. I have an android phone thats running symmetricds syncing up to a server installation. I let the phone run all weekend and noticed the android app crashed due to something that was unrelated to symmetric ds. Anyways, I reinstalled my android app and let it go through the initialization for symmetric again and now I cannot get past the error of "The incoming batch 000-9542 failed: Could not find the target table 'android_log'" on the server side and then "Could not find any database tables matching 'android_log' in the datasource that is configured" on the android side.

prior to this error showing, the initial load create first is set to true and it always created those tables that its saying it could not find

but now its stuck and cannot get to the point of creating those tables for some reason

ALSO: in the server DB the sym_table_reload_request table has a null load_id and after 45 minutes of waiting, no updates to that table.
TagsNo tags attached.

Activities

jordanl010

2020-04-13 11:17

reporter  

corp-000 (6).properties (475 bytes)

jordanl010

2020-04-13 11:19

reporter   ~0001697

And here is my insert seed:

insert_sample (4).sql (14,934 bytes)

jordanl010

2020-04-13 11:25

reporter  

android_log.txt (458,975 bytes)

jordanl010

2020-04-13 11:28

reporter  

symmetric (2).log (12,270 bytes)

jordanl010

2020-04-13 15:31

reporter   ~0001698

It's definitely odd, something in a database that I have not come across yet seems to be hanging this up. Prior to this bug, I would uninstall the mobile app, install the app, and it would reinitialize and pull down the xml configurations for the three tables I need that it is barking about saying it's not found.

jordanl010

2020-04-20 10:16

reporter   ~0001704

Anyone have any time to check this one out yet?

jordanl010

2020-04-30 10:30

reporter   ~0001711

Anyone?

elong

2020-05-01 17:11

developer   ~0001712

The initial load should create tables like employee_location on the Android SQLite database. I don't see that activity in the logs though. I see an initial load is requested, but I don't see it queue up. Maybe you should try clearing sym_table_reload_request and sym_table_reload_status and start over.

I also see a bunch of "Skipping batch 4A549477EDFF-6 that was already loaded". That sounds like you blew away the client but left the state on the server. You need to clear that node out of the server. See "symadmin remove-node".

I don't think this issue sounds like a bug, unless we find some improvement to make it easier to use or diagnose. It's probably better as a forum discussion.

Issue History

Date Modified Username Field Change
2020-04-13 11:17 jordanl010 New Issue
2020-04-13 11:17 jordanl010 File Added: corp-000 (6).properties
2020-04-13 11:17 jordanl010 File Added: Screenshot from 2020-04-13 11-16-58.png
2020-04-13 11:19 jordanl010 File Added: insert_sample (4).sql
2020-04-13 11:19 jordanl010 Note Added: 0001697
2020-04-13 11:25 jordanl010 File Added: android_log.txt
2020-04-13 11:28 jordanl010 File Added: symmetric (2).log
2020-04-13 15:31 jordanl010 Note Added: 0001698
2020-04-20 10:16 jordanl010 Note Added: 0001704
2020-04-30 10:30 jordanl010 Note Added: 0001711
2020-05-01 17:11 elong Note Added: 0001712
2020-05-20 13:30 elong Assigned To => elong
2020-05-20 13:30 elong Status new => feedback