| Author |
Message
|
| Frik |
 Posted: Thu Jan 17, 2013 2:43 am Post subject: Really weird problem with writing to SQLServer |
 |
|
Acolyte
Joined: 25 Nov 2009
Posts: 69
|
In a new Broker, V7.0.0.4 on AIX,
and we are trying to write to SQLServer.
we have set the mqsisetdbparms correctly,
the odbc.ini is in the place,
and etc.
when we are trying to write to the DB, we get the next error message:
error WebSphere Broker v7004[753842]: (Q538MMWB.egInfra)[10025]BIP2322E: Database error: SQL State '22007'; Native Error Code '241'; Error Text '[IBM][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.'.
Now, we have a second Broker, on a similar
OS (we checked the version as well), with a Qmgr that is defined exactly like the first one mentioned here, same encoding, same CCSID, same Queue names, and everything else. we checked a lot of things, really. With this Broker we can write to the SQLServer, but with the first one - we get the above bolded error.
BTW - It's the same flow (we checked the bar over and over again),
and a similar broker as well.
Any clues, ideas, something? |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Thu Jan 17, 2013 2:52 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Are the two ODBC definitions in your ODBC.ini identical as well?
If they are then it might be down to looking at the ODBC trace.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Thu Jan 17, 2013 3:18 am Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
Hi Frik,
Simple question came to my mind. Is the insert request ( = values) same in both servers?
--
marko |
|
| Back to top |
|
|
| McueMart |
| Posted: Thu Jan 17, 2013 3:27 am Post subject: |
|
|
Chevalier
Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere
|
| Yes it would have been helpful if you could tell us the actual character string which is being inserted into the data/time field. |
|
| Back to top |
|
|
| Frik |
| Posted: Thu Jan 17, 2013 3:55 am Post subject: Answers |
|
|
Acolyte
Joined: 25 Nov 2009
Posts: 69
|
smdavies99 - Yes, are identical. it's the same file which was only copied between servers. Same driver as well.
marko.pitkanen - Yes, it's the same insert, it's the same flow.
McueMart - what do you mean? as far as I know it's UTF-8. where can I check it?
(just remind you that the same flow on the second broker is working, with the same properties) |
|
| Back to top |
|
|
| McueMart |
| Posted: Thu Jan 17, 2013 4:13 am Post subject: |
|
|
Chevalier
Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere
|
| I.e. Was the Character string you were inserting like '2013-01-17 12:12:00.000' or something else? |
|
| Back to top |
|
|
| Frik |
| Posted: Thu Jan 17, 2013 4:50 am Post subject: hmm |
|
|
Acolyte
Joined: 25 Nov 2009
Posts: 69
|
| McueMart - It's look exactly like this. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jan 17, 2013 4:53 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
So it's the same flow accepting the same message running on two different brokers and experiencing two different behaviors.
And the brokers are the exact same level and etc. etc. etc - you've said you verified these things.
Take a service trace of the flow on each Broker.
Compare them. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Jan 17, 2013 6:07 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Is the data exactly the same or are you passing a string in once case and a timestamp in the other? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
