DataBase error - Out of resources when opening file './bbmp/tblbbmpworkcode.MYD' (Errcode: 24 - Too many open files)
select tbladdproject.workcodeid,tbladdproject.projectid, tbladdproject.workcode,tbladdproject.projectname,wardid,localityid, tbladdproject.expenditureincurred, tbladdproject.approvedcost,actualdateofcompletion,completiondtpercontract from tblbbmpworkcode left join tbladdproject on tbladdproject.workcodeid = tblbbmpworkcode.workcodeid where wardid='133'DataBase error - Out of resources when opening file './bbmp/tblbbmpworkcode.MYD' (Errcode: 24 - Too many open files)
select count(*) from tblbbmpworkcode where wardid='133'DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count1 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and workstatus='work in progress' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count2 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and workstatus='completed' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count3 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and workstatus='yet to start' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count4 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and workstatus='file in process' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count5 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and tbladdproject.workcode=' ' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count6 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and tbladdproject.workstatus=' ' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select sum(estimatedcost) as sum1 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select sum(approvedcost) as sum2 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select sum(expenditureincurred) as sum3 from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and(expenditureincurred !=0) and (approvedcost != 0) and (expenditureincurred > approvedcost) DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) from tbladdproject left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid where wardid='133' and (expenditureincurred < approvedcost) and (expenditureincurred !=0) and(approvedcost != 0) DataBase error - Out of resources when opening file './bbmp/tblward.TRG' (Errcode: 24 - Too many open files)
select wardno from tblward where wardid='133'DataBase error - Out of resources when opening file './bbmp/tblward.TRG' (Errcode: 24 - Too many open files)
select wardname from tblward where wardid='133' Bruhat Bengaluru Mahanagara Palika

Citizen User Manual GPMS Online Help Desk Guest Login BBMP User Login
                         Ward (Wardno:) Project Details                                                                  Total Projects :
SL No. Workcode View / Comments Project Name
Project Status of Ward
Completed Projects: Work In Progress Projects: Yet to Start Projects:
File in Process Projects: Projects without Workcode: Projects without Work Status:
Total of Estimated Cost: Total of Approved Cost: Total of Expenditure Incurred:
Cost Overrun Projects: Cost Savings Projects: Time Overrun Projects:0
Copyright ICST 2014 Supported by Indian Centre for Social Transformation