OLAPCopyDataArea - Failed to copy data area with error = '69'

After a great battle in B#, I have found the cause and would like to share with anyone else that may come across this.

According to the docs, the error 69:

69	The entered value does not match the value type of the cell.

With suppression enabled, base elements selected within the data area and useOnlyBasicElements set to true (to copy calculated cells) I received an error for 1 cube, the remainder 11 worked fine.

Troubleshooting by reverting to the old foreach method shed no light, as it simply copied all across correctly...

Turns out the OlapDataAreaSuppressNull doesn't detect a physical 0 as null when using in combination with OLAPCopyDataArea.

Therefore using the operator OlapDataAreaOperatorNotEqual, 0.0 resolved it.

Would be very interested to know why this happens exclusively to the OLAPCopyDataArea and not the OLAPCellWriteNumberDynamic/buffer function.

Hope this helps someone.

Find more posts tagged with

Infor EPM Discussions

Comments

unknown

Hi Ebrahim

Thank you for the interesting post.

I got the 69 error after 7 hours of run time. I assumed it was a timeout. I was running the script asynchronous on App Studio.

Process 'Training_CopyActuals_UnitLoop/1' finished with error: 'An error has occurred: 
Failed to copy data area with error = '69''.

my script action lines were:

OLAPDataArea dActualsData = OLAPCreateDataArea(oConnection, "CSTMAIN",
                                                        OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNone,
                                                        0.0, OlapDataAreaOperatorNone, 0, sourceElements);

         //run the copy command just for this unit
         OLAPCopyDataArea(dActualsData, "CSTMAIN", "Relative", 1.0, targetElements, sourceElements, true, false);

Do you feel adding " OlapDataAreaOperatorNotEqual, 0.0 " will improve the performance of my script and avoid the error?

Thanks
Bilal
bilal.docrat@ioco.tech

John Robson

Bilal

The OLAPAreaSupressNull is already stopping null elements being picked up in the data area. So unless your cube is full of zeros the change won't help.
Iterating through or copying a data area triggers any required rule calculations and this should be investigated first.

Gelangens_Anlage_Entwurf.pdf

unknown

Hi Bilal,

Based on my finding you should absolutely use 'OlapDataAreaOperatorNotEqual, 0.0' in combination with OLAPCopyDataArea as it will not exclude a physical '0' in the data area.

OLAPDataArea dActualsData = OLAPCreateDataArea(oConnection, "CSTMAIN",
OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNotEqual,
0.0, OlapDataAreaOperatorNone, 0, sourceElements);

I would however start by cutting down your data area to identify the true cause of your error. Isolate it down so your not having to wait 7 hours between tests to see the result.

OLAPCopyDataArea(dActualsData, "CSTMAIN", "Relative", 1.0, targetElements, sourceElements, true, false);

I noticed you used 'false' for the last parameter, this will trigger your rules and copy calculated cells - is this your intention?

Setting this to 'true' will copy basic elements only.

Also ensure that your 'sourceElements' StringListList is built using strictly base elements to keep this copy as optimal as possible.

Good luck.

unknown

Thanks for the feedback Ebrahim. I will test your suggestion.

The purpose of the script is to copy calculated values to a static uncalculated reporting level. The allocation rules are complex and cause reports to take hours to refresh.

Martin suggested that I loop through the units instead of one huge copy.

my script looks like this. You are welcome to make any suggestions.

#define EngineVersion 5.0
#define RuntimeVersion 5.0

//Include process with OLAP Connection parameters
#include "Training_OLAPConnection", "*"

