KB710301: Invalid license (Excel Integration for Alea)
Symptoms: "Invalid license" error message appears after the Excel integration for Alea is opened.
Reason: Sentinel License Manager blocks Alea licenses after the computer time is adjusted, either manually, or automatically during the
Daylight saving time change. (last Sunday in March, last Sunday in October)
Error message screenshot
Solution: Stop
MIS Alea Server and
SentinelLM services at all affected servers and restart the servers afterwards.
Applies to: MIS Alea 4.1 SR7 and Rainbow Technologies Sentinel LM 7.2.0.9
KB710311: Web Client doesn't work after installation
Symptoms: The web browser displays error message
HTTP Error 404 - File or directory not found even if the
IIS is running,
.NET Framework is installed and *.htm pages in the web client installation directory are displayed correctly.
Reason: This problem usually appears after a clean installation of Microsoft Windows when the ASP.NET web service extension is not yet enabled.
Solution:
Video tutorial how to enable ASP.NET for IIS.
Applies to: Windows 2003 Server
KB803211: Web Client: "Invalid picture" error
Symptoms: The web browser displays a javascript error message "Invalid Picture" after login and it's not possible to open any of the registered folders.
Reason: This problem indicates that the TreeCombo ActiveX component is not installed at the client machine.
Solution: Navigate to
http://<yourwebsite>/ware/com_install.htm and follow the instructions.
Technical information:: datasource.aspx!GetImage, CreateObject("TreeCombo.cNet") function call failure.
Applies to: Internet Explorer 6
KB805261: Web Client: "workbook could not be found" after export to excel
Symptoms:
Error dialogReason: The file name and the path name of Excel workbook cannot exceed 218 characters. This mostly happens if you try to open the workbook directly ("Open" button) instead of saving it into a custom folder before ("Save as"). In such case Internet Explorer stores the file into a temporary folder, which path is usually longer than 90 characters.
c:\Documents and Settings\<username>\Temporary Internet Files\Content.IE5\<random folder name>\<exported filename>.xls
Workaround: Don't open the workbook directly. Save it to a custom folder with shorter path.
Applies to: Microsoft Office Excel 2003 (this behavior is by design of Microsoft Excel)
TEMPORARY: Double click in the favorites window at the startpage doesn't navigate to the web client.
Possible reason: Cross-site scripting has to be enabled if the startpage is at a different subdomain;
e.g. in case of startpage.d0189.something.com and webclient.d0189.something.com set document.domain to "something.com"
function domainize(){
document.domain="spardat.at";
}
<body onload="javascript:domainize();">
KB804141: Web Client: Database update failure. (folder administration page, etc.)
Symptoms: The web client reports the following ASP.NET error:
Could not delete from specified table.Possible reason:: The Web Client doesn't have sufficient rights to update the database.
Solution:: Ensure that the web client is configured to be running impersonated under the IUSR_DATACQUIRE account. You have to configure this in
Web.Config file in the web client installation folder.
<identity impersonate="true" userName="IUSR_DATACQUIRE" password="<password>"/>
KB807181: "Microsoft Excel is waiting for another application to complete an OLE action"
Symptoms: MEX Client reports "
Microsoft Excel is waiting for another application to complete an OLE action" when running in a
print order mode on the server.
Description: After a print order output is generated, the MEX client attempts to send an e-mail notification to the user via Outlook. When this error occurs, the notification is not sent and all the print orders wait in a queue until the message is confirmed.
Possible reason: Too many items in one or more folders of the Outlook account. (several thousand)
Solution: Clean the outlook folders (inbox, outbox or others). It's not enough to move the items to another folder within the e-mail account.
Applies to: Microsoft Outlook 2003 with Exchange server.
KB810141: "The system administrator has set policies to prevent this installation"
Symptoms: Remote Console installer (
mwconsole_setup.msi) reports "
The system administrator has set policies to prevent this installation" and exits.
Possible reason: Your windows account doesn't have sufficient rights to install the application. Either you can't install the application from the network drive or CD or you don't have rights to run *.msi installers at all.
Solutions: - If you are launching the installer from a network drive or CD, copy it to your local hard-drive and try to run it again.
- Log in with another account temporarily (local administrator e.g.) and install the program.
- If the steps above doesn't solve the problem, contact your system administrator.
KB810141: Codepage error in logfile when opening Alea 5.2 database with 4.1 client
Symptoms: Alea database v5.2 can't be opened in old client 4.1 after it has been opened in 5.2 client (at least once) even if it is running in the compatibility mode. An error appears in the logfile and it's not possible to open the database.
Solution: Switch off codepage checking in the
[INIT] section of the database config file. See the
screenshot
KB903241: Remote Console reports "Connection refused" when trying to conect to localhost.
Symptoms: Remote Console can't connect to Engine Controller running at the local computer. (localhost:8000)
Possible reason: Windows hosts file doesn't contain localhost alias for loopback IP address 127.0.0.1. (
c:\windows\system32\drivers\etc\hosts)
Solution: Append the last line from the example below into the hosts file. Create the file if it doesn't exist.
# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host
127.0.0.1 localhost
KB904061: SIS client startup fails with message "Microsoft Forms: Could not load object because it is not available on this machine"
Possible reason: Microsoft Flexgrid component (MsFlxGrd) used by the application has been disabled by windows update patch in windows registry.
Workaround 1: Uninstall KB960715
Workaround 2: Remove Microsoft Flexgrid classid from the list of disabled ActiveX objects in windows registry, using the
KB_960715_MEX_fix.reg in Datacquire prerequisities folder. This is a "safe" method that doesn't uninstall KB960715. Using the first workaround may cause that the system administrator wil re-apply the patch again.
REGEDIT4
;Microsoft FlexGrid Control, C:\Windows\SysWow64\MSFLXGRD.OCX, MSFlexGridLib.MSFlexGrid.1
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{6262D3A0-531B-11CF-91F6-C2863C385E30}]
"Compatibility Flags"=-
"AlternateCLSID"=-
;FlexGrid for Vista 64-bit
[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Internet Explorer\ActiveX Compatibility\{6262D3A0-531B-11CF-91F6-C2863C385E30}]
"Compatibility Flags"=-
"AlternateCLSID"=-
KB909011: Tree Cache doesn't work
Symptoms 1: Caching of tree elements doesn't work in the web client.
Symptoms 2: Functions ClearColumnVectorCache or ClearRowVectorCache cause EventScript error.
Reason: In some cases the tree caching component (treecache.htc) is not loaded on page startup. The exact reason is unknown, might be because of a slow proxy server or unstable internet connection.
Workaround:: Set the default page in IIS to
preload.htm instead of default.aspx at the servers where this problem persists. This page preloads the required component and redirects to default.aspx.
How to check if this workaround should be used?Use this workaround if caching starts working after the web application is refreshed using F5 in the browser. It cannot be used in the environment where startpage is used. Load balancer was not tested.
KB910161: "The Installer was interrupted before Datacquire Web Client could be installed."
Symptoms: Installation of Web Client is interrupted prematurely.
Solution: Go to Control Panel / Programs and Features / Turn Windows Features on or off / Internet Information Service / Web Management Tools / IIS6 Management Compatibility and install
IIS Metabase & IIS6 configuration compatibility.
Applies to: IIS7 (Windows 7, Windows Vista)
KB1001131: MEX Client crashes on startup (Error &H80004005 followed by "Out of memory")
Possible reason: Refedit.dll is broken.
Solution: Open Microsoft Excel and run Dectect and repair (or Excel 2007 diagnose)
Applies to: Microsoft Office 2003, MEX Client 9.9.X (Windows XP Professional)
KB1002011: Excel integration for Alea: "The license server does not have any license that matches the requested feature for the server."
Problem description: Unable to connect to alea database even if there's a valid license imported in Sentinel License manager (wlmadmin.exe) and the license can be reserved using slmdemo.exe. Logfile contains the following error message:
A LOGGING USER: Error >> Call of Rainbow Sentinel LM library failed with error: Error[18]: No license code is available for feature UNKNOWN on host no-net.
Possible reason: License location is set to
Standalone at the server.
Solution: Open Excel integration for Alea on the server, choose Alea -> Info -> click the button "
Register..." -> select "
use mixed mode" option -> click the "
Edit..." button and change the license type of Alea Server from
Standalone to
Network. Options in these dialog are used by Alea server even if license location is not Mixed mode(!) Don't forget to change License Location option button to the original value.
Applies to: Excel Integration for Alea 4.1, 5.2
Info:: This change can be also done manually configuration is stored in
c:\windows\alea.ini or in the user's profile directory.
KB1002011: Opening Alea 5.2 database using Excel integration for Alea 4.1 reports "Access denied".
Possible reason: Invalid DB.ini configuration.
Solution: Open DB.ini in the database root on the server and set the value of TestCodePage variable to "NO".
Applies to: Excel Integration for Alea 4.1, Alea server 5.2
KB1003081: Alea 5.2 SR3 database is slow . (draft)
LOGFILE=YES
this is not a normal quick logging, but this is something like debug-logging that means all operations are logged in logfile.bin which is stored in ../DATA directory
in each database there is also separat DB.ini file, where this parameter can be set
as solution for us we have to set this parameter under area
LOG to LOGFILE=NO
after changing this parameter ALEA service has to be stopped and started, that the changes works
KB1007081: External references
ActiveWorkbook.Worksheets("Tabelle").UsedRange.Replace what:="\\S0189SS0008\Common\MEX\Shared\MexUtl.xla!dbextget", _
Replacement:="dbextget", LookAt:=xlPart, SearchOrder:=xlByColumns, _
MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
