Wednesday, 27 March 2024

How to define the maximum file size in SAP Content Server 7.5


How to define the maximum file size in SAP Content Server 7.5

"There is a need to adjust the maximum file size in SAP Content Server 7.5 (and above) to a desired higher or lower limit."

"The maximum file size is determined by the profile parameter icm/HTTP/max_request_size_KB."

The profile configuration file can be found in the DIR_PROFILE of the new installation, for example, /usr/sap/<SID>/SYS/profile.

The parameter can also be used to set a smaller limit if desired.

Important Note:

Please be aware that adjusting the upload limit for file size will impact all applications.

Any files uploaded prior to the limit adjustment, which exceed the new limit, will become inaccessible.
For instance, if the limit is set at 150MB and a 200MB file was uploaded before the adjustment, it will no longer be accessible.




Reference :

SAP Snote
SAP help

 

Wednesday, 20 March 2024

How to schedule a database/transaction log backup for SAP JAVA Stack system - SAP ASE

 


 You can schedule regular database/transaction log backups for SAP Java Stack systems running on SAP on ASE (with no possibility to use an ABAP stack system to manage that from DBACockpit).

Environment:

SAP Adaptive Server Enterprise (ASE) 16.0

Pre-requisites:

  1.  Job Scheduler database is installed and up and running
  2.  Backup Server is up and running
You can schedule automatic dump jobs using AMC, under Backup & Recovery > Database Dumps > Create option.

If you want to schedule dump manually, you may proceed with the following steps:

Connect to ASE using isql command 
sybadm> isql -Usapsa -PXXXX -S SMJ -X

Create a dump configuration if required. The advantage of the dump configuration is that you can reuse for others dumps.

sybadm> use master
sybadm> go

sybadm> sp_config_dump '<configname>',@stripe_dir='</path/to/backup/location>',@num_stripes='<#stripes>',@retry='1',@compression = '<compression level>'
sybadm>go

Example:  sp_config_dump 'SMJDB',@stripe_dir='</backup/Backup/SOL/SMJ',@num_stripes='1',@retry='1',@compression = '101'  

Create a scheduled job using sp_sjobcreate stored proc

Command syntax: sp_sjobcreate 

sybadm> use sybmgmtdb
sybadm> go

Create database dump syntax:
 sybadm> sp_sjobcreate @name='<schedulename>',@option="jname=<jobname>,jdesc=<job description>,jcmd=dump database <dbname> using config = '<configname>',days=<day1:day2..>,starttime=<hh:mm>"

sybadm> go

Example create database dump with "SMJDB" database name:

sybadm> sp_sjobcreate @name='DMP_SMJDB_SCH',@option="jname=DMP_SMJDB_JOB,jdesc=Nightly SMJDB dump at 22hrs,jcmd=dump database smjdb using config = 'dmpcfg_db',days=Monday:Tuesday:Wednesday:Thursday:Friday,starttime=10:00pm"
 
sybadm> go

 Create transaction log dump with "SMJLOG" database name:

 sybadm> sp_sjobcreate @name='DMPTX_SMJLOG_SCH',@option="jname=DMPTX_SMJLOG_JOB,jdesc=Hourly SMJLOG tran Dumps,jcmd=dump tran smjlog using config = 'dmpcfg_tx',starttime=06:00am,endtime=09:00pm,repeats=1hour,sproperties=continuous_run"
 
sybadm> go 

To check the scheduled job:

smjadm> sp_sjobhelp @name='<schedulename>'

smjadm> go





Reference:

  • SAP Snote
  • SAP help

Saturday, 16 March 2024

How to reduce the number of entries of table SOFFCONT1?

 


How to reduce the number of entries of table SOFFCONT1?

     Table SOFFCONT1 is the database table used by Business Communication Services (SAPoffice, SAPconnect, GOS) and KPRO to store content related to storage category SOFFDB, that contains the attachments from all messages that are sent from SAP (fax, email etc..) therefore it will contain many entries.

