Data Source returning error 'No response from server - Check your connection'

[myersra]

I have 2 numeric values for the phone number that I want to parse as a string value if complete (formatted like 999-9999). I am trying to do this as a case statement to create a new field in the data source. When I press the NEXT button to proceed to the data display I get the "No response from server...." error. If my syntax is invalid I normally see an error and don't see the NEXT button to continue. I want to use the digits function as it will return leading zeros.

Here is the statement I am attempting;

case when (geexch > 0) then digits(geexch) || '-' || digits(gephon)
else null
end AS phone,?

[robert.swanson]

That's peculiar, it should work fine...

Which version of Valence are you running there? Are you seeing anything coming back in the console?

[myersra]

The Valence version is 6.3.20250207.0. I'm seeing a 403 error in vvcall.pgm Here is a snapshot. DatasourceError.pdf There isn't an error posting in the Valence log. I even tried having the AI review the query and "fix" it. No luck....same error.

[sean.lanktree]

If you remove the case statement does it then work?

[myersra]

Yes...that was how I got around the error for now to complete the datasource and use it while I tried to figure out what I was doing wrong. When I added the case statement back it threw the error again. What was odd is that the NEXT button was available and that usually would indicate that the SQL statement was valid. I had heard Johnny Major say in a developer diaries presentation that there was a lot of things happening behind the scenes when the parser kicks in to validate the SQL.

[sean.lanktree]

Can you provide the full statement?

[myersra]

Here is the full statement;

SELECT
geempn,
gelnam,
gefnam,
geemal,
gecust,
genetid,
gephon,
gendat,
lscust,
lsname,
lskfsa,
trim(gefnam) || ' ' || trim(gelnam) AS ename,
geexch,
gearea,
case when geexch > 0 then digits(geexch) || '-' || digits(gephon)
else ' '
end AS phone,
rrn(LAUNDRY.GTEMASTPF) AS rrn1,
rrn(LAUNDRY.LCUSMASPF) AS rrn2
FROM
laundry.gtemastpf
JOIN laundry.lcusmaspf ON gecust = lscust
ORDER BY
gelnam
?

[sean.lanktree]

Hmmm...was hoping to see something else out of the ordinary. May have to take a look at this running on your system if possible.

[myersra]

Please let me know when you would like to set up a quick review of this issue via a remote call. I'm available after 11am ET 2/28.

[Johnny Major]

Can you please email support@cnxcorp.com to schedule a quick call

Thanks