Focal Point
Error S01_A in filters - Error S01_B_CG in pmf_cookie_getvars

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

July 22, 2009, 09:30 AM
SethW
Error S01_A in filters - Error S01_B_CG in pmf_cookie_getvars
Just an FYI -- if anyone is able to login to PMF but the today page displays:


PMF Error


An error occurred during processing:
Error S01_A in filters - Error S01_B_CG in pmf_cookie_getvars, FOCERRNUM: 1406 LINES: 0
Please contact your PMF Administrator


____________

it means that the connection to your database is down. Or that the database is offline.


WF 7.65. Solaris. PMF 5.11 on Oracle 10g
July 23, 2009, 06:20 AM
Bob Jude Ferrante
We'll work to give you a better error message. This one is not informative enough. Thanks Seth!


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!

February 07, 2012, 11:49 AM
kncoi
The same error number 1406, but with a "better error message":

An error occurred during processing:
Error S07_B in pmf_resynch - Error S02_B in pmf_rdbms_check_database. Database/MFD inconsistency for table: PM_DIM01_DISPLAY, FOCERRNUM: 1406
Please contact your PMF Administrator

This happens during a database / metadata sync. (after a db switch). This does not appear to be a disconnection to the db, but rather a mischatch of some sort. How can this be fixed?


WebFocus 8.1.03
PMF 8.0.5
Windows Server 2012
Windows 7
html
February 07, 2012, 12:04 PM
Bob Jude Ferrante
This is a problem with an inconsistency in the Time DImension (DIM01). My guess is you are switching between a database with custom time configured and one with 3-level Time autogen and resync is getting confused.

We recommend you contact customer support. If you can take snapshots of the two DBs, that would make it simpler to figure out how to advise you further.


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!

February 10, 2012, 02:22 PM
kncoi
Bob, my problem has been resolved. Thank you for the quick reply and the very useful information. I was able to synchronize the database and its metadata by duplicating the app files that supported the switched db. Restarting the report server would then reconnect/resync them without further issue.


WebFocus 8.1.03
PMF 8.0.5
Windows Server 2012
Windows 7
html