Hi All -

We have a condition where, for some reason, these fieldnames throw out an Invalid Fieldname error except for the first one - SALESPERSON_NAME_LAST - in our Prod system but works just fine in our QA system. The fields are from an Oracle view. They only error out when the view is JOINED to another table (a .FOC file).

SALESPERSON_NAME_LAST
SALESPERSON_NAME_FIRST
SALESPERSON_NAME_MIDDLE
SALESPERSON_GID

When I run a straight TABLE FILE on the view, it returns the fields just fine. If I join the view to a .FOC db then only the first field works, the others don't. These fieldnames are unique to the view and doesn't exist in the .FOC db. The query doesn't even hit Oracle before it errors out.

If I run the join in our QA system and report on these fields, they all work just fine.

I'm stumped and has no idea what to look at first. Changing the fieldnames in the view is gonna be tough as it is used by other systems.

Thanks for your assistance!

Regards,
Anatess

This message has been edited. Last edited by: <Emily McAllister>,

Did you copy the Master from one environment to another, or did you generate the Master in each environment?

Anatess,

If you extract your data from the Oracle view to a Focus file and then join the extracted file to your Focus, does the same problem occur?

Hi All -

I apologize for the delayed response. I went on a much needed break...

Francis, each environment generated their Master.

Danny, extracting the view into a Focus format yields the same error message. Interestingly, I also tried extracting the view to a Focus format with ASNAMES ON and holding as SALES_LAST, SALES_MIDDLE, SALES_FIRST, SALES_GID and it STILL gave me the same error. What does that tell me?

Regards,
Anatess

Is the "Invalid Fieldname error" generated from SQL or from WebFOCUS?

Does the fieldname in the table or view really contain underscores or are they dashes?

What is the exact error message and code?

Also you say

quote:

extracting the view into a Focus format yields the same error message

Does this happen during the extraction? or after the extraction is performed and the JOIN issued?