Bug 41791 - Xamarin Studio 6.0 and (iOS 9.3) broke AZURE MOBILE SERVICES !!!
Summary: Xamarin Studio 6.0 and (iOS 9.3) broke AZURE MOBILE SERVICES !!!
Status: RESOLVED ANSWERED
Alias: None
Product: iOS
Classification: Xamarin
Component: General ()
Version: XI 9.6 (iOS 9.3)
Hardware: Macintosh Mac OS
: --- normal
Target Milestone: Untriaged
Assignee: Bugzilla
URL:
Depends on:
Blocks:
 
Reported: 2016-06-14 10:48 UTC by Lars Bøggild
Modified: 2016-07-26 11:18 UTC (History)
2 users (show)

Tags:
Is this bug a regression?: ---
Last known good build:


Attachments
The ToDoItem project - changed to prove the error (50.24 KB, application/zip)
2016-06-14 10:48 UTC, Lars Bøggild
Details
Image running the app under the unified api. (54.58 KB, image/png)
2016-06-16 09:32 UTC, Manuel de la Peña [MSFT]
Details
Project ported to the unified API. (52.03 KB, application/zip)
2016-06-16 09:35 UTC, Manuel de la Peña [MSFT]
Details
Unified version - still failing... (478.65 KB, application/zip)
2016-06-16 13:07 UTC, Lars Bøggild
Details


Notice (2018-05-24): bugzilla.xamarin.com is now in read-only mode.

Please join us on Visual Studio Developer Community and in the Xamarin and Mono organizations on GitHub to continue tracking issues. Bugzilla will remain available for reference in read-only mode. We will continue to work on open Bugzilla bugs, copy them to the new locations as needed for follow-up, and add the new items under Related Links.

Our sincere thanks to everyone who has contributed on this bug tracker over the years. Thanks also for your understanding as we make these adjustments and improvements for the future.


Please create a new report on Developer Community or GitHub with your current version information, steps to reproduce, and relevant error messages or log files if you are hitting an issue that looks similar to this resolved bug and you do not yet see a matching new report.

Related Links:
Status:
RESOLVED ANSWERED

Description Lars Bøggild 2016-06-14 10:48:44 UTC
Created attachment 16312 [details]
The ToDoItem project - changed to prove the error

Xamarin Studio 6.0 and C7 (iOS 9.3) broke AZURE MOBILE SERVICES !!!

If a row is inserted and synced to AZURE with a total row size > 17.000 bytes - the sync fails (throws an exception) and the row is never updated in the AZURE database ….

The size limits for AZURE is 100K for a single column and 10 times that for the row, thus we are very far from reaching the AZURE size limits.

I currently have 3 FORMS project in production that uses AZURE Mobile Services with avarage rows size of 30k to 50k !! - Thus they are now broken…..

Note this still works fine for Android it is only broken in IOS - even thought the AZURE code is placed in a SAP project - common to both the Droid and IOS project - only the IOS projects are broken.

I have taken the AZURE/XAMARIN demo project (ToDoList) for AZURE Mobile Services and changed it a bit to prove this error - and it still shows the error…
(So the error exist for both FORMS and Native IOS) 

The ToDoList project - re-named to MSC is attached as documentation.

Run the MSC project and enter ex 18000 as the TEXT for the ToDoItem - and it will produce an ToDoItem with a dummy message of size 18000 - thus causing the error.

In case you have any questions do not hesitate to contact me - I will to all I can to get this error fixed as quickly as possible, since it has broken existing production project!!

Brgds lars
Comment 1 Manuel de la Peña [MSFT] 2016-06-16 09:31:52 UTC
Hello,

Looking at the attached project, I had to update it to use the unified API. Once I did that the project worked as expected. I compiled the project, launched it in the simulator and entered "18000" as the text. I am attaching the modified project and the image of the simulator running you application.

Please can you test the unified project and let me know if you do have the issue. Also, please confirm that I just needed to add "18000" as the text.
Comment 2 Manuel de la Peña [MSFT] 2016-06-16 09:32:25 UTC
Created attachment 16356 [details]
Image running the app under the unified api.
Comment 3 Manuel de la Peña [MSFT] 2016-06-16 09:35:06 UTC
Created attachment 16357 [details]
Project ported to the unified API.
Comment 4 Lars Bøggild 2016-06-16 13:07:05 UTC
Created attachment 16364 [details]
Unified version - still failing...

