Corrupt BSFN on Enterprise Server

[jeremey_garcia]

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
[email protected]



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

 

[simonk2]

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
[email protected]



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

 

[kastanek]

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: [email protected]
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
[email protected]



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

 

[Larry_Jones]

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
[email protected]
OneWorld XE, SP 15.1
HPUX 11, Oracle SE 8.1.6
Mfg, Distribution, Financials

 

[Jack_Crouch]

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]

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]

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]

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