Custom content type and Reporting

Former Member over 2 years ago

We have our custom content type with thousands of items.
But in Reporting extension I don't see any or see 1-2 of it.
I didn't do anything special to integrate that content type with Reporting. Should I do? And how can I do that?

PS I can see my custom Application Type in Report's filters

Top Replies

Christopher G. Stanton over 2 years ago in reply to Brian Dooley +1

Would not implementing IActivityStoryContentType mean it wouldn't appear in the Activity widget?
Brian Dooley over 2 years ago in reply to Christopher G. Stanton +1

Yes, if you do not implement IActivityStoryContentType, for custom content, it will not create an activity story when new content is created.

Parents

No Data

Reply

0 Former Member over 2 years ago in reply to Brian Dooley

Well.
I tested on my local and see same situation.

I found my custom content in ReportingDB in table [dbo].[StagingContent]
it does not have Name and Subject ('Unknown'). Also only part of CreateDates are same as content has, all other is a date of content generation (today).

In ETL logs see only one error line

RenderedMessage

Task \"StageRolesTask\" failed after 00:00:00.0336846

Exception

System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'RowVersionId', table 'TelligentReporting12.dbo.StagingRoles'; column does not allow nulls. INSERT fails.\r\nThe statement has been terminated.\r\n at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n

Anyway, graphs are empty (my local instance is fresh and contains only my custom content). How I can troubleshoot that?

Children

0 Brian Dooley over 2 years ago in reply to Former Member

It looks like the database has not been updated to match the version of the ReportingETL.exe you are using.

Reporting has very limited capabilities when it comes to custom content. It has no idea where the content lives so it can only pull over what the core services know about the content, which is what is handed when ISearchableContentType, or one of the other plugin types, registers it. You need to ensure that you're implementing IContent. If you have this properly implemented, the date should match and while the name and subject will show ('Unknown'), when shown in reporting a lookup occurs that will show the IContent.HtmlName.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel