Re: Setting up a SQL webservice.

I am not getting a 500 error.
I get a result that may be a sql error. However, I tested the SQL and it is
good.
This is the result.

{

"SQLStateInfo": {

"rowsAffectedCounts": null,

"SQLError": null,

"SQLWarnings": [

{

"SQLState": "HY001",

"SQLCode": 1301,

"message": "Invalid request for iSGateOpen."

}

]

}

}


Something in the setup must be wrong but what?

Darryl



On Thu, May 25, 2023 at 10:32 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Have you checked that the SQL runs in Run SQL scripts?

A 500 error indicates a program "explosion" somewhere in your backend
called code. In this case that would be the SQL procedures,


Jon P.

On May 25, 2023, at 9:27 AM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I have checked the spelling.

The web service is being called. The result in the browser has a

different

message when the spelling including case sensitivity is used.

My problem is I don't know how far the call goes within the system and

why

does it not return the value in the JSON?

Thanks, Darryl.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.