- Fri May 20, 2016 9:14 am
#785474
Hi
when i migrating Version from 2.0.45 to 2.5.2
i am getting bellow Error message when i click home menu to the process maker 2.5.2
Error:
[wrapped: Could not execute query [Native Error: Unknown column 'APP_CACHE_VIEW.DEL_LAST_INDEX' in 'field list'] [User Info: SELECT APP_CACHE_VIEW.APP_UID, APP_CACHE_VIEW.DEL_INDEX, APP_CACHE_VIEW.DEL_LAST_INDEX, APP_CACHE_VIEW.APP_NUMBER, APP_CACHE_VIEW.APP_STATUS, APP_CACHE_VIEW.USR_UID, APP_CACHE_VIEW.PREVIOUS_USR_UID, APP_CACHE_VIEW.TAS_UID, APP_CACHE_VIEW.PRO_UID, APP_CACHE_VIEW.DEL_DELEGATE_DATE, APP_CACHE_VIEW.DEL_INIT_DATE, APP_CACHE_VIEW.DEL_TASK_DUE_DATE, APP_CACHE_VIEW.DEL_FINISH_DATE, APP_CACHE_VIEW.DEL_THREAD_STATUS, APP_CACHE_VIEW.APP_THREAD_STATUS, APP_CACHE_VIEW.APP_TITLE, APP_CACHE_VIEW.APP_PRO_TITLE, APP_CACHE_VIEW.APP_TAS_TITLE, APP_CACHE_VIEW.APP_CURRENT_USER, APP_CACHE_VIEW.APP_DEL_PREVIOUS_USER, APP_CACHE_VIEW.DEL_PRIORITY, APP_CACHE_VIEW.DEL_DURATION, APP_CACHE_VIEW.DEL_QUEUE_DURATION, APP_CACHE_VIEW.DEL_DELAY_DURATION, APP_CACHE_VIEW.DEL_STARTED, APP_CACHE_VIEW.DEL_FINISHED, APP_CACHE_VIEW.DEL_DELAYED, APP_CACHE_VIEW.APP_CREATE_DATE, APP_CACHE_VIEW.APP_FINISH_DATE, APP_CACHE_VIEW.APP_UPDATE_DATE, APP_CACHE_VIEW.APP_OVERDUE_PERCENTAGE, APP_CACHE_VIEW.DEL_INIT_DATE, APP_CACHE_VIEW.TAS_UID, APP_CACHE_VIEW.PRO_UID, CU.USR_UID AS USR_UID, CU.USR_FIRSTNAME AS USR_FIRSTNAME, CU.USR_LASTNAME AS USR_LASTNAME, CU.USR_USERNAME AS USR_USERNAME, APPCVCR.APP_TAS_TITLE AS APPCVCR_APP_TAS_TITLE, USRCR.USR_UID AS USRCR_USR_UID, USRCR.USR_FIRSTNAME AS USRCR_USR_FIRSTNAME, USRCR.USR_LASTNAME AS USRCR_USR_LASTNAME, USRCR.USR_USERNAME AS USRCR_USR_USERNAME, PU.USR_FIRSTNAME AS PREVIOUS_USR_FIRSTNAME, PU.USR_LASTNAME AS PREVIOUS_USR_LASTNAME, PU.USR_USERNAME AS PREVIOUS_USR_USERNAME FROM APP_CACHE_VIEW LEFT JOIN USERS CU ON (APP_CACHE_VIEW.USR_UID=CU.USR_UID) LEFT JOIN USERS PU ON (APP_CACHE_VIEW.PREVIOUS_USR_UID=PU.USR_UID) LEFT JOIN APP_CACHE_VIEW APPCVCR ON (APP_CACHE_VIEW.APP_UID=APPCVCR.APP_UID AND APPCVCR.DEL_LAST_INDEX=1) LEFT JOIN USERS USRCR ON (APPCVCR.USR_UID=USRCR.USR_UID) WHERE APP_CACHE_VIEW.APP_STATUS='TO_DO' AND APP_CACHE_VIEW.USR_UID='00000000000000000000000000000001' AND APP_CACHE_VIEW.DEL_FINISH_DATE IS NULL AND APP_CACHE_VIEW.APP_THREAD_STATUS='OPEN' AND APP_CACHE_VIEW.DEL_THREAD_STATUS='OPEN' ORDER BY APP_CACHE_VIEW.APP_NUMBER DESC LIMIT 25]]
please let me the procedure.
Thanks in advance
Tamizhina venthan.E