0 Archived
Forum Replies Created
-
We also experienced this on a regular Windows 10 desktop running Q 10. It’s kind of odd and infrequent.
-
If I do this for a PO it has # in the filename / subject. I think it’s internal to Quantum and how it builds the filename and not part of a database generated name.
Purchase Order #PO123456 11-28-2022 2-22-43 PM.pdf
-
Side note: DUE_DATE is just the date without time (midnight), so if you do use SYSDATE, you would need to use TRUNC(SYSDATE) so is also midnight. TRUNC(SYSDATE) + 14 would put it two weeks from now as an example.
-
We have had this issue as well. I tried to find in my notes how we resolved it but couldn’t find it. For now my user just saves to her desktop then emails via Outlook directly instead of doing it through Quantum.
Will report back once I figure out how to fix it. I don’t think it was an Add-In or corrupt prfile.
-
We are not on a current version, so any Quantum updates wouldn’t help us, CC has said that they won’t back port enhancements to older versions.
-
Still researching it. Sending emails is not effective at this point, I think Microsoft knows the impact that would mean to multi-function-devices/copy machine that send PDFs.
Reading emails like I do so a server can monitor an inbox for keywords and take action is dead using IMAP/POP3. Need to have oauth incorporated for it to authenticate as an application. Our Office level has restrictions on certain areas of Azure AD, so we either need to bump to the next level of subscription or purchase an Azure AD level 2 subscription at $6/user. Some of the steps required in AD have workarounds that allow you to create the entries required w/out paying more but with their transition to V2.0 APIs it’s not straight forward.
-
It looks like they are working on SMTP but for now they are leaving that enabled (if you created your Office 365 account before Januay 2020. Otherwise you have to use power shell to enable Smtp Client Authentication on the domain and for the specific mailboxes.
-
Another thing I have done is a WITH CR1 AS ( HARD SELECT STATEMENT ) SELECT (REST OF THE SELECT) which creates a cursor to use as an INNER JOIN to all the other tables.
I think there are lots of options to pull this kind of information, just need a few more details on them.
-
What I have done for other type queries is focus on the hard part and then either replace the left join with that select statement. It sometimes requires you to duplicate the WHERE statement.
Not sure how you are using tasks, do you close them as you go? Are they in Sequence order? What status codes are you using?
That would help construct the correct SQL to grab the data you are looking for.
-
CODE 39 has a check digit, you should be able to enable verification on the reader so when it misreads it beeps with an error.
-
Hi Saul,
On the User menu do you have Interactive SQL? If so you could delete templates that have not been used. You would issue SQL statements, and if they work, then click the commit button.
If you do, we could figure out the statements.
-
Thanks Tim, I’ll keep that in mind if there is more missing items. That trick could be a real time saver.
-
I had them drag and drop the menu option back onto the toll bar…
-
In System Setup -> Inventory -> Inventory Module Settings you can turn on Part Limits or not.
Then in the master part you can turn it on/off for that master part. Once that is set you can then enter the information for each stock line.
-
This is interesting, Quantum doesn’t track the stock reservation. One could make an SQL that would check SO Detail vs SM Detail vs Invoice before posting the invoice to identify any sales order issues, but I’m not seeing any way to have a warning or anything when someone takes away the reservation at the stock line on the SO detail. I don’t have a shipment that was invoiced so I couldn’t link into that file… but I hope this gives you an idea. for us SOS_AUTO_KEY of 2 is closed. So you would need to fine tune it no doubt.
<font face=”Open Sans, sans-serif”>
</font>select SOH.SO_NUMBER, PM.PN, PM.DESCRIPTION, SOD.QTY_ORDERED, SOD.QTY_RESERVED, SMS.DESCRIPTION AS SHIPMENT_STATUS
from sm_detail smd
inner join so_detail sod on sod.sod_auto_key = smd.sod_auto_key
inner join parts_master pm on pm.pnm_auto_key = sod.pnm_auto_key
inner join so_header soh on soh.soh_auto_key = sod.soh_auto_key
inner join sm_detail smd on smd.sod_auto_key = sod.sod_auto_key
inner join sm_header smh on smh.soh_auto_key = sod.soh_auto_key
inner join sm_status sms on sms.sms_auto_key = smh.sms_auto_key
where sod.qty_reserved = 0 and soh.sos_auto_key <> 2;
-
WO_Operation (main WO table)
WO_Repair table links WO_Operation to Operation_Master
Operation_Master is the task master
Operation_Task are the task’s for each master
SELECT TKS.*
FROM WO_OPERATION WOO
INNER JOIN WO_REPAIRS WRP ON WRP.WOO_AUTO_KEY = WOO.WOO_AUTO_KEY
INNER JOIN OPERATION_MASTER OPM ON OPM.OPM_AUTO_KEY = WRP.OPM_AUTO_KEY
INNER JOIN OPERATION_TASKS OPT ON OPT.OPM_AUTO_KEY = OPM.OPM_AUTO_KEY
INNER JOIN TASK_SKILLS TKS ON TKS.OPT_AUTO_KEY = OPT.OPT_AUTO_KEY
WHERE WOO.SI_NUMBER = ‘W25855’Task_Skills is where I found the estimated hours in the EST_HOURS field of that table. Which I did a sum on…..
-
Our Event Manager stopped being able to send emails, and still cannot send depending on what type of event it is.
CC logged in and replaced the old emgrmail.jar file with a newer one. Granted it’s buggy.
Office 365 rolled out turning off older SSL support. Some items in the queue worked when it connected to a server that still supported the older SSL.
So not really what you are referring two… but different. -
Thanks, we are doing the delete option.
-
Looking at the procedure the PO_WARNING is linked to (PROCEDURE STD_0039_PO_WARNING):
QC_EMGR_PKG.NEW_HEADER(H.POH_AUTO_KEY,H.CONSOLIDATE,H.LOG_VALUE); QC_EMGR_PKG.set_loop_variables(H.cmp_AUTO_KEY); QC_EMGR_PKG.HVALUE(‘COMPANY_NAME’,H.COMPANY_NAME); QC_EMGR_PKG.HVALUE(‘PO_NUMBER’,H.PO_NUMBER); QC_EMGR_PKG.HVALUE(‘WARN_DATE’,QC_EMGR_PKG.date_format(H.EVENT_DATE)); QC_EMGR_PKG.HVALUE(‘REPLYTO_FIRST_NAME’,H.REPLYTO_FIRST_NAME); QC_EMGR_PKG.HVALUE(‘REPLYTO_LAST_NAME’,H.REPLYTO_LAST_NAME); QC_EMGR_PKG.HVALUE(‘REPLYTO_EMAIL’,H.REPLYTO_EMAIL); QC_EMGR_PKG.HVALUE(‘STATUS_CODE’,H.STATUS_CODE); QC_EMGR_PKG.HNOTES(‘NOTES’,H.HNOTES); QC_EMGR_PKG.kword(‘VENDOR’,H.EMAIL1); QC_EMGR_PKG.kword(‘REQUESTER’,H.EMAIL2); QC_EMGR_PKG.kword(‘REQUESTOR’,H.EMAIL2); QC_EMGR_PKG.kword(‘EMPLOYEE’,H.EMAIL3); QC_EMGR_PKG.kword(‘REPLYTO’,H.EMAIL4); QC_EMGR_PKG.STYLE_OVERRIDE_SETTING(‘POH_AUTO_KEY’,H.POH_AUTO_KEY); QC_EMGR_PKG.STYLE_OVERRIDE_SETTING(‘REPORT_DESCRIPTION’,’Purchase Order #’||H.po_NUMBER);
It would look like HVALUE’s are what’s available is that true? So you would need to modify the CC provided procedure or make a custom SQL one? -
To me it looks like it is only grabbing the email address from the users table and not their employee code. The field is EMPLOYEE?
-
Due to the nature of the exploit hopefully CC will be more transparent in their response and provide additional details once they have a good patch for the various products that do have log4j embedded in them.
Low risk does not equal no risk, which in todays zero trust environment is where we want to be.
-
Not sure if we are having the same issue but Office 365 update from early October on killed the import from Excel function. The Quantum screen just shows lines or has errors that you cannot clear.
We reverted back to the semi annual enterprise channel and it started working again (granted we are not on 12 yet so maybe a totally different issue). -
I have a linux script:
#!/bin/sh
HOST=’ftps.ilsmart.com’
USER=‘XYZ12′
FILE=‘~/inventory.xlsx’
lftp –env-password ftp://$USER@$HOST < -
When I was looking at this, it looked like when you create a WO template (Modules -> Shop Control -> Setup -> Template), is where you can assign qty’s to the BOM.
Have not used this (yet)…
-
I would think it’s using ARA_AUTO_KEY (which is one line per company) in your group by is causing the issue.
Looking at it more closely, does that company have multiple Rolodex entries?
select COMPANY_NAME, RDX.* from ROLODEX RDX
inner join COMPANY_ROLODEX CRX ON RDX.RDX_AUTO_KEY = CRX.RDX_AUTO_KEY
inner join COMPANIES CMP on CMP.CMP_AUTO_KEY = CRX.CMP_AUTO_KEY
where cmp.site_code = ‘APX’ AND
cmp.company_code IN (1003819) and
RDX.AR_STATEMENTS = ‘T’
-
CLOSE_DATE is a timestamp and not just a date. So when you trunc sysdate it is looking for anything before mid night.
So you need to add a day [ie: LAST_DAY( BLAH ) + 1 ] would be midnight the next day, which would include the actual last day of the month.
what I do in SQL Developer to tell if a field is a timestamp or not is:
alter session set nls_date_format=’YYYY-MM-DD HH24:MI:SS’;
Not sure if there is an easier way to tell the difference.
Or just TRUNC(CLOSE_DATE) or any date field to ensure that you are looking at just a date and not timestamp.
-
Report Builder is based on Pascal er Delphi. So it takes the cursor (data) and converts it to an array. So that is why you have to reference the data via array syntax when you do dynamic SQL to grab other data at run time.
SQL Developer will execute SQL and create a cursor, the SQL included did not have any filtering so it should have returned a lot of rows, granted 50 is the default if you page down in the results you would have gotten more without a where statement to reduce the result set.
-
What tables are in your data pipeline?
-
Did you try?
q.Sql.Text := ‘select DESCRIPTION from WAREHOUSE where ‘ +
‘WHS_AUTO_KEY=’ + STOCK[‘WHS_AUTO_KEY’];
-
Not sure how familiar you are with SQL Developer, but here is a link that talks about doing an SQL statement via a procedure and created an Event Manager event to execute it.
I am not up on Event Manager, but it looks like you could email a list of companies you are changing to unapproved status too.
-
Can you break up your Queries MSSQL is executing into smaller ones and run them via SQL Developer to see if it’s the Oracle side? That way you can figure out which side needs tuning?
-
Keep in mind component control changed Quantum / Barcode Reader to keep the session idle time minimize and if you do kill a barcode reader session it will just auto-reconnect. So killing sessions is less helpful these days.
-
Based on this website:
https://www.devart.com/odbc/oracle/docs/microsoft_sql_server_manager_s.htm
You need to add a new Linked Server,
Provider string: OraOLED.Oracle
DataSource string:
(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=urHost)(PORT=urPort)))(CONNECT_DATA=(SID=urOracleSID)(SERVER=DEDICATED)));UserId=urUsername;Password=urPassword
-
Interesting, I don’t have access to that option, I just made a handful of User Defined Attributes and pre-populated for the next 5 years of holidays / weekends.
Looking in the help it seems like it’s pretty cool. Then you would just query the CALENDAR table and count the entries (for offset in days). H = Holiday, N = non-workday
For us we don’t charge if it’s weekend/holiday but that seems pretty cool and cleaner no doubt. It looks like tracking employee hours it would it would auto create holiday entries for them.
-
I’ll have to pay attention? That’s no fun. Not sure if Quantum logs errors to a table. People don’t often report Quantum anomalies reliably.
Will do a comparison to see what’s different.
-
I build my time based on the current WO Status and WO Status History. Then for the status codes that are customer related subtract that from the days it took to process. I also made a list of weekends and subtract those from the days it took to process the WO.
If you only have one status that is considered customer, check out pulling the days from WO_STATUS_HISTORY. If weekends don’t matter I wouldn’t worry about that. Then you can look at when the WO was created to when it went to shipped status. Quantum can make this a little challenging and that you can reship a work order (for whatever reason) so there is a little bit of logic to get the most resent ship date and not just grab any ship date.
What’s your WO_STATUS table look like? What tools are you using for custom reporting?
-
Interesting question. No it only happens once in a while.
If it’s tied to URL_LINK_? fields, there is only one part in our parts_master table that has URL_LINK filled out. When I pull up that part and exit and open the inventory control module I don’t get the error.
SELECT PNM_AUTO_KEY, PN, URL_LINK, URL_LINK_2, URL_LINK_3, URL_LINK_4, URL_LINK_5
FROM PARTS_MASTER
WHERE URL_LINK IS NOT NULL OR URL_LINK_2 IS NOT NULL OR URL_LINK_3 IS NOT NULL OR URL_LINK_4 IS NOT NULL OR URL_LINK_5 IS NOT NULL;
-
We did a custom report as we wanted to track date changes. Just because it shipped within the date of the work order didn’t mean to us we were meeting customer ship dates. It just could mean we talked to them 5 times pushing back the date due to whatever issue. Sometimes we are waiting on their approvals which doesn’t count against us as meeting the ship date requirement.
What is how your company views customer ship dates? Are you using a work order status to indicate you ware waiting for their approval? Do you care about that kind of thing (to not count against yourself)?
-
Back in the late 80’s the POS I wrote did this. Customers always find a reason to not pay their invoices. They eventually just admitted to being dead beats once all their excuses where eliminated. Including the invoices with the statements cut down the back and forth quite a bit. Granted we didn’t scan in their signed invoices as that would have driven up the cost of everything back then.
It would be interesting to be able to pull from Docs & Images copies of their invoices (out standing) along with proof of approvals (emails or what not).
Granted in you are in V12 land, you have to have the API to get your data out of Docs * Images. If you use contact manager, you could link each invoice to it’s approval document too.
-
From my understanding if you are an end user there is no fee. They do charge a fee for 3rd party companies who are making 3rd part modules available that integrate with Quantum.
-
Some things are done on the client side (quantum.exe) and not the database server side sad to say. This looks to be the case for this.
-
That works! Thank you for that. I know before I solved it outside of Quantum and if I find that solution I’ll post here. RTF emails look slightly different so it maybe cleaner to get HTML working.
-
Ok, if the user sends an HTML formatted message the body is blank. Changing it before sending to Rich Text and the email body shows up.
Not sure how to default it to Rich Text. I did that in outlook->file->options->mail but Quantum ignored that setting and always trys to send as HTML..
-
My user gave up, they didn’t take any notes and I don’t recall what fixed it.
They just save to desktop and send from there as their workaround.
-
In the release notes for 12.1.x it states: Document Imaging: New Document Imaging server with enhanced security has been implemented. Image file names are now encrypted. New “Security Key for Default Imaging Server” field and “Generate” button have been added to the Global Settings. This security key value is used by Network Services when configuring the new Document Imaging server. [Enhancement] [Ticket: CC-696]
However it doesn’t say how they are doing the encryption with is calling a service they host on AWS.
-
Yeah that is a major concern for us in moving to 12. Using a cloud based document and image encryption module is something we don’t want to be tied to.
-
Looking at your SQL to get a better idea of what you are looking at, when I ran the SQL it would reset my database connection. I ended up replacing the views with the specific joins to obtain just the fields you have in the select part:
SELECT
woo.si_number,
parts_master.pn,
parts_master.description,
woo.entry_date,
pn_groups.group_code,
woo.open_flag,
wo_status.status_type,
stock.serial_number,
application_codes.application_code,
view_sps_wo_operation.si_number as parent_wo,
view_dash_wo_base.work_type,
location.location_code,
warehouse.warehouse_code,
wo_task.last_status_change,
wo_task.last_close_date,
wo_task.sequence,
wo_task_labor.closed_update,
wo_task_labor.stop_time,
wo_task_labor.rework_flag
FROM
qctl.stock_reservations stock_reservations
INNER JOIN WO_OPERATION WOO ON woo.woo_auto_key = stock_reservations.woo_auto_key
LEFT OUTER JOIN qctl.parts_master parts_master ON woo.pnm_auto_key = parts_master.pnm_auto_key
LEFT OUTER JOIN qctl.wo_status wo_status ON woo.wos_auto_key = wo_status.wos_auto_key
LEFT OUTER JOIN wo_work_type view_dash_wo_base ON view_dash_wo_base.wwt_auto_key = woo.wwt_auto_key
LEFT OUTER JOIN WO_OPERATION view_sps_wo_operation ON view_sps_wo_operation.WOO_AUTO_KEY = woo.woo_parent
LEFT OUTER JOIN qctl.wo_task wo_task ON woo.woo_auto_key = wo_task.woo_auto_key
LEFT OUTER JOIN qctl.wo_task_labor wo_task_labor ON wo_task.wot_auto_key = wo_task_labor.wot_auto_key
LEFT OUTER JOIN qctl.pn_groups pn_groups ON parts_master.png_auto_key = pn_groups.png_auto_key
LEFT JOIN qctl.application_codes application_codes ON parts_master.apc_auto_key = application_codes.apc_auto_key
LEFT OUTER JOIN qctl.stock stock ON stock_reservations.stm_auto_key = stock.stm_auto_key
LEFT OUTER JOIN qctl.location location ON stock.loc_auto_key = location.loc_auto_key
LEFT OUTER JOIN qctl.warehouse warehouse ON stock.whs_auto_key = warehouse.whs_auto_key
WHERE
WOO.OPEN_FLAG = 'T'
--AND warehouse.warehouse_code = ’gate3′
ORDER BY WOO.SI_NUMBER DESCGranted this really isn’t ideal. I don’t have crystal reports but I would say take the sub tables lke wo_task_labor that can have multiple results and put that in it’s own sub-report and reduce the number of records in the actual report?
-
Totally right,
In my code sequence I delete TASK_SKILLS and OPERATION_TASKS, then the OPERATION_MASTER… if you use other tables as well you have to remove them first. If it’s been used in production you may not be able to remove all the kids, and have to leave it (hit the rollback button).
So in your case it’s OPERATION_REPAIR_TASKS (which we are not using here).
DELETE FROM OPERATION_REPAIR_TASKS ORT WHERE EXISTS(SELECT 1 FROM OPERATION_MASTER OPM WHERE OPM.OPM_AUTO_KEY = ORT.OPM_AUTO_KEY
AND <Above filters to get your template list)
If you are using TASK_MEASURE, or TASK_TOOLS, or OPERATION_BOM, there are additional tables to delete from before eliminating the task or the template. You just have to work through all the keys blocking the delete and understand where in Quantum it’s used.
-
It depends on how you are using Quantum Templets. I assume you are not using the Publications piece but have Tasks with time estimates only? I would suggest doing this in your training database in the event it doesn’t work. If you can (one by one) delete the estimated hours in each task, the tasks and finally the template via the Template editor, if this works for sure you can do it via SQL as well:
OPERATION_MASTER -> OPERATION_TASKS -> TASK_SKILLS
So you would need to delete all the TASK_SKILLS first, then OPERATION_TASKS, then OPERATION_MASTER.
SELECT * FROM OPERATION_MASTER OPM WHERE OPM.DESCRIPTION LIKE ‘%DELETE ME%’ <put your filters here to get a clean list of records to delete>
DELETE FROM TASK_SKILLS TMS WHERE EXISTS(
SELECT 1 FROM OPERATION_TASKS OPT INNER JOIN OPERATION_MASTER OPM ON OPM.OPM_AUTO_KEY = OPT.OPM_AUTO_KEY
WHERE OPT.OPT_AUTO_KEY = TMS.OPT_AUTO_KEY
AND <Above filters to get your list of templates to delete))
DELETE FROM OPERATION_TASKS OPT WHERE EXISTS(SELECT 1 FROM OPERATION_MASTER OPM WHERE OPM.OPM_AUTO_KEY = OPT.OPM_AUTO_KEY
AND <Above filters to get your template list)DELETE FROM OPERATION_MASTER WHERE <put your filters here to get a clean list of records to delete>
In the Interactive SQL there is a check (commit) and arrow (roll back) after you execute, If you cannot delete the operaiton_master record, I would say click the roll back. Do not commit each delete statement but just the last one.
-
You should link in User_Defined_Attribute to UDA_Checked as well to filter for just the parts master table and not any source_key hit in UDA_Checked?
Not sure…. here is what I do in SQL, if I’m targeting a specific User Code, I add that too.
USER_DEFINED_ATTRIBUTES UDA ON UDA.AUTO_KEY_PREFIX = ‘PNM’