ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker (ACE) SupportError executing the SQL statement PROPAGATE TO LABEL

Post new topicReply to topic
Error executing the SQL statement PROPAGATE TO LABEL View previous topic :: View next topic
Author Message
thanbv1510
PostPosted: Thu Sep 15, 2022 2:19 am Post subject: Error executing the SQL statement PROPAGATE TO LABEL Reply with quote

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
View user's profile Send private message
timber
PostPosted: Thu Sep 15, 2022 2:29 am Post subject: Reply with quote

Grand Master

Joined: 25 Aug 2015
Posts: 1280

You have not provided enough information. Please supply the full error text, plus any associated errors issued at the same time.
Back to top
View user's profile Send private message
thanbv1510
PostPosted: Thu Sep 15, 2022 3:30 am Post subject: Reply with quote

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
View user's profile Send private message
bruce2359
PostPosted: Thu Sep 15, 2022 4:08 am Post subject: Re: Error executing the SQL statement PROPAGATE TO LABEL Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9392
Location: US: west coast, almost. Otherwise, enroute.

thanbv1510 wrote:
my error in anotepad with URI: https://anotepad_com/notes/r7gat6nf (please change _ to .)

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
View user's profile Send private message
abhi_thri
PostPosted: Sat Sep 17, 2022 1:09 am Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker (ACE) SupportError executing the SQL statement PROPAGATE TO LABEL
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.