Server crash issue when pulling data from SAP

Post Reply
late.vaibhav
Posts: 25
Joined: Mon Dec 09, 2013 1:00 pm
OLAP Product: tm1
Version: 9.5.2, 10.2.2
Excel Version: 2007 2010
Location: India
Contact:

Server crash issue when pulling data from SAP

Post by late.vaibhav »

Hi
I have scheduled one ti process to pull data from SAP system to TM1 through framework manager. But the problem is that SAP cube is also get refreshed at regular interval and if both the time matched with each other my server get crashed with following Error message:

14104 [461] DEBUG 2014-07-07 06:27:15.954 TM1.Cognos CCognosProxy::Connect C8Error: Failed to create pipe
14104 [461] DEBUG 2014-07-07 06:27:15.954 TM1.Cognos CCognosProxy Connected
14104 [461] ERROR 2014-07-07 06:27:15.955 TM1.Process Process "Loading SalesVolume for TB_division": : Execution was aborted. Error file: <TM1ProcessError_20140707062715_Loading SalesVolume for TB_division.log>
14104 [461] ERROR 2014-07-07 06:27:15.957 TM1.Process Process "Loading SalesVolume for TB": : Execution was aborted. Error file: <TM1ProcessError_20140707062715_Loading SalesVolume for TB.log>
14104 [461] ERROR 2014-07-07 06:27:15.958 TM1.Process Process "2.1.0.Load_TB": finished executing with errors. Error file: <TM1ProcessError_20140707062715_2.1.0.Load_TB.log>
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: Server crash issue when pulling data from SAP

Post by deepakjain2020 »

What is shown in your error files "Error file: <TM1ProcessError_20140707062715_Loading SalesVolume for TB.log>"?
MSidat
Community Contributor
Posts: 110
Joined: Thu Aug 26, 2010 7:41 am
OLAP Product: TM1, PA
Version: PAL 2.0.8
Excel Version: 2016
Location: North West England

Re: Server crash issue when pulling data from SAP

Post by MSidat »

I am presuming you have just got your terminology confused in that the TM1 Server itself does not crash, but the TI Process fails due to a failire to connect to your SAP datasource as SAP is in the process of updating its own tables.

If my assumption is correct then you possibly have 3 solutions.
(1)
You could see if there is a Flag in SAP somewhere which states whether the SAP data has been refreshed, and only execute your TI if that is set, and if it is not report it so that it can be ran manually by an admin.
(2)
As part of the SAP Routine that updates your datasource (if it is a scheduled event) you could possibly see if you get SAP to execute the TI utilising the TM1RunTI.exe after it has refreshed the datasource.
(3)
Leave plenty of time between when you expect SAP to complete process and when the TI is scheduled to Run.
Always Open to Opportunities
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: Server crash issue when pulling data from SAP

Post by dr.nybble »

It sounds like a bug. Any messages related to pipes means that the TM1 Package Connector process spawned by TM1 either didn't start or quit unexpectedly.
(They communicate with each other via a pipe.)

Contact support.
Post Reply