ContentPack Import fails
we are using OMi 10.61 and have exported an OMi Content Pack. When I import it into another OMi (10.61 or 10.62) I get the following error:
Internal server error. Details: could not update: [com.hp.opr.config.Instrumentation#0379a44d-d710-4059-b4d5-7401050898cb]; SQL [update CFG_INSTRUMENTATION set CONTENT=?, CHKSUM=?, DATE_UPDATED=?, DESCRIPTION=?, DIRNAME=?, VERSION=?, LABEL=?, IS_STUB=? where ID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not update: [com.hp.opr.config.Instrumentation#0379a44d-d710-4059-b4d5-7401050898cb].
The Id 0379a44d-d710-4059-b4d5-7401050898cb is the Cluster_Infrastructure.
Any advise how to fix this?
Just based on "SQLGrammarException" is it possible that the content pack was created/exported from an OMi server with a different DB type from the one that you tried to import to? Of course it should work across DB types, but I have seen in the past a situation where a policy template had what was a valid setting but didn't translate successfully via content pack across from PostgreSQL to SQL Server. In that case, a policy parameter had a min value but no max value, so I entered a max value to avoid the null field which was stored in the content pack as "NaN" which was not a numeric so could not be inserted to the table in SQL Server at content pack import time).
thanks for your reply. The ID which has the problem is a "Instrumentation". Do you also have a proposal how to fix this?
I don't have other ideas - was just sharing that one situation involved working with content across OMi servers that each had different vendor database types. Where the vendor db type was the same in both OMi servers, there was no problem.