Community
Showing results for 
Search instead for 
Do you mean 
Reply

Dates Fields Changing on their own ! Urgent Help required

Copper Contributor
Posts: 45
Country: United Kingdom

Dates Fields Changing on their own ! Urgent Help required

Hi,

 

We have a customer database which contains multiple date fields to record training renewal dates for courses and accreditations.

 

The database is updating those fields on its own when users access the database !

 

I have set History on all these fields and can see that they all update at exactly the same time.

 

There are NO calculations running, there are NO Smart Tasks running. I have run Maintenance and R-Indexing etc

 

Tech Support say they have no record of this happening elsewhere.

 

Any suggestions/ideas please ?

 

Adrian

 

 

Administrator
Posts: 1,372
Country: United_Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

What are the fields updating to? What data is being entered?

Any third party addons installed?

Is it all date fields that have this problem, what happens if you create a new date field? What section of the program are these fields in (contact/company/opportunities).
Copper Contributor
Posts: 45
Country: United Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

Hi John,

 

The fields are simply date fields at Contact level.

 

No data is being entered when it occurs ! It happens when the user is updating other fields - randomly, or when they log on.

 

There are no third party addons. There are NO smart tasks.

 

All the fields were created new when this database was developed a few months ago.

 

The client has other databases and the problem does NOT exist on them.

 

I have now created another Act! user to see if that affects the situation.

Administrator
Posts: 1,372
Country: United_Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

Are all date fields affected?

I can't think of any other mechanism apart from Smart Tasks or addons that would cause fields to update themselves. Is it possible that smart tasks had been previously set up, and have since been stopped/removed but are still running in the background?

It might be worth running the clear pending smart tasks batch file to make sure- you can get it from this KB:
http://kb.act.com/app/answers/detail/a_id/36619

Copper Contributor
Posts: 45
Country: United Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

Hi John,

 

Multiple date fields are affected - - there are around 40 of them in total.

 

I used actdiag to determine if there are any smart Tasks.

Administrator
Posts: 1,372
Country: United_Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

What appears in the date field when they update - today's date?

Is there anything special about the way this database was created - i.e. restored from a remote database, or created as a copy of another database?
Copper Contributor
Posts: 45
Country: United Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

When the date fields update I believe they show todays date.

 

The database was created from an empty copy of another database, then modified with the new date fields. 

Administrator
Posts: 1,372
Country: United_Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

Would it be possible to recreate the fields, and use "Edit > Copy Field..." to copy the data into the newly created fields?
Copper Contributor
Posts: 45
Country: United Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

That is an option that I will consider.

 

My first step has been to create a new User login to see if this is somehow causing the issue, I need to go through a process of elimination.

 

 

Copper Contributor
Posts: 45
Country: United Kingdom

Re: Dates Fields Changing on their own ! Urgent Help required

An update on this:

 

1. Creating a new Act! users did NOT solve the problem.

 

2. I have had to create 40 new date fields and copied data over for each from the existing fields - currently monitoring behaviour.