-----DO NOT FORGET TO CHANGE schema ID -----
begin transaction
set nocount on
declare @SchemaToFix varchar(25)
set @SchemaToFix = 'prd'
declare @max int
declare @i int
declare @cmd varchar(500)
declare @ObjName varchar(500)
declare @ObjNameFull varchar(500)
declare @LastUserID int
declare @LastUser varchar(100)
declare @LastSchemaID int
declare @LastSchema varchar(100)
declare @CurrentUserID int
declare @CurrentSchemaID int
declare @MaxUserID int
declare @MaxSchemaID int
print convert(varchar(20),getdate(),109) + ' Starting ..'
if not exists (select * from sys.schemas where name = @SchemaToFix)
begin
print convert(varchar(20),getdate(),109) + ' Schema not found. Exiting.'
rollback transaction
return
end
if exists (select count(*) from sys.schemas
where principal_id = user_id(@SchemaToFix)
having count(*) > 1
) begin
print convert(varchar(20),getdate(),109) + ' User owns more than one schema. Exiting.'
print convert(varchar(20),getdate(),109) + ' See OSS note 1086375 for details.'
rollback transaction
return
end
if exists (select * from sys.schemas
where principal_id = user_id(@SchemaToFix)
and principal_id = schema_id
) begin
print convert(varchar(20),getdate(),109) + ' UserID and SchemaID are the same.'
print convert(varchar(20),getdate(),109) + ' Nothing to do. Exiting.'
rollback transaction
return
end
select @CurrentUserID = principal_id from sys.schemas where name = @SchemaToFix
select @CurrentSchemaID = schema_id from sys.schemas where name = @SchemaToFix
print convert(varchar(20),getdate(),109) + ' Current state: UserID = ' + convert(varchar(3), @CurrentUserID) + ' SchemaID = ' + convert(varchar(3), @CurrentSchemaID)
select @MaxUserID = max(uid) from sys.sysusers with (nolock) where uid < 16000
select @MaxSchemaID = max(schema_id) from sys.schemas with (nolock) where schema_id < 16000
if @MaxUserID > @MaxSchemaID
set @max = 5 + @MaxUserID
else
set @max = 5 + @MaxSchemaID
dbcc dropcleanbuffers
dbcc freeproccache
if exists (select top 1 name from sysusers where name like 'SchemaRepairU%') begin
declare TempUserCursor cursor for select name from sysusers where name like 'SchemaRepairU%'
open TempUserCursor
fetch next from TempUserCursor into @LastUser
while @@fetch_status = 0 begin
set @cmd = 'drop user ' + @LastUser
execute (@cmd)
fetch next from TempUserCursor into @LastUser
end
close TempUserCursor
deallocate TempUserCursor
end
if exists (select top 1 name from sys.schemas where name like 'SchemaRepairS%') begin
declare TempSchemaCursor cursor for select name from sys.schemas where name like 'SchemaRepairS%'
open TempSchemaCursor
fetch next from TempSchemaCursor into @LastSchema
while @@fetch_status = 0 begin
if not exists (select top 1 name from sysobjects where uid = schema_id(@LastSchema)) begin
set @cmd = 'drop schema ' + @LastSchema
execute (@cmd)
end
fetch next from TempSchemaCursor into @LastSchema
end
close TempSchemaCursor
deallocate TempSchemaCursor
end
print convert(varchar(20),getdate(),109) + ' Cleanup finished'
set @i = 1
set @LastUser = 'SchemaRepairU' + convert(varchar(3),@i)
set @cmd = 'create user ' + @LastUser + ' without login'
execute (@cmd)
set @i = @i + 1
select @LastUserID = uid from sysusers where name = @LastUser
while @LastUserID < @max - 1 begin
set @LastUser = 'SchemaRepairU' + convert(varchar(3),@i)
set @cmd = 'create user ' + @LastUser + ' without login'
execute (@cmd)
select @LastUserID = uid from sysusers where name = @LastUser
set @i = @i + 1
end
print convert(varchar(20),getdate(),109) + ' User created. LastUser is : ' + @LastUser
set @i = 1
set @LastSchema = 'SchemaRepairS' + convert(varchar(3),@i)
set @cmd = 'create schema ' + @LastSchema + ' '
execute (@cmd)
set @i = @i + 1
select @LastSchemaID = schema_id from sys.schemas where name = @LastSchema
while @LastSchemaID < @max - 1 begin
set @LastSchema = 'SchemaRepairS' + convert(varchar(3),@i)
set @cmd = 'create schema ' + @LastSchema + ' '
execute (@cmd)
select @LastSchemaID = schema_id from sys.schemas where name = @LastSchema
set @i = @i + 1
end
print convert(varchar(20),getdate(),109) + ' Schemas created. LastSchema is : ' + @LastSchema
print convert(varchar(20),getdate(),109) + ' Start moving objects .... '
--###########################################################################
declare TempObjectCursor cursor local for
select name from sysobjects where
((xtype='U' and name <> 'dtproperties')
or (xtype='V' and name not in ('syssegments','sysconstraints'))
or (xtype='P' and name not like 'dt_%')
or (xtype='D' and name not like 'DF__dtpropert%')
or (xtype in ('FN','TF','IF'))
) and uid = schema_id(@SchemaToFix)
open TempObjectCursor
fetch next from TempObjectCursor into @ObjName
while @@fetch_status=0
begin
set @ObjNameFull = '[' + @SchemaToFix + '].[' + @ObjName + ']'
set @cmd = N'ALTER SCHEMA ' + @LastSchema + ' TRANSFER ' + @ObjNameFull
exec( @cmd )
fetch next from TempObjectCursor into @ObjName
end
close TempObjectCursor
deallocate TempObjectCursor
--###########################################################################
print convert(varchar(20),getdate(),109) + ' All objects moved to schema ' + @LastSchema
set @cmd = 'alter authorization on schema::' + @LastSchema + ' to ' + @LastUser
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' Authorization on schema ' + @LastSchema
set @cmd = 'alter authorization on schema::' + @SchemaToFix + ' to ' + @LastUser
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' Authorization on schema ' + @SchemaToFix
set @cmd = 'drop schema ' + @SchemaToFix
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' Schema dropped ' + @SchemaToFix
set @cmd = 'drop user ' + @SchemaToFix
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' User dropped ' + @SchemaToFix
set @cmd = 'create user SchemaRepairU without login'
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' User gap filled'
set @cmd = 'create schema SchemaRepairS'
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' Schema gap filled'
set @cmd = 'create user ' + @SchemaToFix + ' for login ' + @SchemaToFix
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' New schema user created'
set @cmd = 'create schema ' + @SchemaToFix
execute (@cmd)
print convert(varchar(20),getdate(),109) + ' New schema created'
print convert(varchar(20),getdate(),109) + ' Start moving objects back ..... '
--###########################################################################
declare TempObjectCursor cursor local for
select name
from sysobjects
where
( (xtype='U' and name <> 'dtproperties')
or (xtype='V' and name not in ('syssegments','sysconstraints'))
or (xtype='P' and name not like 'dt_%')
or (xtype='D' and name not like 'DF__dtpropert%')
or (xtype in ('FN','TF','IF'))
) and uid = schema_id(@LastSchema)
open TempObjectCursor
fetch next from TempObjectCursor into @ObjName
while @@fetch_status=0
begin
set @ObjNameFull = '[' + @LastSchema + '].[' + @ObjName + ']'
set @cmd = N'ALTER SCHEMA ' + @SchemaToFix + ' TRANSFER ' + @ObjNameFull
exec( @cmd )
fetch next from TempObjectCursor into @ObjName
end
close TempObjectCursor
deallocate TempObjectCursor
--###########################################################################
print convert(varchar(20),getdate(),109) + ' All objects moved into new schema'
set @cmd = 'alter authorization on schema::' + @SchemaToFix + ' to ' + @SchemaToFix
execute (@cmd)
set @cmd = 'alter user ' + @SchemaToFix + ' with default_schema = ' + @SchemaToFix
execute (@cmd)
exec sp_addrolemember 'db_owner', @SchemaToFix
print convert(varchar(20),getdate(),109) + ' Authorization set on new schema/user'
declare TempSchemaCursor cursor for select name from sys.schemas where name like 'SchemaRepairS%'
open TempSchemaCursor
fetch next from TempSchemaCursor into @LastSchema
while @@fetch_status = 0 begin
set @cmd = 'drop schema ' + @LastSchema
execute (@cmd)
fetch next from TempSchemaCursor into @LastSchema
end
close TempSchemaCursor
deallocate TempSchemaCursor
print convert(varchar(20),getdate(),109) + ' Final schema cleanup finished'
declare TempUserCursor cursor for select name from sysusers where name like 'SchemaRepairU%'
open TempUserCursor
fetch next from TempUserCursor into @LastUser
while @@fetch_status = 0 begin
set @cmd = 'drop user ' + @LastUser
execute (@cmd)
fetch next from TempUserCursor into @LastUser
end
close TempUserCursor
deallocate TempUserCursor
print convert(varchar(20),getdate(),109) + ' Final user cleanup finished'
commit transaction
exec sp_change_users_login 'update_one',@SchemaToFix,@SchemaToFix
print convert(varchar(20),getdate(),109) + ' New user accociated to the login.'
select @CurrentUserID = principal_id from sys.schemas where name = @SchemaToFix
select @CurrentSchemaID = schema_id from sys.schemas where name = @SchemaToFix
print convert(varchar(20),getdate(),109) + ' Current state: UserID = ' + convert(varchar(3), @CurrentUserID) + ' SchemaID = ' + convert(varchar(3), @CurrentSchemaID)
print convert(varchar(20),getdate(),109) + ' Script finished.'
March 23, 2012
Schema conversion for SAP database copy [custom direct]
-----------begin change of schema----
use EH5
go
if object_id('sp_change_sapuser') is not null drop procedure sp_change_sapuser go create procedure sp_change_sapuser @oldid sysname, @newid sysname as begin
declare @oldid_uid smallint
declare @newid_uid smallint
declare @object sysname
declare @object_full nvarchar(999)
--set @oldid_uid = user_id(@oldid)
select @oldid_uid =schema_id from EH5.sys.schemas where name=@oldid set @newid_uid = user_id(@newid)
if @oldid_uid is not null and @newid_uid is not null begin declare object_cursor cursor local for
select name
from sysobjects
where
( (xtype='U' and name <> 'dtproperties')
or (xtype='V' and name not in ('syssegments','sysconstraints'))
or (xtype='P' and name not like 'dt_%')
or (xtype='D' and name not like 'DF__dtpropert%')
or (xtype in ('FN','TF','IF'))
) and @oldid_uid = uid
open object_cursor
fetch next from object_cursor into @object while @@fetch_status=0 begin
set @object_full = user_name(@oldid_uid) + '.' + @object
exec sp_changeobjectowner @object_full, @newid
fetch next from object_cursor into @object end end else if @oldid_uid is null
begin
print '*** old database user does not exist ***'
end
if @newid_uid is null
begin
print '*** new database user does not exist ***'
end
end
go
exec sp_change_sapuser 'mp1', 'eh5'
go
---------------end change of schema-------------------------
use EH5
go
if object_id('sp_change_sapuser') is not null drop procedure sp_change_sapuser go create procedure sp_change_sapuser @oldid sysname, @newid sysname as begin
declare @oldid_uid smallint
declare @newid_uid smallint
declare @object sysname
declare @object_full nvarchar(999)
--set @oldid_uid = user_id(@oldid)
select @oldid_uid =schema_id from EH5.sys.schemas where name=@oldid set @newid_uid = user_id(@newid)
if @oldid_uid is not null and @newid_uid is not null begin declare object_cursor cursor local for
select name
from sysobjects
where
( (xtype='U' and name <> 'dtproperties')
or (xtype='V' and name not in ('syssegments','sysconstraints'))
or (xtype='P' and name not like 'dt_%')
or (xtype='D' and name not like 'DF__dtpropert%')
or (xtype in ('FN','TF','IF'))
) and @oldid_uid = uid
open object_cursor
fetch next from object_cursor into @object while @@fetch_status=0 begin
set @object_full = user_name(@oldid_uid) + '.' + @object
exec sp_changeobjectowner @object_full, @newid
fetch next from object_cursor into @object end end else if @oldid_uid is null
begin
print '*** old database user does not exist ***'
end
if @newid_uid is null
begin
print '*** new database user does not exist ***'
end
end
go
exec sp_change_sapuser 'mp1', 'eh5'
go
---------------end change of schema-------------------------
March 25, 2011
Best practice - Notes on Installing EHP1 SAP Netweaver 7.0 Application server to existing SAP SID in a new Windows 2003 server
I took an implementation task to install new SAP AS to an existing system. Some of my notes are written here. Below is just overview of actions done for the implementation tasks. It aims to guide other implementer on actions needed to minimize errors in installation.
Action item: This needs follow up update on the solution of common errors and issues. :-) Send me PM to get solution of error if you encounter some below.
A. Pre work
1. Get the SAP system version of existing system SID
(Example: PRD)
2. Get or Download Java installer
3. Get or Download Database installer
4. Get or Download SAP Net Weaver 7.0 EHP1 installer
5. Get or Download kernel version correction for EHP1 - SAP note 1375494
(Example: Kernel 94)
6. Transfer Installers to new Application server host
B. Actual Work
7. Operating system installation
8. Setting up Memory Parameters
9. Install Java
10. Setting up JAVA runtime environment variables
11. Installation of SQL database tools and client components
12. Setting of temp installation directory for MSIEXEC
13. Required parameters before starting installation
14Installation of SAP NetWeaver 7.0 EHP1
15. Troubleshooting Start SAP error
C. Post work
16. Adapt system parameter profile.
17. Adapt OSS information
18. Adapt landscape message servers update in the services file
19. Adapt explicit hosts from external network in the host file
20. Adapt external application such as BWA.
21. Functional tests
D. Appendix
22. Common errors
22.1 SAPinst Error: Java problems
22.2 MSIEXEC error
22.3 Dispatcher memory error
22.4 RFC error cannot connect to SAPmsSID
Action item: This needs follow up update on the solution of common errors and issues. :-) Send me PM to get solution of error if you encounter some below.
A. Pre work
1. Get the SAP system version of existing system SID
(Example: PRD)
2. Get or Download Java installer
3. Get or Download Database installer
4. Get or Download SAP Net Weaver 7.0 EHP1 installer
5. Get or Download kernel version correction for EHP1 - SAP note 1375494
(Example: Kernel 94)
6. Transfer Installers to new Application server host
B. Actual Work
7. Operating system installation
8. Setting up Memory Parameters
9. Install Java
10. Setting up JAVA runtime environment variables
11. Installation of SQL database tools and client components
12. Setting of temp installation directory for MSIEXEC
13. Required parameters before starting installation
14Installation of SAP NetWeaver 7.0 EHP1
15. Troubleshooting Start SAP error
C. Post work
16. Adapt system parameter profile.
17. Adapt OSS information
18. Adapt landscape message servers update in the services file
19. Adapt explicit hosts from external network in the host file
20. Adapt external application such as BWA.
21. Functional tests
D. Appendix
22. Common errors
22.1 SAPinst Error: Java problems
22.2 MSIEXEC error
22.3 Dispatcher memory error
22.4 RFC error cannot connect to SAPmsSID
February 1, 2011
SAP Note 560499 - Global Support Customer Interaction Telephone fax email
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Note Language: English Version: 157 Validity: Valid Since
25.08.2010
Summary
Symptom
You require assistance from SAP Support but you do not know the contact
details.
Other terms
Telephone, Fax, E-mail, Hotline, Message Enforcement, Message Escalation,
Global Support Customer Interaction, Problem Messages, Support Requests,
Service Requests, Service Postings, Support Center, Contact Person for
Customers, BOSAP Contact Data, SAP Business Objects, Speed Up Processing,
Enterprise Support, GSCI, CIC
Reason and Prerequisites
You do not know the telephone, fax or e-mail for Global Support Customer
Interaction.
Solution
Attached is a list of telephone numbers, fax numbers and e-mail addresses
for worldwide Global Support Customer Interaction.
1. TECHNICAL ASSISTANCE
Technical assistance is provided through the creation of an SAP customer
message.
Note:
A valid S-User and Password are required to do so.
S-User-IDs can be requested at www.service.sap.com
A password reset function is available at service.sap.com
1.1 How to create a customer message in SAP Service
Marketplace
- Go to www.service.sap.com
- Click on the SAP Support Portal
- Log in with User Name (S-User) and Password
- Use the following path to create the customer message: Help &
Support > Report a Product Error
- The SAP Message Wizard will then guide you through the
remaining process.
Refer to service.sap.com/message > Documentation for further assistance on
message creation.
1.2. How to create a customer message in SAP Solution Manager
The customer or end user or key user creates a customer message:
06.09.2010 Page 2 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
- In an SAP System via Help > Create Support Message in the menu
of a transaction
- In a web browser, independently of an SAP system
- In the Messages or Service Desk > Messages tab in the Solution
Manager system
Refer to help.sap.com > SAP Solution Manager for further assistance on
message creation.
2. NON-TECHNICAL ASSISTANCE
The following components are used to create messages for non-technical
queries using the message creation process described above:
Area: SAP Service Marketplace
Component: XX-SER-SAPSMP*
Query: Contents, Partner Portal, Download Manager, System Data
Area: S-User
Component: XX-SER-SAPSMP-USR
Query: S-User Administration, Authorisation, Password
Area: Remote Service Request
Component: SV-BO-REQ
Query: Request for the Delivery of a Remote Service
Area: License Keys
Component: XX-SER-LIKEY
Query: License Key for SAP Systems
Area: License Keys
Component: XX-SER-LIKEY-BOJ
Query: License Key for Business Objects
3. GLOBAL SUPPORT CUSTOMER INTERACTION CENTER CONTACT DETAILS
Note: Contacting our Global Support Customer Interaction Centers via our
24x7 telephone service is recommended if you require immediate assistance
for the following:
- Critical priority 1 customer messages (production down
scenarios and endangered imminent Go Live projects)
- Formal escalation of high messages
In order for SAP to prioritise a message appropriately information
detailing the commercial impact of the technical issue is required.
See SAP Note 67739 for message priorities.
See SAP Note 1281633 for message acceleration.
See SAP Note 90835 for message escalation.
3.1 SAP CUSTOMERS
06.09.2010 Page 3 of 9
SAP Note 560499 - Global Support Customer Interaction:
TELEPHONE FAX EMAIL
If a number listed below is not available please call the following number:
+49 6227 744 969 (available worldwide)
COUNTRY CONTACT INFORMATION
Argentina T: +54 11 4891 3340 (24x7)
F: +54 11 4891 3056 / 3305
Australia T: 1800 081923 (24x7)
T: +61 2 9935 4660
F: +61 2 9925 7553
Austria T: 0800 295077(24x7)
Bahrain T: 800 81128 (24x7)
T: +971 4 440 7384 (24x7)
T: +353 1 8558034 (24x7)
Belgium T: 0800 75886 (24x7)
Bolivia T: +54 11 4891 3340 (24x7)
F: +54 11 4891 3056 / 3305
Brazil T: 0800 8914919 (24x7)
F: +55 11 5503 2303
Canada T: +1 866 660 3577 (24x7)
T: +1 610 661 7257 (24x7)
F: +1 610 661 0716
Chile T: +54 11 4891 3340 (24x7)
T: +56 2 440 3555
F: +54 11 4891 3056 / 3305
China T: +86 400 620 2008 (24x7)
T: +86 411 3963 0482
F: +86 21 3860 1346
Colombia T: +58 212 267 8344 (24x7)
T: 01800 915 4889
F: +58 212 276 5544
Costa Rica T: 0 800 052 1041
T: +52 555 258 7701 (24x7)
F: +52 555 257 7503
Czech Republic T: 800 143246 (24x7)
Denmark T: +45 8088 9491 (24x7)
Dubai T: +971 4 4407 384 (24x7)
Ecuador T: +58 212 267 8344 (24x7)
F: +58 212 276 5544
Estonia T: 8000049021 (24x7)
Finland T: +358 800 91 9487 (24x7)
06.09.2010 Page 4 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
France T: 0800 910253 (24x7)
T: +33 1 4445 2333 from North Africa
Germany T: +49 1802 260260 (24x7)
F: +49 1805 343430
Greece T: 00800 49129202 (24x7)
Hong Kong T: 800 964865 (24x7)
T: +852 2539 1919
Hungary T: 0680016601 (24x7)
India T: +91 80 4329 8300 (24x7)
T: +91 80 6779 8300 (24x7)
F: +91 80 2841 8310
Indonesia T: 001 803 65 7700 (24x7)
F: 001 803 65 7718
Ireland T: 1800 800 350(24x7)
Israel T: +972 9 777 5333 (24x7)
Italy T: 800 789009 (24x7)
Japan T: 0120 332 909
T: +81 3 5543 7600
F: +81 3 5543 7801
Japan
CRM on Demand T: 0120 92 5186
Korea T: 080 5992400 (24x7)
T: +82 2 2194 2600
Latvia T: 8000 2982 (24x7)
Lithuania T: 8800 30694 (24x7)
Luxembourg T: 8002 3076 (24x7)
Macau T: 0800 427
Malaysia T: 1800 814167(24x7)
T: +91 80 41398850 (Back up)
F: 1800 801320
Mexico: T: 01 800 713 6843 (24x7)
T: +52 555 258 7701 (24x7)
F: +52 555 257 7503
Netherlands T: 0800 0220683 (24x7)
New Zealand T: 0800 441719 (24x7)
F: +61 2 9935 4652
06.09.2010 Page 5 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Norway T: +47 800 11 739 (24x7)
Pakistan T: +66 2 631 1814 (24x7)
F: +66 2 631 1818
Paraguay T: +54 11 4891 3340 (24x7)
F: +54 11 4891 3056 / 3305
Peru T: +58 212 267 8344 (24x7)
T: 0 800 12260
F: +58 212 276 5544
Philippines T: +63 2 848 1610 (24x7)
F: +63 2 840 8048
Poland T: 008004911572 (24x7)
Portugal T: 800 849195 (24x7)
Russia T: +7 495 725 4341
Saudi Arabia T: 800 891 1002 (24x7)
T: +971 4 440 7384 (24x7)
T: +353 1 8558034 (24x7)
SEME hotline** T: +353 91 40 4227 (24x7)
Singapore T: 800 4922129 (24x7)
T: +65 6768 6363
F: +65 6768 5050
Slovakia T: 0800049019 (24x7)
South Africa T: 0800981539 (24x7)
T: +27 11 235 6122 (24x7)
Spain T: 900998311 (24x7)
Sweden T: 020 799 925 (24x7)
Switzerland T: 0800 562643 (24x7)
Taiwan T: 0800 885 365 (24x7)
Thailand T: +1 800 4910284(24x7)
T: +66 2 631 1818
Trinidad&Tobago T: +58 212 267 8644 (24x7)
F: +58 212 276 5544
Turkey T: +90 216 633 0351 (Head Office)
UAE T: 800 0911 9001 (24x7)
T: +971 4 440 7384 (24x7)
T: +353 1 8558034 (24x7)
United Kingdom T: 08081012181 (24x7)
06.09.2010 Page 6 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Uruguay T: +54 11 4891 3340 (24x7)
F: +54 11 891 3056 / 3305
USA T: +1 800 677 7271 (24x7)
T: +1 610 661 7241 (24x7)
F: +1 610 661 0716
Venezuela T: +58 212 267 8344 (24x7)
T: 0 800 HELPSAP 435 7727
F: +58 212 276 5544
** valid for the following countries: Bosnia and Herzegovina,
Bulgaria, Croatia, Macedonia, the Middle East, Montenegro, Romania,
Serbia, and Slovenia
3.2 SAP BUSINESS USER CUSTOMER
If a number listed below is not available please call the following number:
EMEA Region
+353 91 40 4395
North America and Latin America
+55 51 3081-1291
China, Hong Kong, Japan, South Korea, Singapore, Taiwan
+86 411 3963 1129
Malaysia, Philippines, Thailand
+91 80 4139 9216
Australia, New Zealand
+61 2 9935 4660
COUNTRY PHONE
Argentina 0800 4441284
Australia 1800 081923
+61 2 9935 4660
Austria 0800 295077
Belgium 0800 75886
Brazil 0800 8914919
Bulgaria 00800 1104973
Canada 1866 660 3577
Chile 12300 204255
China +86 400 620 2008
+86 411 3963 0482
Croatia 0800 222530
Cyprus 800 94380
Czech Republic 800 143246
Denmark 8088 9491
Estonia 800 0049021
Finland 0800 919487
France 0800 910253
Germany 01802 260260
Great Britain 0808 1012181
Greece 00800 4912 9202
06.09.2010 Page 7 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Hong Kong 800 964865
+852 2539 1919
Hungary 06800 16601
Iceland 800 8868
India +91 80 4329 8300
+91 80 6779 8300
Ireland 1800 800 350
Israel 180 9349055
Italy 800 789009
Japan 0120 332 909
+81 3 5543 7600
Korea 080 5992400
+82 2 2194 2600
Latvia 8000 2982
Lithuania 8800 30694
Luxembourg 8002 3076
Macau 0800 427
Malaysia 1800 814167
Malta 800 62058
Mexico 01800 1233218
Monaco 800 93485
Netherlands 0800 0220683
New Zealand 0800 441719
+61 2 9935 4652
Norway 800 11739
Pakistan +91 80 4139 9216
Philippines +63 2 848 1610
Poland 00800 4911572
Portugal 800 849195
Singapore 800 4922129
+65 6768 6363
Slovakia 080 0049019
Slovenia 0800 80280
South Africa 0800 981539
South Korea 003084910037
080 599 2400
Spain 900 998311
Sweden 020 799925
Switzerland 0800 562643
Taiwan 0800 885 365
Thailand 001800 4910284
USA 1 800 677 7271
Vietnam +91 80 4139 9216
3.3 E SOURCING CUSTOMERS & PROVIDERS
COUNTRY CUSTOMERS PROVIDERS
US +1 866 456 1983 +1 866 456 1985
EMEA +44 20 8917 7641 +44 20 8917 7642
3.4 EMAIL ADDRESSES
Note: The preferred communication medium is via customer messages or
telephone (both available 24x7)
06.09.2010 Page 8 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Emails sent to Global Support Customer Interaction via one of the following
email addresses are only processed during normal business hours and should
only be used where phone call/message creation is not an option.
3.4.1 SAP BUSINESS USER CUSTOMERS
support.BOSAPAsia@sap.com
support.BOSAPEMEA@sap.com
support.BOSAPAmerica@sap.com
3.4.2 SAP CUSTOMERS
China, Hong Kong, Taiwan, Korea, Singapore:
support.asia@sap.com
Australia, New Zealand:
support.australia@sap.com:
Russia:
support.cis@sap.com
Austria, Belgium, Czech Republic, Denmark, Finland, France, Germany,
Greece, Hungary, Ireland, Israel, Italy, Luxembourg, Netherlands, Norway,
Poland, Portugal, Slovakia, South, Africa, Spain, Sweden, Switzerland, UK:
support.emea@sap.com
India:
support.india@sap.com
Japan:
support.japan@sap.com
Andina, Mexico, Brasil, Region Sur:
support.latinamerica@sap.com
Qatar, Kuwait, United Arab Emirates, Oman, Jordan, Iran, Bahrain, Egypt,
Saudi Arabia, Yemen, Syria, Libya, Lebanon, Palestine, Iraq, Sudan:
support.mena@sap.com
Indonesia, Malaysia, Philippines, Vietnam, Thailand, Pakistan:
support.sea@sap.com
America, Canada:
support.usca@sap.com
Telephone/fax/e-mail
Note Language: English Version: 157 Validity: Valid Since
25.08.2010
Summary
Symptom
You require assistance from SAP Support but you do not know the contact
details.
Other terms
Telephone, Fax, E-mail, Hotline, Message Enforcement, Message Escalation,
Global Support Customer Interaction, Problem Messages, Support Requests,
Service Requests, Service Postings, Support Center, Contact Person for
Customers, BOSAP Contact Data, SAP Business Objects, Speed Up Processing,
Enterprise Support, GSCI, CIC
Reason and Prerequisites
You do not know the telephone, fax or e-mail for Global Support Customer
Interaction.
Solution
Attached is a list of telephone numbers, fax numbers and e-mail addresses
for worldwide Global Support Customer Interaction.
1. TECHNICAL ASSISTANCE
Technical assistance is provided through the creation of an SAP customer
message.
Note:
A valid S-User and Password are required to do so.
S-User-IDs can be requested at www.service.sap.com
A password reset function is available at service.sap.com
1.1 How to create a customer message in SAP Service
Marketplace
- Go to www.service.sap.com
- Click on the SAP Support Portal
- Log in with User Name (S-User) and Password
- Use the following path to create the customer message: Help &
Support > Report a Product Error
- The SAP Message Wizard will then guide you through the
remaining process.
Refer to service.sap.com/message > Documentation for further assistance on
message creation.
1.2. How to create a customer message in SAP Solution Manager
The customer or end user or key user creates a customer message:
06.09.2010 Page 2 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
- In an SAP System via Help > Create Support Message in the menu
of a transaction
- In a web browser, independently of an SAP system
- In the Messages or Service Desk > Messages tab in the Solution
Manager system
Refer to help.sap.com > SAP Solution Manager for further assistance on
message creation.
2. NON-TECHNICAL ASSISTANCE
The following components are used to create messages for non-technical
queries using the message creation process described above:
Area: SAP Service Marketplace
Component: XX-SER-SAPSMP*
Query: Contents, Partner Portal, Download Manager, System Data
Area: S-User
Component: XX-SER-SAPSMP-USR
Query: S-User Administration, Authorisation, Password
Area: Remote Service Request
Component: SV-BO-REQ
Query: Request for the Delivery of a Remote Service
Area: License Keys
Component: XX-SER-LIKEY
Query: License Key for SAP Systems
Area: License Keys
Component: XX-SER-LIKEY-BOJ
Query: License Key for Business Objects
3. GLOBAL SUPPORT CUSTOMER INTERACTION CENTER CONTACT DETAILS
Note: Contacting our Global Support Customer Interaction Centers via our
24x7 telephone service is recommended if you require immediate assistance
for the following:
- Critical priority 1 customer messages (production down
scenarios and endangered imminent Go Live projects)
- Formal escalation of high messages
In order for SAP to prioritise a message appropriately information
detailing the commercial impact of the technical issue is required.
See SAP Note 67739 for message priorities.
See SAP Note 1281633 for message acceleration.
See SAP Note 90835 for message escalation.
3.1 SAP CUSTOMERS
06.09.2010 Page 3 of 9
SAP Note 560499 - Global Support Customer Interaction:
TELEPHONE FAX EMAIL
If a number listed below is not available please call the following number:
+49 6227 744 969 (available worldwide)
COUNTRY CONTACT INFORMATION
Argentina T: +54 11 4891 3340 (24x7)
F: +54 11 4891 3056 / 3305
Australia T: 1800 081923 (24x7)
T: +61 2 9935 4660
F: +61 2 9925 7553
Austria T: 0800 295077(24x7)
Bahrain T: 800 81128 (24x7)
T: +971 4 440 7384 (24x7)
T: +353 1 8558034 (24x7)
Belgium T: 0800 75886 (24x7)
Bolivia T: +54 11 4891 3340 (24x7)
F: +54 11 4891 3056 / 3305
Brazil T: 0800 8914919 (24x7)
F: +55 11 5503 2303
Canada T: +1 866 660 3577 (24x7)
T: +1 610 661 7257 (24x7)
F: +1 610 661 0716
Chile T: +54 11 4891 3340 (24x7)
T: +56 2 440 3555
F: +54 11 4891 3056 / 3305
China T: +86 400 620 2008 (24x7)
T: +86 411 3963 0482
F: +86 21 3860 1346
Colombia T: +58 212 267 8344 (24x7)
T: 01800 915 4889
F: +58 212 276 5544
Costa Rica T: 0 800 052 1041
T: +52 555 258 7701 (24x7)
F: +52 555 257 7503
Czech Republic T: 800 143246 (24x7)
Denmark T: +45 8088 9491 (24x7)
Dubai T: +971 4 4407 384 (24x7)
Ecuador T: +58 212 267 8344 (24x7)
F: +58 212 276 5544
Estonia T: 8000049021 (24x7)
Finland T: +358 800 91 9487 (24x7)
06.09.2010 Page 4 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
France T: 0800 910253 (24x7)
T: +33 1 4445 2333 from North Africa
Germany T: +49 1802 260260 (24x7)
F: +49 1805 343430
Greece T: 00800 49129202 (24x7)
Hong Kong T: 800 964865 (24x7)
T: +852 2539 1919
Hungary T: 0680016601 (24x7)
India T: +91 80 4329 8300 (24x7)
T: +91 80 6779 8300 (24x7)
F: +91 80 2841 8310
Indonesia T: 001 803 65 7700 (24x7)
F: 001 803 65 7718
Ireland T: 1800 800 350(24x7)
Israel T: +972 9 777 5333 (24x7)
Italy T: 800 789009 (24x7)
Japan T: 0120 332 909
T: +81 3 5543 7600
F: +81 3 5543 7801
Japan
CRM on Demand T: 0120 92 5186
Korea T: 080 5992400 (24x7)
T: +82 2 2194 2600
Latvia T: 8000 2982 (24x7)
Lithuania T: 8800 30694 (24x7)
Luxembourg T: 8002 3076 (24x7)
Macau T: 0800 427
Malaysia T: 1800 814167(24x7)
T: +91 80 41398850 (Back up)
F: 1800 801320
Mexico: T: 01 800 713 6843 (24x7)
T: +52 555 258 7701 (24x7)
F: +52 555 257 7503
Netherlands T: 0800 0220683 (24x7)
New Zealand T: 0800 441719 (24x7)
F: +61 2 9935 4652
06.09.2010 Page 5 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Norway T: +47 800 11 739 (24x7)
Pakistan T: +66 2 631 1814 (24x7)
F: +66 2 631 1818
Paraguay T: +54 11 4891 3340 (24x7)
F: +54 11 4891 3056 / 3305
Peru T: +58 212 267 8344 (24x7)
T: 0 800 12260
F: +58 212 276 5544
Philippines T: +63 2 848 1610 (24x7)
F: +63 2 840 8048
Poland T: 008004911572 (24x7)
Portugal T: 800 849195 (24x7)
Russia T: +7 495 725 4341
Saudi Arabia T: 800 891 1002 (24x7)
T: +971 4 440 7384 (24x7)
T: +353 1 8558034 (24x7)
SEME hotline** T: +353 91 40 4227 (24x7)
Singapore T: 800 4922129 (24x7)
T: +65 6768 6363
F: +65 6768 5050
Slovakia T: 0800049019 (24x7)
South Africa T: 0800981539 (24x7)
T: +27 11 235 6122 (24x7)
Spain T: 900998311 (24x7)
Sweden T: 020 799 925 (24x7)
Switzerland T: 0800 562643 (24x7)
Taiwan T: 0800 885 365 (24x7)
Thailand T: +1 800 4910284(24x7)
T: +66 2 631 1818
Trinidad&Tobago T: +58 212 267 8644 (24x7)
F: +58 212 276 5544
Turkey T: +90 216 633 0351 (Head Office)
UAE T: 800 0911 9001 (24x7)
T: +971 4 440 7384 (24x7)
T: +353 1 8558034 (24x7)
United Kingdom T: 08081012181 (24x7)
06.09.2010 Page 6 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Uruguay T: +54 11 4891 3340 (24x7)
F: +54 11 891 3056 / 3305
USA T: +1 800 677 7271 (24x7)
T: +1 610 661 7241 (24x7)
F: +1 610 661 0716
Venezuela T: +58 212 267 8344 (24x7)
T: 0 800 HELPSAP 435 7727
F: +58 212 276 5544
** valid for the following countries: Bosnia and Herzegovina,
Bulgaria, Croatia, Macedonia, the Middle East, Montenegro, Romania,
Serbia, and Slovenia
3.2 SAP BUSINESS USER CUSTOMER
If a number listed below is not available please call the following number:
EMEA Region
+353 91 40 4395
North America and Latin America
+55 51 3081-1291
China, Hong Kong, Japan, South Korea, Singapore, Taiwan
+86 411 3963 1129
Malaysia, Philippines, Thailand
+91 80 4139 9216
Australia, New Zealand
+61 2 9935 4660
COUNTRY PHONE
Argentina 0800 4441284
Australia 1800 081923
+61 2 9935 4660
Austria 0800 295077
Belgium 0800 75886
Brazil 0800 8914919
Bulgaria 00800 1104973
Canada 1866 660 3577
Chile 12300 204255
China +86 400 620 2008
+86 411 3963 0482
Croatia 0800 222530
Cyprus 800 94380
Czech Republic 800 143246
Denmark 8088 9491
Estonia 800 0049021
Finland 0800 919487
France 0800 910253
Germany 01802 260260
Great Britain 0808 1012181
Greece 00800 4912 9202
06.09.2010 Page 7 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Hong Kong 800 964865
+852 2539 1919
Hungary 06800 16601
Iceland 800 8868
India +91 80 4329 8300
+91 80 6779 8300
Ireland 1800 800 350
Israel 180 9349055
Italy 800 789009
Japan 0120 332 909
+81 3 5543 7600
Korea 080 5992400
+82 2 2194 2600
Latvia 8000 2982
Lithuania 8800 30694
Luxembourg 8002 3076
Macau 0800 427
Malaysia 1800 814167
Malta 800 62058
Mexico 01800 1233218
Monaco 800 93485
Netherlands 0800 0220683
New Zealand 0800 441719
+61 2 9935 4652
Norway 800 11739
Pakistan +91 80 4139 9216
Philippines +63 2 848 1610
Poland 00800 4911572
Portugal 800 849195
Singapore 800 4922129
+65 6768 6363
Slovakia 080 0049019
Slovenia 0800 80280
South Africa 0800 981539
South Korea 003084910037
080 599 2400
Spain 900 998311
Sweden 020 799925
Switzerland 0800 562643
Taiwan 0800 885 365
Thailand 001800 4910284
USA 1 800 677 7271
Vietnam +91 80 4139 9216
3.3 E SOURCING CUSTOMERS & PROVIDERS
COUNTRY CUSTOMERS PROVIDERS
US +1 866 456 1983 +1 866 456 1985
EMEA +44 20 8917 7641 +44 20 8917 7642
3.4 EMAIL ADDRESSES
Note: The preferred communication medium is via customer messages or
telephone (both available 24x7)
06.09.2010 Page 8 of 9
SAP Note 560499 - Global Support Customer Interaction:
Telephone/fax/e-mail
Emails sent to Global Support Customer Interaction via one of the following
email addresses are only processed during normal business hours and should
only be used where phone call/message creation is not an option.
3.4.1 SAP BUSINESS USER CUSTOMERS
support.BOSAPAsia@sap.com
support.BOSAPEMEA@sap.com
support.BOSAPAmerica@sap.com
3.4.2 SAP CUSTOMERS
China, Hong Kong, Taiwan, Korea, Singapore:
support.asia@sap.com
Australia, New Zealand:
support.australia@sap.com:
Russia:
support.cis@sap.com
Austria, Belgium, Czech Republic, Denmark, Finland, France, Germany,
Greece, Hungary, Ireland, Israel, Italy, Luxembourg, Netherlands, Norway,
Poland, Portugal, Slovakia, South, Africa, Spain, Sweden, Switzerland, UK:
support.emea@sap.com
India:
support.india@sap.com
Japan:
support.japan@sap.com
Andina, Mexico, Brasil, Region Sur:
support.latinamerica@sap.com
Qatar, Kuwait, United Arab Emirates, Oman, Jordan, Iran, Bahrain, Egypt,
Saudi Arabia, Yemen, Syria, Libya, Lebanon, Palestine, Iraq, Sudan:
support.mena@sap.com
Indonesia, Malaysia, Philippines, Vietnam, Thailand, Pakistan:
support.sea@sap.com
America, Canada:
support.usca@sap.com
January 20, 2011
How to configure and create SAP router service with SNC via NTSCMGR
Steps to do when setting up SAP router via Secure Network Comm (SNC). A note for future reference.
Hope this helps others too.
Part A.
The first thing you need to do, is to send a customer message to SAP
Support (component XX-SER-NET-OSS-NEW) and tell them to register the
hostname and IP of your new SAProuter.
Part B.
After you’ve received a confirmation from SAP that your SAProuter has
been registered, you are ready to configure your SAProuter.
If your SAProuter directory is N:\usr\sap\saprouter, these are the steps
to follow.
Note: You will be asked for a PIN code. Just pick your own 4 numbers, but
you’ll have to use the same PIN every time you’re asked to enter one.
1. Set 2 environment variables: SECUDIR and SNC_LIB according to the
guide you’ve downloaded.
example for variable setting below:
SECUDIR = N:\usr\sap\saprouter\
SNC_LIB = N:\usr\sap\saprouter\NTIA64\sapcrypto.dll (choose NTIA64 if your system is Itanium)
2. Download the SAP Crypto Library and unpack it into
N:\usr\sap\saprouter
3. To generate a certificate request, run the command:
sapgenpse get_pse -v -r N:\usr\sap\saprouter\certreq -p
N:\usr\sap\saprouter\local.pse “”
4. Then you have to follow the guide and request the certificate from
http://service.sap.com/tcs -> Download Area -> SAProuter Certificate
5. Create a file N:\usr\sap\saprouter\srcert and copy the requested
certificate into this file. The run the command:
sapgenpse import_own_cert -c N:\usr\sap\saprouter\srcert -p
N:\usr\sap\saprouter\local.pse
6. To generate credentials for the user that’s running the SAProuter
service, run command:
sapgenpse seclogin -p N:\usr\sap\saprouter\local.pse -O
(this will create the file “cred_v2″)
7. Check the configuration by running command:
sapgenpse get_my_name -v -n Issuer
Result should be: “CN=SAProuter CA, OU=SAProuter,
O=SAP, C=DE”)
8. Create SAProuter service on Windows with the command:
ntscmgr install SAProuter -b N:\usr\sap\saprouter\saprouter.exe -p
“service -r -R N:\usr\sap\saprouter\saprouttab -W 60000 -K ^p:^”
9. Edit the Windows Registry key as follows:
MyComputer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SAProute
r\ImagePath –> Change both ^ to “
Add the value of issuer from step 7..
end value should be -K "p:CN=SAProuter CA, OU=SAProuter,
O=SAP, C=DE”
10. Start the SAProuter service with your SNC user from step 6.
11. Enter the required parameters in OSS1 -> Technical Settings
12. Test your SAP router
Hope this helps others too.
Part A.
The first thing you need to do, is to send a customer message to SAP
Support (component XX-SER-NET-OSS-NEW) and tell them to register the
hostname and IP of your new SAProuter.
Part B.
After you’ve received a confirmation from SAP that your SAProuter has
been registered, you are ready to configure your SAProuter.
If your SAProuter directory is N:\usr\sap\saprouter, these are the steps
to follow.
Note: You will be asked for a PIN code. Just pick your own 4 numbers, but
you’ll have to use the same PIN every time you’re asked to enter one.
1. Set 2 environment variables: SECUDIR and SNC_LIB according to the
guide you’ve downloaded.
example for variable setting below:
SECUDIR = N:\usr\sap\saprouter\
SNC_LIB = N:\usr\sap\saprouter\NTIA64\sapcrypto.dll (choose NTIA64 if your system is Itanium)
2. Download the SAP Crypto Library and unpack it into
N:\usr\sap\saprouter
3. To generate a certificate request, run the command:
sapgenpse get_pse -v -r N:\usr\sap\saprouter\certreq -p
N:\usr\sap\saprouter\local.pse “”
4. Then you have to follow the guide and request the certificate from
http://service.sap.com/tcs -> Download Area -> SAProuter Certificate
5. Create a file N:\usr\sap\saprouter\srcert and copy the requested
certificate into this file. The run the command:
sapgenpse import_own_cert -c N:\usr\sap\saprouter\srcert -p
N:\usr\sap\saprouter\local.pse
6. To generate credentials for the user that’s running the SAProuter
service, run command:
sapgenpse seclogin -p N:\usr\sap\saprouter\local.pse -O
(this will create the file “cred_v2″)
7. Check the configuration by running command:
sapgenpse get_my_name -v -n Issuer
Result should be: “CN=SAProuter CA, OU=SAProuter,
O=SAP, C=DE”)
8. Create SAProuter service on Windows with the command:
ntscmgr install SAProuter -b N:\usr\sap\saprouter\saprouter.exe -p
“service -r -R N:\usr\sap\saprouter\saprouttab -W 60000 -K ^p:^”
9. Edit the Windows Registry key as follows:
MyComputer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SAProute
r\ImagePath –> Change both ^ to “
Add the value of issuer from step 7..
end value should be -K "p:CN=SAProuter CA, OU=SAProuter,
O=SAP, C=DE”
10. Start the SAProuter service with your SNC user from step 6.
11. Enter the required parameters in OSS1 -> Technical Settings
12. Test your SAP router
Subscribe to:
Posts (Atom)
