nkuebelbeck
VIP Member
I've been tasked with creating a custom function to delete work order in case it was created in error because jde doesn't have a really friendly way to do it.
I've got it coded and everything is working great on my fat client. Boom, life if good.
I got it deployed to the Enterprise server (ISERIES) and when I went to execute it my BSFN from a custom interactive application it errors with a 3143 file can not be accessed.
hmmmmmmmm didn't see this in development on my fat client.
Asked the as400 guru to double check everything security wise is ok. check.
turned on some E1 debug logs to the kernel I was attached to and I see this
Feb 17 12:12:05.694048 jdb_rq1.c1169 - 748/4 WRK:MYUSER_80000000_P550102 Entering JDB_OpenTable(Table = F31122)
Feb 17 12:12:05.694064 jdb_rq1.c1570 - 748/4 WRK:MYUSER_80000000_P550102 JDB3100001 - Failed to open table F31122 because of invalid user handle
Feb 17 12:12:05.694480 jdb_rq1.c1180 - 748/4 WRK:MYUSER_80000000_P550102 Exiting JDB_OpenTable(Table = F31122) with Failure
I don't get it. This is my first time really using JDB API so there's a very likely possibility I've missed a quirk.
attached is the code snippet that appears to error, and the error that display on the screen from the interactive program.
Can anyone guide me in the right direction?
I've got it coded and everything is working great on my fat client. Boom, life if good.
I got it deployed to the Enterprise server (ISERIES) and when I went to execute it my BSFN from a custom interactive application it errors with a 3143 file can not be accessed.
hmmmmmmmm didn't see this in development on my fat client.
Asked the as400 guru to double check everything security wise is ok. check.
turned on some E1 debug logs to the kernel I was attached to and I see this
Feb 17 12:12:05.694048 jdb_rq1.c1169 - 748/4 WRK:MYUSER_80000000_P550102 Entering JDB_OpenTable(Table = F31122)
Feb 17 12:12:05.694064 jdb_rq1.c1570 - 748/4 WRK:MYUSER_80000000_P550102 JDB3100001 - Failed to open table F31122 because of invalid user handle
Feb 17 12:12:05.694480 jdb_rq1.c1180 - 748/4 WRK:MYUSER_80000000_P550102 Exiting JDB_OpenTable(Table = F31122) with Failure
I don't get it. This is my first time really using JDB API so there's a very likely possibility I've missed a quirk.
attached is the code snippet that appears to error, and the error that display on the screen from the interactive program.
Can anyone guide me in the right direction?