what kind of objects are stored in SOFFCONT1 table?

SAPoffice documents are created in all of the above scenarios. The document contents are stored in two different ways:

  • The document is not stored using the Knowledge Provider (KPRO).

The document is a text document and is not stored using the KPRO. The contents of the document are displayed directly in Table SOC3. The indicator that shows whether a document has been stored using KPRO is found in table SOOD-EXTCT.

  • The document is stored using the knowledge provider.

Binary documents are stored using the KPRO. The contents of the document are managed by the KPRO. For this purpose, it recognizes a Logical Object ID (LOIO) and a Physical Object ID (PHIO). The SAPoffice component accesses this using the LOIO, which is stored in table SOC3.

In the standard settings, the KPRO stores the SAPoffice data in the database table SOFFCONT1. You can also select an external content server or an archive system as somewhere to store the documents. The storage location is determined using the content repository 'SOFFDB'. You can check the storage location for the SAPoffice data in your system using Transaction 'OAC0'.

Note: It is not possible to determine the storage location for individual document types. It is also not possible to determine in which scenario the document was created. You can only determine whether SAPoffice documents are stored in the ' SOFFCONT1' database table using the KPRO or in an external system.

Further queries:

  • Which document types are stored using the KPRO?
  • all documents that are transferred to a SAPoffice interface in binary form,
  • external documents (type EXT), providing that they are not text documents
  • OTF documents.
  • ALI documents.
  • Can I determine whether a document is stored in the KPRO?
  • (Information for technical support) 
The corresponding document in table SOOD contains an indicator for the knowledge provider. The SOOD-EXTCT field may contain the following values:


Is it possible to store the GOS attachment list in a particular way?

No, even the attachments in the GOS attachment list are stored as SAPoffice documents.

Here are 2 ways to have less entries in SOFFCONT1, using the SAPoffice reorganization report or relocating data from table SOFFCONT1 to a content server:

1. SAPoffice Reorganization Report:

Use the SAPoffice reorganization process to delete entries in SOFFCONT1 that are no longer referenced by any User/folder, etc. Please note that the reorganization report RSBCS_REORG will only delete the entries from the SOFFCONT1 table, the size in the DB should be reduced using the database tool.

2. Content Server:

To store documents in an content server instead of SOFFCONT1 table, set a new storage category for DocuClass SOFFPHIO in transaction SKPR08 which is pointing to the Storage Category in transaction OACT which is pointing to the content repository in OAC0 which resides in the external content server you want to use.

Now new documents will be stored in the content server and existing documents in the system will remain in SOFFCONT1, KPRO will know where a file is stored based on the Storage Category (i.e. in SOFFCON1 or content server) and so a file will be displayed without an issue no matter its storage location.

You can then use the report RSIRPIRL or RSGOS_RELOCATE_ATTA to physically move the existing documents from SOFFCONT1 to a content server.

The report RSGOS_RELOCATE_ATTA can relocate GOS attachments only, and it supports the scenarios where only GOS attachments should be relocated.

The report RSGOS_RELOCATE_ATTA exist only as of SAP Basis Release 740. However, this is only an optional step as the Knowledge Provider still knows whether a document is stored in SOFFCONT1 or on the external content server and can access documents from both.

  • Report RSIRPIRL relocates all objects from SOFFCONT1 to a content server.
  • Report RSGOS_RELOCATE_ATTA does NOT replace report RSIRPIRL.
  • Regarding how to use report RSIRPIRL.

Please keep in mind, that after having less entries in table SOFFCONT1 (either due to SAPoffice reorganization or due to relocation), the size of table will not necessarily be reduced automatically as most likely a database reorganization or table compression is required after removing so many records. It is a database question (and depends what kind of database is used) how to adjust the table size after entries are removed from a table.




Reference:

Wednesday, 6 March 2024

Artificial Intelligence in SAP Solutions



Artificial Intelligence in SAP Solutions:

