[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]

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]

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]

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.