1 Answer
- Newest
- Most votes
- Most comments
1
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:
answered 4 months ago
Relevant content
- asked a month ago
- Accepted Answerasked 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a year ago