Re: Remedy 9.0.01 Installation failed

2016-03-24 Thread Su Kaur 
It was new on test environment. Our last 3 test upgrades also failed but there 
was no email error in the logs.  
This is the first time we had email issues and duplicate key error.

-Kaur

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Remedy 9.0.01 Installation failed

2016-03-24 Thread Saji Philip 
We have the same error, but going from 8.1.02 to 9.1...  Also, 9.0 failed
as well...  Got the same duplicate key Value error.  We have engaged BMC,
will let you know how it goes

On Thu, Mar 24, 2016, 5:48 PM Scott Philben  wrote:

> Was this an upgrade on new hardware? If so, you will have to license it
> before your start. We installed 7.6.04 on a new box, swapped out the
> database with the existing DB, licensed it on the new server, and then ran
> the 8.0 upgrader. BMC recommended doing that one first then moving on to
> 9.0.01 upgrader.
>
> Try that.
>
> Sent from my iPhone
>
> > On Mar 24, 2016, at 18:21, Su Kaur  wrote:
> >
> > Hello,
> >
> > We tried to upgrade 7.6 to 9.0.01 but it failed.  We are highly
> customized and not using any OOTB ITSM applications. The install log file
> had following errors at multiple places -
> > - Your login failed, but connected as a guest user
> >
> > -  LOG EVENT
> {Description=[[resultType=COMPLETED,exitCode=2]],Detail=[RIK command (
> returned a RETURN code of 2, which was interpreted as a failure from RIKJ
> [RIKCOMMAND] LOAD_APPLICATION -C true -t 3785 -u Action Request Installer
> Account -f C:\Program Files\BMC
> Software\ARSystem\AREmail\adf_emailengine_def.xml
> >
> > - LOG EVENT  C:\Program Files\BMC Software\ARSystem -L true -n
> EmailEngine-RIK_PostInstall -N 7200  [RIKERROR]  Exception from RIKJ
> command Definition import failed, code 2 , filename - C:\Program Files\BMC
> Software\ARSystem\AREmail\AR_Email_Workflow.def]
> >
> >
> >
> > We tried to manually import the AR_Email_Workflow.def file but got
> following error -
> >
> > The SQL database operation failed.;
> org.springframework.orm.jpa.JpaSystemException: Exception
> [EclipseLink-4002] (Eclipse Persistence Services -
> 2.4.2.v20130514-5956486):
> org.eclipse.persistence.exceptions.DatabaseException
> > Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerExcepti,  552,
> >
> > The following item was not imported; AR System Email Mailbox
> Configuration,  55,
> >
> >
> >
> > Below are the exceptions in the SQL logs during def file import -
> >
> > uery: InsertObjectQuery(name=Incoming Mail Server Password,
> overlayGroup=0, overlayProp=0)
> > org.springframework.orm.jpa.JpaSystemException: Exception
> [EclipseLink-4002] (Eclipse Persistence Services -
> 2.4.2.v20130514-5956486):
> org.eclipse.persistence.exceptions.DatabaseException
> > Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException:
> Violation of PRIMARY KEY constraint 'PK__field__9104870AD2A5F43D'. Cannot
> insert duplicate key in object 'dbo.field'. The duplicate key value is
> (136, 123, 0).
> > Error Code: 2627
> > Call: INSERT INTO field (fieldId, schemaId, overlayGroup, changeDiary,
> createMode, defaultValue, fbOption, fieldType, fOption, helpText,
> lastChanged, fieldName, objProp, overlayProp, owner, recordId,
> resolvedfieldId, resolvedName, smObjProp, timestamp, datatype) VALUES (?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
> >bind => [21 parameters bound]
> > Query: InsertObjectQuery(name=Incoming Mail Server Password,
> overlayGroup=0, overlayProp=0); nested exception is
> javax.persistence.PersistenceException: Exception [EclipseLink-4002]
> (Eclipse Persistence Services - 2.4.2.v20130514-5956486):
> org.eclipse.persistence.exceptions.DatabaseException
> > Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException:
> Violation of PRIMARY KEY constraint 'PK__field__9104870AD2A5F43D'. Cannot
> insert duplicate key in object 'dbo.field'. The duplicate key value is
> (136, 123, 0).
> > Error Code: 2627
> >
> >
> > Has anyone faced this issue before?  How to fix it?
> >
> > Thanks!
> > Kaur
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Remedy 9.0.01 Installation failed

2016-03-24 Thread Scott Philben 
Was this an upgrade on new hardware? If so, you will have to license it before 
your start. We installed 7.6.04 on a new box, swapped out the database with the 
existing DB, licensed it on the new server, and then ran the 8.0 upgrader. BMC 
recommended doing that one first then moving on to 9.0.01 upgrader. 

Try that. 

Sent from my iPhone

> On Mar 24, 2016, at 18:21, Su Kaur  wrote:
> 
> Hello,
> 
> We tried to upgrade 7.6 to 9.0.01 but it failed.  We are highly customized 
> and not using any OOTB ITSM applications. The install log file had following 
> errors at multiple places -
> - Your login failed, but connected as a guest user 
> 
> -  LOG EVENT {Description=[[resultType=COMPLETED,exitCode=2]],Detail=[RIK 
> command ( returned a RETURN code of 2, which was interpreted as a failure 
> from RIKJ  [RIKCOMMAND] LOAD_APPLICATION -C true -t 3785 -u Action Request 
> Installer Account -f C:\Program Files\BMC 
> Software\ARSystem\AREmail\adf_emailengine_def.xml
> 
> - LOG EVENT  C:\Program Files\BMC Software\ARSystem -L true -n 
> EmailEngine-RIK_PostInstall -N 7200  [RIKERROR]  Exception from RIKJ command 
> Definition import failed, code 2 , filename - C:\Program Files\BMC 
> Software\ARSystem\AREmail\AR_Email_Workflow.def]
> 
> 
> 
> We tried to manually import the AR_Email_Workflow.def file but got following 
> error -
> 
> The SQL database operation failed.; 
> org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] 
> (Eclipse Persistence Services - 2.4.2.v20130514-5956486): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerExcepti,  552,  
> 
> The following item was not imported; AR System Email Mailbox Configuration,  
> 55,  
> 
> 
> 
> Below are the exceptions in the SQL logs during def file import -
> 
> uery: InsertObjectQuery(name=Incoming Mail Server Password, overlayGroup=0, 
> overlayProp=0)
> org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] 
> (Eclipse Persistence Services - 2.4.2.v20130514-5956486): 
> org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: 
> Violation of PRIMARY KEY constraint 'PK__field__9104870AD2A5F43D'. Cannot 
> insert duplicate key in object 'dbo.field'. The duplicate key value is (136, 
> 123, 0).
> Error Code: 2627
> Call: INSERT INTO field (fieldId, schemaId, overlayGroup, changeDiary, 
> createMode, defaultValue, fbOption, fieldType, fOption, helpText, 
> lastChanged, fieldName, objProp, overlayProp, owner, recordId, 
> resolvedfieldId, resolvedName, smObjProp, timestamp, datatype) VALUES (?, ?, 
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
>bind => [21 parameters bound]
> Query: InsertObjectQuery(name=Incoming Mail Server Password, overlayGroup=0, 
> overlayProp=0); nested exception is javax.persistence.PersistenceException: 
> Exception [EclipseLink-4002] (Eclipse Persistence Services - 
> 2.4.2.v20130514-5956486): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: 
> Violation of PRIMARY KEY constraint 'PK__field__9104870AD2A5F43D'. Cannot 
> insert duplicate key in object 'dbo.field'. The duplicate key value is (136, 
> 123, 0).
> Error Code: 2627
> 
> 
> Has anyone faced this issue before?  How to fix it?
> 
> Thanks!
> Kaur
> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"