Precalc not able to run workbook

[Former Member]

Hi Alll

Getting this error when opening a WB from Precalc server:

Unresolved exception occurred on the precalculation server

System.FormatException: Input string was not in a

correct format.

at System.Number.StringToNumber(String str, Num mberStyles options,

NumberBuffer& number, NumberFo

matInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberSty

les style, NumberFormatInfo info)

at com.sap.bi.et.precalculation.BexExcelPrecDll

.SetConnectionTicket(DataTable iParamTable)

at com.sap.bi.et.precalculation.BExPreCalcRFCSe

erverImpl.RS_PREC_PRECALCULATE(String i_jobname, S

ring I_REQUESTEDTYPE, String I_SESSIONID, String I I_TRANSPRINTER,

String I_VARIANT, RSRWBSTORETable&

C_T_BIN_FILE, BICS_PROV_T_MESSAGE& E_T_MESSAGE, RR RX_T_W3QUERY&

I_T_SERVERPROPERTIES, RSR_PREC_T_VAR

I_T_VAR, RRX_T_W3QUERY& I_T_WORKBOOKPROPERTIES)

Input string was not in a correct format.

at System.Number.StringToNumber(String str, Num mberStyles options,

NumberBuffer& number, NumberFo

matInfo info, Boolean parseDecimal)

at System.Number.ParseInt32(String s, NumberSty

les style, NumberFormatInfo info)

at com.sap.bi.et.precalculation.BexExcelPrecDll

.SetConnectionTicket(DataTable iParamTable)

at com.sap.bi.et.precalculation.BExPreCalcRFCSe

erverImpl.RS_PREC_PRECALCULATE(String i_jobname, S

ring I_REQUESTEDTYPE, String I_SESSIONID, String I I_TRANSPRINTER,

String I_VARIANT, RSRWBSTORETable&

C_T_BIN_FILE, BICS_PROV_T_MESSAGE& E_T_MESSAGE, RR RX_T_W3QUERY&

I_T_SERVERPROPERTIES, RSR_PREC_T_VAR

I_T_VAR, RRX_T_W3QUERY& I_T_WORKBOOKPROPERTIES)

pls help.

[Former Member · Accepted solution]

Hi,

Few months back we had similar issue in our landscape and we raised message with SAP for this.After many rounds of discussion , we came to know that our platform version Windows server 2003 R2 64 bit edition is not supported for PreCalc.

They have asked us to move to either of these platform :

Windows server 2003 32 bit / 64 bit (Not R2)

Windows server 2008 32 bit / 64 bit (Not R2)

Windows Xp.

Please see if this is your issue too.

Regards,

Ashutosh

[Former Member · Accepted solution]

Thanks ashutosh,

If the platform is the issue then i'm running on same platform as yours ie Windows server 2003 R2(32 bit / 64 bit) .Will raise a separate message with SAP to get more info on this.

Thanks all for your replies.

Ritesh.

[Former Member · Accepted solution]

One more thing, out of three platforms recommanded by SAP..they have preffered Windows XP or We are going for Windows 2008 x64 Enterprise SP2 for PreCalc.

Regards,

Ashutosh

[Former Member]

Hi,

Issue has been addressed and fixed in the below forum. Please check

Regards,

Sravanthi

[Former Member]

Hello RItpta,

What is your SAP GUI version?

what is your EXCEL version?

Only Excel 2003 and 2007 is supported.

Please, check the note : 1450271

Check the attachment.

Software requirements: u2022 Microsoft Excel 2003 or Excel 2007

also check note : 1461398

Regards,

Amit Barnawal

[Former Member]

i have GUI 720 and excel 2007 .

Even after restart its not resolved and giving same error.

thanks,

Ritesh

[Former Member]

Hi,

Ensure you are using the latest version of Precal Server, and BI

Addons on your Precalculation Server Station

Try to open the workbook with Bex Analyzer on your precalc server.

If the issue does not occurs, the upgrade of the frontend will solve

the issue.

Try to execute the workbook individually there might be some

errors while precalculating the workbook.

Go to RSPRECADMIN T-code and check the Precal queue, delete your

workbook from that list of queue and re-broadcast and monitor in SOST

Activate the SAP BW Precalculation Multiinstance service. Register 3

instances per System (recommended). This will solve the issue.

Please execute these steps and let me knw results.

Regards,

Ashutosh

[Former Member]

Hi,

Please refer to below troubleshooting guide

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30e3d697-4ca0-2c10-4b81-c474b1490...

Also check the Note 1500347 - The Broadcasting Log RSRD_LOG

Regards,

Sravanthi

[Former Member]

Hi,

Can you try to restart your precalc server and in table RSBATCHPARALLEL, and for PROCESS_TYPE "BROADCAST"

set the value 01 for the field PARALLEL_PROCS. Test it again.In case you are running more broadcast jobs, then try to increase this setting one value at a time until you get this working.

Add "BWPREC_USE_NEW_LOAD" with value "X" in table "RSADMIN", as you now

have the latest patches for precalculation server.

Regards

Ashutosh