Timeline for Experience Analytics Error throwing System.Data.DataException error
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 21, 2022 at 0:17 | comment | added | Arun Kumar | it is a standalone. And the reporting db i am using is the one Sitecore created on fresh install of 10.2 rather prod db. Based on the sql query i can see the Converted column is missed as part of subset but it is expected on the the select where it tried to fetched the column out of the subset which wasnt there. That where the confusion is for me where reporting db is fresh one, dlls pushed in not holding any outdated dll, upgrade script for master was run which as per upgrade guidelines. | |
| Oct 20, 2022 at 7:13 | history | edited | Dean OBrien | CC BY-SA 4.0 |
added 557 characters in body
|
| Oct 20, 2022 at 7:06 | history | edited | Dean OBrien | CC BY-SA 4.0 |
added 557 characters in body
|
| Oct 20, 2022 at 7:03 | comment | added | Dean OBrien | The table being referenced is from the Reporting DB, please make same checks with that connection string also. Also, is your upgraded instance in 'standalone' role or 'distributed'. If distributed, then see update in answer. | |
| Oct 20, 2022 at 6:39 | comment | added | Arun Kumar | Thank you. I have validated if any old sitecore dlls are being published from solution, i couldnt find any. To validate i even installed a fresh 10.2 installation and connected existing master db rather publish any solution. But then just by referencing prod master db after executing all db upgrade scripts from 9.1.1 to 10.2 . It is still throwing the same error where no new assemblies of previous sitecore version is pushed in | |
| Oct 17, 2022 at 14:28 | history | answered | Dean OBrien | CC BY-SA 4.0 |