UBE over F986110

[wcgodfrey]

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]

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]

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

 

[david]

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