User, Role, Profile Synchronization Job Fails

[Former Member]

Hi Gurus,

When I am scheduling a job the User, Role, and Profile Sync. job fails giving an error

"Cannot assign a java.lang.String object of length 53 to host variable 5 which has JDBC type VARCHAR(40)."

This happens when the synchronization happens with a portal system. We dont have a ruleset for the portal system, So if I put in a "*", it includes this system and results in the error, If I manually select all other system, it works fine. Is there any way to remove this error so that I can schedule the jobs without having to select every system manually.

Regards,

Chinmaya

[Former Member]

Hi,

As per my knowledge, in the Portal system, you should perform only user sync. Roles/profile sync will not work since portal will have workset roles.

Please refer SAP Note 1168120, which may help you to understand the limitations

Hope this helps!!

Rgds,

Raghu

Edited by: Raghu Boddu on Nov 4, 2010 7:39 PM

[Former Member]

Yes, I believe thats right, My question was that selecting every system manually on that screen can be a pain. If I could just put in "*" and hope for it to run without a problem would be great. I couldnt find a way to save any "variants" so evertime I have to schedule the job its a lot of work.

[Former Member]

It is not possible. You have to do it manually.

Rgds,

Raghu