SQl on ti process gets cut randomly and sql failed

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

SQl on ti process gets cut randomly and sql failed

Post by manu0521 » Thu Jun 03, 2021 3:07 pm

Hi ,

I am using a sql statement in my ti. I have begin and End and the sql inbetween , which does a union

Begin
Sql command
End

It works fine ,but suddenly 1 or 2 days later the sql has only first 3 to 4 lines and rest gets cut and causes sql failed.

Then i will hae to recopy the sql and then resave it .

Can you guys think of any reasons or how to trouble shoot this .


Thanks,

John Hammond
Community Contributor
Posts: 274
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.57 Perspectives
Version: Planning Analytics TM1 11.8.00
Excel Version: 2016
Location: South London

Re: SQl on ti process gets cut randomly and sql failed

Post by John Hammond » Thu Jun 03, 2021 5:45 pm

This could be some type of resource limitation on the service account. You'd have to look at the database logs to see what was going on. SQL has no guaranteed way of doing the query so 1 plan might bust the limit while another does not.

Try asking your dba or turning this into a stored proc that can be executed in a specific way.

Wim Gielis
MVP
Posts: 2713
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: SQl on ti process gets cut randomly and sql failed

Post by Wim Gielis » Sat Jun 05, 2021 11:18 am

Not sure what might cause this.
Thinking out loudly:

- Which client is / clients are used for the prrocesses ? Not the dreaded Performance Modeler ?
- There is an END in the code, this is also a TI function. Maybe there's an interference ?
- Has TM1 been rebooted in the meantime ?
- You are sure no one messed around with the PRO file in Notepad or similar ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references https://github.com/wimgielis

Post Reply