0

I am using Experience Extractor for exporting analytics report data to Excel.I am using Sitecore 9 update 1 Instance. I installed ExperienceExtractor-0.3.1-8.2 in my instance. After that I tried to get analytics report data.But it throws error.Please help me to fix this issue.

Please find the below error message:

System.Collections.Generic.KeyNotFoundException: No parse factory registered for type IDataSource with key "xdb" (Source)
   at ExperienceExtractor.Api.Parsing.JsonJobParser.Parse[TType](ParseState state) in C:\Projects\ExperienceExtractor\experience-extractor\src\ExperienceExtractor\Api\Parsing\JsonJobParser.cs:line 63
   at ExperienceExtractor.Api.Jobs.Job.Run() in C:\Projects\ExperienceExtractor\experience-extractor\src\ExperienceExtractor\Api\Jobs\Job.cs:line 105

{
  "Id": "b986f360-f5eb-48c4-a39e-6168fb54a983",
  "Created": "2019-08-06T14:42:36.8411102+05:30",
  "Ended": "2019-08-06T14:42:36.8451001+05:30",
  "ItemsProcessed": 0,
  "RowsCreated": 0,
  "Progress": null,
  "Status": "Failed",
  "StatusText": "System.Collections.Generic.KeyNotFoundException: No parse factory registered for type IDataSource with key \"xdb\" (Source)\r\n   at ExperienceExtractor.Api.Parsing.JsonJobParser.Parse[TType](ParseState state) in C:\\Projects\\ExperienceExtractor\\experience-extractor\\src\\ExperienceExtractor\\Api\\Parsing\\JsonJobParser.cs:line 63\r\n   at ExperienceExtractor.Api.Jobs.Job.Run() in C:\\Projects\\ExperienceExtractor\\experience-extractor\\src\\ExperienceExtractor\\Api\\Jobs\\Job.cs:line 105",
  "SizeLimitExceeded": false,
  "Url": "/sitecore/experienceextractor/jobs/b986f360-f5eb-48c4-a39e-6168fb54a983",
  "Specification": "{\r\n  \"source\": {\r\n    \"xdb\": {\r\n      \"filters\": [\r\n        {\r\n          \"sample\": 0.6\r\n        },\r\n        {\r\n          \"daterange\": {\r\n            \"start\": \"2019-07-01Z\",\r\n            \"end\": \"2019-08-01Z\"\r\n          }\r\n        }\r\n      ]\r\n    }\r\n  },\r\n  \"mapper\": {\r\n    \"tables\": [\r\n      {\r\n        \"name\": \"Visits\",\r\n        \"fields\": [\r\n          {\r\n            \"date\": \"Date\"\r\n          },\r\n          {\r\n            \"xa\": \"Visits/By channel\"\r\n          },\r\n          \"facts\"\r\n        ],\r\n        \"tables\": [],\r\n        \"partitionkey\": \"00:15:00\"\r\n      }\r\n    ]\r\n  },\r\n  \"postprocessors\": [\r\n    {\r\n      \"mssql\": {\r\n        \"database\": \"ExportData1\",\r\n        \"ssasdatabase\": \"ExportData1\"\r\n      }\r\n    }\r\n  ],\r\n  \"export\": {\r\n    \"format\": \"binary\"\r\n  }\r\n}",
  "LastException": "System.Collections.Generic.KeyNotFoundException: No parse factory registered for type IDataSource with key \"xdb\" (Source)\r\n   at ExperienceExtractor.Api.Parsing.JsonJobParser.Parse[TType](ParseState state) in C:\\Projects\\ExperienceExtractor\\experience-extractor\\src\\ExperienceExtractor\\Api\\Parsing\\JsonJobParser.cs:line 63\r\n   at ExperienceExtractor.Api.Jobs.Job.Run() in C:\\Projects\\ExperienceExtractor\\experience-extractor\\src\\ExperienceExtractor\\Api\\Jobs\\Job.cs:line 105"
}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.