UBE over F986110

wcgodfrey

Member
List:
This may have alredy been discussed but I checked
the archive and could find nothing.
I am atempting to write a report over the F986110
file (just a simple dump) as a first step in creating
a procedure that will modify the records and set the
correct job queue based on the application / version
being executed. However I get the following error
whenever I try and run the simple report.
"You attempted to access F985110. ODBC Data
Source System - B7333 configured incorrectly. Set
Translate option to Do not Translate. Please exit
OneWorld and correct this problem."
The problem is if I create a Find Brouse with the
same business view it works just fine and other JDE
applications use this Business Veiw and they also work
fine so I know the error listed is not the real
problem.

Any thoughts on what I might be doing wrong?

Bill Godfrey
XE SP14.2
AS400 V4R5M0
SQL 7 SP6

_______________________________________________________
 

ovidiuc

Member
Hi Bill,

Did you try to make a mapping to the B9861102 Business function locally on the system datasource ?



Ovidiu Catana
Technical Consultant

NT4.0/Xe/Oracle 8
 

Larry_Jones

Legendary Poster
Bill,

try using View V986110A. This view is mapped correctly to the table and excludes the BLOB field which is probably what your UBE is puking on.

Regards,

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

david

Active Member
Hi Bill:

There is a problem with your client side JDE.INI--

In the [DB SYSTEM SETTINGS], because you are AS/400, you will need to modify a couple of lines. The "Base Datasource", and the "Database" lines need to have a "- DNT" added. Please see below:


[DB SYSTEM SETTINGS]
Version=43
Default User=JDE
Default Env=CNPD7333
Default PathCode=PD7333
Base Datasource=System - B7333 - DNT
Object Owner=
Server=joshua
Database=System - B7333 - DNT
Load Library=JDBODBC.DLL
Decimal Shift =Y
Julian Dates=Y
Use Owner=N
Secured=Y
Type=I
Library List=JOSHUA
TDSError=1
Library=SYS7333
LockMaxTries=50
Default Pwd=_




I hope this helps!

David

David Schoenberger
Focus on the Family
Xe SP15.1, AS/400 V4R5, NT workstations, 700+ fat client users
 
Discover how to build no-code data integrations and business process automations.
Top