Skip to Content
0
Former Member
May 23, 2014 at 10:35 AM

Thousand separator conversion issue with SEGW for BW queries service

192 Views

Dear All,

We have created a project in SEGW for SAP BW MDX query. While testing the service we found that if the amount/number is more than 6 digits then it is failing to display the results. We are getting below error message saying The argument '6.925.8477300000' cannot be interpreted as a number.

If we restrict the amounts to less than 6 digits it works fine. This is considering COMMA as decimal place and DOT as thousand separator.

Can any one tell me is there any setting we need to do to identify COMMA " , " as thousand separator and DOT ( . ) as decimal place in netweaver gateway . I have tried to set this in SU3 (User specific settings in both Netweaver Gateway and back end BW system however this did not solve my problem.

Our Netweaver gateway server is Unicode system and the back end SAP BW system is Non-Unicode system. Is there any setting that needs to be set for this issue?

Appreciate your help.

Below is the complete error log.

<?xml version="1.0" encoding="utf-8" ?>

- <SAPGW_ERROR_LOG>

- <item timestamp="20140523071748">

- <ERROR_DATA>

<SAPCLIENT>100</SAPCLIENT>

<OPID>537C98FC266B1270E1008000911132D1</OPID>

<SUBNO>1</SUBNO>

<USERNAME>ZS224ABAPDEV</USERNAME>

<TIMESTAMP>20140523071748.631168</TIMESTAMP>

<ERROR_COUNT>1</ERROR_COUNT>

<FIRST_TSTMP>20140523071748.631168</FIRST_TSTMP>

<EXPIRY_DATE>2014-06-06</EXPIRY_DATE>

<T100_MSGID>/IWFND/CM_CONSUMER</T100_MSGID>

<T100_MSGNO>122</T100_MSGNO>

<LOCATION>G</LOCATION>

<ERROR_TEXT>The argument '6.925.8477300000' cannot be interpreted as a number</ERROR_TEXT>

<ERROR_COMPONENT>OPU-BSE-SDE</ERROR_COMPONENT>

<ERROR_PACKAGE>/IWBEP/ANA_ADP_ODATA</ERROR_PACKAGE>

<SOURCE_PROGRAM>/IWBEP/CL_ANA_ODATA_DATA======CP</SOURCE_PROGRAM>

<SOURCE_INCLUDE>/IWBEP/CL_ANA_ODATA_DATA======CM002</SOURCE_INCLUDE>

<SOURCE_LINE>24</SOURCE_LINE>

<NAMESPACE>/SAP/</NAMESPACE>

<SERVICE_NAME>***Hide_due_to_secure_log_level***</SERVICE_NAME>

<TRANSACTION_ID>537C989B266B1270E1008000911132D1</TRANSACTION_ID>

<REMOTE_ADDRESS>127.0.0.1</REMOTE_ADDRESS>

<DESTINATION>NONE</DESTINATION>

<REQUEST_URI>/sap/opu/odata/sap/***Hide_due_to_secure_log_level***</REQUEST_URI>

<BALOGNO>00000000000000122360</BALOGNO>

<LOCAL_DATE>2014-05-23</LOCAL_DATE>

<LOCAL_TIME>12:47:48</LOCAL_TIME>

<FIRST_DATE>2014-05-23</FIRST_DATE>

<FIRST_TIME>12:47:48</FIRST_TIME>

<ICF_NODE>odata</ICF_NODE>

<REQUEST_ID>537D9B9721C10900E1008000911132D1</REQUEST_ID>

<LOG_LEVEL>S</LOG_LEVEL>

</ERROR_DATA>

- <ERROR_CONTEXT>

<ERROR_INFO>The argument '6.925.8477300000' cannot be interpreted as a number</ERROR_INFO>

<_-IWCOR_-CX_DS_INTERNAL_ERROR />

- <CX_SY_NO_HANDLER>

<CLASSNAME>CX_SY_CONVERSION_NO_NUMBER</CLASSNAME>

</CX_SY_NO_HANDLER>

- <CX_SY_CONVERSION_NO_NUMBER>

<VALUE>6.925.8477300000</VALUE>

</CX_SY_CONVERSION_NO_NUMBER>

- <SERVICE_INFO>

<NAMESPACE>/SAP/</NAMESPACE>

<VERSION>0001</VERSION>

<SERVICE_NAME>***Hide_due_to_secure_log_level***</SERVICE_NAME>

<REQUEST_DIRECTION>Consumer to Gateway</REQUEST_DIRECTION>

<AGENT>SAP Netweaver Gateway Logger</AGENT>

<SYSTEM_ALIAS>BQ3</SYSTEM_ALIAS>

<DESTINATION>NONE</DESTINATION>

</SERVICE_INFO>

- <SYSTEM_INFO>

<REQUEST_ID>537D9B9721C10900E1008000911132D1</REQUEST_ID>

<REQUEST_URI>/sap/opu/odata/sap/***Hide_due_to_secure_log_level***</REQUEST_URI>

<REMOTE_ADDRESS>127.0.0.1</REMOTE_ADDRESS>

<APPLICATION_SERVER>BWsap121_BR1_04</APPLICATION_SERVER>

</SYSTEM_INFO>

</ERROR_CONTEXT>

- <CALL_STACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>/IWFND/CL_SODATA_ROOT_HANDLER=CP</MAINPROGRAM>

<INCLUDE>/IWFND/CL_SODATA_ROOT_HANDLER=CM007</INCLUDE>

<LINE>17</LINE>

<BLOCKTYPE>METHOD</BLOCKTYPE>

<BLOCKNAME>HANDLE_ERROR</BLOCKNAME>

<LEVELNO>7</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>/IWCOR/CL_DS_HDLR_ROOT========CP</MAINPROGRAM>

<INCLUDE>/IWCOR/CL_DS_HDLR_ROOT========CM00G</INCLUDE>

<LINE>18</LINE>

<BLOCKTYPE>METHOD</BLOCKTYPE>

<BLOCKNAME>HANDLE_EXCEPTION</BLOCKNAME>

<LEVELNO>6</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>/IWCOR/CL_DS_HDLR_ROOT========CP</MAINPROGRAM>

<INCLUDE>/IWCOR/CL_DS_HDLR_ROOT========CM009</INCLUDE>

<LINE>204</LINE>

<BLOCKTYPE>METHOD</BLOCKTYPE>

<BLOCKNAME>/IWCOR/IF_REST_HANDLER~HANDLE</BLOCKNAME>

<LEVELNO>5</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>/IWCOR/CL_REST_HTTP_HANDLER===CP</MAINPROGRAM>

<INCLUDE>/IWCOR/CL_REST_HTTP_HANDLER===CM001</INCLUDE>

<LINE>103</LINE>

<BLOCKTYPE>METHOD</BLOCKTYPE>

<BLOCKNAME>IF_HTTP_EXTENSION~HANDLE_REQUEST</BLOCKNAME>

<LEVELNO>4</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>CL_HTTP_SERVER================CP</MAINPROGRAM>

<INCLUDE>CL_HTTP_SERVER================CM00I</INCLUDE>

<LINE>627</LINE>

<BLOCKTYPE>METHOD</BLOCKTYPE>

<BLOCKNAME>EXECUTE_REQUEST</BLOCKNAME>

<FLAG_SYSTEM>X</FLAG_SYSTEM>

<LEVELNO>3</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>SAPLHTTP_RUNTIME</MAINPROGRAM>

<INCLUDE>LHTTP_RUNTIMEU02</INCLUDE>

<LINE>1218</LINE>

<BLOCKTYPE>FUNCTION</BLOCKTYPE>

<BLOCKNAME>HTTP_DISPATCH_REQUEST</BLOCKNAME>

<FLAG_SYSTEM>X</FLAG_SYSTEM>

<LEVELNO>2</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

- <_-IWFND_-SUTIL_CALLSTACK>

<MAINPROGRAM>SAPMHTTP</MAINPROGRAM>

<INCLUDE>SAPMHTTP</INCLUDE>

<LINE>13</LINE>

<BLOCKTYPE>MODULE (PBO)</BLOCKTYPE>

<BLOCKNAME>%_HTTP_START</BLOCKNAME>

<FLAG_SYSTEM>X</FLAG_SYSTEM>

<LEVELNO>1</LEVELNO>

</_-IWFND_-SUTIL_CALLSTACK>

</CALL_STACK>

- <REQUEST_DATA>

- <HTTP_HEADER>

- <IHTTPNVP>

<NAME>~request_method</NAME>

<VALUE>GET</VALUE>

</IHTTPNVP>

- <IHTTPNVP>

<NAME>~request_uri</NAME>

<VALUE>/sap/opu/odata/sap/***Hide_due_to_secure_log_level***</VALUE>

</IHTTPNVP>

- <IHTTPNVP>

<NAME>host</NAME>

<VALUE>BWsap121:8000</VALUE>

</IHTTPNVP>

- <IHTTPNVP>

<NAME>~remote_addr</NAME>

<VALUE>127.0.0.1</VALUE>

</IHTTPNVP>

</HTTP_HEADER>

<HTTP_BODY />

</REQUEST_DATA>

- <RESPONSE_DATA>

<HTTP_CODE>500</HTTP_CODE>

<HTTP_REASON>Internal Server Error</HTTP_REASON>

- <HTTP_HEADER>

- <IHTTPNVP>

<NAME>content-type</NAME>

<VALUE>application/xml</VALUE>

</IHTTPNVP>

- <IHTTPNVP>

<NAME>dataserviceversion</NAME>

<VALUE>1.0</VALUE>

</IHTTPNVP>

</HTTP_HEADER>

<HTTP_BODY>***Hide_due_to_secure_log_level***</HTTP_BODY>

</RESPONSE_DATA>

</item>

</SAPGW_ERROR_LOG>

Thanks

Manjunath