[SOLVED] Report Works But Doesn't

December 15, 2008, 12:06 PM

I know this sounds odd but I have a report that works perfectly when I run it via developer studio but throws FOC14010 messages when I run it via my web application using the following CFML:

I verified that good data is being passed via the Cold Fusion variables. Can anyone think of anything else that would cause this report to fail via web application but work perfectly in developer studio?

Thanks in advance.
Chris

This message has been edited. Last edited by: Kerry,

December 15, 2008, 12:15 PM

GinnyJakes

Well, I had to look up the message and based on that you are having what I call a 'pathing' problem. You don't say whether you are running with an MFD or SQL passthru.

When you run from DS, you run as you and possibly have application pathing set up for your id. If you run from a browser, you may be running from a default id that only has access to the global profile.

Or you have your master in two different places, they are not the same, and the DS report has access to the correct one.

Please examine your environment to see if any of this makes sense.

December 15, 2008, 12:40 PM

RSquared

quote:
Reply

Copy your .fex into the baseapp folder and then try it again.

IB - Developer Center Forums FOCUS/WebFOCUS Report Works But Doesn't

December 15, 2008, 01:16 PM

j.gross

Your form:

 
<FORM name="form18" action="#wfServer#" method="post"  target="_blank">
  <input type="hidden" name="IBIF_ex" value="pcms_18">
  <input type="hidden" name="PkForWF" value="#variable.theInvoicePK#">
  <input type="hidden" name="FirstName" value="#variable.UserFirstName#">
  <input type="hidden" name="LastName" value="#variable.UserLastName#">
  <input type="hidden" name="PhoneNum" value="#variable.UserPhone#">
</FORM>

specifies which fex to execute, but not where it resides. Add another hidden input, IBIAPP_app, pointing to the appropriate app folder on the server.

December 15, 2008, 01:45 PM

Francis Mariani

The IBIAPP_app parameter is not required if the program resides in an app folder in the Application Path.

"fail via web application" - what is the error? Is the program not found? Is the master not found?

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

December 15, 2008, 02:31 PM

mullman

Here's the text of the error that appears in the browser:

"(FOC14010) E.TCOMPANY_FK IS NOT A VALID COLUMN NAME"

I don't understand how a column could be invalid via the browser and work just fine under Developer Studio. I appreciate any assistance in helping me understand this issue further.

Chris

December 15, 2008, 02:34 PM

RSquared

Please post the code !!

December 15, 2008, 02:41 PM

GinnyJakes

We have been trying to help you. Are you using a master file description? If yes, is there more than one version of the one you are using? Are they different?

Have you checked into application paths, re: discussion of IBIAPP_app above?

December 15, 2008, 02:42 PM

Francis Mariani

quote:
I don't understand how a column could be invalid via the browser and work just fine under Developer Studio

This can happen when your application path is different in each of the environments. You could be pointing to a different Master.

Add the following code to determine which Application folder the Master is found in:

WHENCE master-file-name MASTER
-RUN

Add the following code to see all the fields in the Master:

?FF master-file-name
-RUN

(Substitute master-file-name for the one you're using)

Add these commands to the top of your program in both environments and the results should help you determine what's going on.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

December 15, 2008, 03:20 PM

mullman

Francis,
Thanks for that code suggestion. It looks like the issue is definitely with the path. When I run it within Developer Studio it's different from what I get within the web application environment so I'll have to work with my server admins to get them synch'ed up.

Thanks again and Merry Christmas,
Chris