Автор | Сообщение | ||
---|---|---|---|
Заголовок сообщения: Не могу войти SAP Logon Добавлено: Пн, авг 04 2008, 12:52 |
|||
Зарегистрирован: |
с ftp://ftp.sap.com/pub/sdn/devkits/netweaver/abap взял SAPNW7.0ABAPTrialSP12 + с ftp://ftp.sap.com/pub/sdn/devkits/netweaver/java/ взял SAPNW2004sDevWorkplaceSR2Preview === 1. Установил Microsoft Loopback Adapter + в C:WINDOWSsystem32driversetchosts добавил все что надо. 2. Установил все єто дело по инструкции 3. Бутнулся. 4. Запустил sapmmc и поднял сервис (где-то за 5 минут поднялось) Портал работает: http://localhost:50000/index.html — есть страница. Все фуричит и пускает. А вот зайти через SAP Logon не могу. Говорит: ================== partner ‘127.0.0.1:sapdb00’ not reached WSAECONNREFUSED: Conncetion refused ================== Component NI (Network Interface) Release 710 Version 39 Module nixxi.cpp Line 2985 Method NiPConnect2 ReturnCode -10 SystemCall Connect Error No 10061 Error Text WSAECONNREFUSED: Conncetion refused Counter 1 ================== В Application Server я вписывал и localhost и 127.0.0.1 и имя ПК System Number: 00 i 01 System ID: J2E i NSP Sap Router String оставляю всегда пустую. ================== Конекчусь с той же машини. firewall отключен Многоуважаемые All, подскажите что подкрутить?
|
||
Вернуться к началу |
|
||
dussel |
Заголовок сообщения: Добавлено: Пн, авг 04 2008, 13:05 |
||
Зарегистрирован: |
Причем если я напишу заведомо неправильный хост Application Server’a -> localhosttt ошибка будет другая: =================== hostname ‘localhosttt’ unknown Check yoapplication server name =================== Component NI Module ninti.c Line 895 Method NiPGetHostByNmae: ‘localhosttt’ not found Return Code -2
|
||
Вернуться к началу |
|
||
Tetty |
Заголовок сообщения: Добавлено: Пн, авг 04 2008, 13:35 |
Зарегистрирован: |
dussel написал(а): Причем если я напишу заведомо неправильный хост Application Server’a -> localhosttt попробуйте написать заведомо неправильный номер инстанции я бы начал с того, что убедился в жизнеспособности ABAP-стека, посмотрев это в SLD
|
Вернуться к началу |
|
dussel |
Заголовок сообщения: Добавлено: Пн, авг 04 2008, 13:45 |
||
Зарегистрирован: |
Tetty написал: dussel написал(а): Причем если я напишу заведомо неправильный хост Application Server’a -> localhosttt попробуйте написать заведомо неправильный номер инстанции я бы начал с того, что убедился в жизнеспособности ABAP-стека, посмотрев это в SLD Говорит то же что и в первом варианте: Говорит: ================== partner ‘127.0.0.1:sapdb00’ not reached WSAECONNREFUSED: Conncetion refused ================== Component NI (Network Interface) Release 710 Version 39 Module nixxi.cpp Line 2985 Method NiPConnect2 ReturnCode -10 SystemCall Connect Error No 10061 Error Text WSAECONNREFUSED: Conncetion refused Counter 1 ================== В Application Server я вписывал и localhost и 127.0.0.1 и имя ПК System Number: 00 i 01 System ID: J2E i NSP Sap Router String оставляю всегда пустую. ==================
|
||
Вернуться к началу |
|
||
Vit |
Заголовок сообщения: Добавлено: Пн, авг 04 2008, 14:55 |
Зарегистрирован: |
dussel написал(а): ================== В Application Server я вписывал и localhost и 127.0.0.1 и имя ПК Может быть сервис должен быть sapdp00 ? Т.е. порт 3200.
|
Вернуться к началу |
|
dussel |
Заголовок сообщения: Добавлено: Пн, авг 04 2008, 15:35 |
||
Зарегистрирован: |
Vit написал: dussel написал(а): ================== В Application Server я вписывал и localhost и 127.0.0.1 и имя ПК Может быть сервис должен быть sapdp00 ? Т.е. порт 3200. А где этот сервис «sapdp00» и порт «3200» указывать?? Application Server — тут хост, если ему через двокрапку прилепить порт, он ругается. System Number тут два знака, по умолчанию «00» System ID — тут три буквы, тоже не засунешь «sapdp00».. Сранно это все как-то.
|
||
Вернуться к началу |
|
||
dussel |
Заголовок сообщения: Добавлено: Пн, авг 04 2008, 16:58 |
||
Зарегистрирован: |
|||
Вернуться к началу |
|
||
stayer |
Заголовок сообщения: Добавлено: Вт, авг 05 2008, 07:11 |
Зарегистрирован: |
напиши мне по аське (291701549) , спишемся, помогу настроить
|
Вернуться к началу |
|
leonik |
Заголовок сообщения: Re: Не могу войти SAP Logon Добавлено: Вт, авг 05 2008, 08:10 |
Зарегистрирован: |
dussel написал(а): 1. Установил Microsoft Loopback Adapter + в C:WINDOWSsystem32driversetchosts добавил все что надо. Говорит: В Application Server я вписывал и localhost и 127.0.0.1 и имя ПК Соединение настроено некорректно, подключение посмотреть можно здесь http://deenryz.narod.ru/VirtualLoop.html В настройках саплогона, вместо 127.0.0.1 необходимо прописать имя хоста, указанного в services, либо 10.10.0.10.
|
Вернуться к началу |
|
Vitaly_81 |
Заголовок сообщения: Re: Не могу войти SAP Logon Добавлено: Пн, мар 16 2009, 10:00 |
Зарегистрирован: |
Коллеги! Помогите плиз.Удалось её решить и как? Спасибо.
|
Вернуться к началу |
|
Vitaly_81 |
Заголовок сообщения: Re: Не могу войти SAP Logon Добавлено: Вт, мар 17 2009, 13:59 |
Зарегистрирован: |
Вопрос решился базу в SAPMMC с другой машины.
|
Вернуться к началу |
|
Dear Colleagues,
We are planning to use QlikView in our organization. We decided to build apps based on data from SAP. For this reason we are using QlikVIew SAP connector version 6.2 and SAP version is 7.4 .
We have followed all the instructions from the QlikView SAP connector manual. We have created user QTQVCACCESS with all the roles and imported all transports to SAP. Also, created needed extractors.
We were able to successfully connect to SAP BW and get some data using SQL connector.
However, we are facing some issues when we try to use extractors. We were facing different errors.
Which we solved by adding proper records in hosts and services files. Also, we have added all grants in saproutertab
Currently we stopped at this error and could not find any way around it.
Could you, please, share some thought and ideas on solving this issue.
Below is the content of log file.
Thank you.
2017-08-23 16:39:45 Connector: C:Program FilesCommon FilesQlikTechCustom DataQvSAPConnectorQvSAPEXTRConnector.dll Ver: 6.2.0+Build:02016.origin/release/6.2.0
2017-08-23 16:39:45 Using Server Host: localhost , Port: 8680
2017-08-23 16:39:45 Socket timeout parameter (s): 900
2017-08-23 16:39:45 Socket created OK
2017-08-23 16:39:45 DNS: getaddrinfo
2017-08-23 16:39:45 Connected to SAP (ASHOST): /H/172.*/H/172.*
2017-08-23 16:39:45 Making new SAP Request
2017-08-23 16:39:45 EXTRACTOR = /CPMB/8IZIKSKQ
2017-08-23 16:39:45 TFRMETHOD = T
2017-08-23 16:39:45 UPDMODE = C
2017-08-23 16:39:45 EXTRLANGUAGE = R
2017-08-23 16:39:45 LOGSYS = QTQVCEXTR1
2017-08-23 16:39:45 EXTRACTOR /CPMB/8IZIKSKQ#TFRMETHOD T#UPDMODE C#EXTRLANGUAGE R#LOGSYS QTQVCEXTR1#WHERE#/B28/S_IZDBJ7T I EQ 2017.6#
2017-08-23 16:39:45 TimeoutSAP : 14400
2017-08-23 16:39:45 TimeoutInit : 900
2017-08-23 16:39:45 TimeoutActivity: 7200
2017-08-23 16:39:45 TimeoutData : 3600
2017-08-23 16:39:45 TCPBufSize : 1024
2017-08-23 16:40:07 Err FAILED Error:
LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR partner ‘172.*:sapgw00’ not reached
TIME Wed Aug 23 16:40:07 2017
RELEASE 720
COMPONENT NI (network interface)
VERSION 40
RC -10
MODULE nixxi.cpp
LINE 3271
DETAIL NiPConnect2: 172.*.*.*:3300
SYSTEM CALL connect
ERRNO 10060
ERRNO TEXT WSAETIMEDOUT: Connection timed out
COUNTER 1
2017-08-23 16:40:09 Disconnected
2017-08-23 16:40:11 Closing the Socket
Hi All,
When I started sap gui at client (Win Me) there is error window popup =
like below.
partner not reached (host 203.151.12.54,service sapdp00)
Time Thu Aug 07 16:26:01 2003
Release 46D
Component NI (network interface)
Version 34
Return Code -10
Module ninti.c
Line 1008
Detail NiPConnect2
System Call SO_ERROR
Error No 10065
Error Text WSAEHOSTUNREACH: No route to host
Counter 1
[ OK ]
The server 203.151.12.54 is Solaris 8.
I could ping from this client to the server 203.151.12.54.=20
I could telnet to server 203.151.12.54.
There is sapdp00 in services file.
This client is a new one.=20
The others clients could connect to server (via same version of sap =
gui).
The same ip address of this client (the error one) could connect to =
server when I used the old client that could connected to set to this ip =
address.
If any one could help please suggest me.
Best regards,
Nopporn
Read these next…
WINDOWS 10 «glitch» — file explorer
Windows
Hi.I have been experiencing a black line (glitch) on my file explorer which comes for milliseconds then it goes away. See screen grab. Is there anyone who has experienced such and how were they able to solve it?Thank you.
Are you updating workstations to Windows 11?
Windows
Has anyone started updating workstations on a AD domain to Windows 11? what type of issues are you facing?What is the user reaction been?Thanks!
Snap! — Psyche Probe, DIY Gene Editing, RaiBo, AI handwriting, Metric Pirates
Spiceworks Originals
Your daily dose of tech news, in brief.
Welcome to the Snap!
Flashback: January 27, 1880: Thomas Edison receives patent for the Electric Lamp. (Read more HERE.)
Bonus Flashback: January 27, 1967: Apollo 1 Tragedy (Read more HERE.)
You …
NEC Inmail Email doesn’t Change
Collaboration
Hey Everyone,Recently a client of mine wanted to change the email to their QA extension to her email as to help keep voicemails consolidated instead of spread out among different emails. Normally this wouldn’t be a huge deal. Logged in to to Webpro, hoppe…
I inherited some really cool equipment. I just have no clue how to use it!
Hardware
So I’ve got some switches, and some servers. The switches seem pretty straight forward, plug in packet go zoom, but I have no clue how these servers work. They’re headless rack servers. I know there must be a way to get some kind of UI going with a monito…
I’m Having a problem establishing a connection to SAP in my java program.
I’m following the examples that come in the JCO download but i always get this error:
com.sap.conn.jco.JCoException: (102) RFC_ERROR_COMMUNICATION: Connect to SAP gateway failed
Connection parameters: TYPE=A DEST=ABAP_AS_WITHOUT_POOL ASHOST=xx.xx.x.xx SYSNR=00 PCS=1
LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR partner 'xx.xx.x.xx:3300' not reached
TIME Wed Jul 08 08:18:28 2015
RELEASE 711
COMPONENT NI (network interface)
VERSION 39
RC -10
MODULE nixxi.cpp
LINE 3147
DETAIL NiPConnect2: xx.xx.x.xx:3300
SYSTEM CALL connect
ERRNO 10060
ERRNO TEXT WSAETIMEDOUT: Connection timed out
COUNTER 2
I don’t know what it can be, i’m writing down the correct connection properties (ashost,user,passwd,sysnr,etc).
Has anybody else has had a problem like this?
This is my connection code:
Properties connectProperties = new Properties();
connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "xx.xx.x.xx");
connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "00");
connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "020");
connectProperties.setProperty(DestinationDataProvider.JCO_USER, "xxxxxx");
connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "xxxxxxx");
connectProperties.setProperty(DestinationDataProvider.JCO_LANG, "en");
createDataFile(ABAP_AS, "jcoDestination", connectProperties);
After that i just instantiate the object with those properties and call the method connect that is written like this:
JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS);
System.out.println("Attributes:");
System.out.println(destination.getAttributes());
System.out.println();
I’m working on Java, using netbeans, the sapjco3.jar is added to my libraries.
Do i have to do anything with the dll file that comes?
“resource temporarily unavailable”
or “connection refused”
- Error Details
“connection pending after…”
or “connection refused”
The issue can occur when logon load balance is used or not. The only difference is to where the hostname used should be pointing (directly to an ABAP instance or to the Message Server).
The target port would be different too:
— For a direct connection to an ABAP instance, the port is 32XX (where “XX” is the instance number).
— When logon load balance is used, the initial connection to the Message Server is done to the port 36XX by default.
— The “services” file is not needed anymore, at the frontend computer. With the new SAPUILandscape.xml file in SAP Logon, the port numbers are stored in the SAPUILandscape.xml file itself.
If the SAPUILandscape.xml is not used and an entry is being added manually, then provide the port number together with the Message Server hostname using the syntax “hostname:port” (for example: n52test.example.com:3655).
Possible root cause #1: configuration issue.
- Possible solution: confirm that the hostname and Instance Number (or port number, if logon load balance is used) are correct.
- SAP Support component: if this is a configuration problem with the port number and hostname not getting stored in the SAPUILandscape.xml, then BC-FES-GUI can help.
Possible root cause #2: DNS/Network/Firewall issue.
- Possible solution: involve the DNS/network/firewall team, so they fix the issue.
- SAP Support component: being something related to customer’s network / infrastructure, BC-NET can provide some guidance.
Possible root cause #3: the target SAP system is down
- Possible solution: confirm that the target SAP system is up or start it.
- SAP Support component: BC-CST-STS can assist with starting it up, if required.
Additional tests that can be performed :
- “ping <hostname>” – confirm that the IP address returned by “ping” is correct:
- Use the «Test-NetConnection» PowerShell command to perform a connectivity test
PS C:> Test-NetConnection -Port 3200 -ComputerName n52test.example.com ComputerName : n52test.example.com RemoteAddress : 10.47.60.245 <<<<<< IS THIS THE CORRECT IP OF THE SAP SERVER? RemotePort : 3200 InterfaceAlias : Ethernet 3 SourceAddress : (IP address of client computer here) TcpTestSucceeded : False <<<<<< HAS THE TEST SUCCEEDED (RESULT IS 'TRUE')? OR DID IT FAIL (RESULT IS 'FALSE')? PS C:>
- “telnet <hostname> <32xx or 36xx>”, where “xx” is the Instance Number. The “telnet” tool is delivered by the operating system, not by SAP.
If “telnet” is able to connect, the whole window becomes “empty”, like:
- Confirm that the backend system is up and running by logging on to the server at operating system level, either with “SIDadm” (or with a local administrator, on Windows servers), and executing the command below at a command prompt window started “as administrator” (“XX” is the instance number):
-
sapcontrol -nr XX -function GetProcessList
On Windows servers, it might be required to add “-prot PIPE” to the command line:
sapcontrol -prot PIPE -nr XX -function GetProcessList
-
- Confirm that the correct Message Server port number is used. With the new SAPUILandscape.xml file, the “services” file is not needed at the frontend computer, and the correct port number should be stored in the SAPUILandscape.xml file.
-
At the target SAP system, execute the transaction SMMS. The information on the header should reveal the port number:
-
If the SAP version is old, the header would not be there. Then, get the “dev_ms” trace file and verify the port number at the beginning of the trace. Example:
trc file: «dev_ms», trc level: 1, release: «753»
[Thr 5592] Wed Jul 01 14:28:32 2020
[Thr 5592] SAP_RELEASE = 753
[Thr 5592] compatibility level = 0
[Thr 5592] Server state INIT
[Thr 5592] MsSSetTrcLog: trc logging active, max size = 52428800 bytes
[Thr 5592] * SWITCH TRC-RESOLUTION from 1 to 10
systemid 562 (PC with Windows NT)
relno 7530
patchlevel 0
patchno 602
intno 20170305
make multithreaded, Unicode, 64 bit, optimized
pid 3808
[Thr 5592] Wed Jul 1 14:28:32:668 2020
[Thr 5592] ***LOG Q01=> MsSInit, MSStart (Msg Server 1 3808) [msxxserv.c 2752]
[Thr 5592] load acl file = D:usrsapN50SYSglobalms_acl_info.DAT
[Thr 5592] List of entries found in D:usrsapN50SYSglobalms_acl_info.DAT
[Thr 5592] [001] * [::] (VALID)
[Thr 5592] MsGetOwnIpAddr: my host addresses are :
[Thr 5592] 1 : [10.180.200.17] (HOSTNAME)
[Thr 5592] 2 : [127.0.0.1] (LOCALHOST)
[Thr 5592] MsHttpInit: full qualified hostname = testn50
[Thr 5592] HTTP logging is switch off
[Thr 5592] set HTTP state to LISTEN
[Thr 5592] *** HTTP port 8101 state LISTEN ***
[Thr 5592] *** I listen to port sapmsN50 (3601) ***
[Thr 5592] *** I listen to internal port 3901 (3901) ***
[Thr 5592] *** HTTP port 8101 state LISTEN ***
[Thr 5592] CUSTOMER KEY: >C1861165945<
[Thr 5592] compatibility level = 0
[Thr 5592] build version=753.2019.10.18
[Thr 5592] read logon groups from previously stored file N50_msg_server_adtl_storage
[Thr 5592] Server state ACTIVE
[Thr 5592] Wed Jul 1 14:28:51:411 2020
(…)
- The SAP wiki https://wiki.scn.sap.com/wiki/x/OQV8GQ lists options of how to get the trace files of the backend server. The port number could also be obtained from ‘services’ file on SAP server where the Message Server is running.
Правила форума
ВНИМАНИЕ! Прежде чем задавать вопрос, ознакомьтесь со ссылками ниже:
Вопросы по отличиям версий SAP, Add-On, EHP — сюда
Вопросы по SAP Front End (SAPlogon, SAPgui, guiXT и т.д.) — сюда
Вопросы по LSMW — сюда
Вопросы по архивации в SAP — сюда
Вопросы по SAP GRC — сюда
Вопросы по SAP Business Workplace (почте SAP) и SAP Office — сюда
Вопросы по miniSAP (SAP mini basis) — сюда
Вопросы по SAP HANA — сюда
Вопросы по лицензированию продуктов SAP — сюда
Автор | Сообщение | ||
---|---|---|---|
Заголовок сообщения: Нет подключения к saprouter Добавлено: Вс, дек 21 2014, 16:34 |
|||
|
Пытаюсь зайти в SAP систему. Выдается ошибка partner …:3299 not reached (Err no 10035, Err txt WSAEWOULDBLOCK: Resource temporarily unavailable)
|
||
Вернуться к началу |
|
||
шрам |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Вс, дек 21 2014, 16:38 |
|
Вы хвалитесь или жалуетесь?
|
Вернуться к началу |
|
nrv |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Пн, дек 22 2014, 13:47 |
||
|
Вопрос — на что нужно посмотреть, чтобы выявить причину такого поведения.
|
||
Вернуться к началу |
|
||
basiscons |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Пн, дек 22 2014, 14:12 |
||
|
на сеть, например. не стоит ли где на пути к 3299 порту сетевой фильтр, более известный как файрвол.
|
||
Вернуться к началу |
|
||
nrv |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Пн, дек 22 2014, 16:01 |
||
|
как можно определить наличие фильтра? в случае сотовый телефон в режиме модема — файрвола нет, провайдер сотовой связи может блокировать порт?
|
||
Вернуться к началу |
|
||
RikoNw |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Пн, дек 22 2014, 17:16 |
|
80% проблем людей — проблемы понимания при общении. у вас там какие-то роутеры, вы через них как-то ходите, а потом через телефон ходите. то ли роутеры во вне смотрят, то ли телефон к местной wi-fi, то ли еще чего. Опишите обстановку точнее.
|
Вернуться к началу |
|
nrv |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Пн, дек 22 2014, 18:31 |
||
|
Ok. Есть saprouter для подключения к sap системе. У него публичный ip. Этот ip доступен при проверке утилитами ping, tracert. Я пытаюсь подключиться к нему с помощью sapgui. Не подключается. Варианты — закрыты порты на роутере. Либо фильтруется провайдером. Вот и возник вопрос, каким образом можно найти что блокирует доступ? А в первом посте я написал о том, что подключение работает в одном из четырех разных выходах в интернет.
|
||
Вернуться к началу |
|
||
nrv |
Заголовок сообщения: Re: Нет подключения к saprouter Добавлено: Пн, дек 22 2014, 20:31 |
||
|
вопрос закрыт. Прошу прощения, но все заработало само собой.
|
||
Вернуться к началу |
|
||
I’m Having a problem establishing a connection to SAP in my java program.
I’m following the examples that come in the JCO download but i always get this error:
com.sap.conn.jco.JCoException: (102) RFC_ERROR_COMMUNICATION: Connect to SAP gateway failed
Connection parameters: TYPE=A DEST=ABAP_AS_WITHOUT_POOL ASHOST=xx.xx.x.xx SYSNR=00 PCS=1
LOCATION CPIC (TCP/IP) on local host with Unicode
ERROR partner 'xx.xx.x.xx:3300' not reached
TIME Wed Jul 08 08:18:28 2015
RELEASE 711
COMPONENT NI (network interface)
VERSION 39
RC -10
MODULE nixxi.cpp
LINE 3147
DETAIL NiPConnect2: xx.xx.x.xx:3300
SYSTEM CALL connect
ERRNO 10060
ERRNO TEXT WSAETIMEDOUT: Connection timed out
COUNTER 2
I don’t know what it can be, i’m writing down the correct connection properties (ashost,user,passwd,sysnr,etc).
Has anybody else has had a problem like this?
This is my connection code:
Properties connectProperties = new Properties();
connectProperties.setProperty(DestinationDataProvider.JCO_ASHOST, "xx.xx.x.xx");
connectProperties.setProperty(DestinationDataProvider.JCO_SYSNR, "00");
connectProperties.setProperty(DestinationDataProvider.JCO_CLIENT, "020");
connectProperties.setProperty(DestinationDataProvider.JCO_USER, "xxxxxx");
connectProperties.setProperty(DestinationDataProvider.JCO_PASSWD, "xxxxxxx");
connectProperties.setProperty(DestinationDataProvider.JCO_LANG, "en");
createDataFile(ABAP_AS, "jcoDestination", connectProperties);
After that i just instantiate the object with those properties and call the method connect that is written like this:
JCoDestination destination = JCoDestinationManager.getDestination(ABAP_AS);
System.out.println("Attributes:");
System.out.println(destination.getAttributes());
System.out.println();
I’m working on Java, using netbeans, the sapjco3.jar is added to my libraries.
Do i have to do anything with the dll file that comes?
«Hi,
I cannot connect to System via SAPGUI. I an getting the error «partner not reached».
DB & SAP is up and running.
SAP Version 4.6c SR2 OS AIX 5.3.0.0.
System will stop and start successfully.
Please bear in mind that this System is 1 of 4 on an IBM 570 LPAR.
Personally I suspect that this is due to a «dispatcher» issue, but I am very limited when it comes to how, what way one can perform analyis on AIX. I would be greatful for any input.
the contents of dev_w0 / w1 are the same as shown below ( full log 2 big to ftp to my local machine )
C Fri Jan 23 21:07:48 2009
C curr. statement length: 8
C curr. statement length: 8
C
C Fri Jan 23 22:03:22 2009
C curr. statement length: 8
C
C Fri Jan 23 22:03:25 2009
C curr. statement length: 8
C
C Fri Jan 23 22:03:27 2009
C curr. statement length: 8
C curr. statement length: 8
C curr. statement length: 8
C
C Fri Jan 23 22:04:51 2009
C curr. statement length: 8
C curr. statement length: 8
Not much help there I know ….
Contents of dev_disp ( Why I suspect a dispatcher issue )
—————————————————
trc file: «dev_disp», trc level: 1, release: «46D»
—————————————————
Sat Jan 24 13:26:18 2009
relno 4640
patchlevel 0
patchno 2415
intno 0
pid 250022
***LOG Q00=> DpSapEnvInit, DPStart (03 250022) [dpxxdisp.c 921]
MtxInit: -2 0 0
*** ERROR => DpSysACreate: ShmCreate (CREATE) [dpxxtool2.c 488]
*** ERROR => dispatcher already running ???? [dpxxtool2.c 489]
*** ERROR => I better EXIT before I do any (more) damage [dpxxtool2.c 491]
SAP can connect to DB
Contents of trans.log
4 ETW000 R3trans version 6.05 (release 46D — 26.05.08 — 15:23:00).
4 ETW000 ==============================================4 ETW000
4 ETW000 control file:
4 ETW000 R3trans was called as follows: R3trans -d
4 ETW000 date&time : 24.01.2009 — 13:27:38
4 ETW000 trace at level 2 opened for a given file pointer
4 ETW000 [developertra,00000] Sat Jan 24 13:27:38 2009 66 0.000066
4 ETW000 [developertra,00000] db_con_init called 15 0.000081
4 ETW000 [developertra,00000] create_con (con_name=R/3) 89 0.000170
4 ETW000 [developertra,00000] Loading DB library ‘/usr/sap/PS2/SYS/exe/run/dboraslib.o’ …
4 ETW000 63 0.000233
4 ETW000 [developertra,00000] load shared library (/usr/sap/PS2/SYS/exe/run/dboraslib.o), hdl 0
4 ETW000 5215 0.005448
4 ETW000 [developertra,00000] Library ‘/usr/sap/PS2/SYS/exe/run/dboraslib.o’ loaded
4 ETW000 25 0.005473
4 ETW000 [developertra,00000] function DbSlExpFuns loaded from library /usr/sap/PS2/SYS/exe/run/dboraslib.o
4 ETW000 62 0.005535
4 ETW000 [developertra,00000] Version of library ‘/usr/sap/PS2/SYS/exe/run/dboraslib.o’ is «46D.00″, patchlevel (0.2417)
4 ETW000 767 0.006302
4 ETW000 [developertra,00000] function dsql_db_init loaded from library /usr/sap/PS2/SYS/exe/run/dboraslib.o
4 ETW000 25 0.006327
4 ETW000 [developertra,00000] function dbdd_exp_funs loaded from library /usr/sap/PS2/SYS/exe/run/dboraslib.o
4 ETW000 50 0.006377
4 ETW000 [developertra,00000] New connection 0 created 29 0.006406
4 ETW000 [developertra,00000] db_con_connect (con_name=R/3) 54 0.006460
4 ETW000 [developertra,00000] find_con found the following connection for reuse:
4 ETW000 48 0.006508
4 ETW000 [developertra,00000] Got ORACLE_HOME=/oracle/PS2/102_64 from environment
4 ETW000 699 0.007207
4 ETW000 [developertra,00000] —>oci_initialize 44 0.007251
4 ETW000 [developertra,00000] Got ORACLE_SID=PS2 from environment 93 0.007344
4 ETW000 [developertra,00000] Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment
4 ETW000 51 0.007395
4 ETW000 [developertra,00000] Logon as OPS$-user to get SAPR3’s password 40 0.007435
4 ETW000 [developertra,00000] Connecting as /@PS2 on connection 0 … (dbsl BIN 240908)
4 ETW000 77 0.007512
4 ETW000 [developertra,00000] —>oci_logon(con_hdl=0, user=», dbname=’PS2′) 44 0.007556
4 ETW000 [developertra,00000] Sat Jan 24 13:27:39 2009 83784 0.091340
4 ETW000 [developertra,00000] Now I’m connected to ORACLE using OCI_7 API 29 0.091369
4 ETW000 [developertra,00000] Got SAPR3’s password from table SAPUSER 1283 0.092652
4 ETW000 [developertra,00000] Disconnecting from connection 0 … 18 0.092670
4 ETW000 [developertra,00000] —>oci_logoff(con_hdl=0) 43 0.092713
4 ETW000 [developertra,00000] Now I’m disconnected from ORACLE 1144 0.093857
4 ETW000 [developertra,00000] Try to connect with the password I got from OPS$-user
4 ETW000 57 0.093914
4 ETW000 [developertra,00000] Connecting as SAPR3/@PS2 on connection 0 … (dbsl BIN 240908)
4 ETW000 44 0.093958
4 ETW000 [developertra,00000] —>oci_logon(con_hdl=0, user=’SAPR3′, dbname=’PS2′)
4 ETW000 22 0.093980
4 ETW000 [developertra,00000] Now I’m connected to ORACLE using OCI_7 API 69371 0.163351
4 ETW000 [developertra,00000] Database instance PS2 is running on ihalp11 with ORACLE version 10.2.0.2.0 since 20090124
4 ETW000 3799 0.167150
4 ETW000 [developertra,00000] Connection 0 opened 2413 0.169563
4 ETW000 [developertra,00000] NTAB: Structure of NTAB on DB is VERS_A 6076 0.175639
4 ETW000 [developertra,00000] NTAB: standalone processing 57 0.175696
4 ETW000 [developertra,00000] NTAB: read profile 16 0.175712
4 ETW000 [developertra,00000] NTAB: rsdb/ntab/entrycount 150 13 0.175725
4 ETW000 [developertra,00000] NTAB: rsdb/ntab/ftabsize 200 13 0.175738
4 ETW000 [developertra,00000] NTAB: rsdb/ntab/irbdsize 100 12 0.175750
4 ETW000 [developertra,00000] NTAB: rsdb/ntab/sntabsize 100 13 0.175763
4 ETW000 [developertra,00000] NTAB: maxcnt 150 13 0.175776
4 ETW000 [developertra,00000] NTAB: adm_initial 4080 13 0.175789
4 ETW000 [developertra,00000] NTAB: hfactor 1009 12 0.175801
4 ETW000 [developertra,00000] NTAB: mem_protocol_size 104 13 0.175814
4 ETW000 [developertra,00000] NTAB: FTAB: total 51200, adm_size 14920, data_size 204800
4 ETW000 22 0.175836
4 ETW000 [developertra,00000] NTAB: IREC: total 12800, adm_size 14920, data_size 102400
4 ETW000 22 0.175858
4 ETW000 [developertra,00000] NTAB: STAB: total 25600, adm_size 14920, data_size 102400
4 ETW000 22 0.175880
4 ETW000 [developertra,00000] NTAB: TTAB: total 150, adm_size 7784, data_size 21000
4 ETW000 21 0.175901
4 ETW000 [developertra,00000] NTAB: FTAB: adm_adr 110c44510, adm_len 14920, dat_adr 110c47f58, dat_len 204800
4 ETW000 1149 0.177050
4 ETW000 [developertra,00000] NTAB: IREC: adm_adr 110c79f70, adm_len 14920, dat_adr 110c7d9b8, dat_len 102400
4 ETW000 23 0.177073
4 ETW000 [developertra,00000] NTAB: STAB: adm_adr 110c969d0, adm_len 14920, dat_adr 110c9a418, dat_len 102400
4 ETW000 23 0.177096
4 ETW000 [developertra,00000] NTAB: TTAB: adm_adr 110cb3430, adm_len 7784, dat_adr 110cb5298, dat_len 21000
4 ETW000 22 0.177118
4 ETW000 [developertra,00000] NTAB: mem_protocol 110cb3430, mp_p 110cb3430, proc_id 0
4 ETW000 23 0.177141
4 ETW000 [developertra,00000] NTAB: FTAB: hh_p 110c44510, ha_list 110c4453c, hi_list 110c45500, buffer 110c47f58
4 ETW000 40 0.177181
4 ETW000 [developertra,00000] NTAB: IREC: hh_p 110c79f70, ha_list 110c79f9c, hi_list 110c7af60, buffer 110c7d9b8
4 ETW000 22 0.177203
4 ETW000 [developertra,00000] NTAB: STAB: hh_p 110c969d0, ha_list 110c969fc, hi_list 110c979c0, buffer 110c9a418
4 ETW000 44 0.177247
4 ETW000 [developertra,00000] NTAB: TTAB: hh_p 110cb3498, ha_list 110cb34c4, hi_list 110cb4488, buffer 110cb5298
4 ETW000 22 0.177269
4 ETW000 [developertra,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 0
4 ETW000 57 0.177326
4 ETW000 [developertra,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 1
4 ETW000 55 0.177381
4 ETW000 [developertra,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 2
4 ETW000 53 0.177434
4 ETW000 [developertra,00000] NTAB: mem_handler: alloc for 500 elems, task 0, art 3
4 ETW000 47 0.177481
4 ETW000 Connected to DBMS = ORACLE — dbs_ora_tnsname = ‘PS2’ — SYSTEM = ‘PS2’.
4 ETW000 trace to file pointer closed
4 ETW000 trace at level 1 opened for a given file pointer
4 ETW000
4 ETW000 ================== STEP 1 ====================4 ETW000 date&time : 24.01.2009 — 13:27:39
4 ETW000 function : CONNECT
4 ETW000 buffersync : YES
4 ETW000 clients : default
4 ETW000 l.s.m. : VECTOR
4 ETW000 commit : 100000
4 ETW000 table cache : 32000000
4 ETW000
4 ETW000 [developertra,00000] Disconnecting from ALL connections: 228 0.000228
4 ETW000 [developertra,00000] Disconnecting from connection 0 … 32 0.000260
4 ETW000 [developertra,00000] Now I’m disconnected from ORACLE 1433 0.001693
4 ETW000 [developertra,00000] Disconnected from connection 0 44 0.001737
4 ETW000 [developertra,00000] statistics db_con_commit (com_total=0, com_forced=0, com_tx=0)
4 ETW000 24 0.001761
4 ETW000 [developertra,00000] statistics db_con_rollback (roll_total=0, roll_forced=0, roll_tx=0)
4 ETW000 21 0.001782
4 ETW000 Disconnected from database.
4 ETW000 End of Transport (0000).
4 ETW000 date&time: 24.01.2009 — 13:27:39
Thanks in advance»
Read these next…
Windows 10 Enterprise not allowing downloads or search
Windows
Hello All,We just got a new machine that came with its own computer. The computer has Windows 10 Enterprise on it. All of our PCs are running Windows 10 Pro. I joined the new PC to the domain and logged in as the domain admin. Everything worked great. The…
Bring your dog to work day
Holidays
Do you work from home or office? Doesn’t matter. Let’s see those pets that work right alongside you. Well, mine mostly sleeps but they are there! This is Peanut. Her bed is next to my desk. I have to walk her up and down the stairs due to her rickety bon…
Snap! — Space Immunities, Stretching Metal, Defining Sandwich, 3D Printed Steel
Spiceworks Originals
Your daily dose of tech news, in brief.
Welcome to the Snap!
Flashback: june 23, 1912: Computer Pioneer Alan Turing Born (Read more HERE.)
Bonus Flashback: June 22, 2000: Possible evidence of liquid water found on Mars (Read more HERE.)
…
Has anyone else heard anything about RHEL becoming closed source?
Linux
Would anyone care to share their thoughts about what this might indicate for things to come?
A few weeks ago, Jay Lecroix Opens a new window made some passing references to the changes IBM has made to CentOS/CentOS Strea…
IT Documentation
Software
Let me begin by stating I am aware that there are tonnes of posts for this question. But, I was denied financial leeway for unnecessary expenses; and this in their opinion is one. I, recently, acquired the role of and IT do-it-all. for more than a decade,…