Toggle Sidebar
  • Recent updates
    • Post is under moderation
      This "GIT CONNECTOR" doesnt use a "pure" git client. You need to install a Dimensions client tools on client side. In fact, the name should change to "dimensions client for git". The real "connector" ...to use just the git client is the bridge. More
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      Dave Meier
      Dave Meier is now friends with JOAO ANDRES DE BRITO VALLE
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      JOAO ANDRES DE BRITO VALLE
      Dimensions does not check if a revision being actioned to last state (production) was retrieved (checked-out) from previous revision in production. So developers may use a deprecated revision and prom...ote it to production causing erros. Our company works on large systems, with many suppliers, with large teams in paralel development. For example, we have different teams and suppliers to treat incidents and other to work with new projects. Initially we got some cases of "dirty writes" in production, causing error recurrence. This happens because any human verification is error prone. Dimensions sends emails to warn developers, but sometimes due lots of mails this issue may not be noticed. Like a database with many users accessing same record at same time, if one of these users write back, other users must be warned to avoid overwite data. They must retrieve record again (latest revision) to analyze and merge with latest changes. The bellow query may be used to check if items related in package (CR) was got form latest revision, actioned to last state in normal lifecycle. We use it on API and reports to check this kind of issue. select cmc.ch_doc_id, isc.product_id||':'||isc.obj_id||'.'||isc.variant||'-'||ot.type_name||';'||ic.revision from item_action_history iahs, item_spec_catalogue isc, item_catalogue ic, obj_types ot, cm_impacts cmi, cm_catalogue cmc where cmc.ch_uid=cmi.ch_uid and isc.product_id=ot.product_id and isc.type_uid=ot.type_uid and cmi.impact_type='I' and cmi.affect_uid=ic.obj_uid and ic.obj_spec_uid=isc.obj_spec_uid and cmi.affect_uid = (select max (cmi_s.affect_uid) from cm_impacts cmi_s,item_catalogue ic_s where cmi_s.affect_uid = ic_s.obj_uid and ic_s.obj_spec_uid = ic.obj_spec_uid and cmi_s.ch_uid = cmc.ch_uid and cmi_s.impact_type = 'I') and ic.obj_spec_uid = iahs.obj_spec_uid and TO_CHAR(iahs.date_time,'yyyymmddhh24miss')||iahs.obj_uid=(select MAX(TO_CHAR(iahs2.date_time,'yyyymmddhh24miss')||iahs2.obj_uid) from item_action_history iahs2 where iahs2.new_status = (select status from norm_lifecycle nl1 where nl1.lifecycle_id=ot.lifecycle_id and nl1.state_seq_no=(select max(nl2.state_seq_no) from norm_lifecycle nl2 where nl2.lifecycle_id=ot.lifecycle_id)) and iahs2.obj_spec_uid = iahs.obj_spec_uid) and (select sum(decode(obj_uid, iahs.obj_uid,1,0)) from item_revision_history where history_type 'U' and history_type 'D' start with obj_uid = ic.obj_uid connect by obj_uid = PRIOR decode(prev_obj_uid,obj_uid, null,prev_obj_uid) and history_type 'U' and history_type 'D') = 0 --subquery to remove change requests on last status. comment if necessary and cmc.status!=(select status from norm_lifecycle nl1, obj_types ot1 where nl1.lifecycle_id=ot1.lifecycle_id and ot1.type_uid=cmc.type_uid and nl1.state_seq_no=(select max(nl2.state_seq_no) from norm_lifecycle nl2 where nl2.lifecycle_id=ot1.lifecycle_id)) -- instead of product id, force use index to scan all product and cmc.ch_doc_id like 'ARBOR%' --specific change request and cmc.ch_doc_id='ARBOR_CR_NORMAL_2423' More
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      There's no way to restrict security to run reports by user or group. And there's no way to identify wich user is runnig report. Some reports may have sensitive information or execute procedures that a...re not intended to all users. Dimensions Run User Reports can be used to get custom information or to automate tasks in dimensions through scripts, but there's no way to limit access to some groups or users. Thre'res no security, information about user running current report it or even event in DTK api to check wich user is running it. More
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      JOAO ANDRES DE BRITO VALLE
      Newbie
      Congrats on registering on the site!
      Stream item published successfully. Item will now be visible on your stream.
    • Post is under moderation
      JOAO ANDRES DE BRITO VALLE
      JOAO ANDRES DE BRITO VALLE just registered on the site
      Stream item published successfully. Item will now be visible on your stream.
  • No blogs available.

  • DateTitle
    23/09/2015 Avoid "dirty write" in production environment
    22/09/2015 Run User Reports lacks user identification or security access