Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Saleslogix Mobile v3.0.0 Defect

Hi All,

 

We have just come across a bug which I thought we should share:

 

Steps to replicate:  ** Do not try this if you are running the new Saleslogix Mobile 3 on your live site **

 

Open the SLXMobile and enter your username Now enter the wrong password. You will receive the standard warning “The username or password is invalid”

 

Now remove the password and enter the correct password. You will now receive another warning/error ‘A problem occurred on the server’ From now on the user will not be able to use the SLXMobile! All other users will be fine until you do the same. The user will still be able to access the LAN and WEB client fine.

 

The only way I have been able to resolve this so far is by completely removing the SLXMobile directory and redeploying v2.2 – Swiftpage UK have replicate this and are now in the process of escalating it to the US.

Regards, Adam Travers
empath-e Services Limited
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix Mobile v3.0.0 Defect

Same bug in 3.0.1

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Highlighted
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: Saleslogix Mobile v3.0.0 Defect

Thanks RJ - I thought the issue only occurred in v3.0.1 until I worked back through the versions

.

Mike has just created a temporary fix which we may use if this does not get resolved within the next 24hrs.

 

Temp Fix: Remove the Primary Key on the Userid column within the UserSecurity table and set the Userid to allow NULLs. Grab the ID from the Userinfo table to update the Usersecurity table where the Userid is NULL

 

Regards, Adam Travers
empath-e Services Limited
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix Mobile v3.0.0 Defect

3.0.0 and 3.0.1 are SO close to each other  - the real diff has to do w/Custom Hash Tags showing not showing up in the lookup in 3.0.0.

 

Humm.. not comfortable w/ making the USERID allow nulls.... We really need a fix asap from the dev team (like today).

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Posts: 445
Registered: ‎08-07-2008

Re: Saleslogix Mobile v3.0.0 Defect

There is a very strong chance that this is a Web Core issue and not directly Mobile 3.0.1. We have logged a defect (13093076) with SData where if a failed attempt passes through SData that the user will be locked out. There are multiple scenarios around this but that is the general idea. The defect was logged for Web Core 04 and is slated to be fixed in Web Core 05. I don't see a post here where the exact version of SalesLogix Web was called out, but if you have Core 04 applied that is the likely culprit. Please contact SalesLogix Support for assistance.

 

13093076:  In SData, if there is a failed login attempt an error displays

Garrett Hyde | Technical Support Analyst, Senior
Infor CRM
office: 800 944 5709 | Garrett.Hyde@Infor.com | www.infor.com

Infor + Saleslogix Global Conference | Nov 2 - 5, 2014 | Scottsdale | saleslogix.com/conference
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix Mobile v3.0.0 Defect

It certainly looks like the culprit is in SData where the attempted login fail logic is stepping on mobility.

 

Humm wonder if doing:

 Update sysdba.USERSECURITY SET LOGINATTEMPTS = 0

would clear the problem?

Might have to "reset" the FAILEDATTEMPTDATE field as well (to NULL)

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Elite Contributor
Posts: 514
Registered: ‎03-24-2009

Re: Saleslogix Mobile v3.0.0 Defect

Hi RJ,

 

Check your inbox. Lets hope this interim fix from Swiftpage works for you too until WEB Core Update 05 is released for our customers. 

Regards, Adam Travers
empath-e Services Limited
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix Mobile v3.0.0 Defect

will do - thanks!

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Employee
Posts: 44
Registered: ‎08-19-2009

Re: Saleslogix Mobile v3.0.0 Defect

Hi all,

 

********IMPORTANT*********

 

Please note this is NOT an interium fix, it is purely a validation build of 2 files for Web 05.

 

This file is provided in confidence to BPs and should not be passed around the community.

It will only be released expressely from SalesLogix Support under guidenance from our colleagues the US Development and 3rd Line Support Teams.

 

These files are NOT SUPPORTED and anyone using them does so at their own risk.

 

 

Kind regards,

 

Andrew

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix Mobile v3.0.0 Defect

This WILL clear up the problem and let you log in:

 

UPDATE sysdba.USERSECURITY
SET LOGINATTEMPTS = 0
where LOGINATTEMPTS is not null and LOGINATTEMPTS > 0

 

However, once you "fail it again".. you will have to run an update.

 

On our system I'm using a simple TaskCentre task to handle the problem.. you could create a scheduled WIndows Task to do it as well (if you know how to fire off a SQL statement via a "bat" file ;-)

 

Note this is NOT unique to mobility 3.0 or 3.0.1 - 2.2 can fail too .. it's an SData portal issue.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html