This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

EIS data load error

July 24 2012 at 3:49 PM
No score for this post
Adit 
from IP address 192.91.66.186

I have increased the number of threads integration server uses to 2 [ added [N]=2 in ais.cfg and -N2 in startup.bat as mentioned in the eis sysadmin page 22]. We were using just the default value of 1.

I am getting the following error while doing a data load through EIS.

[Tue Jul 24 xxxxxxxxxxxxx] /IS//0x0/xxxxxxxxxxxxx/Error/1042012/Build-xxxxxxxxxxxxx
EssbaseAPI: Network error [10054]: Cannot Send Data

[Tue Jul 24 xxxxxxxxxxxxx] /IS//0x0/xxxxxxxxxxxxx/Error/1042012/Build-xxxxxxxxxxxxx
EssbaseAPI: Network error [10054]: Cannot Send Data

[Tue Jul 24 xxxxxxxxxxxxx2] /IS//0x0/xxxxxxxxxxxxx/Informational/0/Build-xxxxxxxxxxxxx
IS Error(EssSendString): Network error [10054]: Cannot Send Data 1042012

[Tue Jul 24 xxxxxxxxxxxxx] /IS//0x0/xxxxxxxxxxxxx/Error/0/Build-xxxxxxxxxxxxx
@@@@@Thread_Target4 24 being exited with code 1042012


[Tue Jul 24 xxxxxxxxxxxxx] /IS//0x0/xxxxxxxxxxxxx/Error/1042012/Build-xxxxxxxxxxxxx
EssbaseAPI: Network error [10054]: Cannot Send Data

[Tue Jul 24 xxxxxxxxxxxxx] /IS//0x0/xxxxxxxxxxxxx/Informational/0/Build-xxxxxxxxxxxxx
IS Error(EssSendString): Network error [10054]: Cannot Send Data 1042012

[Tue Jul 24 xxxxxxxxxxxxx] /IS//0x0/xxxxxxxxxxxxx/Error/0/Build-xxxxxxxxxxxxx
@@@@@Thread_Target4 23 being exited with code 1042012


"Essbase error message" pdf says for error 1042012 that we need to increase the netdelay and netretry count(but we have actually reduced these parameters to 600 and 1000 according to what oracle has suggested 2 days back[we had very high values of 2000 and 2500]).

But, I am not getting this data load error if I remove the number of threads.

Any help is greatly appreciated.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply



205.228.53.12

Re: EIS data load error

No score for this post
July 26 2012, 2:10 PM 

My recommendation (what I do with my EIS databases) is to use EIS to build the model, but then use a SQL load rule to import the data from the fact table.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Current Topic - EIS data load error
  << Previous Topic | Next Topic >>Return to Index  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.