User profile for user: svejed123
svejed123 Author
User level: Level 1
16 points

Calendar agent - error: sql cached statement NSSQLiteStatement

Hi,


So after spending quite a lot of time trying to fix my iCalendar app

from the Spinning beach ball lag every time I make a new event or edit an event,

I found this error in the console application:


error: sql cached statement NSSQLiteStatement <0x7f8eef31d7d0> on entity 'Attachment' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZATTACHMENTID, t0.ZCONTENTTYPE, t0.ZFILENAMEINCACHE, t0.ZFILENAMESUGGESTEDBYSERVER, t0.ZISAUTOARCHIVED, t0.ZISCACHED, t0.ZOMITSYNCRECORD, t0.ZPATHONDISKSTRING, t0.ZURLSTRING, t0.ZUUID, t0.ZITEM, t0.Z4_ITEM FROM ZATTACHMENT t0 WHERE t0.ZITEM IN (SELECT * FROM _Z_intarray0) ORDER BY t0.ZITEM' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

destinations = "{0x122c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1163>, 0x1230009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1164>, 0x1234009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1165>, 0x123c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1167>, 0x1258009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1174>, 0x1264009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1177>, 0x126c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1179>, 0x127c009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1183>, 0x1280009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1184>, 0x1284009eb <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/Event/p1185>}";

}



