...
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
...
Environment Variables | Description |
| It collect only those event from ifix service which matches to this receiver value. |
| It searches events from iFix service based on this time interval. |
| mGramSeva OAuth token username. |
| mGramSeva OAuth token password. |
| mGramSeva OAuth token scope. |
| mGramSeva OAuth token grant type. |
| mGramSeva OAuth token tenant id. |
| mGramSeva OAuth token user type. |
| It is a quartz job time interval value. |
| It has two values “Never” or “Always” for Quartz table creation. Never - It wont create any table Always - It will create table every time when service deploy and erase every existing details. (Not recommended).
|
| Host name of mGramSeva |
Related Page
PSPCL Adaptor v1.0 Release notes