Product:
Cognos Controller FAP 10.1.1
Cognos TM1 10.2.2
Windows 2008 R2
Oracle Database
Problem:
FAP process stops when it founds a user in Controller that does not exist in CAM source (LDAP or AD)
Error in FAP log:
2015-01-07 12:36:03,673 [IP:FAP] ERROR RetryInterceptor – Trial 3 failed for method addCAMUser
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:600)
at com.ibm.cognos.fap.common.persistence.retry.RetryInterceptor.intercept(RetryInterceptor.java:43)
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1$$EnhancerByCGLIB$$3867900c.addCAMUser()
at com.ibm.cognos.fap.service.security.User.createUsers(User.java:87)
at com.ibm.cognos.fap.service.security.Security.publish(Security.java:64)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.initialPublish(DatamartTimerTask.java:501)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask.access$300(DatamartTimerTask.java:80)
at com.ibm.cognos.fap.service.schedule.DatamartTimerTask$1.run(DatamartTimerTask.java:367)
at java.lang.Thread.run(Thread.java:736)
Caused by:
com.ibm.cognos.fap.common.exception.LoggedException: Could not add CAM user AD\username1 with CAMID
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1.addCAMUser(SecurityTM1.java:320)
… 12 more
Caused by:
com.ibm.cognos.tm1.TM1Exception: ObjectRegistrationFailed
at com.ibm.cognos.fap.service.persistence.tm1.SecurityTM1.addCAMUser(SecurityTM1.java:314)
… 12 more

Possible Solution:
Go into the Cognos Controller client, and erase all users that should not be there. That has left the company and does not exist in the Active Directory.
http://www-01.ibm.com/support/docview.wss?uid=swg21632436
Different solution is to run SQL script to erase all users that have no CAMID in the table XCAMUSER inside the Cognos Controller database.
Start SQL developer and connect to the Cognos Controller database
Enter below to list the free rows:
Select * from frango.xcamuser where camid = ‘ ‘;
Enter below to make a copy of the table before deleting its contents:
create table xcamuser_backup as select * from xcamuser;
Enter below to delete the empty rows:
Delete from frango.xcamuser where camid = ‘ ‘;