This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Row sequence (position rows) is not updated in the new databases
15-04-2015, 11:30 AM, (This post was last modified: 06-07-2015, 01:21 PM by shaswin.)
#1
Row sequence (position rows) is not updated in the new databases
Affected version: Ple4Win Professional v4.2.x

When a user updates it PLEX database to a new PLEX database. The row sequence position of the tables are not updated conform the row sequence (position rows) of the new database (row sequence of a clean healthy database). The old row sequence is somehow also imported. Due to automation the row sequence in the new database should be the same in updated database with a healthy database or according to the UDM settings file.
19-05-2015, 02:25 PM,
#2
RE: Row sequence (position rows) is not updated in the new databases
I am not sure I understand your problem. Could you elaborate, or give a screenshot of the old / new row sequence (I presume you mean the sequence of tables in the Overview-pane?)
20-05-2015, 09:15 AM,
#3
RE: Row sequence (position rows) is not updated in the new databases
Yes, this happens in the table rows in the Overview panel.
Rows are not always ordered in the same sequence order (between updated project file (pre v4.3.1) and healthy project file (v4.3.1)), especially the output tables rows.

For example the PROFILE row is not always in the same location.
27-05-2015, 01:59 PM,
#4
RE: Row sequence (position rows) is not updated in the new databases
Apparently there is a problem with the update data. To tackle this problem it is important to know the original version of the pre-4.3.1 project. Was it a 4.3.0 project, or an earlier version?
27-05-2015, 02:12 PM, (This post was last modified: 27-05-2015, 02:13 PM by shaswin.)
#5
RE: Row sequence (position rows) is not updated in the new databases
An earlier version (4.2.3).
15-06-2015, 10:10 AM,
#6
RE: Row sequence (position rows) is not updated in the new databases
Sorry, I can't reproduce this issue. As far as I can tell, all older projects starting from version 4.2.0 are correctly updated.

In DF2, the sequence of input tables (after update to v 4.3.1) should be:
ORIGIN, POLYDIF, CONNECT, TEECONF, SISCONF, PIPES, SUPPORT, G-LEVEL, W-LEVEL, ADIDENT, GROUPS

In DF2, the sequence of output tables (after update to v 4.3.1) should be:
SHAPEP, SHAPEB, LENGTH, NODES, ELEMNTS, CONDATA, T-CDATA, PROFILE, IDENTS, GRELEM, AVGRPS

If you can reproduce a situation where this sequence is not correct after update, please let me know and preferably also send the original (not updated) project file to me. Thanks.
29-06-2015, 07:53 AM, (This post was last modified: 29-06-2015, 08:00 AM by shaswin.)
#7
RE: Row sequence (position rows) is not updated in the new databases
Jens,

I have a same situation in DF6.2 for the additional output tables, see screenshots. The original database was based on an earlier version then 4.2.0.

Updated pre-v4.3.1:
   

Original v4.3.1:
   

The sequence order is not the same. Look the location of the TSTRESS row.

I have attached the project file in this post.
The sequence of the output tables in DF2 are not correct in the same way. But in this case (attached project file) the sequence order of the output tables in DF2 is correct.


Attached Files
.zip   DF6.2.zip (Size: 913.24 KB / Downloads: 2)
29-06-2015, 01:42 PM,
#8
RE: Row sequence (position rows) is not updated in the new databases
Thanks a lot, this helped to track down the problem: There was a typo in the update data from version 4.2.2 to version 4.2.3, which lead to the situation that the "rank" of the RDPLNEN and NENSTRS table was not updated. I assigned ticket no. J-1746 to this bug.
29-06-2015, 01:52 PM, (This post was last modified: 01-07-2015, 08:28 PM by shaswin.)
#9
RE: Row sequence (position rows) is not updated in the new databases
Nice to see that you have tracked the problem down. Does this "rank" or similar problem also apply for DF2?
The PROFILE output table in DF2 was also not on the same location.
29-06-2015, 02:44 PM,
#10
RE: Row sequence (position rows) is not updated in the new databases
I could not find any error concerning the PROFILE table. Its "rank" (the position in the grid in the overview pane) was only changed in v4.3.0 because the CONDATA table was added. So all tables below that (T-CDATA up to AVGRPS) had to move down one position. That seems to work okay, in your sample project as well.


Forum Jump:


Users browsing this thread: 2 Guest(s)