We just set up Mail Chimp integration for a client and the records are not synchronizing to Mail Chimp from the group. The error in the log is that the process requires http authentication and the password is invalid. Does anyone know what password it is looking for? The error was actually ERROR [taskExecutorNotChecked-4]: 22-Apr-2015 09:44:18.205 There was an exception when pushing over the processing list with id of 'xxxx'.
java.lang.NullPointerException in another log. I have the fix from the knowledgebase.

The column Bord_Caption on the Custom_Tables table, has an incorrect datatype

1. Log in to SQL Management Studio
2. Backup the CRM Database
3. Execute the following SQL
   //** DROP INDEXES **//
   DROP INDEX Custom_Tables.IDX_Bord_Caption
   
   //** CHANGE DATATYPE*//
   ALTER TABLE Custom_Tables ALTER COLUMN Bord_Caption NVARCHAR(40) NOT NULL
   
   //** TRIM WHITESPACE **//
   UPDATE Custom_Tables SET Bord_Caption = LTRIM(RTRIM(Bord_Caption))
   
   //** RECREATE INDEX **//
   CREATE NONCLUSTERED INDEX [IDX_Bord_Caption] ON [dbo].[Custom_Tables]
   (
   [Bord_Caption] ASC
   )WITH (PAD_INDEX = ON, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80) ON [PRIMARY]
4. Do an IISReset on the CRM server