cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

com.sap.sdb.tools.databasemanagement.DM_Exception: Runtime environment erro

Go to solution
Former Member

on ‎05-20-2009 2:32 AM

0 Kudos

Hi,

using Database Studio when i click on Analyzer tab of Administration tool i get follow error:

------------------------------------------------------------------------------------------------------------------------
19/05/2009      22:12:05
------------------------------------------------------------------------------------------------------------------------
ERROR           Runtime environment error
1,OS error: 'No such file or directory'
------------------------------------------------------------------------------------------------------------------------
Component     : UIDBM
Detail Message: com.sap.sdb.tools.databasemanagement.DM_Exception: Runtime environment error
1,OS error: 'No such file or directory'
	at com.sap.sdb.tools.databasemanagement.internal.DM_Session.execute(DM_Session.java:150)
	at com.sap.sdb.tools.databasemanagement.internal.commands.DM_BaseCommand.doExecute(DM_BaseCommand.java:130)
	at com.sap.sdb.tools.databasemanagement.internal.commands.DM_DatabaseCommand.doExecute(DM_DatabaseCommand.java:53)
	at com.sap.sdb.tools.databasemanagement.internal.commands.DM_BaseCommand.execute(DM_BaseCommand.java:69)
	at com.sap.sdb.tools.databasemanagement.internal.DM_AnalyzerLog.open(DM_AnalyzerLog.java:66)
	at com.sap.sdb.tools.databasemanagement.internal.DM_AnalyzerLogItems.readItems(DM_AnalyzerLogItems.java:99)
	at com.sap.sdb.tools.databasemanagement.internal.DM_AnalyzerLogItems.refresh(DM_AnalyzerLogItems.java:89)
	at com.sap.sdb.tools.ui.dbm.model.AnalyzerLogAdapter.fetchDeferredChildren(AnalyzerLogAdapter.java:82)
	at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:207)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)

is something wrong in my configurations or Analyzer tab cant check analyzer files from a remote server?

regards

Clóvis

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
‎05-20-2009 6:49 AM
0 Kudos

Hi Clovis,

this should work...

What version of the Database Studio do you use?

Windows platform?

regards,

Lars

Show replies
Show replies
Former Member
‎05-20-2009 1:43 PM
0 Kudos

Hi Lars,

i'm using:

Database Studio

Version: 7.7.03.23

Build: 023-123-174-368

the same error occurs on Windows Vista and Windows XP, the maxdb server is installed on a remote linux machine.

best regards.

Clóvis

lbreddemann
Active Contributor
‎05-20-2009 1:50 PM
0 Kudos

Hi Clovis,

I don't know the reason for this issue, but could you (just to make things easier on the analysis side) install the current version of DB Studio 7.7.06.09 ?

regards,

Lars

Former Member
‎05-20-2009 4:03 PM
0 Kudos

Hi Lars,

same error with newer version:


------------------------------------------------------------------------------------------------------------------------
20/05/2009      11:59:42
------------------------------------------------------------------------------------------------------------------------
ERROR           Runtime environment error
1,OS error: 'No such file or directory'
------------------------------------------------------------------------------------------------------------------------
Component     : UIDBM
Detail Message: com.sap.sdb.tools.databasemanagement.DM_Exception: Runtime environment error
1,OS error: 'No such file or directory'
	at com.sap.sdb.tools.databasemanagement.internal.DM_Session.execute(DM_Session.java:207)
	at com.sap.sdb.tools.databasemanagement.internal.commands.DM_BaseCommand.doExecute(DM_BaseCommand.java:139)
	at com.sap.sdb.tools.databasemanagement.internal.commands.DM_DatabaseCommand.doExecute(DM_DatabaseCommand.java:54)
	at com.sap.sdb.tools.databasemanagement.internal.commands.DM_BaseCommand.execute(DM_BaseCommand.java:74)
	at com.sap.sdb.tools.databasemanagement.internal.DM_AnalyzerLog.open(DM_AnalyzerLog.java:66)
	at com.sap.sdb.tools.databasemanagement.internal.DM_AnalyzerLogItems.readItems(DM_AnalyzerLogItems.java:99)
	at com.sap.sdb.tools.databasemanagement.internal.DM_AnalyzerLogItems.refresh(DM_AnalyzerLogItems.java:89)
	at com.sap.sdb.tools.ui.dbm.model.AnalyzerLogAdapter.fetchDeferredChildren(AnalyzerLogAdapter.java:82)
	at org.eclipse.ui.progress.DeferredTreeContentManager$1.run(DeferredTreeContentManager.java:196)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

