≡ Menu

PDF Preview fails in Workspace

Switching to PDF Preview in Workspace on a report generated by Financial Reporting fails with the message “Unable to process request.”

tested through PSU 11.1.2.2.305
Unable to process request occurs with some but not all FR reports.

steps

For each FR server, update to TRACE:32 the logging levels in

<MIDDLEWARE_HOME>\user_projects\domains\<DOMAIN>\config\fmwconfig\servers\FinancialReporting<x>\logging.xml

for three loggers:

<logger name=’oracle.EPMFR’ level=’TRACE:32′ useParentHandlers=’false’>
<handler name=’epmfr-handler’/>
</logger>
<logger name=’oracle.EPMFR.access’ level=’TRACE:32′ useParentHandlers=’false’>
<handler name=’epmfr.access-handler’/>
</logger>
<logger name=’oracle.EPMFR.jsp’ level=’TRACE:32′ useParentHandlers=’false’>
<handler name=’epmfr-handler-jsp’/>
</logger>

Restart the FR servers
Replicate the issue
Check these logs for details of the problem:

Generate
[continue reading…]

{ 0 comments }

TB v TiB

There is something annoying about plugging in six 4 TB hard drives and having only 3.68 TiB available.

When is a terabyte (TB) not a terabyte? It has been going on for years, and everyone accepts it as the way it is, but 91% of what was promised seems like less…than. Let’s have a name for it.

Ninety-one-Percenters

The 91%-ers over-promise and under-deliver.

The 91%-ers get you almost to where they  said they would.

Imagine going to the moon with these people. 34,596 km away and they are popping the “one small step for man” speech.

Mastery is required to differentiate from the 91%-ers.

Sometimes it seems 91% of total effort is required to pull a project to 100% or better.

 

{ 0 comments }

Dell PERC H700 does not recognize Seagate NAS HDD 4TB SATA 6GB NCQ 64 MB Cache Bare Drive ST4000VN000

tested through PERC H700 Adapter BIOS Configuration Utility 2.02-0025.1
5/19/2014
Update 5/25/2014: If the drive cage is properly seated in the backplane both Seagate NAS HDD 4TB SATA 6GB NCQ 64 MB Cache Bare Drive ST4000VN000 and Western Digital WD40EFRX 4 TB WD Red, 3.5 inch, SATA III 5400 RPM 64 MB Cache Bulk/OEM NAS Hard Drive 4TB NAS drives are recognized.

The PERC H700 controller from Dell™ is in the third generation of Dell SAS RAID Cards and provides support for SAS, SATA and SSD (specifically SATA SSDs) drives.

