TM1 does not log Oracle error return code when SQL fails

[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.

[jim wood]

Is this really a bug or a missing feature? Guys what do you think?

[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.

[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

[mce]

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.

[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.

[jim wood]

Thanks for posting a work around. It's always nice when something that has been open for a while gets a response.