error 11:40:50.320294 +0100 CalendarAgent error: sql cached statement NSSQLiteStatement <0x7f8eef350360> on entity 'Group' with sql text 'SELECT t0.Z_ENT, t0.Z_PK, t0.Z_OPT, t0.ZCOLORSTRING, t0.ZISENABLED, t0.ZNOTES,t0.ZOMITSYNCRECORD, t0.ZORDER, t0.ZSYMBOLICCOLORNAME, t0.ZTITLE, t0.ZUID, t0.ZPUBLICATION, t0.ZALARMSDISABLED, t0.ZCHECKED, t0.ZHASSHAREES, t0.ZISEVENTCONTAINER, t0.ZISMARKEDIMMUTABLESHAREES,t0.ZISMARKEDUNDELETABLE, t0.ZISTASKCONTAINER, t0.ZNOTIFICATIONCOUNT, t0.ZSHAREDEFAULTALARMSETTINGS, t0.ZSUPPRESSEVENTSCHEDULINGNOTIFICATIONS, t0.ZDEFAULTALARMSET, t0.ZGROUP, t0.Z46_GROUP,t0.ZLOCALDEFAULTALARMSET, t0.ZSUBSCRIPTIONINFO, t0.ZACCOUNTIDFORHEADING, t0.ZGROUPHEADERTITLE, t0.ZISEDITABLE, t0.ZISSUGGESTEDEVENTCALENDAR, t0.ZISDELEGATE, t0.ZPERMISSION, t0.ZPREPUBLISHURLSTRING,t0.ZPUBLISHURLSTRING, t0.ZSERVERSUBSCRIPTIONURLSTRING, t0.ZSHARINGSTATUS, t0.ZCTAG, t0.ZCALENDARPATH, t0.ZCANBEPUBLISHED, t0.ZISAFFECTINGAVAILABILITY, t0.ZISCOLOREDITABLE, t0.ZISFAMILYCALENDAR,t0.ZISRENAMEABLE, t0.ZOWNERDISPLAYNAME, t0.ZOWNERPRINCIPALPATH, t0.ZPUSHKEY, t0.ZSYNCTOKEN, t0.ZTIMEZONESTRING, t0.ZETAG, t0.ZCHANGEKEY, t0.ZFOLDERID, t0.ZISDISTINGUISHED, t0.ZPARENTFOLDERID, t0.ZSYNCSTATE,t0.ZISEXPANDED, t0.ZDATAFLOWSTOWARDLOCALSTORE, t0.ZPRINCIPAL, t0.Z50_PRINCIPAL, t0.ZACCOUNTID, t0.ZISDELEGATE1, t0.ZISINSEPARATEWINDOW, t0.ZKEEPOFFLINE, t0.ZOVERRIDEBASEURLSTRING, t0.ZREFRESHDATE,t0.ZSHAREDEFAULTALARMSETTINGS1, t0.ZSUPPORTSDEFAULTALARMS, t0.ZDEFAULTALARMSET1, t0.ZLOCALDEFAULTALARMSET1, t0.ZMIGRATIONGROUP, t0.ZALLOWEDCALENDARCREATIONTYPES, t0.ZAVAILABILITYDATA,t0.ZCALENDARHOMEPATH, t0.ZCALENDARHOMEPUSHKEY, t0.ZDEFAULTCALENDARPATH, t0.ZDROPBOXPATH, t0.ZHOMECTAG, t0.ZHOMESYNCTOKEN, t0.ZINBOXCTAG, t0.ZINBOXPATH, t0.ZINBOXSYNCTOKEN,t0.ZISAUTOSCHEDULESUPPORTED, t0.ZISCALENDARPROXYSUPPORTED, t0.ZISCALENDARSERVERPRIVATEEVENTSSUPPORTED, t0.ZISCALENDARUSERSEARCHREPORTSUPPORTED, t0.ZISCHECKFORVALIDEMAILSUPPORTED,t0.ZISCHECKSUMMINGSUPPORTED, t0.ZISEXPANDPROPERTYREPORTSUPPORTED, t0.ZISINBOXAVAILABILITYSUPPORTED, t0.ZISLIKENESSPROPAGATIONSUPPORTED, t0.ZISMANAGEDATTACHMENTSUPPORTED,t0.ZISPRIVATECOMMENTSSUPPORTED, t0.ZISREQUESTCOMPRESSIONSUPPORTED, t0.ZISSHARINGSCHEDULINGSUPPORTED, t0.ZISSHARINGSUPPORTED, t0.ZLASTPUSHSUBSCRIPTION, t0.ZNEXTDEEPREFRESH,t0.ZNOTIFICATIONCOLLECTIONCTAG, t0.ZNOTIFICATIONCOLLECTIONPATH, t0.ZNOTIFICATIONCOLLECTIONSYNCTOKEN, t0.ZNOTIFICATIONURLSTRING, t0.ZOUTBOXPATH, t0.ZPRINCIPALPATH, t0.ZPUSHTRANSPORTS,t0.ZQUOTAFREEBYTES, t0.ZSUPPORTSCALENDARHOMESYNC, t0.ZSUPPORTSFREEBUSY, t0.ZSUPPORTSNOTSERIALIZINGTIMEZONES, t0.ZSUPPORTSRECURRENCESPLITONSERVER, t0.ZSUPPORTSSUBSCRIPTIONCALENDARS,t0.ZSUPPORTSUNBIND, t0.ZLASTERROR, t0.ZDELETEDITEMSFOLDERID, t0.ZDELETEDITEMSFOLDERSYNCSTATE, t0.ZEXCHANGESERVERMAJORBUILDNUMBER, t0.ZEXCHANGESERVERMAJORVERSION,t0.ZEXCHANGESERVERMINORBUILDNUMBER, t0.ZEXCHANGESERVERMINORVERSION, t0.ZEXCHANGESERVERVERSION, t0.ZMAILBOX, t0.ZROOTFOLDERID, t0.ZLASTERROR1 FROM ZNODE t0 WHERE ( t0.Z_PK IN (SELECT * FROM_Z_intarray0)
AND
t0.Z_ENT >= ? AND
t0.Z_ENT <= ?) ' failed due to missing variable binding for (null) with expecting bindings (

"<NSSQLBindVariable: 0x7f8eecff3a70>",

"<NSSQLBindVariable: 0x7f8eef373ee0>"

) but actual substitution variables {

objects = "{<NSManagedObject: 0x7f8eef47a3e0> (entity: ExchangePrincipal; id: 0x2400b0b <x-coredata://93547915-498F-4251-8E7E-23DD04782C04/ExchangePrincipal/p9> ; data: <fault>)}";

}





There are around 8-10 of such errors each time I make a new event.

Can you please help me with this issue?

I already reinstalled mac os sierra few times,

but it made no difference.

MacBook Pro (Retina, 13-inch,Early 2015)

Posted on Feb 27, 2017 2:50 AM

