Category
Product Version
Topic
Subtopic
LAN DAEMON Operating System information (4377922)
In addition to the operating systems specified in the Quest erwin Data Modeler installation guide, do you also support Lan Daemon on the latest versions of CentOS 7 or RHEL 7 (Linux)? ... While many other distributions may function without problems, they are not officially supported.
What encryption algorithm does the Erwin Mart solution use when registering passwords (4377595)
What encryption algorithm does the Erwin Mart solution use when registering passwords ... we are using the “AesCryptoServiceProvider” as our encryption Algorithm . AesCryptoServiceProvider Class (blocksize – 128, keysize – 256
Guidelines Upgrading to 12.5.2 (4375011)
Guidelines upgrading to erwin Mart Portal 12.5.2 Please follow guidelines below when upgrading to erwin Mart 12.5.2<br> <ol><li>Make sure you have Production DB Back up planned prior to upgrading to latest version of Mart.</li><li>If you are testing in Sandbox environment, also have back up of test environment as well.</li><li>If you have any issues after upgrading to newer version, raise support ticket with backup DB where issue exist.
When scheduling a reverse engineer job how can I have erwin DM automatically pick up new tables? (4371829)
When scheduling a Reverse Engineer job, I want to make sure that when new tables are added in Snowflake (in the same schema), they are automatically included in the Reverse Engineer job. ... How can we do this?
erwin DM - how to generate GRANT syntax for Oracle (4369435)
How to generate syntax for GRANTs for an Oracle model? ... There is no way to enter permissions or GRANTs for Oracle in erwin DM? ... This is not supported currently, but there is a workaround which will work not only for Oracle but also for other supported target databases where these properties are not yet available.
When performing a Complete Compare I am not able to Expand or Minimize the Differences. (4279740)
When performing a Complete Compare I am not able to Expand or Minimize the Differences. ... This issue can be reproduced with multiple models on the same erwin Data Modeler client application.</p> <p><strong>Versions: </strong>erwin Data Modeler 9.8 and above.</p> <p><strong>Steps to Reproduce: </strong></p> <ol><li>Invoke the Complete Compare feature by clicking the Actions menu and selecting Complete Compare</li><li>When in the Complete Compare Wizard, choose the Target and Source models with the necessary Object Selection</li><li>Click the Compare button</li><li>In the Resolve Differences
Domain Service user account unable to run Mart Portal Services (4378388)
There are occasions when the erwin Mart Portal services (erwin Apache Server, erwin ER360, erwinMartPortal, and erwinVaultService) are required to be enabled only through a Domain Service user account (or other custom elevated Administrative account).
Import using MIMB Bridge no internet connection (4371997)
When running erwin using import from external files without internet access. ... No internet connection. ... Bridge use jar file needs to be downloaded to user's machine ... as a workaround. ... This command downloads all the files locally, file are Downloaded Third-Party Software
Mart Portal Display Name shows as Full qualified DN string instead of UserName (4378059)
eg ... This is due to user is already exist in DB so the user display name is not changed ... Workaround to remove the existing user from database by running below query:
What cryptography algorithm is used for 'Mart' users? (4377601)
Which encryption algorithm used to secure Mart user passwords in the database?
Error "Compile Error: Can’t find project or library" during upload from Excel to Erwin 2019 R1 (4288115)
<p>When using the VBA Code or Macros in Microsoft Access or Excel, the following error is received “Compile Error: Can’t find project or library”</p> ... <p><img alt="mceclip0.png" src="https://support.quest.com/kbarticleimages/ER/360045793031/mceclip0.png"></img></p>
Erwin Data Modeler - The vulnerabilities using zlib 1.2.8 and 1.2.11, CVE-2016-9843;CVE-2016-9842 and CVE-2022-37434 (4369860)
Install any one of the above-mentioned DM build<br>2. ... Open installation folder “C:\Program Files\erwin\Data Modeler r9”<br>3. ... Replace “zlib128.dll” file with the latest version library attached here<br>4.
How to Configure LDAPS in Mart Server ? (4289085)
Question: my organization is using LDAPs instead of LDAP and we need to configure LDAPs instead of LDAP in our Mart authentication. ... How should I do that? ... Answer: ... To configure LDAPs instead of LDAP
Is there a manual for erwinSpy? (4310531)
Is there a manual for erwinSpy? ... Is there a manual for erwinSpy? ... Also, are there any resources to understand how erwinSpy can be used? ... Solution: ... Please see the following:
Apache Log4j vulnerability erwin DM 12.1 CVE-2022-22978 (4289425)
erwin DM use SparkJDBC Drive for Databricks ... Please download latest SparkJDBC42.jar file from below URL and place the file in erwin Data Modeler 12.1 install directory and usage. ... erwin Data Modeler Install Directory: C:\Program Files\erwin\Data Modeler r9\JDBC_JAR\SparkJDBC42.jar
Erwin tool access (4366838)
https://prod-support-images-cfm.s3.amazonaws.com/KB_kA06R0000007NmtSAE_Hard drive serial number lookup timeout.JPG ... -3639 indicates that one of the Windows system calls used to look up the hard drive serial number is timing out after 5 seconds.
How to make an offline license for ER360 (4373544)
12.5 ER360 could not make an offline license. ... <p><img src="https://prod-support-images-cfm.s3.amazonaws.com/KB_kA06R000000HL3YSAW_error_online_license.png"></img></p>
I have tables to an existing model and it will not allow me to change the durability on the tables. (4376562)
I have tables to an existing model and it will not allow me to change the durability on the tables. ... Some are Blank for Durability and they will not update to Data and Schema to be the same as the other tables.
After delete er360 and reinitialize er360, the index search does not work anymore (4376310)
After delete er360 and reinitialize er360, the index search does not work anymore This is due to index corruption as indicated in er360 log:<br> Failed to complete request: org.apache.lucene.index.CorruptIndexException: Unexpected file read error while reading index.
Slow performance in login/ inconsistent login error / loading page slow (4376169)
We are seeing slow performance in LDAP user login. ... sometimes we inconsistently experience username and password invalid error, when errors encountered, by keeping on click ok, the error goes away and user will login successfully.
How to get the debug logs in erwin Mart Portal 12.5? (4372897)
How to get the debug logs in erwin Mart Portal 12.5? ... How to get the debug logs in erwin Mart Portal 12.5? ... 1) Stop all four services, <br>erwinApacheServer<br>erwinER360<br>erwinMartPortal<br>erwinVaultService<br>2) Go to the directory C:\Program Files\erwin\Mart Portal\MartApp\config<br>edit the files <br>log4j2-er360.xml<br>log4j2-portal.xml<br>log4j2-vaultservice.xml<br>Change all occurrences of INFO to DEBUG<br>3) Save the changes<br>4) Restart all the services in step 1<br>5) Reproduce the issue<br>6) Gather the log files from
Importing model in er360 getting error ava.lang.OutOfMemoryError: Java heap space (4375589)
Importing model in er360 getting error ava.lang.OutOfMemoryError: Java heap space Importing model in er360 getting error ava.lang.OutOfMemoryError: Java heap space <span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;"><span style="font-size: 11.0pt;"><span style="font-family: "Aptos",sans-serif;">You can increase heap size by modifying the file</span></span></span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;"><b><u>Run as Service</u></b>: Go and update the file with below text or just add yellow highlighted text - C:\Program Files\erwin\Mart Portal\<span style="color: red;">create_service.cmd</span></span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">"%APACHE_HOME%\httpd.exe" -k install -n "erwin Apache Server"</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">timeout /t 5</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">sc create "erwinMartPortal" binpath="C:\Program Files\erwin\Mart Portal\srvany.exe" start=auto</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">timeout /t 5</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">sc create "erwinVaultService" binpath="C:\Program Files\erwin\Mart Portal\srvany.exe" start=auto</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">timeout /t 5</span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">reg add "HKLM\SYSTEM\CurrentControlSet\Services\erwinMartPortal\Parameters" /v Application /d "\"%JRE_HOME%\bin\java.exe\" <span style="background: yellow;">-Xms2048m -Xmx10240m</span> -Dlogging.config=\"file:C:\Program Files\erwin\Mart Portal\MartApp\config\log4j2-portal.xml\" -jar \"C:\Program Files\erwin\Mart Portal\MartApp\MartPortal.jar\""</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">reg add "HKLM\SYSTEM\CurrentControlSet\Services\erwinVaultService\Parameters" /v Application /d "\"%JRE_HOME%\bin\java.exe\" <span style="background: yellow;">-Xms2048m -Xmx4096m</span> -Dlogging.config=\"file:C:\Program Files\erwin\Mart Portal\MartApp\config\log4j2-vaultservice.xml\" -jar \"C:\Program Files\erwin\Mart Portal\MartApp\vaultservice.jar\""</span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">IF NOT EXIST "%~dp0MartApp\ER360.jar" GOTO END</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">timeout /t 5</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">reg add "HKLM\SYSTEM\CurrentControlSet\Services\erwinER360\Parameters" /v Application /d "\"%JRE_HOME%\bin\java.exe\" <span style="background: yellow;">-Xms2048m -Xmx10240m</span> -Dlogging.config=\"file:C:\Program Files\erwin\Mart Portal\MartApp\config\log4j2-er360.xml\" -jar \"C:\Program Files\erwin\Mart Portal\MartApp\ER360.jar\""</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">sc create "erwinER360" binpath="C:\Program Files\erwin\Mart Portal\srvany.exe" start=auto</span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">:END</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">timeout /t 5</span></span><br><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;"><b><u>Run as Server</u></b><b>:</b> Go and update the file with below text or just add yellow highlighted text - C:\Program Files\erwin\Mart Portal\<span style="color: red;">startMartServer.cmd</span></span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">set PATH=%JRE_HOME%\bin;%APACHE_HOME%;%PATH%</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">tasklist /fi "ImageName eq httpd.exe" /fo csv 2>NUL | find /I "httpd.exe">NUL</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">if "%ERRORLEVEL%"=="0" (GOTO App)</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">START "Apache" "httpd.exe"</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">:App</span></span><br><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">IF EXIST "%~dp0MartApp\ER360.jar" START "ER360" cmd /k java <span style="background: yellow;">-Xms2048m -Xmx10240m</span> -Dlogging.config="file:%~dp0MartApp\config\log4j2-er360.xml" -jar "%~dp0MartApp\ER360.jar"</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">START "MartPortal" cmd /k java <span style="background: yellow;">-Xms2048m -Xmx10240m</span> -Dlogging.config="file:%~dp0MartApp\config\log4j2-portal.xml" -jar "%~dp0MartApp\MartPortal.jar"</span></span><br><span style="font-size: 10pt;"><span style="font-family: Calibri,sans-serif;">START "VaultService" cmd /k java <span style="background: yellow;">-Xms2048m -Xmx4096m</span> -Dlogging.config="file:%~dp0MartApp\config\log4j2-vaultservice.xml" -jar "%~dp0MartApp\vaultservice.jar"</span></span><br><br>
Why we choose ER360 to replace erwin Web Portal (4375745)
As we announced, in most recent erwin product we introduced a new product called ER360 to replace current erwin Web Portal.
Required permissions to Reverse Engineer or Complete Compare against an Oracle 10g/11g/12c databa (4321703)
<div class="sechdrblutppdg"> <div class="bluetop1"> <div class="sechdrtppdg"> <div id="phpcontent"> <div class="subhdrfnt">During Reverse Engineering, erwin DM retrieves the information from the database by querying the system catalog tables which store the objects and their properties as selected in the Option Set.
A must read before upgrading to 12.5.2 (4375095)
Guidelines upgrading to erwin Mart Portal 12.5.2 Guidelines upgrading to erwin Mart Portal 12.5.2 Please follow guidelines below when upgrading to erwin Mart 12.5.2<br> <ol><li>Make sure you have Production DB Back up planned prior to upgrading to latest version of Mart.</li><li>If you are testing in Sandbox environment, also have back up of test environment as well.</li><li>If you have any issues after upgrading to newer version, raise support ticket with backup DB where issue exist.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All