Due to huge customization in application we may come across database and application synchronization failure issue. Sometimes you will see this error when you add some new fields in CustTable or SalesTable, this is just for an example you can have this issue in any table or view.
progress.setText(dict.tableName(tableId));
application.dbSynchronize(tableId, false, true, false);
Following job will forcefully synchronize all the tables in AOT.
static void forceDbSynchronize(Args _args)
{
Dictionary dict;
int
idx, lastIdx, totalTables;
idx, lastIdx, totalTables;
TableId tableId;
Application application;
SysOperationProgress progress;
StackBase errorStack;
ErrorTxt errorTxt;
;
application = new Application();
dict = new Dictionary();
totalTables = dict.tableCnt();
progress = new SysOperationProgress();
progress.setTotal(totalTables);
progress.setCaption(“@SYS90206”);
errorStack = new StackBase(Types::String);
lastIdx = 0;
try
{
for (idx = lastIdx+1; idx <=
totalTables; idx++)
totalTables; idx++)
{
tableId =
dict.tableCnt2Id(idx);
dict.tableCnt2Id(idx);
progress.setText(dict.tableName(tableId));
lastIdx = idx;
application.dbSynchronize(tableId, false, true, false);
progress.incCount();
}
}
catch (Exception::Error)
{
errorTxt = strFmt(“Error in table
‘%1’ (%2)”, tableId, dict.tableName(tableId));
‘%1’ (%2)”, tableId, dict.tableName(tableId));
errorStack.push(errorTxt);
retry;
}
setPrefix(“@SYS86407”);
errorTxt = errorStack.pop();
while (errorTxt)
{
error(errorTxt);
errorTxt = errorStack.pop();
}
info(‘Sychrnonization is now done.’);
}
