cancel
Showing results for 
Search instead for 
Did you mean: 

24961,ERR_STATE

Former Member
0 Kudos

Hi all,

on MAXDB 7.6 on Win 2008

I backupe a MAXDB database by following command line :

 

dbmcli -d !DB_NAME! -u !DB_USER!,!DB_PWD! -uUTL -c backup_start !MEDIUM_NAME! > "!LOG_file!"

But I receive the follwing eerors :

 

ERR

-24961,ERR_STATE: The operational state of the database instance could not be determined

-24994,ERR_RTE: Runtime environment error

16006,OpenReadOnly file mapping object for Global\ADABAS-KSS-SSM failed, rc: 5

Any help ? Thank you.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thank you.

GUI is installed and database is online (green buton).

Also ,

On cmd box :

P:\BAW_Scripts\BDD_Backup>dbmcli.exe -d MYDB -u user,password -c sql_execute select count(*) from BACKUPTHREADS

ERR

-24961,ERR_STATE: The operational state of the database instance could not be determined

-24994,ERR_RTE: Runtime environment error

16006,OpenReadOnly file mapping object for Global\ADABAS-KSS-SSM failed, rc: 5

Regards.

former_member188883
Active Contributor
0 Kudos

Hi,

Did you connect to the database server via Terminal Server remote access?

Please review Microsoft Knowledge Base Article - 821546

Regards,

Deepak Kori

Former Member
0 Kudos

Hi,

thanks.

you asked :

Did you connect to the database server via Terminal Server remote access?

My answer is :

yes , it is the only way by which I connect to.

Regards.

former_member188883
Active Contributor
0 Kudos

Hi,

Refer this thread. Similar issue is resolved by login as console user.

https://scn.sap.com/thread/1908284

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks .

I saw that thread and KB and add our user to Create global objects and Impersonate a client after authentication. But unfortunataly the problem persist.

Also

C:\Windows\system32>dbmcli -s dbm_version
OK
VERSION    = 7.7.04
BUILD      = DBMServer 7.7.04   Build 028-123-194-355
OS         = WIN64
INSTROOT   = P:\sapdb\SSM\db
LOGON      = True
CODE       = UTF8
SWAP       = full
UNICODE    = YES
INSTANCE   = (unknown)
SYSNAME    = Windows
MASKING    = YES
REPLYTREATMENT = none,zlib,auto

C:\Windows\system32>dbmcli  -d weiterer -n localhost -u fleet,one4allke db_state
Error! Connection failed to node localhost for database weiterer:
database or server not found

C:\Windows\system32>dbmcli  -d weiterer -n localhost -u fleet,one4allke -uUTL
Error! Connection failed to node localhost for database weiterer:
database or server not found

C:\Windows\system32>

former_member188883
Active Contributor
0 Kudos

Hi,

Do you use console user ?

If not, try with that and post the results.

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks.

Sorry, what is console user ?

I connect by Win Terminal server I have this error :

-24961,ERR_STATE: The operational state of the database instance could not be determined 

-24994,ERR_RTE: Runtime environment error

I connect directly on server I have the same error.

Regards.

former_member188883
Active Contributor
0 Kudos

Hi,

The console session is what you see when you look at a monitor that’s plugged into the server. Normally with RDP/WTS you get your own session that is not the same as what’s shown on the server’s own monitor.

A typical example might be a backup application that is running on the console. You don’t want to log into a new session and start a second copy of the backup application; you want to monitor the backup application running in the console session.

You may login to server using mstsc /v console or mstsc /v admin to get console login.

Regards,

Deepak Kori

Former Member
0 Kudos

Thanks again.

I openned a session like this :

mstsc /console

And I connected to the server , and ran :

dbmcli.exe -d MYDB -u user,password -c sql_execute select count(*) from BACKUPTHREADS

And received 

ERR

-24961,ERR_STATE: The operational state of the database instance could not be determined

-24994,ERR_RTE: Runtime environment error

16006,OpenReadOnly file mapping object for Global\ADABAS-KSS-SSM failed, rc: 5

Regards.

former_member188883
Active Contributor
0 Kudos

Hi,

Login as console session and provide output of following commands

sdbregview -l

dbmcli  -d DBSID -n localhost -u control,control db_state

dbmcli  -d DBSID -n localhost -u control,control -uUTL

Regards,

Deepak Kori

Former Member
0 Kudos

Hi,

thanks.

Here they are :

sdbregview -l
C:\Windows\system32>sdbregview -l
DB Analyzer         p:/sapdb/programs    7.7.04.28     64 bit    valid
Server Utilities    p:/sapdb/programs    7.7.04.28     64 bit    valid
PCR 7301            p:/sapdb/programs    7.3.01.22               valid
PCR 7500            p:/sapdb/programs    7.5.00.50     64 bit    valid
SAP Utilities       p:/sapdb/programs    7.7.04.28     64 bit    valid
Base                p:/sapdb/programs    7.7.04.28     64 bit    valid
Redist Python       p:/sapdb/programs    7.7.04.28     64 bit    valid
JDBC                p:/sapdb/programs    7.6.05.06               valid
Messages            p:/sapdb/programs    MSG 0.7113              valid
ODBC                p:/sapdb/programs    7.7.04.28     64 bit    valid
SQLDBC 77           p:/sapdb/programs    7.7.04.28     64 bit    valid
Database Kernel     p:/sapdb/ssm/db      7.7.04.28     64 bit    valid
Loader              p:/sapdb/programs    7.7.04.28     64 bit    valid
SQLDBC              p:/sapdb/programs    7.7.04.28     64 bit    valid
Fastload API        p:/sapdb/programs    7.7.04.28     64 bit    valid
SQLDBC 76           p:/sapdb/programs    7.6.05.09     64 bit    valid

dbmcli  -d DBSID -n localhost -u control,control db_state
OK
State
ONLINE

dbmcli  -d DBSID -n localhost -u control,control -uUTL
dbmcli on localhost : DBSID>exit
OK

former_member188883
Active Contributor
0 Kudos

Hi,

dbmcli  -d DBSID -n localhost -u control,control db_state

OK

State

ONLINE

You are able to connect to database. Looks like problem resolved.

Regards,

Deepak Kori

Former Member
0 Kudos

Yes.

Thank you.

Former Member
0 Kudos

Hi all,

to moderator :

please may I know why my posts are no more approved ?

Thanks and regards.

thorsten_zielke
Contributor
0 Kudos

Hi,

could you clarify what you mean by "no more apporved"?

Thorsten

Former Member
0 Kudos

Hi,

thank you so much.

Yesterday I posted a discussion waiting to be approved. Until now I have received no approval notification. And my post is not on forum. Then for me it means it is not approved. Since my (last) discussion is not approved I wrote :  my posts are no more approved.

Why ?

To day again I created a discussion, not approuved  ?

Regards.

thorsten_zielke
Contributor
0 Kudos

Hi,

issue should be fixed no and your posts approved.

Thorsten

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi,

Could you install DBMGui and check the database state ( whether it is online/offline).

or

Connect to database using dbmcli and check database status using db_status.

Additionally refer wiki http://wiki.sdn.sap.com/wiki/display/MaxDB/HowTo+-+SAP+MaxDB+backup+with+Database+Manager+CLI

Regards,

Deepak Kori