Hi there!
I am trying to use XREF formula from BSO to ASO cubes.
the formula in the outline looks like this:
@XREF(Sen_ASOdb,&PriorAsOf,COID, &CurrMth) ;
The location alias is created by:
create or replace location alias Sen_ASOdb from IFMSen.Senior to SenASO.Plan1 at simappwds06 as admin identified by 'password';

The formula works successfully on our development environment. However when we moved to test env. we started to receive the following error during data retrieval :

[Fri Jul 24 00:59:37 2009]Local/IFMSen/Senior/admin/Error(1023040)
msg from remote site [[Fri Jul 24 00:59:37 2009]simappwds06/SenASO/Plan1/admin/Error(1042013) Network error [10054]: Cannot Receive Data]
[Fri Jul 24 00:59:37 2009]Local/IFMSen/Senior/admin/Info(1200395)
Xref connection to data source [Sen_ASOdb] timed out. Restoring connection...
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Error(1023040)
msg from remote site [[Fri Jul 24 00:59:41 2009]simappwds06/SenASO/Plan1/admin/Error(1042006) Network error [10061]: Unable to connect to [simappwds06:1423]. The client timed out waiting to connect to Analytic Services Agent using TCP/IP. Check your network connections. Also make sure that server and port values are correct]
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Error(1200467)
Error executing formula for [Prior Mth Estimate]: status code [1042006] in function [@_XREF]
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Error(1023040)
msg from remote site [[Fri Jul 24 00:59:41 2009]simappwds06/SenASO/Plan1/admin/Error(1054007) Application SenASO not responding]
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Error(1020004)
An error [1042006] occurred in Spreadsheet Extractor.
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Info(1020055)
Spreadsheet Extractor Elapsed Time : [6.234] seconds
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Info(1020082)
Spreadsheet Extractor Big Block Allocs -- Dyn.Calc.Cache : [73] non-Dyn.Calc.Cache : [0]
[Fri Jul 24 00:59:41 2009]Local/IFMSen/Senior/admin/Warning(1080014)
Transaction [ 0xec0001( 0x4a693fb7.0x73b90 ) ] aborted due to status [1042006].
[Fri Jul 24 00:59:41 2009]Local/IFMSen///Info(1013210)
User [admin] set active on database [Senior]

Seems like ASO database cannot be accessed via location alias. When accessing directly ASO cube i manage to retrieve data with no problem.
I'm not sure whether it is related or not, but i had another issue when loading ASO cube. when loading from the buffer and using "override all data" option i also recieved network errors.

ERROR - 1042013 - Network error [10054]: Cannot Receive Data.
ERROR - 1042012 - Network error [10054]: Cannot Send Data.
ERROR - 1241101 - Unexpected Essbase error 1042013.

finaly i gave up and removed that option.
Ideas will be greatly appreciated!

Thanks a lot,
Dmitry

Hi,
Yes, i tried to recreate the formula, create a new alias, replace substitution variables with static members - doesn't help. if i replace XREF formula for another formula the retrieval starts working again.
Thank you for you response,
Dmitry