BSFN not working properly in one of the Environment

sm_v

Active Member
One of the BSFN is not working correctly in one of the Environments. The Fetch single in the NER is failing. I can do an UTB from the same Environment and works fine. So the OCM and Data Source is fine.
When I check the Log for this environment and compare it against another(Where it works fine)- The Select SQL statement is not being submitted at all. I can see where the NER is called. But after that the select statement is missing in one env and is there in another
Any Inputs?
 
Maybe the object is different in the two environment's pathcodes?
e.g. you have an older copy in one.
 
It is. The Employee Inquiry Program works fine. Which uses the same table.
 
HOW did you check that?
Did you:
1 - open'em with BSFN Design/Code, and
2 - validate EACH line of NER code?
Warm regards,
 
Yes. I did a Debug. It goes to Fetch but If I compare the Debug or the JAS log -
There is no Select Statement at all for this file.
In the Environment that works, I can see the select Statement.
We have put a call to JDE and waiting...
The only difference - We applied Update 7 in the Environment that doesn't work.
 
I. Debug is NOT individual Validation.
In order to Validate an ER line, you have to:
1 - Print it BEFORE
2 - OPEN it (by double-clicking),
3 - take a look at ALL the elements/variables/parameters - and I bet the Fetch line is at fault in your BSFN - and I would
4 - re-assign ALL the parameters using the printout from 1
Then you save it, re-build it into its dll, and test it, and ... post your results

II. Update 7 may have changed a table, business view, indexes, ... vreify that, too.
Sometimes JDE forgets to list ALL the objects impacted, and suggest you build a FULL package ...
 
Back
Top