IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    PI95386

  • Reported component name

    CLEARQUEST WIN

  • Reported component ID

    5724G3600

  • Reported release

    900

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-19

  • Closed date

    2018-11-29

  • Last modified date

    2018-11-29

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"900","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
18 October 2021