Downgrade From 2024 - Assets Page - Unable to cast object of type 'System.Int32' to type 'System.Int64'

arlymac_7956

I downgraded but the Asset page give the error:
Unexpected Error
(500) Server Error
Unable to cast object of type 'System.Int32' to type 'System.Int64'.
For more information, visit the Error Log Page.

Please see below from the error log:

URL: http://localhost:8624/assets
Referrer: http://localhost:8624/administration
User: Admin
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36
Stack trace: at Microsoft.Data.SqlClient.SqlBuffer.get_Int64()
at lambda_method10(Closure , DbDataReader , BufferData )
at Inedo.Data.StrongDataReader.<Read>g__readRow|11_0[TRow](<>c__DisplayClass11_01& ) at Inedo.Data.StrongDataReader.Read[TRow](IDbDataResult dbResult)+MoveNext() at Inedo.Data.StrongDataReader.Read[TRow](Func1 getReader, Boolean disposeReader)+MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Inedo.ProGet.WebApplication.Pages.Assets.AssetDirectoriesPage.CreateChildControls()
at Inedo.ProGet.WebApplication.Pages.ProGetSimplePage.InitializeAsync()
at Inedo.Web.PageFree.SimplePageBase.ExecutePageLifeCycleAsync()
at Inedo.Web.PageFree.SimplePageBase.ProcessRequestAsync(AhHttpContext context)
at Inedo.Web.AhWebMiddleware.InvokeAsync(HttpContext context)

rhessinger

Hi @arlymac_7956,

What version of ProGet did you have installed prior to upgrading to ProGet 2024 before you downgraded? I don't see any differences in the table schemas between ProGet 2023 and 2024, but I want to make sure I'm comparing to the correct schema.

Thanks,
Rich

arlymac_7956

I had 2023.33.
I downgraded to 2023.33 and due to this error I downgraded to 2023.32. As the error was still there I upgraded to 2023.33

atripp

Hi @arlymac_7956

This error will occur when the database and installed product are not the same version. This is a rare scenario, and will happen if you make certain changes to the IIS/Service configuration on a server.

For example, if you were to copy the application folder (e.g. c:\Program Files\ProGet) to a new location, and then run the web application from that location, then it wouldn't be updated when you update ProGet.

If you can't figure how it's happening, I would recommend uninstalling. Then try to delete any remaining configuration like services/IIS. Don't delete the database or the packages of course.

Then when you reinstall, just point to the database and it shoudl work fine again.

Best,
Alana

arlymac_7956

Good Morning,

Unfortunately that did not work and I had to restore to a previous database backup and update the packages etc.

Thanks