9.2

Edit

Manual Task screen is blank

Symptoms

When opened, a Manual Task displays only a blank screen, and the following error is observed in the developer's console:

Root cause

The customer changed URLs.

Resolution

Check the URL in Task > Run tab > Advanced Options > External Form URL and in the databases:

MySQL DB:

mysql> use wfdb;
mysql> select * from MturkEndpoint\G
mysql> select * from Question\G
mysql> select * from EndpointTask\G
mysql> select * from AwsHit\G

PostgreSQL DB:

wfuser=# \c virtualizer
virtualizer=# select * from hit;

virtualizer=# \c virtualizer_sandbox
virtualizer_sandbox=# select * from hit;

In the output, you will see different URLs (old and new ones). To fix it, update URLs in the DB.

Here are the commands for backups:

Mysql:
/home/wfuser/db/lib/mysql/bin/mysqldump -uUSER -pPASS  --port=3306 -h 127.0.0.1 wfdb MturkEndpoint > /backup/tmp/MturkEndpoint.sql
/home/wfuser/db/lib/mysql/bin/mysqldump -uUSER -pPASS  --port=3306 -h 127.0.0.1 wfdb Question > /backup/tmp/Question.sql
/home/wfuser/db/lib/mysql/bin/mysqldump -uUSER -pPASS  --port=3306 -h 127.0.0.1 wfdb EndpointTask > /backup/tmp/EndpointTask.sql
/home/wfuser/db/lib/mysql/bin/mysqldump -uUSER -pPASS  --port=3306 -h 127.0.0.1 wfdb AwsHit > /backup/tmp/AwsHit.sql

Postgresql:
/home/wfuser/db/lib/pgsql-client/bin/pg_dump  -h 127.0.0.1 -p 5432 -U USER -d virtualizer_sandbox -t hit > /backup/tmp/postgres_hit_sandbox.sql
/home/wfuser/db/lib/pgsql-client/bin/pg_dump  -h 127.0.0.1 -p 5432 -U USER -d virtualizer -t hit > /backup/tmp/postgres_hit.sql

Here are the commands to update databases (DB):

MySQL (wfdb DB):

-- change this to valid hostnames --
SET @FROM='<OLD NAME>', @TO='<NEW NAME>';
  
update MturkEndpoint SET secretkey="%%SECRET-CHANGEME%%", accesskey="%%KEY-CHANGEME%%"  WHERE driverid='amazonMturkDriver';
update License SET activeInd=false;
 
UPDATE MturkEndpoint SET 
mturkUrlProduction=replace(mturkUrlProduction,@FROM,@TO), 
mturkUrlTest=replace(mturkUrlTest,@FROM,@TO), 
oopsProductionUrl=replace(oopsProductionUrl,@FROM,@TO), 
oopsSandboxUrl=replace(oopsSandboxUrl,@FROM,@TO), 
productionSubmitUrl=replace(productionSubmitUrl,@FROM,@TO), 
sandboxSubmitUrl=replace(sandboxSubmitUrl,@FROM,@TO), 
secureProductionSubmitUrl=replace(secureProductionSubmitUrl,@FROM,@TO), 
secureSandboxSubmitUrl=replace(secureSandboxSubmitUrl,@FROM,@TO), 
productionSearchUrl=replace(productionSearchUrl,@FROM,@TO), 
sandboxSearchUrl=replace(sandboxSearchUrl,@FROM,@TO), 
notificationDestinationUrl=replace(notificationDestinationUrl,@FROM,@TO);


UPDATE Question SET  externalFormUrl = REPLACE(`externalFormUrl`, @FROM, @TO);
UPDATE EndpointTask SET  externalURL = REPLACE(`externalURL`, @FROM, @TO);
UPDATE AwsHit SET  externalURL = REPLACE(`externalURL`, @FROM, @TO);

PostgreSQL (virtualizer and virtualizer_sandbox):

-- replace(string text, from text, to text)
update hit set question = replace(question, 'old', 'new');

Replace the old name with a new one:

  • /etc/hosts

  • /etc/hostname

  • /etc/nginx/sites-enabled/site

  • /etc/nginx/sites-enabled/site-ssl

Read also:

← PreviousNext →