TM1 does not log Oracle error return code when SQL fails

Suggest and discuss enhancements for TM1
Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

TM1 does not log Oracle error return code when SQL fails

Post 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.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 does not log Oracle error return code when SQL fails

Post by jim wood »

Is this really a bug or a missing feature? Guys what do you think?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: TM1 does not log Oracle error return code when SQL fails

Post 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.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 does not log Oracle error return code when SQL fails

Post 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
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: TM1 does not log Oracle error return code when SQL fails

Post 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.
soozie
Posts: 1
Joined: Thu Dec 01, 2011 10:33 pm
OLAP Product: TM1
Version: 9.52
Excel Version: 2007

Re: TM1 does not log Oracle error return code when SQL fails

Post 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.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: TM1 does not log Oracle error return code when SQL fails

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply