AWS Blu Age L3 carddemo-web File Error: READ on CXACAIX

Question

Hello team, hope everyone is doing fine,
I'm currently doing the AWS L3 Workshop, im at the step 
execution->test->online->User features 
and I'm stuck with the following error when trying to view any account:

![Error](/media/postImages/original/IMNKr34Z0XQfGQbA1s1uGdcg)

File Error: READ     on CXACAIX   returned RESP 000000012 ,RESP2 000000001

there's no exception or errors in the console, only a message of a missing file but it's hard to know since it doesn't give much detail:

![LOG](/media/postImages/original/IM8CJFXvKgQLmwdqayRPnH3g)

I´m aware there's a step in the workshop where you have to remove CXACAIX references, but I already checked I did correctly in the transformed files.

Any guidance or tips on how to fix this would be greatly appreciated.

ArnO · Answer

Please check again that you have correctly made the ad hoc modifications related to **Alternate Indexes** handling
* No record must be present in **FILE_TABLE** table with **FILE_COL** equal **CXACAIX** or **CARDAIX** from **jics** database (execute below SQL request to check that no rows are returned)
* A JSON file named **jicsFileAix.json** must be created with below content and be present in the working directory for local deployment (check your working directory setup and content)

```
# No rows should be returned
select * from file_table where file_col = 'CARDAIX' or file_col = 'CXACAIX';
```

```
[{
  "fileAix" : "CXACAIX",
  "relativeKeyPosition" : 25,
  "keyLength" : 11,
  "allowDuplicates" : true,
  "associatedFile" : "CCXREF"
},
{
  "fileAix" : "CARDAIX",
  "relativeKeyPosition" : 16,
  "keyLength" : 11,
  "allowDuplicates" : true,
  "associatedFile" : "CARDDAT"
}]
```

Instructions pages: 
* https://catalog.workshops.aws/aws-blu-age-l3-certification-workshop/en-US/ad-hoc-modifications/alternate-indexes
* https://catalog.workshops.aws/aws-blu-age-l3-certification-workshop/en-US/data-migration/misc/alternate-indexes

Solution pages: 
* https://catalog.workshops.aws/aws-blu-age-l3-certification-workshop/en-US/solution/ad-hoc-modifications/alternate-indexes
* https://catalog.workshops.aws/aws-blu-age-l3-certification-workshop/en-US/solution/data-migration/misc/alternate-indexes

Edwin · Answer

![Enter image description here](/media/postImages/original/IMfnvb3xJJSDOUVVaNiD24Pg)

NO Data on CardDemo Jics DB

Edwin · Answer

Tried above solution.
Checked:
No record must be present in FILE_TABLE table with FILE_COL equal CXACAIX or CARDAIX from jics database (execute below SQL request to check that no rows are returned)
A JSON file named jicsFileAix.json must be created with below content and be present in the working directory for local deployment (check your working directory setup and content)
Still getting the same error
![Enter image description here](/media/postImages/original/IM4_tW3e7jRhOER-dhECZ_jw)

AWS Blu Age L3 carddemo-web File Error: READ on CXACAIX

Add your answer

Relevant content