Work Book problem

[Former Member]

Hi All,

I am trying to ececute one workbook and when i gave variable inputs here its getting error. Error message is "System exception thrown while marshaling RFCTYPE_NUM to .NET type."

Can any one tell me when this error occurs?

Thanks

Sravani

[former_member186696]

Hello Sravani,

To solve this issue, could please implement the below note.

1179647 - Performance: Network load in BEx Analyzer.

Also, apply all the manual pre-requisites mentioned under the solution part of this note.

>> For your reference I'm pasting below the manual steps that are listed in the note 1179647, which needs to be carried out.

________________________________________________________________________

Create the structure RSR_XLS_RAW or change this structure as follows:

Component Data type Length

RAW RAW 2048

Create the table type RSR_XLS_T_RAW with the line type

RSR_XLS_RAW.

In transaction RS_FRONTEND_INIT, add the following entry:

ANA_USE_TABLE with the value X.

________________________________________________________________________

If persist, let us know.

Thanks

Edward John

[former_member197449]

Hi John,

Hope you are fine.

Below are our current details:

SAP BW Server:Ver 7.01 SPS12/ SAP EHP 1 for SAP NetWeaver 7.0

Business User Client Laptop:Operating system:Windows 7 SP1 SOE v1.05

Microsoft .Net Frame Work 4.1.1

Java Runtime Engine 1.6.0_35

Microsoft Office 2010 14.0.6029 32 bit

SAP GUI For Windows 7.30 7.3 Compilation 3 and

Latest SAP GUI Patch 10 applied and compatible SAP BI Addon installed and Related latest SAP BI Addon Patch 701 applied

We did install the latest patches as far as SAP GUI 7.30 is concerned on client laptop and also

1) In this Business User Client Laptop added latest Verisign certificate downloaded from verisign site to Bex Analyzer.xla addin

2) In SAP BW below server settings done Use transaction RS_FRONTEND_INIT          

       A) Set parameter ANA_USE_SIDGRID to x          

       B) set  ANA_USE_TABLE to x          

       C) set ANA_USE_SIDGRIDMASS to x          

       D) set ANA_USE_SIDGRIDWBUF to x          

       E)set  ANA_ENHANCE_REFRESH to x          

       F) set ANA_SINGLEDPREFR_NEW to x          

       G) set ANA_SERIALIZE_PARTS to x          

       H) Created the structure RSR_XLS_RAW or change this structure as follows:                 

             Component Data type   Length                         

                      RAW     RAW     2048           

         I) Created the table type RSR_XLS_T_RAW with the line type                 RSR_XLS_RAW.

On Running Excel Workbook in Business Explorer Analyzer in above laptop giving above error "System exception thrown while marshaling RFCTYPE_INT to .NET type" even after applying SAP Note 1179647 [which is/was running fine in legacy environment successfully(XP, SAP GUI 7.20, Excel 2003)]

On Observing the traces below error message is obtained as well

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

BExConnect.SetExcel: Attach Excel Instance

BExConnect.SetExcel: Copy Manifest

BExConnect.SetExcel: Set Registry

BExConnect.RegistrySet: System.UnauthorizedAccessExceptionAccess to the registry key 'HKEY_CLASSES_ROOT\SAP.BusinessExplorer.Analyzer\ApolloPath' is denied.

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

BExAnalyzer Settings:

  ListSeparator: ,

  ExcelVersion: 14.0

  AddinVersion: 7300.3.701.2015

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

BExConnect.SetExcel: Initialize BExMenu

BExConnect.SetExcel: Initialize StatusBar

BExConect.BExGetData: Object reference not set to an instance of an object.

   at com.sap.bi.et.analyzer.addin.BExConnect.BexGetData(String iDataprovider, Object iArray)

BExConect.BExGetData: Object reference not set to an instance of an object.

   at com.sap.bi.et.analyzer.addin.BExConnect.BexGetData(String iDataprovider, Object iArray)

CommunicationFactory.UserSettings.CheckFIPSEnabled: open LocalMachine SubKey 'SYSTEM\CurrentControlSet\Control\Lsa\FipsAlgorithmPolicy'

CommunicationFactory.UserSettings.CheckFIPSEnabled: GetValue 'Enabled'

CommunicationFactory.UserSettings.CheckFIPSEnabled: FIPSEnabled:=False

  Isolated Storage FileName: [Unknown]

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

BExCheckFrontend.CheckFrontend: No Check performed (20140904) 0.01

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

The trace tells me a differnt story, that Unauthorized access due to policy set by the organization.

Can you please advice accordingly?

Appreciate your help in advance

Regards,

Venu.K

[Former Member]

Hey Sravani,

Marshalling happens from BYTE[] to RFCTYPE_BYTE. But In order to convert to RFCTYPE_BYTE., your source array should be of predefined length ie 32000 bytes. If the source array size is less than 32000, then you will get an error as I have reported in the oroginal post.

So when you are converting Dotnet Type to SAP Type, you need to define the source array of length 32000.

Hope it helps you.

Gracias...!!

[former_member142702]

You should reference posts of other persons rather than copy them "as is".

Regards,

Stratos

[Former Member]

Hi BOE,

Thanks for your answer but How to define the array settings in BW system

Thanks

Allu