| Author |
Message
|
| bhavyabhandari |
 Posted: Sat Nov 28, 2009 11:03 pm Post subject: Error when Migrating from MB6 to MB6.1 |
 |
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
Hi,
We are migrating from Mb6 to Mb6.1.
I am facing an issue when connecting to a datasource.
I have specified the driver path in ODBC.ini as
/opt/IBM/mqsi/6.1/ODBC64/V5.3/lib/UKora23.so
as per the MB6.1 lib path.
Now this DSN was previously in MB6 referring to the following path
/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
When I make an insert query via the compute node on this DSN I get the following exception
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbDatabaseNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 295 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDatabaseNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmDatabaseNode' (CHARACTER)
(0x03000000:NameValue):Name = 'MgateAdjustmentDBInsert#FCMComposite_1_5' (CHARACTER)
(0x03000000:NameValue):Label = 'MgateAdjustmentDBInsert.Insert in SR_PAYMENT_TBL' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Caught exception and rethrowing' (CHARACTER)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 323 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2393 (INTEGER)
(0x03000000:NameValue):Text = 'Root SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'EAIDBEMA' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 438 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '08S01' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '0' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC 20101 driver]7505' (CHARACTER)
)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 438 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '21' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC 20101 driver][20101]11603' (CHARACTER)
)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 438 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '60' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '1509' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC 20101 driver]1509' (CHARACTER)
I think the issue is with the new Driver Path. But I am not able to locate UKor820.so in the 6.1 path.
Kindly advice on the same |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Sun Nov 29, 2009 9:02 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
which oracle version is it ??? is that 64 bit supported ?
_________________
Cheers |
|
| Back to top |
|
|
| bhavyabhandari |
| Posted: Sun Nov 29, 2009 9:03 pm Post subject: |
|
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
The version is Oracle 10g
It is 64-bit supported |
|
| Back to top |
|
|
| fschofer |
| Posted: Mon Nov 30, 2009 3:23 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
are you using 64-bit or 32-bit execution groups.
If you migrated the broker and they were 32-bit before they are still 32-bit now.
You will either have to create new 64-bit execution groups
or also configure the 32-bit odbc settings.
Greetings
Frank |
|
| Back to top |
|
|
| bhavyabhandari |
| Posted: Mon Nov 30, 2009 3:27 am Post subject: |
|
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
We are using 64-bit execution groups.
The Oracle Version is 10.2.0.4
Are their seperate .so files which have to be uploaded, or with Broker 6.1 we get the compatible files? |
|
| Back to top |
|
|
| fschofer |
| Posted: Mon Nov 30, 2009 3:43 am Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
have you adapted the odbc.ini files to the WMB 6.1 settings for oracle stanzas as listed in the WMB 6.1 infocenter ?
Greetings
Frank |
|
| Back to top |
|
|
| bhavyabhandari |
| Posted: Mon Nov 30, 2009 5:16 am Post subject: |
|
|
Apprentice
Joined: 09 Nov 2006
Posts: 33
|
yes,
I have adapted as per the requirement.
The odbc instances are working for other DBs which are Oracle 9i.
Is it an issue with reference to new driver paths for ORacle 10g? |
|
| Back to top |
|
|
|
|
