View Issue Details

IDProjectCategoryView StatusLast Update
0000268CaseTalk ManagerSQL Serverpublic2013-05-14 20:38
ReporterBCP Software 
Assigned ToBCP Software 
PrioritynormalSeveritymajorReproducibilitysometimes
Status resolvedResolutionfixed 
Product Version1.0.3 
Target Version2.1Fixed in Version2.1 
Summary0000268: IG disappears from treeview after checkin
DescriptionAfter checking in an additional IG, another may disappear from view.
Steps To Reproduce1) Add IG called 'A' into a project in the Manager.
2) Add IG called 'B' into the same project

IG 'A' may appear to be gone.
TagsNo tags attached.

Relationships

Activities

BCP Software

BCP Software

2013-05-14 20:25

administrator   ~0000165

Execute the following query on the Manager's database to detect wrong version information in the database:

-- select all wrong versioned items:

select
  i.item_number,
  i.item_current_version,
  (select max(item_version) from ctk_item_version iv where iv.item_number = i.item_number) as item_current_version_FIX
from ctk_item_version v
join ctk_item i
  on i.item_current_version = v.item_version
 and i.item_number <> v.item_number
BCP Software

BCP Software

2013-05-14 20:26

administrator   ~0000166

Last edited: 2013-05-14 20:27

View 2 revisions

If the above returns a result, please correct the rows with the following update statement. It does not affect the data itself and only updates the current_version reference.

-- fix by updating wrongly versioned items:

update ctk_item
  set ctk_item.item_current_version = fix.item_current_version_FIX
from
  ctk_item
join
    (
    select
      i.item_number,
      i.item_current_version,
      (select max(item_version) from ctk_item_version iv where iv.item_number = i.item_number) as item_current_version_FIX
    from ctk_item_version v
    join ctk_item i
      on i.item_current_version = v.item_version
     and i.item_number <> v.item_number
    ) fix
on ctk_item.item_number = fix.item_number

BCP Software

BCP Software

2013-05-14 20:38

administrator   ~0000167

Please execute the queries attached in this issue to fix existing version reference errors in your database.

Issue History

Date Modified Username Field Change
2013-05-14 20:24 BCP Software New Issue
2013-05-14 20:24 BCP Software Status new => assigned
2013-05-14 20:24 BCP Software Assigned To => BCP Software
2013-05-14 20:25 BCP Software Note Added: 0000165
2013-05-14 20:26 BCP Software Note Added: 0000166
2013-05-14 20:27 BCP Software Note Edited: 0000166 View Revisions
2013-05-14 20:38 BCP Software Note Added: 0000167
2013-05-14 20:38 BCP Software Status assigned => resolved
2013-05-14 20:38 BCP Software Fixed in Version => 2.1
2013-05-14 20:38 BCP Software Resolution open => fixed