SQLite file exception

[chris]

Hey All

Loving the new CloudSync feature, but I'm having issues when using SQLite(I installed through extension manager).
I'm using the tutorials online, but when I deploy to the phone I have a file exception when trying to Add then sync an item at the line:

await tasksContext.AddAsync(task);

I'm wondering if this is just a setup issue?

Hope you can help.
Here is the stack trace:

Message "The specified module could not be found. (Exception from HRESULT: 0x8007007E)" string

   at System.StubHelpers.StubHelpers.GetWinRTFactoryObject(IntPtr pCPCMD)
   at Sqlite.Sqlite3.sqlite3_open_v2(String filename, Database& db, Int32 flags, String zVfs)
   at SQLite.SQLite3.Open(String filename, Database& db, Int32 flags, IntPtr zVfs)
   at SQLite.SQLiteConnection..ctor(String databasePath, SQLiteOpenFlags openFlags, Boolean storeDateTimeAsTicks)
   at SQLite.SQLiteConnection..ctor(String databasePath, Boolean storeDateTimeAsTicks)
   at SQLite.SQLiteConnectionWithLock..ctor(SQLiteConnectionString connectionString)
   at SQLite.SQLiteConnectionPool.Entry..ctor(SQLiteConnectionString connectionString)
   at SQLite.SQLiteConnectionPool.GetConnection(SQLiteConnectionString connectionString)
   at SQLite.SQLiteAsyncConnection.GetConnection()
   at SQLite.SQLiteAsyncConnection.<>c__DisplayClass29`1.<QueryAsync>b__28()
   at System.Threading.Tasks.Task`1.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at Telerik.Windows.Cloud.SQLStorageProvider`1.<CheckRegisterTableForType>d__48.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at Telerik.Windows.Cloud.SQLStorageProvider`1.<StoreAsync>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at Telerik.Windows.Cloud.SynchronizationContext`1.<StoreItemsLocally>d__5f.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at Telerik.Windows.Cloud.SynchronizationContext`1.<AddAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()
   at test_sqlite.MainPage.<updateLocation_Click>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<ThrowAsync>b__0(Object state)

[Deyan]

Hi Christian,

Thanks for writing.

After installing the SQLite Extension, please make sure to add a reference to it in your project. How to do this is explained here:

http://www.telerik.com/help/windows-phone/radcontrols-cloud-synchronization-manualintegration.html

Let me know if this doesn't help.

Regards,
Deyan
Telerik

[chris]

Hi Deyan

Maybe I'm doing things the wrong way, 
I added the SQLite from the NuGet Package manager, I'm also running this as a WP8 app. 
Should I be adding the reference from a particular version?

Cheers
Chris

[Deyan]

Hello Christian,

Thanks for writing back.

Is it possible for you to send me your project in a newly opened support ticket so that I can directly take a look at it and see how I can help you further?

Regards,
Deyan
Telerik

[chris]

Hey Dayan

Sorry have had to focus on other stuff for a few weeks.
I just tried with the standard VS template for cloud sync example. 

I'm developing for WP8 which may make a difference?

The project is 6MB do you have an email address I can send to as it's a 2MB limit here
 

Chris

[Deyan]

Hi Christian,

Thanks for getting back to me.

I am afraid the e-mail approach won't work. Is it possible for you to upload the file to SkyDrive or a similar service?

Regards,
Deyan
Telerik

[chris]

See if you can get it from here. 

https://skydrive.live.com/redir?resid=61FAD7BB00B45B0C!5298&authkey=!ABGDYkY6RHvs3sg

[Deyan]

Hello Christian,

Thanks for writing back and for the provided link.

I have managed to download and test the project without reproducing any exceptions. It works on my side as expected.

Did you make sure that you've installed the SQLite for Windows Phone Visual Studio extension before executing the project?

You can follow the steps described here and you should be able to run the sample:

http://www.telerik.com/help/windows-phone/radcontrols-cloud-synchronization-gettingstarted.html

Please note that we have made some further updates in the API which have been introduced in our Latest Internal Build regarding RadControls for Windows Phone. Since the Cloud Controls and the Data Sync component are in CTP state, we heavily rely on your feedback on how we can improve them further. Changes are continuously introduced for that purpose.

* The latest APIs described in our online help are available as of the Latest Internal Build

Let me know if I can help you further.

Regards,
Deyan
Telerik

[chris]

Hey Deyan

Thanks so much for the help. 
I just figured it was my install of Json.net which gets added when you create the project.  As I was deploying to my phone it wasn't finding the correct build for the Lumia. 

I deleted the json.net reference and then reinstalled using NuGet.All works now. 

Chris

[Deyan]

Hi Christian,

Happy to hear that.

Let us know if you have feedback on this component.

We will appreciate it!

Regards,
Deyan
Telerik