[impulsecsd]

Hi. I came across The row '4529418945ba4d49e6b0279000818478' in table TASK doesn't exist!
error. I didn't touch ANYTHING at all but out of nowhere it appeared after the second activity, 'Evaluate Request'. What shall I do?

Thanks

[hekmati]

please send your whole diagram image, your triggers and steps to more clarify your question.

[amosbatto]

Can you export the process and post your .pmx file for the process? In which task did the error occur?

Open phpMyAdmin and go to the database used by workspace (which by default is named "wf_workflow". Then execute this query in your database:
SELECT * FROM APP_CACHE_VIEW WHERE APP_NUMBER=125;
Post your results here.

It is really hard to try and debug it without this info.

[impulsecsd]

Can you export the process and post your .pmx file for the process? In which task did the error occur?

Open phpMyAdmin and go to the database used by workspace (which by default is named "wf_workflow". Then execute this query in your database:
SELECT * FROM APP_CACHE_VIEW WHERE APP_NUMBER=125;
Post your results here.

It is really hard to try and debug it without this info.

It was occurred in 'Evaluate Request' task.

Here's the result for

Code: Select all

SELECT * FROM APP_CACHE_VIEW WHERE APP_NUMBER=125;

Code: Select all

localhost/bitnami_pm/APP_CACHE_VIEW/		http://127.0.0.1/phpmyadmin/db_structure.php?server=1&db=bitnami_pm
 Showing rows 0 -  1 (2 total, Query took 0.0007 seconds.)

SELECT * FROM APP_CACHE_VIEW WHERE APP_NUMBER=125


APP_UID	DEL_INDEX	DEL_LAST_INDEX	APP_NUMBER	APP_STATUS	USR_UID	PREVIOUS_USR_UID	TAS_UID	PRO_UID	DEL_DELEGATE_DATE	DEL_INIT_DATE	DEL_FINISH_DATE	DEL_TASK_DUE_DATE	DEL_RISK_DATE	DEL_THREAD_STATUS	APP_THREAD_STATUS	APP_TITLE	APP_PRO_TITLE	APP_TAS_TITLE	APP_CURRENT_USER	APP_DEL_PREVIOUS_USER	DEL_PRIORITY	DEL_DURATION	DEL_QUEUE_DURATION	DEL_DELAY_DURATION	DEL_STARTED	DEL_FINISHED	DEL_DELAYED	APP_CREATE_DATE	APP_FINISH_DATE	APP_UPDATE_DATE	APP_OVERDUE_PERCENTAGE	
7126464845c23b5825a6f78070926894	1	0	125	TO_DO	00000000000000000000000000000001		1841735835ba0f73c752115070351030	8134765625b9f87a0652ac6062473440	2018-12-26 17:08:18	2018-12-26 17:08:18	2018-12-26 17:09:09	2018-12-27 17:00:00	2018-12-27 15:24:00	CLOSED	OPEN	#125	Purchase Request	Fill Purchase Request	admin Administrator		3	0	0	0	0	0	0	2018-12-26 17:08:18	
    NULL
	2018-12-26 18:02:29	0	
7126464845c23b5825a6f78070926894	2	1	125	TO_DO	00000000000000000000000000000001	00000000000000000000000000000001	2026062015ba0f764945e03028210352	8134765625b9f87a0652ac6062473440	2018-12-26 17:09:09	2018-12-26 17:09:16	
    NULL
	2018-12-27 17:00:00	2018-12-27 15:24:00	OPEN	OPEN	#125	Purchase Request	Evaluate Request	admin Administrator	admin Administrator	3	0	0	0	0	0	0	2018-12-26 17:08:18	
    NULL
	2018-12-26 18:02:29	0	

[amosbatto]

The information in your database looks to be correct.
The second task can't route to task "4529...", which doesn't exist in your process.
You probably opened a second case in the same web browser which then changed the system variables and screwed up the routing. ProcessMaker uses the same system variables for all tabs/windows, so you need to use a different web browser program.

You should only open one case at a time in a web browser and you should only login as one user in a web browser. If you want to open a second case or you want to login as another user, then you should use a second web browser program. For example, open one case in Firefox and open the second case in Chrome.