Error creating user via CSVUtil

[karram2008]

I have trouble in creating user using the CSVUtil from command prompt in OTM v5.5.
I followed the steps provided in the datamanagement guide. I could see the data getting populated to gl_user and user_association tables. But, I am unable to login from the front end. I get "invalid user name or password" error. Please let me know if there is any way to solve this problem.

Thanks

[james_foran]

Re: Error creating user via CSVUtil

Sounds like the Cache needs to be updated. There are a few ways to fix this:

a) Open the USER record in OTM and select FINISH.

b) Re-start the Application and webServers

c) User the Clear Cache servlet...
http:///GC3/glog.webserver.servlet.cacheclear.CacheClearServle t

Not sure if option c will work. You will need to test this out.

Hope this helps,

Regards,

James Foran
Toll Solutions

[bmj_23]

Re: Error creating user via CSVUtil

When you uploaded the users to the gl_user table, what value did you use for default_user_role_gid ?

Was the user role that you used there an existing user role defined in the application or did you try to create that by inserting records in to the user_role table ?

[karram2008]

Re: Error creating user via CSVUtil

Thanks for the replies. The default_user_role_gid that I gave in the csv file is 'ADMIN'. This role is an existing user role. Unfortunately, the problem still occurs even after trying the 3 fixes given by James.

In the datamanagement guide, it is said that some special processing is done when the GL_USER is specified in the header of the csv file. Can you please let me know what special processing is done apart from inserting into gl_user table. Is there any other table that needs to be populated apart from gl_user?

NOTE: When I use the CSV upload feature in the OTM UI (Business process automation ->Integration->Integration Manager ->Upload and xml/csv transmission) and load the gl_user table, I am able to login from the front end. Problem occcurs only when I use the CSVUtil from command line.

[Philip]

Re: Error creating user via CSVUtil

Anyone try using CSV Upload to update an existing GL_USER? I receive this message 'Only insert and delete is supported on the GL_TABLE'. So, how do I modify a user account via CSV or XML?

[acuartero]

Re: Error creating user via CSVUtil

I've never tried using the CSVUtil to load the gl_user table but I suspect that doing this is bypassing the integration servlet and therefore is bypassing the special post processing steps that occur when you insert via the Integration manager. One thing that it does when you use the Integration manager to insert into that table is that it refreshes the cache so the user is able to login immediately. You may have better luck using something like curl to post directly to the integration servlet URL. That should do the same post processing actions as the Integration Manager.

-Alan

[acuartero]

Re: Error creating user via CSVUtil

Philip,

I don't think you can modify a user via integration. You would need to delete then insert in order to make changes. Doing so can also have undesired side effects. What type of modification are you attempting to do?

-Alan

[Philip]

Re: Error creating user via CSVUtil

Alan,

Thanks so much for the info. We are trying to extract the user accounts from siteminder and post it to OTM via either CSVUtil or HTTP XML integration. The types of modifications include updating username (nickname) and default user roles.

[chrisplough]

Re: Error creating user via CSVUtil

I assume you're trying to setup SSO with automated user creation and modification?

Alan's right - this isn't doable via integration. Direct SQL updates are possible, but there are other related tables to take into consideration and then the issue with app caching, which gets more difficult in a SCA configuration.

Not trying to be a Debby Downer - if you're able to get this working, I'd love to hear about it!

--Chris

[Philip]

Re: Error creating user via CSVUtil

Chris,

You are correct, we are trying to setup SSO with user creation and modifications. One thing we haven't try is using a combo of delete and insert to simulate a modification. I think that should work. I will keep you posted.