The default value of AJAX postback is 90 seconds, so if you have a long asynchronous postback, you will get an error as this:
Sys.WebForms.PageRequestManagerTimeoutException: The server request timed out.
The fix is to change the default timeout value to a larger value in your ScriptManger’s AsyncPostBackTimeout property (10 minutes as below):
<asp:ScriptManager ID="ScriptManager1" runat="server" AsyncPostBackTimeout="600">
If you use Oracle ODP.NET in Visual Studio 2010 (or earlier version) to create a DataTable by using TableAdapter wizard, you may get an Invalid Parameter Binding error if there is a parameter in your query. For example, this simple select query below can cause the error:
select * from Person where personId=:person_uid
The cause is strange because ODP.NET cannot recognize the parameter’s DbType and thus sets the DbType of the parameter to Object, so the fix is simple: just change the DbType from Object to Int32 or the correct DbType.
In Visual Studio, right click the query of the TableAdapter, then click Properties. From the Properties window, click Parameters drop down list, then change the DbType of the parameter from Object to Int32 (or the correct DbType in your application):
After the change, the error will go away. However, if you ever change the query, you will need to remember to change the DbType again because ODP.NET will set it to Object again.