Hi,
I’m very happy with the DEPM-Mappings to load dimensions or cubes, they are extremely fast. Great.
However, I’m missing an important thing and that is the control of the status of executed mappings when called from an APE-Process.
I could not find a way to track the success or failure of a mapping, but this is key because the calling process must know whether the mapping succeeded or not.
I’m trying this:
string errorMessage = "";
int errorCode = 0;
NotifyInformation("Start_Mapping "+mappingName);
try {
ModelingExecuteHierarchyMapping(applicationName, mappingName);
}
catch (errorMessage, errorCode) {
NotifyError("Fehler: "+errorMessage + " Code: "+ToString(errorCode));
}
NotifyInformation("Fertig");
Application and mapping are passed as parameters to the process.
I tested with two mappings one that succeeds and the other one fails because a table does not exist.
However, both calls of ModelingExecuteHierarchyMapping seemed to be successful because the catch is never executed.
When checking the mappings in DEPM/Admin, I’ll find the errors (see attached screenshot)
So “somewhere” this information about failure and error messages is stored and I found them here in the LOG_ENTRY Table (see attached screenshot)
But in the LOG_ENTRY there are all logs of the past and it seems to be hard to find out the “correct” log entries that belong the executed mapping above.
So the challenge is:
Where and how can I retrieve the log entries for the executed mapping in APE?
Before I try and error maybe someone knows best practice here.
Or is this is on the short-term V12 roadmap and there will be a standardized way to get this status information?
If ModelingExecuteHierarchyMapping returned an integer value or true/false instead of being void, that would help a lot
Thanks in advance
Ralf
[View:/cfs-file/__key/communityserver-discussions-components-files/545/6114.Screenshots.pdf:320:240]
