[CASE-OPENED] Loading dropdown from FEX

July 17, 2015, 04:31 PM

I have run into a situation where I'm getting a very general error. I've gone down to create it in the most basic way for demonstration purposes.

It happens when I try to load a dropdown from an FEX file in the HTML canvas editor. The FEX in question returns a list of term codes and descriptions.

Below are screenshots of how I have things set-up and the error message. Does anyone know what is going wrong?

Below is the code for the FEX file

 TABLE FILE NW_S_TERM_ACAD_PROG
BY  HIGHEST NW_S_TERM_ACAD_PROG.NW_S_TERM_ACAD_PROG.TERM
BY  NW_S_TERM_ACAD_PROG.NW_S_TERM_ACAD_PROG.TERM_DESC
WHERE TERM LIKE '____10';
ON TABLE NOTOTAL
END

This message has been edited. Last edited by: <Kathryn Henning>,

July 19, 2015, 10:34 AM

WF_IL

Hi

Try to add to the fex
ON TABLE PCHOLD FORMAT XML
Yours
Eran

July 20, 2015, 09:51 AM

Egon

Eran,

Unfortunately, that resulted in the same error.

Egon

July 20, 2015, 10:57 AM

CoolGuy

Egon,

Firstly, your name reminds me of the movie Ghostbusters.

Back on topic:

Try starting over with a new/fresh file. Before creating the dropdown, create a form for it to be housed in. Then add the dropdown.

Then, your code does need the ON TABLE PCHOLD FORMAT XML line at the bottom of your request no matter if the error your getting appears or not. I'm thinking your WHERE clause may be the issue, but don't quote me on that. Try taking that out and see if it runs without error. Also, Try adding -SET &ECHO=ALL; to the top of your code and running it. Then you can see what happens when your code runs in addition to the error to better troubleshoot the issue. Also, you have yet to bind a parameter to your dropdown control. Maybe that would help also.

July 20, 2015, 11:59 AM

Egon

CoolGuy,

Lots of people say that about my name haha.

I went ahead and tried all of your suggestions, still to no avail.

Here's the source code of the HTML page generated.

<HTML>
            <HEAD><Title>WebFOCUS Message: no valid cgi request to process
            </Title></Head>
            <Body>
            <H2>
            WebFOCUS was called with an invalid request.
            </H2>
            </Body>
            </HTML>

July 20, 2015, 01:39 PM

CoolGuy

Hmmm....

Try altering your code to replicate the below code from a control population request that I know works to see if that works against your data:

-SET &ECHO=ALL;

TABLE FILE [your file]
SUM
[your display value field]
BY HIGHEST [your return value field]
ON TABLE PCHOLD FORMAT XML
END
-RUN

Note: Do not worry about qualifying your fields unless they belong to a file joined to your parent segment within your data description.

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

July 20, 2015, 01:51 PM

Egon

I altered your code to use my table and fields and it still returned the exact same error.

July 20, 2015, 01:57 PM

Egon

okay, I just may have found something. If I place both files in my approot folder it works... is there a max length for the path?

July 20, 2015, 02:00 PM

CoolGuy

Are you getting sample data back from querying the .mas fields used in your request? If so, then I would open a case with tech support. Not sure why the requests aren't valid for you, or what it means by "cgi request". Sorry man.

July 20, 2015, 02:02 PM

CoolGuy

Ah! So your request isn't able to find your data description I'm guessing. Go to your application's properties and under Application Paths make sure that app can see the directory your .mas is in. I don't believe there are restrictions on how long your app path can be. If your app path is set correctly and you still can't get it to work inside your app directory, then it may be that your app directory is corrupt and/or configured incorrectly. My suggestion would be to open a case if so.

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

July 20, 2015, 04:14 PM

susannah

or just put the app name in the table file request, eg.
TABLE FILE ibisamp/CAR
easy and doesn't leave behind any pathing issues.

July 21, 2015, 10:08 AM

Egon

Okay, I have another update. After playing around with it all afternoon I was able to find the following cause to this issue.

The error occurs if the HTML page is in a path that is beyond a certain length. The length of the file name didn't affect the error.

Max lenght:
IBFS:/WFC/Repository/IR/DataCenter/Student_Affars/Dashbaord/Reports/DetailPages/GreekLi

One to long:
IBFS:/WFC/Repository/IR/DataCenter/Student_Affars/Dashbaord/Reports/DetailPages/GreekLif

My original folder:
IBFS:/WFC/Repository/IR/DataCenter/Student_Affars/Dashbaord/Reports/DetailPages/GreekLife

It seems the max path length for the explicit to work is 87 characters. I'm on version 8.0.0.8 and I was wondering if anyone could reproduce this so I can open a case.

Thanks, Egon

July 21, 2015, 10:24 AM

CoolGuy

Egon,

I just made a really long absolute file path that met or exceeded 100 characters in length and ran a test report without any issue. I'm using AppStudio 8.1.04. You might need to upgrade.