Category: SOA
-
[SQLServer]Could not find stored procedure ‘master..xp_jdbc_open2’.
Problem: <Console encountered the following error java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Could not find stored procedure ‘master..xp_jdbc_open2’. Workaround: Go to your Data Source configuration on Weblogic Console and change the Driver Class Name to following: weblogic.jdbc.sqlserver.SQLServerDriver These are the drivers for NonXA data source. However if you want to create an XA connection with MS SQL server…
-
Conversion of type ” whose JDBC type is OTHER to a Java object is not supported.
While calling a Store procedure from MS SQL server, following issue can come Problem: Conversion of type 365366 whose JDBC type is OTHER to a Java object is not supported. An attempt was made to convert type 365366 to a Java object using an unsupported JDBC type: OTHER.; nested exception is: BINDING.JCA-11800Unimplemented object conversion.Conversion of type 365366 whose JDBC type is OTHER to a Java object is not supported.An attempt was made to convert type 365366 to a Java object using an unsupported JDBC type: OTHER. Use a data type with a supported JDBC type. Solution: Go to your Database adapter connection factory and change PlateformClassName from org.eclipse.persistence.platform.database.Oracle10Platform To oracle.toplink.platform.database.SQLServerPlatform
-
Caused by java.sql.SQLException: Cannot call Connection.commit in distributed transaction
Problem: unknown failed. Descriptor name: [unknown].Caused by java.sql.SQLException: Cannot call Connection.commit in distributed transaction. Transaction Manager will commit the resource manager when the distributed transaction is committed..; nested exception is: BINDING.JCA-11616DBWriteInteractionSpec Execute Failed Exception.unknown failed. Descriptor name: [unknown].Caused by java.sql.SQLException: Cannot call Connection.commit in distributed transaction. Transaction Manager will commit the resource manager when the distributed transaction is committed..Please see the logs for the full DBAdapter logging output prior to this exception. This exception is considered retriable, likely due to a communication failure. To classify it as non-retriable instead add property nonRetriableErrorCodes with value “0” to your deployment descriptor (i.e. weblogic-ra.xml). To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff. All properties are integers. Workaround: Uncheck Support global transaction option in data source Transaction section as shown below: Best Camping Cot
-
Resolved:Connection refused: connect. CFGFWK-60850: Test Failed!
While extending SOA domain for OSB, we can come across the following issue Component Schema=OSB JMS Reporting Provider Driver=org.apache.derby.jdbc.ClientDriver URL=jdbc:derby://localhost:1527/osbexamples;ServerName=localhost;databaseName=osbexamples User=DEV_SOAINFRA Password=******** SQL Test=SELECT 1 FROM SYS.SYSTABLES java.net.ConnectException : Error connecting to server localhost on port 1527 with message Connection refused: connect. CFGFWK-60850: Test Failed! OR SQL Test=SELECT 1 FROM SYS.SYSTABLES Insufficient data while reading…
-
There is not an activity (receive/pick) to start the process
Sometimes when we create SOA BPEL with define service interface later, we get the below error even if we add the receive activity. Error(52): There is not an activity (receive/pick) to start the process Error(52): Initial activity is invalid. An initial activity must be of a receive or pick activity. Error: there is no receive…
-
Error occurred during initialization of VM
After fresh installation of Oracle SOA, I started getting the below error while starting servers. Error occurred during initialization of VM Could not reserve enough space for object heap Could not create the Java virtual machine. After trying different solution from the Web I changed the JDK version and it started working fine. I was…
-
BPM Timer Process java.lang.NoClassDefFoundError: oracle/bpm/runtime/quartz/trigger/TriggerWithReschedule
Following issue came because one of the library could not be loaded. So you need to add that library to lib directory of your SOA domain. Go to the /oracle/Middleware/Oracle_SOA1/soa/modules and then copy the oracle.bpm.runtime.classloader-util.jar jar file. Go to /oracle/Middleware/user_projects/domains/[domain_name]/lib directory and past that file. restart the servers, hope this will help. javax.ejb.EJBException: EJB Exception: :…
-
java.sql.SQLException: ResultSet.next was not called Oracle JDeveloper, B2B Callout
While running a Java code of B2B callout i was getting the below error. This was due to below Java code. The commented code was causing the problem then i defined it in if statement as shown below. I hope you understand the reason. PreparedStatement pstmt = conn.prepareStatement(“My select query=?”); pstmt.setInt(1,…
-
javax.naming.CommunicationException [Root exception is java.net.ConnectException: t3: Destination unreachable
While compiling some code in JDeveloper I was getting the below error. It was coming due to proxy issue. So go to Jdeveloper then Tools—Preferences—Web Browser and Proxy then in exceptions field enter your server hostname. Test your code again and this time hopefully error will not come. It resolved my issue and i hope…
-
java.security.PrivilegedActionException: weblogic.common.ResourceException Oracle SOA
java.security.PrivilegedActionException: weblogic.common.ResourceException: java.security.PrivilegedActionException: weblogic.common.ResourceException: No credential mapper entry found for password indirection user=apps for data source DataSourceName While creating a war file and then deploying on weblogic we get this error. To get ride of this error in Jdeveloper go to application properties and then deployments and then uncheck “Auto Generate and Synchronize weblogic-jdbc.xml Descriptors During…