March 17, 2009, 07:26 AM
Clinton Side-KickPossible 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?
March 17, 2009, 10:51 AM
Bob Jude FerranteYes, 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
March 17, 2009, 05:20 PM
Clinton Side-KickThx 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...