Resolved: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid
Thank you Doug for your response, again. To further share with LIST, This error " ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid" was a result of exporting production schema without stopping the production database. (we can't stop production for test/qa environment). The Status-History on 15 records in Service mngt (incident form) were being updated at the time of export. So, once we imported to qa_environment, this error start to occurred on Escalations (aresc.log showed errno=514), Filter (arfilter.log showed USER: AR_ESCALATOR> 514), arerror.log ( ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid") and POP-UP in WUT/MT (ARERR [514] Contents of the Status-History field in the flat file database are missing or invalid). Since qa, I found to records and deleted. If this is production move, then we would have taken the outage and stop db and export schema appropriately. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/ARERR-514-Contents-of-the-Status-History-field-in-the-flat-file-database-are-missing-or-invalid-tp7334519p7352747.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid
Your right Doug, I posted and ran to pick-up kids.. ARS 7.5P4 on 10g DB all on unix 6.1 - we are migrating to new server and db, and brought over the arsys_data schema - we are doing like for like. I queried knowledge base and google and only came up with references to error catalog. I'm not sure which of the below apply.. thanks you the great response... DEE -Original Message- From: Mueller, Doug To: arslist Sent: Thu, Mar 1, 2012 7:19 pm Subject: Re: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid Well, you gave no indicate of what you were doing or context of the message or version of the product or DB you are using or . So, no indication of anything other than an out of context error message. This makes it a bit difficult to help. But, the only place I have been able to find a reference to this error (the text is a bit misleading as it was originally used for a flat file DB case and was shared for this other use without fixing the text of the message) is when there is a query qualifier of some type that has a reference to a status history field and the syntax of the portion of the qualifier structure for the status history reference is incorrect. Now, if you were writing a API program and issuing a call with a qualifier, it would indicate that you have not correctly loaded the Status History section of the Arithmetic Operation Qualifier structure. If you are getting this at import time, it would indicate that the format of some qualifier (an active link or filter run if or a set field or push fields qualifier or ...) is corrupted. There is a status history reference and the format of the serialized representation of the qualifier cannot be decoded. If you are getting this at AR System server startup, it is the same idea as import but it means that one of the definitions somewhere in your metadata tables has a bad qualifier. If you are getting this somewhere else, it is an indication of something around the area where you are getting the error has a bad qualifier regarding a reference to Status History. Of course, the qualification could be messed up so that the system THINKS there is a status history reference but it is really some other corruption of the qualifier definition. Anyway, I hope this helps. It is hard to help further without context. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of RemedyAdmin Sent: Thursday, March 01, 2012 3:10 PM To: arslist@ARSLIST.ORG Subject: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid Can anyone provide a hint/how to resolve this error? Thu Mar 1 18:07:30 2012 390603 : Contents of the Status-History field in the flat file database are missing or invalid (ARERR 514) -- View this message in context: http://old.nabble.com/ARERR-514%3A-Contents-of-the-Status-History-field-in-the-flat-file-database-are-missing-or-invalid-tp33425076p33425076.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
Re: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid
Well, you gave no indicate of what you were doing or context of the message or version of the product or DB you are using or . So, no indication of anything other than an out of context error message. This makes it a bit difficult to help. But, the only place I have been able to find a reference to this error (the text is a bit misleading as it was originally used for a flat file DB case and was shared for this other use without fixing the text of the message) is when there is a query qualifier of some type that has a reference to a status history field and the syntax of the portion of the qualifier structure for the status history reference is incorrect. Now, if you were writing a API program and issuing a call with a qualifier, it would indicate that you have not correctly loaded the Status History section of the Arithmetic Operation Qualifier structure. If you are getting this at import time, it would indicate that the format of some qualifier (an active link or filter run if or a set field or push fields qualifier or ...) is corrupted. There is a status history reference and the format of the serialized representation of the qualifier cannot be decoded. If you are getting this at AR System server startup, it is the same idea as import but it means that one of the definitions somewhere in your metadata tables has a bad qualifier. If you are getting this somewhere else, it is an indication of something around the area where you are getting the error has a bad qualifier regarding a reference to Status History. Of course, the qualification could be messed up so that the system THINKS there is a status history reference but it is really some other corruption of the qualifier definition. Anyway, I hope this helps. It is hard to help further without context. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of RemedyAdmin Sent: Thursday, March 01, 2012 3:10 PM To: arslist@ARSLIST.ORG Subject: ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid Can anyone provide a hint/how to resolve this error? Thu Mar 1 18:07:30 2012 390603 : Contents of the Status-History field in the flat file database are missing or invalid (ARERR 514) -- View this message in context: http://old.nabble.com/ARERR-514%3A-Contents-of-the-Status-History-field-in-the-flat-file-database-are-missing-or-invalid-tp33425076p33425076.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
ARERR 514: Contents of the Status-History field in the flat file database are missing or invalid
Can anyone provide a hint/how to resolve this error? Thu Mar 1 18:07:30 2012 390603 : Contents of the Status-History field in the flat file database are missing or invalid (ARERR 514) -- View this message in context: http://old.nabble.com/ARERR-514%3A-Contents-of-the-Status-History-field-in-the-flat-file-database-are-missing-or-invalid-tp33425076p33425076.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"