SAP Business One Version For HANA Fiori Style Cockpit "Not Authorized"

-

 


  
Solution :
After the installation, to enable the Fiori-stylecockpit and pervasive analytics to work well with SAP HANA multitenant database containers, the app framework must be configured.

1. Log on to the SAP HANA studio and proceed as below:
   - In the Systems list, right-clicka blank space and choose Add System
   - In the Specify System window, separately add a system database and a tenant database. 
            o To add a system database, in the Mode field, you must select Multiple containers and System                 database, and then click Next. 
           o To add a tenant database, in the Mode field, you must select Multiple containers and Tenant      
               database, enter the name of tenant database, and then click Next. 
As a result, you can see two systems the Systems list. One is the system database (for example, SYSTEMDB@HDB(SYSTEM)) and the other is the tenant database (for example, DEV@HDB(SYSTEM)).

2. Double-click the system of system database (for example, SYSTEMDB@HDB(SYSTEM)). On the Configuration tab, choose webdispatcher.ini → profile → wdisp/system_auto_configuration and set the default value to true.

3. Log on to the SLD control center. On the Services tab, copy the link of App Framework. Normally, the URL is https://:43xx (where "xx" represents the SAP HANA instance number). For example, https://abchcd50500:4301.

4. In the SAP HANA Studio, do the following:
     -Double-click the tenant database (for example, DEV@HDB(SYSTEM)).
     -On the Configuration tab, choose xsengine.ini→ public_urls→ https_url and paste the URL which         is copied in step 2 (for example, https://abchcd50500:4301) to the system value. You can also                choose xsengine.ini→ public_urls→ http_url and enter http://:80xx (where "xx" represents the                SAPHANA instance number) in the system value.

Example: You copied https://abchcd50500:4301 in step 3. Then, on the Configuration tab, you choose xsengine.ini→ public_urls→ http_url and enter http://abchcd50500:8001 in the system value.










Comments

Post a Comment

Popular posts from this blog

SAP Business One Web Client Tiles Not Loading (tiles.svc 500 Internal Server Error)

-
Image
Error: W hile trying to read the field 'bind' of a null object loaded from field com.sap.b1.infra.meta.tile.Tile.action of an object loaded from local variable 'tile" when we are logging into specific company Issue: This issue mainly occurs when adding any web client extension tile to the web client home page and you unassign the extension from the extension manager. Solution: Delete the existing users from the SAP Business One and OUSR table and then recreate the user. Then tiles should load in the Web client.
Read more

SAP Business One Company Initialization Error SAP DBTech JDBC: [259]: invalid table name: Could not find table/view M_TIME_DIMENSION in schema _SYS_BI

-
Image
 Error:  2022-04-29 11:03:39|ERROR|ENABLEMENT|Failed to re-initialize company :module id=Hana Model Deployer; cause:com.sap.businessone.model.renew.exception.ModelException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name:   Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)| 2022-04-29 11:03:38|ERROR|MODEL_DEPLOYMENT|Failed to execute sql statement: Create View Next6MonthEndView  as Select Top 6 Year, Month, Max(Date_SQL) as MonthEnd From _SYS_BI.M_TIME_DIMENSION Where Date_SAP <= Last_Day(Add_Months(Add_Days(CURRENT_DATE, 1-DayOfMonth(CURRENT_DATE)), 6)) and Date_Sql >Last_Day(CURRENT_DATE) Group By Year , Month Order By Year Desc, Month Desc, root cause: SAP DBTech JDBC: [259]: invalid table name:   Could not find table/view M_TIME_DIMENSION in schema _SYS_BI: line 4 col 14 (at pos 99)| Solution:   Login to HANA studio  Run the below Query from SYSTEM...
Read more