Guest

Preview Tool

Cisco Bug: CSCum18891 - Client Manager throws exception Invalid column name 'OFFLINE'

Last Modified

Jan 22, 2017

Products (18)

  • Cisco Workload Automation
  • Cisco Tidal Enterprise Adapter for Oracle E-Business Suite
  • Cisco Tidal Enterprise Adapter for Web Services
  • Cisco Tidal Enterprise Adapter for Oracle Database
  • Cisco Tidal Enterprise Adapter for VMware
  • Cisco Tidal Enterprise Adapter for SAS
  • Cisco Tidal Enterprise Adapter for Cognos
  • Cisco Tidal Enterprise Adapter for SAP
  • Cisco Tidal Enterprise Adapter for Informatica
  • Cisco Tidal Agent for Windows
View all products in Bug Search Tool Login Required

Known Affected Releases

6.1.0

Description (partial)

Symptom:
Client Manager throws exception Invalid column name 'OFFLINE'

Conditions:
Client Manager is referencing an invalid column "OFFLINE" in "TES.VIRTUALRESOURCE_View"

[SELECT COUNT(*) FROM TES.VIRTUALRESOURCE_VIEW  VIRTUALRESOURCE WHERE ((VIRTUALRESOURCE.OWNERID = 147) OR (VIRTUALRESOURCE.OWNERID IN (29,144,208,325,457,617,1972,1974,2182)) OR ( VIRTUALRESOURCE.PUBLICFLAG = 'Y' )) AND (UPPER(VIRTUALRESOURCE.NAME) LIKE '%QNCOA%' ESCAPE '!' OR UPPER(VIRTUALRESOURCE.OWNERNAME) LIKE '%QNCOA%' ESCAPE '!' OR LTRIM(RTRIM(STR(VIRTUALRESOURCE.LIMIT))) LIKE '%QNCOA%' ESCAPE '!' OR LTRIM(RTRIM(STR(VIRTUALRESOURCE.INUSE))) LIKE '%QNCOA%' ESCAPE '!' OR LTRIM(RTRIM(STR(VIRTUALRESOURCE.OFFLINE))) LIKE '%QNCOA%' ESCAPE '!' OR LTRIM(RTRIM(STR(VIRTUALRESOURCE.AVAILABLE))) LIKE '%QNCOA%' ESCAPE '!' OR UPPER(VIRTUALRESOURCE.ACTIVE) LIKE '%QNCOA%' ESCAPE '!' OR UPPER(VIRTUALRESOURCE.PUBLICFLAG) LIKE '%QNCOA%' ESCAPE '!' OR UPPER(VIRTUALRESOURCE.DESCRIPTION) LIKE '%QNCOA%' ESCAPE '!') AND ((VIRTUALRESOURCE.OWNERID = 147) OR (VIRTUALRESOURCE.OWNERID IN (29,144,208,325,457,617,1972,1974,2182)) OR ( VIRTUALRESOURCE.PUBLICFLAG = 'Y' ))]
[12/18 03:58:39:265]:Deleting log file .\log\ClientManager-20131218035038527.log
[12/18 03:58:39:998]:com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'OFFLINE'.
Invalid column name 'OFFLINE'.
[ com.microsoft.sqlserver.jdbc.SQLServerException ] Invalid column name 'OFFLINE'.com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'OFFLINE'.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.