any idea to follow?

best regards

Clóvis

lbreddemann
Active Contributor
‎05-20-2009 7:52 PM
0 Kudos

Yeah, well - nearly expected this...

Could you run a

dbmcli -d <DBSID> -u <dbm>,<dbm> file_getfirst ANALYZER

Former Member
‎05-20-2009 9:20 PM
0 Kudos

Hi Lars,

the output is of file_getfirst ANALYZER is:

0
     END
                1121                1121
keyname,mode,size,date,time,comment,filename
ANALYZER#/DBAN.inf	UNKNOWN	412	20090520	093320  	DB Analyzer File	DBAN.inf
ANALYZER#/DBAN.sid	UNKNOWN	8	20090520	093320  	DB Analyzer File	DBAN.sid
ANALYZER#/DBAN.pid	UNKNOWN	5	20090520	093320  	DB Analyzer File	DBAN.pid
ANALYZER#/20090430	DIRECTORY	4096	20090430	160013  	DB Analyzer File	20090430
ANALYZER#/20090504	DIRECTORY	4096	20090504	101808  	DB Analyzer File	20090504
ANALYZER#/20090511	DIRECTORY	4096	20090511	100119  	DB Analyzer File	20090511
ANALYZER#/20090514	DIRECTORY	4096	20090514	141050  	DB Analyzer File	20090514
ANALYZER#/20090515	DIRECTORY	4096	20090515	101220  	DB Analyzer File	20090515
ANALYZER#/20090516	DIRECTORY	4096	20090516	000138  	DB Analyzer File	20090516
ANALYZER#/20090517	DIRECTORY	4096	20090517	000206  	DB Analyzer File	20090517
ANALYZER#/20090518	DIRECTORY	4096	20090518	000141  	DB Analyzer File	20090518
ANALYZER#/DBAN.err	UNKNOWN	202	20090518	214445  	DB Analyzer File	DBAN.err
ANALYZER#/20090519	DIRECTORY	4096	20090519	160739  	DB Analyzer File	20090519
ANALYZER#/20090520	DIRECTORY	4096	20090520	090639  	DB Analyzer File	20090520

best regards.

Clóvis

lbreddemann
Active Contributor
‎05-20-2009 11:53 PM
0 Kudos

grrr... looks like the forum currently likes to eat up half of my posts...

There was quite a lot missing there from what I originally wrote.

Anyhow, let's move on here.

> the output is of file_getfirst ANALYZER is:

> 

0
>      END
>                 1121                1121
> keyname,mode,size,date,time,comment,filename
> ANALYZER#/DBAN.inf	UNKNOWN	412	20090520	093320  	DB Analyzer File	DBAN.inf
> ANALYZER#/DBAN.sid	UNKNOWN	8	20090520	093320  	DB Analyzer File	DBAN.sid
> ANALYZER#/DBAN.pid	UNKNOWN	5	20090520	093320  	DB Analyzer File	DBAN.pid
> ...
> ANALYZER#/DBAN.err	UNKNOWN	202	20090518	214445  	DB Analyzer File	DBAN.err
> ANALYZER#/20090519	DIRECTORY	4096	20090519	160739  	DB Analyzer File	20090519
> ANALYZER#/20090520	DIRECTORY	4096	20090520	090639  	DB Analyzer File	20090520

As you've probably noticed by now, file_getfirst delivers you the contents of files/directories in the RUNDIRECTORY.

DB Studio uses this command to get all the files as well.

So let's try to list the most current folder "ANALYZER#/20090520"


file_getfirst ANALYZER#/20090520

In there should be a file "DBAN.prt".

Please try to display it with file_getfirst as well.

regards,

Lars

Former Member
‎05-21-2009 12:55 PM
0 Kudos

Hi Lars,

file_getfirst ANALYZER#/20090520 returns:

0
     END
                2339                2339
