why sap<sid> and sapr3 cannot be found in LiveCache 7.6.03?

[Former Member]

According to note 632357, I should be able to find them but I CANNOT find either of them.

Do you why? The LC is functional . Thanks!

[lbreddemann · Accepted solution]

How do you try to find these users?

regards,

Lars

[Former Member · Accepted solution]

Per the OSS note , I run

dbmcli.exe on LC1>sql_execute select * from domain.users where username = 'SAPR3'

ERR

-24988,ERR_SQL: SQL error

100,Row not found

---

Thanks!

[lbreddemann · Accepted solution]

> dbmcli.exe on LC1>sql_execute select * from domain.users where username = 'SAPR3'

> ERR

> -24988,ERR_SQL: SQL error

> 100,Row not found

Please run 'sql_execute select user from dual'

before your statement and post the result.

I want to know with which account you're logged in.

Be sure to use the SUPERDBA user for that!

regards,

Lars

[Former Member · Accepted solution]

Lars:

I used 2 IDs : control and superdba.

For user control; dual returns "control"

For superdba, dual returns "a".

However none of the a users can find users sap<sid> and sapr3 by running

sql_execute select * from domain.users.

Please advise. Thnaks!

[lbreddemann · Accepted solution]

>

> Lars:
> 
> I used 2 IDs : control and superdba.
> For user control; dual returns "control"
> For superdba,  dual returns "a".
> 
> However none of the a users can find users sap<sid> and sapr3 by running
> 
> sql_execute  select * from domain.users.
> 
> Please advise. Thnaks!

Pretty odd...

when I try this I get the following:

C:\Dokumente und Einstellungen\Lars>dbmcli -d db76 -u superdba,admin
dbmcli on db76>sql_connect
OK

---
dbmcli on db76>sql_execute select user from dual
OK
END
'CONTROL'

---
dbmcli on db76>sql_execute select username from domain.users
OK
END
'CONTROL'
'SUPERDBA'
'MONA'
'LARS'
'TEST'

---

==> NOW LOGON TO SQL SESSION AS SYSDBA

dbmcli on db76>sql_connect superdba,admin
OK

---
dbmcli on db76>sql_execute select user from dual
OK
END
'SUPERDBA'

---
dbmcli on db76>sql_execute select username from domain.users
OK
END
'CONTROL'
'SUPERDBA'
'MONA'
'LARS'
'TEST'

---
dbmcli on db76>

So the

sql_execute select user from dual

should always return the SQL user you're logged on with - if it just gives 'a' then you probably ran 'select * from dual'.

Hmm... let's see... please run this statement as SUPERDBA and post the output

sql_connect superdba,<pw>
sql_execute select username, usermode from domain.users

regards,

Lars

[Former Member · Accepted solution]

Sorry for being late -- all morning meetings.

Here you are:

dbmcli.exe on LC1>sql_connect superdba,manager

OK

dbmcli.exe on LC1>sql_execute select username, usermode from domain.users

OK

END

'CONTROL';'ADMIN'

'DBSERVICE';'DBA'

'SUPERDBA';'SYSDBA'

'LC1ADM';'DBA'

dbmcli.exe on LC1>sql_execute select user from dual

OK

END

'SUPERDBA'

Thanks!!

[lbreddemann · Accepted solution]

Hi Jennifer,

actually it looks like if the liveCache there is not really the default setup...

Please check in the SCM system transaction LC10 what user is used for the integration of your liveCache with the SCM system.

The users "DBSERVICE" and "LC1ADM" are usually not present - so I assume that maybe one of them contains your liveCache data.

regards,

Lars

[former_member229109 · Accepted solution]

Hello Jennifer,

1) "why sap<sid> and sapr3 cannot be found in LiveCache 7.6.03? "

=> Did you select the 'LC1ADM' as liveCache standard user during the

liveCache installation?

Please check the LCA/LDA/LEA connections settings in LC10-> Integration.

Please also post the output of the SQL command:

select * from users

2) To make sure that the lcinit script works with the correct

user 'LC1ADM' you should run the commands to check the

liveCache user in the upc container:

In a dbmcli session (e.g. in LC10 ) < Tools -> DBMCLI >

sql_execute user-type=SAP select user from dual

Should return this user.

When an error returns ( unkown user/password ),

then no user is set.

To set the 'LC1ADM' user run on the liveCache server:

dbmcli -d LC1 -u control,<control> user_sap LC1ADM,<pwd>

( please see the note 616555 for more details ).

in an dbmcli session. This sets the new user in the upc container.

After that the above command should return LC1ADM

3) Are you planning to apply the SAP Note No. 632357?

Thank you and best regards, Natalia Khlopina

Edited by: Natalia Khlopina on Apr 29, 2009 7:47 PM