SAP Hostagent reporting error on temp file path - but which one?

[volker_borowski2]

After upgrading the hostagent to latest 7.21 patch

i found problems with collection of database Information.

I proceeded as described in note

2435938 - SAP-Host-Agent SAP MaxDB: DBCredentials

and got sapdbctrl to retreive the desired Information:

C:\Program Files\SAP\hostctrl\exe>saphostctrl.exe -function ListDatabases

Instance name: E10, Hostname: MIRACULIX, Vendor: ADA, Type: sap, Release: 7.9.09.006  
  Database name: E10, Status: Running
    Component name: Database (Database), Status: Running (database state is running)
    Component name: LogWriter (LogWriter), Status: Running (LogWriter is active)
    Component name: x_server (x_server), Status: Running (x_server is running)
    Component name: Analyzer (Analyzer), Status: Running (Analyzer is running)
    Component name: Log filling rate (Log filling rate), Status: Running (Log filling rate is ok)
    Component name: Database filling rate (Database filling rate), Status: Running (Database filling rate is ok)
    Component name: SQL connectivity (SQL connectivity), Status: Running (SQL connect data available)

C:\Program Files\SAP\hostctrl\exe>

That is quite ok, but the trace file complains about writing a temp file, which i have no clue what it should be…

[PID 3312] getMaxDBCompoments called
[PID 3312] addrinfo of 'MIRACULIX':
[PID 3312] 0: 10.25.32.97:0 [PID 3312] <unknown socket type 0> [PID 3312] (0-2-0-0-16)
[PID 3312] NiLocalCheck: address 10.25.32.97 is local
[PID 3312] MIRACULIX is a local hostname
[PID 3312] MaxDB::isXServerActive called 
[PID 3312] MaxdbToolCall info -->
[PID 3312]   User: 
[PID 3312]   arg0 = E:\sapdb\programs\bin\x_ping.exe
[PID 3312]   arg1 = -n
[PID 3312]   arg2 = localhost
[PID 3312] <-- MaxdbToolCall info
[PID 3312] *** ERROR => Failed to create temporary file name: The directory name is invalid.
              [DBCommandExecutorImplnt.cpp 248]
[PID 3312] *** ERROR => Failed to create temporary file name: The directory name is invalid.
              [DBCommandExecutorImplnt.cpp 248]
[PID 3312] Successfully started program 'E:\sapdb\programs\bin\x_ping.exe' (PID = 636)
[PID 3312] 'E:\sapdb\programs\bin\x_ping.exe' terminated normally with exit code '0'
[PID 3312] 'E:\sapdb\programs\bin\x_ping.exe' output -->
[PID 3312]   Checking connection to 'localhost' ... ok.
[PID 3312]   Version of Server is
[PID 3312]   ----------------------------------------------------------
[PID 3312]   UNKNOWN
[PID 3312]   ----------------------------------------------------------
[PID 3312] <-- 'E:\sapdb\programs\bin\x_ping.exe' output
[PID 3312] EXECUTE SQL (1): dban_state
[PID 3312] 16 records fetched
[PID 3312] MaxDBInstance::maxDBConnect (dbmConnectOnly=0) called 
[PID 3312] MaxDBInstance::maxdbSQLConnect called 
[PID 3312] connect to database MIRACULIX@E10 (SQL), key=(E10SAPDBCTRL), user=()
[PID 3312] SqldbcInstance::dbConnect (1)
[PID 3312] vendor=ADA, host=MIRACULIX, dbname=E10, sqlport=, userkey=E10SAPDBCTRL
[PID 3312] SqldbcInstance::sqldbcConnect called 
[PID 3312] SqldbcInstance::sqldbcConnect by userkey
[PID 3312] connect to database E10@MIRACULIX with userkey E10SAPDBCTRL 
[PID 3312] SqldbcInstance::dbConnect (1) to MIRACULIX-E10 successful
[PID 3312] MaxDBInstance::changeCurrentSchema called 
[PID 3312] EXECUTE SQL (1): SET CURRENT_SCHEMA = SAPDBCTRL
[PID 3312] MaxDBInstance::getLogWriterStatus called 
[PID 3312] MaxDBInstance::executeSQLCommand (int) called 
[PID 3312] EXECUTE SQL (1): SELECT count(*) FROM DB_STATE WHERE DESCRIPTION = 'Log writing' AND VALUE = 'on'
[PID 3312] 1 records fetched
[PID 3312] MaxDBInstance::executeSQLCommand char called 
[PID 3312] EXECUTE SQL (1): SELECT LOGWRITERSUSPENDED FROM SYSINFO.LOGINFORMATION
[PID 3312] 1 records fetched
[PID 3312] MaxDBInstance::getLogFillingState called 
[PID 3312] MaxDBInstance::executeSQLCommand (int) called 
[PID 3312] EXECUTE SQL (1): SELECT NOTSAVEDPERCENTAGE FROM LOGSTATISTICS
[PID 3312] 1 records fetched
[PID 3312] MaxDBInstance::getLogFillingState called 
[PID 3312] MaxDBInstance::executeSQLCommand (int) called 
[PID 3312] EXECUTE SQL (1): SELECT PCTUNUSED FROM SERVERDBSTATISTICS
[PID 3312] 1 records fetched
[PID 3312] disconnect from database E10@MIRACULIX
[PID 3312] SqldbcInstance::dbDisconnect (1) from MIRACULIX-E10
[PID 3312] }
[PID 3312] SAP_DB_GetDatabaseStatus [ADA] (rc = 0)

That is tracfile Output on trace Level 3 already …

As you can see it is logging the error, allthough the Overall returncode is 0

Any Idea, where that guy is trying to write to ?

[volker_borowski2]

Well, sorry to contradict, but the trace says, it is calling

E:\sapdb\programs\bin\x_ping.exe

which clearly is a maxdb program.

After calling this it logs the error.

After the error it logs the program has been called successfully.

I do not suppose this issue to be all too severe, allthough i would like to get rid of anoying Messages.

But the efford to track a ticket or a service call around this is way to costy.

Will wait a couple of days if here comes something else.

Volker

[JamesZ]

Hi ,

The error is like this:

*** ERROR => Failed tocreate temporary filename: The directorynameis invalid.

Your concern needs more deep knowledge and also it has nothing to do with maxdb, so it is better to raise a chat or incident under SAP support component BC-CCM-HAG.

Best regards,
James

[JamesZ]

Hi ,

The error is like this:

*** ERROR => Failed tocreate temporary filename: The directorynameis invalid.

Your concern needs more deep knowledge and also it has nothing to do with maxdb, so it is better to raise a chat or incident under SAP support component BC-CCM-HAG.

Best regards,
James