Search This Blog

SBL-ADM-02507: Unknown column specified in the show clause

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.2.1 [18353] Com/Med
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Compaq Tru64 UNIX

This document was previously published as Siebel SR 38-2395494154.

Symptoms

Hi!
In 7.7 and 7.8 Bookshelf under "System Monitoring and Diagnostics Guide for Siebel Business Applications > Monitoring Siebel Server Run-Time Operations > Analyzing System Data with Siebel Run-Time Data >" it states:
   To map user session to a Siebel Server:
   .....
   4. Enter the following command:
      list servers show SBLSRVR_NAME, SV_SRVID

After some trial and error we determined that the proper column name and syntax for server ID should be:

      list servers show SBLSRVR_NAME, SV_SRVID

with an extra "R".

Solution

Message 1

Problem:
In 7.7 and 7.8 Bookshelf under "System Monitoring and Diagnostics Guide for Siebel Business Applications > Monitoring Siebel Server Run-Time Operations > Analyzing System Data with Siebel Run-Time Data >" it states:
   To map user session to a Siebel Server:
   .....
   4. Enter the following command:
      list servers show SBLSRVR_NAME, SV_SRVID

Get error: error: SBL-ADM-02507: Unknown column specified in the show clause

Solution:
Correct command syntax is:
list servers show SBLSRVR_NAME, SV_SRVRID

Logged a documentation product defect CR 12-13OAUK5 to include an extra "R".

Thanks,
Siebel Technical Support


No comments:

Post a Comment