Artificial Intelligence adoption continues growing

                      The ability to think and learn in humans is called natural intelligence, therefore in machines, we call it artificial intelligence (AI). There are two primary types of AI: traditional and generative. Traditional AI can recognize patterns, but generative AI creates new patterns based on the recognized historical patterns and any additional data that's provided. Machine learning is a subset of AI, focused on teaching computers to learn from data and improve with experience, instead of being explicitly programmed to do so. In machine learning, algorithms are trained to find patterns and correlations in large data sets, and to make the best decisions and predictions based on these analyses. Machine learning applications improve with use and become more accurate the more data they have access to.



 

Saturday, 2 March 2024

General Concepts of Cloud Computing

 


General Concepts of Cloud Computing.

Introduction to Cloud Computing

             Cloud computing is the delivery of applications, platforms, data storage, operating systems, and other computing resources over the Internet. In the cloud model, you pay a regular subscription fee to consume certain services from a third party provider. 
              
            This is similar to how you consume services in your home such as water and electricity. You pay the utility provider on a monthly or quarterly basis, and the provider is responsible for delivering services to you, and maintaining the infrastructure necessary to deliver those services (public water pipes, power lines). If there is an issue, you would contact the service provider for a resolution. For example, if there is a power outage due to a thunderstorm, the utility provider is responsible for troubleshooting and taking the necessary steps to resolve the issue and reinstate your service.


This is a stark contrast to the traditional on-premise model, where the customer is responsible for purchasing and maintaining the server(s) where the software is installed, and the software itself. This includes setting up redundancies to back up data, and security measures to protect both the physical servers on site, and the software in the virtual space. For example, if the customer's server crashes and needs to be rebooted, an employee within the organization must handle this task, and all employees using the software wouldn't be able to access the system while it's down. What if data was lost during the crash? For a large organization, it may be feasible to budget for a team of people to maintain the servers, software, redundancies, and security, but small and mid-size organizations need a cost-effective solution where they know their data is safe and their applications are accessible when they need them. Large organizations also look to cloud software to help them reduce the cost of maintenance while gaining the benefits described in the below:

Elasticity:
              Increase or decrease the storage space and computing power you need to meet fluctuating workload requirements.

Affordability:
            Minimize hardware and IT (Information Technology) department costs; only pay for what you use.

Availability:
             24 x 7 x 365 system access from anywhere, on any device.

Security:
             Improve compliance, protect data, and mitigate risk with continuous security updates from the cloud provider.

Innovation:
            Rapidly adopt new technologies to innovate faster, while simplifying the IT department's maintenance responsibilities.

Agility:
         Set-up cloud system(s) to quickly react to changing market conditions and business needs.











Reference:(Educational Purpose)
  1. Learing.sap.com


Friday, 1 March 2024

Getting Logon pop-up in transaction CSADMIN - SAP Content Server 750 and higher

 


Getting Logon pop-up in transaction CSADMIN - SAP Content Server 750 and higher:


When accessing transaction CSADMIN through transaction OAC0, a logon pop-up comes up:



Why its happen at the time of SAP Content Server 750 or higher installation, the option "AdminSecurity" was enabled by default on SWPM.


Admin Security is enabled by default (if not explicitly deactivated during installation). When it is enabled, authentication is required for some maintenance tasks in CSADMIN.
This is a security measure to prevent unauthorized administration access to Content Repositories through CSADMIN transaction.
The '<sid>adm' user must be used with the global password that you specified during the installation.

If necessary to disable the logon pop-up, follow these instructions.

For a new installation:
  • When installing SAP Content Server 750, uncheck the 'Enable AdminSecurity' box in the Software Provisioning Manager.
For an existing installation:
  • AdminSecurity is now controlled by parameter icm/HTTP/auth_0.To disable this authentication, edit the SAP Content Server profile on path /usr/sap/<SID>/SYS/profile/<SID>_C<Ins.no)_<hostname>.
Add the "#" character to comment the whole line of parameter icm/HTTP/auth_0.

See the example:


Reference:
  1. help.sap.com
  2. Sap snote