...
Log persistence
It logs every event which has been processed. It also captures the activity, when no event is found from the iFix fiscal event service. It stores success message as well as failure message in “pspcl_event_detail” table.
SQL Migration
It introduced an attribute “referenceid” in “eg_echallan” table to consolidate consumer code. To match with all previous record, reference id will have the value of “challanno”. It’s only for old record maintenance.
Steps for SQL script.
Go to Kubernetes playground with mgramseva name space.
kubectl exec -it <playground> -n <mgramseva namespace> -- /bin/bash
Connect with Postgres DB using appropriate user credentials.
psql -h postgres.mgramseva -U <username> <mgramseva_db>
Run the update command
UPDATE EG_ECHALLAN SET REFERENCEID=CHALLANNO WHERE (REFERENCEID IS NULL OR REFERENCEID = '')
Verify by select command.
Deployment Details
Deploy the latest version of ifix-reference-adapter
...