Troubleshooting

From Starfish ETL
Jump to: navigation, search
Problem Solution
Starfish Engine installation fails with message “Installation was interrupted”. On some versions of Windows, in addition to IIS needing to be installed – “IIS 6 Management Compatibility” will also need to be installed. This is added through the “Turn Windows features on or off” function in Control Panel and is located in the “Internet Information Services\Web Management Tools” Program group. Be sure to check all items under the “IIS 6 Management Compatibility” group.
Scriptcontrol error when deploying bindings file. Some newer versions of Windows Server does not have the ms script controls registered on the server by default. From the command line, run “regsvr32 msscript.ocx”. This file may be located in System32 or SysWow64, depending on your version of Windows. If you continue to get similar errors, you may also need to register “vbscript.dll”.
Error message on deploy: “Could not load file or assembly ‘Microsoft.Crm.Sdk’ or one of its dependencies. An attempt was made to load a program with an incorrect format.” On some 64-bit systems, IIS disables 32-bit mode which Starfish requires. For IIS 7: In IIS, select the Application Pool where Starfish is running, and go to the Advanced Settings and set “Enable 32-Bit Applications” to True. For IIS 6: Follow the instructions outlined here: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/405f5bb5-87a3-43d2-8138-54b75db73aa1.mspx?mfr=true
ODBC DSN entries do not show up in the drop-down list, or DSN entry not found error when running. On 64-bit systems, the DSN must be configured using the 32-bit version of the ODBC manager, it is typically located in: C:\Windows\SysWow64\odbcad32.exe.
When deploying, you get an error message “The HTTP request is unauthorized with the client scheme ‘Anonymous’. The authentication header received from the server was ‘Negotiate,NTLM’”. In IIS Manager, expand Sites, Default Web Site, and select StarfishEngine. Under IIS, select the “Authentication” item, and make sure “Anonymous Authentication” is set to “Enabled”.
Permission denied error to starfish.spd file when deploying. Grant modify permission on the C:\Inetpub\wwwroot\StarfishEngine folder to the server’s IIS_WPG (IIS6) or IIS_IUSRS (IIS7) user.
When testing the Starfish Engine website, you get the following (or similar) error message: “Could not load file or assembly 'Microsoft.Crm.Sdk' or one of its dependencies. An attempt was made to load a program with an incorrect format.” On 64-bit systems, this can be caused if 32-bit applications have been disabled for IIS. For IIS6, go to a command prompt. Change to the “C:\Inetpub\AdminScripts” folder and execute the following command: cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 true For IIS7+, go to IIS Manager, select the Application Pool that Starifh is running under, select Advanced Settings, and set "Enable 32-Bit Applications" to "Enabled".
Errors on Insert & Update stages when using SData Destination with Saleslogix 7.5.3, such as “Object not set to an instance of an object”. This is caused by a bug in Saleslogix 7.5 Service Pack 3. If you are running 7.5.3, be sure to apply 7.5.3 Hot Fix 1, which will fix this issue. SP, Hot Fix 3 may also be necessary to get more detailed messages from SData (such as ValidationException reasons).
Permission error when deploying on path "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files." Some server environments require write permissions be given to the NETWORK SERVICE user (or the user defined in Application Pool Identity tab).
Permission error when deploying “Access to the path ‘C:\Inetpub\wwwroot\StarfishEngine\starfish.spd’ is denied”. Some server environments will require write permissions to be given to the IIS_WPG user. Access should be given to the Inetpub\wwwroot\StarfishEngine folder.
Type mismatch issue where column contains some alpha numeric entries but Starfish believes the data is numeric. If a column of data contains numeric data for the first few rows and then later contains alphanumeric data Starfish will expect numeric data from every row in the data and will then fail to parse the alphanumeric data. Because by default the Microsoft Jet driver that is used for this functionality only scans the first 16 rows, it tries to make a ‘guess’ based on that data for each column type. This is only a problem is the data changes from numeric to alphanumeric partway through the data as thinks the data is all numbers. In registry, navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines\Text Find the MaxScanRows key, and change the value to ‘0’. Restart Starfish
Server Error in '/StarfishEngine' Application. Parser Error Message: Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive. I believe that this error occurred because i had to repair .NET 4.0. My Application Pool reverted to .NET 2.0. I found the solution in this post on Stack Exchange: http://stackoverflow.com/questions/7530725/unrecognized-attribute-targetframework-note-that-attribute-names-are-case-sen. This typically happens when you have an attribute of targetFramework="4.0" in the web.config but the App Pool is set to run ASP.NET 2.0. The targetFramework attribute is entirely unrecognized by ASP.NET 2.0. I switched the AppPool to 4.0 and it worked.
Server Error in Application "DEFAULT WEB SITE/STARFISHENGINE"

HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.

Add StarfishService.asmx the website's Default Document list.

http://forums.iis.net/t/1207657.aspx?How+to+Fix+HTTP+Error+403+14+Forbidden+The+Web+server+is+configured+to+not+list+the+contents+of+this+directory+

Invalid path or file name.

This error often includes a lot of other text and is strange because the Origin test works but the Preview and Run job fail.

This error is caused by the Starfish IIS Applicaiton Pool user not having access to the origin or destination where your local use does have access. The solution is to change the Application Pool identity user to your normal windows login or another user with access.
Error on Start:

System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at http://localhost/StarfishEngine/StarfishService.asmx that could accept the message. This is often caused by an incorrect address or SOAP action.

This error occurs when starting the Starfish Scheduler Service when Starfish was setup with a non-standard Service URL. For example, a custom port or folder structure: http://localhost:8080/StarfishService.asmx. To resolve, edit the StarfishScheduler.exe.config file in the folder where you installed the Starfish Scheduler. Generally this file is located at C:\Program Files (x86)\Starfish ETL\Starfish Scheduler\StarfishScheduler.exe.config.
HTTP Error 404.3 - Not Found

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.
Failed: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. This has been known to happen when frequently running a scheduled job with the Starfish Scheduler. Try setting the IIS Application Pool used by Starfish to recycle on a schedule. In IIS, you can set an Application Pool to recycle every x hours. You can also use Windows Task Scheduler to schedule an Application Pool Reset on a more complicated schedule. For example, if you have a large integration that runs over the weekend, you could use the Task Scheduler to recycle the pool Fridays just before the integration starts. To do this, create a new Task Scheduler with the desired schedule and "Start a program" C:\Windows\System32\inetsrv\appcmd.exe recycle apppool "StarfishETL". You may need to change the location of appcmd.exe or the name of the Application Pool to recycle. A quick internet search should be able to provide more guidance to recycling an Application Pool from the command line.
... MSVPC140.dll is missing ... Download and install the "Microsoft Visual C++ 2015 Redistributable". This can currently be found at https://www.microsoft.com/en-us/download/details.aspx?id=52685.

Starfish Monitor

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.