How to unlock SAP Business One version for HANA manager user using query

-

 Solution : Open the SQL console  from particular company schema and run below query 

                   UPDATE OUSR SET "Locked" = 'N' where "USER_CODE" = 'manager';

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