While configuring Social Network Configuration content, specifically for Facebook, I was getting mixed results when publishing to Facebook using WCM’s Social Media Publisher capability.  After noticing it was happening a majority of the time while trying to publish to a Facebook page (versus a personal wall post), I dug into it a bit and noticed an SQL exception being thrown in the logs.  I opened a PMR within IBM support and worked with them to track down an issue in which a table column being used for SMP was too small relating to the (credential) vault data.  If you’ve ever worked with SMP, you’ll notice an associated credential vault entry gets created when you create a Social Network Configuration through SMP, and this was the process which was attempting to insert a row into this table and the password was too long for the allotted field.  To manually fix this issue, you can modify / alter the RELEASE.VAULT_DATA table, specifically the PWD column which stores the password.  By default, it is defined as a VARCHAR 255, you can simply update it to be 355 characters instead, and this should resolve your issue.  I believe an APAR was opened for this, but I’m not sure where this is as far as being resolved and/or which CF it may be included in.

Hope this helps, feel free to reach out with any questions…