Re: [E] Re: Strange goings on with Attachments in form Report - 9.1.02 (& most probably prior)

2018-10-10 Thread Grooms, Frederick W via ARSList 
Report may be a little different as there is a form "Report Definition"
that actually stores the definition attachment for a report

Fred

On Fri, Oct 5, 2018 at 10:49 AM Jason Miller  wrote:

> 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

Re: [E] Re: Table field refresh in Remedy 18.05

2018-10-10 Thread Grooms, Frederick W via ARSList 
When I do a new action for Change Field It comes up for Field Name.
Somehow your default seems to have changed to Field Value.  That does sound
like a corrupt workspace cache

On Wed, Oct 10, 2018 at 1:16 AM Carl Wilson  wrote:

> Hi Misi,
> Sometimes the Studio crashes and seems to corrupt the stored cache which
> then stops a number of things working.
> Creating a new workspace, or purging the old will rebuild the stored
> objects.
>
> Cheers.
>
> On Tue, 9 Oct 2018, 23:25 Misi Mladoniczky,  wrote:
>
>> Hi Carl!
>>
>> That seems to do the trick :-)
>>
>> Any idea why or when this can happen?
>>
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>> 
>> (ARSList MVP 2011)
>>
>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
>> Find these products, and many free tools and utilities, at http://rrr.se
>> 
>>
>>
>>
>>
>> October 9, 2018 10:44 PM, "Carl Wilson" > <%22carl%20wilson%22%20%3ccarlbwil...@gmail.com%3E>> wrote:
>>
>> Hi,
>> Try creating a new workspace in the Dev Studio and recreating you AL.
>> Cheers
>> On Tue, 9 Oct 2018, 21:38 Misi Mladoniczky,  wrote:
>>
>> Hi,
>>
>> I am on 18.05, Oracle, Linux.
>>
>> I am trying to do a simple table-refresh from an Active Link, but in Dev
>> Studio I can not even pick the Table-field for the Change Field action.
>>
>> If I load an old Active Link the table field shows, but it is underlined
>> with red and the action does not seem to trigger in Mid-Tier...
>>
>>
>>
>> So how are you supposed to do this? Am I doing some obvious mistake?
>>
>> When running Mid-Tier Active Link logging it looks like this, but the
>> refresh does not happen:
>>
>>
>> When choosing a column instead it looks like this in the Mid-Tier Active
>> Link logging, or in other words nothing happens:
>>
>>
>> Any suggestions?
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se
>> 
>> (ARSList MVP 2011)
>>
>> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13)
>> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
>> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs
>> Find these products, and many free tools and utilities, at http://rrr.se
>> 
>> --
>> 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
>> 
>>
> --
> ARSList mailing list
> ARSList@arslist.org
>
> https://urldefense.proofpoint.com/v2/url?u=https-3A__mailman.rrr.se_cgi_listinfo_arslist=DwICAg=udBTRvFvXC5Dhqg7UHpJlPps3mZ3LRxpb6__0PomBTQ=IuUzZpoH4G8vKkBa7TmXnNHc2-87dHrFn9R25Pv__1k=inHAvW7nOQwV74xyrwl6LkwV8dL4zKVZGH5X9Ah5Pcw=P5ukU_k0aZ8ABihCoosD6zWwLgFkMQaIBsrLcpW-mnw=
>


-- 

*Fred Grooms*
Senior Software Engineer *|* Network Systems - Service Assurance *|* XO
Communications - A Verizon Company  *|* www.xo.com

Verizon Certified SCRUM Master
*Office:* 972.578.6528 *|* *Fax:* 972.516.3556 *|* *E-mail:*
frederick.w.gro...@verizon.com
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist

New Idea in BMC Developer Communities

2018-11-26 Thread Grooms, Frederick W via ARSList 
https://communities.bmc.com/ideas/19399

In AR 9.x BMC has discontinued the arfork log file.  You'll notice from the
following link the arfork log is not described and in the screenshot it is
grayed out and unavailable:

https://docs.bmc.com/docs/ars91/en/setting-log-files-options-609073755.html
The log option does not appear on the Logs tab in the later releases
because it is no longer used

The arfork log file was the place to find the execution of an external Run
Process command
   Tue Nov 20 07:54:49 2018 Received record marker.
   Tue Nov 20 07:54:49 2018 Spawning child, shell "", command "{FULL
COMMAND LINE}".
   Tue Nov 20 07:54:49 2018 Spawned "{FULL COMMAND LINE}" as pid 56744.
   Tue Nov 20 07:54:49 2018 Awaiting record marker.
   Tue Nov 20 07:54:49 2018 process id 56744 has exited with status 0x0.

This idea is for BMC to bring back logging the external run process actions
in some log file (my preference would be the Thread log file if they do not
wish to use the arfork log again)

Please vote up
Fred
-- 
ARSList mailing list
ARSList@arslist.org
https://mailman.rrr.se/cgi/listinfo/arslist