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
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)"} |