Solutions
| ID: | S140261 | |
| Published: | 11 February 2014 | |
| Updated: | 08 October 2018 |
Product(s)
- SBM
Description
Get the following error trying to login to SBM.
Web Services "http://<servername>:80/gsoap/gsoap_ssl.dll?sbminternalservices72" returned an error: "java.lang.IllegalArgumentException".
Resolution
Run the following query against the SBM database for the user seeing the issue where xxx is the users login name.
SELECT [TS_ID] ,[TS_LOGINID] ,[TS_TIMEPREFERENCE]
FROM [TS_USERS]
WHERE TS_loginID='xxx'
If this value is not a "0" or "1" then you will see the issue described above. The values above "1" were once valid, but are now obsolete.
To fix this just run the following sql.
UPDATE TS_USERS
SET TS_TIMEPREFERENCE = 0
WHERE (TS_LOGINID = 'xxx')
You can also find any other users that may have this issue by running the following and fixing those as needed.
SELECT [TS_ID] ,[TS_LOGINID] ,[TS_TIMEPREFERENCE]
FROM [TS_USERS]
WHERE TS_TIMEPREFERENCE not in (0,1)
After running the update sql you can either restart IIS or wait until the IIS cache refresh time which is usually around 30 min. Have the user try to login again and make sure they can get in.
