IBM Support

JR34503: QAPPLY GETS ASN7512E RC6 WHEN ACTIVATING A SUBSCRIPTION THAT HAS AN EXPRESSION CONTAINING : ( COLON ) AS PART OF ITS DATA VALUE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Example of Expression used -
    
    case when :COL2 = '10:30:12' then '10:00:00' else :COL2 end
    
    Where COL2 is a column name and '10:30:12' is a data value.
    
    Qapply log shows the following error messages when the
    subscription is capstarted -
    
    
    
    2009-10-08-12.05.04.437000 <browser::verifyMsgVersion> ASN8999D
    "Q Apply" : "QASN" : "BR00000" : Browser for queue
    'QASN.SOURCE2TARGET.RECVQ' received a 'ASNMQ_SUBSCHEMA_MSG'
    message.
    2009-10-08-12.05.04.437000 <QAsubMgr::add2SrcColMap> ASN8999D
    "Q Apply" : "QASN" : "BR00000" : RC=606: Colname '3012'' not
    found in SCHEMA msg.
    2009-10-08-12.05.04.437000 <QAsubMgr::generateSrcColMap>
    ASN0589I  "Q Apply" : "QASN" : "BR00000" The program received an
    unexpected return code "606" from routine
    "QAsubMgr::add2SrcColMap".
    2009-10-08-12.05.04.437000 <QAsubMgr::verifyTrgCols> ASN0589I
    "Q Apply" : "QASN" : "BR00000" The program received an
    unexpected return code "606" from routine
    "QAsubMgr::generateSrcColMap".
    2009-10-08-12.05.04.437000 <QAsubMgr::verifyTrgCols> ASN8999D
    "Q Apply" : "QASN" : "BR00000" : The source column 'case when
    :COL2 = '10:30:12' then '10:00:00' else :COL2 end' of Q
    subscription 'EXP10001' was specified in IBMQREP_TRG_COLS table
    but did not match a subscribed source column in IBMQREP_SRC_COLS
    table.
    2009-10-08-12.05.04.437000 <QAsubMgr::issueSchemaErrorMsg>
    ASN7512E  "Q Apply" : "QASN" : "BR00000" : The Q Apply program
    could not activate the Q subscription "EXP10001" (receive queue
    "QASN.SOURCE2TARGET.RECVQ", replication queue map
    "SOURCE_QASN_TO_TARGET_QASN").  Reason code: "6".
    
    
    QApply should not treat ':' to be the beginning of a column name
    if it is part of a sub string enclosed in single/double quotes
    

Local fix

  • none
    If possible try not to use : colon as part of data value.
    

Problem summary

  • Subscriptions with column SQL expressions using
    data values that contain colon characters (such as
    date/timestamp values) fail to get activated due to incorrect
    parsing of the SQL expression in QAPPLY.
    

Problem conclusion

  • QAPPLY will now correctly parse colon
    characters occurring within single quotes as part of data
    values/literals.  Only colons not enclosed within single
    quotes will be treated as markers for column names.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR34503

  • Reported component name

    REPLICATION SER

  • Reported component ID

    5724N9800

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-10-08

  • Closed date

    2010-12-06

  • Last modified date

    2010-12-06

  • 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

    REPLICATION SER

  • Fixed component ID

    5724N9800

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 December 2010