Error type DuplicateID - row skiped

Suite and Optimus Suite 5
#1

Hi

I have a treegrid that loads a list of file names. The list can be fairly long so I have activated pagination, 20 names per page, 10 pages per group.

Files in the list can depend on another file, so there can be a one-level dependency (i.e. a file can have a parent file, but the parent file cannot be a child file itself).

Depending on the data that needs to be presented, the grid returns a Javascript error
“Error type: DuplicateID
Description: Not unique ID :: 17960, row skiped”.

This error message is repeated many times when clicking the OK button on the popup window, it seems that the grid is trying to add the “duplicate” item on each page.

The problem doesn’t always occur, it seems that it only happens if the child document no longer fits on the first page so that parent and child document get separated in display.

Does anybody have the same issue and know a solution for this problem?

Cheers
Theo

#2

Unfortunately the issue cannot be reproduced locally.
Please provide a complete demo, where the issue can be reconstructed.
Here you can find a tutorial:
docs.dhtmlx.com/doku.php?id=othe … leted_demo

#3

It is not so easy to extract a full demo out of the large application, but maybe it helps to see the code of the grid definition and I’ll attach the XML content that is loaded.

		mygrid = new dhtmlXGridObject('gridboxFileTransfer');
		mygrid.enableDistributedParsing(false);
		mygrid.preventIECaching(false);			// The default but lets be explicit to be sure...
		mygrid.enableSmartXMLParsing(false);
		mygrid.imgURL = contextPath + '/images/dhtmlx/xgrid/';
		mygrid.setHeader("No.,File name,User,Show,Status,Type,Created,Updated,Size,Download");
		if (userIsUploadMgr)
			mygrid.setInitWidths("60,280,100,30,100,130,130,130,100,90"); // total of 1150 plus 2 for the border -> container should have size 1152!
		else
			mygrid.setInitWidths("60,300,0,0,150,150,150,150,100,90"); // total of 1150 plus 2 for the border -> container should have size 1152!
		mygrid.setColAlign("right,left,left,left,left,left,right,right,right,left");
		mygrid.setColTypes("ro,tree,ro,ro,ro,ro,ro,ro,ro,link");
		mygrid.setColSorting("int,str,str,str,str,str,date,date,str,str");
		mygrid.enableResizing("false,false,false,false,false,false,false,false,false,false");
		mygrid.enableTreeCellEdit(false);
		mygrid.enableColumnAutoSize(true);
		mygrid.setSkin("xp");
		mygrid.enableRowsHover(true,'grid_hover') ;
		mygrid.enableAlterCss("a1","a2",false,false);
		mygrid.enableMultiselect(true);
		// add paging
		mygrid.enablePaging(true,20,10,'paging',true,'pagingstate');
								
		mygrid.init();
		mygrid._fixAlterCssTGR();
		mygrid.kidsXmlFile = contextPath + '/pages/filetransferlist.faces';
		mygrid.loadXML(contextPath + '/pages/filetransferlist.faces');
#4

Thank you.
Now, please, provide the generated xml files that populate data to your treegrid.

#5

Please, make sure that each row in your grid is really have a unique id.

#6

how to attach the file, it doesn’t allow extension xml, nor txt.

#7

You may add your file to a zip/rar archive.

#8

much better, cheers. Always nice if you know what to do…
ft.zip (25.4 KB)

#9

Unfortunately the issue cannot be reproduced locally.
Your code works well for us with the provided xml.
If issue still occurs - please, provide with a demo link or a complete demo, where the issue can be reconstructed.
Here you can find a tutorial:
docs.dhtmlx.com/doku.php?id=othe … leted_demo

#10

Thanks for looking into this.

The issue still occurs. In fact, I have been able to reproduce the issue in our test system (the original error occurred in the production environment).

I added 23 files to our system, for each of those files the back-end produced a child document, so that there are now at least 46 documents to be displayed.
It turns out that the grid wants to display 20 parent documents with their children on the first page. The child document of the last document (document no. 20) is not displayed and is the one where the grid complains. Only 39 lines are visible after I have clicked away all the pop-up error messages.

I can’t send you a full demo, as the page wouldn’t work without our database. Would you be able to do a webex so that I can show you what is happening?
Is it possible that the size of the containing DIV is too small?

#11

Would you be able to do a webex so that I can show you what is happening?
Unfortunately it’s not available. You may provide a demo link.

Is it possible that the size of the containing DIV is too small?
no. the sizes of the grid’s container shouldn’t occur any issue.

#12

Hi

finally I have been able to extract the component into a separate demo application that reproduces the error. Can you please have a look at this?

Cheers
Theo
CompleteDemo.zip (460 KB)

#13

Please, try to update the version of your dhtmlxGrid.
In your demo there are files from version 1.4. Unfortunately such version is not supported anymore.

#14

I understand the older version not being supported, but as you know the code better than I do, would it be possible to patch this error?

Unfortunately it’s not available to create a solution for your version of dhtmlx.

If I upgrade, can I just download the whole package? Which version do I have to take? What are the costs involved?

Please, try to use 3.0 version at least. It is recommended to get the latest version of dhtnmx (3.6 at now) as it is fully compatible with Internet Explorer 10, also it is guaranteed that you’ll get the latest fixes.
Please, contact sales[AT]dhtmlx.com to know the details.