Hi,

I've been trying to add customers and contacts, but after adding a customer the grid remains empty. If I add a customer and a contact in the same step, it is even more frustrating since it doesn't show any customer or contact but subsctracts a license from my total license count. The status bar of the "Manage customers" panel says: 0 customer(s), 0 contact(s), 4/25 contacts with license (I'm translating from spanish to english "on the fly" so that may not be the exact literals but I'm sure you'll get the point).

If I go further and take a look at the database I realize that the "Customers" table is using negative customerId's! Could it be the problem? (it started from CustomerId -201, then -101, -100 and counting down....

Can anyone give me intructions about how to solve this issue?

Thank you in advance

Roger Saladrigas

Memory Soft.

Hello Roger,

It appears as if the seed in your CustomerContacts table has been altered or was created incorrectly when your database was created.Did you or anyone make any changes to this table through SQL, or was your database replicated(as opposed to being created via OnTime)?

The -201 and -101 entries in that table refer to the Anonymous and Default contacts, and are required. Yet, your contacts should be incrementing upwards from 1, not from -101. Follow these steps in order to resolve the issue:

First, have your DBA go into the CustomerContacts table using SQL Management Studio and change the CustomerContactIDs and CustomerIDs "-100","-99", etc, to positive numbers such as "1", "2", etc. The Manage Customers window in OnTime will only display those customers contacts with an ID greater than 1, so after fixing these numbers you should be able to see those Contacts.

Next, have your DBA modify the CustomerContacts table. For the CustomerContactID field, under 'Identity Specification', make sure you have the Identity Seed parameter set to "1". Doing this will tell SQL to increment from positive 1, which should have been the default setting in a new OnTime database.

Let me know if you have any further questions.

Hi Tom,

AFAIK nobody has made any change to the database via SQL, actually this was the first time I opened the database to manipulate it. The database was created via OnTime a long time ago (I guess it was created with OnTime 2005). The identity seed was already set to 1.

Following your instructions I managed to solve the issue.

Thank you very much.