service app configuration "-900002 Invalid license type"

[silambarasan_rajendran]

Dear Expert,

I am trying to configure SAP Business one Service App getting error message as below. Is it required separate license?

Please help me.

thanks,

silambu

[jamaltarifi]

I’m facing the same issue since I upgraded the system to 10.0 FP2011 Hana.

I read a document that said if you uninstall SAPb1 server tools and reinstall it on the Linux it can cause an issue of registration in the SLDdata schema in some table and that SAP will release a fix in the next patch.

I formatted my Linux, installed a fresh copy of sles15sp2, new Hana 2.0 HDB database. And fresh SAPB1 server tools without my SSL certificate this time (kept everything pretty much at default value)

On windows I uninstalled everything sap related restarted the windows system and reinstalled all the B1 windows components.

created a new company in SAPb1 client with Israel localization which correspond to my license, added a new user gave it full permission. Assigned professional license to the manager username and the new (not super user) username.

Tested the system, I still got -900002 invalid license for both users when logging in from the SLD control center.

So at this point I knew my company database is not the issue as everything freshly installed.

so I decided to create a new company with MENA localization (trial version), Offcourse there’s no license to assign here as its company (I only have Israel license).

I logged in SAP mobile from the SLD control panel to the new trial MENA company and it worked.

At this point I knew the issue is actually related to the license generated by SAP. I still didn’t get a solution as the trial MENA company is useless for me. But I thought about sharing all my troubleshooting and testing where’s the issue is with everyone.

this way I know my system is correctly installed and the network is fine, my ssl certificate is fine, my company database is also fine. And it’s something SAP need to provide a hot fix for it.

if you found a solution please share thank you:)

[bruno_fagundes]

Hi,

I had the same situation that you, I able to fix executing the query:

 update SLDDATA.HOSTINGUNITS set LICENSESERVER_ID=(select ID from SLDDATA.LICENSESERVERS); 

[jamaltarifi]

Yes, I confirm this solution worked for me,. My SAP partner shared this with me few days ago and I tested it and now SAP sales app is working again 🙂 Thank you!

[hamedmf]

Confirmed the solution on B1 V10 HANA 2018

[nidhisingh14]

Hi silambarasan.rajendran

Please provide result of below mentioned query :

SELECT "HOSTINGUNITS"."ID" AS "HOSTINGUNIT_ID",
"MOBILESERVICES"."HOSTINGUNIT_ID" AS "MOBILESERVICES_HOSTINGUNIT_ID",
"LICENSESERVER_ID" AS "HOSTINGUNIT_LICENSESERVER_ID",
"LICENSESERVERS"."ID" AS "LICENSESERVERS_ID"
FROM "SLDDATA"."HOSTINGUNITS", "SLDDATA"."MOBILESERVICES","SLDDATA"."LICENSESERVERS";

In query result if you found that HOSTINGUNIT_LICENSESERVER_ID column is empty (?) then please apply below query to fix the issue:

update SLDDATA.HOSTINGUNITS set LICENSESERVER_ID=(select ID from SLDDATA.LICENSESERVERS);

If you found any other column is empty in query result then please provide us result and we will provide you corrective query.

Kind Regards
Nidhi Singh
SAP Business One Support

[richardduffy]

Nidhi,

We are encountering a similar issue when using the Service App on FP 2105 with SQL.

We have run the query and all our hosting units have the right license server id referenced and there are no empty fields.

Any thoughts on this issue?

[nidhisingh14]

Hi rduffy_smb_cloud

Could you please provide result of below mentioned query :

SELECT "HOSTINGUNITS"."ID" AS "HOSTINGUNIT_ID",
"MOBILESERVICES"."HOSTINGUNIT_ID" AS "MOBILESERVICES_HOSTINGUNIT_ID",
"LICENSESERVER_ID" AS "HOSTINGUNIT_LICENSESERVER_ID",
"LICENSESERVERS"."ID" AS "LICENSESERVERS_ID"

FROM "SLDDATA"."HOSTINGUNITS", "SLDDATA"."MOBILESERVICES","SLDDATA"."LICENSESERVERS";

Also provide details mentioned in section 7 of SAP note 2267084.

Kind Regards
Nidhi Singh
SAP Business One Support

[PierreBrothier]

Hi,

have you check the note https://launchpad.support.sap.com/#/notes/2267084

SAP Business One Sales, Mobile App for iOS and Android - Troubleshooting and Compatibility Information

Error: License type is invalid.Confirm that the manager user has no connected sessions or only one connected session from SAP Business One client. If the manager user has already two sessions connected from SAP Business One Client from two different Windows machines, then trying to login from the SAP Business One Sales Mobile App, the Mobile Service will call sboconnect to kick off the other session. Since there are already two sessions connected, sboconnect will not know which one to kick off. So the License Server will pop up error message "You have two connected sessions, login is forbidden" and from the SAP Business One Sales Mobile App, the manager user will not be able to login successfully and the App will pop up an error message "Invalid license, License type is invalid". This is License Server limitation.For non-manager user, if the user login from SAP Business One Client and then login from another Windows machine SAP Business One Client, the previous session will be locked. Then, the same user login from the SAP Business One Sales Mobile App, the user will not be able to login successfully and the App will pop up an error message "Invalid license, License type is invalid". This is License Server limitation. For this scenario, please confirm that non-manager user has no connected sessions from SAP Business One client.Otherwise, refer to SAP Note 2383517.

[former_member186605]

hm, have you looked it up in corresponding docu? Any SAP Business One user license or the separate mobile license is needed here. Best, Peter

[steentje1986]

update SLDDATA.HOSTINGUNITS set LICENSESERVER_ID=(select ID from SLDDATA.LICENSESERVERS);

is working for me

[sardsura]

update SLDDATA.HOSTINGUNITS set LICENSESERVER_ID=(select ID from SLDDATA.LICENSESERVERS);

confirm....!!!

[silambarasan_rajendran]

Dear Mr. Peter,

We have license for SAP Business One user. In "SLD" I'm trying to open mobile service it shows error message like "-900002 Invalid license type".

Thanks,

silambu