Since I always find it hard to gather the “right” packages for a fresh install of SLES for SAP Business One, here is a summary of repositories and associated packages required.
The following information was gathered from installing using the “SLE-15-SP3-Full-x86_64-QU2-Media1.iso”, however, the same should apply when installing from the “GM” release, or the newest “QU3” release. Packages were validated against the SAP Business One Administrator’s Guide, version for SAP HANA corresponding to FP2202 (the latest as of now).
During installation (or after), enable the following repositories, so that you can install the packages they provide:
If the required repositories are enabled, you should be able to install all the prerequisites with the following one-liner:
zypper in -y bc glibc-i18ndata insserv-compat libcap-progs libssh2-1 nfs-kernel-server python samba samba-client zip libicu60_2 python2-pyOpenSSL python-gtk rpm-build xmlstarletIf you do need to enable the required repositories after the installation, and have an active subscription or trial code, here are the commands to do so. Note that the Workstation Extension requires a separate registration code. Instead of activating the repositories online, you can use the “Full” media and enable these repositories during installation or from yast2.
SUSEConnect -p sle-module-basesystem/15.3/x86_64
SUSEConnect -p sle-module-legacy/15.3/x86_64
SUSEConnect -p sle-module-python2/15.3/x86_64
SUSEConnect -p sle-we/15.3/x86_64 -r <registration-code>
SUSEConnect -p sle-module-development-tools/15.3/x86_64
SUSEConnect -p sle-module-server-applications/15.3/x86_64If you plan to only install SAP HANA (2.0 SP05 SPS 056) on the same machine, the prerequisites are much more simple:
zypper in -y libatomic1 insserv-compat
Scenario: you want to create a Calculation View and once you execute receive error .
Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed: The following errors occurred: user is not Authorize (2950)
Solution :
Run the below command for each Schema.
GRANT SELECT ON SCHEMA "SBOCONENERGY_TEST" TO _SYS_REPO WITH GRANT OPTION;
Select AccountCode,AccountName,Title from (
Select OACT.AcctCode as AccountCode, OACT.AcctName as AccountName,OACT.GroupMask,OACT.GrpLine,OACT.Postable as Title
from OACT
Where OACT.Postable='Y'
UNION ALL
Select OACT.AcctCode as AccountCode, OACT.AcctName as AccountName,OACT.GroupMask,OACT.GrpLine,OACT.Postable as Title
from OACT
Where OACT.Postable='N'
) as T
ORDER BY T.GroupMask,T.GrpLine
Properties current SAP Connection command line argument: 0030002C0030002C00530041005000420044005F00440061007400650076002C0050004C006F006D0056004900490056
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Windows.Forms;
using SAPbobsCOM;
namespace MySAPB1WinFormApp
{
static class Program
{
/// <summary>
/// The main entry point for the application.
/// </summary>
///
public static SAPbouiCOM.Application oApplication = null;
public static SAPbobsCOM.Company oCompany = null;
[STAThread]
static void Main()
{
if(IsSAPConnected()==true)
{
}
}
public static bool IsSAPConnected()
{
try
{
int oErrorValue = -1;
string oErrorMessage = string.Empty;
//***Step:1
//***** in this step we getting the Application
SAPbouiCOM.SboGuiApi oSboGuiApi = new SAPbouiCOM.SboGuiApi();
string[] strCon = Environment.GetCommandLineArgs();
oSboGuiApi.Connect(strCon[1]);
oApplication = oSboGuiApi.GetApplication(-1);
//**************************************************
oApplication.StatusBar.SetText("SampleFormAddon is Connection", SAPbouiCOM.BoMessageTime.bmt_Short, SAPbouiCOM.BoStatusBarMessageType.smt_Success);
//*** Step 2
// in this step company object generates the cookie for the current session with the help of method GetContextcookie()
oCompany = new SAPbobsCOM.Company();
string oCookies =(string) oCompany.GetContextCookie();
//**********************************************************
//*** Step 3
//****** in this step GetConnectionContext(oCookies) method of the application object encrypt the connection string with the help of Cookies provided by the DI API
string constr = oApplication.Company.GetConnectionContext(oCookies);
//*************************************
if (oCompany.Connected == true)
oCompany.Disconnect();
//***Step4
//*** in this step setsbologincontext(constr) method of company object deciphers the encrypted connection information and sets the connection parameter to the company object
oCompany.SetSboLoginContext(constr);
//**************************************************
///**Step 5
///*** in this step with the help of connect() method we establish connection with the company
oErrorValue = oCompany.Connect();
if (oErrorValue == 0)
{
oApplication.MessageBox("Single Sign on connection established", 1, "Alert", "", "");
return true;
}
else
oCompany.GetLastError(out oErrorValue, out oErrorMessage);
oApplication.MessageBox("ErrorCode" + oErrorValue + "ErroMessage" + oErrorMessage.ToString(), 1, "Error", "", "");
return false;
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
}
}
numbervar x := {OINV.DocTotal};
numbervar ipart;
numberVar decpart;
ipart := int(x);
decpart := x - ipart;
Propercase(Replace(towords(ipart)," and xx / 100",""))& " Ringgit" &
if decpart = 0 then "" else " and "&Propercase(Replace(towords(decpart*100)," and xx / 100","")) &" sen";
Step 1: Go to Tools > Query generator >
