<div dir="ltr">Yup, you are correct. The problem was that the database still had the NRCH hostname (localhost) set for Optima1 and Optima2. Now that our server is running again, I had to change it back to <a href="http://demeler5.uleth.ca">demeler5.uleth.ca</a>. I did that and it works again, can you please try again?<div>-Borries</div></div><br><div class="gmail_quote gmail_quote_container"><div dir="ltr" class="gmail_attr">On Sat, Oct 25, 2025 at 5:36 PM Bird, Sophia <<a href="mailto:sophia.bird@uleth.ca">sophia.bird@uleth.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg940619841275751152">
<div dir="ltr">
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<img size="131452" style="width: 254.664px; height: 198px; max-width: 391px;" height="198" width="254" id="m_940619841275751152image_0" src="cid:ii_19a1ddf3899cb971f161"></div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I am back on the cch database; however, this error appears when I open data acquisition.</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
-Sophia</div>
<div id="m_940619841275751152appendonsend"></div>
<hr style="display:inline-block;width:98%">
<div id="m_940619841275751152divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Demelerlab <<a href="mailto:demelerlab-bounces@biophysics.uleth.ca" target="_blank">demelerlab-bounces@biophysics.uleth.ca</a>> on behalf of Alexey Savelyev via Demelerlab <<a href="mailto:demelerlab@biophysics.uleth.ca" target="_blank">demelerlab@biophysics.uleth.ca</a>><br>
<b>Sent:</b> 25 October 2025 14:48<br>
<b>To:</b> Emre Brookes <<a href="mailto:emre.brookes@mso.umt.edu" target="_blank">emre.brookes@mso.umt.edu</a>>; Borries Demeler <<a href="mailto:demeler@gmail.com" target="_blank">demeler@gmail.com</a>>; <a href="mailto:demelerlab@biophysics.uleth.ca" target="_blank">demelerlab@biophysics.uleth.ca</a> <<a href="mailto:demelerlab@biophysics.uleth.ca" target="_blank">demelerlab@biophysics.uleth.ca</a>><br>
<b>Subject:</b> Re: [Demelerlab] Canada databases</font>
<div> </div>
</div>
<div><font size="2"><span style="font-size:11pt">
<div>Yes, that change is required for the dataDisk Pseudoabsorbance type to
<br>
operate via GMP framework..<br>
<br>
There is a PR#20 for SQL repo.<br>
<br>
Alexey<br>
<br>
On 10/25/25 13:54, Emre Brookes wrote:<br>
> CCH and AUCCANADA have been moved back to demeler9.<br>
> Users should be able to resume normal work, albeit on the correct <br>
> servers now.<br>
><br>
> Alexey - noted a sql difference on CCH on NRCH.<br>
> uslims3_CCH : differences dataSource enum in in autoflow & <br>
> autoflowHistory<br>
> < `dataSource` <br>
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL <br>
> DEFAULT 'INSTRUMENT',<br>
> ---<br>
> > `dataSource` <br>
> enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
<br>
> NOT NULL DEFAULT 'INSTRUMENT',<br>
><br>
> I made the equivalent uncommitted local change on <br>
> demeler9:~us3/lims/database/sql<br>
> $ git diff<br>
> diff --git a/us3.sql b/us3.sql<br>
> index 4706095..1f8be0a 100644<br>
> --- a/us3.sql<br>
> +++ b/us3.sql<br>
> @@ -117,7 +117,7 @@ CREATE TABLE IF NOT EXISTS autoflow (<br>
> devRecord enum('NO', 'YES', 'Processed') NOT NULL,<br>
> gmpReviewID int(11) NULL,<br>
> expType enum('VELOCITY','ABDE') NOT NULL,<br>
> - dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT <br>
> 'INSTRUMENT',<br>
> + dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
<br>
> NOT NULL DEFAULT 'INSTRUMENT',<br>
> opticsFailedType varchar(300) NULL,<br>
><br>
> PRIMARY KEY (ID) )<br>
> @@ -159,7 +159,7 @@ CREATE TABLE IF NOT EXISTS autoflowHistory (<br>
> devRecord enum('NO', 'YES', 'Processed') NOT NULL,<br>
> gmpReviewID int(11) NULL,<br>
> expType enum('VELOCITY','ABDE') NOT NULL,<br>
> - dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL DEFAULT <br>
> 'INSTRUMENT',<br>
> + dataSource enum <br>
> ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance')
<br>
> NOT NULL DEFAULT 'INSTRUMENT',<br>
> opticsFailedType varchar(300) NULL,<br>
><br>
> PRIMARY KEY (ID) )<br>
><br>
><br>
><br>
><br>
> Borries Demeler wrote:<br>
>> Everyone:<br>
>> Now that we have our server back online thanks to Saeed's tireless <br>
>> efforts, I want to move the databases back to our server in Canada <br>
>> and disable the CCH and AUCCANADA databases on the NRCH server, so we <br>
>> can move them back to the demeler9 server. I asked Emre to do that, <br>
>> and perhaps send us a short notice when he plans to do it. During <br>
>> this time please do not use the server on either server until we have <br>
>> the green light from Emre to use the server back in Canada again.<br>
>> Thanks! -Borries<br>
><br>
_______________________________________________<br>
Demelerlab mailing list<br>
<a href="mailto:Demelerlab@biophysics.uleth.ca" target="_blank">Demelerlab@biophysics.uleth.ca</a><br>
<a href="https://www.biophysics.uleth.ca/mailman/listinfo/demelerlab" target="_blank">https://www.biophysics.uleth.ca/mailman/listinfo/demelerlab</a><br>
</div>
</span></font></div>
</div>
</div></blockquote></div>