lkptable.blogg.se

Mobile has lost connection (gone offline immediately etc.) after sending the data to WebAPI layer (SQL Server DB) so acknowledgement not recieved by mobile app. I should read the data from STAGING tables every 5 mins and do some processing and then save, successfully validated data in main tables. STG_FORMDATA (No keys, all are nullable fields, to ingest all records from the devices) ID - GUID

SQLite should also have the same structure (except RecordUploadedDate column). It just needs to submit data to server, it's job is over.ĭBSchema for the tables is here. Mobile App doesn't have to worry about the data validations on the server side. We don't want the devices to wait till whole data is processed. Based on this acknowledgement, the mobileĪpp can delete the data in its local db tables(SQLite). And then a success message will be sent to the device - "Data submitted successfully".

Once the WebAPIs receive data, we are saving in two STAGING_FORMDATA and STAGING_PHOTOGRAPH tables in SQL Server 2014. There is a relationship exists between FORM DATA table and Photograph table in mobile db (SQLite) using GUID. To receive only photographs related to a FORM To receive the FORM DATA (all text fields) in json format When the user comes online, locally stored data will be sent to SQL Server 2014 via WebAPIs. The users submit the forms in their devices (Android, iOS mobile phones & Apple tab) and the data will be stored in the local db (SQLite). The mobile app is also supporting offline mode. Hit Nextĥ.I have a mobile application where users fill and submit a form (all are text fields) with few photographs. Check all the options: Domain, Private and, Public. Now select the “Allow the connection” option.Enter 1433 in the “specific local ports” and hit Next.Select the Inbound Rules and click on the New Rules as shown in figure.If port is disabled then, go to control panel-> Administrative tool- >select “Windows firewall with advanced security”.Go to SQL Server instance property and check the option “Allow remote connections to this server”. You can check the remote connection by following: Open SSMS-> Connect with SQL server using SSMS.Check the connection strings and check that you are trying to connect with the correct server.To check the SQL Server, just enter “services.msc” command.IP address of the instance has been blocked.Ĭheck the solutions for each issue below:.