Re: SQL Studio navigation tree is empty!! (Solved)

[Adriano Ferlin]

Hi Massimo,

   It was solved with Markus' help. It's here the solution:

>>
SQLStudio has a textbox at the top which is for entering starts
(usually start characters)
of objects (tables, indexes, etc. (but not owned users)) to narrow down
a bit what you see
in case of big data models.

could it be that you entered the IP adress of the server machine into it ?
IF so, clear the textbox and push the refresh button near it.
Then you should be able to see the tables.
>>

   Thanks for all,

Adriano.

 Massimo Renzi <[EMAIL PROTECTED]> wrote:

Hi,

the database seems ok.

I think also that u have to check if exist the folder and full permissions for the user and usergroup sapdb:

1. /usr/spool/sql/ipc/sapdb/db

2. /usr/spool/sql/ipc/sapdb/us

 

Try to restart your linux, so start the sapdb server, start sapdb database, put the database on line. ./x_server, db_start, db_online

So exit from dbmcli on linux.

 

Go in sqlStudio, unchek the chekbox "Wan Mode", chek the chekbox "No Timeout".

Try to connect with the user DBA password DBA.

 

bye

maxsoft

irc-chat:
server address: LasVegas.NV.US.Undernet.org
server port: 6667
channel: #sapdb

-----Messaggio originale-----
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Per conto di Adriano Ferlin
Inviato: gioved� 13 febbraio 2003 19.55
A: [EMAIL PROTECTED]
Oggetto: Re: R: SQL Studio navigation tree is empty!!

Hi Massimo,

   These results were generated:

db_restart -> OK

db_online -> OK

db_state -> State ONLINE

db_enum ->

OK
TESTE   /opt/sapdb/depend       7.4.3.10        fast    running
TESTE   /opt/sapdb/depend       7.4.3.10        slow    offline
TESTE   /opt/sapdb/depend       0.0.0.0          test    unknown
TESTE   /opt/sapdb/depend       7.4.3.10        quick   offline
TESTE1  /opt/sapdb/depend       7.4.3.10        fast    running
TESTE1  /opt/sapdb/depend       7.4.3.10        slow    offline
TESTE1  /opt/sapdb/depend &am! ! p;nb! ! sp;     0.0.0.0          test    unknown
TESTE1  /opt/sapdb/depend       7.4.3.10        quick   offline

 Massimo Renzi <[EMAIL PROTECTED]> wrote:

have u tried to go in the server, dbmcli and do:

db_restart

db_online

db_state

db_enum

 

bye

 

send here the commands results

 

maxsoft

irc-chat:
server address: LasVegas.NV.US.Undernet.org
server port: 6667
channel: #sapdb

-----Messaggio originale-----
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Per conto di Adriano Ferlin
Inviato: gioved� 13 febbraio 2003 16.45
A: '[EMAIL PROTECTED]'
Oggetto: RE: SQL Studio navigation tree is empty!!

Hi Markus,

     Thanks for your attention. I did what you said, but the problem persists. I have used this script to create new users:

CREATE USER test PASSWORD test DBA NOT EXCLUSIVE

and

CREATE USER test1 PASSWORD test1 DBA EXCLUSIVE

    I tried to connect with both users, and in WAN Mode too, but the tree navigator doesn't lists the objects of the database. I tried to reinstall the SQL Studio, ODBC driver and DBM GUI too.

    I really don't know what to do. I'm thinking to reinstall sapdb. Do you have some idea??

    Thanks,

 

Adriano.

 "Stausberg, Markus" <[EMAIL PROTECTED]> wrote:

Hi Adriano,

you wrote :
>I'm connected to a linux server with sapdb 7.4.3. I'm using Win2000 and SQL Studio to generate >tables remotely, but when I start SQL Studio as SYSDBA, no one table, indexes or sequences
>appears in the navigation tree. The database is running. What is going wrong?

There are three possible reasons for this behavior :
1. The system tables have not been loaded properly during instance creation
You could redo this using e.g. DBMGui.
2. You are in SQLStudio WAN mode, which is more bandwidth friendly for connecting
over a slow (e.g. modem) connection.
3. The user sysdba was not created as 'not exclusive' , thus, can only use a single
db connection (the catalog manager needs a second one besides the one which
is used for submitting user queries).

check these conditions, if problems persist, feel free to post agai! ! ! ! ! ! n.

regards

Markus Stausberg
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

---

Busca Yahoo!
O servi�o de busca mais completo da Internet. O que voc� pensar o Yahoo! encontra.

---

Busca Yahoo!
O servi�o de busca mais completo da Internet. O que voc� pensar o Yahoo! encontra.

---

Busca Yahoo!
O servi�o de busca mais completo da Internet. O que voc� pensar o Yahoo! encontra.