Skip to Content

MultiSource - Connection Error

I see the below error when trying to inset tables for Multi Source universe.



I published the connection to repository sucessfully with out any issues. Test says success and I can view Show values.


But in the data foundation I see the below error

Error:

[Data Federator Driver] [Server] [Connector 'LLKLKLSLJ'] The database has reported an Exception: [IBM][CLI Driver] SQL1013N  The database alias name or database name "LLKLKLSLJ" could not be found.  SQLSTATE=42705

(SQLState: 08001, Vendor code: -1,013)


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 22, 2012 at 12:56 PM

    Hi,

    Are you getting this error when browsing for a table, expanding a selection, or inserting a table?  (please elaborate)

    To investigate the issue, I'd recommend you follow Note 1561226 - BI 4.0 - How to troubleshoot MultiSource universes  and follow steps 2 and 3 specifically :

    • Enable a 'HIGH' TraceLog service in the Adaptive Processing Server (APS) for the "Data Federation Service" only. 
    • Open the Data Federation Administration Tool (DFAT) client. In System Parameters, set "QUERY_HISTORY_SIZE" to 100. Switch to the Query Monitoring view, and select Type "All Queries".   

    (local IDT trace probably isn't necessary)

    regards,

    H

    Add comment
    10|10000 characters needed characters exceeded