Troubleshooting - Revision history

Jkuehlthau: /* Starfish Errors */

2024-03-28T19:16:17Z

Starfish Errors

← Older revision		Revision as of 19:16, 28 March 2024
Line 59:		Line 59:
	\|HTTP Error 404.3 - Not Found<br>		\|HTTP Error 404.3 - Not Found<br>
	The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.		The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.
	\|~~In Windows 8/10, you have to use~~ Programs and Features, Turn Windows features on or off~~, IIS, World Wide Web Services~~, Application Development ~~Features~~, and ~~check the appropriate items, such as enabling~~ ASP.NET. ~~(This still worked as of Starfish v5~~.~~2/v5.3~~.)		\|Use Programs and Features or Turn Windows features on or off to enable ASP.NET 4.7. This includes .NET Framework 4.7 Features->ASP.NET 4.7, Application Development->.NET Extensibility 4.7, and Application Development->ASP.NET 4.7. If this doesn't help, I would try adding more Web Server and .NET features and functions.
	\|-		\|-
	\|-		\|-

Jkuehlthau: /* Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. */

2024-03-28T15:24:11Z

Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.

← Older revision		Revision as of 15:24, 28 March 2024
Line 111:		Line 111:
	==Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.==		==Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.==
	In the Web.config there is an old entry looking for a specific version of the System.Runtime.CompilerServices.Unsafe.dll file. After we removed that entry, it worked.		In the Web.config there is an old entry looking for a specific version of the System.Runtime.CompilerServices.Unsafe.dll file. After we removed that entry, it worked.
			==There was an error during the IIs configuration process. Your original IIS configuration will be restored.==
			Try installing "IIS 6 Management Compatibility".

	=Starfish Monitor=		=Starfish Monitor=
	==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==		==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==
	Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.		Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.

Jkuehlthau: /* HTTP Error 404.17 - Not Found */

2024-01-10T18:24:54Z

HTTP Error 404.17 - Not Found

← Older revision		Revision as of 18:24, 10 January 2024
Line 108:		Line 108:

	I wend into Turn Windows Features On or Off and checked a bunch of stuff under Internet Information Services by expanding all of the trees under the parent node. This made Starfish Engine work.		I wend into Turn Windows Features On or Off and checked a bunch of stuff under Internet Information Services by expanding all of the trees under the parent node. This made Starfish Engine work.

			==Could not load file or assembly 'System.Runtime.CompilerServices.Unsafe' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference.==
			In the Web.config there is an old entry looking for a specific version of the System.Runtime.CompilerServices.Unsafe.dll file. After we removed that entry, it worked.

	=Starfish Monitor=		=Starfish Monitor=
	==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==		==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==
	Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.		Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.

Jkuehlthau: /* System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. */

2019-09-09T16:40:05Z

System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied.

← Older revision		Revision as of 16:40, 9 September 2019
Line 104:		Line 104:
	==System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied.==		==System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied.==
	This started happening with the upgrade to Starfish v5.3. Try opening IIS Manager -> Starfish's Application Pool -> Advanced Settings -> and make sure "Load User Profile" is true. In the same area, you may have to change the "Identity" to an account with elevated permissions. I used LocalSystem.		This started happening with the upgrade to Starfish v5.3. Try opening IIS Manager -> Starfish's Application Pool -> Advanced Settings -> and make sure "Load User Profile" is true. In the same area, you may have to change the "Identity" to an account with elevated permissions. I used LocalSystem.
			==HTTP Error 404.17 - Not Found==
			The requested content appears to be script and will not be served by the static file handler.

			I wend into Turn Windows Features On or Off and checked a bunch of stuff under Internet Information Services by expanding all of the trees under the parent node. This made Starfish Engine work.

	=Starfish Monitor=		=Starfish Monitor=
	==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==		==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==
	Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.		Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.

Jkuehlthau: /* System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. */

2019-08-27T12:34:18Z

← Older revision		Revision as of 12:34, 27 August 2019
Line 103:		Line 103:

	==System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied.==		==System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied.==
	This started happening with the upgrade to Starfish v5.3. Try opening IIS Manager -> Starfish's Application Pool -> Advanced Settings -> and make sure "Load User Profile" is true. In the same area, you may have to change the "Identity" to ~~and~~ account with elevated permissions. I used LocalSystem.		This started happening with the upgrade to Starfish v5.3. Try opening IIS Manager -> Starfish's Application Pool -> Advanced Settings -> and make sure "Load User Profile" is true. In the same area, you may have to change the "Identity" to an account with elevated permissions. I used LocalSystem.

	=Starfish Monitor=		=Starfish Monitor=
	==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==		==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==
	Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.		Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.

Jkuehlthau: /* Starfish Errors */

2019-06-04T18:38:46Z

Starfish Errors

← Older revision		Revision as of 18:38, 4 June 2019
Line 59:		Line 59:
	\|HTTP Error 404.3 - Not Found<br>		\|HTTP Error 404.3 - Not Found<br>
	The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.		The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.
	\|In Windows 8/10, you have to use Programs and Features, Turn Windows features on or off, IIS, World Wide Web Services, Application Development Features, and check the appropriate items, such as enabling ASP.NET.		\|In Windows 8/10, you have to use Programs and Features, Turn Windows features on or off, IIS, World Wide Web Services, Application Development Features, and check the appropriate items, such as enabling ASP.NET. (This still worked as of Starfish v5.2/v5.3.)
	\|-		\|-
	\|-		\|-

