Hi,

I'm trying to load a measure, but I keep getting the following error:
*** Database error. Could not update Measure information

In the edaprint I see the following:
12/04/2008 10:11:12 Pid=00002792 MntType: *********************************************************
12/04/2008 10:11:12 Pid=00002792 MntType: ******* Maintain Name: meas_loader_load.mnt
12/04/2008 10:11:12 Pid=00002792 MntType: *********************************************************
12/04/2008 10:11:12 Pid=00002792 MntType: CASE: TOP
12/04/2008 10:11:12 Pid=00002792 MntType: zMEASURE_SERIES: 3
12/04/2008 10:11:12 Pid=00002792 MntType: CASE: getMeasure_Source_LoadParm
12/04/2008 10:11:12 Pid=00002792 MntType: CASE: getExistingMeasureSeriesInfo
12/04/2008 10:11:12 Pid=00002792 MntType: CASE: load_measures_fetch
12/04/2008 10:11:12 Pid=00002792 MntType: zMEASURE_SERIES: 3
12/04/2008 10:11:12 Pid=00002792 MntType: About to exec meas_loader
12/04/2008 10:11:12 accepting cmrpip000117 tcp=127.0.0.1:1667
12/04/2008 10:11:12 request by cmrpip000117 from edaapi for iwa connect to agent (DEFAULT)
12/04/2008 10:11:12 connecting cmrpip000117 tscomid=2,sesid=117
12/04/2008 10:11:12 processing cmrpip000117 u=dupreezj,l=SRV
12/04/2008 10:11:15 request by t3rp2808 to notify disconnect of sesid=117
12/04/2008 10:11:15 disconnect cmrpip000117 tscomid=2,sesid=117
12/04/2008 10:11:15 Pid=00002792 MntType: Just exec'd meas_loader
12/04/2008 10:11:15 Pid=00002792 MntType: Return code from meas_loader_load: 0
12/04/2008 10:11:15 Pid=00002792 MntType: stk_Measures_toLoad.foccount: 6
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: load_measures_error_check
12/04/2008 10:11:15 Pid=00002792 MntType: stk_Measures_Errors.foccount: 0
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: PPMF_delete
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: load_measures_delete
12/04/2008 10:11:15 Pid=00002792 MntType: zDelete_if_not_New: N,zMEAS_LOAD_TYPE: B
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: load_measures_insert
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: load_measures_update
12/04/2008 10:11:15 Pid=00002792 MntType: zMEAS_LOAD_TYPE: B
12/04/2008 10:11:15 Pid=00002792 MntType: 1
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: error_handler
12/04/2008 10:11:15 Pid=00002792 MntType: ***** PROGRAM ERROR *****
12/04/2008 10:11:15 Pid=00002792 MntType: ******CASE load_measures_update#3. FocError: 1 DBMS
12/04/2008 10:11:15 > error: 0 zMEASURE_SERIES: 3 Measure_ID: 12912
12/04/2008 10:11:15 Pid=00002792 MntType: CASE: display_results
12/04/2008 10:11:15 Pid=00002792 MntType: batch_mode:N
12/04/2008 10:11:15 Pid=00002792 MntType: *******MEAS_LOADER_RETURN_FORM, ResultMsg:*** Database
12/04/2008 10:11:15 > error. Could not update Measure informationzWizardMode:
12/04/2008 10:11:15 request by t3rp2792 to notify disconnect of sesid=116
12/04/2008 10:11:15 disconnect cmrpip000116 tscomid=1,sesid=116
12/04/2008 10:11:19 accepting cmrpht000013 tcp=127.0.0.1:1669
12/04/2008 10:11:19 request by cmrpht000013 to exec u=dupreezj, wsesid=2

If I do a full refresh I don't get the error but Add new, replace actual/target produces the error.

Any advise will be appreciated.

WebFOCUS 7.6.5
Windows XP service pack 2

Hi Wihan,
What version of PMF are you currently on?
Kind regards,
C

hi Clinton,


pmf 4.5b

Hi Wihan--
We noticed you're looking in the Reporting Server log for help. This log won't give the same amount of debugging support as the interative loader in PMF will, so here's how to do it.

Best way to debug a measure load - and we say 'debug' because you're analyzing your own data structure and how your specific load logic is set up, you're not debugging PMF - is to run it interatively in the measure loader.

First, make sure you have data access. Bring up the measure in the loader, and click Sample Data. Make sure you get a return. If you don't it means your data adapter is not set up right, or your master file and access file in WebFOCUS against that data source need to be changed. Perhaps the database was moved, perhaps the structure of the source data table changed, etc. The problem in this case is lower down in the environment, and PMF gets the data via the environment.

Second, click Load and you should see an error message - it usually is green and red. (No holday jokes please). Right-click it and select View Source in your browser, and have a look at the ending part of the trace. The WebFOCUS error message that's actually causing the load issue will be there. This will help you track down the source of the error. Perhaps there was a subtle change to the format of a field in the source data, so that it comes up OK but it's not in the right format inbound. Or perhaps there is a newly-introduced error because someone changed the field mapping at some point for your measure load.

Good luck.

thanks