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 <arslist-boun...@arslist.org> 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 <mailto: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 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 ARSList@arslist.org <mailto:ARSList@arslist.org> https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist
