-24988,ERR_SQL: sql error - Note 877203 Step 2

[Former Member]

Hi Gurus,

I'm getting this error following step 2 in note 877203 after renaming the user from SAPLCP to SAPLC3

ersb4ci0:sdbap3 9> dbmcli -d LC3 -n ersb4ci0 -u control,xxxxx -uSQL

saplc3,xxxxx sql_execute select * from domain.users

ERR

-24988,ERR_SQL: sql error

-4008,Unknown user name/password combination

As a test when i did this:-

ersb4ci0:sdbap3 10> dbmcli -d LC3 -u SAPLC3,xxxxxx

dbmcli on LC3>sql_execute select * from domain.users

ERR

-24937,ERR_MISSRIGHT: no server rights for this command

---

Additional info :-

dbmcli on LC3>user_get SAPLC3

OK

SERVERRIGHTS=

GUIRIGHTS=

SECONDPASSWORD=NO

DISABLED=NO

COMMENT=

USERTYPE=SAP

Best Regards

[former_member272632 · Accepted solution]

Hi,

check the password of the saplc3 user.

Try to splitt the first command into 2 commands:

ersb4ci0:sdbap3 9> dbmcli -d LC3 -n ersb4ci0 -u control,xxxxx

dbmcli on LC3><b>sql_connect</b> saplc3,xxx

//<i>if last command works, try an sql command:</i>

dbmcli on LC3>sql_execute select username from users

your second command is wrong: you are trying to execute sql's without openning the sql session inside of dbmcli session:

ersb4ci0:sdbap3 10> dbmcli -d LC3 -u SAPLC3,xxxxxx

<i>//here is no sql_connect !!! see example above</i>

dbmcli on LC3>sql_execute select * from domain.users

please try this, I think the problem is a wrong password of saplc3. You can change the password as superdba using the command:

dbmcli -d ... -u control,... -uSQL superdba,xxx sql_execute "alter password SAPLC3 <NEWPASSWORD>"

do not forget to update the connect information for lc10 ...

best regards,

Alexander

[Former Member · Accepted solution]

Thanks for the info Alex.

The Live cache is working fine now, but when I do a query in dbmcli i get table not found message, but I can see theose tables in LC10

I wonder what could be the issue:-

ersb4ci0:sdbap3 5> dbmcli -d LC3 -u superdba,xxxxxx

dbmcli on LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

ERR

-24988,ERR_SQL: sql error

-4004,Unknown table name:/SAPAPO/ORDMAP

---

dbmcli on LC3>exit

OK

---

ersb4ci0:sdbap3 6> dbmcli -d LC3 -n ersb4ci0 -u superdba,xxxxx

dbmcli on ersb4ci0 : LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

ERR

-24988,ERR_SQL: sql error

-4004,Unknown table name:/SAPAPO/ORDMAP

---

---

ersb4ci0:sdbap3 7> dbmcli -d LC3 -n ersb4ci0 -u superdba,xxxxxx

dbmcli on ersb4ci0 : LC3>sql_execute select * from domain.users

OK

END

'SUPERDBA';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093533';'20071204';'00093533';'20071204';'00093533';'LC3';'ersb4ci0';0;(null)

---

---

ersb4ci0:sdbap3 8> dbmcli -d LC3 -u superdba,xxxxx

dbmcli on LC3>sql_execute select * from domain.users

OK

END

'SUPERDBA';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093533';'20071204';'00093533';'20071204';'00093533';'LC3';'ersb4ci0';0;(null)

---

[former_member229109 · Accepted solution]

Hello,

-> What are the liveCache versions of the LCP & LC3 liveCache instances?

-> You run::

"ersb4ci0:sdbap3 5> dbmcli -d LC3 -u superdba,xxxxxx

dbmcli on LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

"

??

Please run the following commands:

dbmcli -d LC3 -n ersb4ci0 -u control,xxxxx

dbmcli on LC3>sql_connect superdba,xxxxxx

dbmcli on LC3>sdl_execute select * from domain.users

dbmcli on LC3>sql_execute select * from tables where owner='SAPLCP'

dbmcli on LC3>sql_execute select * from tables where owner='SAPLC3'

dbmcli on LC3>sdl_release

dbmcli on LC3>sdl_connect saplc3,xxxxx

dbmcli on LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

dbmcli on LC3>sdl_release

-> What steps of the note 877203 was you able to run already?

Thank you and best regards, Natalia Khlopina

[Former Member · Accepted solution]

Hi Natalia,

I've attached the command outputs.

Earlier testing using the note 877203 I was able to perform steps until renaming the SAPLCP to SAPLC3. The "-uSQL saplc3,sap

sql_execute select * from domain.users" didn't work for me

Currently current database newly initialized LC3(from lc10)

ersb4ci0:sdbap3 4> dbmcli -d LC3 -n ersb4ci0 -u control,xxxxx

dbmcli on ersb4ci0 : LC3>sql_connect superdba,xxxxx

OK

---

dbmcli on ersb4ci0 : LC3>sql_execute select * from domain.users

OK

END

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093533';'20071204';'00093557';'20071204';'00093533';'LC3';'ersb4ci0';10;(null)

'SUPERDBA';'';'DOMAIN';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093537';'20071204';'00093538';'20071204';'00093537';'LC3';'ersb4ci0';11;(null)

'SUPERDBA';'';'SYS';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093539';'20071204';'00093539';'20071204';'00093539';'LC3';'ersb4ci0';12;(null)

'SUPERDBA';'';'SYSINFO';'RESOURCE';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093542';'20071204';'00093542';'20071204';'00093542';'LC3';'ersb4ci0';13;(null)

'SUPERDBA';'';'SAPLC3';'DBA';'MULTIPLE';(null);(null);(null);'ASCII';'20071204';'00093543';'20071204';'00093543';'20071204';'00093605';'LC3';'ersb4ci0';14;(null)

'SUPERDBA';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20071204';'00093533';'20071204';'00093533';'20071204';'00093533';'LC3';'ersb4ci0';0;(null)

---

dbmcli on ersb4ci0 : LC3>sql_execute select * from tables where owner='SAPLCP'

ERR

-24988,ERR_SQL: sql error

100,Row not found

---

dbmcli on ersb4ci0 : LC3>sql_execute select * from tables where owner='SAPLC3'

OK

END

'SAPLC3';'/SAPAPO/OM_LCPROFDATA';'';'TABLE';'TABLE';'20071204';'00093612';'20071204';'00093612';'20071204';'00093612';'NO';(null);20000;(null);'';'NO';'NO';'NO'

'SAPLC3';'/SAPAPO/ORDKEY';'';'TABLE';'TABLE';'20071204';'00093611';'20071204';'00093611';'20071204';'00093611';'NO';(null);20000;(null);'';'NO';'NO';'NO'

'SAPLC3';'/SAPAPO/ORDMAP';'';'TABLE';'TABLE';'20071204';'00093611';'20071204';'00093611';'20071204';'00093611';'NO';(null);20000;(null);'';'NO';'NO';'NO'

'SAPLC3';'MATRIXINDEXTAB';'';'TABLE';'TABLE';'20071204';'00093612';'20071204';'00093612';'20071204';'00093612';'NO';(null);20000;(null);'';'NO';'NO';'NO'

'SAPLC3';'MMRP_DATEVECS';'';'TABLE';'TABLE';'20071204';'00093612';'20071204';'00093612';'20071204';'00093612';'NO';(null);20000;(null);'';'NO';'NO';'NO'

'SAPLC3';'RPM_PERF_DATA';'';'TABLE';'TABLE';'20071204';'00093612';'20071204';'00093612';'20071204';'00093612';'NO';(null);20000;(null);'';'NO';'NO';'NO'

