Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[RESUELTO] problemas con el modulo Reports
#11
Hola Joe,
He hecho lo que me indicas y esto es lo que ocurre:

La query sql que da el error es esta:

select DISTINCT case when(vtiger_usersCalendar.last_name NOT LIKE '' and vtiger_crmentity.crmid!='' ) THEN CONCAT(vtiger_usersCalendar.first_name,' ',vtiger_usersCalendar.last_name) else vtiger_groupsCalendar.groupname end as 'Calendar_Assigned_To', vtiger_leadscf.cf_866 AS 'Leads_Nombre_de_la_Empresa', vtiger_leaddetails.firstname AS 'Leads_First_Name', vtiger_leaddetails.lastname AS 'Leads_Last_Name', vtiger_leadscf.cf_868 AS 'Leads_Fecha_Ultimo_Contacto', vtiger_leadaddress.state AS 'Leads_State', vtiger_contactscf.cf_865 AS 'Contacts_Nombre_de_la_Empresa', vtiger_contactdetails.firstname AS 'Contacts_First_Name', vtiger_contactdetails.lastname AS 'Contacts_Last_Name', vtiger_contactscf.cf_867 AS 'Contacts_Fecha_Ultimo_Contacto', vtiger_contactaddress.otherstate AS 'Contacts_Other_State', vtiger_crmentity.description AS 'Calendar_Description', vtiger_crmentity.crmid AS "LBL_ACTION" from vtiger_activity inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_activity.activityid left join vtiger_activitycf on vtiger_activitycf.activityid = vtiger_crmentity.crmid left join vtiger_cntactivityrel on vtiger_cntactivityrel.activityid= vtiger_activity.activityid left join vtiger_contactdetails as vtiger_contactdetailsCalendar on vtiger_contactdetailsCalendar.contactid= vtiger_cntactivityrel.contactid left join vtiger_groups as vtiger_groupsCalendar on vtiger_groupsCalendar.groupid = vtiger_crmentity.smownerid left join vtiger_users as vtiger_usersCalendar on vtiger_usersCalendar.id = vtiger_crmentity.smownerid left join vtiger_groups on vtiger_groups.groupid = vtiger_crmentity.smownerid left join vtiger_users on vtiger_users.id = vtiger_crmentity.smownerid left join vtiger_seactivityrel on vtiger_seactivityrel.activityid = vtiger_activity.activityid left join vtiger_activity_reminder on vtiger_activity_reminder.activity_id = vtiger_activity.activityid left join vtiger_recurringevents on vtiger_recurringevents.activityid = vtiger_activity.activityid left join vtiger_crmentity as vtiger_crmentityRelCalendar on vtiger_crmentityRelCalendar.crmid = vtiger_seactivityrel.crmid left join vtiger_account as vtiger_accountRelCalendar on vtiger_accountRelCalendar.accountid=vtiger_crmentityRelCalendar.crmid left join vtiger_leaddetails as vtiger_leaddetailsRelCalendar on vtiger_leaddetailsRelCalendar.leadid = vtiger_crmentityRelCalendar.crmid left join vtiger_potential as vtiger_potentialRelCalendar on vtiger_potentialRelCalendar.potentialid = vtiger_crmentityRelCalendar.crmid left join vtiger_quotes as vtiger_quotesRelCalendar on vtiger_quotesRelCalendar.quoteid = vtiger_crmentityRelCalendar.crmid left join vtiger_purchaseorder as vtiger_purchaseorderRelCalendar on vtiger_purchaseorderRelCalendar.purchaseorderid = vtiger_crmentityRelCalendar.crmid left join vtiger_invoice as vtiger_invoiceRelCalendar on vtiger_invoiceRelCalendar.invoiceid = vtiger_crmentityRelCalendar.crmid left join vtiger_salesorder as vtiger_salesorderRelCalendar on vtiger_salesorderRelCalendar.salesorderid = vtiger_crmentityRelCalendar.crmid left join vtiger_troubletickets as vtiger_troubleticketsRelCalendar on vtiger_troubleticketsRelCalendar.ticketid = vtiger_crmentityRelCalendar.crmid left join vtiger_campaign as vtiger_campaignRelCalendar on vtiger_campaignRelCalendar.campaignid = vtiger_crmentityRelCalendar.crmid left join vtiger_vendor as vtiger_vendorRelCalendar on vtiger_vendorRelCalendar.vendorid = vtiger_crmentityRelCalendar.crmid left join vtiger_users as vtiger_lastModifiedByCalendar on vtiger_lastModifiedByCalendar.id = vtiger_crmentity.modifiedby left join vtiger_cntactivityrel as vtiger_cntactivityreltmpContacts ON (vtiger_activity.activityid=vtiger_cntactivityreltmpContacts.activityid) left join (select vtiger_contactdetails.* from vtiger_contactdetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_contactdetails.contactid and vtiger_crmentity.deleted=0) as vtiger_contactdetails on vtiger_contactdetails.contactid=vtiger_cntactivityreltmpContacts.contactid left join vtiger_crmentity as vtiger_crmentityContacts on vtiger_crmentityContacts.crmid = vtiger_contactdetails.contactid and vtiger_crmentityContacts.deleted=0 left join vtiger_contactdetails as vtiger_contactdetailsContacts on vtiger_contactdetailsContacts.contactid = vtiger_contactdetails.reportsto left join vtiger_contactaddress on vtiger_contactdetails.contactid = vtiger_contactaddress.contactaddressid left join vtiger_customerdetails on vtiger_customerdetails.customerid = vtiger_contactdetails.contactid left join vtiger_contactsubdetails on vtiger_contactdetails.contactid = vtiger_contactsubdetails.contactsubscriptionid left join vtiger_account as vtiger_accountContacts on vtiger_accountContacts.accountid = vtiger_contactdetails.accountid left join vtiger_contactscf on vtiger_contactdetails.contactid = vtiger_contactscf.contactid left join vtiger_groups as vtiger_groupsContacts on vtiger_groupsContacts.groupid = vtiger_crmentityContacts.smownerid left join vtiger_users as vtiger_usersContacts on vtiger_usersContacts.id = vtiger_crmentityContacts.smownerid left join vtiger_users as vtiger_lastModifiedByContacts on vtiger_lastModifiedByContacts.id = vtiger_crmentityContacts.modifiedby INNER JOIN vt_tmp_u96_t4 vt_tmp_u96_t4Contacts ON vt_tmp_u96_t4Contacts.id = vtiger_crmentityContacts.smownerid left join vtiger_seactivityrel as vtiger_seactivityreltmpLeads ON (vtiger_activity.activityid=vtiger_seactivityreltmpLeads.activityid) left join (select vtiger_leaddetails.* from vtiger_leaddetails inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_leaddetails.leadid and vtiger_crmentity.deleted=0) as vtiger_leaddetails on vtiger_leaddetails.leadid=vtiger_seactivityreltmpLeads.crmid AND vtiger_leaddetails.converted = 0 left join vtiger_crmentity as vtiger_crmentityLeads on vtiger_crmentityLeads.crmid = vtiger_leaddetails.leadid and vtiger_crmentityLeads.deleted=0 left join vtiger_leadaddress on vtiger_leaddetails.leadid = vtiger_leadaddress.leadaddressid left join vtiger_leadsubdetails on vtiger_leadsubdetails.leadsubscriptionid = vtiger_leaddetails.leadid left join vtiger_leadscf on vtiger_leadscf.leadid = vtiger_leaddetails.leadid left join vtiger_groups as vtiger_groupsLeads on vtiger_groupsLeads.groupid = vtiger_crmentityLeads.smownerid left join vtiger_users as vtiger_usersLeads on vtiger_usersLeads.id = vtiger_crmentityLeads.smownerid left join vtiger_users as vtiger_lastModifiedByLeads on vtiger_lastModifiedByLeads.id = vtiger_crmentityLeads.modifiedby INNER JOIN vt_tmp_u96_t7 vt_tmp_u96_t7Leads ON vt_tmp_u96_t7Leads.id = vtiger_crmentityLeads.smownerid INNER JOIN vt_tmp_u96_t9 vt_tmp_u96_t9 ON (vt_tmp_u96_t9.id = vtiger_crmentity.smownerid and vt_tmp_u96_t9.shared=0) WHERE vtiger_activity.activityid > 0  AND vtiger_crmentity.deleted=0 and (vtiger_activity.activitytype != 'Emails') and (( trim(case when (vtiger_usersCalendar.last_name NOT LIKE '') then CONCAT(vtiger_usersCalendar.first_name,' ',vtiger_usersCalendar.last_name) else vtiger_groupsCalendar.groupname end) like '%MANOLIN%' and vtiger_activity.date_start > '2016-03-28 11:34:00' ) ) order by Leads_Nombre_de_la_Empresa ASC

