DATAFED: Customer datamart datafeed/table is not updating after sending DATAFEED Soap request.

DATAFED: Customer datamart data feed/table is not updating after sending DATAFEED Soap request.

SOAP REQUEST:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dat="http://www.thesearchagency.com/smb/DataFeedService/">

<soapenv:Header/>

<soapenv:Body>

<dat:executeJobFromFileSystemRepository>

<!-Optional:->

<job name="Job 1">

<!-Optional:->

<variables>

<!-Zero or more repetitions:->

<variable key="START_DATE" value="2012-01-01"/>

<variable key="END_DATE" value="2012-01-03"/>

</variables>

</job>

</dat:executeJobFromFileSystemRepository>

</soapenv:Body>

</soapenv:Envelope>

SOAP RESPONSE:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body>

<ns2:executeJobFromFileSystemRepositoryResponse xmlns:ns2="http://www.thesearchagency.com/smb/DataFeedService/">

<return>true</return>

</ns2:executeJobFromFileSystemRepositoryResponse>

</soap:Body>

</soap:Envelope>

Login to database

A) mysql -uspike -ptar63t -h optus-qa-agency1

B)mysql> use pdi_staging

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;

----------------------------------

----------------------------------

3)mysql> select * from customerDatamart;

Empty set (0.01 sec)