Buongiorno sto provando ad utilizzare la funzionalità di aggiornamento massivo schede. Da applicazione ricevo il messaggio "Impossibile recuperare le card", ho alzato il livello di log recuperando quando segue dal cmdbuild.log
DEBUG 2012-06-12 14:42:08 [sql ] SELECT DISTINCT "Hardware"."User" AS "Hardware_User", "Hardware"."Description" AS "Hardware_Description", "Hardware"."BeginDate" AS "Hardware_BeginDate", "LookUp_StrutturaRegionale"."Id" AS "Hardware_StrutturaRegionale", "LookUp_StrutturaRegionale"."Description" AS "Hardware_StrutturaRegionale_Description", "Hardware"."Etichetta" AS "Hardware_Etichetta", "ODA_ODA"."Id" AS "Hardware_ODA", "ODA_ODA"."Description" AS "Hardware_ODA_Description", "Hardware"."Code" AS "Hardware_Code", "Hardware"."Floor" AS "Hardware_Floor", "Hardware"."Notes" AS "Hardware_Notes", "Hardware"."SerialNumber" AS "Hardware_SerialNumber", "Hardware"."Status" AS "Hardware_Status", "LookUp_Modello"."Id" AS "Hardware_Modello", "LookUp_Modello"."Description" AS "Hardware_Modello_Description", "Componenti_Componente"."Id" AS "Hardware_Componente", "Componenti_Componente"."Description" AS "Hardware_Componente_Description", "Hardware"."InizioGaranzia" AS "Hardware_InizioGaranzia", "Hardware"."Id" AS "Hardware_Id", "LookUp_Comune"."Id" AS "Hardware_Comune", "LookUp_Comune"."Description" AS "Hardware_Comune_Description", "Hardware"."FineGaranzia" AS "Hardware_FineGaranzia", "Hardware"."Indirizzo" AS "Hardware_Indirizzo", "Hardware".tableoid::int4 AS "Hardware_IdClass", "Fornitori_Fornitore"."Id" AS "Hardware_Fornitore", "Fornitori_Fornitore"."Description" AS "Hardware_Fornitore_Description", (SELECT COUNT(*) FROM (SELECT DISTINCT "Hardware"."Id" FROM "Hardware" AS "Hardware" LEFT JOIN "LookUp" AS "LookUp_StrutturaRegionale" ON "LookUp_StrutturaRegionale"."Id" = "Hardware"."StrutturaRegionale" LEFT JOIN "ODA" AS "ODA_ODA" ON "ODA_ODA"."Id" = "Hardware"."ODA" LEFT JOIN "LookUp" AS "LookUp_Modello" ON "LookUp_Modello"."Id" = "Hardware"."Modello" LEFT JOIN "Componenti" AS "Componenti_Componente" ON "Componenti_Componente"."Id" = "Hardware"."Componente" LEFT JOIN "LookUp" AS "LookUp_Comune" ON "LookUp_Comune"."Id" = "Hardware"."Comune" LEFT JOIN "Fornitori" AS "Fornitori_Fornitore" ON "Fornitori_Fornitore"."Id" = "Hardware"."Fornitore" WHERE (((("Hardware"."Floor" ILIKE 'Viale Regione Siciliana, 2771, 90100, Palermo (PA)')) AND ("Hardware".tableoid::int4, "Hardware"."Id") IN ()) AND ("Hardware"."Status" = 'A'))) AS countid) AS "Count" FROM "Hardware" AS "Hardware" LEFT JOIN "LookUp" AS "LookUp_StrutturaRegionale" ON "LookUp_StrutturaRegionale"."Id" = "Hardware"."StrutturaRegionale" LEFT JOIN "ODA" AS "ODA_ODA" ON "ODA_ODA"."Id" = "Hardware"."ODA" LEFT JOIN "LookUp" AS "LookUp_Modello" ON "LookUp_Modello"."Id" = "Hardware"."Modello" LEFT JOIN "Componenti" AS "Componenti_Componente" ON "Componenti_Componente"."Id" = "Hardware"."Componente" LEFT JOIN "LookUp" AS "LookUp_Comune" ON "LookUp_Comune"."Id" = "Hardware"."Comune" LEFT JOIN "Fornitori" AS "Fornitori_Fornitore" ON "Fornitori_Fornitore"."Id" = "Hardware"."Fornitore" WHERE (((("Hardware"."Floor" ILIKE 'Viale Regione Siciliana, 2771, 90100, Palermo (PA)')) AND ("Hardware".tableoid::int4, "Hardware"."Id") IN ()) AND ("Hardware"."Status" = 'A')) ORDER BY "Hardware"."Id" ASC
ERROR 2012-06-12 14:42:08 [persist ] Errors finding cards
org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
...
Da cosa può dipendere il fatto che la ("Hardware".tableoid::int4, "Hardware"."Id") IN ()) non viene riempita?
Se occorre posso inviare ulteriori dettagli allegando una traccia log più estesa
Grazie
Alessandro