Wednesday, July 17, 2013

ORA-01000: maximum open cursors exceeded


Possible Fix :

1)Ensure Oracle 8.1.7 JDBC driver or a later version should be used
2)Java code can be checked for closure of ResultSet & Statement after the using this specific stored procedure
3) Increase the value of OPEN_CURSORS parameter in Oracle

Steps to fix:



1)Do static code check and all of the cursors/connections are closed properly in the java code
2) Ask DBA Team to check the value of OPEN_CURSORS parameter in Oracle and see whether the value is too less or not.
3)Further analysis is possible only if we are having details of all open cursors at the time of exception (DBA Team can provide the details of opened cursors)


EPS file does not open correctly in photoshop-("Could not open or parse a DSC plate file because the file cannot be found"):


I have an issue from Customer saying that .eps file is not opened properly in photoshop application and throws the error "Could not open or parse a DSC plate file because the file cannot be found".

1)Downloaded open source viewer application such as InfraView and installed.The .eps file opened propely but in blurred form, so that I fgiured out some information is missing to reconstruct the file.
2)Tried to open in photoshop and got the error.I converted psd file to eps file which worked fine.At that time I came across options 'multiple file version/single file version' before saving the psd file to eps.
3)read more about EPS file format in internet and clarified about 'multiple file version/single file version'
4)Opened the error .eps file in Notepad++ and checked and found out .C,.M,.Y and .K files are missing and that was originally created as multiple file version.


Resolution:

EPS file was created as multiple file version and some of the files are missed out( Logo.C,Logo.M, Logo.Y,Logo.K ).
create single file version of eps file and upload the image to Application

Unable to install the trial version of a product with IBM Installation Manager:

I  downloaded trial version of rational application developer (RAD) from IBM website and tried to install the product. Normally all of the IBM products will be installed via IBM installation manager. The configuration file packed inside installation file (exe) will have information to obtain IBM product repository, in out case this is http link https://www-912.ibm.com/software/repositorymanager/action/getInitData

I clicked on the installation file which extracted the files to temporary location and started screens to install the installation manager and received popup with below error

CRIMC1085E: Resumable download failed for: https://www.ibm.com/software/repositorymanager/action/getInitData.    CRIMC1083E: Failed to retrieve 'https://www.ibm.com/software/repositorymanager/action/getInitData'.      CRIMC1084E: An exception is thrown while retrieving the file 'https://www.ibm.com/software/repositorymanager/action/getInitData' to 'C:\Users\ADMINI~1\AppData\Local\Temp\cicdip_Administrator\1374108030737\nf\cicURLLgetInitData7337285020417225312.tmp'.      This issue can occur for different reasons. You might have an issue with your network connection. If you retrieve the file from a machine or network in your environment, the file system might be mounted incorrectly. On AIX, when you install from a file system that is mounted with the 'cio' option, the installation fails with the exception: A system call received a parameter that is not valid.      Verify your network connection. If you retrieve the files from your environment, copy the source files to a different file system and install from that file system.      java.net.ConnectException: Connection timed out: connect

I ignored the error and installed "IBM installation manager" and I restarted the installation manager and agian failed with same error, I ignored the error and the installation manager didn't have any repositories to install RAD. So I searched in Google and found IBM support page http://www-01.ibm.com/support/docview.wss?uid=swg21457139 which says "Turn Off firewall". But firewall is already disabled in my system. 

My computer is connected to internet via proxy server and based on the error message I suspected that proxy server needs to be configured to obtain the repository information and I'm right.From the installation manager I clicked "Add Repositories" link and expanded "Internet" option and configured proxy server details.

 How do we get repository information to install RAD ? 


Accessed the link https://www.ibm.com/software/repositorymanager/action/getInitData obtained from error message which returns RAD repository data in XML tags. Specified the repository information in Installation manager which listed RAD 9.0 under installation packages.

Note:You need to provide credentials for proxy server and IBM site credentials when repository information is validated in installation manager.RAD repository location: https://www.ibm.com/software/repositorymanager/com.ibm.rational.application.developer.v9

 

 

Enter your Comments