A
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)
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.
** UNUSUED **
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 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.
Shopworks has been installed, and works for most purposes --> But the drop-down list for printers is blank, no printers are discoverable.
What could this mean?
Assuming normal setup has been taken care of:
-- printers available to windows user
-- correct windows user set as identity for commonservices/printservice apppool
-- setup.webiis has been run
The most common fix is to change the connection string in IQPrintAgent > AppSettings.json to "localhost".
Beyond this, it may be necessary to rebuild the service itself.
We are receiving errors that look like:
TblArinvt: Type mismatch for field 'ONHAND', expecting: FMTBcdField actual: BCD (arinvt) (Component Name: TblArinvt)
What does this mean?
This probably indicates a client/server mismatch. First check your help > about for both release and module version.
If so, we should do a silent install over the top, or clean uninstall > reinstall.
[QA00000338479]
** UNUSED **
How can we ensure that a TEST email sent from system parameters > email is using the values shown on this page? What other values might it be looking at?
Changing the EPlant to "view all" mode.
Otherwise, the TEST EMAIL function will test with the applicable enterprise > eplant > contacts.
** UNUSED **
The silent installer is failing to setup an oracle client. You check their Client/oracle folder and find only a pair of instant clients (like 19_14 and 19_19). How would you manually install these and finish the EIQ client install?
1) Copy the instantclient folders into C:\oracle\client
2) Take a copy of a working Network folder from another workstation (or manually write the TNSNames.ora)
3) Add the instantclients to Environmental Variables > System > PATH
4) copy and run the registries for SOFTWARE\WOW6432Node\ORACLE and SOFTWARE\ORACLE (exported from another workstation or even our own laptops)...
At which point, you should hope to be able to run Silent.exe without issue... otherwise, run Client/enterpriseIQ/setup.exe
We want to install a second Oracle instance on our TEST server (TEST REPOS). What do we need to do to start this install?
We need to change the SQLNet.ora file to allow NTS authentication. And we need to have our user as part of the ORA_DBA group. (also calculate appropriate tuning that wont overload the server).
** NOTE: If the user is not part of ORA_DBA, can be added, or even newly created group --> but it won't take effect until a system restart.
** UNUSED **
I am going to change my window's IQMS-Service account password. This is the window's admin user that runs Oracle, Ataman and IIS. Is there anywhere I need to change this password besides microsoft?
Oracle: "none" unless services have been tied to the service and password is updated manually
Ataman: In the atrls control panel > Prompts > Password.
IIS: In the identity fields of apppools associated with the user (and good to double check that sites still are accessing the pages, else password might be saved in "authentication" and lower level site user settings).
My IQMS password is expiring every weekend. No users are supposed to be in the system, and I just changed my IQMS password again on Monday.
How can we investigate this, and given our findings what might be the cause?
We can check the DD > Audit log and filter the return code to only report back our failed login attempts (1> x > 27999).
In *THIS* particular instance we find 10 failed login attempts from the IQAlert server midday Saturday.
** UNUSED **
From all indicators, we should have successfully installed Shopworks appropriately, but when trying to access the website, it remains blank and doesn't even show a login prompt. BUT, we have even logged into Shopworks successfully from another computer.
What should we look at?
First, check your browser. Both IE and Firefox have given us trouble with Shopworks in the past, and this sounds like a bug (from reports, this may only be an issue in 2024+).
Beyond this, probably best to try incognito mode or remove all cache/cookies.
** UNUSED **
When my user tries to access IIS websites, I get "THOTH GATEWAY ERROR"
What is going on?
Typically this error is cleared by Grant iqwebdirect_role or through security inspector "green checkmark" grant webdirect access.
Sometimes you need to go one step further to grant connect.
I need help with 3ds contact admin!
** ULTIMATLY this falls to their site admin, but there is new news and we often get called on to help, so...
Hand off the contact admin technote.
Access the 3ds support app (my prefered method from 3ds.com/support -> blue button near bottom "take me to 3ds support")
Login
** AND HERE IS NEW INFORMATION **
3ds now requires 2FA authentication. On the "update contact" page, click into the top banner to access the 2FA settings. Will require an external authenticator (key or phone) and ask some security questions. This step can be quick to resolve, but need the email verification before login.
Once on the app, there is manage contacts which brings you to clientcare as normal.
Your SYS user account is LOCKED, and we need to reset it.
* BONUS POINT * --> Give a second method.
Common method as described on SysAdminWiki --> sqlplus \ conn, no log.
But PROPS to Andy for the new method below:
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}
What is the common cause for backup jobs failing with ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]
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.
** NOTE -- Bonus point for predicting corner case **