Expand my Community achievements bar.

Join us for the Adobe Journey Optimizer Community Q&A Coffee Break on 28th February at 8 am PT with Ariel Sultan, Daniel Wright, Josee Haeley and Rohit Basuri.
SOLVED

Android AEP SDK SQliteDatabase errors on Android Q api level 29

Avatar

Level 1

Hello Adobe AEP SDK team,

We have an Adobe AEP SDK implementation on Android that is working fine on versions prior to Android Q (api level 29) but on Android Q the FCM pushidentifier is not being captured on Campaign dashboard. When i check the logs i see some SQLiteDatabase errors only on Android Q, do you guys have any plan on updating the SDK to support Android Q.

We are not able to send push notifications through Adobe campaign to devices running Android Q because the AEP SDK on this version is not able to send info back to Adobe servers.

Below is part of log for the errors that i see only on Android Q api level 29.

2019-07-19 11:14:57.041 22866-23961/"packageName" E/SQLiteLog: (1) near "null": syntax error 2019-07-19 11:14:57.042 22866-23961/"packageName" E/SQLiteDatabase: Error inserting android.database.sqlite.SQLiteException: near "null": syntax error (code 1 SQLITE_ERROR): , while compiling: INSERT INTO HITS(null) VALUES (NULL) at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:986) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:593) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:590) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:61) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:33) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1597) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1468) at com.adobe.marketing.mobile.AndroidDatabase.insert(AndroidDatabase.java:159) at com.adobe.marketing.mobile.HitQueue.queue(HitQueue.java:166) at com.adobe.marketing.mobile.AnalyticsHitsDatabase.queue(AnalyticsHitsDatabase.java:251) at com.adobe.marketing.mobile.AnalyticsExtension.handleLifecycleRequestEvent(AnalyticsExtension.java:1248) at com.adobe.marketing.mobile.AnalyticsListenerLifecycleRequestContent$1.run(AnalyticsListenerLifecycleRequestContent.java:44) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641) at java.lang.Thread.run(Thread.java:919) 2019-07-19 11:14:57.042 22866-23961/"packageName" E/AdobeExperienceSDK: HitQueue - A database error occurred preventing a hit from being inserted 2019-07-19 11:14:57.042 22866-23961/"packageName" E/AdobeExperienceSDK: HitsDatabase - Database in unrecoverable state, resetting.

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi nandeeshtank​,

This issue is currently being investigated by Engineering.  There is also a github issue logged Android AEP SDK SQliteDatabase error on Android Q (api level 29) · Issue #178 · Adobe-Marketing-Clou...  which development will update once they have further information.

Jen

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi nandeeshtank​,

This issue is currently being investigated by Engineering.  There is also a github issue logged Android AEP SDK SQliteDatabase error on Android Q (api level 29) · Issue #178 · Adobe-Marketing-Clou...  which development will update once they have further information.

Jen