Neuron ESB User Network

The Service Bus for the Connected Business

I tried to use the following query in a table query command:

SELECT RTRIM(ACCT_UNIT), RTRIM(POSTING_DATE), RTRIM(LINE_NMBR), RTRIM(DESCRIPTION), RTRIM(QTY), RTRIM(AMOUNT) FROM FinanceStaging_LM WHERE POSTING_DATE = @postdate AND ACCT_UNIT = @acctunit AND ((QTY <> 0) OR (AMOUNT <> 0))

 

I get the following message when running the process:

Exception Type: System.Exception
Exception Message:

Pipeline Error Message: Process, 'LaMad MenuMix Feed', aborted. Process Execution process step Execute Finance Feed failed Executing Neuron Process,
'LaMad Finance Feed'. Table query pipeline step Get LM Fin Staged Data failed: Name cannot begin with the '>' character, hexadecimal value 0x3E.
Line 1, position 13.

Source Pipeline: LaMad Finance Feed
Source Pipeline Step: Get LM Fin Staged Data
Source Error Message: Name cannot begin w

 

The Character identified as '>' is actually '('.  Is Neuron translating the command string so the hex 0x3E becomes 0x28?  I've looked at the dat in hex and do not see a 0x3E. 

Can we not use functions like RTRIM in a table query command line in Neuron?  If we can, what to I need to do to use them.  BTW, the result if the query will be used in an XSLT for output to a file.

 

Thanks for any answers to this.  I need to get the spaces out of the data.

 

 

Views: 171

Reply to This

Replies to This Discussion

Hi,

Let me see if I can replicate this on our side

Ok...I'm going to put a fix in for this.  it will be in the 3.0.3.308 release.  should be ready by morning. 

However, you can make this work without the fix.  Just add an Alias to all your functions.  For example, if I use the following:

select RTRIM(FirstName) from PhoneBook where ID=5

I'll get the error you got.  However, if I modify it like so:

select RTRIM(FirstName) As FirstName from PhoneBook where ID=5

it will work just fine

RSS

Neuron ESB Product Support Forums and Communities

Latest Activity

Anupama Nair posted a discussion

Marketo Adapter Invalid Token

Hi,We are using the Marketo adapter to push account updates to Marketo. It works well for some time then starts failing with Invalid Token unless restarted. Is there a configuration that can be done so it can auto refresh the token when required?Thanks!See More
Nov 6, 2023
Sayantini Basak posted a discussion

Maximum payload size(REST API) for requests interfacing to NeuronESB

I am new to Neuron ESB and in our current scenario,We need to process batch transactions comprising of ~1000 records and send them to Neuron ESB for further processing. I would like to understand what is the maximum size of payload that can be transferred using REST interface to Neuron ESB.See More
Jul 22, 2022
Profile IconRobert E Dunie and Sayantini Basak joined Neuron ESB User Network
Apr 28, 2022
Profile IconDayanand, Frederic C, Steffen Greve-Oksfeldt and 1 more joined Neuron ESB User Network
Mar 16, 2022
Profile IconCam Vong and Mitja Luznar joined Neuron ESB User Network
Jan 27, 2022
Profile IconWill Hitzges, Chad Parsons, michael larsen and 4 more joined Neuron ESB User Network
Jun 11, 2021
Anupama Nair posted a discussion

ODBC stored proc polling with temporary tables

We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More
Dec 14, 2020
Prasanth Kharade is now a member of Neuron ESB User Network
Dec 30, 2019

Badge

Loading…

© 2024   Created by Neuron Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service