Preview Tool

Cisco Bug: CSCvj02572 - TES 6.2.1 Peoplesoft query using lower case when PS column has capital letters in the names

Last Modified

Jul 30, 2018

Products (1)

  • Cisco Workload Automation

Known Affected Releases

6.2.1 6.3.1 6.3.3

Description (partial)

When the peoplesoft db is configured for case sensitivity our query does not function correctly due to the column name in the where clause being lower case.
  from PS_SCHDLITEM ps 
  left outer join PS_OUTDESTTYPE ot 
               on ps.OUTDESTTYPE = ot.OUTDESTTYPE 
              and ps.GENPRCSTYPE = ot.GENPRCSTYPE 
  left outer join PS_OUTDESTFORMAT odf 
               on ps.OUTDESTFORMAT = odf.OUTDESTFORMAT 
              and ps.GENPRCSTYPE   = odf.GENPRCSTYPE 
              and ps.OUTDESTTYPE   = odf.OUTDESTTYPE 
where ps.jobnamesrc= ?

Only when the Peoplesoft database is using case sensitive collation

?Task 6-1-3: Setting Up the Collation The default collation for PeopleSoft databases is Latin1_General_Bin?
Bug details contain sensitive information and therefore require a 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.