0 Archived
Forum Replies Created
-
I’m sure you could have an Event Manager (or Oracle Job) fire off at the end of the ‘day’ and auto punch out for people who ‘forgot’
-
If you do decide to run TomCat, do not provide it a public facing IP address. Only allow ports via Firewall that are required for Quantum to talk to it for Docs & Images (8080?) so that in the event malware gets onto a local PC, it cannot take over TomCat.
-
HAhahaha…. best practice?
PCI compliance mandates no Web Server on your SQL Database server. That was in 2010? That’s why at the time Microsoft SBS 2011 came in two flavors. One with a stand-a-lone SQL Server (on a different computer) and one that did not include SQL Server.
Granted if you don’t care about PCI compliance (check your yearly Bank audit/questionare) then go ahead
-
For our Quantum 12.3.6 ‘test environment’ it works fine. Quantum, Oracle, Tomcat all on the same Windows 2019 server.
-
Image Pro I would bet is superior to Mobile Imaging.
The advantage to Mobile Imaging is you get a license to access the encrypted Docs & Imaging data for your internal applications.
-
With Quantum < 12, automating Docs and Images is very doable depending on your technical skills. Quantum > 10 you need to have a licensed API key, which I guess CC is charging an arm and leg for, and told me I couldn’t have for whatever reason.
-
We use Docs & Images to store everything either at the part level or the stock level depending on how specific it is.
-
Even with SAS 10K drives… RAID-10 with 10 drives is 10 times faster write and 8 time faster read than a small RAID-5 or default drive.
So drive bottle neck is ZERO in this configuration. You’re right about SSD vs SAS and PCI-E vs SSD. Just depends on your budget.
-
Here’s a link you can use to see if your computer equipment is FIPS 140-2 compliant which is part of the NIST 180-171
-
Ah! Old school thinking….. Love it. Separating the data into separate data files on different spindles makes a world of difference.
I think that was very true before RAID-10 and affordable SAS drives. I know in my old servers I would do RAID-1 for the “boot” drive and then RAID-5 for the “data” drive. Or multiple RAID-5’s to separate out the heavily hit files just like your recommendation.
Now with 10K SAS drives in RAID-10 I am getting a little over 4GB per second Read and 5.5 TB of usable space. Back just a few years you would be looking at tens of thousands of dollars to get this performance…. now it’s dirt cheap.
So yes, lots to consider when optimizing your system beyond memory. In environments have their own unique situations which you trip across as you optimize.
I think you are spot on there.
is moving our DB to a new server covered by SMA? I did mange to install it on another system thanks to your help.. but not everything like Event Manger, Doc’s & Images, etc…
-
So in our case our server has always had 32GB of RAM but had a ton of unnecessary services active before installing Quantum. SGA_TARGET is 9G, is that why mine is consuming only 10GB in TaskManager?
Task Manager Shows:
Total Memory 32GB
Cached 11GB
Available 12GB
Free 2GB
-
That’s a very cool presentation. Amazing.
-
Our CCTL directory is around 75GB and 10GB of memory seems to work well without careful 11g settings. Training always lags currently.
We are looking at moving it to it’s own server with more ram and raid-10 for better drive performance. Current server is limited to 32GB.
What settings would one look at to optimize Oracle 11g? That’s a very interesting comment. Or when we upgrade to 256GB of RAM will it just auto tune itself well enough?
-
It’s just Task Manager. For us Oracle floats around 10GB of RAM and is a little free hearted at giving it up to other processes. Once I kill off anything that I can that is high memory, Oracle reallocates to about 10GB.
I agree with the others, once Oracle is restarted it takes it a little while to get back on it’s feet. Kind of like logging into another shema like training, it takes it a little time to adjust.
Is it running slow for days and days or just a brief period of time then it’s back to normal?
-
Something going on the server where Oracle is? Backup stalled or something eating up CPU/Memory?
For us we have seen slow downs in Quantum when Oracle is getting crunched for system resources.
-
We have been looking into this as a future requirement. Granted the new administration could easily void this requirement out. So hard to say going forward…
Here is a link to the current requirements, not sure on any consultants other that folks that have dealings with PCI compliance upped a couple of levels…..
https://csrc.nist.gov/publications/detail/sp/800-171/rev-2/final
And here’s a link to a 3rd party website that breaks it down with recommendations…
-
Mike,
Probably easier? Who do you want to maintain that link? I really have more to do with my time then updating hard coded SQL when I could push that out to a user or two. Ha ha ha. Easier? Just depends on which hat you are wearing that day.
Create an INSERT/UPDATE trigger and presto you are done. Write a report in Event manager to notify people in charge of maintaining the data…. show if ARCHIVED is true for that user as a manager and unassigned companies with work orders
-
You can also use User Defined Attributes and create a CSR entry per company record and then use that in the SQL so it’s all inside Quantum for the GUI side and no need to constantly edit the SQL as things change.
-
That’s very cool Mike. Thanks for sharing that.
The more I learn Oracle the more I enjoy it.
-
What I do when data is not showing up, use LEFT JOIN instead of INNER JOIN to see which is dropping the data. Sometimes INNER JOINs are overkill depending on what you want to see.
-
When I do an add stock line, no GL entries are created. The screen doesn’t even have a cost / value field.
Is that a setting we have turned off in system settings?
I do like:
Modules -> Inventory Control -> Search Master Parts
Edit the Part
Hit F9 for Stock Lines
Do Add
Or is there a GL batch? I did a select distinct description from gl_batch and didn’t see any descriptions that would indicate addition of a stock line.
Once the stock line is there, I can edit the stock line and Adjust->Cost which is what would impact the GL?
-
Switch to INNER JOIN (so you only see records that have an RO_DETAIL/HEADER)?
And check for the specific work order status codes you want to review?
WOS_AUTO_KEY
-
All docs they provided are just making tweaks to the screen and no scripting. Where can I find out about the scripting side?
We would love to be able to do scripting and “fix” some issues we have with V10
-
CC tech support says that the scriptor has been removed and the editing feature does not allow moving of fields between tabs sad to say.
-
In V10 on Stock Line edit form there are two tabs. With the screen editor can we move a field from one tab to the other?
We want to use the User Defined Date Fields and they would be better on the Stock Line Tab vs the Stock User Defined Tab.
-
Yes your user has to be set as an Administrator in Quantum Users (Editing User Information).
-
Screen Editor is alive and well. Screen Scriptor they killed to do difficulty in providing support for it after V7 (I think)
-
Has scripting been removed? It’s just an editor now?
-
Ah… this is for images not pdf’s.
-
That’s a pretty cool script. Most of what I do is in not within Oracle but using PHP and MongoDB.
I tweaked the WHERE to be:
WHERE object_name LIKE ‘%NBA_%’
AND object_name not in (‘KANBAN_TRANS_LOG’,’VIEW_KANBAN_STOCK’)
AND object_type in (‘TABLE’, ‘VIEW’, ‘INDEX’, ‘FUNCTION’, ‘PROCEDURE’,’PACKAGE’,’SEQUENCE’))
That way I could grab any of my NBA objects and not get extras.
Thank you very much for sharing, it works like a champ. Granted and order by clause would help the DLL work as generated. So it would try and create an index before the table is defined, etc….
This should make data-wise upgrades less painful, granted we are in v10 land for the moment.
-
So you are doing something like:
WITH CR1 AS (
SELECT TRIGGER_NAME FROM ALL_TRIGGERS WHERE OWNER=’TRAIN’ AND TRIGGER_NAME LIKE ‘NBA%’
)
SELECT DBMS_METADATA.get_ddl(‘TRIGGER’,CR1.trigger_name, ‘TRAIN’) FROM CR1;
To grab all your custom triggers? That’s pretty cool just store those away and then run the statements when you need to recreate them.
-
I do have backups that so I am able to recover after CC whips the schema into their shape.
When I first started working with Quantum last year after an update I lost my custom tables, so I retooled after that.
Will run with the company TLA as a prefix to the custom items to make it easier to manage.
Event manager only gets you so far. Agree 100% have to test to ensure compatibility with existing triggers (yours and theirs).
Thank you all.
-
In Excel, you can click on Data->Text To Columns, click Next, then uncheck deliminters then next and finish, that will bring back the missing 0’s.
-
Wouldn’t it be better to look at the STOCK_XFER_LOG table? That has NEW vs OLD fields?
-
We’ve seen people use like https://www.formstack.com/ to do online vendor surveys. It wouldn’t be hard to create some forms and embed the URL to it on your ship notifications or what not.
-
To me looking at it, you have:
WHERE cmp.coc_auto_key = ‘1’)
coc_auto_key is a number right and not a string?
-
Nadim Ghazzaoui wrote:
Your best bet would be to adjust cost and/or quantity. No merging.
Maybe you can adjust the existing SL down to zero and then adjust the phantom stock up to the total actual quantity. This way you don’t need to adjust the cost.
Hi Nadim,
We have decided to do a direct update on the SL we wish to keep by adding the cost from the other. We don’t use the accounting module here so I was not sure how that would affect that side but I think it is the only way to accomplish what we need.
Thank you!
Shelly
-
You are right it depends on the customer that the quote is for. Interesting.
-
Thank you very much!
-
Can you clarify: 40% discount over traditional solutions
What do you consider a traditional solution?
How do you handle PCI compliance (Quantum doesn’t seem to be even close)?
Are you just doing a REST API calls like PayPal or Square?
-
Are you trying to show the stock room what items are needed:
Via McDonald’s method (wall mounted TV) [refreshed automatically]?
Via e-mail / text message to stock room staff [scheduled every x min]?
Via hand held device / TV / Computer screen [manual check by staff]?
-
Thanks Mike, appreciate the confirmation. Some programs assume you always accept defaults, glad to hear that is not the case here.