Error in CommData.loadData line 4135, in loadData

Follow me down the rabbit hole as I dig into the inner workings of FDMEE to resolve a somewhat cryptic error message.

FDMEE

What about plus signs in FDMEE Load Rules!?

When executing FDMEE load rules via batch keep the pluses in the rule names if you want. With this technique they can still be executed run.

FDMEE

Spaces in FDMEE Load Rules? No Problem!

Stop replacing spaces with hyphens and underscores in you FDMEE load rules. Load rules with spaces in the name can be run via batch with this technique.

ORA-01400: cannot insert NULL into ("FDMEE"."TDATASEG_T"."DATAKEY")

Behind the scenes FDMEE inserts values into DATAKEY but sometimes things can get a little messed up. Fixing this issue is generally quick and simple.

Jython

Accessing ODI Physical Schema via FDMEE

Story time! Recently I was migrating FDMEE from 11.1.2.3 to 11.1.2.4 at a client that has extensive scripting in FDMEE. Lot's of neat stuff going on here. One of the things they were doing was accessing the ODI physical schema to obtain the login

ODI

Planning Integration with the FDMEE Built-In Agent

When using the FDMEE integrated agent resolving the "java.lang.NoSuchMethodError: com.hyperion.planning.HspHALBean.endLoad()" error message may require adding HspJS.jar to the classpath...

EPM

Resetting Admin Passwords

Reset a lost Oracle EPM admin password with a little SQL.

FDMEE

When mappings fail migration

Some less common issues that may prevent FDMEE mappings from migrating between environments.

FDMEE

FDMEE Parallelism Gone Wild? Rein it in with custom throttling!

If you're like me, you've noticed (perhaps despairingly) that FDMEE settings can be a bit extreme. You need to tightly control the order and concurrency of your data loads? Sequential to the rescue! Oh wait now, you need to allow multiple loads to process at the same time? Parallel to

EPM

FrankenHyperion (Ubuntu, SQL Server for Linux and Nginx)

If you read my last post you know I ran into some problems at the end. Not related to SQL Server but related to how OHS (Oracle HTTP Server aka. Oracles version of Apache) plays with Ubuntu. For whatever reason I was not able to get OHS to install correctly

EPM

EPM 11.1.2.4 and SQL Server on Ubuntu

Today we try something different. I have a stock Ubuntu installation in Hyper-V. Microsoft has released SQL Server for Linux, I think SQL Server for Linux is a Release Candidate (RC), which we over at Tevpro have been using with some .NET Core applications. Lastly, I need a VM of

Beard

Kscope 17 Recap - Day 3

I have got to start getting to sleep earlier but I have been having too much fun meeting with people. So yea I missed the first round of sessions but honestly, it was a conscious decision, nothing looked very interesting to me. So the first session for me is "

Kscope

Kscope 17 Recap - Day 2

I started the day by following Cameron into the Essbase Development session, I was running a bit late, and had a few takeaways. Essbase Studio is not supported on 12c Java and REST API will continue to be supported EAS will not be available in 12c IDCS will be the

Jython

Splitting multi-period into single period load files

When loading data into Oracle EPM applications the tool of choice is Financial Data Quality Management Enterprise Edition (FDMEE). Dating back to Classic FDM it has been possible to load either by single period or multi-period. In Classic FDM there was a performance penalty associated with processing multi-period files. The

Groovy

Kscope 17 Recap - Day 1

Fun times out here in San Antonio, if you haven't been you definitely want to check out Kscope next year in Orlando. I haven't let the family know yet but something tells me the whole crew will be there. So things we learned yesterday: Big data has some really cool

DRM

Comparing Properties in DRM

Overview My client updates several hierarchies monthly using extracts from SAP (DRM is not currently the source of Master Data). One of the things updated with the hierarchies are the member descriptions. They have a requirement to move the existing description to another property when descriptions change. We then load

DRM

Creating DRM Properties that Inherit from Descendants

Overview To inherit is defined as "to receive or be left with (a situation, object, etc.) from a predecessor or former owner." DRM allows for property inheritance which works great for things like Account Types in planning applications or currencies on entities but, what happens when you need

Python

Extracting UDAs from the Outline

First, hope everyone had a wonderful holiday weekend. Now it's back to real life... I have been doing quite a bit with DRM for a while now and am currently migrating a Planning application to DRM. One of my most recent tasks was to load the UDA's into DRM. Now

Jython

Installing JunkieFramework in FDMEE

In a previous blog post we announced the release of the JunkieFramework (call it whatever you want). This post will focus on getting the framework installed and show some basic usage. Save Script The simplest way to load the framework is by grabbing the source file JunkieFramework.py. Then save

JunkieFramework

PEP 8 and Logging

Over the weekend I spent a little more time on the FDMEE framework, while implementing some new logging functionality I felt compelled to look into the Python Style Guide (PEP 8) and realized while my new logging code seemed to be in line with guide, our property names were not.

JunkieFramework

Its a collaboration not a dictatorship

Well we already have our first big change to the framework. As Justin was working with it he found the instance variables to be a pain point. Each use of a variable required it be wrapped in a to string function str(jf.variable). If the variable was not explicitly

FDMEE

Whats that you say an FDMEE Framework?

Lately Justin, Erik and I have been discussing FDMEE quite a bit. We recently realized that we were doing many of the same things however our implementations may differ. While chatting last Friday we decided to change that. So I would like to be the first to introduce the JunkieFramework.

ODI

JConsole to the Rescue

A few months back I ran into this error Java.lang.OutOfMemoryError: PermGen space while working on some ODI integrations. I pulled up a quick google search and found the second link of the list was stackoverflow bam problem resolved. Well that was in Development. Then couple weeks ago I

PyDev

Jython Debugging for ODI (revisited)

Over a year ago I wrote a two part (1, 2) post about ODI (Oracle Data Integrator) debugging using Eclipse. This post was meant to have at least one more part; somewhere along the way I gave up. It is not that is isn’t important, in fact I still

Jython

Installing Jython

Jython is the language that powers Oracle Data Integrator (ODI), it also is one of two options (Visual Basic (VB) is the other, it has been speculated the option for VB may disappear at some point in the future) for Financial Data Quality Management - Enterprise Edition (FDMEE). Jython is