 |
 |
|
|
|
|
 |
|
|
General
The ever-powerful List X module forum. Post your questions, new configuration ideas and reviews.
| You are not authorized to post a reply.
|
|
| Author |
Messages |
|
VarunC
Posts:117
 |
| 04/10/2008 1:35 PM |
 Alert
|
Hi,
From past few days the DNN installation of mine has lots n lots of General Exceptions, as soon as a User log in to the site.
I've got many module as skin object, BUT ALL the modules are applied with WEDJET skin and are SET to AJAX MANUAL Load. and DNn Log Viewer reports Exceptions concerning query execution being termninated without proper single quotes and all sorts of things.
An Example of Error Message:
ListX Execute Action Error (TabID:xxx|ModuleID:xxx): System.Data.SqlClient.SqlException: Incorrect syntax near ','. Incorrect syntax near '='. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at
.......
My concern is if Module is on Ajax manual load then how come any query gets executed.
FYI, I've multiple SubQueries in the modules, so can there be a case if subqueries are executing even if Module is Set to manual load, but then also, i've crosschecked the queries and all have been entered with proper syntax followed by listx and sql queries.
Help !!! as the DNN database size is increasing and the SITE speed is at WORST at present due to exceptions occurring whenever user goes to another tab or refreshes the tabs. <img src='http://dnn.bi4ce.com/desktopmodules/ntforums/images/emoticons/cry.gif' height='20' width='20' border='0' title='Cry' align='absmiddle'>
|
|
|
|
|
kevinmschreiner
Posts:749
|
| 04/10/2008 1:40 PM |
Alert
|
| Is Ajax Enabled on the module AND it is marked as manual, or just manual? You need to make sure it's both I believe. |
|
Kevin M Schreiner
Business Intelligence Force, Inc. (bi4ce)
 |
