Question / Issue |
|
DataPlus Auto Import not updating Act |
Answer / Solution |
|
Auto import is setup for DataPlus using Microsoft Task Scheduler.
The data in Act is not being updated.
Items to check to verify import.
- Task Scheduler
- Ensure Task is
- Enabled
- Administrator Username/Password is valid
- Status = "Ready"
- If multiple DataPlus tasks are scheduled, ensure that the tasks do not overlap time frame
- DataPlus Log Files
- Server
- C:\Program Files (x86)\Hogan Data\DataPlus 4.0\Logs
- Verify log files
- are being created
- time stamp and creation date
- Open and review latest log files
- Review log entries at the end of file.
- Import Complete
- This is an indication that the import was successful and complete
- No profiles found to import. Stopping.
- Profile in "bat" file does not exist, or is wrong
- Profile is created in DataPlus Server Configuration. The comment in bat file corresponses with the profile.
- Profile name = CustomerOnly (dpConfiguration)
- Profile reference in bat file = pr:"CustomerOnly"
- Another instance of DataPlus Import is already running.
- Only one instance of DataPlus Import can be running at the sametime. Ensure the there is plenty of time between scheduled tasks and be sure profile is configured properly
- Error: Database is locked. You must log in to ACT! to unlock it.
- The Act database is in a locked state and data cannot be imported
- Error: Update For Record Failed -- Update Aborted.
- Review log entries above the Error message
- Examples
- Error: Unable to process row. Reason given was: Unable to get field type for column: ColumnName as requested by "StoredProcedureName:Data Type Not Detected
- New field needs to be created and "Disable Database Locking" is checked or someone is in Act and the data type of field cannot be determined
- Error: Unable to process row. Reason given was: Unable to create contact field: FieldName Reason given was: The database must be locked to apply schema changes.
- New field needs to be created and "Disable Database Locking" is checked or someone is in Act
- "Disable Database Locking" is not checked. Therefore DataPlus is trying to lock the Act database and it cannot because someone is logged into Act.
- New field needs to be created and "Disable Database Locking" is checked or someone is in Act
- Error: Log on information is incorrect. Please fill in the correct User Name and Password
- Login credentials in DataPlus Configuration Manager for Act is incorrect.
- DataPlus Configuration Manager
|