'SAPLC3';'RPM_PLAN_FILE';'';'TABLE';'TABLE';'20071204';'00093612';'20071204';'00093612';'20071204';'00093612';'NO';(null);20000;(null);'';'NO';'NO';'NO'

---

dbmcli on ersb4ci0 : LC3>sql_release

OK

---

dbmcli on ersb4ci0 : LC3>sql_connect saplc3,xxxxx

OK

---

dbmcli on ersb4ci0 : LC3>sql_execute select * from domain.users

OK

END

'SUPERDBA';'';'SUPERDBA';'SYSDBA';(null);(null);(null);(null);'DEFAULT';'20071204';'00093533';'20071204';'00093557';(null);(null);'LC3';'ersb4ci0';10;(null)

'SUPERDBA';'';'DOMAIN';'DBA';(null);(null);(null);(null);'DEFAULT';'20071204';'00093537';'20071204';'00093538';(null);(null);'LC3';'ersb4ci0';11;(null)

'SUPERDBA';'';'SYS';'DBA';(null);(null);(null);(null);'DEFAULT';'20071204';'00093539';'20071204';'00093539';(null);(null);'LC3';'ersb4ci0';12;(null)

'SUPERDBA';'';'SYSINFO';'RESOURCE';(null);(null);(null);(null);'DEFAULT';'20071204';'00093542';'20071204';'00093542';(null);(null);'LC3';'ersb4ci0';13;(null)

'SUPERDBA';'';'SAPLC3';'DBA';'MULTIPLE';(null);(null);(null);'ASCII';'20071204';'00093543';'20071204';'00093543';'20071204';'00093605';'LC3';'ersb4ci0';14;(null)

'SUPERDBA';'';'CONTROL';'ADMIN';(null);(null);(null);(null);'DEFAULT';'20071204';'00093533';'20071204';'00093533';(null);(null);'LC3';'ersb4ci0';0;(null)

---

dbmcli on ersb4ci0 : LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

ERR

-24988,ERR_SQL: sql error

100,Row not found

---

dbmcli on ersb4ci0 : LC3>sql_execute select LOGSYS, count(*) from "SAPLCP"."/SAPAPO/ORDMAP" group by logsys

ERR

-24988,ERR_SQL: sql error

-4004,Unknown table name:/SAPAPO/ORDMAP

---

dbmcli on ersb4ci0 : LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

ERR

-24988,ERR_SQL: sql error

100,Row not found

---

dbmcli on ersb4ci0 : LC3>sql_release

OK

---

[Former Member · Accepted solution]

Version 7.5 0035 for both

[former_member229109 · Accepted solution]

Hello,

you was able to run the SQL statement as SAPLC3 user:

dbmcli on ersb4ci0 : LC3>sql_execute select LOGSYS, count(*) from "SAPLC3"."/SAPAPO/ORDMAP" group by logsys

ERR

-24988,ERR_SQL: sql error

100,Row not found

=> the table /SAPAPO/ORDMAP is empty.

You could run as owner of this table the SQL statement:

select count(*) from "SAPLC3"."/SAPAPO/ORDMAP"

=> to see number of entries in the table.

If you got "100,Row not found" => then no rows in the table ...

-> What is the current issue?

-> Go further with your steps - procedure.

-> As SAP customer you have opotunity to create the OSS message,

therefore we could logon to your system & check the steps you run

during the Homogenous liveCache copy procedure on your system.

Thank you & best regards, Natalia Khlopina

[former_member272632 · Accepted solution]

Hi,

this a critical point if you say: from lc10 you can see the table and from dbmcli you can not see it.

Check the connection information (Integration data) in lc10. It is most possible, that you are still connecting to the old liveCache. be sure , that you are working with the new instance. otherwise lcinit will hit the old instance!

regards,

Alexander

[Former Member · Accepted solution]

Yes Alex I'm aware of that, but since like Natalia said, since the table is empty, when do a count it simply says no row error

I can see the table in LC but the contents are empty, so we're good

Thanks all