Solutions
To troubleshoot you would need to log in to SQLPLUS via Gold command prompt as diebold user and set SYSLOG debug for a module, have them send a batch print, then query the SYSLOG by module ID and see what data is returned.
1.) Open Gold Command Prompt on the TPS Server as admin and type in sqlplus diebold@oraclegold, once prompted for the password enter in what is found in credential keeper for diebold user.
Note: The step Can be skipped if the school uses SQL Developer or Toad you would just proceed to the next step.
2.) Next run the command to enable the debug that will aid into discovering why the value is not updating to CS Gold:
@setdebug CARDPRINT_SMARTCARD_P 7
3.) After the debug is set have them send a test job and once the issue occurs run this in the SQL session:
SELECT * FROM SYSLOG WHERE moduleid = 'CARDPRINT_SMARTCARD_P' and POSTDATE > SYSDATE - .1;
It will return data similar to:
05-JAN-23 03.29.45.465000 PM batch_printcard ["infomsg"]=>
05-JAN-23 03.29.45.481000 PM batch_printcard string(0) ""
05-JAN-23 03.29.45.481000 PM batch_printcard ["warnmsg"]=>
05-JAN-23 03.29.45.481000 PM batch_printcard string(178) "Failed to get job status: DateTime::__construct(): Failed to parse time string (2023-01-05T20:29:19.461148900Z) at position 0 (2): The timezone could not be found in the database"
4.) The important part is the following:
string(178) "Failed to get job status: DateTime::__construct(): Failed to parse time string (2023-01-05T20:29:19.461148900Z) at position 0 (2): The timezone could not be found in the database"
***This specific error is a known issue by HID and there is a fix that has to be put in place to resolve see email in Additional notes***
To Resolve:
A. ) Go to: https://www.dropbox.com/s/9q2hxo17meqfd5g/HID-FARGO-Connect-ClientSDK-for-PHP-1.7.2.zip?dl=0
If you get a popup about signing in click outside of it and it will go away, you do not need an account to download the file.
B.) Select download and it will download the files needed.
C.) Upload to the downloaded file to the TPS and Web server(s) and verify the media is not blocked by going to properties, if it is blocked select unblock and apply.
D.) Go to: D:\CBORD\DCS\CSGoldWeb\phplib on both the TPS and Web server(s)
E.) Rename the HID_CloudPrint folder and can call it HID_CloudPrintOld
F.) Create a new HID_CloudPrint folder and copy the contents from the SDK that was uploaded onto the system. Make sure to drill down to the PHP files then paste into HID_CloudPrint folder on both the TPS and Web server(s).
G.) After files are replaced have them test print and issue should be resolved.
Additional Notes
From: Morris, Andrew <andrew.morris@hidglobal.com>
Sent: Thursday, November 17, 2022 1:35 PM
To: redacted
Subject: We found an issue with CSGold and the new version of Connect 1.10
Hi everyone,
I am not quite sure who to reach out to on the CSGold side, so please forward this to anyone that we may need to add.
The timestamp formatting was changed with the addition of a newer java version we were forced to move to mitigate potential security issues. We determined that this exposed a bug with php on any version less than 8.1.7. While printing will work just fine, the status retrieval will fail (including card number read back). It appears that it is just not updating the status of the jobs. We need to have any customer update the sdk if they are going to use version 1.10 of Connect. On prem customers can do this when they choose to upgrade Connect. Any cloud customers need to do this immediately. We have our partners reaching out to this handful of customers.
We need CBORD to start using this version of the sdk with any new installs, and let support know how to fix it if a customer reaches out.
We need to update the php sdk to version 1.7.2 that CSGold is using. It is currently at 1.5. The sdk can be found here: https://www.dropbox.com/s/9q2hxo17meqfd5g/HID-FARGO-Connect-ClientSDK-for-PHP-1.7.2.zip?dl=0
The location is in D:\cbord\dcs\csgoldweb\phplib\HID_CloudPrint. I found the error log under d:\program files\Apache…\logs\
I would back up the entire HID_CloudPrint and then overwrite the files from the zip in the link. No need to restart anything.
Specific changes of the 1.7.2 vs 1.5 php sdk (current csgold install) are as follows:
New php files - JobResource.php, CardRednderOption, and JobImageResource.php (all to support image rendering retrieval function – CSGold doesn’t use this)
Client.php - Updated the SDK version
Job.php - Fixed ISO 8601 timestamp parsing for the submitDate and lastUpdate properties
JobApi.php - Fixed ISO 8601 timestamp parsing for the startDate and endDate properties
ProductionRequestTemplate.php - Fix for jobs with multiple image parameters
There is a php bug that is causing timestamps to not read correctly:
Here are more details on the php bug:
https://bugs.php.net/bug.php?id=51987 if you scroll down you will see the comment: for inclusion into PHP 8.1.7 (or PHP 8.1.8) and PHP 8.2 and later.
Thanks,
Andrew Morris
Solutions Manager
Mobile: +1-510-427-8004
6533 Flying Cloud Dr, Eden Prairie, MN 55344
Comments
0 comments