Thursday, July 23, 2009

OBIEE 10.1.3.4.1 - Catalog path containing "."

I was just testing multiple web catalogs when I realized that it's a bad idea to put version numbers into the web catalog name.

As an example, I have my web catalog "samplesales_paint_v1.3" sitting ready in OracleBIData\web\catalog and my instanceconfig.xml looking like this:

< ?xml version="1.0" encoding="utf-8"?>
< WebConfig>
< ServerInstance>
< DSN>AnalyticsWeb
< CatalogPath>F:\OracleBIData\web\catalog\samplesales_paint_v1.3

Starting up the server will not load the refrenced catalog, but rather create a new one from scratch: "samplesales_paint_v1"



And the Oracle BI Presentation Services Administration duly notes:

Physical Presentation Catalog Path \\?\F:\OracleBIData\web\catalog\samplesales_paint_v1\root

The sawlog0.log reads as follows:

Type: Error
Severity: 40
Time: Wed Jul 21 23:46:36 2009
File: project/webcatalog/localwebcatalog.cpp Line: 1507
Properties: ThreadID-4328
Location:
saw.catalog.local.loadCatalog
saw.webextensionbase.init
saw.sawserver
saw.sawserver.initializesawserver
saw.threads

Could not load catalog F:\OracleBIData\web\catalog\samplesales_paint_v1.3. Either it does not exist or insufficient permissions.
---------------------------------------
Type: Warning
Severity: 40
Time: Wed Jul 21 23:46:36 2009
File: project/websubsystems/httpserverinit.cpp Line: 49
Properties: ThreadID-4328
Location:
saw.catalog.local.loadCatalog
saw.webextensionbase.init
saw.sawserver
saw.sawserver.initializesawserver
saw.threads

Creating Catalog F:\OracleBIData\web\catalog\samplesales_paint_v1.3.
---------------------------------------

The log is incorrect on both accounts. "F:\OracleBIData\web\catalog\samplesales_paint_v1.3" does exist and the folder creation in the warning message may use the correct naming but actually creates folder "F:\OracleBIData\web\catalog\samplesales_paint_v1".

XML normally accepts "." inside the element content so I guess this is a legacy fragment from Siebel Analytics versions where the web catalog was a .webcat file. Why? Well, using this element:

< CatalogPath>F:\OracleBIData\web\catalog\paint.webcat

starts my "paint" folder ;-)



Any comments on this are welcome.

Cheers,
Christi@n

No comments:

Post a Comment