Here's how it croaks on the realmdriver trace.
I did all migrations through the supplier tools except that I copied the mrrealm repository tables and manually adjusted wf_mrdomains.domainname from 48 to 128.

[2007-08-21 11:04:31 BST] {ERROR} [WFMRX_MRRepositoryDriver] renameDomain:
EXCEPTION CLASS: ibi.webfoc.wfmre.mrutil.WFMRError
MESSAGE: 1016
STACK TRACE:
ibi.webfoc.wfmre.mrutil.WFMRError: 1016
at ibi.webfoc.wfmre.mrutil.WFMRUtil.htmlReplaceText(WFMRUtil.java:1601)
at ibi.webfoc.wfmre.mrio.WFMRFile.replaceTextInHtmlFile(WFMRFile.java:192)
at ibi.webfoc.wfmre.repos.htm_bd.WFMRFileRepositoryHandler.renameDomain(WFMRFileRepositoryHandler.java:859)
at ibi.webfoc.wfmre.repos.core_bd.WFMRRouterRepositoryHandler.renameDomain(WFMRRouterRepositoryHandler.java:169)
at ibi.uas.drivers.WFMRX_MRRepositoryDriver.renameDomain(WFMRX_MRRepositoryDriver.java:427)
at ibi.webfoc.wfmre.repos.WFMRRepositoryHandlerProxy.renameDomain(WFMRRepositoryHandlerProxy.java:449)
at ibi.webfoc.wfmre.mrobj.WFMRDomain.changeRecord(WFMRDomain.java:1481)
at ibi.webfoc.wfmre.mrobj.WFMRDomain.setProperties(WFMRDomain.java:1454)
at ibi.webfoc.wfmre.WFMRService.perform(WFMRService.java:1167)
at ibi.webfoc.WFRequestWorker.processRequest(WFRequestWorker.java:502)
at ibi.webfoc.WFWorkerUtil.processRequest(WFWorkerUtil.java:387)
at ibi.webfoc.WFServlet.processRequest(WFServlet.java:763)
at ibi.webfoc.WFServlet.doPost(WFServlet.java:728)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at ibi.srv.util.IBIHttpServlet.service(IBIHttpServlet.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at ibi.srv.util.IBIHttpServlet.service(IBIHttpServlet.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

Copying XFOCUS files from 7.1.3 to 7.6.2 results in a problem sometimes "FILE is protected by a different data administrator"

This may mean that you have to rebuild unload some XFOCUS files created under 7.1 and rebuild load it into 7.6.

There an undoc feature in 7.1.3 that does not get replicated


-* File temp.fex
-DEFAULTS &A = FOC_ALL
-SET &DUMMY = &A.(OR(A,B,C,D,E)).Enter choice. ;
-SET &DUMMY = &X;
-? &

If you select 2 to n-1 choices say A and B then you will get variables

IBI_A_MULTI0 = 2
IBI_A_MULTI1 = 'A'
IBI_A_MULTI2 = 'B'

This feature might have been handy if implemented regardless of the number of values entered ie rather like the way rexx used to do arrays.

Can't see how it could be done at site.wfs level either... Anyone know any better.

John,

Thanks very much for keeping us up to date on your 7.6.2 upgrade work.

It seems to me that you're doing the work that IBI should have done???

This will be a very valuable resource when I assist a client in upgrading - unfortunately, by that time, a new version will be out, with all its bugaboos!

I second that - we're looking to do our upgrade as soon as we get some time freed up and it certainly does help knowing the potential roadblocks.

John,

That first happend in 5.2.3 (I think) and was reported as a bug. It got "fixed" in 5.3.2 and has now, obviously, crept back in.

Gerry,

Any ideas on why this happens?

T

Because the left hand doesn't talk to the right (wrong) foot?

Here's another

You cannot match on a key field that has the missing=on attribute set when that value is initially INCLUDEd as a blank.

(Please do not say that key fields must not be MISSING=ON - there is no documented restriction in wf although a lot of rdbms'es stupidly enforce this condition)

The following code works in 7.1 but not in 7.6 where REJECTs occur.

DEFINE FILE CAR
 CAR_NAME    /A50 MISSING ON = ' ' ;
END
TABLE FILE CAR
SUM RETAIL_COST
BY CAR
BY CAR_NAME
-* will always hold CAR_NAME as missing regardless of HOLDMISS setting.
ON TABLE HOLD AS HOLD1 FORMAT XFOCUS
END
-RUN
TABLE FILE HOLD1
PRINT *
ON TABLE HOLD AS HOLD2 FORMAT ALPHA
END
-RUN
MODIFY FILE HOLD1
FIXFORM FROM HOLD2
MATCH CAR CAR_NAME
  ON NOMATCH REJECT
  ON MATCH UPDATE RETAIL_COST
DATA ON HOLD2
END
-EXIT

The workaround is when you do your

BY POTENTIAL_BLANK_FIELD
ON TABLE HOLD FORMAT XFOCUS

You must actually do

DEFINE FILE ...
POTENTIAL_BLANK_FIELD/A20 MISSING=OFF = POTENTIAL_BLANK_FIELD ;

BY POTENTIAL_BLANK_FIELD
ON TABLE HOLD FORMAT XFOCUS
ON TABLE SET HOLDMISS OFF

Have done some hunting on this

IB have changed a default from 7.1 setting to a new setting in 7.6 so watch out!

Look on p282 of this manual

quote:

The SET FIXFRMINPUT command enables you to specify how to handle FIXFORM input
fields as either conditional (field/format C) or non-conditional fields. Thus, spaces in a
transaction field can be used for updating database fields.
Syntax: How to Control Whether FIXFORM Input Fields Are Conditional
SET FIXFRMINPUT = {COND|NONCOND}
where:
COND
Treats all transaction fields generated by FIXFORM FROM mastername as conditional
(format C) fields. COND is the default value.
NONCOND
Treats all transaction fields as present in the transaction, and their contents are
treated as real values.
Note that if you have not changed the value of the FIXFRMINPUT parameter and you query
its value, the value displays as DEFAULT.
Reference: Usage Notes for SET FIXFRMINPUT
❏ The FIXFRMINPUT setting does not affect a FIXFORM command that does not have a
FROM phrase.
❏ If you run a compiled MODIFY, its behavior reflects the FIXFRMINPUT setting at the
time it was compiled, even if a different setting is in effect at run time.

Just checked and these are SET defaults that change 7.1 to 7.6

AGGRRATIO 0 - 1
FIXFRMINPUT NONCOND - COND(SHOWS AS DEFAULT)
SMARTMODE ???? - OFF
WEBHOME Blank - OFF
XFBINS 16 (active) - 64 (active)

Report assistant - when displaying a DKU segment will use the CRSEGNAME instead of the SEGNAME.

eg. SEG01 is displayed instead of the more explicit PROJECT_EXTENDED

This is a bug because the CRSEGNAME may not be unique (whereas the SEGNAME is) and the user will be confused.

$=======================================================================================================
$ Project extended details
$=======================================================================================================
SEGNAME=PROJECT_EXTENDED, SEGTYPE=DKU, PARENT=PROJECT, CRFILE=NEW_PROJECT, CRSEGNAME=SEG01, CRKEY=PRJ_PROJECT_ID,$

Amperautoprompting formerly removed leading blanks from strings in FIND type lists.

It no longer does this preserving the number of blanks.

Dev studios physical view advanced graph icon does not work putting you into the ordinary painter.

Only way to open advanced graph is through New Procedure Dialog (sim to the PDF layout painter being only available from there)

PDF Layout that worked in 7.1.3 causes agent crash in 7.6.2

I solved the problem by importing the old pdf layout into the PDF layout tool and making a small change so the PDF tool would update the code.

I would appreciate if anyone could explain what the new stuff means

new

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=A4, $
PAGELAYOUT=1, NAME='Layout page 1', text='Layout page 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='0^0.5^0^0.5', $

old

COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=A4, $
pagelayout=1, name='Layout page 1', $

I think everyone is going to be having to do a bit of this on going to 7.6...

You can no longer append the results of a HOLD file onto itself:

TABLE FILE xyz

ON TABLE HOLD AS RESULTS FORMAT ALPHA
END
-RUN
FILEDEF RESULTS DISK RESULTS.FTM (APPEND
TABLE FILE RESULTS
...
ON TABLE SAVE AS RESULTS FORMAT ALPHA
END

Tried setting AUTOTABLEF=OFF but in the end the only thing would work is:

TABLE FILE xyz

ON TABLE HOLD AS RESULTS FORMAT ALPHA
END
-RUN
COPY RESULTS.FTM RESULTS1.FTM
COPY RESULTS.MAS RESULTS1.MAS

FILEDEF RESULTS DISK RESULTS1.FTM (APPEND
TABLE FILE RESULTS
...
ON TABLE SAVE AS RESULTS1 FORMAT ALPHA
END

There seem to be differences in the results displayed by the old PDF layout command and the new.

Compound docs that are tightly spaced will generally need recoding...

John,

Regarding the FILEDEF (APPEND, I think the real problem is that this occurs with any FILDEF (APPEND and not just a recursive one. Basically the function no longer works as in previous releases.

A quick test against the CAR file shows the problem -

TABLE FILE CAR
SUM RCOST
    DCOST
 BY COUNTRY
 BY CAR
 BY MODEL
ON TABLE HOLD AS TEMPCAR FORMAT ALPHA
END
-RUN
FILEDEF TEMPCAR DISK TEMPCAR.FTM (APPEND
-RUN
TABLE FILE CAR
SUM RCOST
    DCOST
 BY COUNTRY
 BY CAR
 BY MODEL
ON TABLE SAVE AS TEMPCAR FORMAT ALPHA
END
-RUN
TABLE FILE TEMPCAR
PRINT *
END
-RUN

The final report should show 36 records (and does in 7.1.3) but only shows 18 in 7.6.2.

I raised a case with IB (32402513) if any of you wish to reference it.

Keep smiling

T

The SET COMPOUND= command does not work for PDF and EXL2K and also interferes with HOLD FORMAT HTMTABLE.

Have now changed opinion on this:

The SET COMPOUND= command MAY not work for PDF and EXL2K and also interferes with HOLD FORMAT HTMTABLE.

On observation:

SET COMPOUND= works in some places and ON TABLE PCHOLD FORMAT PDF [OPEN | OPEN NOBREAK | NOBREAK | CLOSE ] does n't and vice versa!

So if it does not work in 7.6.2 try swapping them round...



This

SET COMPOUND=OPEN NOBREAK
TABLE FILE ...


ON TABLE PCHOLD FORMAT PDF
END
-RUN
SET COMPOUND=CLOSE
TABLE FILE ...


ON TABLE PCHOLD FORMAT PDF
END
-RUN

Needs to be replaced with

TABLE FILE ...


ON TABLE PCHOLD FORMAT PDF OPEN NOBREAK

END
-RUN
TABLE FILE ...


ON TABLE PCHOLD FORMAT PDF CLOSE
END
-RUN

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

PDF Layout Painter

1. Changing the grid to 5x5 pixels with layout loaded completely crashed dev studio out to windows (painter refs memory not owned by it).

2. When you select an item and try to move it, the item jerks downward a small amount from its original position.

MR Admin URL changed from ending in mradmin to mradmin-login?

In 7.6.1 if you edit an HTML in the text editor...in MRE only .and hit the save button...when you exit the HTML it does not save the changes. You have to X out and when it prompts for 'Do you want to Save changes'..and save - it then saves them. Very annoying. Works fine in Self Service. Was wondering if the same behavior was in 7.6.2...and a more important question...How did this behavior show up with " Code Tightening

Prarie,

That rings a bell from 5.n.something (5.2.3? I think). Basically you could perform an edit and the disk icon would still show greyed out (non selectable) and no asterisk beside the fex title.

In 7.1.3 you can open a fex up in text editor (state A), make changes and save (state B), then run the changed fex to test. If you then undo all the changes back to the original state of the fex (state A), the disk icon is greyed out, saving via alt f - s doesn't save the fex at current state (state A) and if you close and reopen you will find the fex has the changes you made (state B) which is OK as you didn't (couldn't!!) save back to the original state (state A).

The wall next to my desk now has an imprint of my head

T

I have the wall pictured.

That wall, that picture: http://flickr.com/photos/designwallah/295079472/

An update on the FILEDEF (APPEND problem -

quote:

The same problem is reported in Hottrack 30922505
Status:
This issue has been fixed in version 763 GEN 219.

So who picks up the costs of having to upgrade again eh?

T

F - Nothing like the shape of my head

Is 7.6.3 out?

Search for 31832548 in InfoResponse

Is there such a thing as "last stable version"?

I was wanting to upgrade to 7.62, but I think I'll wait. I have seen at least 6 issues here that would severely impact what we do.

Didn't we do a poll a while back, and one of the items was getting the core FOCUS language stable?

Amper autoprompt inserts blank for null string
Your IBI Case#32412520 internal: 000141658

This illustrates the prob nb you must have IBIF_wfdescribe to XMLRUN or XMLPROMPT at the client console to enable autoprompting

-SET &DUMMY = &X.Dummy. ;
-DEFAULT COUNTRY=''
-SET &DUMMY = &COUNTRY.Please Enter Country. ;
TABLE FILE CAR 
PRINT SEG.CAR 
IF COUNTRY EQ '&COUNTRY'
END

Under 7.1.3 the cursor was hard left in the generated textbox. Under 7.6.1 there is a leading space.

If the user thinks he has entered 'XXX' he will have entered ' XXX'. This will mean that selection criteria will fail.

The workaround is to not code the null default and no leading spaces were supplied. Ironically the nulls were only coded in 7.1 because if you didn't then you got leading spaces.

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