on 09-18-2006 3:56 PM
I saw that Reiner has reloaded I also opened an OSS note. My problem is when calling an RFC function I do not get error, bigger problem; Server Application Unavailable error. and when I have checked EventViewer, the error is "aspnet_wp.exe stopped unexpectedly" error.
Web Config file :
<Entry DestinationName="A" AppServerHost="*" SystemNumber="0"
Username="" Password="" Client="60">
</Entry>
<Entry DestinationName="B" AppServerHost="*" SystemNumber="0"
Username="" Password="" Client="60">
</Entry>
<Entry DestinationName="C" AppServerHost="*" SystemNumber="0"
Username="" Password="" Client="30">
</Entry>
<Entry DestinationName="D" AppServerHost="*" SystemNumber="0"
Username="" Password="" Client="30">
</Entry>
<Entry DestinationName="E" AppServerHost="*" SystemNumber="0"
Username="" Password="" Client="30">
</Entry>
</Destinations>
</Connector>
</SAP>
.cs file is:
VEP proxy = new VEP();
Connection connection = SAPConnectionPool.GetConnection
(Config.Instance.GetDestinationByName("A"));
proxy.Connection = connection;
connection = null;
if (!proxy.Connection.IsOpen)
proxy.Connection.Open();
proxy.Z_Dıs_Run_Report(reportName, userName, out _ayrintiliSonuc, out
sonuc, ref resultSetSAP, ref parametersSAP);
SAP Function is:
Import:
USERID LIKE ZDIS_USERS_INFO-USERID
RAPOR LIKE RS38M-PROGRAMM
Export:
SONUC TYPE CHAR2
AYRINTILI_SONUC TYPE CHAR100
Tables:
PARAMETRELER LIKE RSPARAMS
BUFFER LIKE ZSTRINGS5
Code:
FUNCTION Z_DIS_RUN_REPORT.
*"----
""Local interface:
*" IMPORTING
*" VALUE(USERID) LIKE ZDIS_USERS_INFO-USERID
*" VALUE(RAPOR) LIKE RS38M-PROGRAMM
*" EXPORTING
*" VALUE(SONUC) TYPE CHAR2
*" VALUE(AYRINTILI_SONUC) TYPE CHAR100
*" TABLES
*" PARAMETRELER STRUCTURE RSPARAMS
*" BUFFER STRUCTURE ZSTRINGS5
*"----
-
DATA: MYTABLE LIKE ABAPLIST OCCURS 0 WITH HEADER LINE.
DATA : BEGIN OF MYTABLESON OCCURS 0,
LINE(255),
END OF MYTABLESON.
DATA : I TYPE I.
****************************************************
REFRESH BUFFER.
IF RAPOR EQ 'ZMMR0181'.
IF USERID = '202455'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'ZDIS'.
ENDIF.
IF USERID = '201796'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'ZDIS2'.
ENDIF.
IF USERID = '202575'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'ZDIS3'.
ENDIF.
IF USERID = '206765'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'ZDIS4'.
ENDIF.
IF USERID = '207643'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'ZDIS5'.
ENDIF.
IF USERID = '201142'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'ZDIS6'.
ENDIF.
ELSEIF RAPOR EQ 'ZD23_WEB'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'TÜM FATURALAR'.
ELSEIF RAPOR EQ 'ZSDR0250_K2'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER
USING SELECTION-SET 'HG'.
ELSEIF RAPOR EQ 'ZPPYS011'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN.
elseif rapor eq 'ZPPYS020'.
if userid = '206765'.
submit (rapor) exporting list to memory and return
with selection-table parametreler
using selection-set 'ODS'.
elseif userid = '207643'.
submit (rapor) exporting list to memory and return
with selection-table parametreler
using selection-set 'ODSEL'.
*
endif.
ELSEIF RAPOR EQ 'AQ60PS==========04============'.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER.
ELSE.
SUBMIT (RAPOR) EXPORTING LIST TO MEMORY AND RETURN
WITH SELECTION-TABLE PARAMETRELER.
ENDIF.
IF SY-SUBRC NE 0.
BUFFER = 'Kayıt Bulunamadı!'.
APPEND BUFFER.
REFRESH PARAMETRELER.
EXIT.
ENDIF.
CALL FUNCTION 'LIST_FROM_MEMORY'
TABLES
LISTOBJECT = MYTABLE
EXCEPTIONS
NOT_FOUND = 1.
IF SY-SUBRC NE 0.
BUFFER = 'Kayıt Bulunamadı!'.
APPEND BUFFER.
REFRESH PARAMETRELER.
EXIT.
ENDIF.
CALL FUNCTION 'LIST_TO_ASCI'
TABLES
LISTASCI = MYTABLESON
LISTOBJECT = MYTABLE
EXCEPTIONS
EMPTY_LIST = 1
LIST_INDEX_INVALID = 2.
IF SY-SUBRC = 0.
LOOP AT MYTABLESON.
CLEAR BUFFER.
BUFFER = MYTABLESON.
APPEND BUFFER.
ENDLOOP.
ELSE.
BUFFER = 'Kayıt Bulunamadı!'.
APPEND BUFFER.
ENDIF.
REFRESH PARAMETRELER.
ENDFUNCTION.
When the
proxy.Z_Dıs_Run_Report(reportName, userName, out _ayrintiliSonuc, out
sonuc, ref resultSetSAP, ref parametersSAP);
is called, we are getting error as :
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web
browser to retry your request.
Administrator Note: An error message detailing the cause of this
specific request failure can be found in the application event log of
the web server. Please review this log entry to discover what caused
this error to occur.
And the Evet Viewer of application is:
Event Type: Error
Event Source: ASP.NET 1.1.4322.0
Event Category: None
Event ID: 1000
Date: 12.09.2006
Time: 08:18:40
User: N/A
Computer: *
Description:
aspnet_wp.exe (PID: 2232) stopped unexpectedly.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
And Deneme.trc file is
2006-09-12 08:48:53Z Trace file opened.
2006-09-12 08:48:53Z Allowed to fetch new.
2006-09-12 08:48:53Z AllocReservation: 0
2006-09-12 08:48:54Z Call method Z_Dıs_Check_User
2006-09-12 08:48:54Z Found right now.
2006-09-12 08:48:54Z Call method Z_Dıs_Brıng_Reports_Lıst
2006-09-12 08:48:54Z Allowed to fetch new.
2006-09-12 08:48:54Z AllocReservation: 1
2006-09-12 08:48:54Z Call method Z_Dıs_Brıng_Reports_Lıst
2006-09-12 08:48:55Z Allowed to fetch new.
2006-09-12 08:48:55Z AllocReservation: 2
2006-09-12 08:48:55Z Call method Z_Dıs_Brıng_Reports_Lıst
2006-09-12 08:48:55Z Found right now.
2006-09-12 08:48:55Z Call method Z_Dıs_Brıng_Fıles_Lıst
2006-09-12 08:48:55Z Found right now.
2006-09-12 08:48:55Z Call method Z_Dıs_Brıng_Fıles_Lıst
2006-09-12 08:48:55Z Found right now.
2006-09-12 08:48:55Z Call method Z_Dıs_Brıng_Fıles_Lıst
2006-09-12 08:49:00Z Found right now.
2006-09-12 08:49:00Z Call method Z_Dıs_Run_Report
Hi Huseyin,
Did you allready find a solution for your problem?
We are exactly having the same problem here with .NET connector and our ERP2005 system.
Thank you for your feedback.
Br,
Tom.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Huseyin:
Do you verified the IIS and ASP.net was installa correctly? This error is associted with this enviroment.
On other hand, I recoment reemplace the code line
Connection connection = SAPConnectionPool.GetConnection
(Config.Instance.GetDestinationByName("A"));
To
Connection connection = SAPConnectionPool.GetConnectionFromPool
(Config.Instance.GetDestinationByName("A"));
GetConnectionFromPool() metod use the internal ConnectionPool of SAP.Connector, this functionality configurated in webconfig.
Regards
Sergio
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.