Remedy Discussion
Would you like to react to this message? Create an account in a few clicks or log in to continue.

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

Go down

AR ERROR: The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) Empty 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 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

Back to top Go down

AR ERROR: The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) Empty 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 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

Back to top Go down

Back to top

- Similar topics

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