A
I think our listener is broken, it keeps reporting back "TNS:listener does not currently know of the service requested in connect descriptor."
What should we do?
First, double check that the listener service is running at all. If so we might need to rebuild it:
-- stop service
-- delete service
-- net manager, delete old listener
-- add new listener
-- configure with default and SID
-- lsnrctl start
... But if this reports back connection to an idle instance, then we have some more digging to do.
A customer is trying to upgrade from version 2014 to 2025. They have all the appropriate files, but just need to know which scripts to run and in which order. And are there any special considerations regarding the actual DD.exe?
They will need to run:
-- updt_2014_15.3.sql
-- pre-16.sql
-- update_2015_to_2021x.sql
all from the original 2014 DD.
Beyond that they will still need to run:
-- v2_conv_prep.sql
-- update_to_2024.sql
-- update_to_2025.sql
from the current 2025 DD.
**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
A 3ds employee is calling in, and their oracle instance is inaccessible. The have the correct service name, hostname and port saved, and we can even confirm these values saved out to TNSNames, but we are still unable to log in, even to SQLPlus on the Server.
Try replacing the hostname with direct IP or even just localhost.
This has been happening to a couple of 3ds employees due to the default values in HOSTS file being overwritten.
** UNUSED **
In SmartPage, getting error: Uncaught TypeError: cannot convert object to primitive value. How might we address this?
It's on the fence: but there is a quick test we can try to see if it is likely either a EIQ 2025 bug or a simple client reinstall.
If you can right click and pull up a 'standard' edge menu, then we are possibly looking at a re-install (image (31).png included).
Shopworks is throwing an Internal Server Error 500, unable to parse connect string. What is the most likely cause.
This likely indicates the values saved in shopworks' appsettings.json don't match up with the IQORA connection.
** UNUSED **
The PrintService has been installed on their IIS server, but even from the server itself, the webpage will not load. Just shows a .NET error.
This could indicate some issues with RabbitMQ.
Navigate out to http://localhost:15672/ to troubleshoot further:
-- does this site load
-- does the common print-service user work
-- are there stuck jobs in queue
Customer calling in because they can not see the option to download oracle on Software.3ds.com. They are a current customer, and CAN download the EnterpriseIQ packages, but not oracle.
This appears to be a missing Trigram from their license. In a recent email string from sales-admin, I believe it was "AQ5".
Ultimately, it is something for Sales to address, but since it is an automated process, this is not something Sales team members have been helped to troubleshoot.
We are just finishing an upgrade, and have submitted our log for review. But we are getting a pair of unresolved dependencies:
SMP_BLOB and SMP_LONG_TEXT
What should we do about these.
They are old and outdated tables, no longer applicable to our current system. It is safe to just drop them:
Drop table SMP_BLOB
/
Drop table SMP_LONG_TEXT
/
Then you can re-run resolve dependencies, and it should clear.
** UNUSED **
After upgrading, we are starting to see some .NET errors on our websites. We have for sure re-run the setup.webiis from the correct enterprise 2-of-2 package. And when we check our windows features, we have all the correct boxes marked... but it does show our .NET only as 4.5 (instead of the normal 4.8)
This is due to not allowing Windows Updates to take place (and for a rather long time). The older version of EIQ webfiles built for 4.5 but we expect the current framework for newer versions.
** UNUSED **
We are getting an error: SP2-0310: Unable to open file "C:\Users\rde25\appdata\local\temp\1\file.sql" when trying to execute code in SQLPlus. How might we address this?
Seems to be an issue with how the computer is handling its temp space, and commonly seen on RDS setups. I usually navigate out to the folder and find that there is no temp\#\ directory, but if you add the one it's asking for that it should work.
Otherwise you can set your own temp directory or update policy such that it doesn't try to subdivide the temp.
** 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 **
After upgrade, we are seeing IQAlert backups fail with error: "Export failed! (error: 1)". We can manually run a backup through the command line, but it fails in IQAlerts > Exectute action now.
This could be caused by giving IQAlert the path to the "wrong" expdp.exe. The one in the main IQMS/bin is not the one shared with InstantClient_19_19, and IQAlert needs the path to client expdp.
I am updating my IQAlert backup action, but am unable to get it added to my backups group. It is erroring with ORA-00001: unique constraint error. How can I get it added?
This likely indicates that this action has already been assigned to a different group, and can not be added to another. Review the Link Groups & Actions menu for your action, and see where it already included.
When I try to open a report, it fails with error: EnterpriseIQ - Operation Aborted (IQPrint Action: Check Create Report Object). This only happens on one workstation, how can I fix this?
This likely indicates a missing reg edit, specifically for CoreUI and iqrep. You can try to re-run IQStatus > Apply as admin, or run the following commands directly in CMD:
C:\Windows\Microsoft.Net\Framework\v4.0.30319\RegAsm.exe "C:\Program Files (x86)\IQMS\IQWin32\IQMS.CoreUIControls.dll" /codebase C:\Windows\Microsoft.Net\Framework\v4.0.30319\RegAsm.exe "C:\Program Files (x86)\IQMS\IQWin32\iqrep.dll" /codebase
(might also be worth checking for the correct version of SAP)
If I have accidentally applied crypto to my environment/license, and I need to roll back, what steps would I take?
We would need to drop out the iqorders table:
SQL> truncate table iqms.iqorder2; and then review the masterhome and client for correct versions.