Better late than never: Your solution worked just fine !
Thanks !
/Jens
-----Oprindelig meddelelse-----
Fra: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] vegne af hwimmer
Sendt: 5. april 2006 09:26
Til: Axapta-Knowledge-Village@yahoogroups.com
Emne: [Axapta-Knowledge-Village] Re: Problem with "Online users" ...
Hi Jens! I think you are struggling with a standard error in the
online user form that is occurring with Oracle only. Please check the
"Info" class and there the methods:
* licensedUsers * licensedComUsers * licensedAOSUsers *
licensedObjectServers
In all those 4 methods (well, "licensedUsers" is the most important, but
please change the others as well), add the following line to the "select
sysconfigtemp" statement: && sysConfigTemp.ConfigType ==
ConfigType::AccessCodes; So, the select statement should look
something like this: select sysConfigTemp
where sysConfigTemp.id == licenseCodeNum(...)
&& sysConfigTemp.ConfigType == ConfigType::AccessCodes; Why
all that? Well, when you start the Online Users form, Axapta will check
how many users are in your license. It will then only show online users
up to that amount. The methods above are not giving back the correct
numbers because they are looking into the wrong record. Why is it only
on Oracle? --> On MSSQL, there is a Clustered Index used on the
Sysconfig table so that Axapta chooses the right records by chance !
Example: the method "licensedUsers" looks like this in standard Axapta
3.0 SP3 select sysConfigTemp
where sysConfigTemp.id == licenseCodeNum(SysUsers);
The Id that should be selected is 10.
Problem: there are 2 records with ID 10! --> one with ConfigType =
"AccessCodes" (that would be the correct one) and one with ConfigType =
"ConfigurationKey"
I hope it will solve your problem. I will also posted this solution on
my blog http://axaptafreak.blogspot.com
<http://axaptafreak.blogspot.com> . Best regards, Helmut
http://axaptafreak.blogspot.com <http://axaptafreak.blogspot.com>
--- In Axapta-Knowledge-Village@yahoogroups.com, "Jens Strandberg"
<[EMAIL PROTECTED]> wrote:
>
>
> As you may or may not know removing the axdat.udb in the appl/standard
> directory should fix the problem, if not all current users show up in
the
> form "Online users".
>
> Now, we have never had problems with this, but one of our 2 AOS
servers went
> down a couple of days ago, and since that time, only 4 users are
displayed.
> I have shut down both AOS managers, deleted the axdat.udb file and
> restarted, but the problem won't go away.
>
> At peek time we have around 65 users online, but only 4 are displayed,
which
> is quite annoying.
>
> I did NOT restart the server itself - only the AOS manager.
>
> Any advice ? Would it make any difference to restart the Windows
servers ?
>
> Running Ax 3.0 SP4 with AOS on Windows2003 and Oracle 9 as DB.
>
> Thanks in advance !
>
> /Jens
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
Yahoo! Groups Links
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
SPONSORED LINKS
| Business finance course | Business to business finance | Small business finance |
| Business finance consultant | Business finance magazine | Business finance schools |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