|
|
VarunC
Posts:117
|
| 04/10/2008 1:49 PM |
Alert
|
| yes i've both enabled ... |
|
|
|
|
VarunC
Posts:117
|
| 04/10/2008 1:50 PM |
Alert
|
FYI,
ListX version - 1.9.9.6
DNn Version - 04.08.00 |
|
|
|
|
kevinmschreiner
Posts:749
|
| 04/10/2008 2:03 PM |
Alert
|
Ah, okay, I've just checked it - thats because you are still getting a page load. Something we made far better in OWS. But in any case - your actions execute during page load AND during ajax callbacks. So - if you have an execute (query) action - it will be executed. You can easily detect if you are running in a non ajax request by checking something like this:
IF [COALESCE,lxSrc,Querystring,{LENGTH}] > 0
DO YOUR AJAX ONLY STUFF IN HERE.... |
|
Kevin M Schreiner
Business Intelligence Force, Inc. (bi4ce)
|
|
|
VarunC
Posts:117
|
| 04/11/2008 7:16 AM |
Alert
|
thanks. But I've an issue here.
In Log it says:
InnerException: ListX Execute Action Error (TabID:xxx|ModuleID:xxx): System.Data.SqlClient.SqlException: Incorrect syntax near 'Client'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at ......................
Now the issue is, I've ALL EXCEUTE actions To Bet Set to execute only on a Particular QuesryString Value check..
like If '[Save,Q]'<>'' Then
.. EXECUTE Query actions ....
So in this case too whether Manual AJAX is set or NOT the Module should not be causing any errors in Event Log. |
|
|
|
|
VarunC
Posts:117
|
| 04/11/2008 7:20 AM |
Alert
|
oh also the error is not occurring on Same Page Refresh, this is the correction on my part while explaining the issue.
The error is causing only once when user logged in and visits the tab afresh and if he visits teh page again then no error is being logged, this is common to not all modules where error is occurring but to most modules that are causing exceoptions.
And very strangely, if I enable debug and check the module Actions and Subqueries .. ALL came clean YET an Exception Exist for that Module in Log Viewer.
:-( .. Help |
|
|
|
|
pauldes
Posts:1392
|
| 04/15/2008 2:06 PM |
Alert
|
| bump |
|
ListX....makes you look brilliant, even though you're not. |
|
|
VarunC
Posts:117
|
| 04/16/2008 6:55 AM |
Alert
|
I think this is also occuring NOT SURE of this is also relatd to the issue I explained earlier.
Can there be a possibility that when AJAX Manual Load is checked then ONLY ACTION:EXECUTE are executed on Page Load and NOT the Query String Variables declared in the Module? This I'm saying because there is an error that is for EMPTY variale but that appears only once after login I guess. |
|
|
|
|
pauldes
Posts:1392
|
| 04/24/2008 8:33 AM |
Alert
|
| bump |
|
ListX....makes you look brilliant, even though you're not. |
|
|
robert_chumley
Posts:595
|
| 04/28/2008 4:32 PM |
Alert
|
Are there any other errors you are seeing in the module load, or are you only seeing this problem in the Log?
Thanks, |
|
Robert Chumley
r2integrated (formally bi4ce) |
|
|
pauldes
Posts:1392
|
| 05/01/2008 7:26 AM |
Alert
|
| just in the DNN Event Log |
|
ListX....makes you look brilliant, even though you're not. |
|
|
VarunC
Posts:117
|
| 05/06/2008 12:18 AM |
Alert
|
| Any luck in recognizing the issue!!! <img src='http://dnn.bi4ce.com/desktopmodules/ntforums/images/emoticons/sad.gif' height='20' width='20' border='0' title='Sad' align='absmiddle'> |
|
|
|
|
robert_chumley
Posts:595
|
| 05/08/2008 11:41 AM |
Alert
|
What DNN Version are you using. It is possible that you are using a version that had leaky Error message. I would suggest upgrading to DNN Version 4.8.2.
Thanks, |
|
Robert Chumley
r2integrated (formally bi4ce) |
|
|
pauldes
Posts:1392
|
| 05/08/2008 8:25 PM |
Alert
|
| 4.8, what version are you referring to? |
|
ListX....makes you look brilliant, even though you're not. |
|
|
robert_chumley
Posts:595
|
| 05/12/2008 9:19 AM |
Alert
|
4.6 Had problems with event logs mesages taking over DNN. I had one Event Log that had 600K entries. IMHO the event logs tend to be a little touchy anyway.
Thanks, |
|
Robert Chumley
r2integrated (formally bi4ce) |
|
|
VarunC
Posts:117
|
| 05/12/2008 11:05 AM |
Alert
|
then any luck in finding the issue for the same .. do you think upgrading to 4.8 would solve the issue ?
I think this was all working fine until we upgrade to DNN 4.8.
|
|
|
|
|
VarunC
Posts:117
|
| 05/12/2008 11:07 AM |
Alert
|
| Sorry upgrading to 4.8.2 .. its is at present 4.8.0. |
|
|
|
|
robert_chumley
Posts:595
|
| 05/12/2008 3:27 PM |
Alert
|
Right, that is what Kevin said above. The best you can do is protect the actions on the module by using a conditional before any queries that check to see if the current request is an AJAX request.
IF [COALESCE,lxSrc,Querystring,{LENGTH}] > 0
DO YOUR AJAX ONLY STUFF IN HERE....
Is there a problem with using this from above?
Thanks, |
|
Robert Chumley
r2integrated (formally bi4ce) |
|
|
sigmadx
Posts:24
|
| 10/03/2008 6:09 PM |
Alert
|
I had a similar problem as above in two cases. I thought I'd chip in.
Checking the two AJAX boxes helped me for one of them.
In the other case, I had 4 cascading dropdowns, with subqueries linking each. Each successive drop down had a subquery that would refine the select and narrow the field of results. While the module worked, I was getting 3 of the same errors each time i loaded the page.
What was happening was my first query variable of my Subquery had no 'Empty Target' setting so my SQL statement 'select .. where x='' ' was not rendering properly. Once I gave a value for 'Empty Target' to my query string I stopped getting these General Exceptions.
|
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.6
|
|
| Latest Post
|
 |
|
At R2integrated (formerly Bi4ce), we take support seriously. That's why we support our customers and DNN community with daily monitoring from our experienced engineering team. We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered. We ask that you review the documentation that we provide for our products before posting a question.
The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback. Please be sure to perform keyword searches for previous related forum responses.
To be helpful when submitting a new item, please include the following:
- DNN Version
- Module Version
- Admin Log Viewer Information
- Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST). Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.
Thank you for using our Forums.
Click here to register for the Forums
|
|
|
|
| © 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation
|
 |
|
|
|
 |
|