If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

ODBC dlinks fail

Started by mgzryq, 01 Dec 2009 08:24:29 PM

Previous topic - Next topic

mgzryq

Hi,

I'm new to this board so please bear with me.

I have 2 ODBC dlinks (A & B), for ODBC dlink A the source is a smallish published table and the target is a smallish Analyst dcube (2m cells) while for ODBC dlink B the source is a largeish published table and the target is a 35m cell analyst dcube.  When I run dlink A then followed by dlink B it fails on dlink B with error message...

Received prompt:  [E LE00109] [E FS00054] SOME ATTRIBUTES FAILED:  DATA  WITH ERRNOS: 50 REPORTED WHILE  [E LE00069] ODBC ERROR PREPARING TO READ: %1% WITH D-CUBE AFS_DP_LEDGERDATASTORE.DATA_OPEX_PSGL_ALL3.

However, when I run dlink B followed by dlink A it all works fine.

Can anyone please explain why this would happen?

mizu

#1
are you running them from a macro or manually?

btw, have you tried this: http://www-01.ibm.com/support/docview.wss?uid=swg21347343 ? it looks quite similar,..

mgzryq

I'm running them from an Analyst macro that is kicked off by a CAC macro which is scheduled using a CONNECTION JOB.

mgzryq

Just to close the loop we have redesigned this section of the macro to target 2 new smaller dcubes using 2 new ODBC dlinks and we have sidelined the original offending ODBC dlinks & it's targeted dcube.