Using ModelingOperationResult

Hi,

I'm trying to check the result of the ModelingExecuteHierarchyMapping function in APE but I'm struggeling....

I'm calling the function with a mapping, that does not exist using this code:

#define EngineVersion 5.0
#define RuntimeVersion 5.0

bool TEST()
@Description: "Mappings";
@Returns: "true";
{
string mm_line = "";
int mm_index = 0;

ModelingOperationResult map_result = ModelingExecuteHierarchyMapping("Logistik", "Unknown_Mapping_Name");

StringList mapping_message = ModelingOperationResultGetMessages(map_result);

// Check if successful
if (ModelingOperationResultIsSuccess(map_result))
{
NotifyInformation("Mapping successful");
}
else
{
NotifyInformation("Mapping not successful");

int mm_count = Count(mapping_message);

while (mm_index < mm_count) {

mm_line = GetElementByIndex(mapping_message, mm_index);
WriteLine (mm_line);

mm_index = mm_index + 1;

}
}

return true;
}

When running the process in APE-Editor the console window shows the expected error message:

Execute Process: TEST
Executing the process failed with an error. The returned message was: An error has occurred:
Calling function 'ModelingExecuteHierarchyMapping' failed with this message: Modeling Mapping Unknown_Mapping_Name not found.

However, the process crashes at this time and I have no chance to control the result and write the status in a table or do something else to pass the fail status back to the calling application.

Then I tried it with try/catch:

try{
ModelingOperationResult map_result = ModelingExecuteHierarchyMapping(applicationName, mappingName);
}

