Tuesday 12 November 2013

Log reduction in SQL server


Hi All,

For Reduce the Log file in SQL server to specify size.

SELECT name, log_reuse_wait_desc FROM sys.databases where name='System ID';


EXEC sp_removedbreplication 'System ID';


SELECT name, log_reuse_wait_desc FROM sys.databases where name='System ID';


ALTER DATABASE System ID SET RECOVERY SIMPLE;


DBCC SHRINKFILE ('System IDLOG1', 1000, TRUNCATEONLY);



Thursday 7 November 2013

Error in Run ABAP Import reports (SAP installation)


Error in SAP System: Problem at Run ABAP Import reports:
An error occurred while processing option Enhancement Package 7 for SAP ERP 6.0 > SAP Application Server ABAP > MS SQL Server > Central System > Central System( Last error reported by the step :Unable to open RFC connection.). You can now:
Choose Retry to repeat the current step.
Choose Log Files to get more information about the error.
Stop the option and continue with it later.
Log files are written to C:\Program Files/sapinst_instdir/ERPEhP5/AS-ABAP/MSS/CENTRAL/.
An error occurred while processing option Enhancement Package 5 for SAP ERP 6.0 > SAP Application Server ABAP > MS SQL Server > Central System > Central System( Last error reported by the step :Unable to call function. Error message: Exception condition "WRITE_FAILED" raised. .). You can now:
 


Solution:
1. Ist We have to Give the Permissions in Users,Administrator and SSD ADM.
2. Host File Adding in Drivers:
                   IP Name                        Host name                       SAPTRANSHOST
3.Add this parameter - login/no_automatic_user_sapstar-0 in default profile
4. Restart the MMC and start the Services in Services.msc.
First ensure that there is no DNS server address configured in your Network configuration. Then add the following line to your \winnt\system32\drivers\etc\hosts file or correct an existing line accordingly
<IP Address of server> <Hostname> SAPTRANSHOST
Once done, check as below dir \\SAPTRANSHOST\sapmnt\trans
Check that the user SAPService<SID> has write permission on the transport directory.
Then restart SAP through SAPMMC and also restart Service SAP<SID>
Then continue the installation.
Also carefully go throuogh below SAP Note..

[Note 162266 - Questions and tips for R3SETUP on Windows NT / W2K|https://service.sap.com/sap/support/notes/162266

Tuesday 5 November 2013

SAP Router commands (IMPORTANT)

SAP Router commands:
saprouter -s Stops SAProuter
saprouter –r Starts SAProuter
niping -c -O -S 3299 -H 194.39.131.34
niping -c -O -S 3200 -H (Your Server ip) ---> port is open in SAP router is not
niping -c -O -S 3201 -H (Your Server ip) ---> port is open in SAP router is not
Verifying the Configuration
sapgenpse get_my_name -V -n issuer
saprouter –I - status connecting properly
Importing the Certificate & Creating Credential
sapgenpse import_own_cert -c srcert -p local.pse
Creating the credential for User responsible to start SAP Router
sapgenpse seclogin –p local.pse –O <sidadm>
Name of the Issuer as : CN=SAProuter CA, OU=SAProuter, O=SAP, C=D
Post Configuration Activity
Set environmental variable SNC_LIB=/usr/sap/saprouter/ libsapcrypto.so
The command saprouter -n (iSeries: saprouter '-n' ) is used to report changes in the route permission table to the running SAProuter.