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 B140C2000012 where entryid = '000000000000842' 173747.521 i ArQryGet returns 0 records for select * from B140C2000012 where entryid = '000000000000842' > SthMsch Report | grep Attach 2000012 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 <[email protected]> On Behalf Of LJ LongWing Sent: October-04-18 3:40 PM To: [email protected] 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 <[email protected] <mailto:[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] <mailto:[email protected]> > On Behalf Of LJ LongWing Sent: October-04-18 2:36 PM To: [email protected] <mailto:[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] <mailto:[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? 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 Canada / Deutschland Mobile: +49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email: <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Ben.Chernys_AT_softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> 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/> http://www.softwaretoolhouse.com/ -- ARSList mailing list [email protected] <mailto:[email protected]> https://mailman.rrr.se/cgi/listinfo/arslist -- ARSList mailing list [email protected] <mailto:[email protected]> https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
