Order Transaction Information
https://delivery.aciqa.io/delivery/ACI?FileName=1004 - Clean for Metadata.aci&orderid=js-smoke-11-27-a&deliveryprofileid=Default&EmployerGuid=5a8419b8-6400-4c8a-9c87-43d678ef9376&FileId=150735575
UnModified OriginalFile Start Over Re-Process
Exceptions
Original File:
File Id Type Download
953952bc-7ceb-4ec0-a1b8-2fa9ecd5b8e3 ACI Download
Address Verification:
Property Type Street Address City State Postal Code Validated Message
Sales 971 N Lakeshore Dr Ludington MI 49431 True As01:Address Verified. The Address Is Valid And Deliverable.
Sales 212 E Ludington Ave Ludington MI 49431 False Ac02:State Change. The State Abbreviation Was Changed Or Added.
Ac03:City Change. The City Name Was Changed Or Added.
Ae09:Suite/Apartment Missing. The Suite Or Apartment Number Is Missing.
As02:Default Address. The Default Building Address Was Verified But The Suite Or Apartment Number Is Missing Or Invalid.
As17:No Mail Delivery. Address Does Not Receive Mail At This Time.(Us Only)
Sales 5 Winterberry Pl Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Subject 121212 Walla Pl West Sacramento CA 95691 False Ae02:Unknown Street. The Street Name Was Not Be Found.
Sales 57 Waters Dr Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Sales 101 Wedgewood Ln Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Sales 18 Wasserman Dr Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Sales 6 Walla Pl Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Sales 8 Winterling Pl Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Sales 12 Winterling Pl Palm Coast FL 32164 True As01:Address Verified. The Address Is Valid And Deliverable.
Artifacts:
Artifact File Id Type Status Message Instance Download
953952bc-7ceb-4ec0-a1b8-2fa9ecd5b8e3 ACI Succeeded Address verification was run Address Verification Download
Transactions:
Instance Name Msg sent Time Elapse Time Start Time End Time Transaction Type Artifact Type Status Message
Address Verification 11/17/2026 22:02:55 00:00:07 11/17/2026 22:02:55 11/17/2026 22:03:02 VerifiedAddresses ACI
Succeeded Address verification was run
Restb Listing/Alternative Sales 11/17/2026 22:03:02 00:00:03 11/17/2026 22:03:02 11/17/2026 22:03:06 RestbListing ACI
Failed Restb Listing Lambda returned status code: 500 body: {"message": "Unknown error: HTTPSConnectionPool(host='aci-primary-test.auth.us-west-2.amazoncognito.com', port=443): Max retries exceeded with url: /oauth2/token (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1147)')))"}
Restb Property AI Data 11/17/2026 22:03:06 00:00:03 11/17/2026 22:03:06 11/17/2026 22:03:10 RestbPropertyAI Failed Restb Property AI returned status code: 500 body: {"message": "Unknown error: (pg8000.dbapi.ProgrammingError) {'S': 'ERROR', 'V': 'ERROR', 'C': '42804', 'M': 'column \"streetview\" is of type jsonb but expression is of type character varying', 'H': 'You will need to rewrite or cast the expression.', 'P': '671', 'F': 'parse_target.c', 'L': '769', 'R': 'transformAssignedExpr'}[SQL: INSERT INTO assignment.\"order\" (ordername, status, createddate, completedate, employerguid, subjectpropertycity, subjectpropertystate, subjectpropertyzipcode, subjectpropertyfipscountycode, subjectpropertycountrycode, subjectpropertylatitude, subjectpropertylongitude, companyname, subjectpropertyaddress1, subjectpropertyaddress2, lastupdateduser, createduser, source, streetview) VALUES (%s::VARCHAR, %s::VARCHAR, %s::TIMESTAMP WITHOUT TIME ZONE, %s::TIMESTAMP WITHOUT TIME ZONE, %s::UUID, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR, %s::VARCHAR) RETURNING assignment.\"order\".id, assignment.\"order\".uuid, assignment.\"order\".statuseventdate][parameters: ('js-smoke-11-27-a', 'orderreceived', datetime.datetime(2026, 11, 17, 22, 3, 8, 563040), None, '5a8419b8-6400-4c8a-9c87-43d678ef9376', 'Palm Coast', 'FL', '95691', None, None, None, None, None, '121212 Walla Pl', None, None, 'd4a8a445-db29-4658-9e5d-f800a0c0afcc', 'soa-restb-AI', None)](Background on this error at: https://sqlalche.me/e/21/f405)"}