Hello,
we are using CMDBuild 2.3.4 (installed on Centos and Tomcat6), everything is working correctly except that we are not able to send emails (we tried by creating a synchronous event and also just sending them by using the tool: compose e-mail in the administration module).
Could you please check where is our mistake?
If any other information is needed, do not hesitate to contact us.
Thanks in advance!
Here is the log file:
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"Email#EmailStatus"."Description" AS "Email#EmailStatus#Description", "Email#Card"."Description" AS "Email#Card#Description", "Email"."Code" AS "Email#Code", "Email"."Description" AS "Email#Description", "Email"."Notes" AS "Email#Notes", "Email"."Card" AS "Email#Card", "Email"."EmailStatus" AS "Email#EmailStatus", "Email"."FromAddress" AS "Email#FromAddress", "Email"."ToAddresses" AS "Email#ToAddresses", "Email"."CcAddresses" AS "Email#CcAddresses", "Email"."BccAddresses" AS "Email#BccAddresses", "Email"."Subject" AS "Email#Subject", "Email"."Content" AS "Email#Content", "Email"."NotifyWith" AS "Email#NotifyWith", "Email"."NoSubjectPrefix" AS "Email#NoSubjectPrefix", "Email"."Account" AS "Email#Account", "Email"."Template" AS "Email#Template", "Email"."KeepSynchronization" AS "Email#KeepSynchronization", "Email"."PromptSynchronization" AS "Email#PromptSynchronization", "Email"."Delay" AS "Email#Delay", "Email"."IdClass"::oid AS "_Email_IdClass", "Email"."Id" AS "_Email_Id", "Email"."User" AS "_Email_User", "Email"."BeginDate" AS "_Email_BeginDate"
FROM "Email" AS "Email"
LEFT JOIN "LookUp" AS "Email#EmailStatus" ON "Email#EmailStatus"."Id" = "Email"."EmailStatus"
LEFT JOIN "Class" AS "Email#Card" ON "Email#Card"."Id" = "Email"."Card"
WHERE "Email"."Id" = ? AND "Email"."Status" = ?) AS main
ORDER BY "_Email_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3762, A]
DEBUG 2016-02-18 13:31:19 [cmdbuild] invoking method 'public abstract void org.cmdbuild.services.event.Observer.afterUpdate(org.cmdbuild.dao.entry.CMCard,org.cmdbuild.dao.entry.CMCard)' on object 'org.cmdbuild.logic.taskmanager.event.DefaultSynchronousEventFacade$DefaultIdentifiableObserver@79aa675b[identifier=2409]'
DEBUG 2016-02-18 13:31:19 [jsonrpc ] creating JSON element for '3581'
DEBUG 2016-02-18 13:31:19 [jsonrpc ] resulting element is '{"attribute":"Id","value":[3581],"operator":"equal"}'
INFO 2016-02-18 13:31:19 [jsonrpc ] adding condition '{"attribute":"Id","value":[3581],"operator":"equal"}' to actual filter '{"attribute":{},"relation":[]}'
DEBUG 2016-02-18 13:31:19 [jsonrpc ] attribute element is empty
DEBUG 2016-02-18 13:31:19 [jsonrpc ] resulting filter is '{"attribute":{"simple":{"attribute":"Id","value":[3581],"operator":"equal"}},"relation":[]}'
INFO 2016-02-18 13:31:19 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2016-02-18 13:31:19 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT DISTINCT ON ("_AGRUPACION_BBDD_Id")
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE "AGRUPACION_BBDD"."Id" = ? AND "AGRUPACION_BBDD"."Status" = ?) AS main
ORDER BY "AGRUPACION_BBDD#Description" ASC, "_AGRUPACION_BBDD_Id"
LIMIT 2147483647
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3581, A]
INFO 2016-02-18 13:31:19 [cmdbuild] reading template 'Modification'
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailTemplate#Account"."Description" AS "_EmailTemplate#Account#Description", "SRC"."Code" AS "SRC#Code", "SRC"."Description" AS "SRC#Description", "SRC"."From" AS "SRC#From", "SRC"."Notes" AS "SRC#Notes", "SRC"."To" AS "SRC#To", "SRC"."CC" AS "SRC#CC", "SRC"."BCC" AS "SRC#BCC", "SRC"."Subject" AS "SRC#Subject", "SRC"."Body" AS "SRC#Body", "SRC"."Account" AS "SRC#Account", "SRC"."KeepSynchronization" AS "SRC#KeepSynchronization", "SRC"."PromptSynchronization" AS "SRC#PromptSynchronization", "SRC"."Delay" AS "SRC#Delay", "DST"."Code" AS "DST#Code", "DST"."Description" AS "DST#Description", "DST"."Notes" AS "DST#Notes", "SRC"."IdClass"::oid AS "_SRC_IdClass", "SRC"."Id" AS "_SRC_Id", "SRC"."User" AS "_SRC_User", "SRC"."BeginDate" AS "_SRC_BeginDate", "DST"."IdClass"::oid AS "_DST_IdClass", "DST"."Id" AS "_DST_Id", "DST"."User" AS "_DST_User", "DST"."BeginDate" AS "_DST_BeginDate", "DOM"."IdDomain"::oid AS "_DOM_IdDomain", "DOM"."_Src" AS "_DOM__Src", "DOM"."Id" AS "_DOM_Id", "DOM"."User" AS "_DOM_User", "DOM"."BeginDate" AS "_DOM_BeginDate", "DOM"."EndDate" AS "_DOM_EndDate", "DOM"."IdObj1" AS "_DOM_IdObj1", "DOM"."IdObj2" AS "_DOM_IdObj2"
FROM "_EmailTemplate" AS "SRC"
LEFT JOIN "_EmailAccount" AS "_EmailTemplate#Account" ON "_EmailTemplate#Account"."Id" = "SRC"."Account"
LEFT JOIN (SELECT "Id", "IdDomain", ? AS "_Src", "IdObj1", "IdObj2", "User", "BeginDate", NULL AS "EndDate" FROM ONLY "Map_ClassMetadata" WHERE "Map_ClassMetadata"."Status" = ?) AS "DOM" ON "SRC"."Id"="DOM"."IdObj1" LEFT JOIN (SELECT "Id", "IdClass", "User", "BeginDate", NULL AS "EndDate", NULL AS "CurrentId", "Code", "Description", "Notes" FROM ONLY "Metadata" WHERE "Metadata"."Status" = ?) AS "DST" ON "DOM"."IdObj2"="DST"."Id"
WHERE TRUE AND "SRC"."Status" = ?) AS main
ORDER BY "_SRC_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [_1, A, A, A]
WARN 2016-02-18 13:31:19 [sql ] class not found for IdClass '0', skipping creation
WARN 2016-02-18 13:31:19 [sql ] class not found for IdClass '0', skipping creation
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailTemplate#Account"."Description" AS "_EmailTemplate#Account#Description", "SRC"."Code" AS "SRC#Code", "SRC"."Description" AS "SRC#Description", "SRC"."From" AS "SRC#From", "SRC"."Notes" AS "SRC#Notes", "SRC"."To" AS "SRC#To", "SRC"."CC" AS "SRC#CC", "SRC"."BCC" AS "SRC#BCC", "SRC"."Subject" AS "SRC#Subject", "SRC"."Body" AS "SRC#Body", "SRC"."Account" AS "SRC#Account", "SRC"."KeepSynchronization" AS "SRC#KeepSynchronization", "SRC"."PromptSynchronization" AS "SRC#PromptSynchronization", "SRC"."Delay" AS "SRC#Delay", "DST"."Code" AS "DST#Code", "DST"."Description" AS "DST#Description", "DST"."Notes" AS "DST#Notes", "SRC"."IdClass"::oid AS "_SRC_IdClass", "SRC"."Id" AS "_SRC_Id", "SRC"."User" AS "_SRC_User", "SRC"."BeginDate" AS "_SRC_BeginDate", "DST"."IdClass"::oid AS "_DST_IdClass", "DST"."Id" AS "_DST_Id", "DST"."User" AS "_DST_User", "DST"."BeginDate" AS "_DST_BeginDate", "DOM"."IdDomain"::oid AS "_DOM_IdDomain", "DOM"."_Src" AS "_DOM__Src", "DOM"."Id" AS "_DOM_Id", "DOM"."User" AS "_DOM_User", "DOM"."BeginDate" AS "_DOM_BeginDate", "DOM"."EndDate" AS "_DOM_EndDate", "DOM"."IdObj1" AS "_DOM_IdObj1", "DOM"."IdObj2" AS "_DOM_IdObj2"
FROM "_EmailTemplate" AS "SRC"
LEFT JOIN "_EmailAccount" AS "_EmailTemplate#Account" ON "_EmailTemplate#Account"."Id" = "SRC"."Account"
LEFT JOIN (SELECT "Id", "IdDomain", ? AS "_Src", "IdObj1", "IdObj2", "User", "BeginDate", NULL AS "EndDate" FROM ONLY "Map_ClassMetadata" WHERE "Map_ClassMetadata"."Status" = ?) AS "DOM" ON "SRC"."Id"="DOM"."IdObj1" LEFT JOIN (SELECT "Id", "IdClass", "User", "BeginDate", NULL AS "EndDate", NULL AS "CurrentId", "Code", "Description", "Notes" FROM ONLY "Metadata" WHERE "Metadata"."Status" = ?) AS "DST" ON "DOM"."IdObj2"="DST"."Id"
WHERE "SRC"."Code" = ? AND "SRC"."Status" = ?) AS main
ORDER BY "_SRC_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [_1, A, A, Modification, A]
WARN 2016-02-18 13:31:19 [sql ] class not found for IdClass '0', skipping creation
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"Email#EmailStatus"."Description" AS "Email#EmailStatus#Description", "Email#Card"."Description" AS "Email#Card#Description", "Email"."Code" AS "Email#Code", "Email"."Description" AS "Email#Description", "Email"."Notes" AS "Email#Notes", "Email"."Card" AS "Email#Card", "Email"."EmailStatus" AS "Email#EmailStatus", "Email"."FromAddress" AS "Email#FromAddress", "Email"."ToAddresses" AS "Email#ToAddresses", "Email"."CcAddresses" AS "Email#CcAddresses", "Email"."BccAddresses" AS "Email#BccAddresses", "Email"."Subject" AS "Email#Subject", "Email"."Content" AS "Email#Content", "Email"."NotifyWith" AS "Email#NotifyWith", "Email"."NoSubjectPrefix" AS "Email#NoSubjectPrefix", "Email"."Account" AS "Email#Account", "Email"."Template" AS "Email#Template", "Email"."KeepSynchronization" AS "Email#KeepSynchronization", "Email"."PromptSynchronization" AS "Email#PromptSynchronization", "Email"."Delay" AS "Email#Delay", "Email"."IdClass"::oid AS "_Email_IdClass", "Email"."Id" AS "_Email_Id", "Email"."User" AS "_Email_User", "Email"."BeginDate" AS "_Email_BeginDate"
FROM "Email" AS "Email"
LEFT JOIN "LookUp" AS "Email#EmailStatus" ON "Email#EmailStatus"."Id" = "Email"."EmailStatus"
LEFT JOIN "Class" AS "Email#Card" ON "Email#Card"."Id" = "Email"."Card"
WHERE "Email"."Id" = ? AND "Email"."Status" = ?) AS main
ORDER BY "_Email_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3767, A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"Email#EmailStatus"."Description" AS "Email#EmailStatus#Description", "Email#Card"."Description" AS "Email#Card#Description", "Email"."Code" AS "Email#Code", "Email"."Description" AS "Email#Description", "Email"."Notes" AS "Email#Notes", "Email"."Card" AS "Email#Card", "Email"."EmailStatus" AS "Email#EmailStatus", "Email"."FromAddress" AS "Email#FromAddress", "Email"."ToAddresses" AS "Email#ToAddresses", "Email"."CcAddresses" AS "Email#CcAddresses", "Email"."BccAddresses" AS "Email#BccAddresses", "Email"."Subject" AS "Email#Subject", "Email"."Content" AS "Email#Content", "Email"."NotifyWith" AS "Email#NotifyWith", "Email"."NoSubjectPrefix" AS "Email#NoSubjectPrefix", "Email"."Account" AS "Email#Account", "Email"."Template" AS "Email#Template", "Email"."KeepSynchronization" AS "Email#KeepSynchronization", "Email"."PromptSynchronization" AS "Email#PromptSynchronization", "Email"."Delay" AS "Email#Delay", "Email"."IdClass"::oid AS "_Email_IdClass", "Email"."Id" AS "_Email_Id", "Email"."User" AS "_Email_User", "Email"."BeginDate" AS "_Email_BeginDate"
FROM "Email" AS "Email"
LEFT JOIN "LookUp" AS "Email#EmailStatus" ON "Email#EmailStatus"."Id" = "Email"."EmailStatus"
LEFT JOIN "Class" AS "Email#Card" ON "Email#Card"."Id" = "Email"."Card"
WHERE "Email"."Id" = ? AND "Email"."Status" = ?) AS main
ORDER BY "_Email_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3767, A]
DEBUG 2016-02-18 13:31:19 [cmdbuild] invoking method 'public abstract void org.cmdbuild.services.event.Observer.afterUpdate(org.cmdbuild.dao.entry.CMCard,org.cmdbuild.dao.entry.CMCard)' on object 'org.cmdbuild.logic.taskmanager.event.DefaultSynchronousEventFacade$DefaultIdentifiableObserver@2ccaa680[identifier=3637]'
DEBUG 2016-02-18 13:31:19 [jsonrpc ] creating JSON element for '3581'
DEBUG 2016-02-18 13:31:19 [jsonrpc ] resulting element is '{"attribute":"Id","value":[3581],"operator":"equal"}'
INFO 2016-02-18 13:31:19 [jsonrpc ] adding condition '{"attribute":"Id","value":[3581],"operator":"equal"}' to actual filter '{}'
DEBUG 2016-02-18 13:31:19 [jsonrpc ] filter has no element 'attribute' adding an empty one
DEBUG 2016-02-18 13:31:19 [jsonrpc ] attribute element is empty
DEBUG 2016-02-18 13:31:19 [jsonrpc ] resulting filter is '{"attribute":{"simple":{"attribute":"Id","value":[3581],"operator":"equal"}}}'
INFO 2016-02-18 13:31:19 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2016-02-18 13:31:19 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE "AGRUPACION_BBDD"."Id" = ? AND "AGRUPACION_BBDD"."Status" = ?) AS main
ORDER BY "AGRUPACION_BBDD#Description" ASC, "_AGRUPACION_BBDD_Id"
LIMIT 2147483647
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3581, A]
INFO 2016-02-18 13:31:19 [cmdbuild] reading template 'Modification2'
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailTemplate#Account"."Description" AS "_EmailTemplate#Account#Description", "SRC"."Code" AS "SRC#Code", "SRC"."Description" AS "SRC#Description", "SRC"."From" AS "SRC#From", "SRC"."Notes" AS "SRC#Notes", "SRC"."To" AS "SRC#To", "SRC"."CC" AS "SRC#CC", "SRC"."BCC" AS "SRC#BCC", "SRC"."Subject" AS "SRC#Subject", "SRC"."Body" AS "SRC#Body", "SRC"."Account" AS "SRC#Account", "SRC"."KeepSynchronization" AS "SRC#KeepSynchronization", "SRC"."PromptSynchronization" AS "SRC#PromptSynchronization", "SRC"."Delay" AS "SRC#Delay", "DST"."Code" AS "DST#Code", "DST"."Description" AS "DST#Description", "DST"."Notes" AS "DST#Notes", "SRC"."IdClass"::oid AS "_SRC_IdClass", "SRC"."Id" AS "_SRC_Id", "SRC"."User" AS "_SRC_User", "SRC"."BeginDate" AS "_SRC_BeginDate", "DST"."IdClass"::oid AS "_DST_IdClass", "DST"."Id" AS "_DST_Id", "DST"."User" AS "_DST_User", "DST"."BeginDate" AS "_DST_BeginDate", "DOM"."IdDomain"::oid AS "_DOM_IdDomain", "DOM"."_Src" AS "_DOM__Src", "DOM"."Id" AS "_DOM_Id", "DOM"."User" AS "_DOM_User", "DOM"."BeginDate" AS "_DOM_BeginDate", "DOM"."EndDate" AS "_DOM_EndDate", "DOM"."IdObj1" AS "_DOM_IdObj1", "DOM"."IdObj2" AS "_DOM_IdObj2"
FROM "_EmailTemplate" AS "SRC"
LEFT JOIN "_EmailAccount" AS "_EmailTemplate#Account" ON "_EmailTemplate#Account"."Id" = "SRC"."Account"
LEFT JOIN (SELECT "Id", "IdDomain", ? AS "_Src", "IdObj1", "IdObj2", "User", "BeginDate", NULL AS "EndDate" FROM ONLY "Map_ClassMetadata" WHERE "Map_ClassMetadata"."Status" = ?) AS "DOM" ON "SRC"."Id"="DOM"."IdObj1" LEFT JOIN (SELECT "Id", "IdClass", "User", "BeginDate", NULL AS "EndDate", NULL AS "CurrentId", "Code", "Description", "Notes" FROM ONLY "Metadata" WHERE "Metadata"."Status" = ?) AS "DST" ON "DOM"."IdObj2"="DST"."Id"
WHERE TRUE AND "SRC"."Status" = ?) AS main
ORDER BY "_SRC_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [_1, A, A, A]
WARN 2016-02-18 13:31:19 [sql ] class not found for IdClass '0', skipping creation
WARN 2016-02-18 13:31:19 [sql ] class not found for IdClass '0', skipping creation
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailTemplate#Account"."Description" AS "_EmailTemplate#Account#Description", "SRC"."Code" AS "SRC#Code", "SRC"."Description" AS "SRC#Description", "SRC"."From" AS "SRC#From", "SRC"."Notes" AS "SRC#Notes", "SRC"."To" AS "SRC#To", "SRC"."CC" AS "SRC#CC", "SRC"."BCC" AS "SRC#BCC", "SRC"."Subject" AS "SRC#Subject", "SRC"."Body" AS "SRC#Body", "SRC"."Account" AS "SRC#Account", "SRC"."KeepSynchronization" AS "SRC#KeepSynchronization", "SRC"."PromptSynchronization" AS "SRC#PromptSynchronization", "SRC"."Delay" AS "SRC#Delay", "DST"."Code" AS "DST#Code", "DST"."Description" AS "DST#Description", "DST"."Notes" AS "DST#Notes", "SRC"."IdClass"::oid AS "_SRC_IdClass", "SRC"."Id" AS "_SRC_Id", "SRC"."User" AS "_SRC_User", "SRC"."BeginDate" AS "_SRC_BeginDate", "DST"."IdClass"::oid AS "_DST_IdClass", "DST"."Id" AS "_DST_Id", "DST"."User" AS "_DST_User", "DST"."BeginDate" AS "_DST_BeginDate", "DOM"."IdDomain"::oid AS "_DOM_IdDomain", "DOM"."_Src" AS "_DOM__Src", "DOM"."Id" AS "_DOM_Id", "DOM"."User" AS "_DOM_User", "DOM"."BeginDate" AS "_DOM_BeginDate", "DOM"."EndDate" AS "_DOM_EndDate", "DOM"."IdObj1" AS "_DOM_IdObj1", "DOM"."IdObj2" AS "_DOM_IdObj2"
FROM "_EmailTemplate" AS "SRC"
LEFT JOIN "_EmailAccount" AS "_EmailTemplate#Account" ON "_EmailTemplate#Account"."Id" = "SRC"."Account"
LEFT JOIN (SELECT "Id", "IdDomain", ? AS "_Src", "IdObj1", "IdObj2", "User", "BeginDate", NULL AS "EndDate" FROM ONLY "Map_ClassMetadata" WHERE "Map_ClassMetadata"."Status" = ?) AS "DOM" ON "SRC"."Id"="DOM"."IdObj1" LEFT JOIN (SELECT "Id", "IdClass", "User", "BeginDate", NULL AS "EndDate", NULL AS "CurrentId", "Code", "Description", "Notes" FROM ONLY "Metadata" WHERE "Metadata"."Status" = ?) AS "DST" ON "DOM"."IdObj2"="DST"."Id"
WHERE "SRC"."Code" = ? AND "SRC"."Status" = ?) AS main
ORDER BY "_SRC_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [_1, A, A, Modification2, A]
WARN 2016-02-18 13:31:19 [sql ] class not found for IdClass '0', skipping creation
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"Email#EmailStatus"."Description" AS "Email#EmailStatus#Description", "Email#Card"."Description" AS "Email#Card#Description", "Email"."Code" AS "Email#Code", "Email"."Description" AS "Email#Description", "Email"."Notes" AS "Email#Notes", "Email"."Card" AS "Email#Card", "Email"."EmailStatus" AS "Email#EmailStatus", "Email"."FromAddress" AS "Email#FromAddress", "Email"."ToAddresses" AS "Email#ToAddresses", "Email"."CcAddresses" AS "Email#CcAddresses", "Email"."BccAddresses" AS "Email#BccAddresses", "Email"."Subject" AS "Email#Subject", "Email"."Content" AS "Email#Content", "Email"."NotifyWith" AS "Email#NotifyWith", "Email"."NoSubjectPrefix" AS "Email#NoSubjectPrefix", "Email"."Account" AS "Email#Account", "Email"."Template" AS "Email#Template", "Email"."KeepSynchronization" AS "Email#KeepSynchronization", "Email"."PromptSynchronization" AS "Email#PromptSynchronization", "Email"."Delay" AS "Email#Delay", "Email"."IdClass"::oid AS "_Email_IdClass", "Email"."Id" AS "_Email_Id", "Email"."User" AS "_Email_User", "Email"."BeginDate" AS "_Email_BeginDate"
FROM "Email" AS "Email"
LEFT JOIN "LookUp" AS "Email#EmailStatus" ON "Email#EmailStatus"."Id" = "Email"."EmailStatus"
LEFT JOIN "Class" AS "Email#Card" ON "Email#Card"."Id" = "Email"."Card"
WHERE "Email"."Id" = ? AND "Email"."Status" = ?) AS main
ORDER BY "_Email_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3772, A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"_EmailAccount"."Code" AS "_EmailAccount#Code", "_EmailAccount"."IsDefault" AS "_EmailAccount#IsDefault", "_EmailAccount"."Address" AS "_EmailAccount#Address", "_EmailAccount"."Description" AS "_EmailAccount#Description", "_EmailAccount"."Notes" AS "_EmailAccount#Notes", "_EmailAccount"."Username" AS "_EmailAccount#Username", "_EmailAccount"."Password" AS "_EmailAccount#Password", "_EmailAccount"."SmtpServer" AS "_EmailAccount#SmtpServer", "_EmailAccount"."SmtpPort" AS "_EmailAccount#SmtpPort", "_EmailAccount"."SmtpSsl" AS "_EmailAccount#SmtpSsl", "_EmailAccount"."ImapServer" AS "_EmailAccount#ImapServer", "_EmailAccount"."ImapPort" AS "_EmailAccount#ImapPort", "_EmailAccount"."ImapSsl" AS "_EmailAccount#ImapSsl", "_EmailAccount"."InputFolder" AS "_EmailAccount#InputFolder", "_EmailAccount"."ProcessedFolder" AS "_EmailAccount#ProcessedFolder", "_EmailAccount"."RejectedFolder" AS "_EmailAccount#RejectedFolder", "_EmailAccount"."RejectNotMatching" AS "_EmailAccount#RejectNotMatching", "_EmailAccount"."OutputFolder" AS "_EmailAccount#OutputFolder", "_EmailAccount"."IdClass"::oid AS "__EmailAccount_IdClass", "_EmailAccount"."Id" AS "__EmailAccount_Id", "_EmailAccount"."User" AS "__EmailAccount_User", "_EmailAccount"."BeginDate" AS "__EmailAccount_BeginDate"
FROM "_EmailAccount" AS "_EmailAccount"
WHERE TRUE AND "_EmailAccount"."Status" = ?) AS main
ORDER BY "__EmailAccount_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"Email#EmailStatus"."Description" AS "Email#EmailStatus#Description", "Email#Card"."Description" AS "Email#Card#Description", "Email"."Code" AS "Email#Code", "Email"."Description" AS "Email#Description", "Email"."Notes" AS "Email#Notes", "Email"."Card" AS "Email#Card", "Email"."EmailStatus" AS "Email#EmailStatus", "Email"."FromAddress" AS "Email#FromAddress", "Email"."ToAddresses" AS "Email#ToAddresses", "Email"."CcAddresses" AS "Email#CcAddresses", "Email"."BccAddresses" AS "Email#BccAddresses", "Email"."Subject" AS "Email#Subject", "Email"."Content" AS "Email#Content", "Email"."NotifyWith" AS "Email#NotifyWith", "Email"."NoSubjectPrefix" AS "Email#NoSubjectPrefix", "Email"."Account" AS "Email#Account", "Email"."Template" AS "Email#Template", "Email"."KeepSynchronization" AS "Email#KeepSynchronization", "Email"."PromptSynchronization" AS "Email#PromptSynchronization", "Email"."Delay" AS "Email#Delay", "Email"."IdClass"::oid AS "_Email_IdClass", "Email"."Id" AS "_Email_Id", "Email"."User" AS "_Email_User", "Email"."BeginDate" AS "_Email_BeginDate"
FROM "Email" AS "Email"
LEFT JOIN "LookUp" AS "Email#EmailStatus" ON "Email#EmailStatus"."Id" = "Email"."EmailStatus"
LEFT JOIN "Class" AS "Email#Card" ON "Email#Card"."Id" = "Email"."Card"
WHERE "Email"."Id" = ? AND "Email"."Status" = ?) AS main
ORDER BY "_Email_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3772, A]
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE "AGRUPACION_BBDD"."Id" = ? AND "AGRUPACION_BBDD"."Status" = ?) AS main
ORDER BY "_AGRUPACION_BBDD_Id"
LIMIT ALL
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3581, A]
DEBUG 2016-02-18 13:31:19 [cmdbuild] updating relation attributes for references of card '3581'
DEBUG 2016-02-18 13:31:19 [cmdbuild] unlocking card '3581'
DEBUG 2016-02-18 13:31:19 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:19 [sql ] query: SELECT * FROM (
SELECT
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE "AGRUPACION_BBDD"."Id" = ? AND "AGRUPACION_BBDD"."Status" = ?) AS main
ORDER BY "_AGRUPACION_BBDD_Id"
LIMIT 1
OFFSET 0
DEBUG 2016-02-18 13:31:19 [sql ] params: [3581, A]
DEBUG 2016-02-18 13:31:20 [cmdbuild] request received for '/services/json/management/modcard/getcardposition'
INFO 2016-02-18 13:31:20 [jsonrpc ] Calling url /management/modcard/getcardposition
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "retryWithoutFilter": true
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "cardId": 3581
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "className": AGRUPACION_BBDD
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "sort": []
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "_dc": 1455798680141
INFO 2016-02-18 13:31:20 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2016-02-18 13:31:20 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
DEBUG 2016-02-18 13:31:20 [jsonrpc ] missing element
DEBUG 2016-02-18 13:31:20 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:20 [sql ] query: SELECT * FROM (SELECT * FROM (SELECT *, row_number() OVER (ORDER BY "AGRUPACION_BBDD#Description" ASC, "_AGRUPACION_BBDD_Id") AS _AGRUPACION_BBDD__Row FROM (
SELECT
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE TRUE AND "AGRUPACION_BBDD"."Status" = ?) AS main) AS numbered WHERE "_AGRUPACION_BBDD_Id" = 3581
LIMIT 2147483647
OFFSET 0) AS numbered WHERE "_AGRUPACION_BBDD_Id" = 3581
DEBUG 2016-02-18 13:31:20 [sql ] params: [A]
DEBUG 2016-02-18 13:31:20 [cmdbuild] request received for '/services/json/management/modcard/getcardlist'
INFO 2016-02-18 13:31:20 [jsonrpc ] Calling url /management/modcard/getcardlist
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "start": 0
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "limit": 20
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "className": AGRUPACION_BBDD
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "page": 1
DEBUG 2016-02-18 13:31:20 [jsonrpc ] parameter "_dc": 1455798680598
INFO 2016-02-18 13:31:20 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2016-02-18 13:31:20 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
DEBUG 2016-02-18 13:31:20 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:20 [sql ] query: SELECT *, count(*) over() AS _AGRUPACION_BBDD__RowsCount FROM (
SELECT
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE TRUE AND "AGRUPACION_BBDD"."Status" = ?) AS main
ORDER BY "AGRUPACION_BBDD#Description" ASC, "_AGRUPACION_BBDD_Id"
LIMIT 20
OFFSET 0
DEBUG 2016-02-18 13:31:20 [sql ] params: [A]
DEBUG 2016-02-18 13:31:20 [cmdbuild] getting data for module 'cmdbuild'
DEBUG 2016-02-18 13:31:21 [cmdbuild] request received for '/services/json/management/modcard/getcard'
INFO 2016-02-18 13:31:21 [jsonrpc ] Calling url /management/modcard/getcard
DEBUG 2016-02-18 13:31:21 [jsonrpc ] parameter "cardId": 3581
DEBUG 2016-02-18 13:31:21 [jsonrpc ] parameter "className": AGRUPACION_BBDD
DEBUG 2016-02-18 13:31:21 [jsonrpc ] parameter "_dc": 1455798681060
INFO 2016-02-18 13:31:21 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO 2016-02-18 13:31:21 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
DEBUG 2016-02-18 13:31:21 [sql ] executing query from 'interface org.cmdbuild.dao.query.QuerySpecs'
DEBUG 2016-02-18 13:31:21 [sql ] query: SELECT * FROM (
SELECT
"AGRUPACION_BBDD"."Code" AS "AGRUPACION_BBDD#Code", "AGRUPACION_BBDD"."Description" AS "AGRUPACION_BBDD#Description", "AGRUPACION_BBDD"."Notes" AS "AGRUPACION_BBDD#Notes", "AGRUPACION_BBDD"."ID_ORIGEN" AS "AGRUPACION_BBDD#ID_ORIGEN", "AGRUPACION_BBDD"."id_instancia_agrupBbdd" AS "AGRUPACION_BBDD#id_instancia_agrupBbdd", "AGRUPACION_BBDD"."BD_ID" AS "AGRUPACION_BBDD#BD_ID", "AGRUPACION_BBDD"."Nombre" AS "AGRUPACION_BBDD#Nombre", "AGRUPACION_BBDD"."SID" AS "AGRUPACION_BBDD#SID", "AGRUPACION_BBDD"."Tipo" AS "AGRUPACION_BBDD#Tipo", "AGRUPACION_BBDD"."Version" AS "AGRUPACION_BBDD#Version", "AGRUPACION_BBDD"."IdClass"::oid AS "_AGRUPACION_BBDD_IdClass", "AGRUPACION_BBDD"."Id" AS "_AGRUPACION_BBDD_Id", "AGRUPACION_BBDD"."User" AS "_AGRUPACION_BBDD_User", "AGRUPACION_BBDD"."BeginDate" AS "_AGRUPACION_BBDD_BeginDate"
FROM "AGRUPACION_BBDD" AS "AGRUPACION_BBDD"
WHERE "AGRUPACION_BBDD"."Id" = ? AND "AGRUPACION_BBDD"."Status" = ?) AS main
ORDER BY "_AGRUPACION_BBDD_Id"
LIMIT 1
OFFSET 0
DEBUG 2016-02-18 13:31:21 [sql ] params: [3581, A]
DEBUG 2016-02-18 13:31:21 [cmdbuild] getting data for module 'cmdbuild'