Problems while writing data (Cannot perform write (RSDRI_CUBE_WRITE_PACKAGE)

[Former Member]

Hi Experts,

I'm facing this problem while trying to save data via Input Forms, script logic or Data Manager. Whenever I click on Save Data button, the process starts but it nevers ends, although IT DOES SAVE DATA.

As soon as I click on Save Data I can see that the data is already written in the InfoCube, but the EPM process stops until half an hour later with the message: "The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error"

I'm currently working on S4HANA, BPC 10.1 Standard. EPM 10.0 SP28 Patch 3 .NET 4.5

SAP BASIS 752 SP0

SAP BW 752 SP0

system.png

I have the follwing messages:

EPM log:

FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2 RECORD_SEPARATOR:35 COLUMN_SEPARATOR:124 COLUMNS:Time|Severity|Category|Method|User|DSRRootContextID|DSRTransactionID|DSRConnectionID|DSRCounter|Thread|Text SEVERITY_MAP:DEBUG|Debug|INFO|Information|VERBOSE|Verbose|WARNING|Warning|ERROR|Error|FATAL|Fatal HEADER_END 2018-07-23 22:05:59,374|ERROR|OfficeWrappers|FPMXLClient.Office.EPMExcelReportManager+<>c__DisplayClass3b.<ExecuteParallelizedReportsFramework4>b__38|sthana8|||||1|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="SAP NetWeaver Application Server [NS4/800]"'.# 2018-07-23 22:05:59,389|ERROR|AnalyzerOne|FPMXLClient.AddIn.RefreshSheetWithScan|sthana8|||||1|Error in refresh sheet# 2018-07-23 22:05:59,468|ERROR|AnalyzerOne|FPMXLClient.AddIn.ExecuteUICommand|sthana8|||||1|Error in refresh sheet# 2018-07-23 22:06:02,768|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request|sthana8|||||1|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="SAP NetWeaver Application Server [NS4/800]"'.# 2018-07-23 22:06:02,784|ERROR|BPCProxy|FPMXLClient.BPCProxy.Session.SessionServiceHelper.Logoff|sthana8|||||1|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="SAP NetWeaver Application Server [NS4/800]"'.# 2018-07-23 22:06:14,658|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request|sthana8|||||38|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="SAP NetWeaver Application Server [NS4/800]"'.# 2018-07-23 22:37:25,648|ERROR|Dataservice|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.SendData|sthana8|||||1|The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.# 2018-07-23 22:37:25,648|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.SendDataToServer|sthana8|||||1|The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.# 2018-07-23 22:37:25,664|ERROR|AnalyzerOne|FPMXLClient.AddIn.SubmitSheet|sthana8|||||1|The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.# 2018-07-23 22:37:25,664|ERROR|AnalyzerOne|FPMXLClient.AddIn.ExecuteUICommand|sthana8|||||1|The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.#

In SM21:

Database error 131 with FET access to table RSAPOADM

In SLG1:

Cannot perform write (RSDRI_CUBE_WRITE_PACKAGE)

In SM12:

There are no Lock Entries

Please, any help would be greatly appreciated. Thanks in advance.

Cesar Sarabia

[former_member523998]

What happens if...

• You disable default logic? Does the issue persist?
• Process your dims? Any errors?
• You run a lite optimize? Any errors?
• Execute a send in a different model? Same error?
• Switch real time behavior, delete a meaningless record, switch back?

[Former Member]

Hi Steven,

Thanks for the answer. I have run the scenarios you mentioned with the following results:

• As far as I know default logic cannot be disabled, however, I ran a script logic without running the default logic and the issue persist; data is written in 2 seconds but the script process stops until half an hour later.
• Dimensions are processed successfully without any errors
• Lite optimization supposedly runs and ends successfully, however I noticed that in SLG1 the following job is being executed every 3 seconds for half an hour until it stops:

  

  

• I tried to save data via Input Form in the Rates model and got the same result; data is written almost immediately in the InfoCube but the process window in EPM displays "Saving Data... Please wait..." for half an hour.

• I tried to switch the Real Time behaviour but i got the following dump in ST22 (only happening with InfoCubes where I have written/saved data, other InfoCubes switching Real Time behaviour correctly):

Category ABAP programming error

Runtime Errors DBSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

ABAP Program SAPLRSSM

Application Component BW-WHM-DST

Date and Time 24.07.2018 22:02:16

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Short Text | | SQL error "SQL code: 131" occurred while accessing table "RSAPOADM". |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|What happened? |

| Database error text: "SQL message: transaction rolled back by lock wait |

| timeout: TrexUpdate failed on table 'SAPABAP1:RSAPOADM' with error: |

| transaction rolled back by lock wait timeout: Lock timeout occurs while |

| waiting RECORD_LOCK of mode EXCLUSIVE(TRANSACTION_ID=64, UPDATE_T"

| ----------------------------------------------------------------------------------------------------

| 64| cl_rs_b4hana_util=>abort_function( ). |

| 65| |

| 66| CLEAR: l_set_green. |

| 67| IF i_init_simu IS INITIAL AND i_error_handler IS INITIAL. |

| 68| CHECK NOT i_rnr IS INITIAL. |

| 69| | | 70|* check if RSAPOADM must be cleaned in case of a |

| 71|* transactional infocube: I_TRANSACT = RS_C_TRUE |

| 72|* I_ignore is only set if cube is transactional |

| 73| IF i_transact = rs_c_true. |

| 74| CALL FUNCTION 'RRSI_VAL_SID_SINGLE_CONVERT' |

| 75| EXPORTING |

| 76| i_iobjnm = rsd_c_dpanm-requid |

| 77| i_chavl = i_rnr |

| 78| IMPORTING |

| 79| e_sid = l_rnrsid. |

| 80|** check if requets is already closed? |

| 81| |

|>>>>>| SELECT SINGLE FOR UPDATE * |

| 83| INTO l_s_rsapoadm |

| 84| FROM rsapoadm CONNECTION (l_second_connection) |

| 85| WHERE infocube = i_infocube. |

| 86| |

| 87| IF sy-subrc = 0 AND l_s_rsapoadm-wr_request = i_rnr |

| 88| AND NOT l_s_rsapoadm-wr_request IS INITIAL. |

| 89| |

| 90|*** request mut be closed |

| 91| DO. |

| 92| CALL FUNCTION 'ENQUEUE_ERSICCONT' |

| 93| EXPORTING |

| 94| icube = i_infocube |

| 95| _scope = 3 |

| 96| EXCEPTIONS |

| 97| OTHERS = 1. |

| 98| IF sy-subrc = 0. |

| 99| EXIT. |

| 100| ELSE. |

| 101| CALL FUNCTION 'RSSM_SLEEP_DEBUG' |

.

.

Thanks a lot for any additional suggestion.

César Sarabia