Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

bi7 workbook precalculation no data

Dear sap guys.

i have installed the sap bw workbook precalculation service and custimzing the precalcuation server in the bi tcode rsprecadmin.

when i test the precalculation, always get the bank excel with the message line "There are variables; change variable values." no the data line appear.

the log of precalculation is posted here:

BExTextPool.New2: 2.65625

BExTextPool.New3: 2.65625

BExTextPool.New2: 2.8125

BExMenu.CreateSubMenu1: 0

BExMenu.CreateSubMenu2: 0.78125

ListSeparator: ,

ExcelVersion: 11.0

AddinVersion: 7005.5.1403.811

GetSystemInformation

SUNI Const: 2.1875

CommunicationFactory.GetSystemInformation (Setting Conn 1)): 2.1875

CommunicationFactory.GetSystemInformation (Setting Conn 2)): 6.875

CommunicationFactory.GetSystemInformation (Setting init Propties)): 6.875

CommunicationFactory.GetSystemInformation (SUNI.FUNCTION_EXISTS)): 7.34375

RSR_XLS_RFCtrc: 4.375

CommunicationFactory.GetSystemInformation (RSR_XLS_NET_INTERFACE)): 15.15625

CommunicationFactory.GetSystemInformation (XML Stuff)): 18.90625

CommunicationFactory.GetSystemInformation (Prop Stuff)): 18.90625

CommunicationFactory.GetSystemInformation (Version)): 18.90625

CommunicationFactory.ObtainSystemInformationandCheckVersion (GetSysInfo)): 18.90625

CommunicationFactory.ObtainSystemInformationandCheckVersion (CheckAfterLogin)): 0

CommunicationFactory.LogOnUsingComConnection (ObtainSystemInfo)): 18.90625

CommunicationFactory.LogOnUsingComConnection (MainConnectionChangedEvent)): 1.5625

BExItems.CreateFromDeSer: Trying to deserialize the Items...

BExExcelApplication - New 2---- Windows visible is set to true

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExExcelApplication - OpenWorkbookOpenTheSavedWorkbook -

-


Windows visible is set to true

BExConnect.LogOn: 633449958564.219

RSR_XLS_RFCtrc: 1.5625

RSR_XLS_RFCtrc: 2.34375

at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

at System.Environment.get_StackTrace()

at com.sap.bi.et.analyzer.api.BExApplication.Refresh(Boolean iWithVariables, Boolean iRRICall)

at com.sap.bi.et.analyzer.api.BExApplication.Refresh()

at com.sap.bi.et.analyzer.api.BExApplication.set_Synchronize(Boolean iValue)

at com.sap.bi.et.analyzer.addin.BExMenu.Refresh(String iName)

at com.sap.bi.et.analyzer.addin.BExMenu.Refresh()

at com.sap.bi.et.analyzer.addin.BExThreads.ProcessSubExecuter.Execute()

at com.sap.bi.et.analyzer.addin.BExThreads.Execute(BExExecuter iExecuter, Boolean iFrontendUpdate, Boolean iDoNotDisplayMessages)

at com.sap.bi.et.analyzer.addin.BExConnect.MenuRefreshPrecalc(Object iVariables, String iFileName)

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

Withvariables - False

BExItemGrid: Making BExVZOZS65T15NOGPBB5XTO7E9XW invisible

BExItemGrid: BExVZOZS65T15NOGPBB5XTO7E9XW is invisible: 0

BExItemGrid: Making BEx5PYJ15CQMM60SZOBOQV522YE4 invisible

BExItemGrid: BEx5PYJ15CQMM60SZOBOQV522YE4 is invisible: 0

BExItemGrid: Making BEx1VHR3T7MJWIK8SPJJM7FVMF1E invisible

BExItemGrid: BEx1VHR3T7MJWIK8SPJJM7FVMF1E is invisible: 0

BExItemGrid: Making BEx3CORPFIDSPEQBC46SPTQEYDT1 invisible

BExItemGrid: BEx3CORPFIDSPEQBC46SPTQEYDT1 is invisible: 0

RenderIndent: 0

RenderBorders: 0

RenderHierarchyShapes: 0

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

RenderIndent: 0

RenderBorders: 0

RenderHierarchyShapes: 0

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExApplication.AfterRender: 01æ?ªæ?¾å?°å?å??æ ¼ã??

BExConnect.CloseWorkbook: SAPBEXPREC8965.xls

RSR_XLS_RFCtrc: 0.15625

BExCompression.SupportsCompression: Compression NOT supported

Could not load file or assembly 'vjslib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

RSR_XLS_RFCtrc: 0

BExConnect.Closed

Best regards.

Eric

Edited by: liu mengjun on Apr 28, 2008 4:55 AM

Former Member
Not what you were looking for? View more on this topic or Ask a question