
Hi all,
In running scheduler job 1070, I get the following errors in one infolog. Any help in resolving these will be much appreciated
1. "The change tracking information related to scheduler job 1070 and data group DataGroup are only partially available, due to the AX database change tracking retention period setting. A complete snapshot of data will be generated instead."
2. "Error executing code: RetailCDXXmlDataOutput_AX63 (Object) has no valid runable code in method 'RetailPubRetailStoreTable'."
3. "Error happened during scheduler job execution. Check infolog for details."
Infolog shows
public void run()
{
RetailConnSchedule schedule;
int lastInfologLine;
str exceptionMessage;
;
scheduledJobs = new Set(Types::String);
if (this.isInBatch())
{
// create a task, which will start after other tasks
// will finish their execution
if (!batchHeader)
{
batchHeader = BatchHeader::construct(this.parmCurrentBatch().BatchJobId);
}
lastTask = new RetailMonitoringScheduleEndTask();
batchHeader.addRuntimeTask(lastTask, this.parmCurrentBatch().RecId);
}
try
{
select firstonly Active from schedule where schedule.RecId == scheduleRecID;
if (schedule.Active == NoYes::No)
{
Global::warning(strFmt("@REX4160596", schedule.Name));
return;
}
switch (parameterSet)
{
case 0: // regular
this.processRegular();
break;
case 1: // full sync
this.processFullSync();
break;
case 2: // rerun
this.processRerun();
break;
default:
break;
}
if (this.isInBatch())
{
lastTask.setScheduledJobs(scheduledJobs);
batchHeader.save();
}
else
{
RetailMonitoringHelper::processExecutionResults(scheduledJobs);
}
}
catch
{
if (!this.isInBatch())
{
RetailMonitoringHelper::processExecutionResults(scheduledJobs);
}
// rethrow last error
lastInfologLine = Global::infologLine();
exceptionMessage = infolog.text(lastInfologLine);
// delete last message, since it will be rewritten
infolog.cut(lastInfologLine);
throw Global::error(exceptionMessage);
}
if (!taskExists)
{
select firstonly Name from schedule where schedule.RecId == scheduleRecID;
// Schedule %1 has no associated data group or enabled job.
Global::warning(strFmt("@REX4520721", schedule.Name));
}
}
Any help in resolving this error will be much appreciated.
*This post is locked for comments
I have the same question (0)1. From AX 2012 R3, AX use sql change tracking to identify what is the incremental data it needs to push for each datagroup. For optimal database size, the change tracking data retention period is set to below 1 week in most of the cases. If you have not send incremental job in 7 days, system will send the full data as the the change tracking information is not available. You can go change the change tracking period in datapbase properties from SQL management studio.
2. -
3. Please make sure that Channel Schema on the 1070 match with the channel schema in the data group configuration.