Focal Point
Possible Resync issue with WF768

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/18610374

March 17, 2009, 07:26 AM
Clinton Side-Kick
Possible Resync issue with WF768
Has anyone else experienced the following error after changing datamart and loging in as pmfadmin:
The Resync gadget experiences an "Unknown error occured. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log" while attempting to check the sync status (this is prior to the point where you are given the option to ReSync).
I have tried to debug and it seems the point of failure is where the pmf_rdbms_get.fex sets the &APPPATH variable to USERPATH(256,'A256');

There is nothing wrong with PMF, it seems that WF768 has a problem with the USERPATH function.

I'm stumped at this point as I would like to swap between the pmf_manufacturing and pmf_it datamarts and PMF is unable to resync.

Any ideas?


--------------------------------------------------------------------------------
prod: WF/AS 8.2.05; OmniGen;
In FOCUS since 1991
March 17, 2009, 10:51 AM
Bob Jude Ferrante
Yes, confirmed, in WebFOCUS 7.6.8, if the PATH variable returned contains more than 134 characters, it crashes the WebFOCUS server.

A workaround was added to V5.1.2 (now generally available) for this server issue. If you don't want to upgrade you must remove the USERPATH function from the resync code and hard code the resulting var. I believe it's defaulted to SQLMSS so if you are using SQL Server as your mart, you can just comment out the line that calls the USERPATH function.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

March 17, 2009, 05:20 PM
Clinton Side-Kick
Thx Bob,

I had to bypass the block of code that eventually sets the &THIS_RDBMS parm to SQLMSS.

Saved me having to upgrade to 512 for the time being on the demo image...


--------------------------------------------------------------------------------
prod: WF/AS 8.2.05; OmniGen;
In FOCUS since 1991