Hi Manuel,

I tried running your unified version - it still fails.
Then i unified the project myself - that requested the packets to be "retarget". I did that but the retarget did not work correctly.
I then started all over - took an old copy - unified it - remove all packets and installed them again. (That worked).
Only the error still persist !!!

I will attache the new unified version (MSC-Unififed2.zip) 

Please check that if this works for you.

If you are using my Azure database - i cannot see any items larger than  17000 in there??

Try this:

1 ) Change the local dba name to ex "localstore301.db"
2 ) run the program and enter 1234 then press the +
3 ) Stop the program and change the local dba name again ("localstore302.db")
4 ) Start the program you still see 1234 in the list of items (sync down from Azure since you have changed the local dba name).
5) Now enter 18123 then press the +
6) Stop the program and change the dba name again ("localstore303.db")
7) Start the program - now you still only see 1234 - 18124 is missing since it failed to sync up to the azure dba.

new I have cleared the dba - so its now empty meaning all entries will be entered by you.

If you need me to monitor the dba - while you test - please just call me at +45 26353294

Brgds lars
Comment 5 Manuel de la Peña [MSFT] 2016-06-20 10:38:47 UTC
Hello,

When trying your new project on Xamarin Studio 6.0 I had to do the following to be able to compile it:

1. Remove references to those dlls that are coming from gnugets.
2. Remove the gnugets of Microsoft Azure, SQLitePCL, Newtonsoft.Json and re-add them to the project. The versions numbers of the packages are:
    * Microsoft.Azure.Mobile.Client - 2.0.0
    * Microsoft.Azure.Mobile.Client.SQLiteStore - 2.0.1
    * SQLitePCL - 3.8.7.2
    * Newtonsoft.Json - 8.0.3

After doing so I had to update your code because the constructor of the MobileServiceClient does not longer take the app key as per https://msdn.microsoft.com/en-us/library/azure/microsoft.windowsazure.mobileservices.mobileserviceclient(v=azure.10).aspx

Can you please either test you application with the latests Azure client or provide the exact version numbers to use.
Comment 6 Lars Bøggild 2016-06-20 16:15:53 UTC
Hi Manuel,

I can see you changed the packet from ³Azure Mobile Services² to ³Azure
Mobile Services Client² - thus you had to remove the API-KEY.
However, without the API-KEY you cannot access the AZURE database!

How do you envision this to work? - Its a different API all together
(How did you supply AZURE with API-KEY in your version?)

The unified version I attached to the bugzilla report 41791 should contain
the very latest NuGet packets.

I have updated ALL the packages - and the error still persist..

I attach the latest packages.config for ref

I you need you can send my your work phone no - in this mail an I can call
you


Brgds
Lars
PS: Note that this bug was first detected in a existing Forms Apps -
running the Unified API. - I only made the small MSC app for easy testing.

<?xml version="1.0" encoding="utf-8"?>
<packages>
  <package id="Microsoft.Bcl" version="1.1.10" targetFramework="xamarinios10" />
  <package id="Microsoft.Bcl.Build" version="1.0.21" targetFramework="xamarinios10" />
  <package id="Microsoft.Net.Http" version="2.2.29" targetFramework="xamarinios10" />
  <package id="Newtonsoft.Json" version="8.0.3" targetFramework="xamarinios10" />
  <package id="SQLitePCL" version="3.8.7.2" targetFramework="xamarinios10" />
  <package id="WindowsAzure.MobileServices" version="1.3.2" targetFramework="xamarinios10" />
  <package id="WindowsAzure.MobileServices.SQLiteStore" version="1.0.4" targetFramework="xamarinios10" />
</packages>
Comment 7 Manuel de la Peña [MSFT] 2016-06-23 14:15:04 UTC
Hello, let me take a look again and see what is the issues. Sorry for the confusion regarding the azure libs
Comment 8 Lars Bøggild 2016-07-26 07:37:26 UTC
Hi Manuel,

Any progress on this bug?

We really really need it soon...

Let me know if there is anything I can do to help....

brgds lars
Comment 9 Manuel de la Peña [MSFT] 2016-07-26 09:05:35 UTC
Using the provided solution and with the following env I cannot reproduce the issue:

