Running report locally

echeng

Active Member
This morning all my developer including me (full access) can't run reports locally but can run from the server.
The error we got is :
Unable to locate table in specified datasource for section:
Financial Reporting (F0901/F0902/F0006).
If we can run it from the server, then it is not a security issue. Where can I look??
 
Does this error occur for all reports or just Finance reports?

Can you UTB to the F09901, F0902 and the F0006? If yes then what datasource
are you pointing to? (ie do you have an overriding OCM)

Is the BSVW on the local workstation corrupt? Check out the BSVW(s) for the
report in question.

Does anything else show up in the jde.log???


Colin

** Shared Knowledge = Better Knowledge **

Implementing B7333 (Xe) SP18.1, SQL
 
You can check your OCM mappings to see if you have specific mappings for thest tables. By default they are mapped to Business Data
 
They are not in the OCM mappings.



Xe with SP 14.1
AS400, 2 Window2000 Application Servers
Citrix MetaFrame with VPN

** Shared Knowledge = Better Knowledge **

Implementing B7333 (Xe) SP18.1, SQL
 
Definitely sounds like someone's been screwing with the OCM mappings.
 
I have

PD7333 Default TBLE Business Data-PROD *Public AV

No mapping for the 3 files in the error msg.





Xe with SP 14.1
AS400, 2 Window2000 Application Servers
Citrix MetaFrame with VPN

** Shared Knowledge = Better Knowledge **

Implementing B7333 (Xe) SP18.1, SQL
 
Re: RE: Running report locally

On both server and system side....can you run any other reports locally, Do you have a base JDE report that uses these tables to try and run locally. Also can you pull those up in UTB.
 
RE: RE: Running report locally

I can pull the table from UTB.

Only new reports they are working on has this problem. All existing reports
can be ran locally.





Xe with SP 14.1
AS400, 2 Window2000 Application Servers
Citrix MetaFrame with VPN
 
I dont know if you heard anything on this yet or fixed it by now...but this is a problem with your business view being corrupted on that UBE. You need to re-attach the bsvw to your section. Yes, this can be a pain in the butt if you have a lot of level breaks and references to bsvw columns, but it works!
 
Back
Top