Excel Import Issue in Ginesys Web
SYMPTOMS
Requested by: Gyanesh Kumar 13/Feb/2019
Import process of excel file performs in the module Admin > Utilities > Data Import. After clicking Add button, number of steps need to import excel file.
Step 1: Select the source file.
Most of the time there is no issue in Step 1. After clicking the Next button, the pre-loader animation “Uploading” is showing continuously. If you wait for 15-20 seconds without closing or refreshing the page, then the screen will stuck as shown in the screenshot below:
RESOLUTION
Follow the given steps to resolve the issue -
Solution 1:
You can un-install the 32-bit version of Microsoft Office and install the 64-bit version of Microsoft Office in your system to resolve the issue.
If the above solution is not possible then please go through the following steps to fix the issue.
Solution 2:
Step 1:
Go to Control Panel and type "Microsoft Access" to check if Microsoft Access Database Engine 2010 is installed on the system or not.
Step 2:
Right click on "My Computer" and select "Properties" to check the windows operating system installed on the system is 32-bit or 64-bit.
Step 3:
Download the required version of AccessDatabaseEngine.exe / AccessDatabaseEngine_x64.exe from the Microsoft website by clicking on the following link:
Step 4:
Browse through the local path where AccessDatabaseEngine.exe / AccessDatabaseEngine_x64.exe is downloaded and open command prompt or windows power shell.
Step 5:
Run the command "AccessDatabaseEngine.exe /passive" or "AccessDatabaseEngine_x64.exe /passive" according to the version downloaded for your system.
Step 6:
Wait for approx 30 seconds for the installer to finish, because you will not get any notification by the installer after finishing the installation.
Step 8:
Open the Control Panel to check the whether it has been installed or not.
Step 9:
- Go to Run and type “regedit” and browse to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths.
- You can find the value mso.dll on the right hand side.
- Delete the mso.dll file.
Step 10:
Refresh the browser and re-start the import process from the beginning.
Solution 3:
Step 1: Please check the log file in \Shared\WebAPI\Logs and find ErrrApp.txt.
Step 2: Press Ctrl + End and check the error details with the current time.
The error is : " (Inner Exception #0) NHibernate.Exceptions.GenericADOException: could not execute query [ select int$pkg_STORFRANOUT.int$pkg_STORFRANOUT_clear(:p0) from dual ] Name:p_userid - Value:1035 [SQL: select int$pkg_STORFRANOUT.int$pkg_STORFRANOUT_clear(:p0) from dual] ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-01013: user requested cancel of current operation ORA-06512: at "ARPL.INT$PKG_STORFRANOUT" "
Step 3: Go to the \Shared\WebAPI\Logs\Others folder and check the nhibernate log.
Step 4: Press Ctrl + End and check the following sql query given below: