Bug 780616 (SOA-3054) - ODBC Driver fails on Solaris with [IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
Summary: ODBC Driver fails on Solaris with [IM005][unixODBC][Driver Manager]Driver's S...
Keywords:
Status: CLOSED NOTABUG
Alias: SOA-3054
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: unspecified
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER5
: 6.0
Assignee: Van Halbert
QA Contact: Filip Nguyen
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks: SOA-2946 1054244
TreeView+ depends on / blocked
 
Reported: 2011-05-04 15:58 UTC by Paul Nittel
Modified: 2014-07-09 05:00 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Solaris 10
Last Closed: 2014-03-10 20:28:56 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)
isqlWork.sql (73 bytes, application/octet-stream)
2011-05-04 16:04 UTC, Paul Nittel
no flags Details
odbc.ini (371 bytes, application/octet-stream)
2011-05-04 16:04 UTC, Paul Nittel
no flags Details
RunIsqlSol (183 bytes, application/octet-stream)
2011-05-04 16:04 UTC, Paul Nittel
no flags Details
.odbc.ini (2.72 KB, application/octet-stream)
2011-05-04 16:04 UTC, Paul Nittel
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 780552 1 None None None 2021-01-20 06:05:38 UTC
Red Hat Issue Tracker SOA-3054 0 Major Closed ODBC Driver fails on Solaris with [IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed 2017-09-26 12:32:05 UTC

Internal Links: 780516 780552

Description Paul Nittel 2011-05-04 15:58:51 UTC
Steps to Reproduce: See description.
project_key: SOA

I'm using the isql tool we provide with our kit. (It's working on other platforms.) When I try to simply connect to the DSN, the error results. I'll attach the odbc.ini, my own .odbc.ini, the script I run, and the SQL queries I'm attempting.

It goes like this when run manually:
$ isql -v eds pnittel mm
[IM005][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed
[ISQL]ERROR: Could not SQLConnect

Comment 1 Paul Nittel 2011-05-04 16:04:04 UTC
Files to use to reproduce

Comment 2 Paul Nittel 2011-05-04 16:04:04 UTC
Attachment: Added: isqlWork.sql
Attachment: Added: odbc.ini
Attachment: Added: RunIsqlSol
Attachment: Added: .odbc.ini


Comment 3 Mladen Turk 2011-05-11 07:45:12 UTC
Still no progress.
Now trying to compile the package locally on my VM instance with some more debugging options.



Comment 4 Mladen Turk 2011-05-11 10:12:07 UTC
Can someone check the console on the PostgreSQL server.
I'm wondering if this is related to:
http://archives.postgresql.org/pgsql-odbc/2007-09/msg00000.php
In which case when a isql attempt is tried an error should
be displayed as explained in that link.

Someone can check that? I don't have access to a DB box.

Comment 5 Paul Nittel 2011-05-11 16:05:35 UTC
I'll see what I can learn from this. While it's the same error message, I'm not sure how our different scenario will affect the outcome. As soon as I get my SOA-P server working again, I'll give it a shot.

Comment 6 Mladen Turk 2011-05-11 20:43:48 UTC
Trying on the FC14 with RHEL6 binaries I have
$ ./isql rhel32eds -vvv
[38000][unixODBC]ERROR: org.teiid.core.TeiidException
org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
[ISQL]ERROR: Could not SQLConnect

This is with the .odbc.ini provided

 

Comment 7 Len DiMaggio 2011-05-12 17:29:16 UTC
Link: Added: This issue relates to SOA-2986


Comment 8 Paul Nittel 2011-05-12 19:25:27 UTC
I finally got QM27 running SOA-P/EDS again. I tried executing isql several times and non of them produced any kind of log file. Even the EDS server log shows nothing, which leads me to believe it dies before it tries to log onto the EDS server.

The TeiidException you received may have been from the server being down. It's back up now, so please try it again.

Comment 9 Van Halbert 2011-06-02 19:54:47 UTC
Link: Added: This issue is a dependency of SOA-2946


Comment 10 Van Halbert 2012-03-05 18:15:20 UTC
Is there more testing still to be done to determine the issue?

Comment 11 Mladen Turk 2012-03-05 19:17:06 UTC
Nope. Have no clue why is this happening.
Since I'm not familiar with the unixODBC and I see no obvious reason in solaris build files why would this happening, I'm afraid I can't be of much help here.

Comment 14 belong 2013-11-15 04:59:46 UTC
Paul,

Is the Doc Text I have provided sufficient information for customers? It seems there is no definitive workaround.

Cheers,
Ben

Comment 15 Anne-Louise Tangring 2013-12-04 00:11:36 UTC
I don't think this issue is applicable any more. If that is true, please close as will not fix.

Comment 16 belong 2013-12-10 00:52:30 UTC
Assuming this will be set to VERIFIED before GA - setting requires_doc_text- accordingly.

Comment 17 Filip Nguyen 2014-02-11 09:09:49 UTC
Dropping support for Solaris 10.


Note You need to log in before you can comment on or make changes to this bug.