catch (errorMessage, errorCode) {
StringList mapping_message = ModelingOperationResultGetMessages(map_result);

// Check if successful...

Problem here: inside the catch the variable map_result is not declared.

How can I declare the map_result globally? I don't know how to initialise the variable...

Could anybody please provide a code snipped that shows how to check the result of a mapping, so that all cases like mapping does not exist at all, mapping returns error, mapping returns warnings, etc. can be controlled and the process itself does not crash.

Thanks in advance,

Ralf

Find more posts tagged with

FAQs, How-To's, and Best Practices

Comments

ivan-rebo

Hi,

in case of an error the only message you can get is directly in the errorMessage part of the "catch" clause. The modeling operation result object only contains information about possible warnings that happened on a successful run.

I think all the details must be read from the user logs from the staging database where modeling writes them.

regards

Ivan

unknown

Hi Ralf,

the errorMessage variable in the catch should capture any errors, try the following:

try{
ModelingOperationResult map_result = ModelingExecuteHierarchyMapping(applicationName, mappingName);
}

catch (errorMessage, errorCode) {
WriteLine(errorMessage);

}

Ralf Zerfass

Hi Ivan,

thanks for the fast response.

I understand that the ModelingOperationResult can not be provided when the mapping itself does not exist and this kind of error must be cought by try/catch.

But another test: I called a dimension mapping that exists in fact, but failed, because of "Consolidated elements without chilldren are invalid".

Unfortunaltely the same result: the function ModelingExecuteHierarchyMap fails and no result in the ModelingOperationResult is given.

I think, when a mapping exists the execution result should be returned properly, no matter if success warning or error, shouldn't it?

Digging for error messages in the Log-tables is a big challenge... Do you have a sample SELECT how to find "my" error messages?

Ralf

ivan-rebo

Modeling makes no difference between different types of errors. When it considers something more then a warning, the whole call will fail with the exception and the error is in the errorMessage of the catch.

Sorry i dont have a sample that reads from the database. Maybe someone else can help with that.

Ralf Zerfass

Hi Ibrahim,

means that errors have to be checked by try/catch but the exact error message of the mapping can only be selected from the logging tables.

When the function call was successful (i.e. execution continues in the try-branch) the ModelOperationResult must be checked with the new functions to find out, if there are warnings and if so, retrieve the warnings using ModelingOperationResultGetMessages

Is that the right way to do it, now?

Are there any plans to simplifiy this in a way that the ModelOperationResult-functions cover all the above?

Regards and thanks for explaining,

Ralf

Ralf Zerfass

One more (and hopefully last) question:

I want to handle both, hierarchy and fact mappings in one process, as all of the rest is the same for both types.

However,, when executing this:

try {

if (mappingType == "D")
{
ModelingOperationResult map_result = ModelingExecuteHierarchyMapping(applicationName, mappingName);
}

if (mappingType == "C")
{
ModelingOperationResult map_result = ModelingExecuteFactMapping(applicationName, mappingName);
}

StringList mapping_message = ModelingOperationResultGetMessages(map_result);

the execution of the ModelingOperationResultGetMessages fails, because the variable map_result is not declared here anymore as the call is outside the brackets.

So my idea is to declare the variables outside at the top of the process, but I have no idea how to initialise the variable:

ModelingOperationResult map_result = ?????

Neither 0, "", NULL etc. worked.

What is the correct way to initialise a variable of type ModelingOperationResult globally so that is can be use in the whole process?

Thanks for any ideas,

Ralf

ivan-rebo

app engine does not at the moment support creating of empty variables. Might be something we add in future.

For now rather create one stringlist (with createstringlist) and get the stringlist from the result in each of the branches.

martin-reischl

Hi Ralf,

>Do you have a sample SELECT how to find "my" error messages?

I now ran into a similar situation that you are describing. Now I do have a solution that reads the "good" messages from the application log. The main caveat is that the application log is written in an asynchronous way, so it may take a few minutes until the messages appear in the SQL table. I'm now using an asynchronous App Engine process to read this information and add it to my regular logging, whenever the stuff appears.

The other caveat is that the timestamps in the application log are always UTC, and App Engine gives you only your local time. There is an enhancement request for this limitation, 97211.

But otherwise, this SQL will give you the information that you want:

SELECT m.[EVENT_ID], e.[Name] AS EVENT_NAME, m.[LEVEL], m.[EVENT_DATA] FROM [DEPM_FWK_LOG_ENTRY] m inner join [DEPM_FWK_LOG_EVENT] e on m.Event_id = e.event_id WHERE APPLICATION_NAME = '<application>' and OBJECT_NAME = '<unique name of the mapping>' AND USER_ID = '<current user name>' AND ADDED_DATE >= '<time in utc when the mapping was called>' AND ADDED_DATE <= '<time in utc when the mapping finished>'

In my sample run, the result in my logging file looks like this:

02/28/2023 10:24:18 E Element not exist: {"dimension":"DACOUNT","element":"050204010x"}
02/28/2023 10:24:18 E Element not exist: {"dimension":"DCOMPC","element":"20002x"}
02/28/2023 10:24:18 E Element not exist: {"dimension":"DCOMPC","element":"20004x"}
02/28/2023 10:24:18 E Cube Load Stop: {"cube":"TFINANC","numberOfLoadedValues":"163992","numberOfErrors":"2780"}

That is exactly what I need to know. Sorry I found no easier way to extract this piece of poetry.

Best Regards

Martin

dEPM-634 - Demonstrating_Whats_New_WB_12_0_8_vid.mp4

Ralf Zerfass

Hi Martin,

thanks a lot for investigating and sharing this. Will have a closer look at it next time I'm at the customer's site.

Have a nice day,

Ralf

radek-kafka

Many thanks Ivan for that. We are not able to catch and get details out of some hard error ocuring inside of mapping/modeling operation for now (due to fact we don't have an empty variable to use in catch block).

I'm handling all these errors using this simple approach:

ModelingOperationResult modOperResult = ModelingExecuteTableDataLoadQuery(ModelName,TableName,Name,bClear);
StringList slMessages = ModelingOperationResultGetMessages(modOperResult);
string sSeverity = "I";
if ( !ModelingOperationResultIsSuccess( modOperResult ) or ModelingOperationResultIsWarning ( modOperResult )) {
sSeverity = "W";
}
foreach (string modMsg in slMessages ) {
AddProtocolEntry(sqlConn, RequestId, sSeverity,0 ,modMsg);
}

Copyright © 2025 Infor. All rights reserved.