1/30/2008

Tuxedo error prodinst_complete.cc

Hi all again.

Recently one reader of this blog (one that it isn’t one of my colleagues, one of my friends, or one of my family) ask to me why I don’t update this blog frequently. Well, there were several reasons, but one of them was very clear; it seemed to me that no one was interested in this blog. But after this comment I understand that, at least, one person was following this blog. This entry is dedicated to this reader. THANK YOU for your comment.

What I have done today that could be interested for this blog? Today in the morning the service desk sent me the following error

“E12118> Tuxedo error 5500 occurred. Tuxedo error message, Internal error occurred in file prodinst_complete.cc at line 2394. “

This error was produced when the provisioning system was trying to create a new product instance in the system. The product instances in our system are created by an EAI (a middleware between the CRM (not Singl.eView) and the billing system (Singl.eView)). This EAI is coded in JAVA and create these instances using the JAVA API. The error appeared when the EAI was trying to “complete” a product instance after the creation of this and after the services were added to this instance. This only was happening when it was trying to create some instances of some product type.
After some tests (including creating the product instance using the Singl.eView GUI) I identified that the problem was derived for a problem in the database. The definition of the product in the database had one error. In the product_service_type table (the table that has the service types that are included in the product definition) the service_item_seqnr wasn’t consecutive. There was a hole in the sequence. One row for this product had been deleted. This was the origin of the problem.
I tested also, that the same problem it could happen if some of the service_range_seqnr was duplicated for the product.
Then, if you obtain this error remember review the service_range_seqnr field for the product type and for the companion products that you were trying to complete. It can’t be holes and it can’t be duplicated.

How to fix this? Very clear and very dangerouos. You have to fix the sequence in the service_range_seqnr…but warning ! This field is replicated in the product_instance_service table, then if you have yet several instances of this kind of product created, you can´t change the service_range_seqnr that are in this table for this instances.

I hope I had been clear in the explanation. If you have some question or comment, please post.

That’s all folks,

Labels: