SQl on ti process gets cut randomly and sql failed

[manu0521]

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]

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]

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 ?