Hi
I had a working import synchro in iTOP from AD - everything worked fine.
Moved the instance to another server. Same Windows 2019, same WAMP, same MySQL. Have had to do this a couple of times and the synchro has worked so far.
No it doesn't work anymore. All other services work fine.
What started happening?
I checked the synchro table in the DB - for some reason all the new users get to this point but no further. But the IDs here for the new users are 0 all of a sudden.
And furthermore:
When the users were first added, it shows under the import phase. But not in the synchro phase. And in the table the same story - they are with 0s as IDs. They are not synced to iTOP.
iTop version 2.7.5-1-7770 built on 2021-07-12 19:29:29
Data model: 2.7.5
MySQL: 5.7.19
PHP: 7.1.9
The only error that I managed to find was under PHP error log: PHP Warning: Invalid argument supplied for foreach() in location_of_wamp\myvhost\synchro\synchrodatasource.class.inc.php on line 2883
The foreach is this: foreach ($aData as $sKey => $value)
{
$aRows[] = array('attcode' => $sKey, 'data' => $value);
}
$oPage->Table($aHeaders, $aRows);
$oPage->add('');
$oPage->add('');
Ok annoying but found a solution. I recreated the synchro data source on the new server. Exactly the same but just recreated it - everything works again. Hopefully this helps someone.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi
I had a working import synchro in iTOP from AD - everything worked fine.
Moved the instance to another server. Same Windows 2019, same WAMP, same MySQL. Have had to do this a couple of times and the synchro has worked so far.
No it doesn't work anymore. All other services work fine.
What started happening?
I checked the synchro table in the DB - for some reason all the new users get to this point but no further. But the IDs here for the new users are 0 all of a sudden.
And furthermore:
Import phase summary
------------------------------------------------------------
Data Source: 1
Synchronize: 1
Class: Person
Separator: ;
Qualifier: "
Charset Encoding:UTF-8
Date and time format: 'Y-m-d H:i:s'
Date only format: 'Y-m-d'
Data Size: 41595
Data Lines: 230
Columns: primary_key, name, status, org_id, email, phone, notify, function, first_name, mobile_phone, location_id, employee_number
Output format: summary
Simulate: 0
Change tracking comment:
Issues (before synchro): 0
Created (before synchro): 2
Updated (before synchro): 228
------------------------------------------------------------
Synchronization phase summary
------------------------------------------------------------
Replicas: 244
Replicas touched since last synchro: 244
Objects deleted: 0
Objects deletion errors: 0
Objects obsoleted: 0
Objects obsolescence errors: 0
Objects created: 0 (0 warnings)
Objects creation errors: 0
Objects updated: 0 (0 warnings)
Objects update errors: 0
Objects reconciled (updated): 0 (0 warnings)
Objects reconciled (unchanged): 0 (0 warnings)
Objects reconciliation errors: 1
Replica disappeared, no action taken: 0
When the users were first added, it shows under the import phase. But not in the synchro phase. And in the table the same story - they are with 0s as IDs. They are not synced to iTOP.
iTop version 2.7.5-1-7770 built on 2021-07-12 19:29:29
Data model: 2.7.5
MySQL: 5.7.19
PHP: 7.1.9
The only error that I managed to find was under PHP error log: PHP Warning: Invalid argument supplied for foreach() in location_of_wamp\myvhost\synchro\synchrodatasource.class.inc.php on line 2883
The foreach is this: foreach ($aData as $sKey => $value)
{
$aRows[] = array('attcode' => $sKey, 'data' => $value);
}
$oPage->Table($aHeaders, $aRows);
$oPage->add('');
$oPage->add('');
Ok annoying but found a solution. I recreated the synchro data source on the new server. Exactly the same but just recreated it - everything works again. Hopefully this helps someone.