Click here to Skip to main content
14,333,606 members
Rate this:
Please Sign up or sign in to vote.
09-24 12:09:40.219: E/SQLiteLog(3535): (14) cannot open file at line 30191 of [00bb9c9ce4]
09-24 12:09:40.219: E/SQLiteLog(3535): (14) os_unix.c:30191: (2) open(//data/data/com.momeni.shams/databases/shams) -
09-24 12:09:40.223: E/SQLiteDatabase(3535): Failed to open database 'data/data/com.momeni.shams/databases/shams'.
09-24 12:09:40.223: E/SQLiteDatabase(3535): android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteConnection.nativeOpen(Native Method)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:209)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteConnection.open(SQLiteConnection.java:193)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteConnectionPool.openConnectionLocked(SQLiteConnectionPool.java:463)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:185)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteConnectionPool.open(SQLiteConnectionPool.java:177)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteDatabase.openInner(SQLiteDatabase.java:804)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteDatabase.open(SQLiteDatabase.java:789)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:694)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:669)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at com.momeni.shams.Dal.checkdb(Dal.java:80)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at com.momeni.shams.Dal.database(Dal.java:60)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at com.momeni.shams.Showperson.onCreate(Showperson.java:30)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.Activity.performCreate(Activity.java:5231)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2159)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2245)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.ActivityThread.access$800(ActivityThread.java:135)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1196)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.os.Handler.dispatchMessage(Handler.java:102)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.os.Looper.loop(Looper.java:136)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at android.app.ActivityThread.main(ActivityThread.java:5017)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at java.lang.reflect.Method.invokeNative(Native Method)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at java.lang.reflect.Method.invoke(Method.java:515)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)
09-24 12:09:40.223: E/SQLiteDatabase(3535): at dalvik.system.NativeStart.main(Native Method)
Posted
Comments
Bernhard Hiller 24-Sep-14 9:35am
   
does the file "//data/data/com.momeni.shams/databases/shams" exist on the device?
Xiao Ling 27-Sep-14 21:53pm
   
can't open database. Check whether the database exists.
‫محم د‬‎ 28-Sep-14 2:09am
   
Yes ! my databace is exist and i can give data from that
But wen i want to use data in custom list view it give error
Rate this:
Please Sign up or sign in to vote.

Solution 1

this problem is related to a corrupt sqlite database or the file doesn´t exist
Failed to open database 
android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database

be sure to have the correct path, application package and database name, probably you are missing the extension (shams).
/data/data/com.momeni.shams/databases/shams
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

Hie,
While searching for your problem i found this easy blog with easy manual solution codes which can maybe a help for you. Visit http://sqliteviewer.com/blog/know-manual-solution-of-sqlite-error-14.html[^]
Try the solution and let me know if it works.

Thanks
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100