A
Your SYS user account is LOCKED, and we need to reset it.
* BONUS POINT * --> Give a second method.
NTS login, using ORA_DBA user, point to the instance directly and conn / as sysdba. (QA00000299357)
OR
From the Oracle Home, copy + delete the PWDIQMS.ora file, and in command prompt make a new one with:
orapwd file=C:\oracle\iqms\database\PWDIQMS.ora password={password}
** UNUSED **
Beyond the normal and chosen password specifications, are there any limitations on what can be set for the IQMS user password?
Pre-2023, there was a bug BR10000338817 that limited IQMS-password to no more than 16-characters. Specifically, it would cause "character string buffer too small" errors to surface for ALL users in workflows.
As of 2023 Golden, the bug has been resolved, but is now specified that "Passwords up to 30 characters will be allowed." (the normal Oracle maximum)
** UNUSED **
What are the most common causes for a cloned environment of PROD to result in a new TEST instance that does not work.
1) New drive names can result in control files being in the "wrong" place.
2) A lack of memory to accommodate the previous tuning arguments.
3) The TNSNames and/or Listener are still hardcoded with the old hostname.
During upgrade and import, we find that we are unable to open Data Dictionary, and get an error:
ORA-00001: unique constraint (IQMS.PK_S_USER_LOGIN) violated.
How can we resolve this?
We have to run two scripts:
grantIQMS.bat and fix_s_user_login_seq.bat.
Since version 2022x and beyond, what is the most common error for IQAlert backup comment: "Export failed! (error: 1)".
* MULTIPLE ANSWERS ACCEPTABLE *
1) Using the oracle home expdp.exe instead of the one listed in instant client.
2) Additional and broken actions, like executing zipmove.bat.
3) Limited drive space.
This indicates that the DIRECTORY={alias} setting does not align with the actual file structure. Commonly a typo, or just missing a directory level.
ALSO possible that they are trying to write out to a network drive, but have not put in the additional permissions work to allow the local system to write to the remote drive.
When trying to navigate to WMS, you get an error:
Thoth Gateway Error
What would this indicate, and what is the fix?
The oracle user needs the role IQWEBDIRECT_ROLE. This should be granted when migrating users through our Export Users tool, but otherwise can be applied through the green check in Security Inspector > General or through SQL directly.
Trying to install client, and Silent finishes without errors, but shortcuts and executables are still missing. Notably, the EnterpriseIQ wizard never even seems to show up.
What is a possible cause?
There may be more possibilities here, and would be more clear if trying the manual install or reading the silent logs...
But in my experience this is most common when there are other versions of SAP CR Runtimes preinstalled. Most likely 13.0.25 from Setup.WebIIS but possible others.
UninstallCrystalPrerequisites.bat fails to uninstall any version after 13.0.13. And from there, the EnterpriseIQ setup.exe fails to open further.
** UNUSED **
What are some of the common causes for "Waiting for DBCA to Start" during o19c.exe install?
1) File paths containing illegal characters (such as spaces)
2) File paths that are too long
3) 7zip4powershell not extracting
4) Smartpage blocks on any part of the oracle package
5) Requesting too much memory for SGA+PGA
When trying to execute OPatch apply, we get an error:
OPatch failed with error code = 73. What do we need to do?
This indicates that certain drivers are "in use" by other processes, and are unavailable for the OPatch process. As we have already shut down all Oracle related services by this point in the patching process, it is likely due to OS or AV.
So as per QA00000303054, we need a the Sysinternals Process Explorer. Once downloaded, run > Find > and find any handles listed above the error code. This will produce a PID that you can find and end, then retry OPatch apply.
We are in the process of importing new data, and at the step "drop user iqms cascade" but it seems to be stuck.
Is there any way to check and see if there is progress being made?
Beyond that you can still access the instance with either SYSTEM or SYS, and run a query like:
select count(*) from all_tables where owner = 'IQMS';
** UNUSED **
When installing IIS, we get an error:
The process cannot access the file 'C:\IQMS\WEBIIS\IQMSWEBSITE\favicon.ico' because it is being used by another process?
What does this indicate, and how to resolve this?
This is likely due to the masterhome directory setting when choosing where to extract from. Specifically, when the IIS server is also the location of the Masterhome, and the mapped letter has been used instead of the local drive letter.
This tricks the installer to reading that it should be copying files from itself to itself, and getting locked.
Instead, choose to extract from the local drive or directly from the IQMaster.zip file from the 2-of-2 media.
No printers are showing in Shopworks print options (empty drop down menu). Where should you look to resolve this?
* MULTIPLE ANSWERS *
1) Check your commonServicesAppPool (or in 2025 printServiceAppPool) identity for a local admin user.
2) Check ShopWorks appsettings.json for correct hostname.
3) Check Common_Services_Tracking for correct hostname.
4) Check C:\DelmiaWorks\Services\IQPrintAgent > appsettings.json, and change any literal hostname to "localhost".
5) Check the IQMS Print Service Agent in Services, and double check the user.
6) And if the Print Service website is inaccessible, you may need to check for RabbitMQ as per QA00000416522.
Server was working, but just recently, the database has gone down and won't start back up again. When trying to start it gives the error:
ORA-27301: OS failure message: The specified module could not be found.
What is a likely cause and solution?
This can happen when AV is overzealous, and removes basic Oracle files. With luck, you can check the AV quarantine list and whitelist any Oracle files found.
But if the list is inconclusive, you may need to check to make sure all the contents of C:\oracle\iqms\bin are still present and unblocked.
After migrating to a new server, and running Export_Users, we see in security inspector, the users exist and are unlocked, but get an error when trying to login:
ORA-28040: No matching authentication protocol.
What does this mean and how can we get users to log in again?
This indicates that the passwords exported are still formatted in an older Oracle hash. These are much less secure than modern standards, and as such it is HIGHLY recommended that all users have their password updated manually through security inspector.
That said, if for some reason they are in a rush to get users back in... you can edit the:
C:\oracle\iqms\network\admin\sqlnet.ora
with the following line:
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
WHO IS THE WORST AV?
* FREE POINT *
SENTINEL ONE (though CloudStrike really tried their best to take the #1 spot)