Jkuehlthau at 19:00, 24 May 2019

2019-05-24T19:00:47Z

← Older revision		Revision as of 19:00, 24 May 2019
Line 101:		Line 101:

	Try opening IIS Manager -> Your Starfish Application Pool -> Advanced Settings -> Confirm "Enable 32-Bit Application" is False.		Try opening IIS Manager -> Your Starfish Application Pool -> Advanced Settings -> Confirm "Enable 32-Bit Application" is False.

			==System.Data.CData.Excel.ExcelException (0x80004005): [500] Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied. ---> rxo190c.Mn: Access to the path '%APPDATA%\CData\Excel Data Provider\Schema' is denied.==
			This started happening with the upgrade to Starfish v5.3. Try opening IIS Manager -> Starfish's Application Pool -> Advanced Settings -> and make sure "Load User Profile" is true. In the same area, you may have to change the "Identity" to and account with elevated permissions. I used LocalSystem.

	=Starfish Monitor=		=Starfish Monitor=
	~~'''~~Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.~~'''<br>~~		==Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.==
	Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.		Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.

Jkuehlthau: /* Starfish Errors */

2018-09-06T17:44:06Z

Starfish Errors

← Older revision		Revision as of 17:44, 6 September 2018
Line 91:		Line 91:

	On a Windows 2016 computer, I downloaded .NET v7.7.2 from here: https://www.microsoft.com/net/download/dotnet-framework-runtime/net472.		On a Windows 2016 computer, I downloaded .NET v7.7.2 from here: https://www.microsoft.com/net/download/dotnet-framework-runtime/net472.
			\|-
			\|System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SQLite.SQLiteException: unable to open database file ...
			\|This is telling us that Starfish cannot open the engine.db file found in you web service's folder. By default this is "C:\inetpub\wwwroot\StarfishEngine". Ensure you have proper Security on this folder to allow Starfish and IIS to interact with it. Right click on the Folder -> Properties -> Security Tab. Confirm that System, Administrators and IIS_IUSRS have "Full control" of the folder. If all else fails, try granting "Everyone" Full control.
	\|-		\|-
	\|}		\|}

Jkuehlthau at 16:31, 10 August 2018

2018-08-10T16:31:06Z

← Older revision		Revision as of 16:31, 10 August 2018
Line 1:		Line 1:
			=Starfish Errors=
	{\| class="wikitable"		{\| class="wikitable"
	! style="font-weight: bold;" \| Problem		! style="font-weight: bold;" \| Problem
Line 92:		Line 93:
	\|-		\|-
	\|}		\|}

			==Load failure information for v8-ia32.dll==
			Error: "Load failure information for v8-ia32.dll" or "The specified module could not be found...v8-ia32.dll".

			Try opening IIS Manager -> Your Starfish Application Pool -> Advanced Settings -> Confirm "Enable 32-Bit Application" is False.

	=Starfish Monitor=		=Starfish Monitor=
	'''Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.'''<br>		'''Monitor Error: System.DllNotFoundException: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found.'''<br>
	Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.		Copy the SQLite.Interop.dll file from the Engine bin folder to the Scheduler folder. Generally C:\Program Files (x86)\Starfish ETL\Starfish Admin\SQLite.Interop.dll to C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\SQLite.Interop.dll.

Jkuehlthau at 16:54, 30 July 2018

2018-07-30T16:54:58Z

← Older revision		Revision as of 16:54, 30 July 2018
Line 85:		Line 85:
	Source File: C:\inetpub\wwwroot\StarfishEngine\web.config Line: 49 <br>		Source File: C:\inetpub\wwwroot\StarfishEngine\web.config Line: 49 <br>
	...		...
	\|~~Based on this page~~, https://~~blogs.msdn~~.microsoft.com/~~benjaminperkins~~/~~2018~~/03/08/~~configuration~~-~~error~~-~~targetframework~~-4-~~7/, I found I had .NET v4.6~~ installed.		\|This issue seems to always be caused by the wrong version of .NET being installed. To see what version of .NET you have installed, follow these instructions: https://docs.microsoft.com/en-us/dotnet/framework/migration-guide/how-to-determine-which-versions-are-installed#net_b.

	On a Windows 2012 computer, I downloaded the .NET v4.7.1 offline installer from here, https://support.microsoft.com/en-us/help/4033345/the-microsoft-net-framework-4-7-1-for-windows-server-2012, and installed it.		On a Windows 2012 computer, I downloaded the .NET v4.7.1 offline installer from here: https://support.microsoft.com/en-us/help/4033345/the-microsoft-net-framework-4-7-1-for-windows-server-2012, and installed it.

	On a Windows 2016 computer ~~that had~~ .NET ~~v4.7.3 or v4~~.7.2 ~~installed (the computer seemed to think both were installed), we changed the targetFramework~~ from "4.~~7.1" to "4.7" so we ended up with: targetFramework="4~~.7".		On a Windows 2016 computer, I downloaded .NET v7.7.2 from here: https://www.microsoft.com/net/download/dotnet-framework-runtime/net472.
	\|-		\|-
	\|}		\|}