jimmymac
Reputable Poster
We have an issue with a trigger failing in an AS400 environment. Here are the specifics.
We are trying to run the chart of account copy UBE in batch. However, there is a nonJDE trigger on the F0901 that needs to read the F0006 table. The trigger is failing with the error that it basically cannot find the file in the library list. We are running XE in a fat client environment with an AS400 server.
When the UBE is submitted to batch it runs fine, but apparently the submitted job isn't just using the libary list like a normal AS400 job, but somehow accesses the JDE files correctly in PRODDTA through some other means. I say this because the library list of the submitted UBE jobs have a library list that do not contain PRODDTA. So they can apparently access the proper files through the environment somehow.
But when the non JDE trigger fires off, it fails we assume becasue the library of the job within the environment its running doesn't have PRODDTA in it.
That UBE uses a profile called JDEDATA and a JOBD called JDEJOBD.
My suggestion would be to try to add PRODDTA to the default library list for the user profile, but my people here are reluctant. ANy other suggestions would be appreciated.
Thanks.
We are trying to run the chart of account copy UBE in batch. However, there is a nonJDE trigger on the F0901 that needs to read the F0006 table. The trigger is failing with the error that it basically cannot find the file in the library list. We are running XE in a fat client environment with an AS400 server.
When the UBE is submitted to batch it runs fine, but apparently the submitted job isn't just using the libary list like a normal AS400 job, but somehow accesses the JDE files correctly in PRODDTA through some other means. I say this because the library list of the submitted UBE jobs have a library list that do not contain PRODDTA. So they can apparently access the proper files through the environment somehow.
But when the non JDE trigger fires off, it fails we assume becasue the library of the job within the environment its running doesn't have PRODDTA in it.
That UBE uses a profile called JDEDATA and a JOBD called JDEJOBD.
My suggestion would be to try to add PRODDTA to the default library list for the user profile, but my people here are reluctant. ANy other suggestions would be appreciated.
Thanks.