Reply
14 replies
User profile for user: pcharlier
pcharlier
User level: Level 1
4 points

Sep 2, 2017 10:06 AM in response to svejed123

I have the same problem with CalendarAgent , but it's not the only one ! cloudd also has an issue with sqlite/sql:

It's really annoying to know there is such a flood of error messages in the Console and not to know what to do.

Tried re-apply combo update, onyX to clean caches and temp files, repair permissions, disabling features then re-enabling, complete iCloud logout then login back. Errors still there.

erreur19:00:25.865073 +0200cloudphotosdSQLite[275]: <private>libprequelite.dylib
erreur19:00:25.865493 +0200cloudphotosdSQLite[275]: <private>libprequelite.dylib
erreur19:00:25.865882 +0200cloudphotosdSQLite[275]: <private>libprequelite.dylib
erreur18:49:39.517811 +0200clouddSqlite request <private> failed on <private> with error [<private>]
erreur18:49:39.520965 +0200clouddSQLite[6922]: <private>
erreur18:46:33.911000 +0200CalendarAgenterror: sql cached statement NSSQLiteStatement <0x7fc753c96250> on entity 'CalendarUserAddress' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZADDRESSSTRING, t0.ZCALENDAR, t0.Z43_CALENDAR, t0.ZPRINCIPAL, t0.Z51_PRINCIPAL FROM ZCALENDARUSERADDRESS t0 WHERE t0.ZCALENDAR IN (SELECT * FROM _Z_intarray0) ORDER BY t0.ZCALENDAR' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

destinations = "{0x80070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p2>, 0x100070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p4>, 0x140070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p5>, 0x180070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p6>, 0x1c0070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p7>, 0x200070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p8>, 0x240070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p9>, 0xf00070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p60>, 0xf40070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p61>, 0xf80070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p62>, 0xfc0070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p63>, 0x1000070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p64>, 0x1040070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p65>, 0x1080070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p66>, 0x10c0070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p67>, 0x1140070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p69>, 0x1180070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p70>, 0x11c0070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p71>, 0x1200070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p72>, 0x1240070b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVCalendar/p73>, 0x11000b8b <x-coredata://6F425E06-C4BC-4FEB-9EE6-72BE1038617D/CalDAVSubscribedCalendar/p68 >}";

}

Reply
User profile for user: pcharlier
pcharlier
User level: Level 1
4 points

Sep 7, 2017 1:13 AM in response to Barney-15E

Those many error in data access. I haven't noticed a loss in the events I planned recently, but It's not reassuring if there are wrong sql statements involved, I wouldn't like to trust the calendar and then in the end get trouble forgetting an appointment, or having to double check with a paper notebook…


I have typically these errors, but not exclusively :


erreur09:38:22.832545 +0200assistantdlibsystem_network.dylibnw_socket_write_close shutdown(6, SHUT_WR): [32] Broken pipe
erreur09:38:22.832681 +0200assistantdlibsystem_network.dylibnw_endpoint_flow_service_writes [94.1.1 17.130.74.5:443 ready multipath-socket-flow (satisfied)] Write request has 0 frame count, 0 byte count
erreur09:38:22.834479 +0200assistantdlibsystem_network.dylib__tcp_connection_write_eof_block_invoke Write close callback received error: [89] Operation canceled


erreur09:59:18.031847 +0200accountsdAccountsDaemon"Cannot check access to a private account type: <private>"


erreur10:07:46.231099 +0200identityservicesdFTServicesRecived an unknown object for kBodyIDKey


erreur10:07:48.695665 +0200accountsdAccountsDaemon"Keychain add migrated failed with error: <private> for item: AccountSync"
erreur10:07:48.696100 +0200accountsdAccountsDaemon"Account Sync - error - <private>"


