concepts->timeline error

[Paul Fernandez]

Consistently, whether from a direct search result or a related profile, when going to the Concepts page, e.g.

https://profiles.sdsu.edu/display/222918/network/researchareas/timeline

The raw HTML looks like this:

<span id="ctl00_rptMain_ctl00_ctl00_litError" style="display:inline-block;width:800px;">MESSAGE: Object reference not set to an instance of an object.
SOURCE: Profiles
FORM:
QUERYSTRING: </span>

I've seen other references to "Object reference not set to an instance of an object" but not quite like this.  Is this a data issue? 

 

Paul 

[Brown, Nicholas William]

Paul

 

Looking at your site, it appears that the firstname and lastname data is not coming through to the website. These values should populate the name value on the co-authors pages, and this is missing on your site. This also populates the name in the help text on the Cluster and Timeline tabs, there is no error catching for this, which is what I believe is causing the errors you are seeing. Firstname and lastname do appear in the RDF for your site, so I’m not certain yet why this isn’t coming through to these pages.  This may be the same issue that Brandon was asking about last week, I am still working with him to troubleshoot that issue. I’ll keep you updated if I figure anything out there.

 

Can you send me the results of the following queries so I can check the values are correct:

 

SELECT * from [Ontology.].[ClassProperty]

  where property like '%foaf%'

 

SELECT * FROM [Ontology.].ClassPropertyCustom where property like '%Foaf%'

 

Thanks

 

Nick

--
You received this message because you are subscribed to the Google Groups "ProfilesRNS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to profilesrns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/profilesrns/CACT3x%2BUJQec5RDS87py_Cy-hfL0HgGvN1X11miw%3DoS4E7pNCQA%40mail.gmail.com.

[Paul Fernandez]

First query:

ClassPropertyID	Class	NetworkProperty	Property	IsDetail	Limit	IncludeDescription	IncludeNetwork	SearchWeight	CustomDisplay	CustomEdit	ViewSecurityGroup	EditSecurityGroup	EditPermissionsSecurityGroup	EditExistingSecurityGroup	EditAddNewSecurityGroup	EditAddExistingSecurityGroup	EditDeleteSecurityGroup	MinCardinality	MaxCardinality	CustomDisplayModule	CustomEditModule	_ClassNode	_NetworkPropertyNode	_PropertyNode	_TagName	_PropertyLabel	_ObjectType	_NumberOfNodes	_NumberOfTriples
838	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/firstName	0	NULL	0	0	0.1	1	0	-1	-40	-40	-40	-40	-40	-40	0	NULL	NULL	NULL	1007	NULL	2060	foaf:firstName	first name	1	46	46
839	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/lastName	0	NULL	0	0	0.5	1	0	-1	-40	-40	-40	-40	-40	-40	0	NULL	NULL	NULL	1007	NULL	2069	foaf:lastName	last name	1	46	46

second query:

ClassPropertyCustomTypeID	Class	NetworkProperty	Property	IncludeProperty	Limit	IncludeNetwork	IncludeDescription	IsDetail	_ClassPropertyID
1	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/firstName	NULL	NULL	NULL	NULL	1	838
1	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/lastName	NULL	NULL	NULL	NULL	1	839
3	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/firstName	0	NULL	NULL	NULL	NULL	838
3	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/lastName	0	NULL	NULL	NULL	NULL	839
4	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/firstName	0	NULL	NULL	NULL	NULL	838
4	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/lastName	0	NULL	NULL	NULL	NULL	839
5	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/firstName	0	NULL	NULL	NULL	NULL	838
5	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/lastName	0	NULL	NULL	NULL	NULL	839
6	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/firstName	0	NULL	NULL	NULL	NULL	838
6	http://xmlns.com/foaf/0.1/Person	NULL	http://xmlns.com/foaf/0.1/lastName	0	NULL	NULL	NULL	NULL	839

Thank you

Paul Fernandez

SDSU HealthLINK Center for Transdisciplinary Health Disparities Research
San Diego State University Research Foundation

To view this discussion on the web visit https://groups.google.com/d/msgid/profilesrns/MN2PR07MB72956030200FEC7E57DFDB7EA6030%40MN2PR07MB7295.namprd07.prod.outlook.com.

[Tim VanWagoner]

We are having the same problem as this. Was there any resolution to this issue? Doesn't occur on a new test database, so something definitely in our main profilesRNS database.

Thanks

[Brown, Nicholas William]

Tim

I don't remember what the fix was in the referenced issue. I'm happy to help you troubleshoot this though. 

I think the most likely issue was that the class property custom table could be configured incorrectly. I would start by running 

SELECT * FROM [Ontology.].ClassPropertyCustom where property like '%Foaf%'

On both the working and the problem databases and comparing the results. Looking at the results below, I think that first and last names would be skipped by the classpropertycustom table for network pages. I would check that the values are the same on both databases, particularly the IncludeProperty column.

Nick

---

From: profi...@googlegroups.com <profi...@googlegroups.com> on behalf of Tim VanWagoner <tim.van...@gmail.com>
Sent: Wednesday, January 22, 2025 10:10 AM
To: ProfilesRNS <profi...@googlegroups.com>
Subject: Re: [ProfilesRNS] concepts->timeline error

 

To view this discussion visit https://groups.google.com/d/msgid/profilesrns/b280353e-3f96-4d4e-bf60-0d97b896c28fn%40googlegroups.com.

[Tim VanWagoner]

Thanks. Everything is effectively the same between databases. I'll keep trying other things. 

[Tim VanWagoner]

For what it is worth, it turns out that it is working fine for all newer users added in the past few years, but not for older users. I suspect something wrong in the database. If one might have some ideas how to identify the likely errors, that would be great. 

On Wednesday, January 22, 2025 at 9:39:04 AM UTC-6 nichola...@hms.harvard.edu wrote:

[Tim VanWagoner]

For anyone else that has this happen, I was able to fix my particular situation. It turns out there were many nodes with broken links caused by a bad URL change sometime in the past. Fixing all of those has seemed to correct this issue for me.