IBM Support

PM39231: ERROR CONNECTING TO SQL SERVER 2008 DB WITH A '.' IN THE NAME

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as unreproducible.

Error description

  • When trying to connect to a SQL Server DB with a decimal in the
    name such as GOSALES8.4.1 there is an error message testing the
    connection in Cognos Administration.  The same error will be
    displayed in Framework Manager when trying to access that
    DB.??---------------------------?Windows Internet
    Explorer?---------------------------?QE-DEF-0285 The logon
    failed.?QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either
    the DSN is missing or the host is inaccessible.?RQP-DEF-0068
    Unable to connect to at least one database during a
    multi-database attach to 1 database(s) in: ?
    testDataSourceConnection??UDA-SQL-0031 Unable to access the
    "testDataSourceConnection" database.?UDA-SQL-0532 Data Source is
    not accessible: "DBserver".?UDA-SQL-0564 [Microsoft OLE DB
    Provider for SQL Server]Cannot open database "GOSALESDW8.4.1"
    requested by the login. The login failed. (SQLSTATE=42000,
    SQLERRORCODE=4060)?BME-EX-0144 Trace
    back:?BmtPlayTransaction.cpp(757): QFException: CCL_RETHROW:
    BmtPlayTransaction::DoAction?BmtActionsHelper.cpp(488):
    QFException: CCL_RETHROW:
    BmtActionsHelper::DoAction?QFSSession.cpp(719): QFException:
    CCL_RETHROW: QFSSession::ProcessDoRequest()?QFSSession.cpp(717):
    QFException: CCL_CAUGHT:
    QFSSession::ProcessDoRequest()?QFSSession.cpp(1548):
    QFException: CCL_RETHROW:
    QFSSession::SessionProcessTestConnection()?Source/QE_RsApi.cpp(2
    071):
    QFException: CCL_RETHROW:
    QE?Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW:
    QE??---------------------------?OK
    ?---------------------------
    

Local fix

Problem summary

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

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PM39231

  • Reported component name

    COG BI FRAMEWK

  • Reported component ID

    5724W12FM

  • Reported release

    841

  • Status

    CLOSED UR5

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-13

  • Closed date

    2012-09-17

  • Last modified date

    2013-06-11

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

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

Fix information

Applicable component levels

  • RA11 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHNWR","label":"Framework and Map Manager v11x"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"841","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
11 June 2013