Fixes are available
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 & Data Platform"},"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"900","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
18 October 2021