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 < [email protected]> 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 = '000000000000842' > > 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 <[email protected]> *On Behalf Of *LJ LongWing > *Sent:* October-04-18 2:36 PM > *To:* [email protected] > *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 < > [email protected]> 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 in a buffer. > > > > When an update to an attachment field is made, no matter if a buffer or > file is used, a new record is added to the Bxxx table. > > > > How is this attachment different than all the others? > > > > [image: Note untranslated value in Report Name & Short Description – a > responsibility of the API. Note also that this is in Korean but the same > file appears in multiple records, presumably most are normal attachments > since all records have attachments and only a few come with the location > already retrieved and an Entry not found when executing the Get_BLOB f().]Data > from my 9.1.02 system: > > > > 04/10/2018 13:10:35 > > e:\ > SthMry -S Report "'1' = \"000000000000842\"" > > om 1 matches) in Report > > <ArIds returned start> > > <Id: 000000000000842 →→ →→→ nullWeb > nullCBK:ChargeBack null802; null2 > null> > > <ArIds returned end > > > <-------------------->000000000000842 > > Request ID 000000000000842 > > Submitter BMC Software > > Create Date 2003/01/24 13:14:58 > > Assigned To > > Last Modified By AR_ESCALATOR > > Modified Date 2015/04/09 15:27:04 > > Status Active > > Short Description →→ →→ →→ →→→ > > Status History 1043439298♦dev_caga♥♥ > 1482978799♦Action Request Installer Account♥ > > Assignee Groups 802; > > Locale ko > > Instance ID AG0050569E2243w0gPSAayxAdASvcH > > Assignee Groups_Parent > > zFormIdentificationMarkerField > > Form Name CBK:ChargeBack > > Report Type Web > > Report Attachment Field CBK_Adjustment.rptdesign > > Report Set Name Adjustment Report > > Server %% > > Override Query No > > Report Name →→ →→→ > > Designer Version > > Lock Override Option Yes > > Visible In Console No > > zTempInstanceCount > > Report Parameters > > Base Qualification '179' != $\NULL$ > > Date Range Field ID > > Date Range Report No > > Datatag config-fin > > Category 1 > > Category 2 > > Category 3 > > > > > > > mqry -q select schemaid from arschema where name='Report' > > "001" > > <-------------------->SQL row: 1 > > Col 0: 140 > > > > > mqry -q select * from B140 where c1 = '000000000000842' > > 131548.456 i ArQryGet returns 0 records for select * from B140 where c1 = > '000000000000842' > > > > > > Cheers, > > Ben Chernys > Senior Software Architect > [image: logoSthInc-sm] > > Canada / Deutschland > Mobile: +49 171 380 2329 GMT - 7 + [ DST ] > > Mobile +1 403 554 0887 > Email: Ben.Chernys_AT_softwaretoolhouse.com > <Ben.Chernys_AT_softwaretoolhouse.com> > > Web: www.softwaretoolhouse.com > > We are a BMC Technology Alliance Partner > > > > > > Check out Software Tool House's free Diary Editor and our Freebies > Section for ITSM Forms and Fields spreadsheet. > > *Meta-Update <http://www.softwaretoolhouse.com/product/SthMupd/index.html>* > *,* our premium ARS Data tool, lets you automate your imports, > migrations, *in no time at all*, without programming, without staging > forms, without merge workflow. > > > > *Meta-Archive > <http://www.softwaretoolhouse.com/product/SthArch/index.html>* does ITSM > Archiving your way: with your forms and your multi-tenant rules, treating > each root request as a complete tree and checking associatuions. Archive > output to different servers, HTML pages with links to attachments or > archive forms. > > > > *Meta-Databot > <http://www.softwaretoolhouse.com/product/Databot/index.html>* is an > automated, extensible BMC Data Wizard. It reads a file of data changes and > sports an Undo feature. > > > > Pre ITSM 9.1.04? Clarify? HP? Roll your own? No problem! You can keep > your valuable data! > > > http://www.softwaretoolhouse.com/ > > > > > > > > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
