SQLite file exception

10 posts, 0 answers
  1. chris
    chris avatar
    9 posts
    Member since:
    Dec 2008

    Posted 16 Jun 2013 Link to this post

    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)

  2. Deyan
    Admin
    Deyan avatar
    2039 posts

    Posted 19 Jun 2013 Link to this post

    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
    Have a suggestion or face a problem - you can use the Ideas & Feedback portal to submit ideas, feedback and vote for them.
  3. DevCraft banner
  4. chris
    chris avatar
    9 posts
    Member since:
    Dec 2008

    Posted 21 Jun 2013 Link to this post

    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
  5. Deyan
    Admin
    Deyan avatar
    2039 posts

    Posted 21 Jun 2013 Link to this post

    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
    Have a suggestion or face a problem - you can use the Ideas & Feedback portal to submit ideas, feedback and vote for them.
  6. chris
    chris avatar
    9 posts
    Member since:
    Dec 2008

    Posted 15 Jul 2013 Link to this post

    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
  7. Deyan
    Admin
    Deyan avatar
    2039 posts

    Posted 16 Jul 2013 Link to this post

    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
    Have a suggestion or face a problem - you can use the Ideas & Feedback portal to submit ideas, feedback and vote for them.
  8. chris
    chris avatar
    9 posts
    Member since:
    Dec 2008

    Posted 16 Jul 2013 Link to this post

    See if you can get it from here. 

    https://skydrive.live.com/redir?resid=61FAD7BB00B45B0C!5298&authkey=!ABGDYkY6RHvs3sg
  9. Deyan
    Admin
    Deyan avatar
    2039 posts

    Posted 17 Jul 2013 Link to this post

    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
    Have a suggestion or face a problem - you can use the Ideas & Feedback portal to submit ideas, feedback and vote for them.
  10. chris
    chris avatar
    9 posts
    Member since:
    Dec 2008

    Posted 17 Jul 2013 Link to this post

    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
  11. Deyan
    Admin
    Deyan avatar
    2039 posts

    Posted 17 Jul 2013 Link to this post

    Hi Christian,

    Happy to hear that.

    Let us know if you have feedback on this component.

    We will appreciate it!

    Regards,
    Deyan
    Telerik
    Have a suggestion or face a problem - you can use the Ideas & Feedback portal to submit ideas, feedback and vote for them.
Back to Top
DevCraft banner