Troubleshooting: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "Problem: Starfish Engine installation fails with message “Installation was interrupted”. Solution: On some versions of Windows, in addition to IIS needing to be installed...")
 
No edit summary
Line 33: Line 33:
Problem: Permission error when deploying “Access to the path ‘C:\Inetpub\wwwroot\StarfishEngine\starfish.spd’ is denied”.
Problem: Permission error when deploying “Access to the path ‘C:\Inetpub\wwwroot\StarfishEngine\starfish.spd’ is denied”.
Solution: 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.
Solution: 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.


Problem: Type mismatch issue where column contains some alpha numeric entries but Starfish believes the data is numeric.
Problem: Type mismatch issue where column contains some alpha numeric entries but Starfish believes the data is numeric.

Revision as of 21:42, 24 October 2014

Problem: Starfish Engine installation fails with message “Installation was interrupted”. Solution: 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.

Problem: Scriptcontrol error when deploying bindings file. Solution: 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”.

Problem: 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.” Solution: 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

Problem: ODBC DSN entries do not show up in the drop-down list, or DSN entry not found error when running. Solution: 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.

Problem: 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’”. Solution: 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”.

Problem: Permission denied error to starfish.spd file when deploying. Solution: Grant modify permission on the C:\Inetpub\wwwroot\StarfishEngine folder to the server’s IIS_WPG (IIS6) or IIS_IUSRS (IIS7) user.

Problem: 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.” Solution: 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".

Problem: 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”. Solution: 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).

Problem: Permission error when deploying on path "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files." Solution: Some server environments require write permissions be given to the NETWORK SERVICE user (or the user defined in Application Pool Identity tab).

Problem: Permission error when deploying “Access to the path ‘C:\Inetpub\wwwroot\StarfishEngine\starfish.spd’ is denied”. Solution: 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.

Problem: Type mismatch issue where column contains some alpha numeric entries but Starfish believes the data is numeric. Solution: 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