Re: problem with html/sql interface AIX TSM server 4.2.3.0

This has to be a bug.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Peter Pijpelink - P.L.C.S. BV Storage Consultants [mailto:tsm AT PLCS DOT 
NL]

Sent: Friday, October 18, 2002 6:15 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: problem with html/sql interface AIX TSM server 4.2.3.0


hello,

I get when I click on either a filespace or a volume the following message:
Is this a know bug??

I did run the ./dsmserv runfile ../webimages/dsmserv.idl


10/18/02 11:56:15     ANR2017I Administrator ADMIN issued command: QUERY
PROCESS

10/18/02 11:56:15     ANR0944E QUERY PROCESS: No active processes
found.
10/18/02 11:56:33     ANR9999D idutil.c(540): ThreadId<19> Cannot Prepare
SQL:
                        SELECT
NODE_NAME,FILESPACE_NAME,FILESPACE_ID,FILESPACE_T-

YPE,CAPACITY,PCT_UTIL,BACKUP_START,BACKUP_END,DELETE_OCC-
                        URRED,UNICODE_FILESPACE,FILESPACE_HEXNAME FROM
FILESPACES
                        WHERE FILESPACE_NAME=X'2532353246746d70253235324332'
AND
                        FILESPACE_ID=%252Ftmp%252C2 AND NODE_NAME='HQTSM03'.
10/18/02 11:56:33     (19) Context
report
10/18/02 11:56:33     (19) Thread SessionThread (40) is a parent thread
related
                        to:
19
10/18/02 11:56:33     (40) Generating TM Context Report:
(struct=tmTxnDesc)
                        (slots=256)

10/18/02 11:56:33     (40)  *** no transactions found
***
10/18/02 11:56:33     (40) Generating Database Transaction Table
Context:
10/18/02 11:56:33     (40)  *** no transactions found
***
10/18/02 11:56:33     (40) Generating SM Context
Report:
10/18/02 11:56:33     (40) Session
726:    Type=Admin,   Id=ADMIN
10/18/02 11:56:33     (40)   Platform=WebBrowser, NodeId=0,
Owner=
10/18/02 11:56:33     (40)   SessType=0, Index=1,
TermReason=0
10/18/02
11:56:33     (40)   RecvWaitTime=0.000  (samples=0)
10/18/02 11:56:33     (40)   Backup  Objects ( bytes )  Inserted: 0 ( 0.0
)
10/18/02 11:56:33     (40)   Backup  Objects ( bytes )  Restored: 0 ( 0.0
)
10/18/02 11:56:33     (40)   Archive Objects ( bytes )  Inserted: 0 ( 0.0
)
10/18/02 11:56:33     (40)   Archive Objects ( bytes ) Retrieved: 0 ( 0.0
)
10/18/02 11:56:33     (40)   Last Verb ( (Unknown) ), Last Verb State (
Recv )
10/18/02 11:56:33     (40) Generating AS Vol Context
Report:
10/18/02 11:56:33     (40)  No mounted (or mount in progress)
volumes.
10/18/02 11:56:33     (40) Generating ssSession Context
Report:
10/18/02 11:56:33     (40)  No storage service sessions
active.
10/18/02 11:56:33     (40) Generating ssOpenSeg Context
Report:
10/18/02 11:56:33     (40)  No storage service segments
found.
10/18/02 11:56:33     (40) Generating BF Copy Control Context
Report:
10/18/02 11:56:33     (40)  No global copy control
blocks.
10/18/02
11:56:33
10/18/02 11:56:33     (19) Thread AcceptorThread (34) is a grandparent
thread
                        related to:
40
10/18/02 11:56:33     (34) Generating TM Context Report:
(struct=tmTxnDesc)
                        (slots=256)

10/18/02 11:56:33     (34)  *** no transactions found
***
10/18/02 11:56:33     (34) Generating Database Transaction Table
Context:
10/18/02 11:56:33     (34)  *** no transactions found
***
10/18/02 11:56:33     (34) Generating SM Context
Report:
10/18/02 11:56:33     (34)  *** no sessions found
***
10/18/02 11:56:33     (34) Generating AS Vol Context
Report:
10/18/02 11:56:33     (34)  No mounted (or mount in progress)
volumes.
10/18/02 11:56:33     (34) Generating ssSession Context
Report:
10/18/02 11:56:33     (34)  No storage service sessions
active.
10/18/02 11:56:33     (34) Generating ssOpenSeg Context
Report:
10/18/02 11:56:33     (34)  No storage service segments
found.
10/18/02 11:56:33     (34) Generating BF Copy Control Context
Report:
10/18/02 11:56:33     (34)  No global copy control
blocks.
10/18/02
11:56:33
10/18/02 11:56:33     (19) SmHttpCommandThread : ANR9999D calling
thread
10/18/02 11:56:33     (19) Generating TM Context Report:
(struct=tmTxnDesc)
                        (slots=256)

10/18/02 11:56:33     (19) slot ->
81:
10/18/02 11:56:33     (19) Tsn=0:55377, Resurrected=False,
InFlight=True,
                        Distributed=False

10/18/02 11:56:33     (19)  Participants=1,
summaryVote=ReadOnly
10/18/02 11:56:33         Participant DB: voteReceived=False,
ackReceived=False
10/18/02 11:56:33     (19) Generating Database Transaction Table
Context:
10/18/02 11:56:33     (19)  *** no transactions found
***
10/18/02 11:56:33     (19) Generating SM Context
Report:
10/18/02 11:56:33     (19)  *** no sessions found
***
10/18/02 11:56:33     (19) Generating AS Vol Context
Report:
10/18/02 11:56:33     (19)  No mounted (or mount in progress)
volumes.
10/18/02 11:56:33     (19) Generating ssSession Context
Report:
10/18/02 11:56:33     (19)  No storage service sessions
active.
10/18/02 11:56:33     (19) Generating ssOpenSeg Context
Report:
10/18/02 11:56:33     (19)  No storage service segments
found.
10/18/02 11:56:33     (19) Generating BF Copy Control Context
Report:
10/18/02 11:56:33     (19)  No global copy control
blocks.
10/18/02
11:56:33
10/18/02 11:56:33     (19) End Context
report
10/18/02 11:56:33     ANR2911E Invalid SQL numeric literal token -
'252Ftmp'.
10/18/02 11:56:33     ANR2032E HTML: Command failed - internal server
error
                        detected.