Page 1 of 1
TM1 does not log Oracle error return code when SQL fails
Posted: Wed Aug 24, 2011 2:15 am
by mce
In a TI process, when SQL query against Oracle DB fails, TM1 does nor log the Oracle error return code in server logs or in process error log. Therefore you do not know why it failed if it is an intermittent failure.
Re: TM1 does not log Oracle error return code when SQL fails
Posted: Wed Aug 24, 2011 1:10 pm
by jim wood
Is this really a bug or a missing feature? Guys what do you think?
Re: TM1 does not log Oracle error return code when SQL fails
Posted: Wed Aug 24, 2011 8:34 pm
by mce
IBM did not acknowledge it as a bug and accepted to treat as enhancement request since product behaves as expecte. Whatever you call it, it is an obvious issue for TM1. Due to this issue, we are not able to resolve intermittent SQL errors in our PROD environment. The same SQL mosly succeeds, but sometimes fail and we do not have the error return code, hence not able to resolve the issue.
Re: TM1 does not log Oracle error return code when SQL fails
Posted: Wed Aug 24, 2011 8:36 pm
by jim wood
Don't get me wrong this is an issue but I don't think it falls within the bug category as there is no issue number from IBM.
- Moved to enhancement requests
Re: TM1 does not log Oracle error return code when SQL fails
Posted: Wed Aug 24, 2011 8:38 pm
by mce
jim wood wrote:Don't get me wrong this is an issue but I don't think it falls within the bug category as there is no issue number from IBM.
- Moved to enhancement requests
that is ok with me. thanks.
Re: TM1 does not log Oracle error return code when SQL fails
Posted: Thu Dec 01, 2011 10:43 pm
by soozie
I know this is an old post but thought I would put a workaround out there if you havent found one.
When I get a SQL failure message I copy and paste the SQL code into SQL querying software to get a more definitive explanation of why it fails, I use PLSQL developer here but im sure there are plenty of alternatives too.
Re: TM1 does not log Oracle error return code when SQL fails
Posted: Fri Dec 02, 2011 1:42 pm
by jim wood
Thanks for posting a work around. It's always nice when something that has been open for a while gets a response.