erreur10:09:32.232710 +0200AddressBookSourceSyncCoreDatawarning: dynamic accessors failed to find @property implementation for 'region' for entity ABCDPostalAddress while resolving selector 'region' on class 'ABCDOwnedObject'. Did you remember to declare it @dynamic or @synthesized in the @implementation ?
erreur10:09:32.232807 +0200AddressBookSourceSyncCoreDatawarning: dynamic accessors failed to find @property implementation for 'countryName' for entity ABCDPostalAddress while resolving selector 'countryName' on class 'ABCDOwnedObject'. Did you remember to declare it @dynamic or @synthesized in the @implementation ?
erreur10:09:35.241660 +0200assistantdlibsystem_network.dylibnetwork_config_has_proxies_configured network_config_has_proxies_configured is deprecated
erreur10:09:35.241958 +0200assistantdlibsystem_network.dylibtcp_connection_set_fallback_fast tcp_connection_set_fallback_fast is deprecated
erreur10:09:35.635968 +0200CalendarAgentCoreDataerror: sql cached statement NSSQLiteStatement <0x7f80ccc1d230> on entity 'Group' with sql text 'SELECT t0.Z_ENT, t0.Z_PK, t0.Z_OPT, t0.this, t0.that, t0 WHERE ( t0.Z_PK IN (SELECT * FROM _Z_intarray0) AND t0.Z_ENT >= ? AND t0.Z_ENT <= ?) ' failed due to missing variable binding for (null) with expecting bindings (

"<NSSQLBindVariable: 0x7f80cccd5860>",

"<NSSQLBindVariable: 0x7f80ccccf1c0>"

) but actual substitution variables {

objects = "{<NSManagedObject: 0x7f80ca7bc490> (entity: CalDAVPrincipal; id: 0x4c007eb <x-coredata://3846E2D9-FFCD-4A54-A036-A7BE41F0856B/CalDAVPrincipal/p19> ; data: <fault>), <NSManagedObject: 0x7f80cf2cd8b0> (entity: CalDAVPrincipal; id: 0x4007eb <x-coredata://3846E2D9-FFCD-4A54-A036-A7BE41F0856B/CalDAVPrincipal/p1> ; data: <fault>)}";

}

erreur10:09:35.636625 +0200CalendarAgentCoreDataerror: sql cached statement NSSQLiteStatement <0x7f80cf18d090> on entity 'Sharee' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZACCESSLEVEL, t0.ZADDRESS, t0.ZCOMMONNAME, t0.ZSTATUS, t0.ZCALENDAR, t0.Z43_CALENDAR FROM ZSHAREE t0 WHERE t0.ZCALENDAR IN (SELECT * FROM _Z_intarray0) ORDER BY t0.ZCALENDAR' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

destinations = "{0x80084b <x-coredata://3846E2D9-FFCD-4A54-A036-A7BE41F0856B/CalDAVCalendar/p2>, 0xc0084b <x-coredata://3846E2D9-FFCD-4A54-A036-A7BE41F0856B/CalDAVCalendar/p3>, 0x100084b <x-coredata://3846E2D9-FFCD-4A54-A036-A7BE41F0856B/CalDAVCalendar/p4>, 0x140084b <x-coredata://3846E2D9-FFCD-4A54-A036-A7BE41F0856B/CalDAVCalendar/p5>, 0x180084b <x-coredata://3846E2D9-FFCD-4A54-A036-.....}";

}

Reply
User profile for user: AVSM
AVSM
User level: Level 1
4 points

Jul 6, 2017 4:48 PM in response to svejed123

I'm seeing this issue a lot. I've looked everywhere but cannot find a solution. I'm adding my error. Every time the calendar fetches data, i get theses errors.


error: sql cached statement NSSQLiteStatement <0x7fcedb940ae0> on entity 'Attachment' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZATTACHMENTID, t0.ZCONTENTTYPE, t0.ZFILENAMEINCACHE, t0.ZFILENAMESUGGESTEDBYSERVER, t0.ZISAUTOARCHIVED, t0.ZISCACHED, t0.ZOMITSYNCRECORD, t0.ZPATHONDISKSTRING, t0.ZURLSTRING, t0.ZUUID, t0.ZITEM, t0.Z4_ITEM FROM ZATTACHMENT t0 WHERE t0.ZITEM IN (SELECT * FROM _Z_intarray0) ORDER BY t0.ZITEM' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

