| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| CAST TIMESTAMP TO CHAR FAILS IF FORMAT OPTION CONTAINS 'ZZZ' |
« View previous topic :: View next topic » |
| Author |
Message
|
| MizukiYamato |
 Posted: Fri May 21, 2010 3:02 pm Post subject: CAST TIMESTAMP TO CHAR FAILS IF FORMAT OPTION CONTAINS 'ZZZ' |
 |
|
Apprentice
Joined: 16 Dec 2009
Posts: 45
Location: Japan
|
Hi,
I am using WMBv7.0 and WMBT v7.0(fix2).
In the environment, I tryed below code, but I recieved BIP2228E, and the broker put out abend file.(and reboots)
DECLARE TIMESTR CHARACTER CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'yyyy-MM-dd''T''HH:mm:ssZZZ');
(but, below code works well.
DECLARE TIMESTR CHARACTER CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'yyyy-MM-dd''T''HH:mm:ss'); )
I tryed on AIX 5.3 and Windows XP(Pro), and both of them works same.
Above ESQL is wrong? or broker's problem?
Please help.
syslog(AIX5.3) :
May 22 06:26:29 loopback user:err|error [19894]: [ID 000000 user.error] (BKR001.805e940a-2801-0000-0080-b4c5f049490b)[4639]BIP2228E: Severe error: /build/S700_P/src/CommonServices/Unix/ImbAbend.cpp 1034 signal received Abend file: /var/mqsi/common/errors/BKR001.805e940a-2801-0000-0080-b4c5f049490b.19894.4639.abend action: abort
May 22 06:26:38 aix001 user:warn|warning WebSphere Broker v7000[15236]: (BKR001)[6686]BIP2060W: The broker has detected that the Execution Group EXG001, process ID 19894, has shutdown. : BKR001.agent: /build/S700_P/src/AdminAgent/ImbAdminAgent.cpp: 4633: ImbAdminAgent::startAndMonitorADataFlowEngine: :
May 22 06:26:39 aix001 user:info WebSphere Broker v7000[19896]: (BKR001.EXG001)[1]BIP2208I: Execution group (64) started: process '19896'; thread '1'; additional information: brokerName 'BKR001' (operation mode 'trial100410'); executionGroupUUID '805e940a-2801-0000-0080-b4c5f049490b'; executionGroupLabel 'EXG001'; queueManagerName 'QM01'; trusted 'false'; userId ''; migrationNeeded 'false'; brokerUUID 'ac41e68e-44cc-11df-8a74-000000000000'; filePath '/opt/IBM/mqsi/7.0'; workPath '/var/mqsi'; ICU Converter Path ''. : BKR001.805e940a-2801-0000-0080-b4c5f049490b: /build/S700_P/src/DataFlowEngine/ImbMain.cpp: 515: ImbMain::start: :
May 22 06:27:18 aix001 user:info WebSphere Broker v7000[19896]: (BKR001.EXG001)[1]BIP3132I: The HTTP Listener has started listening on port '7800' for 'http' connections. : BKR001.805e940a-2801-0000-0080-b4c5f049490b: /build/S700_P/src/DataFlowEngine/NativeTrace/ImbNativeTrace.cpp: 837: TomcatInstanceManager::startTomcatIfNecessary: :
May 22 06:27:19 aix001 user:info WebSphere Broker v7000[19896]: (BKR001.EXG001)[5144]BIP2152I: Configuration message received from broker. : BKR001.805e940a-2801-0000-0080-b4c5f049490b: /build/S700_P/src/DataFlowEngine/ImbConfigurationNode.cpp: 320: ImbConfigurationNode::evaluate: :
May 22 06:27:19 aix001 user:info WebSphere Broker v7000[19896]: (BKR001.EXG001)[5144]BIP2153I: About to 'start' an execution group. : BKR001.805e940a-2801-0000-0080-b4c5f049490b: /build/S700_P/src/DataFlowEngine/ImbConfigurationNode.cpp: 323: ImbConfigurationNode::evaluate: :
May 22 06:27:19 aix001 user:info WebSphere Broker v7000[19896]: (BKR001.EXG001)[5144]BIP2154I: Execution group finished with Configuration message. : BKR001.805e940a-2801-0000-0080-b4c5f049490b: /build/S700_P/src/DataFlowEngine/ImbConfigurationNode.cpp: 458: ImbConfigurationNode::evaluate: : |
|
| Back to top |
|
 |
| mgk |
| Posted: Sat May 22, 2010 5:43 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi, this is a known problem. Please raise a PMR to get a fix...
Kind Regards,
_________________
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 |
|
|
| MizukiYamato |
| Posted: Sat May 22, 2010 5:59 am Post subject: |
|
|
Apprentice
Joined: 16 Dec 2009
Posts: 45
Location: Japan
|
| Thank you very much, mgk. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Sat May 22, 2010 10:06 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Please *MAKE SURE* to put a link to this thread in your PMR text.
It will help. |
|
| Back to top |
|
|
| MizukiYamato |
| Posted: Sat May 22, 2010 4:28 pm Post subject: |
|
|
Apprentice
Joined: 16 Dec 2009
Posts: 45
Location: Japan
|
Thank you, Mq Jeff.
I'll do so.
(However, I might not be able to raise PMR for the limitation of my contract...) |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
