Skip to Content
avatar image
Former Member

Cannot perform write (NOT_TRANSACTIONAL) while running Package Link in EPM 10

Hi Gurus,

I am trying to run the Package Link (tried schedule & run both) in EPM 10 system. Package Link has 6 packages total. Issue here I am getting when I run the Package link at first Package (CLEAR-which is clearing the selected dimensions as per Business need) throwing error message in 16 seconds. Error message is as below.

Cannot perform write (NOT_TRANSACTIONAL)

Model - FINANCE

Package status - Error.

I tried enabling the 'Real Time Load Behavior' of the backend Infocube in BW system (7.4-SP-8). But still I am getting the same error message.

Could you please share the experiences if anybody has come across the similar issue. Appreciate your help.

Thank you !!

Sree

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 14, 2017 at 12:58 PM

    Hello Sree S

    This message (“Could not perform write (NOT_TRANSACTIONAL)”) indicates that the planning model is currently set to "Real-Time Data Target Can Be Loaded With Data; Planning Not Allowed".

    This can occur if a process is interrupted and the model is not returned to proper planning status, such as if a Lite optimize or BW data load fails or is interrupted.

    To resolve this issue:

    1. Go to backend BW system.

    2. Refer to the data cube, right-click on it, and click Switching a Real-Time Data Target.

    3. Choose 2nd option: Real-Time Data Target Can Be Planned; Data Loading Now Allowed.

    4. Save the setting.

    See: https://service.sap.com/sap/support/notes/1397208

    As to what caused the model to be left in this state you will need to investigate to determine what process chains or Data Manager packages were executed just before this issue occurred.

    Note: it is, of course, also possible that someone manually changed the option.

    Marc

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 10, 2016 at 07:52 AM

    First - incorrect primary tag, has to beSAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

    Second - if you simply run DM package to clear data (without package link) do you have the same error?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 08, 2017 at 04:40 PM

    Before running Data Manager Package Link, Run Light Optimization package. I think you can not get the error.

    Add comment
    10|10000 characters needed characters exceeded

    • You have to understand that "Run Light Optimization package" has nothing relevant to the issue "Cannot perform write (NOT_TRANSACTIONAL)"

      You have some other issue and it will come back in future!

      P.S. If you look on Light Optimize chain you will see that it will switch cube mode :)