Symptoms
A "Create virtual web server" task is failing like below:
Task ID 10000001
Queue name domain_service10001
Task name Create virtual web server 100001 (domain_id=11111, hd_id=111111) on host 'winweb.provider.tld' (host_id=101).
Task description
Create virtual web server 10938 (domain_id=11111, hd_id=111111) on host 'winweb.provider.tld' (host_id=101).
Subscription ID 1000001
Queue status Failed
Start not earlier than Jan-01-2017 00:10
Method name taskCreateWebSite on OBJREF:iis:0:getDomainService:10001
Last execution output java.lang.NullPointerException
The following can be found in OA main system log during the task's execution:
Apr 27 15:54:36 linmn : DBG [task:10000001:954314 RequestProcessor-592874 pau ]: com.parallels.pa.service.db.ejb.DBServiceBean Executing non-locking query: ' SELECT dom_id FROM iis_addons WHERE ( srv_id = ? ) '. Parameters: [1111] [sqlpid: 1297]
Apr 27 15:54:36 linmn : DBG [task:10000001:954314 RequestProcessor-592874 pau ]: com.parallels.pa.corba.ServiceInvoker Service invocation for service DBService$$$view9 took 1 ms
Apr 27 15:54:36 linmn : DBG [task:10000001:954314 1:2999:f24f1b90 lib ]: [ DBHelper::SelectExecutorNoLock::executeSelect] <=== EXIT [0.001764]
Apr 27 15:54:36 linmn : DBG [task:10000001:954314 RequestProcessor-583790 pau ]: com.parallels.pa.service.dns.ejb.DomainManagerBean Invoking getDomain, domainId: 11111
Apr 27 15:54:36 linmn : DBG [task:10000001:954314 RequestProcessor-583790 pau ]: com.parallels.pa.corba.ServiceInvoker DomainManager invocation failedjavax.ejb.EJBException: java.lang.NullPointerException
at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInNoTx(CMTTxInterceptor.java:215) ~[jboss-as-ejb3-7.3.0.Final-redhat-14.jar!/:7.3.0.Final-redhat-14]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:261) ~[jboss-as-ejb3-7.3.0.Final-redhat-14.jar!/:7.3.0.Final-redhat-14]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:398) ~[jboss-as-ejb3 -7.3.0.Final-redhat-14.jar!/:7.3.0.Final-redhat-14]
at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:242) ~[jboss-as-ejb3-7.3.0.Final-redhat-14.jar!/:7.3.0.Final-redhat-14]
In the OA database:
plesk=> SELECT ds_id,dom_id,dom_name FROM iis_addons WHERE srv_id=1111;
ds_id | dom_id | dom_name
-------+--------+------------------------
10001 | 11111 | domain.com
plesk=> select count(*) from domains where domain_id = 11111;
count
-------
0
Cause
Most likely the domain was removed from OA while the task was being processed, thus creating a database inconsistency.
Resolution
This issue is reported to the OA maintenance team as POA-99553: "Domain could be deleted while creating of a virtual web server bound to it". Please contact your Account Manager or Pooled Technical Associates team (pta@odin.com) to trace the status of the issue.
As a workaround the task should be canceled and the virtual web server should be recreated from scratch, if required.