Log in
Linked Applications
Loading…
Spaces
Glossaries
Create
Create
Hit enter to search
Announcement Banner
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Log in
Cash Collection Wiki
Pages
Cash Collection Wiki Home
Solvent inventory E2E Test procedure
Solvent inventory E2E Test procedure
search
attachments
weblink
advanced
image-effects
image-attributes
Paragraph
Paragraph
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Preformatted
Quote
Bold
Italic
Underline
Colour picker
More colours
Formatting
Strikethrough
Subscript
Superscript
Monospace
Clear formatting
Bullet list
Numbered list
Task list
Outdent
Indent
Align left
Align center
Align right
Page layout
Link
Table
Insert
Insert content
Files and images
Link
Markup
Horizontal rule
Task list
Date
Symbol
Insert macro
User mention
Jira Issue/Filter
Info
Add Lucidchart Diagram
draw.io Diagram
Embed draw.io Diagram
draw.io Board Diagram
Status
Gallery
Table of Contents
Google Drive Live Link
Embedded Google Drive Folder
Embedded Google Drive File
Google Drive Search Result
Other macros
Page layout
No layout
Two column (simple)
Two column (simple, left sidebar)
Two column (simple, right sidebar)
Three column (simple)
Two column
Two column (left sidebar)
Two column (right sidebar)
Three column
Three column (left and right sidebars)
Undo
Redo
Find/Replace
Keyboard shortcuts help
You are not logged in. Any changes you make will be marked as
anonymous
. You may want to
Log In
if you already have an account.
This page is also being edited by
. Your changes will be merged with theirs when you save.
<p>To test the Solvent Inventory E2E we are going to introduce mistakes in a solvent experiment and wait for the errors to be sent in the CGP error_logs. To do so you can clone a solvent experiment in ELN TEST, and edit the Excel file. And modify the solvents name by adding caracters, delete caracters and also use the synonyms of the solvent (findable here : <a class="" href="https://docs.google.com/spreadsheets/d/1gKEp0EYVFguKy1Sbwun1-70icGfIZ5HpziSjyya4oyQ/edit?gid=0#gid=0"><img class="editor-inline-macro" src="/plugins/servlet/confluence/placeholder/macro?definition=e2xyZWYtZ2RyaXZlLWZpbGU6dXJsPWh0dHBzOi8vZG9jcy5nb29nbGUuY29tL3NwcmVhZHNoZWV0cy9kLzFnS0VwMEVZVkZndUt5MVNid3VuMS03MGljR2ZJWjVIcHppU2p5eWE0b3lRL2VkaXQ_Z2lkPTAjZ2lkPTB9&locale=en_GB&version=2" data-macro-name="lref-gdrive-file" data-macro-id="0f9a4264-0c57-4c2b-b7ce-c412469385bc" role="button" tabindex="0" aria-haspopup="true" aria-label="lref-gdrive-file macro" data-macro-parameters="url=https://docs.google.com/spreadsheets/d/1gKEp0EYVFguKy1Sbwun1-70icGfIZ5HpziSjyya4oyQ/edit?gid\=0#gid\=0" data-macro-schema-version="1"></a>)</p><p>Then you ask to the data ing to ingest your ELN solvent experiment, and also to run the jobs in order to the the mail for an E2E test ! After that, put next to each other your experiment solvents, the inventory and the result found in the email.</p><p>Example : </p><p>In Green = Errors detected successfully</p><p>In Red = Errors detected, but are false positive...</p><p>In Blue = Proofs that Synonyms are working</p><p>(left is the solvent experiment, middle in the inventory, right in the email)<br /><br /><img class="confluence-embedded-image" draggable="false" height="250" src="/download/attachments/909480496/Capture%20d%E2%80%99e%CC%81cran%202024-11-18%20a%CC%80%2017.52.14.png?version=1&modificationDate=1731953148155&api=v2" data-image-src="/download/attachments/909480496/Capture%20d%E2%80%99e%CC%81cran%202024-11-18%20a%CC%80%2017.52.14.png?version=1&modificationDate=1731953148155&api=v2" data-unresolved-comment-count="0" data-linked-resource-id="909480495" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Capture d’écran 2024-11-18 à 17.52.14.png" data-base-url="https://wiki.syensqo.com" data-linked-resource-content-type="image/png" data-linked-resource-container-id="909480496" data-linked-resource-container-version="2" title="Cash Collection Wiki > Solvent inventory E2E Test procedure > Capture d’écran 2024-11-18 à 17.52.14.png" data-location="Cash Collection Wiki > Solvent inventory E2E Test procedure > Capture d’écran 2024-11-18 à 17.52.14.png" data-image-height="1964" data-image-width="3024"></p><p>Then you can check with a data eng line by line, until all the incorrect lines are not present anymore in GCP. Example of request :</p><p><span style="color: rgb(25,103,210);">SELECT</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(60,64,67);">*</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(25,103,210);">FROM</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(24,128,56);">`prj-data-dm-ri-dev.DM.log_errors`</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(25,103,210);">WHERE</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(0,0,0);">experiment_id</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(25,103,210);">LIKE</span><span style="color: rgb(32,33,36);"> </span><span style="color: rgb(24,128,56);">"1811864"</span></p><p><br /></p><p><img class="confluence-embedded-image" draggable="false" height="250" src="/download/attachments/909480496/Capture%20d%E2%80%99e%CC%81cran%202024-11-19%20a%CC%80%2016.57.13.png?version=1&modificationDate=1732035466583&api=v2" data-image-src="/download/attachments/909480496/Capture%20d%E2%80%99e%CC%81cran%202024-11-19%20a%CC%80%2016.57.13.png?version=1&modificationDate=1732035466583&api=v2" data-unresolved-comment-count="0" data-linked-resource-id="909480827" data-linked-resource-version="1" data-linked-resource-type="attachment" data-linked-resource-default-alias="Capture d’écran 2024-11-19 à 16.57.13.png" data-base-url="https://wiki.syensqo.com" data-linked-resource-content-type="image/png" data-linked-resource-container-id="909480496" data-linked-resource-container-version="2" title="Cash Collection Wiki > Solvent inventory E2E Test procedure > Capture d’écran 2024-11-19 à 16.57.13.png" data-location="Cash Collection Wiki > Solvent inventory E2E Test procedure > Capture d’écran 2024-11-19 à 16.57.13.png" data-image-height="1380" data-image-width="2534"></p>
Edit
Preview
Save
Close
{"serverDuration": 71, "requestCorrelationId": "81e4e1fc869f54e1"}