cancel
Showing results for 
Search instead for 
Did you mean: 

MultiSource - Connection Error

former_member203645
Active Participant
0 Kudos

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)


Accepted Solutions (0)

Answers (1)

Answers (1)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

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