Dialogue Mngr - 7.1.4 vs 7.6.4

January 14, 2008, 01:20 PM

Why will dialogue Manager not work the same once we upgraded our server to 7.6.4? When we run the fex on our old server it works just fine but when we run it on our new upgraded server we get an error message as follows:

Project='Laurus'
TWO Project='
Manager=FOC_NONE
TWO Manager=FOC_NONE
Capital_Code=FOC_NONE
TWO Capital_Code=FOC_NONE
0 ERROR AT OR NEAR LINE 115 IN PROCEDURE trak_stat_details
(FOC257) MISSING QUOTE MARKS: ';
BYPASSING TO END OF COMMAND
(FOC009) INCOMPLETE REQUEST STATEMENT

We run the exact same fex on the old server and it works perfectly. What can be the difference? Any and all help is GREATLY appriciated!!!

Ana

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

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

January 14, 2008, 02:13 PM

Leah

quote:
Project='Laurus'
TWO Project='
Manager=FOC_NONE
TWO Manager=FOC_NONE

It's called tightening the code, note you do have a quote mark missing on the TWO Projects=.

I just went through something similar with a complex where clause, worked in 5.3.6, died in 7.6.2 and .4, just crashed and burned so to speak.

Leah

January 14, 2008, 02:20 PM

Latigresa

It claims to be missing but it is not.

If it were missing it would not work on the old server. Here is the actual code being used on both servers...

-TYPE Project=&Project
-SET &Project='&Project.EVAL';
-TYPE TWO Project=&Project

-TYPE Manager=&Manager
-SET &Manager='&Manager.EVAL';
-TYPE TWO Manager=&Manager

-TYPE Capital_Code=&Capital_Code
-SET &Capital_Code='&Capital_Code.EVAL';
-TYPE TWO Capital_Code=&Capital_Code

Ana

WEBFOCUS 7.6.4
Server: WINXP

January 14, 2008, 02:29 PM

Leah

So where is the single quote coming from, is someone passing the parameter with a quote in it? Since it is an amper variable it wants it, and then you do a set after the fact, it's as if you are trying to output something that isn't there of course I'm not big dialog manager person, so this may have been a perfectly okay at some time.

Leah

January 14, 2008, 02:42 PM

FortuneCookie

If I input 'Laurus' I also get:
Project='Laurus'
TWO Project='

If I input Laurus I get:
Project=Laurus
TWO Project=Laurus

I don't really get the FOC_NONE but are you also using something with HTML Layout

Prod: WebFOCUS 7.1.6, Windows 2003

Dev: WebFOCUS 7.6.2, Windows 2003

January 14, 2008, 03:27 PM

Latigresa

Thank you so much...I removed the SETs in Dialogue Mngr it it is now working...

Thanks!!!
Ana

WEBFOCUS 7.6.4
Server: WINXP

January 14, 2008, 03:36 PM

Leah

Glad it worked. Nothing like fixes.

Leah