{"action":"created","issue":{"url":"https://api.github.com/repos/xmassoft/rolsac/issues/424","repository_url":"https://api.github.com/repos/xmassoft/rolsac","labels_url":"https://api.github.com/repos/xmassoft/rolsac/issues/424/labels{/name}","comments_url":"https://api.github.com/repos/xmassoft/rolsac/issues/424/comments","events_url":"https://api.github.com/repos/xmassoft/rolsac/issues/424/events","html_url":"https://github.com/xmassoft/rolsac/issues/424","id":137893045,"number":424,"title":"Error pantalla UA - Relació Fitxa-Secció-UA","user":{"login":"xmassoft","id":8349093,"avatar_url":"https://avatars.githubusercontent.com/u/8349093?v=3","gravatar_id":"","url":"https://api.github.com/users/xmassoft","html_url":"https://github.com/xmassoft","followers_url":"https://api.github.com/users/xmassoft/followers","following_url":"https://api.github.com/users/xmassoft/following{/other_user}","gists_url":"https://api.github.com/users/xmassoft/gists{/gist_id}","starred_url":"https://api.github.com/users/xmassoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xmassoft/subscriptions","organizations_url":"https://api.github.com/users/xmassoft/orgs","repos_url":"https://api.github.com/users/xmassoft/repos","events_url":"https://api.github.com/users/xmassoft/events{/privacy}","received_events_url":"https://api.github.com/users/xmassoft/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/xmassoft/rolsac/milestones/3","html_url":"https://github.com/xmassoft/rolsac/milestones/1.2","labels_url":"https://api.github.com/repos/xmassoft/rolsac/milestones/3/labels","id":1611584,"number":3,"title":"1.2","description":"","creator":{"login":"xmassoft","id":8349093,"avatar_url":"https://avatars.githubusercontent.com/u/8349093?v=3","gravatar_id":"","url":"https://api.github.com/users/xmassoft","html_url":"https://github.com/xmassoft","followers_url":"https://api.github.com/users/xmassoft/followers","following_url":"https://api.github.com/users/xmassoft/following{/other_user}","gists_url":"https://api.github.com/users/xmassoft/gists{/gist_id}","starred_url":"https://api.github.com/users/xmassoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xmassoft/subscriptions","organizations_url":"https://api.github.com/users/xmassoft/orgs","repos_url":"https://api.github.com/users/xmassoft/repos","events_url":"https://api.github.com/users/xmassoft/events{/privacy}","received_events_url":"https://api.github.com/users/xmassoft/received_events","type":"User","site_admin":false},"open_issues":14,"closed_issues":129,"state":"open","created_at":"2016-02-29T11:52:11Z","updated_at":"2016-03-02T14:49:06Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-03-02T14:49:06Z","updated_at":"2016-03-02T14:49:18Z","closed_at":null,"body":"Numero: 518\nCreació: 2013-10-31 10:39:59.000\n*Originally created by:* sgelabert\n\n*Originally owned by:* tcerda\n\nDóna error quan s'intenta eliminar la DARRERA fitxa d'una secció\\. L'error està en la construcció de la consulta:\r\n\r\nwhere \\(ficharesum0\\_\\.FUA\\_CODUNA=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODSEC=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODFIC=ficharesum1\\_\\.FIC\\_CODI \\)AND\\(ficharesum0\\_\\.FUA\\_CODI NOT IN\\(\\)\\)\r\n\r\nAdjunt log:\r\n\r\n11:27:00,302 DEBUG \\[QueryTranslator\\] HQL:&nbps; SELECT ficha, fichaUA&nbps; FROM org\\.ibit\\.rol\\.sac\\.model\\.FichaResumenUA AS fichaUA, org\\.ibit\\.rol\\.sac\\.model\\.FichaResumen AS ficha&nbps; WHERE fichaUA\\.idUa = :idUA&nbps; AND fichaUA\\.idSeccio = :idSeccion&nbps; AND fichaUA\\.ficha\\.id = ficha\\.id&nbps; AND fichaUA\\.id NOT IN \\(\\) \r\n11:27:00,302 DEBUG \\[QueryTranslator\\] SQL: select ficharesum1\\_\\.FIC\\_CODI as FIC\\_CODI0\\_, ficharesum0\\_\\.FUA\\_CODI as FUA\\_CODI1\\_, ficharesum1\\_\\.FIC\\_FECPUB as FIC\\_FECPUB0\\_, ficharesum1\\_\\.FIC\\_FECCAD as FIC\\_FECCAD0\\_, ficharesum1\\_\\.FIC\\_FECACT as FIC\\_FECACT0\\_, ficharesum1\\_\\.FIC\\_ICONO as FIC\\_ICONO0\\_, ficharesum1\\_\\.FIC\\_IMAGEN as FIC\\_IMAGEN0\\_, ficharesum1\\_\\.FIC\\_BANER as FIC\\_BANER0\\_, ficharesum1\\_\\.FIC\\_VALIDA as FIC\\_VALIDA0\\_, ficharesum1\\_\\.FIC\\_INFO as FIC\\_INFO0\\_, ficharesum1\\_\\.FIC\\_RESPON as FIC\\_RESPON0\\_, ficharesum1\\_\\.FIC\\_URLVID as FIC\\_URLVID0\\_, ficharesum1\\_\\.FIC\\_URLFOR as FIC\\_URLFOR0\\_, ficharesum1\\_\\.FIC\\_FORTEM as FIC\\_FORTEM0\\_, ficharesum0\\_\\.FUA\\_CODFIC as FUA\\_CODFIC1\\_, ficharesum0\\_\\.FUA\\_CODUNA as FUA\\_CODUNA1\\_, ficharesum0\\_\\.FUA\\_CODSEC as FUA\\_CODSEC1\\_, ficharesum0\\_\\.FUA\\_ORDEN as FUA\\_ORDEN1\\_, ficharesum0\\_\\.FUA\\_ORDSEC as FUA\\_ORDSEC1\\_ from RSC\\_FICHUA ficharesum0\\_, RSC\\_FICHA ficharesum1\\_ where \\(ficharesum0\\_\\.FUA\\_CODUNA=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODSEC=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODFIC=ficharesum1\\_\\.FIC\\_CODI \\)AND\\(ficharesum0\\_\\.FUA\\_CODI NOT IN\\(\\)\\)\r\n11:27:00,302 DEBUG \\[SQL\\] select ficharesum1\\_\\.FIC\\_CODI as FIC\\_CODI0\\_, ficharesum0\\_\\.FUA\\_CODI as FUA\\_CODI1\\_, ficharesum1\\_\\.FIC\\_FECPUB as FIC\\_FECPUB0\\_, ficharesum1\\_\\.FIC\\_FECCAD as FIC\\_FECCAD0\\_, ficharesum1\\_\\.FIC\\_FECACT as FIC\\_FECACT0\\_, ficharesum1\\_\\.FIC\\_ICONO as FIC\\_ICONO0\\_, ficharesum1\\_\\.FIC\\_IMAGEN as FIC\\_IMAGEN0\\_, ficharesum1\\_\\.FIC\\_BANER as FIC\\_BANER0\\_, ficharesum1\\_\\.FIC\\_VALIDA as FIC\\_VALIDA0\\_, ficharesum1\\_\\.FIC\\_INFO as FIC\\_INFO0\\_, ficharesum1\\_\\.FIC\\_RESPON as FIC\\_RESPON0\\_, ficharesum1\\_\\.FIC\\_URLVID as FIC\\_URLVID0\\_, ficharesum1\\_\\.FIC\\_URLFOR as FIC\\_URLFOR0\\_, ficharesum1\\_\\.FIC\\_FORTEM as FIC\\_FORTEM0\\_, ficharesum0\\_\\.FUA\\_CODFIC as FUA\\_CODFIC1\\_, ficharesum0\\_\\.FUA\\_CODUNA as FUA\\_CODUNA1\\_, ficharesum0\\_\\.FUA\\_CODSEC as FUA\\_CODSEC1\\_, ficharesum0\\_\\.FUA\\_ORDEN as FUA\\_ORDEN1\\_, ficharesum0\\_\\.FUA\\_ORDSEC as FUA\\_ORDSEC1\\_ from RSC\\_FICHUA ficharesum0\\_, RSC\\_FICHA ficharesum1\\_ where \\(ficharesum0\\_\\.FUA\\_CODUNA=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODSEC=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODFIC=ficharesum1\\_\\.FIC\\_CODI \\)AND\\(ficharesum0\\_\\.FUA\\_CODI NOT IN\\(\\)\\)\r\n11:27:00,302 INFO&nbps; \\[STDOUT\\] Hibernate: select ficharesum1\\_\\.FIC\\_CODI as FIC\\_CODI0\\_, ficharesum0\\_\\.FUA\\_CODI as FUA\\_CODI1\\_, ficharesum1\\_\\.FIC\\_FECPUB as FIC\\_FECPUB0\\_, ficharesum1\\_\\.FIC\\_FECCAD as FIC\\_FECCAD0\\_, ficharesum1\\_\\.FIC\\_FECACT as FIC\\_FECACT0\\_, ficharesum1\\_\\.FIC\\_ICONO as FIC\\_ICONO0\\_, ficharesum1\\_\\.FIC\\_IMAGEN as FIC\\_IMAGEN0\\_, ficharesum1\\_\\.FIC\\_BANER as FIC\\_BANER0\\_, ficharesum1\\_\\.FIC\\_VALIDA as FIC\\_VALIDA0\\_, ficharesum1\\_\\.FIC\\_INFO as FIC\\_INFO0\\_, ficharesum1\\_\\.FIC\\_RESPON as FIC\\_RESPON0\\_, ficharesum1\\_\\.FIC\\_URLVID as FIC\\_URLVID0\\_, ficharesum1\\_\\.FIC\\_URLFOR as FIC\\_URLFOR0\\_, ficharesum1\\_\\.FIC\\_FORTEM as FIC\\_FORTEM0\\_, ficharesum0\\_\\.FUA\\_CODFIC as FUA\\_CODFIC1\\_, ficharesum0\\_\\.FUA\\_CODUNA as FUA\\_CODUNA1\\_, ficharesum0\\_\\.FUA\\_CODSEC as FUA\\_CODSEC1\\_, ficharesum0\\_\\.FUA\\_ORDEN as FUA\\_ORDEN1\\_, ficharesum0\\_\\.FUA\\_ORDSEC as FUA\\_ORDSEC1\\_ from RSC\\_FICHUA ficharesum0\\_, RSC\\_FICHA ficharesum1\\_ where \\(ficharesum0\\_\\.FUA\\_CODUNA=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODSEC=? \\)AND\\(ficharesum0\\_\\.FUA\\_CODFIC=ficharesum1\\_\\.FIC\\_CODI \\)AND\\(ficharesum0\\_\\.FUA\\_CODI NOT IN\\(\\)\\)\r\n11:27:00,333 DEBUG \\[JDBCExceptionReporter\\] SQL Exception\r\njava\\.sql\\.SQLException: ORA\\-00936: falta una expresi?n\r\n\r\n\r\nPer altra banda tampoc funciona l'eliminació de seccions \\(En aquest cas hauria d'eliminar la relació de Fitxa\\-Secció\\-UA i no ho fa\\."},"comment":{"url":"https://api.github.com/repos/xmassoft/rolsac/issues/comments/191267580","html_url":"https://github.com/xmassoft/rolsac/issues/424#issuecomment-191267580","issue_url":"https://api.github.com/repos/xmassoft/rolsac/issues/424","id":191267580,"user":{"login":"xmassoft","id":8349093,"avatar_url":"https://avatars.githubusercontent.com/u/8349093?v=3","gravatar_id":"","url":"https://api.github.com/users/xmassoft","html_url":"https://github.com/xmassoft","followers_url":"https://api.github.com/users/xmassoft/followers","following_url":"https://api.github.com/users/xmassoft/following{/other_user}","gists_url":"https://api.github.com/users/xmassoft/gists{/gist_id}","starred_url":"https://api.github.com/users/xmassoft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xmassoft/subscriptions","organizations_url":"https://api.github.com/users/xmassoft/orgs","repos_url":"https://api.github.com/users/xmassoft/repos","events_url":"https://api.github.com/users/xmassoft/events{/privacy}","received_events_url":"https://api.github.com/users/xmassoft/received_events","type":"User","site_admin":false},"created_at":"2016-03-02T14:49:18Z","updated_at":"2016-03-02T14:49:18Z","body":"*anonymous\n2013-10-31 11:42:13\n*Originally by:* sgelabert\n\nSi després de l'eliminació no queden fitxes dins la secció, la secció no hauria d'apareixer dins el mòdul Fitxa\\-Secció\\-UA\\.\r\n\r\nPer altra banda el botó \"Gestiona seccions\" hauria de desapareixer del mòdul Fitxa\\-Secció\\-UA\\. Ja que potencialment pot deixar fitxes orfes i per tant no accessibles\\."}}