I want to fill some of the user profile properties via BDC Connection. I already have created more than 50 user profiles which I imported from AD. Now, in order to import profiles properties using BDC, I performed below steps:

a) Ensured Business Data Connectivity and Secure Store are running and used account has Full permission on these services.

b) Created an external content type using SharePoint Designer and created an external list to ensure that data is available:

• Set email field as identifier, which is one of the columns in SQL table and is a primary key.
• Created Read Item and Read List operations on above ECT.

c) Checked the presence of above ECT in BDC service and ensured it has all necessary permissions i.e. Edit, Execute etc.

d) Configure a new synchronization connection in User profile Service by selecting the same ECT. Here I chose to connect 1:1 mapping and picked up WorkEmail property to return items.

e) Mapped one of the custom property with one of the fields of SQL Server. Here, I ensured they both have same type.

f) Ran Full Synchronize after above steps. On checked, I do not find any data in the mapped properties.

Below are the traces of LOGS:

Profile sync step BusinessConnection (stage BusinessDataCatalogFullImport) finished successfully. 8ecffe9c-6d0a-e0e8-ec25-eb7a5f1c1215
04/21/2015 12:37:00.68  OWSTIMER.EXE (0x337C)                    0x02DC SharePoint Portal Server       User Profiles                  ac4iu Medium   Profile sync step BusinessConnection (stage BusinessDataCatalogFullSync) started execution. 
04/21/2015 12:37:00.68  OWSTIMER.EXE (0x337C)                    0x4CCC SharePoint Foundation          Topology                       8xqz Medium   Updating SPPersistedObject UserProfileImportJob Name=UserProfileServiceApplication_ProfileImportJob. Version: 2294209 Ensure: False, HashCode: 36728399, Id: 4f037df6-d339-4b5a-8892-ef3699c16b20, Stack:    at Microsoft.SharePoint.Administration.SPJobDefinition.Update()     at Microsoft.Office.Server.UserProfiles.UserProfileImportJob.SaveStatus()     at Microsoft.Office.Server.UserProfiles.UserProfileImportJob.Execute()     at Microsoft.Office.Server.Administration.UserProfileApplicationJob.Execute(SPJobState jobState)     at Microsoft.SharePoint.Administration.SPTimerJobInvokeInternal.Invoke(SPJobDefinition jd, Guid targetInstanceId, Boolean isTimerService, Int32& result)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)   8ecffe9c-6d0a-e0e8-ec25-eb7a5f1c1215
04/21/2015 12:37:01.70  OWSTIMER.EXE (0x337C)                    0x4CCC SharePoint Portal Server       User Profiles                  ac4iq Medium   Profile sync step BusinessConnection (stage BusinessDataCatalogFullSync) finished successfully. 8ecffe9c-6d0a-e0e8-ec25-eb7a5f1c1215
04/21/2015 12:37:01.70  OWSTIMER.EXE (0x337C)                    0x4CCC SharePoint Foundation          Topology                       8xqz Medium   Updating SPPersistedObject UserProfileImportJob Name=UserProfileServiceApplication_ProfileImportJob. Version: 2294211 Ensure: False, HashCode: 36728399, Id: 4f037df6-d339-4b5a-8892-ef3699c16b20, Stack:    at Microsoft.SharePoint.Administration.SPJobDefinition.Update()     at Microsoft.Office.Server.UserProfiles.UserProfileImportJob.SaveStatus()     at Microsoft.Office.Server.UserProfiles.UserProfileImportJob.Execute()     at Microsoft.Office.Server.Administration.UserProfileApplicationJob.Execute(SPJobState jobState)     at Microsoft.SharePoint.Administration.SPTimerJobInvokeInternal.Invoke(SPJobDefinition jd, Guid targetInstanceId, Boolean isTimerService, Int32& result)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)   8ecffe9c-6d0a-e0e8-ec25-eb7a5f1c1215
04/21/2015 12:37:02.53  OWSTIMER.EXE (0x337C)                    0x319C SharePoint Foundation          Monitoring                     nasq Medium   Entering monitored scope (Timer Job job-upgrade-sites). Parent No 9f354308-7b18-40f3-80d6-c7d0616cd9e5
04/21/2015 12:37:02.53  OWSTIMER.EXE (0x337C)                    0x319C SharePoint Foundation          Logging Correlation Data       xmnv Medium   Name=Timer Job job-upgrade-sites a0cffe9c-7d80-e0e8-ec25-e024bd692f28
04/21/2015 12:37:02.67  OWSTIMER.EXE (0x337C)                    0x319C SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (Timer Job job-upgrade-sites). Execution Time=136.402252241556 a0cffe9c-7d80-e0e8-ec25-e024bd692f28
04/21/2015 12:37:04.94  w3wp.exe (0x4440)                        0x4070 SharePoint Portal Server       Runtime                        8gp7 Medium   Topology cache updated. (AppDomain: /LM/W3SVC/1712947452/ROOT-1-130740700225995467) 
04/21/2015 12:37:05.00  OWSTIMER.EXE (0x337C)                    0x1FA0 SharePoint Foundation          Monitoring                     aeh57 Medium   Sql Ring buffer status eventsPerSec = ,processingTime=0,totalEventsProcessed=0,eventCount=0,droppedCount=0,memoryUsed=0 
04/21/2015 12:37:05.52  w3wp.exe (0x4440)                        0x3DD8 SharePoint Foundation          Topology                       e5mc Medium   WcfSendRequest: RemoteAddress: 'http://172.20.21.163:32843/af95f58c149b4b61b13c0d0250479beb/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges2' MessageId: 'urn:uuid:324f52f2-8c3a-49e3-9d2c-6119776db97b' 08d6992a-9413-4d09-b8f9-bcfb08266cc7
04/21/2015 12:37:05.52  w3wp.exe (0x4848)                        0x3D98 SharePoint Foundation          Monitoring                     nasq Medium   Entering monitored scope (ExecuteWcfServerOperation). Parent No 
04/21/2015 12:37:05.52  w3wp.exe (0x4848)                        0x3D98 SharePoint Foundation          Topology                       e5mb Medium   WcfReceiveRequest: LocalAddress: 'http://ispantest.domainname.local:32843/af95f58c149b4b61b13c0d0250479beb/MetadataWebService.svc' Channel: 'System.ServiceModel.Channels.ServiceChannel' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges2' MessageId: 'urn:uuid:324f52f2-8c3a-49e3-9d2c-6119776db97b' 08d6992a-9413-4d09-b8f9-bcfb08266cc7
04/21/2015 12:37:05.52  w3wp.exe (0x4848)                        0x3D98 SharePoint Server              Taxonomy                       fuc5 Medium   MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service' starting. 08d6992a-9413-4d09-b8f9-bcfb08266cc7
04/21/2015 12:37:05.53  w3wp.exe (0x4848)                        0x3D98 SharePoint Server              Taxonomy                       fuc6 Medium   MetadataWebServiceApplication.GetChanges called on 'Managed Metadata Service' completed. 08d6992a-9413-4d09-b8f9-bcfb08266cc7
04/21/2015 12:37:05.53  w3wp.exe (0x4848)                        0x3D98 SharePoint Foundation          Monitoring                     b4ly Medium   Leaving Monitored Scope (ExecuteWcfServerOperation). Execution Time=2.03964470344695 08d6992a-9413-4d09-b8f9-bcfb08266cc7
04/21/2015 12:37:05.53  w3wp.exe (0x4440)                        0x3DD8 SharePoint Foundation          General                        aipzw High     An exception occurred while writing a service call usage entry.  Exception details: System.ObjectDisposedException: Safe handle has been closed     at System.Runtime.InteropServices.SafeHandle.DangerousAddRef(Boolean& success)     at Microsoft.Win32.Win32Native.GetTokenInformation(SafeTokenHandle TokenHandle, UInt32 TokenInformationClass, SafeLocalAllocHandle TokenInformation, UInt32 TokenInformationLength, UInt32& ReturnLength)     at System.Security.Principal.WindowsIdentity.GetTokenInformation(SafeTokenHandle tokenHandle, TokenInformationClass tokenInformationClass)     at System.Security.Principal.WindowsIdentity.get_User()     at System.Security.Principal.WindowsIdentity.GetName()     at System.Security.Principal.WindowsIdentity.get_Name()     at Microsoft.SharePoint.Utilities.SPUtili... 08d6992a-9413-4d09-b8f9-bcfb08266cc7