The drives that might work are $900 each (Dell 4 TB 7200 RPM Near Line Serial Attached SCSI Hard Drive for Select Dell Poweredge Servers / PowerVault Storage) or $319 each from Amazon (Dell – 4TB 7.2K 6Gb/s 3.5″ SAS HD -Mfg # DTK38 (Comes with drive and tray))

steps

None.

description

None at this time

external links

None at this time


{ 1 comment }

RDC updated

Remote Desktop Connection (RDC) 8.1 client update … lets you use the new Remote Desktop Services features. These features were introduced in Windows 8.1 and Windows Server 2012 R2, and they are now available for computers that are running Windows 7 Service Pack 1 (SP1).

{ 0 comments }

HFM Taskflows inaccessible to regular users

Access to HFM Taskflows is restricted to users provisioned for Consolidation Administration

tested through PSU 11.1.2.2.305
3/4/2014

The README for Patch 17740222: Patch Set Update: 11.1.2.2.306 for Oracle Hyperion Financial Management indicates Defect fixed in this patch (“17328388: The Consolidation Administration menu is not available for users with the Run Taskflows role.”) Testing to follow…

Oracle Enterprise Performance Management Documentation for 11.1.2.2 indicates on page 232

Run Taskflows – Permits users to only run and view taskflows. Users with this role cannot create new taskflows or edit existing taskflows

As implemented, the placement of the Taskflows interface within Consolidation Administration effectively blocks all but HFM administrators from viewing or managing Taskflows. Until the application design catches up with the documentation one would need to provide access to Taskflows via EPMA rather than HFM.

steps

If you would like assistance with Taskflows in HFM 11.1.2.2+ please let me know as I can help you with your HFM-Planning automation processes.

description

None at this time

external links

None at this time


{ 2 comments }

replication help message

net helpmsg 4006

{ 0 comments }

HFM 306 PSU now available

Release 11.1.2.2.306 Patch Set Update (PSU): 11.1.2.2.306 Readme

Nice job Oracle!

{ 0 comments }

FoundationServices Workspace could not resolve role

The EPM Foundation Services in Workspace 11.1.2.2.300.20 could not resolve role

native://DN=cn=HUB:23,ou=HUB,ou=Roles,dc=css,dc=hyperion,dc=com?ROLE

Examination of LCM export of all provisioning as well as Users, Groups and Roles indicates this role is not in Shared Services.

Oracle Support indicates:

There is no problem with the user provisioning. Everything is working correctly. In a future release we will address this so that no error message is logged.
This bug won’t not cause any functional problems.

steps

Error messages that repetitively appear in FoundationServices0, the Workspace.log, like:
[2013-08-16T20:51:47.921-04:00] [FoundationServices0] [ERROR] [01301] [oracle.bi.bifndnepm.workspace.security.RoleChecker] [tid: 14] [userId: ] [ecid: 123414233212341234123412340000e,0] [SRC_CLASS: com.oracle.workspace.security.RoleChecker] [APP: WORKSPACE#11.1.2.0] [SRC_METHOD: initializeRoleCache:187] Could not resolve role: native://DN=cn=HUB:23,ou=HUB,ou=Roles,dc=css,dc=hyperion,dc=com?ROLE

{ 0 comments }

Taskflows Add Link fails with 404 not found

symptoms

When creating a Taskflow in 11.1.2.2 Consolidation Administration, “Add Link” fails, and may open a 404 page not found. The Taskflow will not become visible in Workspace > Consolidation Administration. You will be unable to create Taskflows. You will likely be unable LCM Export or LCM Import Taskflows.

steps

The source of the issue is a missing library; The solution is to add commons-dbcp-1.2.2.jar (‘D:\Oracle\Middleware\EPMSystem11R1\common\JakartaCommons\commons-dbcp-1.2.2.jar;’) to the end of
HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\FoundationServices0\HyS9FoundationServices key in Windows Registry that starts with -Djava.class.path=
Restart the HSS Server after adding the reference to the class path.

[continue reading…]

{ 0 comments }

Taskflows scheduler fails in 11.1.2.2.305 with SOA

symptoms

In 11.1.2.2.305 verified on multiple client environments the scheduler in Taskflows does not work in an EPM installation that includes SOA. There are additional bugs to work through which will get written up as time permits. Furthermore, once the problem is identified using SQL Server trace files a solution creates downstream issues that are interesting to diagnose and resolve.

steps

The source of the issue is a conflict in the version of quartz used by HFM and FCM. An EPM system that includes SOA will create [D:\Oracle\Middleware\Oracle_SOA1\soa\modules\quartz-all-1.6.5.jar] in the Windows Registry FoundationServices classpath during installation.
Manually changing the value in -Djava.class.path [D:\Oracle\Middleware\Oracle_SOA1\soa\modules\quartz-all-1.6.5.jar] replacing it with [D:\Oracle\Middleware\EPMSystem11R1\common\SharedServices\11.1.2.0\lib\quartz.jar] Windows Registry for Foundation Services will cause deployed automated integrations to fail.
using script or starting from command line made no difference

After restart all SysInt*composites in SOA went to a conflicted state, started throwing null pointer exceptions and could not be undeployed, redeployed or retired. Cound not import any of the Integration Types that are automated via Workspace. These issues are related.
work through undeploy in Enterprise Manager, ignoring errors, for all SysInt* composites
Restart the EPMSystem (using the usual script)
Not all SysInt*composites had been removed, however, import HFM integration types succeeded. Null pointer errors in logs stopped.

The integration of so many EPM System products + SOA creates interesting challenges. This one is listed as an unpublished bug on Oracle Support.

{ 0 comments }