• 1 reply
  • Latest Post - ‏2013-11-13T18:27:31Z by Phil B.
27 Posts

Pinned topic RAA Logon Error

‏2013-11-12T18:35:04Z |

Hi Everyone,


While i am trying to login into new install RAA. I'm getting following error.

DMH5364E: Unexpected exception occurred. Message=[SQL exception on prepared statement [SELECT user_id FROM $(SCHEMA).dmh_user WHERE UCASE(SUBSTR(user_name, 1, 8)) = UCASE(SUBSTR(?, 1, 8))]|[SELECT user_id FROM DMH.dmh_user WHERE UCASE(SUBSTR(user_name, 1, 8)) = UCASE(SUBSTR(?, 1, 8))] trying to set parameter [1] with value [java.lang.String:db2admin]. Caused by: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DMH.DMH_USER, DRIVER=3.57.82 Caused by: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-204;42704;DMH.DMH_USER, DRIVER=3.57.82]


Kindly help us to resolve this error. Why we facing this error.

Error Screenshot attached!



Shajeel K


  • Phil B.
    Phil B.
    252 Posts

    Re: RAA Logon Error


    It sounds like an error occurred when creating the database during install.   To gather the install logs, go to Installation Manager and choose Help -> Export Data For Problem Analysis.   Then, post the logs here.

    I see that you're using db2admin to log into RAA.   What userid were you logged into Windows as when you installed RAA?  What DB2 authority does that userid have?   What userid was specified on the DB2 panel of the RAA install for the database userid?