{"id":1155,"date":"2018-04-09T08:53:42","date_gmt":"2018-04-09T06:53:42","guid":{"rendered":"http:\/\/ponte.ch\/blog\/?p=1155"},"modified":"2018-06-26T00:39:03","modified_gmt":"2018-06-25T22:39:03","slug":"when-ibm-connections-sync-stops-synching","status":"publish","type":"post","link":"https:\/\/ponte.ch\/blog\/when-ibm-connections-sync-stops-synching\/","title":{"rendered":"When IBM Connections Sync stops synching.."},"content":{"rendered":"<p>..I&#8217;m in trouble\u00a0because I heavily rely on this feature of IBM Connections where the content of \u00abMy Drive\u00bb is synced to my devices.<\/p>\n<ul class=\"lotusInlinelist\">\n<li class=\"lotusFirst\">\n<blockquote><p>All content in this view can be synced to any of your computers or mobile devices by downloading and installing the IBM Connections Plug-ins<\/p><\/blockquote>\n<\/li>\n<\/ul>\n<p>I&#8217;ve been using IBM Connections Sync for ages with little to no issues, connecting to our own IBM Connections environment but also customers or IBM Cloud servers.<\/p>\n<p>A few weeks back I started to have problems with a few files which I resolved by removing and adding the files back to \u00abMy Drive\u00bb.<br \/>\nThen suddenly\u00a0the plug-in complained about not being able to sync files because they were missing..\u00a0what?<br \/>\nThe files were on local and on the server.. I did the remove\/add trick but that didn&#8217;t help. I deleted the file and wanted to add it again but it wouldn&#8217;t let me because &#8220;the file already exists&#8221;..\u00a0what?<br \/>\nUnder normal\u00a0circumstances, the plug-in can offer different resolution options, one of them being to \u00abforget the local copy\u00bb and discard it. That was also not working anymore so I decided to remove the account from the plug-in and create a new one.<\/p>\n<figure id=\"attachment_1156\" aria-describedby=\"caption-attachment-1156\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1156\" src=\"http:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/account-300x148.png\" alt=\"IBM Connections Sync Account\" width=\"300\" height=\"148\" srcset=\"https:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/account-300x148.png 300w, https:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/account-768x378.png 768w, https:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/account.png 804w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption id=\"caption-attachment-1156\" class=\"wp-caption-text\">IBM Connections Sync Account<\/figcaption><\/figure>\n<p>The downside to that is, that the whole \u00abMy Drive\u00bb folder has to be downloaded again but it did the trick, so all good.<\/p>\n<p>When adding the next file to the local folder I noticed that the sync was not working reliably and at one point stopped again. When adding files to \u00abMy Drive\u00bb in Connections it would sync but not from local to Connections.<\/p>\n<p>Since I had not updated the plug-in for quite some time I thought to get the newest version. I installed the upgrade and surprise<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1157\" src=\"http:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/sync-300x104.png\" alt=\"Sync detail\" width=\"300\" height=\"104\" srcset=\"https:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/sync-300x104.png 300w, https:\/\/ponte.ch\/blog\/wp-content\/uploads\/2018\/04\/sync.png 537w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>The \u00ablast synced\u00bb date went back to the 70ies and I was not able to get anything to sync. I removed the plug-in, deleted every reference, preference file, library file and what else, installed an older version of the plug-in, installed the newest version.. nothing. I added other accounts because I thought it had to do with my credentials, but no luck. I added Cloud and customer accounts, and they all worked. hmmm.. maybe it&#8217;s not a local thing after all. I&#8217;ve asked our Connections master Urs Meli to help me out and look for errors in the logs and yes, he found a few things.<\/p>\n<blockquote><p>com.ibm.db2.jcc.am.SqlSyntaxErrorException: <strong>The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: &#8220;LCUSER&#8221;.<\/strong> Operation: &#8220;SELECT&#8221;. Object: &#8220;FILES.SYNC_EVENT_EXTENDED&#8221;.. SQLCODE=-551, SQLSTATE=42501, DRIVER=4.21.29<\/p><\/blockquote>\n<p>Basically, lcuser\u00a0was missing the correct authorization to certain tables. To solve it Urs ran the <strong>APPGrant.sql<\/strong> in DB Wizard to reset the rights.<\/p>\n<p>He also noticed errors regarding the Push Notification App. Restarting the app cleared those as well. We do not know if this was related to the other issue though.<\/p>\n<p>After these changes, my sync started working again and I had no\u00a0issues since then.<\/p>\n<p>We think the problem is related to one of the latest IBM Connections upgrades but we can&#8217;t pinpoint it to a specific item.<\/p>\n<p>Since many others are reporting problems with IBM Connections Sync (on Mac, but the problem affects all plug-ins) I suggest to check for errors on the server as well besides using the latest plug-in, which you can download from the\u00a0IBM Collaboration Solutions Catalog located\u00a0<a href=\"https:\/\/xspy.mybluemix.net\/?cm_mmc=dw-_-champions-_-champtracker-_-allchamps\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>..I&#8217;m in trouble\u00a0because I heavily rely on this feature of IBM Connections where the content of \u00abMy Drive\u00bb is synced to my devices. All content in this view can be synced to any of your computers or mobile devices by downloading and installing the IBM Connections Plug-ins I&#8217;ve been using IBM Connections Sync for ages&#8230; <a class=\"more-link\" href=\"https:\/\/ponte.ch\/blog\/when-ibm-connections-sync-stops-synching\/#more-1155\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[38,22],"tags":[34,140],"class_list":["post-1155","post","type-post","status-publish","format-standard","hentry","category-ibm","category-technology","tag-ibm-connections","tag-ibm-connections-sync","clear"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2HetC-iD","_links":{"self":[{"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/posts\/1155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/comments?post=1155"}],"version-history":[{"count":3,"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/posts\/1155\/revisions"}],"predecessor-version":[{"id":1242,"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/posts\/1155\/revisions\/1242"}],"wp:attachment":[{"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/media?parent=1155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/categories?post=1155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ponte.ch\/blog\/wp-json\/wp\/v2\/tags?post=1155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}