Hello,

I'm presenting company EPAM Systems. We are going to buy you product and I have to investigate it functionality and coverage of our needs.

I have downloaded and installed the trial version using the video guide provided. 

The first trouble I met, is the server error on the step of generating the report in template mode (New report - >Generate template report - checked -> Add - > Server error) .

The text, ntext, and image data types are invalid in this subquery or aggregate expression. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }

Server Error in '/feedbackserver' Application.

---

The text, ntext, and image data types are invalid in this subquery or aggregate expression.

[SqlException (0x80131904): The text, ntext, and image data types are invalid in this subquery or aggregate expression.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1948826
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4844747
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
   DataIllusion.FeedbackServer.ApplicationBlocks.Data.SqlHelper.Od5W5Rwod(SqlConnection , SqlTransaction , CommandType , String , DataSet , String[] , SqlParameter[] ) +274
   DataIllusion.FeedbackServer.ApplicationBlocks.Data.SqlHelper.FillDataset(SqlConnection connection, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters) +24
   DataIllusion.FeedbackServer.ApplicationBlocks.Data.SqlHelper.FillDataset(String connectionString, CommandType commandType, String commandText, DataSet dataSet, String[] tableNames, SqlParameter[] commandParameters) +112
   DataIllusion.FeedbackServer.SQLServerDAL.Question.GetQuestionReport(Int32 surveyId, Int32 reportId, Int32 reportItemId, Int32 questionId, Int32 filterId, Boolean applyExtendedFilters, String sortOrder, String languageCode, DateTime startDate, DateTime endDate) +700
   DataIllusion.FeedbackServer.DataAccess.Questions.GetQuestionReport(Int32 surveyId, Int32 reportId, Int32 reportItemId, Int32 questionId, Int32 filterId, Boolean applyExtendedFilters, String sortOrder, String languageCode, DateTime startDate, DateTime endDate, Boolean limitTextSize) +103
   DataIllusion.FeedbackServer.WebControls.UI.WebGraphicReport.dARpKAKCn(Int32 ) +309
   DataIllusion.FeedbackServer.WebControls.UI.WebGraphicReport.BuildReport() +314
   DataIllusion.FeedbackServer.WebControls.UI.ReportItem.CreateChildControls() +92
   System.Web.UI.Control.EnsureChildControls() +87
   System.Web.UI.Control.PreRenderRecursiveInternal() +44
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Control.PreRenderRecursiveInternal() +171
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

When I'm not checking that checkbox and trying to add manualy some charts, i get the image frame with no image inside. It seems to me that there are some troubles with handlers.

The second trouble I've encountered is the usage of Active Directory. When I'm adding my account to the web.config, and specifying other credentials I'm logged in by the login/password: admin/admin, but I see nothing but folder "Home"  and the greeting saying something like "Hello anonymous".

I would be very grateful to you for the reply, thanks

Best Regards,
Mykhail Pak
Software Engineer

EPAM Systems
Minsk office, Belarus 

Hi Mykhail,

what build are you running ? You can see it on the bottom footer of the admin section ? This was an issue in one of the first builds of FS but it has been resolved in later builds you might need to reinstall using the latest build install.

You have to first use the bootstrap account you have specified using the feedbackServerADUserName. Once you're logged in using that account you can set afterward all rights to any other account using the user management interface of FS. Make sure not to use the default web.config but to rename the web.AD.config to web.config and use this one. There is an installation procedure for AD in the help on to do this and what attributes to change but let me know if you need further help on this. 

Hello Tom, thank you for fast reply.

The build version is Rev 1.8264. Please tell me where can I get the "fresh" version, because this one I've downloaded from the Download section on your site.

Concerning the AD: I've configured it at last to work poperly, using the web.AD.FORMS.config as the base. It seems to work fine but...

1. User get the login screen when trying to pass the survey. How can I remove it to simply record the AD user name ?

2. I do not get the AD name recorded... The AD Authentication works just fine, but no data in the report concerning user name or something like that, IP address only

the latest builds are in our download section and you will also find the current version next to the filename. Make sure to reinstall a fresh database from this build, dont point to the "old one" you already have.

If your run into mixed mode you can't skip the login screen because there is no integrated security and the user is not logged into AD as proper speaking as the application is running basically in form mode and IIS cannot be configured to be both at the same time integrrated AD and form mode. If you want to have the screen skipped you have to run everything under AD and not in mixed mode.

Make sure to have the AD Security addin activated on your survey from the security settings page as its the addin which will record the username once the survey gets submited.

Well I will try to figure out AD problem, right now I'm downloading new version from this link http://www.feedbackserver.com/downloads/fs2008_webinstall.zip

I got it from this page

http://feedbackserver.com/feedbackserver/Downloads.aspx

It's written that the build version is  Build 3.0.8274.1

But last time, a day ago, I was downloading from the same page, maybe you have not updated the directory?

hmm this is really strange because if you downloaded the file a day ago it was a build which was ok, could you still try to resetup the DB using the new zip and also try the exact same steps online in our demo (its the same build) to see if you can reproduce the error ?

Tom, I have downloaded new version, installed new DB, created new vritual directory, the result is the same, footer line:

Feedback Server® 2008 - Rev 1.8274  - Unregistered Trial - © 2008 Data Illusion. All rights reserved.

// skm_registerMenu('FSAdminMenuControl_HeaderMenu',new skm_styleInfo('','','','','','','','','','menuHoverClass'),new skm_styleInfo('','','','','','','','','',''),1,true); // Can you help me somhow with this problem?

The "handler trouble" is the same

Hi,

ok seems an old issue happening on SQL 2000 installations only, could you send us an email at support[at]dataillusion.com and we will send you the corresponding fix in the meantime we work on a new update release package.

Thank you Tom for the e-mail, there is no error now.

Still fighting with Actrive Directory, maybe you can help. I have set up the Ad configuration, and it seems to be right, because when logging in the survey me or my colleagues entering credentials come to the questioned page. But that all works in mixed mode as mentioned above, and no data about employes is registered.

I was honestly trying for a couple of hours to figure out what should I do to stop getting "anonymous" welcome message.. In vain.

I'm not the domain administrator, and I strongly doubt that our system administrators would allow me to become the member of admin group. The question  I would like to clarify is, why do users in mixed mode can login and system gets their AD accounts correctly, and why it can't be done in the AD mode only? Maybe it is possible to do that in some other way?

BTW trying to add AD Panel Iget message that system can not find any certificate in the MS . NET folder...

 Thanks in advance,

Mykhail

once you the latest script I've sent to you will also be able to see the user.

the anonymous message is shown when not authentication context is available. If you choose to run in Mixed mode you have to use the web.ad.Forms.config and make sure that the line :

<system.web>

<deny users="?"/>

</system.web>

<location path="FeedbackServer/login.aspx">

<authorization>

</authorization>

</location>

<authentication mode="Forms">

<forms name=".FSADAUTH" loginUrl="~/FeedbackServer/login.aspx"

</authentication>

As long as you are able to access the fs.aspx file directly from your browser without going through the login.aspx page it means that the security context is not properly setup and as such no user will be detected or authenticated.

Because mixed mode is a special mode where basically IIS is running in a form authentication mode and thats why users have to enter their credentials for both the admin section and the survey access. AD mode is authenticated directly from the browser as such users dont have to enter their credentials but anyone else having no AD account will not be able to access FS or its surveys. You have to run one or the other but its not possible to have both at the same time its a technical "limitation" of the IIS web server.

What is the exact message that you get ? Sounds like  a net specific configuration issue.

That's all nice I have that settings when using mixed mode, but tell me please, what should I wirte in web.config file to use just AD authentication mode?

I wrote Domain Contrller, user name/password, admin name, domain name, removed all sections concerning forms, but after that I get nothing but anonymous greeting

I'll show example

adController="minsk.epam.com"

adUserName="Mykhail_Pak@epam.com"

adPassword="password"

adDomain="epam.com"

adToDBSyncTimeOut="1440"

feedbackServerADUserName="Mykhail_Pak@epam.com"

adSearcherFilter="(&amp;(objectCategory=person)(objectClass=user))"

Hi,

if you want to have a full AD installation you have to use the web.AD.config not the mix mode web.config and setup the IIS web server for integrated security, the steps to setup integrated security on IIS are described here :
http://www.dataillusion.com/demo/FeedbackServer/help/index.html?page=Active%20Directory%20User%20Provider.htm

 Hello Tom,

I figured out some points in AD security and now I am recognized (I was writting Ad Administrator Mykhail_Pak@epam.com, when needed Mykhail_Pak) . Now I have the troublethat was from the beginning, survey users authentication occurs normally, but no data about users is recorded, I'm still playing with domain settings. I use my account and my password as username and pass to access domain, is it right?

Hi,

what mode are you now running in? Are you now running mixed form/ad or full ad ?