Y esta es la respuesta:

'cbcrm_XYXYXYXYXYX.vt_tmp_u96_t4' doesn't exist


y esto es lo que reponde despues cuando se queda colgado:

INFO  VT PearDatabase ->ADODB disconnect


Me puedes decir que debo hacer? Gracias.
Reply
#12
No puedes ejecutar esas consultas directamente se tienen que ejecutar dentro de la aplicación ya que la tabla temporal se crea dinámicamente según el usuario.

¿No te da error en el log?
Joe
TSolucio
Reply
#13
(04-08-2016, 01:30 PM)joebordes Wrote: No puedes ejecutar esas consultas directamente se tienen que ejecutar dentro de la aplicación ya que la tabla temporal se crea dinámicamente según el usuario.

¿No te da error en el log?

Hola Joe,
Huh  Pues entonces no lo estaba haciendo en el sitio correcto.
Estaba habilitando la depuración en servidor no en la aplicación.
Cómo la habilito en la aplicación?
Saludos.
Reply
#14
http://corebos.org/documentation/doku.php?id=en:devel:debuging
Joe
TSolucio
Reply
#15
(04-11-2016, 02:04 PM)joebordes Wrote: http://corebos.org/documentation/doku.php?id=en:devel:debuging

Gracias Joe.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)