Re: 38501 on first HTTP_POST_VERBOSE

Wasn't someone else having this issue a couple weeks ago?

On Thu, Jan 8, 2026 at 10:25 AM Daniel Gross <[email protected]> wrote:

> SQLSTATE 38501 should be SQLCODE -443 - that's SQL0443 = Trigger program
> or external routine detected an error.
>
> Therefore you have to inspect the job log for the exception message before
> that.
>
> HTH
> Daniel
>
>
> > Am 08.01.2026 um 17:18 schrieb Brad Stone <[email protected]>:
> >
> > What is SQLCODE?
> >
> >> On Thu, Jan 8, 2026 at 10:12 AM Daniel Gross <[email protected]> wrote:
> >>
> >> It's most probably a AXISC exception - you have to look into the job log
> >> for the whole error message and 2nd level text - there might be a clue
> on
> >> what fails.
> >>
> >> HTH
> >> Daniel
> >>
> >>
> >>>> Am 08.01.2026 um 17:06 schrieb Justin Taylor <[email protected]>:
> >>>
> >>> We have an SQLRPGLE program that's calling QSYS2.HTTP_POST_VERBOSE().
> >> The
> >>> first call within a job always fails with SQLSTATE 38501.  Subsequent
> >> calls
> >>> always work.  All inputs are the same.
> >>>
> >>> How do we find the cause and fix this?
> >>>
> >>> Thanks
> >>> --
> >>> This is the RPG programming on IBM i (RPG400-L) mailing list
> >>> To post a message email: [email protected]
> >>> To subscribe, unsubscribe, or change list options,
> >>> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> >>> or email: [email protected]
> >>> Before posting, please take a moment to review the archives
> >>> at https://archive.midrange.com/rpg400-l.
> >>>
> >>> Please contact [email protected] for any subscription
> >> related questions.
> >>>
> >> --
> >> This is the RPG programming on IBM i (RPG400-L) mailing list
> >> To post a message email: [email protected]
> >> To subscribe, unsubscribe, or change list options,
> >> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> >> or email: [email protected]
> >> Before posting, please take a moment to review the archives
> >> at https://archive.midrange.com/rpg400-l.
> >>
> >> Please contact [email protected] for any subscription
> related
> >> questions.
> >>
> >>
> > --
> > This is the RPG programming on IBM i (RPG400-L) mailing list
> > To post a message email: [email protected]
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: [email protected]
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact [email protected] for any subscription
> related questions.
> >
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact [email protected] for any subscription related
> questions.
>
>
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.