<html><head></head><body>Sat Nov 26 08:49:57 2016,359 [29853] INFO VT - PearDatabase ->ADODB error <br>
Query Failed:ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX<br>
(assetsid)::->[1072]Key column 'assetsid' doesn't exist in table<br>
<br>
It's all in your error log, give it a read again and then you will notice that your table is missing indexes, something went obviously wrong when you moved the database to a new server. Those table names look like temporary tables (urgh). Anyway you could try Google the error and look for a fix or you just recreate all the reports ;) <br><br><div class="gmail_quote">On November 26, 2016 4:48:06 PM GMT+08:00, kiran <kiranraju.jakka@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail">Hi,<br /><br />I'm using reports from 2 years i didn't get any problem, recently i moved to<br />another server. Now reports are keep hanging and says below error in logs. I<br />just tailed the logs to know what is happening.. i came to know that:::<br /><br />Sat Nov 26 08:49:57 2016,359 [29853] INFO VT - PearDatabase ->ADODB error <br />Query Failed:ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX<br />(assetsid)::->[1072]Key column 'assetsid' doesn't exist in table<br />Sat Nov 26 08:49:57 2016,359 [29853] DEBUG VT - Prepared sql query being<br />executed : ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX<br />(crmid)<br />Sat Nov 26 08:49:57 2016,359 [29853] INFO VT - PearDatabase ->ADODB error <br />Query Failed:ALTER TABLE vtiger_reptmptbl_158394cb546ddb0829531730 ADD INDEX<br />(crmid)::->[1072]Key column 'crmid' doesn't exist in table<br />Sat Nov 26 08:49:57 2016,359 [29853] DEBUG VT - Prepared sql query
being<br />executed : select DISTINCT vtiger_assetscf.cf_1330 AS 'Assets_Site_Name',<br />vtiger_assetscf.cf_1332 AS 'Assets_Site_Address',<br />vtiger_servicecontracts.contract_status AS 'ServiceContracts_Status',<br />vtiger_crmentity.crmid AS "Assets_LBL_ACTION" from vtiger_assets inner join<br />vtiger_crmentity on vtiger_crmentity.crmid=vtiger_assets.assetsid inner join<br />vtiger_assetscf as vtiger_assetscf on<br />vtiger_assetscf.assetsid=vtiger_assets.assetsid left join vtiger_groups on<br />vtiger_groups.groupid = vtiger_crmentity.smownerid left join vtiger_users on<br />vtiger_<a href="http://users.id">users.id</a> = vtiger_crmentity.smownerid left join vtiger_crmentityrel<br />as vtiger_crmentityreltmpServiceContracts ON<br />(vtiger_assets.assetsid=vtiger_crmentityreltmpServiceContracts.relcrmid OR<br />vtiger_assets.assetsid=vtiger_crmentityreltmpServiceContracts.crmid) left<br />join vtiger_reptmptbl_158394cb546ddb0829531730 as vtiger_servicecontracts on<br
/>(vtiger_servicecontracts.servicecontractsid=vtiger_crmentityreltmpServiceContracts.relcrmid<br />OR<br />vtiger_servicecontracts.servicecontractsid=vtiger_crmentityreltmpServiceContracts.crmid)<br />left join vtiger_crmentity as vtiger_crmentityServiceContracts on<br />vtiger_crmentityServiceContracts.crmid =<br />vtiger_servicecontracts.servicecontractsid and<br />vtiger_crmentityServiceContracts.deleted=0 WHERE vtiger_assets.assetsid > 0 <br />AND vtiger_crmentity.deleted=0 order by `ServiceContracts_Status` ASC LIMIT<br />0, 1000<br /><br />This would be the error i have identified in logs.<br /><br />Can anybody help me to get rid of it?<br /><br /><br />Thanks & Regards,<br /><br /><br /><br /><br />--<br />View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/VtigerCRM-Developers-Reports-keep-getting-hanging-tp20175.html">http://vtiger-crm.2324883.n4.nabble.com/VtigerCRM-Developers-Reports-keep-getting-hanging-tp20175.html</a><br />Sent from
the vtigercrm-developers mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br /><hr /><br /><a href="http://www.vtiger.com">http://www.vtiger.com</a>/<br /></pre></blockquote></div><br>
-- <br>
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.</body></html>