Category: Error Resolution

Error : Font in Outlook Compose Email window is very small even though font size is 11

Issue : Font in Outlook Compose Email window is very small even though font size is 11

Resolution :

Click on Zoom button and change Zoom % to 100

Unable to install .NET Framework 4.5 using dotNetFx45_Full_setup.exe installer without internet connection in server

Error :

Unable to install .NET Framework 4.5 using dotNetFx45_Full_setup.exe installer without internet connection in server

Resolution :
dotNetFx45_Full_setup.exe installer is web installer for .NET Framework 4.5. .NET Framework 4.5 installer are of two types :
1. Web Installer : Requires internet connection
2. Offline Installer : Does not require internet connection
Step 1 : Download .NET Framework 4.5 Offline installer ( dotNetFx45_Full_x86_x64.exe )
Step 2: Run and install dotNetFx45_Full_x86_x64.exe

Error : ORA-01460: unimplemented or unreasonable conversion requested

Error

ORA-01460: unimplemented or unreasonable conversion requested

Error Details

Getting the above error when trying to pass byte array of size greater than 32 K to Oracle BLOB column in ADO.NET code.

Solution

Remove the blob parameter from main insert or update statement and use below code to update Blob parameter later
OracleCommand cmd = new OracleCommand();
OracleConnection oraConn = new OracleConnection(“Data Source=Emp;User ID=Emp;Password=Emp”);
oraConn.Open();
OracleTransaction myTrans;
myTrans = oraConn.BeginTransaction(System.Data.IsolationLevel.ReadCommitted);
cmd.Transaction = myTrans;
cmd.CommandText = “DECLARE dpBlob BLOB; BEGIN DBMS_LOB.CREATETEMPORARY(dpBlob, False, 0); :tmpBlob := dpBlob; END;”;
cmd.Parameters.Add(new OracleParameter(“tmpBlob”, OracleType.Blob)).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
OracleLob tempLob = default(OracleLob);
tempLob = (OracleLob)cmd.Parameters[0].Value;
tempLob.BeginBatch(OracleLobOpenMode.ReadWrite);
               
tempLob.Write(doc, 0, doc.Length);
               
tempLob.EndBatch();
cmd.Parameters.Clear();
               
cmd.CommandText = “Update EmpDocument Set DOC = :blb WHERE EMPID= “ + empID;
                
cmd.CommandType = CommandType.Text;
               
cmd.Parameters.Add(new OracleParameter(“blb”, OracleType.Blob)).Value = tempLob;
               
cmd.ExecuteNonQuery();
               
myTrans.Commit();
Reach out to contactus@alltechnicalfaqs.com in case of further queries

Other Error Resolution :

Error : dll file is being used by another process

Error : Unable to copy file XYZ.dll. The process cannot access the file XYZ.dll because it is being used by another process

Resolution :

Go to windows command prompt  ( Click on Start -> Run -> Type cmd -> Press OK )

Type tasklist /m and Press enter

The above command will list all the process i.e exe and dlls each process is using

Find out which process i.e exe is using the dll XYZ.dll

Then go to Task Manager and End the process

Error : The type or namespace name ‘ScriptManager’ does not exist in the namespace ‘System.Web.UI’ (are you missing an assembly reference?)

Error :

The type or namespace name ‘ScriptManager’ does not exist in the namespace ‘System.Web.UI’ (are you missing an assembly reference?)

Error Details :

Getting above error on addition ScriptManager to .aspx page

Solution :

Add the System.Web.Extensions.dll reference to project to resolve above error.