keyname,mode,size,date,time,comment,filename
ANALYZER#/20090520/DBAN.prt	UNKNOWN	1080209	20090520	220608  	DB Analyzer File	DBAN.prt
ANALYZER#/20090520/DBAN_LOGGING.csv	UNKNOWN	6670	20090520	220608  	DB Analyzer File	DBAN_LOGGING.csv
ANALYZER#/20090520/DBAN_CACHES.csv	UNKNOWN	9686	20090520	220608  	DB Analyzer File	DBAN_CACHES.csv
ANALYZER#/20090520/DBAN_FILLING.csv	UNKNOWN	7335	20090520	220608  	DB Analyzer File	DBAN_FILLING.csv
ANALYZER#/20090520/DBAN_GC.csv	UNKNOWN	5392	20090520	220608  	DB Analyzer File	DBAN_GC.csv
ANALYZER#/20090520/DBAN_TASK_IO.csv	UNKNOWN	7026	20090520	220608  	DB Analyzer File	DBAN_TASK_IO.csv
ANALYZER#/20090520/DBAN_IO.csv	UNKNOWN	9976	20090520	220608  	DB Analyzer File	DBAN_IO.csv
ANALYZER#/20090520/DBAN_TRANSACTIONS.csv	UNKNOWN	7319	20090520	220608  	DB Analyzer File	DBAN_TRANSACTIONS.csv
ANALYZER#/20090520/DBAN_TASK_ACTIVITIES.csv	UNKNOWN	9721	20090520	220608  	DB Analyzer File	DBAN_TASK_ACTIVITIES.csv
ANALYZER#/20090520/DBAN_LOAD.csv	UNKNOWN	8867	20090520	220608  	DB Analyzer File	DBAN_LOAD.csv
ANALYZER#/20090520/DBAN_SHARED_SQL.csv	UNKNOWN	9370	20090520	220608  	DB Analyzer File	DBAN_SHARED_SQL.csv
ANALYZER#/20090520/DBAN_STRATEGY_PRIMKEY.csv	UNKNOWN	5612	20090520	220608  	DB Analyzer File	DBAN_STRATEGY_PRIMKEY.csv
ANALYZER#/20090520/DBAN_STRATEGY_INDEX.csv	UNKNOWN	10043	20090520	220608  	DB Analyzer File	DBAN_STRATEGY_INDEX.csv
ANALYZER#/20090520/DBAN_STRATEGY_SCANS.csv	UNKNOWN	6193	20090520	220608  	DB Analyzer File	DBAN_STRATEGY_SCANS.csv
ANALYZER#/20090520/DBAN_BACKUP.csv	UNKNOWN	4740	20090520	220608  	DB Analyzer File	DBAN_BACKUP.csv
ANALYZER#/20090520/DBAN_TASK_STATES.csv	UNKNOWN	6088	20090520	220608  	DB Analyzer File	DBAN_TASK_STATES.csv
ANALYZER#/20090520/DBAN_OVERVIEW.csv	UNKNOWN	6759	20090520	220608  	DB Analyzer File	DBAN_OVERVIEW.csv
ANALYZER#/20090520/DBAN_REGIONS.csv	UNKNOWN	5552	20090520	220608  	DB Analyzer File	DBAN_REGIONS.csv
ANALYZER#/20090520/DBAN_RW_LOCKS.csv	UNKNOWN	5379	20090520	220608  	DB Analyzer File	DBAN_RW_LOCKS.csv
ANALYZER#/20090520/DBAN_SPINLOCKS.csv	UNKNOWN	4720	20090520	220608  	DB Analyzer File	DBAN_SPINLOCKS.csv
ANALYZER#/20090520/DBAN_IOTHREADS.csv	UNKNOWN	5073	20090520	220608  	DB Analyzer File	DBAN_IOTHREADS.csv
ANALYZER#/20090520/DBAN_CPU_UTILIZATION.csv	UNKNOWN	8835	20090520	220608  	DB Analyzer File	DBAN_CPU_UTILIZATION.csv

file_getfirst ANALYZER#/20090520/DBAN.prt returns:

1
CONTINUE
             1080209               15917
===== #0          at 2009-05-20 09:05:30
*  I  Number of CPU's 4, processor type: x86_64
      CON: NUM_PHYSICAL_CPU > 1 
      VAL: 4                > 1 
*  I  Physical memory 3943 MB, virtual memory 6000 MB, memory allocated from instance: 3246 MB
      CON: NUM_PHYSICAL_CPU > 1 
      VAL: 4                > 1 
*  I  Operating system: Linux 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT 2006
      CON: 1 
      VAL: 1 
*  I  Kernel version: Kernel    7.6.03   Build 007-123-157-515
      CON: 1 
      VAL: 1 
*  I  Instance SUNDOWN (dcpr0136n) is up since 2009-05-18 21:45:40
      CON: 1 
      VAL: 1 
*  I  Configuration: number of CPUs (MAXCPU): 4, max user tasks: 500
      CON: 1 
      VAL: 1 
*  I  Size of data cache 2045.56 MB
      CON: DATA_CACHE_SIZE > 1 
      VAL: 2094656         > 1 
*  I  Number of data volumes: 5
      CON: 1 
      VAL: 1 
*  I  PACKET_SIZE is 131072
      CON: ENV_PACKET_SIZE 
      VAL: 131072          
*  I  SQL commands executed: 12921239
      CON: SQL_Cmds > 0 
      VAL: 12921239 > 0 

===== #1          at 2009-05-20 09:06:20
*  I  SQL commands executed: 6346, avg. 97 per second
      CON: PureSQL_Cmds > INTERVAL * 5 
      VAL: 6346         > 68       * 5 
* W3  69 command cache cleanups! 6 commands reloaded, 40960 execution plans and 188 commands deleted
      CON: CmdCacheCleanups > INTERVAL 
      VAL: 69               > 68       
* W3  Task 120 (appl. 0) is waiting for lock 'row_exclusive' on table TITULOPAGAMENTO since 68s, locked 'tab_share' from task 429 (appl. 0, state Vwait)
      CON: LOCK_REQUESTOR_TID["             2898305"] == last(LOCK_REQUESTOR_TID["             2898305"]) && LOCK_WAITER_TRANS["             2898305"] == last(LOCK_WAITER_TRANS["             2898305"]) 
      VAL: 120                                        == 120                                              && 2898305                                   == 2898305                                         
* W3  Task 429 (appl. 0) is waiting for lock 'tab_share' on table TITULOCOBRANCA since 68s, locked 'row_exclusive' from task 348 (appl. 0, state Vwait)
      CON: LOCK_REQUESTOR_TID["             2880370"] == last(LOCK_REQUESTOR_TID["             2880370"]) && LOCK_WAITER_TRANS["             2880370"] == last(LOCK_WAITER_TRANS["             2880370"]) 
      VAL: 429                                        == 429                                              && 2880370                                   == 2880370                                         
* W3  Task 361 (appl. 0) is waiting for lock 'row_exclusive' on table TITULOPAGAMENTO since 68s, locked 'tab_share' from task 429 (appl. 0, state Vwait)
      CON: LOCK_REQUESTOR_TID["             2921405"] == last(LOCK_REQUESTOR_TID["             2921405"]) && LOCK_WAITER_TRANS["             2921405"] == last(LOCK_WAITER_TRANS["             2921405"]) 
      VAL: 361                                        == 361                                              && 2921405                                   == 2921405                                         
* W3  Task 313 (appl. 0) is waiting for lock 'row_exclusive' on table TITULOPAGAMENTO since 68s, locked 'tab_share' from task 429 (appl. 0, state Vwait)
      CON: LOCK_REQUESTOR_TID["             2913185"] == last(LOCK_REQUESTOR_TID["             2913185"]) && LOCK_WAITER_TRANS["             2913185"] == last(LOCK_WAITER_TRANS["             2913185"]) 
      VAL: 313                                        == 313                                              && 2913185                                   == 2913185                                         
* W3  Task 135 (appl. 0) is waiting for lock 'row_exclusive' on table TITULOPAGAMENTO since 68s, locked 'tab_share' from task 429 (appl. 0, state Vwait)
      CON: LOCK_REQUESTOR_TID["             2918713"] == last(LOCK_REQUESTOR_TID["             2918713"]) && LOCK_WAITER_TRANS["             2918713"] == last(LOCK_WAITER_TRANS["             2918713"]) 
      VAL: 135                                        == 135                                              && 2918713                                   == 2918713                                         
* W3  Task 563 (appl. 0) is waiting for lock 'row_exclusive' on table TITULOPAGAMENTO since 68s, locked 'tab_share' from task 429 (appl. 0, state Vwait)
      CON: LOCK_REQUESTOR_TID["             2911020"] == last(LOCK_REQUESTOR_TID["             2911020"]) && LOCK_WAITER_TRANS["             2911020"] == last(LOCK_WAITER_TRANS["             2911020"]) 
      VAL: 563                                        == 563                                              && 2911020                                   == 2911020

lbreddemann
Active Contributor
‎05-21-2009 1:10 PM
0 Kudos

Hi Clovis,

looks like the forum software has issues parsing the markup coding correctly...

Anyhow, as the DBMServer commands did work as expected, something must be wrong with the DB Studio here.

I see two approaches: 1. Delete/Move all DBAnalyzer files and restart the DBAnalyzer to try if the problem is solved by that. In that case I would suspect tha there is some kind of corruption in the DBAN.prt file.

2. Activate the DEBUG tracing for the UIDBM component in DB Studio and check what function is called just before the error occurs.

regards,

Lars

Former Member
‎05-21-2009 5:59 PM
0 Kudos

Hi Lars,

first i followed the step 2.

in trace i can see that Database studio tries to execute follow command:

file_getfirst ANALYZER#20090521dban.prt

but as my database runs on linux the correct is:

file_getfirst ANALYZER#/20090521/DBAN.prt

then maybe the problem is how DB Studio are construct the path to DBAN.prt file, and DBAN.prt must maintain the case, if you try to execute with correct slash but with filename dban.prt the error 'No such file or directory' occurs too.

best regards.

Clóvis

lbreddemann
Active Contributor
‎05-21-2009 6:48 PM
0 Kudos

>

> Hi Lars,

>

> in trace i can see that Database studio tries to execute follow command:

>

> 

file_getfirst ANALYZER#\20090521\dban.prt

>

> but as my database runs on linux the correct is:

>

> 

file_getfirst ANALYZER#/20090521/DBAN.prt

>

> then maybe the problem is how DB Studio are construct the path to DBAN.prt file, and DBAN.prt must maintain the case, if you try to execute with correct slash but with filename dban.prt the error 'No such file or directory' occurs too.

Hi Clovis,

I doubt that this is the problem here...

Anyhow, you can just doublecheck it by running

file_getfirst ANALYZER#\20090521\dban.prt

yourself.

More interesting to me is the actual case of the file name.

You're sure that DB Studio asks for the file in lower case?

See, I do use the DB Studio from Windows to access a linux box and never came across such issues.

regards,

Lars

Former Member
‎05-22-2009 1:26 AM
0 Kudos

Hi Lars,

Worry but that is the truth,

in DB Studio command line tab i executed as you wish and see what happen:

file_getfirst ANALYZER#20090521dban.prt
Runtime environment error
1,OS error: 'No such file or directory'

to make sure, i checked the dbm.prt file on dbserver and just now the time i clicked in db studio Analyzer tab i get:

2009-05-21 21:16:29 0x00005914 INF        283 DBMSrv   command file_getfirst ...
2009-05-21 21:16:29 0x00005914 ERR     -24994 DBMSrv   ERR_RTE: Runtime environment error
                    0x00005914 ERR     -24778 DBMSrv   1,OS error: 'No such file or directory'

exists another above that, but that one is the one i typed by hand in command line tab.

the only command that returns the data inside DBAN.prt is the one i made by hand, that is:

file_getfirst ANALYZER#/20090521/DBAN.prt

note that i extracted the command file_getfirst ANALYZER#20090521dban.prt from trace that you told me above.

best regards.

Clóvis

lbreddemann
Active Contributor
‎05-22-2009 9:11 AM
0 Kudos

Hi Clovis,

I've now been able to reproduce the issue.

It's not about the direction of the slahes, but about the case of the file names.

Somehow the current DB Studio gets the file name in lower case letter.

I'll give the developer a hint to that.

thanks for pointing out.

Lars

Answers (0)

Ask a Question