PM90423: WHEN DELIVERING TO SQL SERVER 2008 OR 2012, BULK COPY DELIVERY FAILS WITH DM-SSL-0060

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • When delivering to SQL Server 2008 or 2012, Bulk copy delivery
    fails with:??DM-SSL-0060 Delivery 'Audit': BCP process failed
    (status -1,073,741,819)?DM-BLD-0005 The delivery 'Audit' failed.
    

Local fix

  • There do seem to be a few ways to workaround the issue with SQL
    Server 2008:
    
    -Use Bulk Copy via API, and the build works.
    -The build delivers 3 fewer columns than exist in the target tab
    le -  so adding a delivery element for the 3 missing columns to
    the build allows it to complete.
    -Deliver to a new table.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
    * 1                                                            *
    * or IBM Cognos Business Intelligence 10.2 Fix Pack 2          *
    ****************************************************************
    

Problem conclusion

  • Code Fix
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM90423

  • Reported component name

    COG DATA MGR

  • Reported component ID

    5724W12DM

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-06-04

  • Closed date

    2014-03-31

  • Last modified date

    2014-03-31

  • 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

    COG DATA MGR

  • Fixed component ID

    5724W12DM

Applicable component levels

  • RA20 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos Business Intelligence
Data Manager

Software version:

10.2

Reference #:

PM90423

Modified date:

2014-03-31

Translate my page

Machine Translation

Content navigation