Welcome to the Axosoft Community, Sign in | Register | Help
in Search

EXception

Last post 03-30-2007, 6:25 AM by Paul Greefhorst. 12 replies.
Sort Posts: Previous Next
  •  03-06-2007, 7:13 AM 10427

    EXception

    I upgraded our Ontime 2006 to 7.0.1.7150, but when openening the windows client I receive the following exception. Nothing is saved in exception log.

    What could cause this? (or How to resolve)

    Jesper, Sitecore

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.Data.SqlClient.SqlException: Line 69: Incorrect syntax near '30'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsP****r.ThrowExceptionAndWarning(TdsP****rStateObject stateObj)
       at System.Data.SqlClient.TdsP****r.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsP****rStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
       at Axosoft.Common.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at Axosoft.Common.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
       at Axosoft.OnTime.DataLayer.Defects.GetPage(PageIdType getPageBy, Int32 pageNumber, Int32 rowCount, User currentUser, Int32 projectId, String filterString)
       at Axosoft.OnTime.DataLayer.Defects.GetPage(PageIdType getPageBy, Int32 pageNumber, Int32 rowCount, User currentUser)
       at Axosoft.OnTime.UserInterface.MainForm.RefreshDefectsDataSet(Int32 selectedProjectId, Boolean includeArchived, Boolean includeInactiveProjects, Boolean includeSubprojects)
       at Axosoft.OnTime.UserInterface.OnTimeUtils.DefectsControl.RefreshDefectsDataSet()
       at Axosoft.OnTime.UserInterface.OnTimeUtils.DefectsControl.RefreshDefectListView(Boolean hitDatabase, Int32 selectedId)
       at Axosoft.OnTime.UserInterface.MainForm.RefreshDefectListView(Boolean hitDatabase, Int32 selectedId)
       at Axosoft.OnTime.UserInterface.MainForm.RefreshTabs(Boolean hitDatabase)
       at Axosoft.OnTime.UserInterface.MainForm.SelectedProjectChanged(Object sender, EventArgs ea)
       at Axosoft.OnTime.UserInterface.OnTimeUtils.ProjectsTreeControl.OnSelectedProjectChanged()
       at Axosoft.OnTime.UserInterface.OnTimeUtils.ProjectsTreeControl.projectsTree_AfterSelect(Object sender, TreeViewEventArgs ea)
       at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)
       at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
       at System.Windows.Forms.TreeView.WmNotify(Message& m)
       at System.Windows.Forms.TreeView.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    ----------------------------------------
    OnTime
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/OnTime.exe
    ----------------------------------------
    Axosoft.OnTime.DataLayer
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTime.DataLayer.DLL
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    Axosoft.Common.Utilities
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.Utilities.DLL
    ----------------------------------------
    Axosoft.OnTimeWinControls
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeWinControls.DLL
    ----------------------------------------
    Axosoft.Common.ExceptionManagement
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.ExceptionManagement.DLL
    ----------------------------------------
    Axosoft.OnTimeResources
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeResources.DLL
    ----------------------------------------
    System.Xml
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Configuration
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    swconeza
        Assembly Version: 7.0.1.7150
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Axosoft.Common.Data
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.Data.DLL
    ----------------------------------------
    System.Web.Services
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
    ----------------------------------------
    Axosoft.OnTimeConfiguration
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeConfiguration.DLL
    ----------------------------------------
    System.Data
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    System.Transactions
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
    ----------------------------------------
    System.EnterpriseServices
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    ----------------------------------------
    System.Security
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    ----------------------------------------
    e4pzwbts
        Assembly Version: 7.0.1.7150
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    wg04ch4v
        Assembly Version: 7.0.1.7150
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    y34plgsv
        Assembly Version: 7.0.1.7150
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    rvsamvqv
        Assembly Version: 7.0.1.7150
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    Axosoft.OnTimeDashboard
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.OnTimeDashboard.DLL
    ----------------------------------------
    Axosoft.WinControls
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.WinControls.DLL
    ----------------------------------------
    HTMLEditorControl
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/HTMLEditorControl.DLL
    ----------------------------------------
    AxInterop.SHDocVw
        Assembly Version: 1.1.0.0
        Win32 Version: 1.1.0.0
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/AxInterop.SHDocVw.DLL
    ----------------------------------------
    Microsoft.mshtml
        Assembly Version: 7.0.3300.0
        Win32 Version: 7.0.3300.0
        CodeBase: file:///C:/WINXP/assembly/GAC/Microsoft.mshtml/7.0.3300.0__b03f5f7f11d50a3a/Microsoft.mshtml.dll
    ----------------------------------------
    SHDocVw
        Assembly Version: 1.1.0.0
        Win32 Version: 1.1.0.0
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/SHDocVw.DLL
    ----------------------------------------
    Accessibility
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    ----------------------------------------
    SharpGraph.Windows
        Assembly Version: 1.1.0.1545
        Win32 Version: 1.1.0.1545
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/SharpGraph.Windows.DLL
    ----------------------------------------
    System.Design
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.42 (RTM.050727-4200)
        CodeBase: file:///C:/WINXP/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
    ----------------------------------------
    WebKeyGenerator
        Assembly Version: 2.0.2049.23152
        Win32 Version: 1.1.0.1545
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/SharpGraph.Windows.dll
    ----------------------------------------
    Axosoft.Common.Utilities.TextHelper
        Assembly Version: 7.0.1.7150
        Win32 Version: 7.0.1.7150
        CodeBase: file:///C:/Program%20Files/Axosoft/OnTime%202007/OnTime%20Windows/Axosoft.Common.Utilities.TextHelper.DLL
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.

  •  03-06-2007, 12:06 PM 10428 in reply to 10427

    RE: EXception

    Can you tell me if you get the login screen to login to the OnTime database before or after you get this error message? Looking at the error message that you have posted, it seems that your SQL connection settings are broken. Please make sure that you are able to go to Tools > Manage Database and select the "Test Connection" button which will give you a response from the SQL server as to which version of the database your currently running. This will tell us if the connection is good or bad. Are all of the users affected by this problem in your environment or just certain ones?

     

    Thank you,

    Axosoft Support

     


    Dragan Marceta
    www.Axosoft.com
  •  03-07-2007, 2:18 AM 10429 in reply to 10427

    RE: EXception

    I get the login page and th eerror comes immediately after. I get to see the project structure, but it doesn't show defects.

    I observed the following after looking at the Manage Database page:

    1) Password field was blank.

    2) Test connection failed

    3) Entered password

    4) Connection successfull

    5) After choosing "Open database" I get login screen again.

    6) Receives same error after login

    7) When I go back to Manage Database, password field is blank.

    8) When I compare to OnTime 2006, I can see that password field is filled with ****'s in the password field of 2006 version.

    /Jesper

  •  03-07-2007, 4:03 PM 10430 in reply to 10427

    RE: EXception

     

    The password to your SQL server is still stored in the OnTime.config file which is located on the local workstation. In 2007, we have removed the ability to cache the password on the manage database window due to security reasons. Many users in OnTime 2006 were selecting the option to create a new database while the password was being cached on the manage database window allowing them to create new OnTime databases on their SQL servers.

     

    Would it be possible if we could connect remotely to your local machine via gotomeeting to take a look at this problem for you? If yes, please send us your contact information via email to Support@axosoft.com

     

    Thank you,

    Axosoft Support

     


    Dragan Marceta
    www.Axosoft.com
  •  03-08-2007, 6:56 AM 10431 in reply to 10427

    RE: EXception

    Got new info that pinpoints it:

    The following sql is executed against the database. It both fails on our converted database and the default database that OnTime install for you. So you shoul dbe able to reproduce the error with this sql.

    >>>>>>>>>>>>>>>>> Snippet >>>>>>>>>>>>>>>>>>>

    exec spS_Defects_WithNames @FilterByProjectSelection = 1,
    @ProjectId = 3286,
    @IncludeArchived = 0,
    @IncludeInactiveProjects = 0,
    @IncludeSubProjects = 1,
    @where = N'(Defects.ProjectId in (0,2246,2248,2249,2250,2251,2252,2253,2254,2255,2256,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2270,2273,2274,2298,2299,2300,2301,2302,2303,2304,2305,2308,2313,2321,2323,2324,2326,2328,2356,2388,2389,2390,2391,2392,2393,2394,2395,2426,2427,2428,2430,2431,2432,2455,2456,2459,2460,2461,2462,2463,2464,2469,2470,2471,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488,2489,2490,2491,2523,2525,2528,2530,2531,2532,2533,2534,2535,2537,2538,2539,2540,2541,2542,2543,2544,2545,2546,2548,2549,2550,2551,2553,2554,2556,2557,2558,2559,2562,2564,2565,2566,2568,2569,2570,2571,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2610,2612,2615,2616,2617,2618,2619,2620,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2688,2689,2690,2691,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2711,2712,2717,2718,2719,2720,2721,2724,2725,2727,2728,2731,2734,2741,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2756,2757,2758,2759,2760,2761,2764,2765,2767,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2784,2785,2786,2787,2788,2789,2790,2791,2793,2794,2799,2801,2802,2803,2804,2805,2807,2808,2809,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2847,2849,2850,2851,2852,2853,2856,2857,2858,2859,2860,2861,2862,2863,2864,2867,2868,2869,2870,2871,2874,2875,2876,2877,2878,2879,2882,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2898,2899,2901,2903,2905,2906,2907,2908,2909,2910,2912,2913,2914,2916,2917,2921,2922,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2974,2975,2977,2978,2979,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3029,3030,3031,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3056,3057,3058,3059,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3202,3203,3204,3205,3207,3208,3209,3210,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3235,3236,3237,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253,3254,3255,3256,3258,3259,3260,3261,3262,3263,3264,3265,3266,3267,3268,3269,3270,3271,3272,3273,3274,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3298,3299,3300,3302,3303,3304,3305,3306,3307,3308,3309,3310,3311,3312,3313,3314,3315,3316,3317,3319,3320,3321,3322,3323,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3349,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3385,3386,3387,3388,3389,3390,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404))',
    @orderby = N'Defects.DefectId',
    @page = 0,
    @rowcount = 0

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    Notice that if you shorten the @where line to something like this, no error is thrown.

    @where = N'(Defects.ProjectId in (0,2246,3404))',

     

     

  •  03-12-2007, 1:50 AM 10432 in reply to 10427

    RE: EXception
    Bump...
  •  03-12-2007, 2:56 PM 10433 in reply to 10427

    RE: EXception

    I think the following error message is generated by the OnTime search box in the windows or web client. Please verify that your search field in the OnTime client is completely empty, close the application and re-open it to see if this error message comes up. I have noticed that when removing the search criteria, this error message is no longer a problem. If this is the case, then we know what the problem is. Please let us know what you can find out on this issue.

    Thank you,

    Axosoft Support

     


    Dragan Marceta
    www.Axosoft.com
  •  03-16-2007, 7:22 AM 10434 in reply to 10427

    RE: EXception

    The search box was empy, but I forced a clear of it, and also did a reset of usersettings. Same error.

    I suspected that the huge number of project id's in the sql was the reason so I deleted projects from the database until the error disappeared, which confirms my suspicion.

    I then navigated between folders and used sql profiler to watch the sql, and noticed that the list of project id's was the same no matter what project I navigated to. So somehow this list must be compiled in the OnTime application. I noticed the same list of project id's in the thread called "Search error".

    I suggest the same approach as in the "search error" case: That I provide you the database for you to reproduce. You can contact me for a link to it (8 MB).

     

    Brgds. Jesper, Sitecore

  •  03-22-2007, 2:46 AM 10792 in reply to 10434

    Re: RE: Exception
    On request from one of your supporters I sent an Ontime database to Axosoft that should reproduce the error. But didn't hear anything since. Any news regarding this?
  •  03-26-2007, 12:11 PM 10885 in reply to 10792

    Re: RE: Exception

    In OnTime 2007 we moved the filtering of items to the SQL Server so we can do paging on the SQL Server as well.  Doing this means we have to pass all the filtering criteria to the stored procedures, and because we want to support SQL 2000 it means we are restricted to 4000 character length parameter (nvarchar(4000)).  The problem happens when you have a large number of projects or a large number of custom fields, which causes the filters being passed into the stored procedures to be larger than 4000 characters.

    There is a workaround for this if you are using SQL 2005.  SQL 2005 introduces the concept of nvarchar(max), which basically removes the 4000 character limit on the nvarchar data type.  There are 9 stored procedures which need to have all instances of nvarchar(4000) changed to nvarchar(max):
    spS_Defects_WithNames
    spS_Defects_WithNames_Count
    spS_Features_WithNames
    spS_Features_WithNames_Count
    spS_Incidents_WithNames
    spS_Incidents_WithNames_Count
    spS_Tasks_WithNames
    spS_Tasks_WithNames_Count
    spS_Dashboard_MiniDashboard
    Each stored procedure has 2-3 parameters of that type as well as a couple of variables. Make sure to back up your database before modifying anything.

    If you are using SQL 2000, unfortunately there is no easy fix for this.  You may want to consider upgrading to SQL 2005, or using the free SQL 2005 Express edition.

    We plan on addressing this issue, but because it involves multiple stored procedures it will most likely not be in the 7.0.2 release, which is already in testing.  I apologize for the inconvenience, but we are trying to make sure the fix will not cause any further problems.


    Dan Suceava
    http://www.axosoft.com
  •  03-28-2007, 1:29 AM 10919 in reply to 10885

    Re: RE: Exception

    Thanks a lot Dan

     Good information is the next best thing to actually have it working.

    Smile Jesper

  •  03-29-2007, 9:58 AM 10959 in reply to 10919

    Re: RE: Exception

    Interesting conversation; this is exactly what we are experiencing with OnTime 2007. I reported defect 1922 2 day's ago describing exactly the same problem (what happened to you're outstanding customer support? I haven't got any feed back on this defect! Sad )

    Please hurry with fixing this problem. It keeps us from migrating to OnTime 2007 while we want 2007 very vary badly.

    I'm not very comfortable with changing the mentioned stored procedures; but if it's the only solution for now I'll guess it's the best option. Can you give us an indication when we can expect a solution so we can decide on the appropriate action?

     


    Paul Greefhorst
    Quadrantr Software BV
  •  03-30-2007, 6:25 AM 10979 in reply to 10959

    Re: RE: Exception

    SOLVED! Big Smile

    It only took 10 mintutes to script the mentioned stored procs en 'gloabal replace' nvarchar(4000) to nvarchar(max).  I don't get the mentioned errors anymore and I can start my weekend with the idea that mayby somewere next week we can migrate to Ontime 2007. A great way to end the week.

    Dan, thanks a lot for your information.

     


    Paul Greefhorst
    Quadrantr Software BV
View as RSS news feed in XML

© 2002 - 2007, Axosoft, LLC. All Rights Reserved. | Privacy
Bug Tracking | Defect Tracking Videos | Help Desk Software