=== Xamarin Studio Business ===

Version 6.1 (build 4373)
Installation UUID: 01060673-5bee-4cf4-a4c2-5e36a18d39a2
Runtime:
	Mono 4.4.1 (mono-4.4.0-branch-c7sr0/4747417) (64-bit)
	GTK+ 2.24.23 (Raleigh theme)

	Package version: 404010000

=== Xamarin.Profiler ===

Not Installed

=== Xamarin.Android ===

Version: 6.1.1.1 (Xamarin Business)
Android SDK: /Users/mandel/Library/Developer/Xamarin/android-sdk-macosx
	Supported Android versions:
		4.0.3 (API level 15)
		4.3   (API level 18)
		4.4   (API level 19)
		5.0   (API level 21)
		6.0   (API level 23)

SDK Tools Version: 25.1.6
SDK Platform Tools Version: 24.0.0
SDK Build Tools Version: 23.0.2

Java SDK: /usr
java version "1.7.0_71"
Java(TM) SE Runtime Environment (build 1.7.0_71-b14)
Java HotSpot(TM) 64-Bit Server VM (build 24.71-b01, mixed mode)

Android Designer EPL code available here:
https://github.com/xamarin/AndroidDesigner.EPL

=== Xamarin Android Player ===

Version: 0.6.5
Location: /Applications/Xamarin Android Player.app

=== Apple Developer Tools ===

Xcode 7.3 (10183.3)
Build 7D175

=== Xamarin.Mac ===

Version: 2.8.1.4 (Xamarin Business)

=== Xamarin.iOS ===

Version: 9.8.1.4 (Xamarin Business)
Hash: 3cf8aae
Branch: c7sr0
Build date: 2016-06-20 16:09:58-0400

=== Build Information ===

Release ID: 601004373
Git revision: 852a87304bbbd9c26e81bbb2428dafc6145f1601
Build date: 2016-05-31 01:09:06-04
Xamarin addins: d6b49aee9d3b2f75a1eea84b8ad3b2d1d4fd77c0
Build lane: monodevelop-lion-master

=== Operating System ===

Mac OS X 10.11.5
Darwin Mandels-Pro-Work.local 15.5.0 Darwin Kernel Version 15.5.0
    Tue Apr 19 18:36:36 PDT 2016
    root:xnu-3248.50.21~8/RELEASE_X86_64 x86_64

=== Enabled user installed addins ===

Addin Maker 1.3.2
StyleCop Support 1.0.1.9
Manifest.addin 0.0.0.0

Lars, can you please provide the same information from your system to better asses in which version is this happening?
Comment 10 Lars Bøggild 2016-07-26 09:58:55 UTC
=== Xamarin Studio Community ===

Version 6.0 (build 5174)
Installation UUID: 70b919d4-262c-4dd1-b601-11f3efc492a3
Runtime:
	Mono 4.4.0 (mono-4.4.0-branch-c7-baseline/5995f74) (64-bit)
	GTK+ 2.24.23 (Raleigh theme)

	Package version: 404000182

=== Xamarin.Profiler ===

Not Installed

=== Apple Developer Tools ===

Xcode 7.3.1 (10188.1)
Build 7D1014

=== Xamarin.iOS ===

Version: 9.8.0.323 (Xamarin Studio Community)
Hash: 39ebb77
Branch: cycle7
Build date: 2016-06-01 21:23:15-0400

=== Xamarin.Android ===

Version: 6.1.0.71 (Xamarin Studio Community)
Android SDK: /Users/LKB/Library/Developer/Xamarin/android-sdk-mac_x86
	Supported Android versions:
		2.3   (API level 10)
		4.0.3 (API level 15)
		4.4   (API level 19)
		5.0   (API level 21)
		5.1   (API level 22)
		6.0   (API level 23)

SDK Tools Version: 25.1.7
SDK Platform Tools Version: 23.1
SDK Build Tools Version: 22.0.1

Java SDK: /usr
java version "1.7.0_71"
Java(TM) SE Runtime Environment (build 1.7.0_71-b14)
Java HotSpot(TM) 64-Bit Server VM (build 24.71-b01, mixed mode)

Android Designer EPL code available here:
https://github.com/xamarin/AndroidDesigner.EPL

=== Xamarin Android Player ===

Not Installed

=== Xamarin.Mac ===

Not Installed

=== Build Information ===

Release ID: 600005174
Git revision: 694a75f040b7f2309bc43d4f78a3a6572ca898bf
Build date: 2016-06-01 17:28:08-04
Xamarin addins: 33f406fa2dcf214012c78cb846585f062b2e1d24
Build lane: monodevelop-lion-cycle7-baseline

=== Operating System ===

Mac OS X 10.11.5
Darwin Larss-MacBook-Pro.local 15.5.0 Darwin Kernel Version 15.5.0
    Tue Apr 19 18:36:36 PDT 2016
    root:xnu-3248.50.21~8/RELEASE_X86_64 x86_64
Comment 11 Lars Bøggild 2016-07-26 10:03:38 UTC
Hi Manuel

Did you follow these steps:

Try this:
1 ) Change the local dba name to ex "localstore301.db"
2 ) run the program and enter 1234 then press the +
3 ) Stop the program and change the local dba name again ("localstore302.db")
4 ) Start the program you still see 1234 in the list of items (sync down from Azure since you have changed the local dba name).
5) Now enter 18123 then press the +
6) Stop the program and change the dba name again ("localstore303.db")
7) Start the program - now you still only see 1234 - 18124 is missing since it failed to sync up to the azure dba.

And could you see/verify that the AZURE database actually got updated with an entry exceeding 18123 bytes?  (or by looking at the AZURE database using the AZURE web access showing the content of the database) ?

brgds lars
Comment 12 Lars Bøggild 2016-07-26 10:51:51 UTC
Hi Manuel,

God news - updating to the below suddenly made every thing work!!
First i testing using the old versions and it still failed, then i updated to the latest versions - just like you have, and now it works...

Perfect - I do not know what specific update makes the difference, but I guess its Xamarin IOS 9.8.1.4.

Thanks for all you help.

Brgds lars 


=== Xamarin Studio Community ===

Version 6.0.1 (build 9)
Installation UUID: 70b919d4-262c-4dd1-b601-11f3efc492a3
Runtime:
	Mono 4.4.1 (mono-4.4.0-branch-c7sr0/4747417) (64-bit)
	GTK+ 2.24.23 (Raleigh theme)

	Package version: 404010000

=== Xamarin.Profiler ===

Not Installed

=== Xamarin.Android ===

Version: 6.1.1.1 (Xamarin Studio Community)
Android SDK: /Users/LKB/Library/Developer/Xamarin/android-sdk-mac_x86
	Supported Android versions:
		2.3   (API level 10)
		4.0.3 (API level 15)
		4.4   (API level 19)
		5.0   (API level 21)
		5.1   (API level 22)
		6.0   (API level 23)

SDK Tools Version: 25.1.7
SDK Platform Tools Version: 23.1
SDK Build Tools Version: 22.0.1

Java SDK: /usr
java version "1.7.0_71"
Java(TM) SE Runtime Environment (build 1.7.0_71-b14)
Java HotSpot(TM) 64-Bit Server VM (build 24.71-b01, mixed mode)

Android Designer EPL code available here:
https://github.com/xamarin/AndroidDesigner.EPL

=== Xamarin Android Player ===

Not Installed

=== Apple Developer Tools ===

Xcode 7.3.1 (10188.1)
Build 7D1014

=== Xamarin.iOS ===

Version: 9.8.1.4 (Xamarin Studio Community)
Hash: 3cf8aae
Branch: c7sr0
Build date: 2016-06-20 16:09:58-0400

=== Xamarin.Mac ===

Not Installed

=== Build Information ===

Release ID: 600010009
Git revision: e879ce52093257c5c386ad7e390dfaa937fa7f90
Build date: 2016-06-24 11:53:43-04
Xamarin addins: a9252e6df4851fbbed1f9c6228e7b6dd1b475ac5
Build lane: monodevelop-lion-cycle7-sr0

=== Operating System ===

Mac OS X 10.11.5
Darwin Larss-MacBook-Pro.local 15.5.0 Darwin Kernel Version 15.5.0
    Tue Apr 19 18:36:36 PDT 2016
    root:xnu-3248.50.21~8/RELEASE_X86_64 x86_64
Comment 13 Manuel de la Peña [MSFT] 2016-07-26 11:18:08 UTC
Probably it was a regression that was found. Will close the bug.