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)
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 22, 2007, 04:47 AM
hammo1j
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.
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 22, 2007, 10:20 AM
hammo1j
There an undoc feature in 7.1.3 that does not get replicated
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.
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 22, 2007, 11:07 AM
Francis Mariani
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!
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 22, 2007, 11:55 AM
RickW
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.
WebFOCUS 7.6.6/TomCat/Win2003,SQL Server 2005,Oracle
August 22, 2007, 12:01 PM
Tony A
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
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
August 22, 2007, 12:08 PM
Francis Mariani
Because the left hand doesn't talk to the right (wrong) foot?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 23, 2007, 01:20 PM
hammo1j
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
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.
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 23, 2007, 02:23 PM
hammo1j
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)
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 24, 2007, 09:55 AM
hammo1j
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.
I think everyone is going to be having to do a bit of this on going to 7.6...
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 25, 2007, 12:11 PM
hammo1j
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
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 25, 2007, 12:40 PM
hammo1j
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...
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 28, 2007, 05:31 AM
Tony A
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
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
August 28, 2007, 07:57 AM
hammo1j
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,
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 28, 2007, 08:57 AM
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.
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 28, 2007, 09:07 AM
hammo1j
MR Admin URL changed from ending in mradmin to mradmin-login?
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 28, 2007, 09:15 AM
Prarie
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
In Focus since 1993. WebFOCUS 7.7.03 Win 2003
August 28, 2007, 09:54 AM
Tony A
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
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 29, 2007, 09:40 AM
jgelona
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?
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
August 29, 2007, 09:44 AM
hammo1j
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,
Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2 Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo