[SOLVED] FOC1406 SQL OPEN CURSOR ERROR

I’ve created a procedure in Developer Studio 7.62 that uses a SQL 2000 view. The procedure has 3 parameters in it and works fine when just executing the procedure.
When I create an HTML File, add a new report, select “Reference an existing procedure”
I get an Error Message stating the following;
(FOC 1400) SQL CODE IS 208
FOC1406 SQL OPEN CURSOR ERROR. :VWALLPROJECTSBYBUSINESSACCTREP

We’ve tested the connection.

Any suggestions?

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

Darin Lee

Virtuoso

posted

Hide Post

You got the first step in testing the connection. Second step would be to test the view. Can you retrieve sample data for that master file from the data server (or create a simple fex to read 100 lines in dev Studio)? If that works, there are a couple other things to try including looking at your HTML file and/or existing procedure.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

posted

To answer your question, Yes. If I execute the porcedure from Developer Studio it runs and I've executed the view from SQL.
In Dev Studio the drop-down boxes populate correctly and the procedure runs
Below is the relevant WHERE statements

WHERE ( MEMBERTITLE EQ '&MEMBERTITLE.(FIND MEMBERTITLE IN vwallprojectsbybusinessacctreps).MEMBERTITLE.' );
WHERE ( MemberName EQ '&MemberName.(FIND MemberName IN VWALLPROJECTSBYBUSINESSACCTREPS).MemberName.' );
WHERE ( STATUS EQ '&STATUS.(FIND STATUS IN vwallprojectsbybusinessacctreps).STATUS.' );

It's when I try to use the procedure in anHTML file that the problem occurs

Darin Lee

Virtuoso

posted

Hide Post

Now that you have the procedure completed and working and you're creating a separate HTML page that runs this procedure, you'll want to also create your own controls to populate the drop-down boxes. In this case, simplify your WHERE statements (e.g. WHERE MEMBERTITLE EQ '&MEMBERTITLE'; ) and use the parameters tab in the HTM layout painter (whatever it's called now) to tell the page to dynamically retrieve the values from the appropriate fields in the view.

I usually only leave the FINDs in the where if it will only be run using autoprompting, not if it has its own launch page. And I don't particularly care for autoprompting either so I rarely use FIND IN at all.

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

posted

I tried your suggestion( note revised WHERE statements below). It’s when I try to set the Control Values and check “Dynamic” that the error occurs.

I’ve discovered that if I create the procedure and HTML file in the Application Folder under EDASERVE and then copy it to the Domain in Managed Reporting it will run but if I try to edit it in HTML Painter the error occur when the file opens.

WHERE ( MEMBERTITLE EQ '&MEMBERTITLE' );
WHERE ( MemberName EQ '&MemberName' );
WHERE ( STATUS EQ '&STATUS' );

Darin Lee

Virtuoso

posted

Hide Post

Wheh you create an HTML page under EDASERVE there is a lot of information that is not added because it is under the server path instead of insdie the MR domain. try creating th WHOLE THING inside of MRE, including re-creating the fex (not just reference existing or import). This is pretty simple functionality so there's something easy that we're missing.

Regards,

Darin

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Show Post

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

[SOLVED] FOC1406 SQL OPEN CURSOR ERROR

Focal Point | Privacy Statement | Terms of Service