| Author |
Message
|
| Rookwood |
 Posted: Tue Aug 31, 2004 12:22 am Post subject: Problem loading CLOBs into oracle - ODBC error |
 |
|
Novice
Joined: 26 Aug 2004
Posts: 13
|
Running:
Win 2K,
WMBI v5.0,
Oracle 9,
DataDirect 4.10 32BT Oracle8 ODBC driver
Getting error :
[DataDirect][ODBC Oracle driver]Invalid precision value. Error in parameter 1
when trying to load CLOB's over 4K into Oracle.
I've seen a previous post regarding this error from 2002 for MQSIv2.1 and Oracle and wonder if the proposed solution of setting an undocumented Environment variable, is still good for V5.0
Graham
_________________
GS |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Aug 31, 2004 10:35 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Have you tried setting the environment variable?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Rookwood |
| Posted: Wed Sep 01, 2004 12:44 am Post subject: |
|
|
Novice
Joined: 26 Aug 2004
Posts: 13
|
Yes I have.
I'm assuming I've done this correctly.
Control Panel/System Properties applet...
->Advanced Tab/Enviroment Variables
Added it to System Variables list.
MQSI_ORACLE_LOB_TYPE set to CLOB
If I've added it correctly, the answer is doesn't appear to work.
We're trying to load the data via an Oracle stored procedure, the procedure is passed a character string.
Any idea's greatly appreciated.
G
_________________
GS |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Sep 01, 2004 9:45 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
System Enviroment variables are not guaranteed to be in effect until a reboot of the machine has occurred. (Not precisely, but close enough - you have to restart the shell of every process involved. Restarting is the easiest way to do this).
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Wed Sep 01, 2004 10:00 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Resarting the Broker service is enough.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| mgk |
| Posted: Thu Sep 02, 2004 12:01 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
It is not enough on windows as the service host process is the one that feeds the env to the processes it creates, namely bipservice in this case, which passes them down to bipbroker etc. Unless you kill and restart the service host (not a good idea) then a reboot is required to allow the broker to pick up system environment variable changes.
Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Sep 02, 2004 6:19 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
If I stop the broker serice will it not stop bipservice process also? If not, then when exactly this process is started in WMQI?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| kirani |
| Posted: Thu Sep 02, 2004 6:30 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
I tried this on my machine. It seems there is one instance of bipservice process for Config mgr and another instance for the Broker. When i shut-down the broker, corresponding bipserice process is also shutdown. So, I guess stopping the service is enough for a WMQI related environment variable to take effect. Please correct me if I am wrong.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Rookwood |
| Posted: Thu Sep 02, 2004 8:45 am Post subject: |
|
|
Novice
Joined: 26 Aug 2004
Posts: 13
|
I've rebooted the machine several times since I added the environment variable, just be be sure all the processes start afresh.
Still get the same error, so either I've entered the variable incorrectly - sure doesn't look wrong - or this work around doesn't work on v5.0 brokers.
Any other ideas I might try?
Graham
_________________
GS |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Sep 02, 2004 8:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| kirani wrote: |
| I tried this on my machine. It seems there is one instance of bipservice process for Config mgr and another instance for the Broker. When i shut-down the broker, corresponding bipserice process is also shutdown. So, I guess stopping the service is enough for a WMQI related environment variable to take effect. Please correct me if I am wrong. |
It's not the bipservice.exe process he's talking about. it's the svchost.exe process, which is responsible for starting all windows Services.
And as he said, killing or restarting svchost.exe is not a good idea without restarting the whole machine.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Sep 02, 2004 5:26 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Thanks for the clarification.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| chanduy9 |
| Posted: Fri Sep 03, 2004 8:11 am Post subject: |
|
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
Can you post your ESQL.
Thanks,
Chandra. |
|
| Back to top |
|
|
|
|
