Re: CMDB 18_05 Installer fails
Perhaps you need to set the JAVA_HOME and/or JRE_HOME environment variables? -JDHood On Fri, Oct 5, 2018 at 4:57 PM Kevin Candelaria wrote: > perhaps its looking for /usr/java/latest/ > > or try creating a symlink. > > > > -- > *From:* ARSList on behalf of Kevin Shaffer < > kshaf...@partneritsm.com> > *Sent:* Friday, October 5, 2018 3:04 PM > *To:* ARSList > *Subject:* CMDB 18_05 Installer fails > > > We are trying to upgrade from 8.1.02 to 18_05. We are running in a > Solaris environment. ARS has upgraded and we are now trying the CMDB > installer. It keeps failing with the error, “incorrect jre path”, however > you are never prompted to enter a jre path. We have tried modifying the > path in the file, AtriumCoreInstallingConfiguration.xml and > AtriumCoreInstalled.xml and still get the same message. We think this is > because it appears the installer overwrites that path > > > > We think the root cause might be the setup.bin, as we have noticed that > the installer seems to append the bin directory to the java path. So our > java path is usr/java/jre, however I think it is looking for java in the > usr/java/jre/bin directory. > > > > Has anyone else experienced this issue or have any ideas how to get around > the error? > > > -- > ARSList mailing list > ARSList@arslist.org > https://mailman.rrr.se/cgi/listinfo/arslist > -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: CMDB 18_05 Installer fails
perhaps its looking for /usr/java/latest/ or try creating a symlink. From: ARSList on behalf of Kevin Shaffer Sent: Friday, October 5, 2018 3:04 PM To: ARSList Subject: CMDB 18_05 Installer fails We are trying to upgrade from 8.1.02 to 18_05. We are running in a Solaris environment. ARS has upgraded and we are now trying the CMDB installer. It keeps failing with the error, "incorrect jre path", however you are never prompted to enter a jre path. We have tried modifying the path in the file, AtriumCoreInstallingConfiguration.xml and AtriumCoreInstalled.xml and still get the same message. We think this is because it appears the installer overwrites that path We think the root cause might be the setup.bin, as we have noticed that the installer seems to append the bin directory to the java path. So our java path is usr/java/jre, however I think it is looking for java in the usr/java/jre/bin directory. Has anyone else experienced this issue or have any ideas how to get around the error? -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
CMDB 18_05 Installer fails
We are trying to upgrade from 8.1.02 to 18_05. We are running in a Solaris environment. ARS has upgraded and we are now trying the CMDB installer. It keeps failing with the error, "incorrect jre path", however you are never prompted to enter a jre path. We have tried modifying the path in the file, AtriumCoreInstallingConfiguration.xml and AtriumCoreInstalled.xml and still get the same message. We think this is because it appears the installer overwrites that path We think the root cause might be the setup.bin, as we have noticed that the installer seems to append the bin directory to the java path. So our java path is usr/java/jre, however I think it is looking for java in the usr/java/jre/bin directory. Has anyone else experienced this issue or have any ideas how to get around the error? -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
Re: Strange goings on with Attachments in form Report - 9.1.02 (& most probably prior)
With it described like that, it sounds like some kind of plugin at work. Jason On Fri, Oct 5, 2018 at 8:22 AM LJ LongWing wrote: > So, you have a record that can get the attachment no problem, but when you > look at the DB there is no B or BC entry for the attachment?if this is > true then the only way that can possibly be delivered is through the Remedy > server, meaning it's not stored in the db at all, it's stored in the Remedy > binaries and delivered as if it existed in the db. > > On Thu, Oct 4, 2018 at 5:56 PM Ben Chernys < > ben.cher...@softwaretoolhouse.com> wrote: > >> Hi LJ, >> >> >> >> The attachment field has both a name and contents. The GUI can save it >> no problem (as can Meta-Update now). >> >> Both the name and contents are delivered with GetEntry. GetBLOB returns >> no entry in database. There is no record in the B or BC table… >> >> >> >> > SthMqry -q select * from B140C212 where entryid = >> '842' >> >> 173747.521 i ArQryGet returns 0 records for select * from B140C212 >> where entryid = '842' >> >> >> >> > SthMsch Report | grep Attach >> >>212 Report Attachment Field(Report Definition File) Attach Max: 0 >> >> >> >> As for no way – of course there’s a way. It’s called code. There may be >> special code for this table. I have not seen this before in any other >> table and have saved many attachments from many different tables. >> Meta-Archive generates HTML with links to the attachments, so it’s been >> tested on ALL the ITSM modules. The Report table has not been part of the >> default Archive configs. >> >> >> >> Same results with “driver”. >> >> >> >> I highlighted the file name below in red. >> >> Cheers >> >> Ben Chernys >> >> www.softwaretoolhouse.com >> >> >> >> *From:* ARSList *On Behalf Of *LJ LongWing >> *Sent:* October-04-18 3:40 PM >> *To:* arslist@arslist.org >> *Subject:* Re: Strange goings on with Attachments in form Report - >> 9.1.02 (& most probably prior) >> >> >> >> For each Remedy form there is a T, H, and B tables >> >> T - Data >> >> H - Status History >> >> B - Binary (Attachments) >> >> >> >> B table is going to have a column for each attachment field, one each for >> the file name, original file size, compressed file size. >> >> >> >> For each attachment field there will be an additional table...if your >> table is 123 and your field id is 543 then your BC table would be >> >> B123C543 >> >> >> >> the BC table is the table that contains the actual attachment... >> >> >> >> So the B table contains the metadata regarding each of the attachments, >> the BC table contains the ACTUAL attachment >> >> >> >> so, you are saying that there is no B entry, but is there a >> BC?without the BC the Remedy server would have no way of giving you the >> contents of the file, without the B it has no way of telling you the name >> of the file... >> >> >> >> On Thu, Oct 4, 2018 at 2:50 PM Ben Chernys < >> ben.cher...@softwaretoolhouse.com> wrote: >> >> Hi LJ, >> >> >> >> Correct. The same will be on your system (if you have ITSM and perhaps >> if you have a whack of languages). >> >> The GUI handles it OK (as do I now). >> >> >> >> What’s a BC table? >> >> >> >> > SthMqry -q select * from BC140 where c1 = '842' >> >> 144304.453 E ARGetListSQL returned an error 2. Status messages: 1 >> >> 144304.453 E ARGetListSQL ==> 2, 552, The SQL database operation failed. >> ORA-00942: table or view does not exist >> >> >> >> /Ben >> >> >> >> *From:* ARSList *On Behalf Of *LJ LongWing >> *Sent:* October-04-18 2:36 PM >> *To:* arslist@arslist.org >> *Subject:* Re: Strange goings on with Attachments in form Report - >> 9.1.02 (& most probably prior) >> >> >> >> So, you are saying that you have a record in a table (Report) that's >> reporting that it has an attachment in an attachment field, but when you go >> look at the B table it's not showing there?...what about if you look in the >> BC table? Is the record there? >> >> >> >> On Thu, Oct 4, 2018 at 1:27 PM Ben Chernys < >> ben.cher...@softwaretoolhouse.com> wrote: >> >> Hi Folks, >> >> >> >> I discovered something curious about attachment fields. I've never had >> an attachment field which had a value (ie a file) with a non-null location >> in a myriad of tables. I got one such from the Report table. A type = >> buffer. Locations are used when updating attachment fields - or so I had >> thought. >> >> >> >> No matter, I was using getblob to create the file even if the buffer was >> already in memory for another reason (when I had done a getblob to a >> buffer). >> >> >> >> I now simply create the file myself when an attachment field comes in >> “already retried” in a buffer, so there are no problems with this. >> >> >> >> Presumably, these “special” attachments are identified simply by their >> non-null attachment location on retrieval. I would wager that if I update >> this attachment field, it would transform this record’s attachment into a >> normal
Re: Strange goings on with Attachments in form Report - 9.1.02 (& most probably prior)
So, you have a record that can get the attachment no problem, but when you look at the DB there is no B or BC entry for the attachment?if this is true then the only way that can possibly be delivered is through the Remedy server, meaning it's not stored in the db at all, it's stored in the Remedy binaries and delivered as if it existed in the db. On Thu, Oct 4, 2018 at 5:56 PM Ben Chernys < ben.cher...@softwaretoolhouse.com> wrote: > Hi LJ, > > > > The attachment field has both a name and contents. The GUI can save it no > problem (as can Meta-Update now). > > Both the name and contents are delivered with GetEntry. GetBLOB returns > no entry in database. There is no record in the B or BC table… > > > > > SthMqry -q select * from B140C212 where entryid = '842' > > 173747.521 i ArQryGet returns 0 records for select * from B140C212 > where entryid = '842' > > > > > SthMsch Report | grep Attach > >212 Report Attachment Field(Report Definition File) Attach Max: 0 > > > > As for no way – of course there’s a way. It’s called code. There may be > special code for this table. I have not seen this before in any other > table and have saved many attachments from many different tables. > Meta-Archive generates HTML with links to the attachments, so it’s been > tested on ALL the ITSM modules. The Report table has not been part of the > default Archive configs. > > > > Same results with “driver”. > > > > I highlighted the file name below in red. > > Cheers > > Ben Chernys > > www.softwaretoolhouse.com > > > > *From:* ARSList *On Behalf Of *LJ LongWing > *Sent:* October-04-18 3:40 PM > *To:* arslist@arslist.org > *Subject:* Re: Strange goings on with Attachments in form Report - 9.1.02 > (& most probably prior) > > > > For each Remedy form there is a T, H, and B tables > > T - Data > > H - Status History > > B - Binary (Attachments) > > > > B table is going to have a column for each attachment field, one each for > the file name, original file size, compressed file size. > > > > For each attachment field there will be an additional table...if your > table is 123 and your field id is 543 then your BC table would be > > B123C543 > > > > the BC table is the table that contains the actual attachment... > > > > So the B table contains the metadata regarding each of the attachments, > the BC table contains the ACTUAL attachment > > > > so, you are saying that there is no B entry, but is there a BC?without > the BC the Remedy server would have no way of giving you the contents of > the file, without the B it has no way of telling you the name of the file... > > > > On Thu, Oct 4, 2018 at 2:50 PM Ben Chernys < > ben.cher...@softwaretoolhouse.com> wrote: > > Hi LJ, > > > > Correct. The same will be on your system (if you have ITSM and perhaps if > you have a whack of languages). > > The GUI handles it OK (as do I now). > > > > What’s a BC table? > > > > > SthMqry -q select * from BC140 where c1 = '842' > > 144304.453 E ARGetListSQL returned an error 2. Status messages: 1 > > 144304.453 E ARGetListSQL ==> 2, 552, The SQL database operation failed. > ORA-00942: table or view does not exist > > > > /Ben > > > > *From:* ARSList *On Behalf Of *LJ LongWing > *Sent:* October-04-18 2:36 PM > *To:* arslist@arslist.org > *Subject:* Re: Strange goings on with Attachments in form Report - 9.1.02 > (& most probably prior) > > > > So, you are saying that you have a record in a table (Report) that's > reporting that it has an attachment in an attachment field, but when you go > look at the B table it's not showing there?...what about if you look in the > BC table? Is the record there? > > > > On Thu, Oct 4, 2018 at 1:27 PM Ben Chernys < > ben.cher...@softwaretoolhouse.com> wrote: > > Hi Folks, > > > > I discovered something curious about attachment fields. I've never had an > attachment field which had a value (ie a file) with a non-null location in > a myriad of tables. I got one such from the Report table. A type = > buffer. Locations are used when updating attachment fields - or so I had > thought. > > > > No matter, I was using getblob to create the file even if the buffer was > already in memory for another reason (when I had done a getblob to a > buffer). > > > > I now simply create the file myself when an attachment field comes in > “already retried” in a buffer, so there are no problems with this. > > > > Presumably, these “special” attachments are identified simply by their > non-null attachment location on retrieval. I would wager that if I update > this attachment field, it would transform this record’s attachment into a > normal value and a record would be created in the Bxxx table. – I shall do > that test shortly. > > > > > > Check out the Report form, there are a few records there with non-null > attachment fields AND no record in the Bxxx table. > > > > When data is retrieved from those records, the attachment value has a name > and the data
