Sharepoint various users problem.

See more:

SharePoint

Hi all,

I am facing problem with displaying current user designation in infopath 2010 form.

The steps what i taken to display current user designation:
1)All the user and their corresponding information from active directory pushing into database table.
2)Created on external list using BCS connection pulling all the necessary user data from that custom table.
3)Using data connection in infopath 2010 calling the externalist and filtering the current user designation.

Following the above steps its working fantastically except some users:

Probml no 1: If the user member of administrator, and if i preview the form from infopath 2010 application his designation will be poped up perfectly in the respective field. And after publishing the same form in sharepoint 2010 site thru central admin. If the same user login to the application and open the form, his designation field is empty i mean not populating. And right corner side of the
application it is not dispalying his login name. Its displaying system account.
problm no 2: For few employees while opening the form from sharepoint site their designation is not populating even though when i run the query from custom table where all the employee details stored, their designatin is there. Using the same filteration all the employee's designation is coming perfectly except some few.

Any help about above mentioned problem would be heartily appreciated.