Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator - Stored procedure saving issue
Go
New
Search
Notify
Tools
Reply
  
Data Migrator - Stored procedure saving issue
 Login/Join
 
Gold member
posted
In the following stored procedure (the complete fex has several dialogue manager lines too which I did't include here) in data migrator. When I try to save it, I get the following error
FOC1517 - ON TABLE HOLD AS PUR_COSTCENTER FORMAT FOCUS INDEX COSTCENTER GRHAND GRSUNO PGPRFA PGPGRP
However, if I remove
LM17
LM18
LM19
LM20
LM21
LM22
LM23
LM24
from the TABLE FILE PURHOLD1, then it saves just fine. Can someone see whats wrong here? Thanks.



APP HOLD CACHE

DEFINE FILE PURHOLD1
PRIORYRMTD_VAL/P17.2C=IF (GRPERI EQ '&PREVYRMONTH') AND (GRRDAT LE &YEARM1&MONTHDAY) THEN GRAMSY ELSE 0;
PRIORYTD_VAL/P17.2C=IF (GRPERI GE '&BEGINPREVYRMONTH') AND (GRRDAT LE &YEARM1&MONTHDAY) THEN GRAMSY ELSE 0;
CURRENTYRMTD_VAL/P17.2C=IF (GRPERI EQ '&CURRYRMONTH') AND (GRRDAT LE &YYMD) THEN GRAMSY ELSE 0;
CURRENTYTD_VAL/P17.2C=IF (GRPERI GE '&BEGINCURRYRMONTH') AND (GRRDAT LE &YYMD) THEN GRAMSY ELSE 0;

LM1/P17.2C=IF GRPERI EQ '&MP1' THEN GRAMSY ELSE 0;
LM2/P17.2C=IF GRPERI EQ '&MP2' THEN GRAMSY ELSE 0;
LM3/P17.2C=IF GRPERI EQ '&MP3' THEN GRAMSY ELSE 0;
LM4/P17.2C=IF GRPERI EQ '&MP4' THEN GRAMSY ELSE 0;
LM5/P17.2C=IF GRPERI EQ '&MP5' THEN GRAMSY ELSE 0;
LM6/P17.2C=IF GRPERI EQ '&MP6' THEN GRAMSY ELSE 0;
LM7/P17.2C=IF GRPERI EQ '&MP7' THEN GRAMSY ELSE 0;
LM8/P17.2C=IF GRPERI EQ '&MP8' THEN GRAMSY ELSE 0;
LM9/P17.2C=IF GRPERI EQ '&MP9' THEN GRAMSY ELSE 0;
LM10/P17.2C=IF GRPERI EQ '&MP10' THEN GRAMSY ELSE 0;
LM11/P17.2C=IF GRPERI EQ '&MP12' THEN GRAMSY ELSE 0;
LM12/P17.2C=IF GRPERI EQ '&MP13' THEN GRAMSY ELSE 0;
LM13/P17.2C=IF GRPERI EQ '&MP14' THEN GRAMSY ELSE 0;
LM14/P17.2C=IF GRPERI EQ '&MP15' THEN GRAMSY ELSE 0;
LM15/P17.2C=IF GRPERI EQ '&MP16' THEN GRAMSY ELSE 0;
LM16/P17.2C=IF GRPERI EQ '&MP17' THEN GRAMSY ELSE 0;
LM17/P17.2C=IF GRPERI EQ '&MP18' THEN GRAMSY ELSE 0;
LM18/P17.2C=IF GRPERI EQ '&MP19' THEN GRAMSY ELSE 0;
LM19/P17.2C=IF GRPERI EQ '&MP20' THEN GRAMSY ELSE 0;
LM20/P17.2C=IF GRPERI EQ '&MP21' THEN GRAMSY ELSE 0;
LM21/P17.2C=IF GRPERI EQ '&MP22' THEN GRAMSY ELSE 0;
LM22/P17.2C=IF GRPERI EQ '&MP23' THEN GRAMSY ELSE 0;
LM23/P17.2C=IF GRPERI EQ '&MP24' THEN GRAMSY ELSE 0;
LM24/P17.2C=IF GRPERI EQ '&MP25' THEN GRAMSY ELSE 0;
END
-RUN

TABLE FILE PURHOLD1
SUM
PRIORYRMTD_VAL
CURRENTYRMTD_VAL
PRIORYTD_VAL
CURRENTYTD_VAL
LM1
LM2
LM3
LM4
LM5
LM6
LM7
LM8
LM9
LM10
LM11
LM12
LM13
LM14
LM15
LM16
LM17
LM18
LM19
LM20
LM21
LM22
LM23
LM24
MAX.NANAME
BY REGION
BY COSTCENTER
BY GRHAND
BY GRSUNO
BY PGPRFA
BY PGPGRP
ON TABLE HOLD AS PUR_COSTCENTER FORMAT FOCUS INDEX COSTCENTER GRHAND GRSUNO PGPRFA PGPGRP
END
-EXIT


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I'm afraid this may take some digging on your part.

Where you say you are having problems "saving" this.... do you mean just clicking on the save icon, or do you mean save and execute?

The error you got - FOC1517 - there should have been more with that. You should have seen something like "(FOC1517) UNRECOGNIZED COMMAND" and more info after that. Was the info after that your "ON TABLE HOLD AS PUR_COSTCENTER FORMAT FOCUS INDEX COSTCENTER GRHAND GRSUNO PGPRFA PGPGRP"? If not, what was it?

If you don't have -SET &ECHO=ALL at the top of your fex, I would recommend adding it so you can see what is happening with all the code and all the dialogue manager commands.

You say you removed LM17 to LM24 and it worked. Did you already determine that it had to be all 8 of them? If not, can you, by process of elimination, find out exactly which field(s) are causing the issue?

What are the values of the variables (&MP18, &MP19, etc)? Are they as you expected them to be?

Hopefully, this will help uncover the issue.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Reply With QuoteReport This Post
Gold member
posted Hide Post
Thanks for the input, Jessica. The fex does execute without problem and creates the app hold file, however, when I try to save it I get the following error.

11/18/2010 09:49:24 EDASERVE (FOC1517) UNRECOGNIZED COMMAND BY PGPGRP
11/18/2010 09:49:24 EDASERVE (FOC1517) UNRECOGNIZED COMMAND ON TABLE HOLD AS PUR_COSTCENTER FORMAT FOCUS
11/18/2010 09:49:24 EDASERVE INDEX COSTCENTER GRHAND GRSUNO PGPRFA PGPGRP
11/18/2010 09:49:24 EDASERVE (FOC1517) UNRECOGNIZED COMMAND -EXIT
11/18/2010 09:49:24 EDASERVE Failed to save "EDASERVE:dev_cm/pur_costcenter.fex"


When I remove lines LM21 - LM24, I get the following error (note: Its a little different than the earlier error with the whole fex)

11/18/2010 09:52:59 EDASERVE (FOC1517) UNRECOGNIZED COMMAND ON TABLE HOLD AS PUR_COSTCENTER FORMAT FOCUS
11/18/2010 09:52:59 EDASERVE INDEX COSTCENTER GRHAND GRSUNO PGPRFA PGPGRP
11/18/2010 09:52:59 EDASERVE (FOC1517) UNRECOGNIZED COMMAND -EXIT
11/18/2010 09:52:59 EDASERVE Failed to save "EDASERVE:dev_cm/pur_costcenter.fex"

When I remove the lines LM19 - LM24, I get the following error
11/18/2010 09:54:36 EDASERVE (FOC1517) UNRECOGNIZED COMMAND -EXIT
11/18/2010 09:54:36 EDASERVE Failed to save "EDASERVE:dev_cm/pur_costcenter.fex"

Now, here if I remove the '-EXIT' line then the fex saves line. Also, what I did was from here I started adding back the lines LM19-LM24, one by one, and saving it and ended up adding and saving all lines. But out of curiousity, I replaced the original fex with a saved copy, removed the -EXIT line and tried to save it but again got the error reported above.
I think I would need to open up a case with IBI as I don't understand this behavior.


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Change your HOLD AS PUR_COSTCENTER to a max 12 byte name:

HOLD AS PUR_CST_CNTR

If that doesn't work, use a max of 8 bytes...

hth


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1937 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Where you say "Also, what I did was from here I started adding back the lines LM19-LM24, one by one, and saving it and ended up adding and saving all lines.".... if I'm following you, this means you had a complete fex that works okay and saved okay, right? Can you do that again, but then take the saved copy and put that into another fex, then compare the two fexes? If they are identical, then I agree, you should open a case with IBI. Even if they are not identical, I think you should still open a case with IBI because I can think of no good reason for the "save" to fail like this. Even if Tom is right and the hold file name is too long, that should error during execution and not while trying to save the fex.


Data Migrator 5.3, 7.1, 7.6
WebFOCUS 7.1, 7.6, 7.7
SQL Server, Oracle, DB2
Windows
 
Posts: 126 | Registered: January 18, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Jess is right, I didn't read that it worked and you couldn't save. Probably the DM commands, but, maybe not.

Follow Jessica's advice...

Tom

P.S. Hey Jessica, hope all is well with you! Happy Thanksgiving!


Tom Flynn
WebFOCUS 7.7.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1937 | Location: Parker, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
I did try shortening the length of hold file names but still didn't work.
Jessica, you correctly understood what I did. I was able to save the whole fex but only by adding one line, saving, adding next line, saving, and so on until I completely saved the fex but when I copy and paste the whole thing and try to save it, it gives an error. I opened a case yesterday. Will update once I get this resolved.


WebFOCUS 7.6.10
Windows
all output (Excel, HTML, PDF)
 
Posts: 69 | Registered: March 11, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Data Migrator - Stored procedure saving issue

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.