john.schneider
Forum Replies Created
-
Update : 10.9.10
10.9.10 build done for the bugs we found and we upgraded to this last night.
All points above have now been fixed.
I am still not 100% sure about the client update being smooth.
But you can at least work around that if you do get it.
Image temp files are now named:
(image_ID) + (original_file_name)
For example: 401765_scannedcert.pdf
This means the temp file is always unique, as it needed to be.
10.9.10 seems fine for the modules we use now.
-
Thanks James
To sum up:
1. Client upgrade is not straight forward – on this build expect problems/time wasted. It is just a bit painful.
2. Changes on Repair Order for someone else’s tracker has stopped us raising some charges, a new rule/logic has been added.
3. Images – big problems on this due to a tracker which attempted to keep file name intact for export I am guessing. Despite Cole D discussing this at QueGroup and pointing out it would cause major issues with temp files with duplicate file names – changes were made anyway. A big problem if you use ISIS scanning as we do in stores as it always names the file temp.pdf.
The idea was good but the execution was poor …
4. In Repair Orders there is a cache issue with Find/Loading RO’s whereby when you find and open a 2nd RO, the window in the bottom left of Window keeps the previous RO number in it, the title of the RO Window also has the previous RO number on it – so it is very mixed up!
Overall I am guessing that cache issue might show itself up in other places if the fundamental design/usage has been played with.
5. Custom Barcode label stopped working. Not 100% an upgrade issue but the upgrade certainly made it fail 100% when transferring parts.
We had to check the latest Std Barcode label to see why the custom label did not work Fairly easy fix in house, but a pain when 300 boxes had the wrong label on within 5 hours. Only affected new parts booked in.
The above issues will be fixed in an urgent build revision being done today/tomorrow.
Not sure if the client install will be fixed that quickly as it may need a bit of thought and testing outside of what CC can do in house.
I would certainly advise caution with this upgrade as some of the issues are not apparent when testing initially.
This build is certainly not as well tested as previous builds/upgrades.
We had Konstantin onsite this week anyway which meant we could investigate and apply fixes.as we found them Which is why I was wiling to do the production this week.
-
Are you using username sys@cctl ?
That would be the default filtered view on that username.
If you use qctl@cctl you will get:
AC_BAY
AC_CATEGORIES
Different view again on dia@cctl etc.
It goes without saying but I will say it anyway … exercise caution in this area…
-
We use both terminal server and Citrix Xendesktop (which still uses roaming profiles).
Provided best practice is followed regarding redirected-folders and roaming profiles the speed issues should be limited.
It requires fine tuning to make sure you get the speed you need.
It will always be slower to startup, maybe 20 seconds, but after that you should not notice much difference.
If you get very slow loading times then best practice is not being followed, a good example is redirected folder(s) not being used.
Would also advise using something to keep profiles clean/lean, for example CCleaner or the equivalent.
The other issue is of course hardware setup, the terminal server needs to be high spec. as you get the performance you pay for …
-
This is our procedure, which I believe runs every night to reset every user’s fetch size, if you wanted to automate it:
create or replace procedure avtrade_fetch_reset is
sysuq number;
begin
for r in (
select sysuq_auto_key from sys_user_queries
) loop
begin
update sys_user_queries set max_rows = 50 where sysuq_auto_key = (r.sysuq_auto_key);
commit;
exception when others then
rollback;
end;
end loop;
end;
-
I’m a huge fan of doing pics/scans via a mobile app, especially OneDrive & Lens.
All options have their own strengths etc. We run 2 different ones, just to provide a backup option when the main one doesn’t work, which does happen no matter what product you choose.
Off topic slightly, but you can use Lens direct from Onedrive and it will save the image to the location you are in (on the app), giving a little more flexibility for filing options. Although it is quicker just to use Lens if you just want to use the one default location.
-
Hi
This one was not ours. Looks like unless you use the same 3rd party app this may not be of any use. I have checked with CC Support:
Freight forwarder, and foreign consigner in the shipping management module is a custom programing for the company:
Aero Precisions, integrates with 3rd party software called Proship.
-
I believe this is an SQL update of an Oracle trigger.
It is on our training system for report testing..
-
I will be adding this to our CP this week – if it not already there:
User/System Setup/Maintain System Tables/System Browses/Users
[Edit User]
PO Authorization [Check Box]
PO Limit [Value]
Will be available in 10.9
-
May not be the same issue, but Symantec AV ( and others ) had an issue recently with the Imaging module on an upgrade. It needed an exception in the AV on the windows desktop clients. By default the rule created by the AV blocked the action.
The only thing this stopped was the drag and drop feature, so it may be a similar ‘security’ related issue.
Assuming you have security software on what you are running, you could disable it for a moment to check.
-
Yes.
There were previous reports of problems – but most of our installs actually worked fine.
The recent updates have started to cause problems so we took the decision yesterday to remove and go back to XI.
We use Nuance as an editor but Adobe reader as default PDF as it’s jut much quicker to load an image, especially in Quantum.
-
Sorry for the delay in reply.
None in your area, but maybe other users of Quantum in your area might have good support available to recommend?
Firebird was the worst problem, Oracle has been great in comparison.
The support of servers/workstations/security/applications/licensing is a huge subject…
-
For the Stock line, as an example, I believe you can link:
STOCK.STM_AUTO_KEY
to
IMAGE_LIST.SOURCE_PK
IMAGE-CODES can also be linked to IMAGE _LIST via IMC_AUTO_KEY
IMAGE_LIST I believe holds the links to all imaging in Quantum.
Linked to the appropriate table.auto_key you can get to any images.
I have not got Crystal in front of me, I am just going by some old notes.
So maybe try it and see…
-
Yes, the new version of imaging caused AV threat warnings so exceptions had to be made. Symantec had issues, but other AV was ok, maybe that is why is slipped past testing. Maybe that is what you experienced.
To get things going – because we were at a stop – my tech team put exclusions in without really making any real checks. Which is not a good scenario.
The other ‘thing’ that has always bugged me is someone remotely logging in and then just setting security group Everyone full access to folders – including the folders on the server… without really much due care and attention/planning.
It’s a fairly poor level of security as you have highlighted. I suspect the answer will just be that it is all down to you as the customer, as far as CC are concerned. I don’t think they have the expertise/resources in security to support anything more than what they do for now anyway.
-
Is this the general security bulletin sent out recently? I am assuming it is …
This was due to a few customers falling for malware attacks on their systems.
CC are not equipped to deal with customer security, other than to advise/remind us of the problems we may face if security is not at the required level.
I am not aware of anyone at CC responsible for security questions.
Other than User rights in Quantum.
Overall security for Windows, Oracle, networks, email and web services is a huge topic.
There is no way CC can support that other than a general advisory.
Or is this another bulletin about something else …?
-
Not sure what your question was…?
You can run multiple terminals off any one base station – it sounds like someone told you different?
However….
Having more than 1 base station I would recommend, if you use them routinely in your business going forward.
If your company becomes reliant on them, you would not want to have one base station any more than you would rely on one terminal or computer it is attached to, just so that you have options if one fails.
Each base station then connected to a different computer.
You have then introduced some fault tolerance. Something often not appreciated until the single base station/terminal you might have fails.
For that ‘practical’ reason – if you intend to use a lot of functionality and rely on the barcode technology – 2 separate base stations with one terminal on each as a minimum. From that starting point, you can add more terminals to each base station as needed.
Also… you might have 2 base stations if you needed to use the second one to extend the range etc. depending on your RF requirements/situation.
-
Well… from a purely selfish point of view … as long as it doesnt stop my CP thats fine 😉
-
Looking at the size and complexity of the product I am always suprised at how few people work at CC. They have done really well to get where they are, but I think the product has overtaken the company structure – it has done for some time.
They desperately need more technical staff but I am guessing increasing the payroll is not the number one objective of a new owner(s).
-
Update:
I asked our Helpdesk Team Leader today.
They have just deployed a set of systems and they used DC with no problems.
I checked and they do work fine. They are Windows 7 x86 on Citrix.
No problems. Even the virtual m/c I tested last night works fine today and I just repeated it from the same snapshot/starting point with an upgrade. Hoping to prove the point it doesnt work and then it did, very frustrating…
The team are quite keen to put this to the test with different systems.
I will let them have ago and see if we can find out why these other systems have no problem with DC.
-
Sorry yes it has an issue. We don’t see it on many of the machines as they have other PDF software installed – non adobe – which is default.
Those that do use Adobe, including mine are probably all power users.
The rest do have XI installed now – so they must have been rolled back when I was not looking…
-
We use QC 10.8.9
Adobe Reader has had a few issues over years, but it always fixed with doing Adobe Repair and making sure we do a Reg on the client.
That combination always fixes the issues for us.
We did have an issue at one point which also required an Office repair.
But that was a couple of years ago.
We use Windows 7/8/10 standard desktops, as well as XenDesktop and Xenapp, across a wide range of equipment.
Whilst I agree Adobe Reader has been unstable at points due to a certain sequence of events, it has always been recoverable, without going back to a previous version etc.
-
We did previously use cameras but they were slow to use in comparison over all. When they are taking thousands of pics in that dept. it saves hours a day.
Also, breakages with normal cameras, they just are not designed to be in a busy operational environment.
These S4 and S5 minis with tough cases and gorilla glasss covers are nearly bullet proof.
Whatever works for you though, the good thing here is you have options.
-
Not sure if this is what you are asking but… for Doc and Images?
We use Samsung S4 and S5 Mini’s.
Set the resolution to an acceptable one as default.
We then use QNAP Storage with a client app on the phone
Result is within about 5 to 10 seconds we have photos in shared folder on the network, named for each user.
We have over 40 of these going at any one time in operations.
It also means we can put their emails on there phones and anything else we want them to have. Devices are locked down so that users cannot mess around with them. Essentially they are just cameras.
We take around 6 pics for each receiver and the same for despatch.
So making pictures a quick seemless task is important.
We did use Dropbox but its not great in a corporate network.
QNAP client is great though.
-
Crystal is fine. The Unknown receipt uses it which is where we picked it up previously. Yes you need admin rights to update the client crystal. Not an issue for us as we use Citrix in Operations, so it is one time fix.
We have picked up multiple issues.
All worked through as we came across them.
The one annoyance was the T7758, which needed a manual sql fix per schema. A known issues but shall we say forgotten by those doing the upgrade… Konstantin to the rescue again. Issues stopped Shipping being created from a Sales Order.
A few words about security though and staff on this.
Unlike any previous upgrade the Document and Imaging created issues with Symantec – which if the user did not click accept on a rule exception stopped imaging from working. Despite telling all staff what to do, too many are a bit too click happy with ‘no’.
In addition, the Citrix Receiver had a security warning, which again if the user did not accept/allow the user could then not close the Imaging pop up window – but no error present. A single click by user also created a rule so it never asked again. As often the case users had click amnesia so I didn’t realize until I tested it myself.
So overall be wary of document and imaging security issues – depending on your security software you may get similar but different results.
Some screen scriptor issues with boxes in the wrong place.
Other than that it s been fine for us – but keep in mind we don’t use some of the modules you do.
10.8.9 ok for us and has all our CP 🙂
-
We are upgrading on production to 10.8.9 tonight…
-
Hi Jason
10.8.6 in the last two weeks.
We reported a few bugs/issues.
ISIS scanning didn’t work – it does now with a fix – you use ISIS at AJW?
CM on line items on RO didn’t link.
A few other issues, menu items missing etc. but now fixed.
The latest update early this week was 10.8.6 which we will onto production next week.
Interesting you are testing 10.8.8 when 10.8.6 didn’t work 100%.
I am guessing 10.8.8 is fairly long way from release if 10.8.6 is only just ok.
-
This maybe a fixed bug, I don’t think our 10.7 does this, can you confirm what version of Quantum you are using?
-
Sorry don’t know what happened to that paste … I will edit previous link / post
-
Thanks for Reply, sorry for delay as I totally missed it.
Not that familiar with Python but I will take a look…
Somebody else also kindly gave me this script, which seemed to work well in DIA:
(edited 9 Sept 2016 as original paste had missing lines)
-
For anyone else looking, this is a similar script with an error log file – you need to have ExistingWarehouse defined in table first.
— Start of DDL Script for Procedure DIA.LOC_WHS
— Generated 6-Sep-2016 17:01:05
— Only need a CSV file with 2 columns “NewLocation,ExistingWarehouse”
— No headers
— If Warehouse is not found location not imported – error in log file
— If Warehouse and Location found they will be linked
— If Warehouse is found and Location is not create location and link
CREATE OR REPLACE
PROCEDURE loc_whs (P_IMP NUMBER)
IS
C DIA_RL_PKG.CURSOR_TYPE ;
V_START_LINE NUMBER := DIA_RL_PKG.get_start_line(p_imp) ;
I NUMBER := 0 ;
V_PWD VARCHAR2(100) := NULL;
SYSUR NUMBER;
whs NUMBER;
loc NUMBER;
WLC NUMBER;
V_FILE VARCHAR2(100) := ‘LOC_WHS_ERRORS.log’;
V_FILE_HLD UTL_FILE.file_type ;
BEGIN
OPEN C FOR SELECT PWD, SYSUR_AUTO_KEY FROM SYS_USERS WHERE USER_NAME = ‘SYSDBA’;
FETCH C INTO V_PWD , SYSUR ; CLOSE C;
C := qc_sc_pkg.validate_password(‘SYSDBA’,V_PWD);
CLOSE C ;
C := qc_sc_pkg.validate_password(‘SYSDBA’,V_PWD);
CLOSE C ;
IF NOT UTL_FILE.is_open(V_FILE_HLD) THEN V_FILE_HLD := UTL_FILE.fopen(‘DIA_IMPORT’,V_FILE,’w’,32767) ; END IF ;
FOR R IN ( SELECT ext.location_code, ext.warehouse_code
FROM EXT_LOC_WHS EXT
) LOOP
I := I +1 ;
IF (I >= V_START_LINE) THEN
begin
whs := null ;
for r_whs in (select whs_auto_key from warehouse where warehouse_code = r.warehouse_code ) loop
whs := r_whs.whs_auto_key ;
end loop;
if whs is null then
IF NOT UTL_FILE.is_open(V_FILE_HLD) THEN V_FILE_HLD := UTL_FILE.fopen(‘DIA_IMPORT’,V_FILE,’w’,32767) ; END IF ;
UTL_FILE.put_line(V_FILE_HLD,’Line:’||I||’ is not imported. Warehouse is not found. WAREHOUSE_CODE: ‘ ||R.warehouse_code||’ LOCATION_CODE: ‘||R.location_code );
UTL_FILE.fflush(V_FILE_HLD);
else
loc := NULL ;
IF R.location_code IS NOT NULL THEN
OPEN C FOR select LOC_AUTO_KEY from location where location_code=R.location_code ;
FETCH C INTO LOC;
IF C%NOTFOUND THEN
CLOSE C;
SELECT G_LOC_AUTO_KEY.NEXTVAL INTO LOC FROM DUAL;
INSERT INTO location (LOC_AUTO_KEY, LOCATION_CODE, DESCRIPTION)
VALUES (LOC, R.location_code, R.location_code);
ELSE
CLOSE C;
END IF;
—— WAREHOUSE_LOCATIONS
WLC := null;
for r_WLC in (select WLC.wlc_auto_key from WAREHOUSE_LOCATIONS WLC where WLC.whs_auto_key=whs and loc_auto_key = loc ) loop
WLC := r_WLC.wlc_auto_key;
end loop;
if WLC is null then
insert into WAREHOUSE_LOCATIONS (whs_auto_key,loc_auto_key )
values (whs , loc ) ;
end if;
END IF;
end if;
exception
when others then
IF NOT UTL_FILE.is_open(V_FILE_HLD) THEN V_FILE_HLD := UTL_FILE.fopen(‘DIA_IMPORT’,V_FILE,’w’,32767) ; END IF ;
UTL_FILE.put_line(V_FILE_HLD,’Line:’||I||’ is not imported. WAREHOUSE_CODE: ‘ ||R.warehouse_code||’ LOCATION_CODE: ‘||R.location_code );
UTL_FILE.put_line(V_FILE_HLD,’Line:’||I||’ is not imported. ‘ ||to_char(SQLCODE)||’ : ‘||SQLERRM );
UTL_FILE.fflush(V_FILE_HLD);
end ;
END IF;
END LOOP;
IF UTL_FILE.is_open(V_FILE_HLD) THEN UTL_FILE.fclose(V_FILE_HLD); END IF;
exception
when others then
UTL_FILE.put_line(V_FILE_HLD,’ERROR : ‘ ||to_char(SQLCODE)||’ : ‘||SQLERRM );
UTL_FILE.fflush(V_FILE_HLD);
IF UTL_FILE.is_open(V_FILE_HLD) THEN UTL_FILE.fclose(V_FILE_HLD); END IF;
raise;
END ;
/
— End of DDL Script for Procedure DIA.LOC_WHS
-
Link to error doesn’t seem to work for me.
However, we have around 4 base stations and 12 readers (radio)
We currently have one base station that is doing something similar in Dispatch dept. they only use one base station with 4 readers.
Every day, sometimes a couple of times day the RF program just stops responding. Have changed machine it is attached to and base station – same issue. Assume it is either one of the readers or the something in the Dispatch function ( as only that team use that function ).
All of the other base stations and readers work 100% of the time with no error. Will be swapping over the Dispatch Readers with 4 others used in Goods Receiving (on different stations).
If the fault stays where it is in Dispatch it is something weird in the Dispatch module on the RF.exe. We don’t get an error message though, the RF.exe just stops responding to readers logging on and any Reader already logged on stops responding with Waiting for Base station or something similar.
Only fix is to power cycle the computer and the RF base station to be 100% sure of a return to service.