PI95386: CONTACTS ORA-00911 INVALID CHARACTER ERROR ON SYNC REPLICA

Rational ClearQuest Fix Pack 5 (9.0.1.5) for 9.0.1
Rational ClearQuest Fix Pack 6 (9.0.1.6) for 9.0.1
Rational ClearQuest Fix Pack 7 (9.0.1.7) for 9.0.1
Rational ClearQuest Fix Pack 8 (9.0.1.8) for 9.0.1
Rational ClearQuest Fix Pack 9 (9.0.1.9) for 9.0.1

APAR status

• Closed as program error.

Error description

• The customer is using MultiSite and the trouble is with two
  sites (SITEN and SITEB).
  
  SITEB     -Current Master site to be decommissioned sometime in
  the future
          Upgraded all the clients to Windows 10 machines with CQ
  version 9.0.0.5.
          Since planning to uprgade environment, did not change
  the Oracle version and left it at version 10.
  
  SITEN    -Replica
          Windows Server 2008.  The Oracle version 11.
  
  When running multiutil syncreplica  from SITEN to SITEB, the
  client gets the following
  error:
  
  Multiutil: CRMDB0001E SQLExecute: RETCODE=-1, State=37000,
  Native Error=911
  [IBM Rational DataDirect][ODBC Oracle Wire Protocol
  driver][oracle]ORA-00911: invalid character
  SQLstatement="..."
  
  
  multiutil syncreplica  from SITEB to SITEN is not a problem.
  
  This sounds may be a code page/character set issue.  The SITEB
  system is old and the Oracle character set is set to
  WE8ISO8859P1 where the
  SITEN system is newer and was set Oracle to ANSI.
  
  Code page of CQMS.XXX.SITEB (or SITEN): 20127 (US-ASCII)
  Code page of client: 1252 (MS Windows Latin 1)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ClearQuest Multisite                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In some circumstances, a "ORA-00911 Invalid Character Error" *
  * may occur during a ClearQuest multisite syncreplica command. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• A fix is available in ClearQuest 9.0.1.5.
  There was a parsing defect in ClearQuest's ODBC database drivers
  that caused this error when text data contained specific
  characters.  This issue has been corrected with the current
  version of the ClearQuest ODBC drivers.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  CLEARQUEST WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R900 PSY

     UP