• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Corrupt BSFN on Enterprise Server

jeremey_garcia

VIP Member
Hey ya'll

We got a problem that is disturbing us. We have had multiple BSFN's all =
of a sudden get corrupted. They are amongst different area's receiving =
on purchasing, and the ability to create A/P checks. Has anyone heard =
of this? Does anyone have any idea other then users, on how they can get =
corrupted? We have them locked down on a '400, and am interested in how =
this could've happened.

We are getting ready to build a full package against production to =
hopefully fix this problem. =20

TIA
Jeremey Garcia
programmer/analyst
864.255.4174
jeremey.garcia@deltamills.com



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix
 

simonk2

Member
We had a similar problem this week. We build a BSFN on an update package to production on our AS400. The update package did not relink the BSFN. All objects that used the BSFN did not work correctly. The solution to solve our problem was to run LINKBSFN on the AS400 and it corrected the problem. JDE support line said that you do not have to run a relink with an existing BSFN, only on new one's, but we found that anytime you promote a BSFN to production, you must run the LINKBSFN command on the AS400. We are at sp. 13.3. Hope this helped.

Krikor Simonian
Johnson Matthey
AS400
B7333 SP 13.3

Hey ya'll

We got a problem that is disturbing us. We have had multiple BSFN's all =
of a sudden get corrupted. They are amongst different area's receiving =
on purchasing, and the ability to create A/P checks. Has anyone heard =
of this? Does anyone have any idea other then users, on how they can get =
corrupted? We have them locked down on a '400, and am interested in how =
this could've happened.

We are getting ready to build a full package against production to =
hopefully fix this problem. =20

TIA
Jeremey Garcia
programmer/analyst
864.255.4174
jeremey.garcia@deltamills.com



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix
--------------------------
 

kastanek

Well Known Member
We've got the same issue and for us it's getting worse.

It started with a few UBE's not running fromthe OW Scheduler, then it
spread to UBE's run during the day as well. These same UBE's run just fine
when submitted locally but they don;t run on the server. We are just not
getting the correct results.

The UBE's we've identified to have this issue so far are:

R04570 - not receiving required results
R09813 - not receiving required results
R09706 - integrity report - receive error during processing
R03B707 - integrity report - receive error during processing
R09801 - producing unpredictable results for different users??? Usually
posting ALL apporved batches and not jsut selected batches.


If anyone has a solution I'd love to hear it. Nothing has changed
technically on the machine - no ESU's or SP's have been loaded recently.

We've tried deleting the Global tables in the Enterprise server, we've
tried building new FULL packages and deploying to the client and the server
and still the client runs fine and the server doesn't.

Ent Server: AS/400 V5R1 - Latest cume
Dep Server: W2K - Latest SP
OW Version: Xe, SP15.1

Regards,
Gerald.





jeremey_garcia
<jeremey.garcia@delta To: jdelistml@jdelist.com
mills.com> cc:
Sent by: Subject: Corrupt BSFN on Enterprise Server
owner-jdelistml@jdeli
st.com


08/02/2001 04:51 PM
Please respond to
jdelist





Hey ya'll

We got a problem that is disturbing us. We have had multiple BSFN's all =
of a sudden get corrupted. They are amongst different area's receiving =
on purchasing, and the ability to create A/P checks. Has anyone heard =
of this? Does anyone have any idea other then users, on how they can get =
corrupted? We have them locked down on a '400, and am interested in how =
this could've happened.

We are getting ready to build a full package against production to =
hopefully fix this problem. =20

TIA
Jeremey Garcia
programmer/analyst
864.255.4174
jeremey.garcia@deltamills.com



Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix
--------------------------
 

Larry_Jones

Legendary Poster
Gerald,

check on the server to make sure that the full package is being moved into the production directories/libraries (look at the create/mod dates). If something is preventing the spec files, etc. from being updated/replaced I would expect some of the symptoms you are experiencing.

Has someone recently changed the security permissions on the files/directories?

Larry Jones
ljones@wagstaff.com
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials
 

Jack_Crouch

Well Known Member
I would also blow away *SQLPKGs.

I recently started getting a Next Number Failure in R31802. Once these
were deleted (I do this each Sunday) the problem went away.



AS400 V4R5, XE+XU1+18ESUs, SP14.2, NT-SQL7 for CO
 

jeremey_garcia

VIP Member
Hey Gerald,

One of the UBE's you had problems with was one that we also had problems with. R04570. Edwards said to build a full package because the specs were corrupt on the '400. We eventually were able to get one built after fighting it for 4 days. (No CNC help here) Now, it looks like everything is running smoothly. (thank goodness).
I haven't heard of lnkbsfn. I will bring it to my bosses' attention, in case this ever happens again, that way we will try it. But if anyone else has tried it and had success with it on a '400, I will appreciate hearing how you did it.

Thanks for everyone's response.

Jeremey Garcia

Jeremey Garcia
Xe SP14 ES - AS/400 CO - AS/400 Deploy - NT Citrix
 

dschlieder

Well Known Member
Re: RE: Corrupt BSFN on Enterprise Server

Jack,

FWIW we added the line under the section [DB System Settings] of the jde.ini on the AS/400:

      SQL Package Library = 1.

This forces the SQL packages to go to QTEMP which means they only last as long as the job. We were having too many issues with these objects. Having to stop production and shut OneWorld down to delete then in the middle of the day, etc.

We did not have a noticeable decline in performance and we no longer have to periodically delete them.

There are a number of references to these on the KG. Some of them state that deleting the SQL package for some jobs will allow those jobs to run in much less time!

Another states that you need to delete them after each job you submit from the CL as they use a common package in some circumstances! We did not have this issue however but this would force you to do single threaded processing!

Dave
 

jdeperson

Active Member
Hi Gerald,

I'm looking at going to V5R1 very soon. Did your upgrade to V5R1 go well? Did you have any problems? Would you do it again at the same time you did? How long did it take to do the upgrade?

Any Gotchas you could tell me about?

Thank you,

Lori
 
Top