destinations = "{0x1b80058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p110>, 0x1bc0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p111>, 0x1c00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p112>, 0x1c40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p113>, 0x1c80058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p114>, 0x1d40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p117>, 0x1e00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p120>, 0x1e80058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p122>, 0x1f40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p125>, 0x2000058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p128>, 0x2180058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p134>, 0x2280058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p138>, 0x22c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p139>, 0x2380058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p142>, 0x2440058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p145>, 0x2500058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p148>, 0x2600058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p152>, 0x2640058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p153>, 0x2680058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p154>, 0x2700058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p156>, 0x27c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p159>, 0x2800058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p160>, 0x2840058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p161>, 0x2880058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p162>, 0x28c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p163>, 0x2900058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p164>, 0x2940058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p165>, 0x2980058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p166>, 0x29c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p167>, 0x2a00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p168>, 0x2a40058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p169>, 0x198c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p1635>, 0x1b980058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p1766>, 0x38140058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3589>, 0x38200058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3592>, 0x38240058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3593>, 0x382c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3595>, 0x38480058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3602>, 0x38540058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3605>, 0x385c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3607>, 0x386c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3611>, 0x38700058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3612>, 0x38740058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p3613>, 0x463c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4495>, 0x4ce00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4920>, 0x4d9c0058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4967>, 0x4dc00058b <x-coredata://A99FEECB-0063-4665-BD2B-CB3F5B7F5F63/Event/p4976>}";

}

Reply
User profile for user: Community User
Community User

Aug 14, 2017 6:16 AM in response to AVSM

I have the same problem here:


error: sql cached statement NSSQLiteStatement <0x7fb7ba9ee7f0> on entity 'Alarm' with sql text 'SELECT 0, t0.Z_PK, t0.Z_OPT, t0.ZABSOLUTETRIGGER, t0.ZACKNOWLEDGED, t0.ZACTION, t0.ZBOOKMARK, t0.ZEMAILADDRESS, t0.ZISDEFAULTALARM, t0.ZISTIMETOLEAVEALARM, t0.ZMESSAGE, t0.ZNOTRELATIVETOTRAVEL, t0.ZOMITSYNCRECORD, t0.ZORDER, t0.ZPROXIMITY, t0.ZRELATEDTO, t0.ZRELATIVETRIGGER, t0.ZSOUND, t0.ZSUBJECT, t0.ZTIMETOLEAVEDATE, t0.ZTIMETOLEAVEESTIMATEDTRAVELTIME, t0.ZTIMETOLEAVETRAFFICDENSITYSTRING, t0.ZTIMETOLEAVETRANSPORTTYPE, t0.ZUID, t0.ZURLSTRING, t0.ZCALENDAR, t0.Z38_CALENDAR, t0.ZDEFAULTALARMBYREFERENCE, t0.ZDEFAULTALARMSETEVENTALLDAY, t0.ZDEFAULTALARMSETEVENTTIMED, t0.ZITEMCUSTOMALARM, t0.Z4_ITEMCUSTOMALARM, t0.ZITEMLOCALDEFAULTALARM, t0.Z4_ITEMLOCALDEFAULTALARM, t0.ZITEMSERVERDEFAULTALARM, t0.Z4_ITEMSERVERDEFAULTALARM, t0.ZLOCATION, t0.ZUNRECOGNIZEDICSPROPERTIES FROM ZALARM t0 WHERE t0.ZCALENDAR IN (SELECT * FROM _Z_intarray0) ORDER BY t0.ZCALENDAR' failed due to missing variable binding for (null) with expecting bindings (

) but actual substitution variables {

destinations = "{0x8013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p2>, 0x14013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p5>, 0x1c013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p7>, 0x20013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p8>, 0x24013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p9>, 0x28013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p10>, 0x2c013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p11>, 0x30013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p12>, 0x34013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p13>, 0x38013ab <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVCalendar/p14>, 0xc013cb <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVSubscribedCalendar/p3> , 0x10013cb <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVSubscribedCalendar/p4> , 0x18013cb <x-coredata://C6568071-60BE-4E89-BEAF-6929C9FFAB46/CalDAVSubscribedCalendar/p6> }";

}

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Calendar agent - error: sql cached statement NSSQLiteStatement

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up