Livacache Connectivity Issue

[Former Member]

Hi Colleagues,

The standard liveCache user from the integration data must be known to  the DBM Server for this action.                                        

Refer to SAP Note 821200                                              

Name of the Database Connection:                                        LCA                                                                    

Database User in the Integration Information:                           SAPTGL                                                                 

Database User in the User Profile Container (UPC):                      SAPR3                                                                  

Type of the Database User in the UPC:                       SAP                                                                                                                                           

The two DB users do not match.                                        

Adjust the integration information or                                   define the database user in the UPC                                     (see SAP Note 616555).

I tried :

dbmcli on TGL>USER_SAP SAPTGL,admin

ERR

-24949,ERR_USREXISTS: User name already exists

dbmcli on TGL>user_get SAPTGL

OK

SERVERRIGHTS=DBInfoRead,SystemCmd,ExecLoad,UserMgm,DBFileRead,Backup,InstallMgm,LoadSysTab,ParamCheckWrite,ParamFull,ParamRead,DBStart,DBStop,Recovery,AccessSQL,AccessUtility,SharedMemoryMgm,SchedulerMgm,Scheduling,EvtDispMgm,EvtDisp

GUIRIGHTS=

SECONDPASSWORD=NO

DISABLED=NO

COMMENT=SAPTGL

USERTYPE=

So how to change user type to SAP.??

Currently for SAPR3 the user type is SAP

Kindly provide the solution for the issue

Regards,

Nivedita

[premsukh_bishnoi · Accepted solution]

Hi Nivedita,

Please check below wiki link:  http://wiki.sdn.sap.com/wiki/display/MaxDB/User+Profile+Container

Please let me know if you require more information.

Regards, Premsukh

[Former Member · Accepted solution]

Hi Premsukh,

Issue resolved with the help of above link.Thanks for your support

Regards,

Nivedita