Survey Forums

HomeHomeSurvey Project ...Survey Project ...Installation & ...Installation & ...error when installing 1.0.1 msierror when installing 1.0.1 msi
Previous
 
Next
New Post
4/14/2010 2:59 PM
 

When installing the msi on an image with SQL 2005, IIS 6 en .net 2.0 I get the following error:

error -2147217913: failed to execute SQL string, error detail: The statement has been terminated., SQL key: InitScriptUser SQL string...

Anyone any idea what im doing wrong?

 
New Post
4/19/2010 12:40 AM
 

Hello,

You may have to check the database compatibility level of Sqlserver 2005 and the Survey database created (database properties/ options/ ....). One other cause might be the access rights/ authorisations of the db user used to install the database.

Hope this helps you get it solved.

Kinds regards,
Fwsmaster

 
New Post
4/21/2010 1:21 AM
 

regrettably I have to report that im still not succeeding in running the msi succesfully. When trying the sql file to create a database I also get errors. Any ideas on these errors?

 

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spAnswerMatrixChildAddNew'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spMultiLanguageTextUpdate'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spUserAnswerTypeAssignUser'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spUserAnswerTypeUnAssignAllUser'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spMultiLanguageTextUpdate'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spMultiLanguageTextUpdate'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spFileDeleteExpired'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spQuestionSectionOptionClone'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spQuestionGetDetails'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spQuestionSectionOptionClone'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spQuestionSectionOptionClone'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spQuestionSectionOptionClone'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spVoterFilter'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spUserRegularExpressionAssignUser'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spSurveyGetDetails'. The object will still be created.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'vts_spVoterUIdAddNew'. The object will still be created.

 
New Post
4/22/2010 12:29 AM
 

 You can ignore the sql "errors" they have no effect on a correct installation.

Concerning the MSI installer, did you see the helpfiles at: http://survey.codeplex.com/wikipage?title=AutomatedInstallation&referringTitle=Installation 

Most of all try the instructions at the bottom to determine what may be wrong:

o During installation a logfile (install.log) was created in the survey file directory. This file contains the details of your survey website as entered during the installation. 

o Should you run into problems during the installation there is a first step in identifying the cause of the problem by (re)running the installation and starting the Survey.msi installer from the command line with the following statement: 

msiexec /i "your directorypath\Survey.msi" /l*v SurveyLogFile.txt

This will create a verbose logfile with all the details of every step taken during the installation proces. The logfile can be found in Documents and Settings/ root of [your computeraccount] directory. 

Kind regards
Fwsmaster

 
New Post
4/22/2010 1:17 PM
 

thnx for your help. I found out about the command line log solution yesterday when I was looking through the documentation. It pointed out that it was solely a rights issue. So I managed to install the survey after all. Thanks for your help.

 
Previous
 
Next
HomeHomeSurvey Project ...Survey Project ...Installation & ...Installation & ...error when installing 1.0.1 msierror when installing 1.0.1 msi