mmalmeida

Stock Item (SI) - an item
Movement History (H) - a movement of one or more stock items from A to B. Has 1 or more Reception information
Reception Information (RI) - Details on the reception conditions. One RI per SI (eg if H is a movement of 2 stock item, it will have 2 RI)

Query - I want to find missmatches between current location of the SI and what the most recent movement history for that item says that stock item went to. Something similar to:

SELECT h.*,ri.code_id,si.*
  FROM iwrs.movement_history h inner join iwrs.reception_information ri on ri.movement_history_id = h.id
inner join iwrs.stock_item si on si.id=ri.code_id
where ri.code_id in

mmalmeida

<centralreservas@melvar.pt>: host email.net.vodafone.pt[213.134.48.171] said:
    550 5.7.1 <centralreservas@melvar.pt>: Recipient address rejected: Mail
    appeared to be SPAM or forged. Ask your Mail/DNS-Administrator to correct
    HELO and DNS MX settings or to get removed from DNSBLs; please relay via
    your ISP (almeida.at) (in reply to RCPT TO command)

mmalmeida

package at.almeida.tests;

import static org.junit.Assert.assertEquals;

import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerConfigurationException;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.TransformerFactoryConfigurationError;

import org.junit.Before;

mmalmeida

Jun 19 19:38:02 webservices postfix/smtpd[4031]: connect from localhost[127.0.0.1]
Jun 19 19:38:02 webservices postfix/smtpd[4031]: EFB8712EA12C: client=localhost[127.0.0.1]
Jun 19 19:38:02 webservices postfix/cleanup[4021]: EFB8712EA12C: message-id=<977093308.119.1403203070606.JavaMail.tomcat7@vps001.itclinical.com>
Jun 19 19:38:02 webservices postfix/qmgr[19318]: EFB8712EA12C: from=<iwrs@itclinical.com>, size=1248, nrcpt=1 (queue active)
Jun 19 19:38:02 webservices postfix/smtpd[4031]: disconnect from localhost[127.0.0.1]
Jun 19 19:38:03 webservices amavis[3516]: (03516-13) Passed CLEAN, [46.105.29.10] [46.105.29.10] <iwrs@itclinical.com> -> <leeiannotti.joyce@mayo.edu>, Message-ID: <97709
3308.119.1403203070606.JavaMail.tomcat7@vps001.itclinical.com>, mail_id: ikgWcZjfrqw4, Hits: -2.9, size: 625, queued_as: EFB8712EA12C, 12268 ms
Jun 19 19:38:03 webservices postfix/smtp[4022]: A0B4612EA106: to=<leeiannotti.joyce@mayo.edu>, relay=127.0.0.1[127.0.0.1]:10024, delay=12, delays=0.12/0/0.01/12, dsn=2.0.
0, statu

mmalmeida

protected ZipOutputStream createZipFile(File file, List<DataCollectionItf> answers)
			throws ExportException {
		ZipOutputStream zipFile;
		try {
			zipFile = newZipFile(file);
		} catch (FileNotFoundException e1) {
			throw new ExportException("Zip file could not be initialised",e1);
		}

		List<String> filesAdded = new ArrayList<String>();

mmalmeida

	@Test
	public void xxx() throws FileNotFoundException, IOException{
		file = File.createTempFile("temp-file", ".zip");
		new ZipOutputStream(new FileOutputStream(file)).close();
	}

mmalmeida

Delivery to the following recipient failed permanently:

     conceição-fake@host.com

Technical details of permanent failure:
 local-part of envelope contains utf8 but remote  server did not offer SMTPUTF8

----- Original message -----

DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;

mmalmeida

Nov 17 15:50:23 webservices postfix/smtpd[22095]: connect from unknown[192.168.10.111]
Nov 17 15:50:23 webservices postfix/smtpd[22095]: B0A8E12EA157: client=unknown[192.168.10.111], sasl_method=PLAIN, sasl_username=user1
Nov 17 15:50:23 webservices postfix/cleanup[22108]: B0A8E12EA157: message-id=<1416239366.3332.28.camel@itcd001>
Nov 17 15:50:23 webservices postfix/qmgr[20450]: B0A8E12EA157: from=<user1@example.com>, size=997, nrcpt=1 (queue active)
Nov 17 15:50:23 webservices postfix/smtpd[22095]: disconnect from unknown[192.168.10.111]
Nov 17 15:50:23 webservices amavis[21178]: (21178-08) WARN: address modified (recip): <jo\303\243o-fake@example.com> -> <"jo\\\303\\\243o-fake"@example.com>
Nov 17 15:50:37 webservices postfix/smtpd[22116]: connect from localhost[127.0.0.1]
Nov 17 15:50:37 webservices postfix/smtpd[22116]: 5A32712EA1B1: client=localhost[127.0.0.1]
Nov 17 15:50:37 webservices postfix/cleanup[22106]: 5A32712EA1B1: message-id=<1416239366.3332.28.camel@itcd001>
Nov 17 15:50:37 webservices postf

mmalmeida

VirtualBox VM 4.2.16 r86992 linux.amd64 (Jul  4 2013 15:00:28) release log
00:00:00.045638 Log opened 2015-02-04T11:17:16.368526000Z
00:00:00.045642 OS Product: Linux
00:00:00.045643 OS Release: 2.6.32-50-generic
00:00:00.045644 OS Version: #112-Ubuntu SMP Tue Jul 9 20:28:23 UTC 2013
00:00:00.045666 DMI Product Name: System Product Name
00:00:00.045674 DMI Product Version: System Version
00:00:00.045744 Host RAM: 8002MB total, 5590MB available
00:00:00.045748 Executable: /usr/lib/virtualbox/VBoxHeadless
00:00:00.045748 Process ID: 5423

mmalmeida

$ cat /mnt/hdc/VirtualBox\ VMs/webservices/Logs/VBox.log |grep "TM:"
00:00:00.203349 TM: GIP - u32Mode=1 (SyncTSC) u32UpdateHz=99
00:00:00.235495 TM: cTSCTicksPerSecond=0xb0cab5e0 (2 966 074 848) fTSCVirtualized=true  fTSCUseRealTSC=false
00:00:00.235504 TM: fMaybeUseOffsettedHostTSC=true  TSCTiedToExecution=false TSCNotTiedToHalt=false

$ cat /mnt/hdc/VirtualBox\ VMs/webservices/Logs/VBox.log.1 |grep "TM:"
00:00:00.714111 TM: GIP - u32Mode=1 (SyncTSC) u32UpdateHz=100
00:00:00.746199 TM: cTSCTicksPerSecond=0xb2a6a970 (2 997 266 800) fTSCVirtualized=true  fTSCUseRealTSC=false
00:00:00.746206 TM: fMaybeUseOffsettedHostTSC=true  TSCTiedToExecution=false TSCNotTiedToHalt=false