bool Training_CopyActuals_UnitLoop(string SourceYear, string TargetYear)
@Description: "Copy Actuals to Budget from Source year to Target year";
@Category: "AppEngine Training - Exercise 4";
@Parameter[SourceYear]: "Year to take the values from";
@Parameter[TargetYear]: "Year to put the values to";
@ParameterDebuggerValue[SourceYear]: "01_2022";
@ParameterDebuggerValue[TargetYear]: "01_2026";
@Returns: "True if process is successful";
{
    // 1. Create a connection from Global parameters process
    OLAPConnection oConnection = Training_OLAPConnection();    //  Create string list for target data area
    StringListList targetElements = CreateStringListList();
    StringList s_model  = ConvertToStringList("Planning");

    StringList s_level  = ConvertToStringList("STATIC");
    StringList s_version  = ConvertToStringList("Revised Fcst");
    StringList s_entity  = ConvertToStringList("Santam_Group");
    StringList s_year  = ConvertToStringList("2026");
    StringList s_period  = ConvertToStringList("02");

    OLAPElementList olOPS = OLAPGetChildElementList(oConnection, "CSTORGPL", "OPS", true);
    StringList s_orgPL  = ConvertToStringList(olOPS) ;    StringList s_orgHL  = ConvertToStringList("N.A.");
    StringList s_account  = ConvertToStringList(OlapDataAreaBCells);    StringList s_channel  = ConvertToStringList(OlapDataAreaBCells);
    StringList s_class  = ConvertToStringList(OlapDataAreaBCells);
    StringList s_relman  = ConvertToStringList("N.A.");
    StringList s_currency  = ConvertToStringList("ZAR_LC");


    Append(targetElements,s_model);
    Append(targetElements,s_level);
    Append(targetElements,s_version);
    Append(targetElements,s_entity);

    Append(targetElements,s_year);
    Append(targetElements,s_period);
    Append(targetElements,s_orgPL);
    Append(targetElements,s_orgHL);
    Append(targetElements,s_account);
    Append(targetElements,s_channel);
    Append(targetElements,s_class);
    Append(targetElements,s_relman);
    Append(targetElements,s_currency);

    StringListList sourceElements  = CreateStringListList();

    Append(sourceElements,s_model);
    StringList s_source_level  = ConvertToStringList("INPUTS");
    Append(sourceElements,s_source_level);

    Append(sourceElements,s_version);
    Append(sourceElements,s_entity);
    StringList s_Source_year  = ConvertToStringList("2023");
    StringList s_Source_period  = ConvertToStringList("01");
    Append(sourceElements,s_Source_year);
    Append(sourceElements,s_Source_period);
    Append(sourceElements,s_orgPL);
    Append(sourceElements,s_orgHL);
    Append(sourceElements,s_account);
    Append(sourceElements,s_channel);
    Append(sourceElements,s_class);
    Append(sourceElements,s_relman);
    Append(sourceElements,s_currency);
    // 4. Delete all existing values in the target area.
    // Filter data area to values that are not null (suppress null values). Use base elements only
    OLAPDataArea deleteValues = OLAPCreateDataArea(oConnection, "CSTMAIN",
                                                   OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNone,
                                                   0.0, OlapDataAreaOperatorNone, 0, targetElements);
    OLAPDeleteDataArea(deleteValues);

    //___________________________________________________________

    int counter = 0;

    //get all basic elements of the dimension
//    OLAPElementList olOPS = OLAPGetElementList(oConnection, "CSTORGPL", true);

    NotifyDebug("before loop");

    //then loop through each element of the dimension
    foreach (OLAPElement oeOPS in olOPS) {
        //NotifyDebug("inside loop");
        NotifyDebug("counter: " + counter);

        NotifyDebug("oeOPS: " + oeOPS);
        counter = counter + 1;

        targetElements = CreateStringListList();

        Append(targetElements,s_model);
        Append(targetElements,s_level);
        Append(targetElements,s_version);
        Append(targetElements,s_entity);

        Append(targetElements,s_year);
        Append(targetElements,s_period);
        //Append(targetElements,s_orgPL);
        Append(targetElements,oeOPS);
        Append(targetElements,s_orgHL);
        Append(targetElements,s_account);
        Append(targetElements,s_channel);
        Append(targetElements,s_class);
        Append(targetElements,s_relman);
        Append(targetElements,s_currency);


        sourceElements  = CreateStringListList();

        Append(sourceElements,s_model);        Append(sourceElements,s_source_level);

        Append(sourceElements,s_version);
        Append(sourceElements,s_entity);        Append(sourceElements,s_Source_year);
        Append(sourceElements,s_Source_period);
        Append(sourceElements,oeOPS);        Append(sourceElements,s_orgHL);
        Append(sourceElements,s_account);
        Append(sourceElements,s_channel);
        Append(sourceElements,s_class);
        Append(sourceElements,s_relman);
        Append(sourceElements,s_currency);

        //define the data area just for this unit

        OLAPDataArea dActualsData = OLAPCreateDataArea(oConnection, "CSTMAIN",
                                                       OlapDataAreaIncludeB | OlapDataAreaSuppressNull, OlapDataAreaOperatorNone,
                                                       0.0, OlapDataAreaOperatorNone, 0, sourceElements);

        //run the copy command just for this unit
        OLAPCopyDataArea(dActualsData, "CSTMAIN", "Relative", 1.0, targetElements, sourceElements, true, false);
    }

// 8. Disconnect from OLAP Server
    OLAPDisconnect(oConnection);

    return true;
}

Copyright © 2025 Infor. All rights reserved.