Re: Remedy 9.0.01 Installation failed
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
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
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"
Remedy 9.0.01 Installation failed
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"
Please remove me from list ...thank you all
___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
Re: Vendor Form to external Oracle Database
Thanks - good to know. I finally got AI working. Little thanks to BMC support on that. I don't think I need this solution right now. James On Wednesday, March 9, 2016 at 6:05:46 PM UTC-5, LJ LongWing wrote: > > ** > James, > A View form gives you all of the ability to query/update/insert/delete > that your account has permission to do on the other end, and is > significantly easier than setting up an ARDBC Plugin. > > On Wed, Mar 9, 2016 at 3:56 PM, jham36 > > wrote: > >> ** >> Thanks, but I need to update the data in the external database. I think >> I need a vendor form for this. >> >> My first solution to this was using AIE. That worked fine, but we are >> migrating to ARS 9.1 with AI and support is not very helpful in telling me >> how to pass a variable into my job/transformation into the ARInput step. >> They want me to directly query the AR database, which I am not a fan of >> doing since the table and column names may differ between dev and >> production. Going through the Application server with the ARInput step >> seems like a better solution instead of a TableInput step. >> >> On Wednesday, March 9, 2016 at 1:17:15 PM UTC-5, jham36 wrote: >>> >>> ARS 9.1 windows 2008 oracle 11 >>> External DB Oracle 11 >>> I am trying to use ojdbc6.jar file from the oracle client installation >>> to create a plugin to be used in a view form. >>> I am trying to follow the limited instructions that BMC offers on how to >>> do this, but everything is too generic. "create your plugin", "Add it to >>> the Plugin Server Configuration", "Add anything else you need" >>> That's not much help. I am sure someone has figured out how to do >>> this. I would think a connection to an external oracle database would be >>> fairly common. Common enough for BMC to provide better documentation. >>> >>> Can anyone point me in the right direction here? What needs to be >>> provided when using the Plugin Server Config form? What user defined >>> parameters are needed? What else is needed? Do I have to manually update >>> pluginserver cong and ar.cfg? >>> >>> Thanks, >>> James >>> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "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"
