AR ERROR: The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382)

View previous topic View next topic Go down

AR ERROR: The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382)

Post  giby.varghese@gmail.com on Mon Jun 07, 2010 10:10 am

AR ERROR: The value(s) for this entry violate a unique index that has been
defined for this form (ARERR 382)

giby.varghese@gmail.com

Posts : 107
Points : 222
Reputation : 3
Join date : 2009-11-11

View user profile

Back to top Go down

Re: AR ERROR: The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382)

Post  giby.varghese@gmail.com on Mon Jun 07, 2010 10:11 am

1. Turn on SQL log file and then reproduce the problem.
2. Check arerr.log file
3. Access database directly and run below commands:
select schemaId from arschema where name='Name of Form';
Then using this as an example (replace your schemaId here):
select nextId from arschema where schemaId = 101;
nextId = 1775251, we have tickets up to 1775297 in T101
update arschema set nextId = 1775298 where schemaId = 101;
See also the information in the Server Administrator's Guide on changing the Next Available Entry Id. If this
table has long field or diary field, you also need to check and update nextId for the Form based on the values in
the long field tables or diary tables with same commands that show above.

giby.varghese@gmail.com

Posts : 107
Points : 222
Reputation : 3
Join date : 2009-11-11

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum