Skip to Content

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

Dec 09, 2016 at 11:44 PM


avatar image
Former Member

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)


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 !!


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Marc Kuipers
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.


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.


10 |10000 characters needed characters left characters exceeded
Vadim Kalinin 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?

10 |10000 characters needed characters left 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.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

I think the topic author is not interested in the answers...


I'm interested... as I had the same error after a test environment was restored and no information was in the log to go on. Ran a Light Optimize and everything is great!

Thanks for posting Ashok.


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 :)