| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Error executing the SQL statement PROPAGATE TO LABEL |
View previous topic :: View next topic |
| Author |
Message
|
| thanbv1510 |
 Posted: Thu Sep 15, 2022 2:19 am Post subject: Error executing the SQL statement PROPAGATE TO LABEL |
 |
|
Newbie
Joined: 15 Sep 2022
Posts: 8
|
Hi there, my flow running working fine:
| Code: |
SOAP Input -> Compute -> Route To label
-> ws(Label node)
-> modyfyWsgc(Label node)
-> ipcWsgc(Label node)
|
with code in Compute:
| Code: |
DECLARE opration CHARACTER InputRoot.SOAP.Context.operation;
-- add other api into list
DECLARE oprationOthers ROW;
SET oprationOthers.Name[] = LIST{'modifyWsgc', 'ipcWsgc'};
IF EXISTS(SELECT n.* FROM oprationOthers.Name[] AS n where n = opration) THEN
PROPAGATE TO LABEL opration;
ELSE
PROPAGATE TO LABEL 'ws';
END IF;
RETURN FALSE;
|
but today i get the error:
| Code: |
BIP2488E: Error detected whilst executing the SQL statement ''PROPAGATE TO LABEL 'ws' FINALIZE DEFAULT DELETE DEFAULT;''.
|
I using IIB 10.0.0.7
I can't reproduce the error. Please help me 
edit: I can't put full error to here, because:
| Code: |
You must have 2 posts before you can post URL's/Links.
|
my error in anotepad with URI: https://anotepad_com/notes/r7gat6nf (please change _ to .)
MY flow has been working fine for about 10 days and the bug just popped up today
Last edited by thanbv1510 on Thu Sep 15, 2022 3:38 am; edited 8 times in total |
|
| Back to top |
|
 |
| timber |
| Posted: Thu Sep 15, 2022 2:29 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1290
|
| You have not provided enough information. Please supply the full error text, plus any associated errors issued at the same time. |
|
| Back to top |
|
|
| thanbv1510 |
| Posted: Thu Sep 15, 2022 3:30 am Post subject: |
|
|
Newbie
Joined: 15 Sep 2022
Posts: 8
|
| timber wrote: |
| You have not provided enough information. Please supply the full error text, plus any associated errors issued at the same time. |
- Sorry, I edited this post. Please help me |
|
| Back to top |
|
|
| bruce2359 |
| Posted: Thu Sep 15, 2022 4:08 am Post subject: Re: Error executing the SQL statement PROPAGATE TO LABEL |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9442
Location: US: west coast, almost. Otherwise, enroute.
|
Sorry, but I don't click on random URLs.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| abhi_thri |
| Posted: Sat Sep 17, 2022 1:09 am Post subject: |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
| thanbv1510 wrote: |
MY flow has been working fine for about 10 days and the bug just popped up today |
hi...if you look closer at the error it is pretty obvious on why it failed.
| Quote: |
BIP2136E: Source character ''1ed7'' in field ''003c003f0078006d006c002000760065007200730069006f006e003d00220031002e0030002200200065006e0063006f00640069006e0067003d002200690073 ...data truncated to first 64 chars'' cannot be converted from Unicode to codepage '819'.
The source character is an invalid code point within the given codepage.
Correct the application or message flow that generated the message to ensure that all data within the message can be represented in the target codepage. |
i.e the incoming message came with '1ed7' character “ỗ” which is not supported in Latin1 (819) codepage. So either request Source system to stick to 819 or get the Target system to support Unicode (eg:- 1208) |
|
| 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
|
|
|
|
