SMP 2.3 How to open SMP database

[Former Member]

Hi all.

In some cases it might be extremely useful to be able to open and edit SMP DB directly.

For example, not all settings or features are presented in SCC. And existing user data or connection data in SMP DB may stop your development process.

Anyway, I found this article in scn wiki which is useful:

Checklist for troubleshooting an unresponsive SUP and SMP 2.X servers - SAP Mobility - SCN Wiki

and I tried to access SMP DB and succeded.

Here are the steps:

1) Access your SMP server computer.

2) Open folder C:\SAP\MobilePlatform\Servers\SQLAnywhere12\BIN32

3) Run scjview.exe

4) In opened Sybase Central database explorer window you will see 3 items:

     -SQL Anywhere 12

     -Mobilink 12

     -Ultralite 12

5) Select item you want and double click.

6) Default login/password is dba / sql

6) I opened SQL Anywhere 12. Inside there is your server called [YourServername_primary]. Inside there are databases clusterdb, default, monitordb, domainlogdb.

7) Inside you will find all tables. Search for what info you need. Also you can edit data.

[former_member185504]

Hi Mikhail,

Thank you very much for the information. Although, some more specific guide adn maybe some more screenshots i think they will be useful to everyone.

Are you trying from yor Application Server of from the DB?

Under which specific path are the :defaulsdb, monitordb e.t.c. files?

Whe you double click the SQL anywhere icon on Sybase Central it gives a settings window to fill. What is the setting you chose to connect to the DB?

I didnt manage to make the connection myself.

Thanks

George Lazaridis

[Jitendra_Kansal]

There are few blogs i had written while working on SUP 2.2, you can follow it

If you have other queries, please raise a new thread.

Regards,

JK

[former_member185504]

H Jitendra,

Thanks!!

Really appreciate it!!