HD93163: Solidworks integration crashes on old files after migration to R 19SP6

APAR status

• Closed as user error.

Error description

• Scenario :- For detail scenario please open attached word docume
  nt
  FE Confirmed & Accordingly Modified Scenario :-
  1) Run SmarTeam, login Joe (no password)
  2) Launch the search ?? 57682K ?? of groupe ?? Pb migration ??,
  3) Select line 57682K indices 01,
  4) Click on the tab viewer to see that the file exists and is di
  splayed in edrawing.
  5) Go back on tab ?? Attributes ??, then run the command ?? File
   operation/Open for ??
  6) Choose option ?? Open for edit ??,
  7) In the life cycle window, just click Ok
  8) File is opened in Solid works and seems normal,
  9) Activate the Data Manager of SmarTeam, A black square, as rep
  orted in the customer scenario is NOT displayed, But SmarTeam/So
  lid Works integration is NOT working (As shown in the below scen
  ario ST-LCO ???Checkin??? and ???release??? are available but th
  ese operations are not working anymore),
  10) Close SmarTeam and Solid Works, Repeat step 1 to 9 but choos
  e the drawing linked to part 57682K,
  11) Activate the Data Manager SmarTeam; Drawing & part is correc
  tly displayed. But SmarTeam/Solid Works integration is NOT worki
  ng (As shown in the below scenario ST-LCO ???Checkin??? and ???r
  elease??? are available but these operations are not working any
  more),
  12) Repeat same step but with the search 100503, Result is the s
  ame, file is open in SW but integration is KO.
  13) Repeat same step but with the search 100511, this time, inte
  gration is working fine.
         I tried for ???ST-LCO checkin??? & found that it works co
  rrectly,
  Current Result: - There is problem of integration, ST-SW integra
  tion not working anymore on some old files [57682K & 100503] cre
  ated before migration.
  Expected Result:- ST-SW integration should get working with old
  files [57682K & 100503]
  

Local fix

• empty
  

Problem summary

Problem conclusion

Temporary fix

Comments

• The problem is ocurring due to database problem
  Please observe the TN_DOCUMENTATION table for entries of the
  SW files
  In this table please observe the value under CN_NW_COCHE_MALT
  column for problematic SW
  documets we will observe they have value as "0".
  The value 0 is incorrect. As this is lookup value and it
  should have three values as NULL,1
  and 3 as correct value, For correct values please observe
  table TN_YESNO.
  Fix :For problematic SW documents please update the value for
  CN_NW_COCHE_MALT
  column as -2147483647 in TN_DOCUMENTATION table.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels