HelpForum

Forum (Archive)

This forum is kept largely for historic reasons and for our latest changes announcements. (It was focused around the older EPPI Reviewer version 4.)

There are many informative posts and answers to common questions, but you may find our videos and other resources more informative if you are an EPPI Reviewer WEB user.

Click here to search the forum. If you do have questions or require support, please email eppisupport@ucl.ac.uk.

<< Back to main Help page

HomeHomeUsing EPPI-Revi...Using EPPI-Revi...Questions about...Questions about...[Arg_NullReferenceException] in Crosstabs[Arg_NullReferenceException] in Crosstabs
Previous
 
Next
New Post
17/02/2017 12:53
 

Hi,

I am currently having an issue with the crosstab option. It returns an error with the following text:

[Arg_NullReferenceException]

This occurs when I perform a crosstab operation with the same code set in the X-axis and Y-axis. I am looking to get an overview for which codes occur simultaneously. I tried a few things and found the following:

Assuming X*Y axis orientation and the two code sets A and B (A being the problematic one).

When using the crosstab function the outputs are the following:

A*A = Error

B*B = Output

B*A = Output

A*B = Error

Is there a fix for this?

Joeri

 

 
New Post
17/02/2017 13:58
 

Hello Joeri,

this looks very much like a bug: there is probably something unusual about the codeset "A" that causes a problem when it is placed on the X axist. I did a few preliminary tests in your review and could replicate the problem, I can also add that the error appears only when there is some data to report, if the crosstab is empty, no errors are shown.
Unfortunately there is no obvious visible cause for this, which means that I'll need to spend some time investigating. Will report back when I'll know more. In the mean time, I hope you can find a workaround; please do let us know if you think we can provide some extra help while we're investigating the issue.

Thanks, with my apologies for the inconvenience,
Sergio

 
New Post
17/02/2017 15:10
 

Hello Joeri,
I've figured out what is happening. In a nutshell, comparisons can handle up to 50 codes on the X axis, if more are included, the error would show up. Moreover, the data-structures that carry over the information are hard-limited to 50 codes, so even if I wrote something to avoid generating the error, the data shown would be incomplete.

This points to a possible workaround: you could move some of your codes from the root of the codeset and into an ad-hoc (container) child code. I think your root level currently contains 76 codes, so moving 26 of them into a new child code created for this purpose should work. Of course, proceeding in this way means you will have to produce multiple crosstabs, while operating on the "flatter" original codeset could have worked in a single go.

In case you need to preserve the current codeset shape, you could re-move the codes back into their original location after collecting the required crosstabs.

I do realise that this is far from ideal, but it's the only quick solution I can offer. I will discuss possible permanent resolutions with my colleagues, but I can anticipate that we won't be able to make such a solution available in a matter of days. More likely it would take a few weeks (would require to publish a new version) and perhaps more.

Please do let us know whether the proposed workaround doesn't fit your needs or if it doesn't actually work (in case I've missed another catch!). I haven't tried myself because it would require to interfere with your work/data.

With my apologies once more,
Sergio

 
New Post
20/02/2017 07:50
 

Hello Sergio,

Thank you for looking into this issue. I will take a look into the solution you suggested.

Is there a possibility to export all code data to an excel/another file? Something as in the format below:

Refference     Code A       Code B      Code C

Smith et al.      x                x                x

Graaf et al.      x                                  x

etc.

I ask this because from within the Eppi software I have not found the possibility to get an overview of which articles have which code.

I ask this because I am not sure it is possible trace which codes belong to which article when splitting the code set in the workaround you proposed.

I will let you know if it does work out.

Greetings,

Joeri

 

            

 

 
New Post
20/02/2017 11:09
 

Hello Joeri,

You should be able to create a report similar to that in the Reports tab. If you set up an 'Answer' report and put each code in its own column you will get the code displayed in that column (if that code was selected during coding). You could then save the report as and html file and open it in excel so you have it in a table format.

If you are unsure about how to set this up just let me know and I can explain it in more detail.

Best regards,

Jeff

 
New Post
22/02/2017 12:33
 

Hello,

I have tried the previously mentioned solutions and they seem to work for the most part. However, when I try to run one of the reports i get the following alert:

system.outofmemoryexception

If this on my end (my pc/system)? Or is it something else?

Greetings,

Joeri

 
New Post
22/02/2017 15:14
 

Hello Joeri,

If the report is very very large then it might be a resource issue on your computer. The report is displayed in your browser and if the size of your report is such that it uses up all of your computers memory (ram) before it can finish displaying the report you might get that message.

If you can let me know the report and the items you are trying to include in the report I can have a look at it to see what might be going on.

Best regards,

Jeff

 

 
Previous
 
Next
HomeHomeUsing EPPI-Revi...Using EPPI-Revi...Questions about...Questions about...[Arg_NullReferenceException] in Crosstabs[Arg_NullReferenceException] in Crosstabs


Copyright 2021 by EPPI-Centre :: Privacy Statement :: Terms Of Use :: Site Map :: Login
Home::Help::EPPI-Mapper::RIS Export::About::Account Manager