Cisco Bug: CSCvj02572 - TES 6.2.1 Peoplesoft query using lower case when PS column has capital letters in the names
Jul 30, 2018
- Cisco Workload Automation
Known Affected Releases
6.2.1 6.3.1 6.3.3
Symptom: 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. select JOBNAMESRC,PRCSNAME,PRCSTYPE,PARENTJOBNAME,RUN_CNTL_ID,OUTDEST,ps.OUTDESTTYPE,OUTDESTTYPEDESCR,ps.OUTDESTFORMAT,OUTDESTFORMATDESCR 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= ? Conditions: 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 Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases