Article

Unable to use idxactivate because it displays the error message (13246)

Information

 
Article Number000064523
EnvironmentProduct: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Other: idxactivate
Question/Problem Description
Unable to use idxactivate because it displays the error message (13246).
Steps to Reproduce
Clarifying Information
Index has been added and it is inactive.
Error MessageConnections with timestamps older than <dbtimestamp> exist. (13246)
Defect/Enhancement Number
Cause
This is an Informational message indicating that Index Activate cannot proceed to process the index until the list client connections either reset their schema timestamp or disconnect from the database.  SQL clients reset their timestamp at the beginning of each transaction.  ABL clients must disconnect and reconnect to reset their timestamp.





 
Resolution
ABL clients need to either finish the transaction and disconnect or have to be disconnected using the command:

proshut <DBNAME> -C disconnect <user number> 

To run the idxactivate in a script use the following methods.

For UNIX

yes | proutil sp -C idxactivate customer.climit refresh 1 > idxactivate.log

This will ask every second and will be automatically answer with a "y" until the process that is locking the schema finishes or is terminated.

For Windows and UNIX

proutil sp -C idxactivate customer.climit refresh 1 < yes.txt > idxactivate.log

This will ask every second and will be automatically be feed with a "y" from the yes.txt file until the process that is locking the schema finishes or is terminated or the number of "y" characters is finished.

A yes.txt file will automatically answer five times if it contains:

y
y
y
y
y
 
Workaround
Notes
Attachment 
Last Modified Date11/12/2015 11:19 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025