[Dev] Need help and suggestions for Unified dashboard work
Hi Manu/Dunith, I am in the process of creating gadgets for the unified dashboard. I am using the wso2das-3.0.0-SNAPSHOT dashboard for this purpose. I have attached images of the current state of the gadgets i have created. Kindly shed light on the following 3 points. - I need guidance to do the following: 1. Need to customize and format the gadget container (padding, etc...). 2. Create a custom layout for the dashboard page - I am creating gadgets with graphs (with controls such as drop downs). I would like to know if the controls have to be included in the gadget itself or whether it should be placed as a separate gadget, or any other manner. - I am using jaggery for database connectivity. I am unable to host the jaggery files in the shindig server. When i hosted the jaggery files separately i was able to get the data for the gadget graphs. Is it not possible to host jaggery files in the shindig server? Kindly provide alternatives if it is not. Thanks in advance Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] [DAS] ERROR:java.sql.SQLException: Invalid value for getInt() - 'id'
Hi, I created a datasource (RDBMS) and I am trying to retrieve data in that to the DAL. I was able to create the temporary tables using: *create temporary table tempSparkTable using CarbonJDBC options (dataSource localDB, tableName test123); CREATE TEMPORARY TABLE tempDASTable USING CarbonAnalytics OPTIONS (tableName dasTemp, schema id INT, name STRING, countN INT);* When i tried to insert values using the following command: *insert overwrite table tempDASTable select id, name, countN from tempSparkTable;* i got the following error: *ERROR: *Job aborted due to stage failure: Task 0 in stage 1.0 failed 1 times, most recent failure: Lost task 0.0 in stage 1.0 (TID 1, localhost): java.sql.SQLException: Invalid value for getInt() - 'id' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:997) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:983) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:928) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2758) at org.apache.spark.sql.jdbc.JDBCRDD$$anon$1.getNext(JDBCRDD.scala:416) at org.apache.spark.sql.jdbc.JDBCRDD$$anon$1.hasNext(JDBCRDD.scala:472) at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327) at org.wso2.carbon.analytics.spark.core.sources.AnalyticsWritingFunction.apply(AnalyticsWritingFunction.java:72) at org.wso2.carbon.analytics.spark.core.sources.AnalyticsWritingFunction.apply(AnalyticsWritingFunction.java:41) at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:878) at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:878) at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1767) at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1767) at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:63) at org.apache.spark.scheduler.Task.run(Task.scala:70) at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:213) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) I get the same error when i try to use the following command in the console in DAS: *select * from tempSparkTable* Kindly provide assistance to overcome this issue. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [DAS] ERROR:java.sql.SQLException: Invalid value for getInt() - 'id'
sure Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Thu, Aug 27, 2015 at 12:22 PM, Niranda Perera nira...@wso2.com wrote: Hi Nashri, this error comes from the Spark native jdbc connector as well. I'm currently working on this. let me check. in the mean time can you open a JIRRA for this best On Thu, Aug 27, 2015 at 12:20 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I created a datasource (RDBMS) and I am trying to retrieve data in that to the DAL. I was able to create the temporary tables using: *create temporary table tempSparkTable using CarbonJDBC options (dataSource localDB, tableName test123); CREATE TEMPORARY TABLE tempDASTable USING CarbonAnalytics OPTIONS (tableName dasTemp, schema id INT, name STRING, countN INT);* When i tried to insert values using the following command: *insert overwrite table tempDASTable select id, name, countN from tempSparkTable;* i got the following error: *ERROR: *Job aborted due to stage failure: Task 0 in stage 1.0 failed 1 times, most recent failure: Lost task 0.0 in stage 1.0 (TID 1, localhost): java.sql.SQLException: Invalid value for getInt() - 'id' at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:997) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:983) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:928) at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2758) at org.apache.spark.sql.jdbc.JDBCRDD$$anon$1.getNext(JDBCRDD.scala:416) at org.apache.spark.sql.jdbc.JDBCRDD$$anon$1.hasNext(JDBCRDD.scala:472) at scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327) at org.wso2.carbon.analytics.spark.core.sources.AnalyticsWritingFunction.apply(AnalyticsWritingFunction.java:72) at org.wso2.carbon.analytics.spark.core.sources.AnalyticsWritingFunction.apply(AnalyticsWritingFunction.java:41) at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:878) at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:878) at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1767) at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1767) at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:63) at org.apache.spark.scheduler.Task.run(Task.scala:70) at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:213) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) I get the same error when i try to use the following command in the console in DAS: *select * from tempSparkTable* Kindly provide assistance to overcome this issue. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com -- *Niranda Perera* Software Engineer, WSO2 Inc. Mobile: +94-71-554-8430 Twitter: @n1r44 https://twitter.com/N1R44 https://pythagoreanscript.wordpress.com/ ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [ESB] 101500 ERROR_MESSAGE : Error in Sender
Hi, 1) I couldn't find the line to enable wire logs in my log4j file. Is it okay if i add the line to it? (log4j.logger.org.apache.synapse.transport.http.wire=DEBUG) 2) My init config is in the sequence *sf_auth* as below: salesforce.init xmlns=http://ws.apache.org/ns/synapse; usernamesesh...@wso2.com/username passwordp1ne@pplelrY5ZpMQVqPyPramkfIdKDYE6/password loginUrlhttps://login.salesforce.com/services/Soap/u/27.0/loginUrl /salesforce.init 3) When i added the logs, i find that error occurs at salesforce.getUserInfo configKey=*sf_auth*/salesforce.getUserInfo The error logs are as follows: [2015-08-18 14:42:22,950] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:4ca4be55-4b42-4b9f-89c3-3fc4b534a1a2, Direction: request, STATE = Before sf_auth sequence [2015-08-18 14:42:22,958] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:42:26,100] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the sequence. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:30 PM, Malaka Silva mal...@wso2.com wrote: Seems like an error when sending the message out. Can you put some logs in your mediation flow and identify with point it's failing? Also enabling wire logs will also help to find the failing point. Also share the salesfore.init config. On Tue, Aug 18, 2015 at 2:19 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am trying to get data from salesforce using salesforce connector by writing a proxy. I get the following error when i run the sequence/proxy: [2015-08-18 14:06:31,815] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:06:38,933] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached a sequence i have written for the above task. What could be the reason for this? Please help. Thanks in advance. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Malaka Silva Senior Tech Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/ http://www.wso2.com/about/team/malaka-silva/ http://wso2.com/about/team/malaka-silva/ Save a tree -Conserve nature Save the world for your future. Print this email only if it is absolutely necessary. ?xml version=1.0 encoding=UTF-8? sequence xmlns=http://ws.apache.org/ns/synapse; name=AccManagersSeq log property name=STATE value=Before sf_auth sequence/ /log salesforce.getUserInfo configKey=sf_auth/ log property name=STATE value=Authentication success!!!/ /log salesforce.query batchSize2000/batchSize queryStringSELECT Id,AccountId, Project__c, Name,Owner.Name,OwnerId, Products_in_use__c,Amount,FiscalQuarter,FiscalYear,IsClosed,IsWon,Opp_End_Date__c,Opp_Start_Date__c,LeadSource,Services_Amount__c,Opportunity_Term__c,Production_Support_Amount__c,Includes_Consulting__c,Includes_Dev_Support__c,Includes_Production_Support__c,Includes_QuickStart__c,Probability,Reason_Lost__c,ForecastCategory,Last_Account_Sale__c,CurrencyIsoCode, CloseDate FROM Opportunity/queryString /salesforce.query class name=org.wso2.carbon.solutions.sf.DateStamper/ log property name=STATE value=Query success!!!/ /log iterate xmlns:ns1=urn:partner.soap.sforce.com xmlns:ns=http://org.apache.synapse/xsd; continueParent=true expression=$body/ns1:queryResponse/ns1:result/ns1:records sequential=true target sequence dbreport connection pool passwordroot/password userroot/user urljdbc:mysql://localhost:3306/sf/url drivercom.mysql.jdbc.Driver/driver /pool /connection statement sql insert into AMpipeline(Id,AccountId, Project__c, Name,OwnerName,OwnerId, Products_in_use__c,Amount
[Dev] I/O error: General SSLEngine problem in ESB
Hi, I am getting the following error when i try to run a proxy which gets data from salesforce. Any idea how to solve this? TID: [0] [ESB] [2015-08-18 06:14:17,256] INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logged in at [2015-08-18 06:14:17,256-0400] {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} TID: [0] [ESB] [2015-08-18 06:15:34,645] INFO {org.apache.synapse.mediators.builtin.LogMediator} - To: /services/SalesforceProxy.SalesforceProxyHttpSoap12Endpoint, WSAction: urn:mediate, SOAPAction: urn:mediate, MessageID: urn:uuid:89a301b5-e7c4-4781-91c8-e4c677e2e4db, Direction: request, STATE = OPP {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-18 06:15:34,657] INFO {org.apache.synapse.mediators.builtin.LogMediator} - Connection = Login to Salesforce . {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-18 06:15:36,639] ERROR {org.apache.synapse.transport.passthru.TargetHandler} - I/O error: General SSLEngine problem {org.apache.synapse.transport.passthru.TargetHandler} javax.net.ssl.SSLHandshakeException: General SSLEngine problem at sun.security.ssl.Handshaker.checkThrown(Handshaker.java:1252) at sun.security.ssl.SSLEngineImpl.checkTaskThrown(SSLEngineImpl.java:514) at sun.security.ssl.SSLEngineImpl.writeAppRecord(SSLEngineImpl.java:1173) at sun.security.ssl.SSLEngineImpl.wrap(SSLEngineImpl.java:1145) at javax.net.ssl.SSLEngine.wrap(SSLEngine.java:469) at org.apache.http.nio.reactor.ssl.SSLIOSession.doWrap(SSLIOSession.java:220) at org.apache.http.nio.reactor.ssl.SSLIOSession.doHandshake(SSLIOSession.java:254) at org.apache.http.nio.reactor.ssl.SSLIOSession.isAppInputReady(SSLIOSession.java:380) at org.apache.http.impl.nio.reactor.AbstractIODispatch.inputReady(AbstractIODispatch.java:118) at org.apache.http.impl.nio.reactor.BaseIOReactor.readable(BaseIOReactor.java:160) at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvent(AbstractIOReactor.java:342) at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvents(AbstractIOReactor.java:320) at org.apache.http.impl.nio.reactor.AbstractIOReactor.execute(AbstractIOReactor.java:280) at org.apache.http.impl.nio.reactor.BaseIOReactor.execute(BaseIOReactor.java:106) at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor$Worker.run(AbstractMultiworkerIOReactor.java:604) at java.lang.Thread.run(Thread.java:701) Caused by: javax.net.ssl.SSLHandshakeException: General SSLEngine problem at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLEngineImpl.fatal(SSLEngineImpl.java:1660) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:289) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:281) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1255) at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:200) at sun.security.ssl.Handshaker.processLoop(Handshaker.java:848) at sun.security.ssl.Handshaker$1.run(Handshaker.java:788) at sun.security.ssl.Handshaker$1.run(Handshaker.java:786) at java.security.AccessController.doPrivileged(Native Method) at sun.security.ssl.Handshaker$DelegatedTask.run(Handshaker.java:1189) at org.apache.http.nio.reactor.ssl.SSLIOSession.doRunTask(SSLIOSession.java:238) at org.apache.http.nio.reactor.ssl.SSLIOSession.doHandshake(SSLIOSession.java:270) ... 9 more Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:386) at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:293) at sun.security.validator.Validator.validate(Validator.java:260) at sun.security.validator.Validator.validate(Validator.java:236) at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:147) at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:230) at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:270) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1234) ... 17 more Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:197) at java.security.cert.CertPathBuilder.build(CertPathBuilder.java:255) at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:381) ... 24 more TID: [0] [ESB] [2015-08-18 06:15:36,646] WARN {org.apache.synapse.endpoints.EndpointContext} - Endpoint : AnonymousEndpoint will be marked SUSPENDED as it failed {org.apache.synapse.endpoints.EndpointContext} TID: [0] [ESB] [2015-08-18 06:15:36,647] WARN {org.apache.synapse.endpoints.EndpointContext} - Suspending endpoint : AnonymousEndpoint - last
[Dev] [ESB] 101500 ERROR_MESSAGE : Error in Sender
Hi, I am trying to get data from salesforce using salesforce connector by writing a proxy. I get the following error when i run the sequence/proxy: [2015-08-18 14:06:31,815] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:06:38,933] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached a sequence i have written for the above task. What could be the reason for this? Please help. Thanks in advance. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ?xml version=1.0 encoding=UTF-8? sequence xmlns=http://ws.apache.org/ns/synapse; name=AccManagersSeq salesforce.getUserInfo configKey=sf_auth/ log property name=STATE value=Authentication success!!!/ /log salesforce.query batchSize2000/batchSize queryStringSELECT Id,AccountId, Project__c, Name,Owner.Name,OwnerId, Products_in_use__c,Amount,FiscalQuarter,FiscalYear,IsClosed,IsWon,Opp_End_Date__c,Opp_Start_Date__c,LeadSource,Services_Amount__c,Opportunity_Term__c,Production_Support_Amount__c,Includes_Consulting__c,Includes_Dev_Support__c,Includes_Production_Support__c,Includes_QuickStart__c,Probability,Reason_Lost__c,ForecastCategory,Last_Account_Sale__c,CurrencyIsoCode, CloseDate FROM Opportunity/queryString /salesforce.query class name=org.wso2.carbon.solutions.sf.DateStamper/ log property name=STATE value=Query success!!!/ /log iterate xmlns:ns1=urn:partner.soap.sforce.com xmlns:ns=http://org.apache.synapse/xsd; continueParent=true expression=$body/ns1:queryResponse/ns1:result/ns1:records sequential=true target sequence dbreport connection pool passwordroot/password userroot/user urljdbc:mysql://localhost:3306/sf/url drivercom.mysql.jdbc.Driver/driver /pool /connection statement sql insert into AMpipeline(Id,AccountId, Project__c, Name,OwnerName,OwnerId, Products_in_use__c,Amount,FiscalQuarter,FiscalYear,IsClosed,IsWon,Opp_End_Date__c,Opp_Start_Date__c,LeadSource,Services_Amount__c,Opportunity_Term__c,Production_Support_Amount__c,Includes_Consulting__c,Includes_Dev_Support__c,Includes_Production_Support__c,Includes_QuickStart__c,Probability,Reason_Lost__c,ForecastCategory,Last_Account_Sale__c,Currency_code, CloseDate,RecordDate) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) /sql parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:Id/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:AccountId/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:Project__c/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:Name/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:OwnerName/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:OwnerId/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com xmlns:nsb=urn:partner.soap.sforce.com expression=$body/nsb:records/nsa:Products_in_use__c/text() type=VARCHAR/ parameter xmlns:nsa=urn:sobject.partner.soap.sforce.com
Re: [Dev] [ESB] 101500 ERROR_MESSAGE : Error in Sender
Hi Malaka, I did import the .crt file from salesforce.com into the esb home/repository/resources/security folder. Is this the one you are referring to? If so, it didnt work. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 6:33 PM, Malaka Silva mal...@wso2.com wrote: Maybe the issue is related to [1]. Can you try importing the certificate to truststore pls? @Kesavan - Did you experience this behavior intermittently? [1] https://wso2.org/jira/browse/ESBCONNECT-60 On Tue, Aug 18, 2015 at 5:33 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, the sequence previously worked with the getUserInfo. i added an onError=fault, the logs are as follows: [2015-08-18 17:22:45,644] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:cb25cf91-f7fa-4681-beeb-c769ffebe7f4, Direction: request, STATE = Before sf_auth sequence [2015-08-18 17:22:45,644] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:cb25cf91-f7fa-4681-beeb-c769ffebe7f4, Direction: request, text = An unexpected error occured, message = null, Envelope: ?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv= http://www.w3.org/2003/05/soap-envelope;soapenv:BodyyAM data written successfully into pipeline table/y/soapenv:Body/soapenv:Envelope [2015-08-18 17:22:45,648] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 17:22:46,928] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the logs after enabling wire logs. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:54 PM, Malaka Silva mal...@wso2.com wrote: Why are you adding getUserInfo, since you are not using the response from it? Also try adding onError attribute to your sequence and check. eg: onError=fault More on wire logs with [1] [1] http://mytecheye.blogspot.com/2013/09/wso2-esb-all-about-wire-logs.html On Tue, Aug 18, 2015 at 2:46 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, 1) I couldn't find the line to enable wire logs in my log4j file. Is it okay if i add the line to it? (log4j.logger.org.apache.synapse.transport.http.wire=DEBUG) 2) My init config is in the sequence *sf_auth* as below: salesforce.init xmlns=http://ws.apache.org/ns/synapse; usernamesesh...@wso2.com/username passwordp1ne@pplelrY5ZpMQVqPyPramkfIdKDYE6/password loginUrlhttps://login.salesforce.com/services/Soap/u/27.0 /loginUrl /salesforce.init 3) When i added the logs, i find that error occurs at salesforce.getUserInfo configKey=*sf_auth* /salesforce.getUserInfo The error logs are as follows: [2015-08-18 14:42:22,950] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:4ca4be55-4b42-4b9f-89c3-3fc4b534a1a2, Direction: request, STATE = Before sf_auth sequence [2015-08-18 14:42:22,958] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:42:26,100] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the sequence. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:30 PM, Malaka Silva mal...@wso2.com wrote: Seems like an error when sending the message out. Can you put some logs in your mediation flow and identify with point it's failing? Also enabling wire logs will also help to find the failing point. Also share the salesfore.init config. On Tue, Aug 18, 2015 at 2:19 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am trying to get data from salesforce using salesforce connector by writing a proxy. I get the following error when i run the sequence/proxy: [2015-08-18 14:06:31,815] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:06:38,933] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached a sequence i have written for the above task. What could be the reason for this? Please help. Thanks in advance. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Malaka Silva Senior Tech Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/ http://www.wso2.com/about/team/malaka-silva/ http://wso2.com/about/team
Re: [Dev] I/O error: General SSLEngine problem in ESB
Hi Rajjaz, I got new security token and tried. still same error. And yes i have put the password and the token together. the thing is, this used to work fine just a few days back. I think this error occurs due to some expired certificate or something. But cant figure out where exactly. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 5:59 PM, Rajjaz Mohammed raj...@wso2.com wrote: Hi Aaquibah, i got the same error because of Security Token so can you check your credentials once again and for the Salesforce password is a combination of the user password plus the security token provided by Salesforce. On Tue, Aug 18, 2015 at 3:51 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am getting the following error when i try to run a proxy which gets data from salesforce. Any idea how to solve this? TID: [0] [ESB] [2015-08-18 06:14:17,256] INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logged in at [2015-08-18 06:14:17,256-0400] {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} TID: [0] [ESB] [2015-08-18 06:15:34,645] INFO {org.apache.synapse.mediators.builtin.LogMediator} - To: /services/SalesforceProxy.SalesforceProxyHttpSoap12Endpoint, WSAction: urn:mediate, SOAPAction: urn:mediate, MessageID: urn:uuid:89a301b5-e7c4-4781-91c8-e4c677e2e4db, Direction: request, STATE = OPP {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-18 06:15:34,657] INFO {org.apache.synapse.mediators.builtin.LogMediator} - Connection = Login to Salesforce . {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-18 06:15:36,639] ERROR {org.apache.synapse.transport.passthru.TargetHandler} - I/O error: General SSLEngine problem {org.apache.synapse.transport.passthru.TargetHandler} javax.net.ssl.SSLHandshakeException: General SSLEngine problem at sun.security.ssl.Handshaker.checkThrown(Handshaker.java:1252) at sun.security.ssl.SSLEngineImpl.checkTaskThrown(SSLEngineImpl.java:514) at sun.security.ssl.SSLEngineImpl.writeAppRecord(SSLEngineImpl.java:1173) at sun.security.ssl.SSLEngineImpl.wrap(SSLEngineImpl.java:1145) at javax.net.ssl.SSLEngine.wrap(SSLEngine.java:469) at org.apache.http.nio.reactor.ssl.SSLIOSession.doWrap(SSLIOSession.java:220) at org.apache.http.nio.reactor.ssl.SSLIOSession.doHandshake(SSLIOSession.java:254) at org.apache.http.nio.reactor.ssl.SSLIOSession.isAppInputReady(SSLIOSession.java:380) at org.apache.http.impl.nio.reactor.AbstractIODispatch.inputReady(AbstractIODispatch.java:118) at org.apache.http.impl.nio.reactor.BaseIOReactor.readable(BaseIOReactor.java:160) at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvent(AbstractIOReactor.java:342) at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvents(AbstractIOReactor.java:320) at org.apache.http.impl.nio.reactor.AbstractIOReactor.execute(AbstractIOReactor.java:280) at org.apache.http.impl.nio.reactor.BaseIOReactor.execute(BaseIOReactor.java:106) at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor$Worker.run(AbstractMultiworkerIOReactor.java:604) at java.lang.Thread.run(Thread.java:701) Caused by: javax.net.ssl.SSLHandshakeException: General SSLEngine problem at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLEngineImpl.fatal(SSLEngineImpl.java:1660) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:289) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:281) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1255) at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:200) at sun.security.ssl.Handshaker.processLoop(Handshaker.java:848) at sun.security.ssl.Handshaker$1.run(Handshaker.java:788) at sun.security.ssl.Handshaker$1.run(Handshaker.java:786) at java.security.AccessController.doPrivileged(Native Method) at sun.security.ssl.Handshaker$DelegatedTask.run(Handshaker.java:1189) at org.apache.http.nio.reactor.ssl.SSLIOSession.doRunTask(SSLIOSession.java:238) at org.apache.http.nio.reactor.ssl.SSLIOSession.doHandshake(SSLIOSession.java:270) ... 9 more Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target at sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:386) at sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:293) at sun.security.validator.Validator.validate(Validator.java:260) at sun.security.validator.Validator.validate(Validator.java:236) at sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:147) at sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:230
Re: [Dev] [ESB] 101500 ERROR_MESSAGE : Error in Sender
Hi, the sequence previously worked with the getUserInfo. i added an onError=fault, the logs are as follows: [2015-08-18 17:22:45,644] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:cb25cf91-f7fa-4681-beeb-c769ffebe7f4, Direction: request, STATE = Before sf_auth sequence [2015-08-18 17:22:45,644] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:cb25cf91-f7fa-4681-beeb-c769ffebe7f4, Direction: request, text = An unexpected error occured, message = null, Envelope: ?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv= http://www.w3.org/2003/05/soap-envelope;soapenv:BodyyAM data written successfully into pipeline table/y/soapenv:Body/soapenv:Envelope [2015-08-18 17:22:45,648] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 17:22:46,928] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the logs after enabling wire logs. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:54 PM, Malaka Silva mal...@wso2.com wrote: Why are you adding getUserInfo, since you are not using the response from it? Also try adding onError attribute to your sequence and check. eg: onError=fault More on wire logs with [1] [1] http://mytecheye.blogspot.com/2013/09/wso2-esb-all-about-wire-logs.html On Tue, Aug 18, 2015 at 2:46 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, 1) I couldn't find the line to enable wire logs in my log4j file. Is it okay if i add the line to it? (log4j.logger.org.apache.synapse.transport.http.wire=DEBUG) 2) My init config is in the sequence *sf_auth* as below: salesforce.init xmlns=http://ws.apache.org/ns/synapse; usernamesesh...@wso2.com/username passwordp1ne@pplelrY5ZpMQVqPyPramkfIdKDYE6/password loginUrlhttps://login.salesforce.com/services/Soap/u/27.0 /loginUrl /salesforce.init 3) When i added the logs, i find that error occurs at salesforce.getUserInfo configKey=*sf_auth*/salesforce.getUserInfo The error logs are as follows: [2015-08-18 14:42:22,950] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:4ca4be55-4b42-4b9f-89c3-3fc4b534a1a2, Direction: request, STATE = Before sf_auth sequence [2015-08-18 14:42:22,958] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:42:26,100] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the sequence. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:30 PM, Malaka Silva mal...@wso2.com wrote: Seems like an error when sending the message out. Can you put some logs in your mediation flow and identify with point it's failing? Also enabling wire logs will also help to find the failing point. Also share the salesfore.init config. On Tue, Aug 18, 2015 at 2:19 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am trying to get data from salesforce using salesforce connector by writing a proxy. I get the following error when i run the sequence/proxy: [2015-08-18 14:06:31,815] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:06:38,933] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached a sequence i have written for the above task. What could be the reason for this? Please help. Thanks in advance. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Malaka Silva Senior Tech Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/ http://www.wso2.com/about/team/malaka-silva/ http://wso2.com/about/team/malaka-silva/ Save a tree -Conserve nature Save the world for your future. Print this email only if it is absolutely necessary. -- Best Regards, Malaka Silva Senior Tech Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/ http://www.wso2.com/about/team/malaka-silva/ http://wso2.com/about/team/malaka-silva/ Save a tree -Conserve nature Save the world for your future. Print this email only if it is absolutely necessary. wirelogs Description: Binary data
Re: [Dev] [ESB] 101500 ERROR_MESSAGE : Error in Sender
Hi, @Malaka: Yes, i have imported it to the client-truststore.jks. @Bhathiya: This was the same issue. I had imported the cert from the login page with cn login.salesforce.com. Once i got a cn of *.salesforce.com it works. Thank you all Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 7:32 PM, Bhathiya Jayasekara bhath...@wso2.com wrote: When was using Salesforce connector once, I faced a certificate issue. Mentioning about this in case it helps you. I initially imported the cert of login.salesforce.com, it worked fine for login. But its CN was login.salesforce.com. So every request which were sent to ap1.salesforce.com, after login, failed because of the mismatched CN. So I also had to import cert of ap1.salesforce.com, of which CN was *. salesforce.com, to make other requests successful. Thanks, Bhathiya On Tue, Aug 18, 2015 at 9:19 AM, Malaka Silva mal...@wso2.com wrote: Have you imported it to client-truststore.jks? https://docs.wso2.com/display/ESB481/Setting+Up+Keystores+for+a+Client+and+a+Service On Tue, Aug 18, 2015 at 6:39 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi Malaka, I did import the .crt file from salesforce.com into the esb home/repository/resources/security folder. Is this the one you are referring to? If so, it didnt work. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 6:33 PM, Malaka Silva mal...@wso2.com wrote: Maybe the issue is related to [1]. Can you try importing the certificate to truststore pls? @Kesavan - Did you experience this behavior intermittently? [1] https://wso2.org/jira/browse/ESBCONNECT-60 On Tue, Aug 18, 2015 at 5:33 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, the sequence previously worked with the getUserInfo. i added an onError=fault, the logs are as follows: [2015-08-18 17:22:45,644] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:cb25cf91-f7fa-4681-beeb-c769ffebe7f4, Direction: request, STATE = Before sf_auth sequence [2015-08-18 17:22:45,644] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:cb25cf91-f7fa-4681-beeb-c769ffebe7f4, Direction: request, text = An unexpected error occured, message = null, Envelope: ?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv= http://www.w3.org/2003/05/soap-envelope;soapenv:BodyyAM data written successfully into pipeline table/y/soapenv:Body/soapenv:Envelope [2015-08-18 17:22:45,648] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 17:22:46,928] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the logs after enabling wire logs. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:54 PM, Malaka Silva mal...@wso2.com wrote: Why are you adding getUserInfo, since you are not using the response from it? Also try adding onError attribute to your sequence and check. eg: onError=fault More on wire logs with [1] [1] http://mytecheye.blogspot.com/2013/09/wso2-esb-all-about-wire-logs.html On Tue, Aug 18, 2015 at 2:46 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, 1) I couldn't find the line to enable wire logs in my log4j file. Is it okay if i add the line to it? (log4j.logger.org.apache.synapse.transport.http.wire=DEBUG) 2) My init config is in the sequence *sf_auth* as below: salesforce.init xmlns=http://ws.apache.org/ns/synapse; usernamesesh...@wso2.com/username passwordp1ne@pplelrY5ZpMQVqPyPramkfIdKDYE6/password loginUrlhttps://login.salesforce.com/services/Soap/u/27.0 /loginUrl /salesforce.init 3) When i added the logs, i find that error occurs at salesforce.getUserInfo configKey=*sf_auth* /salesforce.getUserInfo The error logs are as follows: [2015-08-18 14:42:22,950] INFO {SERVICE_LOGGER} - To: , MessageID: urn:uuid:4ca4be55-4b42-4b9f-89c3-3fc4b534a1a2, Direction: request, STATE = Before sf_auth sequence [2015-08-18 14:42:22,958] INFO {SERVICE_LOGGER} - Connection = Login to Salesforce . [2015-08-18 14:42:26,100] WARN {SERVICE_LOGGER} - ERROR_CODE : 101500 ERROR_MESSAGE : Error in Sender I have attached the sequence. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 2:30 PM, Malaka Silva mal...@wso2.com wrote: Seems like an error when sending the message out. Can you put some logs in your mediation flow and identify with point it's failing? Also enabling wire logs will also help to find the failing point. Also share
Re: [Dev] I/O error: General SSLEngine problem in ESB
Hi, I had imported the cert from the login page with cn login.salesforce.com. Once i got a cn of *.salesforce.com it works. Thank you all Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 7:35 PM, Bhathiya Jayasekara bhath...@wso2.com wrote: This is the exact error I mentioned on the other thread[1]. [1] [Dev] [ESB] 101500 ERROR_MESSAGE : Error in Sender Thanks, On Tue, Aug 18, 2015 at 9:48 AM, Malaka Silva mal...@wso2.com wrote: Try importing the certificate to client-truststore.jks? https://docs.wso2.com/display/ESB481/Setting+Up+Keystores+for+a+Client+and+a+Service On Tue, Aug 18, 2015 at 6:15 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi Rajjaz, I got new security token and tried. still same error. And yes i have put the password and the token together. the thing is, this used to work fine just a few days back. I think this error occurs due to some expired certificate or something. But cant figure out where exactly. Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Tue, Aug 18, 2015 at 5:59 PM, Rajjaz Mohammed raj...@wso2.com wrote: Hi Aaquibah, i got the same error because of Security Token so can you check your credentials once again and for the Salesforce password is a combination of the user password plus the security token provided by Salesforce. On Tue, Aug 18, 2015 at 3:51 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am getting the following error when i try to run a proxy which gets data from salesforce. Any idea how to solve this? TID: [0] [ESB] [2015-08-18 06:14:17,256] INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logged in at [2015-08-18 06:14:17,256-0400] {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} TID: [0] [ESB] [2015-08-18 06:15:34,645] INFO {org.apache.synapse.mediators.builtin.LogMediator} - To: /services/SalesforceProxy.SalesforceProxyHttpSoap12Endpoint, WSAction: urn:mediate, SOAPAction: urn:mediate, MessageID: urn:uuid:89a301b5-e7c4-4781-91c8-e4c677e2e4db, Direction: request, STATE = OPP {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-18 06:15:34,657] INFO {org.apache.synapse.mediators.builtin.LogMediator} - Connection = Login to Salesforce . {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-18 06:15:36,639] ERROR {org.apache.synapse.transport.passthru.TargetHandler} - I/O error: General SSLEngine problem {org.apache.synapse.transport.passthru.TargetHandler} javax.net.ssl.SSLHandshakeException: General SSLEngine problem at sun.security.ssl.Handshaker.checkThrown(Handshaker.java:1252) at sun.security.ssl.SSLEngineImpl.checkTaskThrown(SSLEngineImpl.java:514) at sun.security.ssl.SSLEngineImpl.writeAppRecord(SSLEngineImpl.java:1173) at sun.security.ssl.SSLEngineImpl.wrap(SSLEngineImpl.java:1145) at javax.net.ssl.SSLEngine.wrap(SSLEngine.java:469) at org.apache.http.nio.reactor.ssl.SSLIOSession.doWrap(SSLIOSession.java:220) at org.apache.http.nio.reactor.ssl.SSLIOSession.doHandshake(SSLIOSession.java:254) at org.apache.http.nio.reactor.ssl.SSLIOSession.isAppInputReady(SSLIOSession.java:380) at org.apache.http.impl.nio.reactor.AbstractIODispatch.inputReady(AbstractIODispatch.java:118) at org.apache.http.impl.nio.reactor.BaseIOReactor.readable(BaseIOReactor.java:160) at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvent(AbstractIOReactor.java:342) at org.apache.http.impl.nio.reactor.AbstractIOReactor.processEvents(AbstractIOReactor.java:320) at org.apache.http.impl.nio.reactor.AbstractIOReactor.execute(AbstractIOReactor.java:280) at org.apache.http.impl.nio.reactor.BaseIOReactor.execute(BaseIOReactor.java:106) at org.apache.http.impl.nio.reactor.AbstractMultiworkerIOReactor$Worker.run(AbstractMultiworkerIOReactor.java:604) at java.lang.Thread.run(Thread.java:701) Caused by: javax.net.ssl.SSLHandshakeException: General SSLEngine problem at sun.security.ssl.Alerts.getSSLException(Alerts.java:192) at sun.security.ssl.SSLEngineImpl.fatal(SSLEngineImpl.java:1660) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:289) at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:281) at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1255) at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:200) at sun.security.ssl.Handshaker.processLoop(Handshaker.java:848) at sun.security.ssl.Handshaker$1.run(Handshaker.java:788) at sun.security.ssl.Handshaker$1.run(Handshaker.java:786) at java.security.AccessController.doPrivileged(Native Method) at sun.security.ssl.Handshaker$DelegatedTask.run(Handshaker.java:1189
[Dev] Unexpected error sending message back- in ESB 4.8.1 while running scheduled task
Hi, i get the following errors when i try to run a proxy as a scheduled task in the esb 4.8.1: Any help would be greatly appreciated. LOGS: [2015-08-05 11:46:00,004] INFO - LogMediator To: , MessageID: urn:uuid:2464be20-b62d-46e0-aa6d-fba1b0916395, Direction: request, STATE = LEADQ [2015-08-05 11:46:00,009] INFO - LogMediator Connection = Login to Salesforce . [2015-08-05 11:46:10,166] INFO - LogMediator To: http://www.w3.org/2005/08/addressing/anonymous, WSAction: , SOAPAction: , MessageID: urn:uuid:52c9cf45-6c1c-4325-a2dd-e859d4f5b3bc, Direction: request, STATE = LEADQ [2015-08-05 11:46:10,170] ERROR - Axis2Sender Access-Control-Allow-Origin:*,Content-Type:application/json,Date:Wed, 05 Aug 2015 06:16:09 GMT,Expires:Thu, 01 Jan 1970 00:00:00 GMT,Set-Cookie:BrowserId=QUzIWHx-Q2ybwOcjvSLJmw;Path=/;Domain=. salesforce.com;Expires=Sun, 04-Oct-2015 06:16:09 GMT,Transfer-Encoding:chunked,?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv= http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd= http://www.w3.org/2001/XMLSchema; xmlns=urn:partner.soap.sforce.com xmlns:sf=urn:sobject.partner.soap.sforce.com xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;soapenv:Header xmlns:wsa= http://www.w3.org/2005/08/addressing;wsa:MessageIDurn:uuid:eccb2dcc-b961-4d43-b77d-47fe901039ab/wsa:MessageID/soapenv:Headersoapenv:BodyqueryResponseresult xsi:type=QueryResultdonetrue/donequeryLocator xsi:nil=true/queryLocatorrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__c xsi:nil=true/sf:Region__csf:expr0 xsi:type=xsd:int24/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cNA/sf:Region__csf:expr0 xsi:type=xsd:int1572/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cSA/sf:Region__csf:expr0 xsi:type=xsd:int382/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cEUROPE/sf:Region__csf:expr0 xsi:type=xsd:int1642/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cMEAP/sf:Region__csf:expr0 xsi:type=xsd:int7/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cROW/sf:Region__csf:expr0 xsi:type=xsd:int2011/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordssize6/size/result/queryResponse/soapenv:Body/soapenv:Envelope Unexpected error sending message back org.apache.axis2.AxisFault: Unable to determine wsa:Action for outbound message at org.apache.axis2.handlers.addressing.AddressingOutHandler$WSAHeaderWriter.processWSAAction(AddressingOutHandler.java:311) at org.apache.axis2.handlers.addressing.AddressingOutHandler$WSAHeaderWriter.writeHeaders(AddressingOutHandler.java:228) at org.apache.axis2.handlers.addressing.AddressingOutHandler.doInvoke(AddressingOutHandler.java:134) at org.apache.axis2.handlers.AbstractTemplatedHandler.invoke(AbstractTemplatedHandler.java:44) at org.apache.axis2.engine.Phase.invokeHandler(Phase.java:340) at org.apache.axis2.engine.Phase.invoke(Phase.java:313) at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:261) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:426) at org.apache.synapse.core.axis2.Axis2Sender.sendBack(Axis2Sender.java:163) at org.apache.synapse.mediators.builtin.RespondMediator.mediate(RespondMediator.java:23) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:131) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:196) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:255) at org.apache.synapse.core.axis2.Axis2SynapseEnvironment.mediateFromContinuationStateStack(Axis2SynapseEnvironment.java:556) at org.apache.synapse.core.axis2.Axis2SynapseEnvironment.injectMessage(Axis2SynapseEnvironment.java:198) at org.apache.synapse.core.axis2.SynapseCallbackReceiver.handleMessage(SynapseCallbackReceiver.java:488) at org.apache.synapse.core.axis2.SynapseCallbackReceiver.receive(SynapseCallbackReceiver.java:170) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) at org.apache.synapse.transport.passthru.ClientWorker.run(ClientWorker.java:225) at org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at
Re: [Dev] Unexpected error sending message back- in ESB 4.8.1 while running scheduled task
Hi Chanaka, I changed the send mediator to the drop mediator. But got the same set of errors. Any ideas? Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Wed, Aug 5, 2015 at 2:49 PM, Chanaka Fernando chana...@wso2.com wrote: Hi Aaquibah, Looks like you are trying to execute a proxy service using scheduled task where back end sends a response message to the ESB. In this case, ESB will fail to send that response, since there is no client in this scenario. You can use the drop mediator in the out sequence such that it will drop the message instead of trying to respond back to the client. Thanks, Chanaka On Wed, Aug 5, 2015 at 2:22 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i get the following errors when i try to run a proxy as a scheduled task in the esb 4.8.1: Any help would be greatly appreciated. LOGS: [2015-08-05 11:46:00,004] INFO - LogMediator To: , MessageID: urn:uuid:2464be20-b62d-46e0-aa6d-fba1b0916395, Direction: request, STATE = LEADQ [2015-08-05 11:46:00,009] INFO - LogMediator Connection = Login to Salesforce . [2015-08-05 11:46:10,166] INFO - LogMediator To: http://www.w3.org/2005/08/addressing/anonymous, WSAction: , SOAPAction: , MessageID: urn:uuid:52c9cf45-6c1c-4325-a2dd-e859d4f5b3bc, Direction: request, STATE = LEADQ [2015-08-05 11:46:10,170] ERROR - Axis2Sender Access-Control-Allow-Origin:*,Content-Type:application/json,Date:Wed, 05 Aug 2015 06:16:09 GMT,Expires:Thu, 01 Jan 1970 00:00:00 GMT,Set-Cookie:BrowserId=QUzIWHx-Q2ybwOcjvSLJmw;Path=/;Domain=. salesforce.com;Expires=Sun, 04-Oct-2015 06:16:09 GMT,Transfer-Encoding:chunked,?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv= http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd= http://www.w3.org/2001/XMLSchema; xmlns=urn:partner.soap.sforce.com xmlns:sf=urn:sobject.partner.soap.sforce.com xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;soapenv:Header xmlns:wsa= http://www.w3.org/2005/08/addressing;wsa:MessageIDurn:uuid:eccb2dcc-b961-4d43-b77d-47fe901039ab/wsa:MessageID/soapenv:Headersoapenv:BodyqueryResponseresult xsi:type=QueryResultdonetrue/donequeryLocator xsi:nil=true/queryLocatorrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__c xsi:nil=true/sf:Region__csf:expr0 xsi:type=xsd:int24/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cNA/sf:Region__csf:expr0 xsi:type=xsd:int1572/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cSA/sf:Region__csf:expr0 xsi:type=xsd:int382/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cEUROPE/sf:Region__csf:expr0 xsi:type=xsd:int1642/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cMEAP/sf:Region__csf:expr0 xsi:type=xsd:int7/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cROW/sf:Region__csf:expr0 xsi:type=xsd:int2011/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordssize6/size/result/queryResponse/soapenv:Body/soapenv:Envelope Unexpected error sending message back org.apache.axis2.AxisFault: Unable to determine wsa:Action for outbound message at org.apache.axis2.handlers.addressing.AddressingOutHandler$WSAHeaderWriter.processWSAAction(AddressingOutHandler.java:311) at org.apache.axis2.handlers.addressing.AddressingOutHandler$WSAHeaderWriter.writeHeaders(AddressingOutHandler.java:228) at org.apache.axis2.handlers.addressing.AddressingOutHandler.doInvoke(AddressingOutHandler.java:134) at org.apache.axis2.handlers.AbstractTemplatedHandler.invoke(AbstractTemplatedHandler.java:44) at org.apache.axis2.engine.Phase.invokeHandler(Phase.java:340) at org.apache.axis2.engine.Phase.invoke(Phase.java:313) at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:261) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:426) at org.apache.synapse.core.axis2.Axis2Sender.sendBack(Axis2Sender.java:163) at org.apache.synapse.mediators.builtin.RespondMediator.mediate(RespondMediator.java:23) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:131) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:196) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77
Re: [Dev] Unexpected error sending message back- in ESB 4.8.1 while running scheduled task
Hi Chanaka, As you suggested, after i replaced respond/respond with drop/ in the sequence the error is fixed. Thank you. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Wed, Aug 5, 2015 at 3:38 PM, Chanaka Fernando chana...@wso2.com wrote: Can you attach the task and proxy configurations? On Wed, Aug 5, 2015 at 3:28 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi Chanaka, I changed the send mediator to the drop mediator. But got the same set of errors. Any ideas? Thanks Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Wed, Aug 5, 2015 at 2:49 PM, Chanaka Fernando chana...@wso2.com wrote: Hi Aaquibah, Looks like you are trying to execute a proxy service using scheduled task where back end sends a response message to the ESB. In this case, ESB will fail to send that response, since there is no client in this scenario. You can use the drop mediator in the out sequence such that it will drop the message instead of trying to respond back to the client. Thanks, Chanaka On Wed, Aug 5, 2015 at 2:22 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i get the following errors when i try to run a proxy as a scheduled task in the esb 4.8.1: Any help would be greatly appreciated. LOGS: [2015-08-05 11:46:00,004] INFO - LogMediator To: , MessageID: urn:uuid:2464be20-b62d-46e0-aa6d-fba1b0916395, Direction: request, STATE = LEADQ [2015-08-05 11:46:00,009] INFO - LogMediator Connection = Login to Salesforce . [2015-08-05 11:46:10,166] INFO - LogMediator To: http://www.w3.org/2005/08/addressing/anonymous, WSAction: , SOAPAction: , MessageID: urn:uuid:52c9cf45-6c1c-4325-a2dd-e859d4f5b3bc, Direction: request, STATE = LEADQ [2015-08-05 11:46:10,170] ERROR - Axis2Sender Access-Control-Allow-Origin:*,Content-Type:application/json,Date:Wed, 05 Aug 2015 06:16:09 GMT,Expires:Thu, 01 Jan 1970 00:00:00 GMT,Set-Cookie:BrowserId=QUzIWHx-Q2ybwOcjvSLJmw;Path=/;Domain=. salesforce.com;Expires=Sun, 04-Oct-2015 06:16:09 GMT,Transfer-Encoding:chunked,?xml version=1.0 encoding=utf-8?soapenv:Envelope xmlns:soapenv= http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd= http://www.w3.org/2001/XMLSchema; xmlns=urn:partner.soap.sforce.com xmlns:sf=urn:sobject.partner.soap.sforce.com xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;soapenv:Header xmlns:wsa= http://www.w3.org/2005/08/addressing;wsa:MessageIDurn:uuid:eccb2dcc-b961-4d43-b77d-47fe901039ab/wsa:MessageID/soapenv:Headersoapenv:BodyqueryResponseresult xsi:type=QueryResultdonetrue/donequeryLocator xsi:nil=true/queryLocatorrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__c xsi:nil=true/sf:Region__csf:expr0 xsi:type=xsd:int24/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cNA/sf:Region__csf:expr0 xsi:type=xsd:int1572/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cSA/sf:Region__csf:expr0 xsi:type=xsd:int382/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cEUROPE/sf:Region__csf:expr0 xsi:type=xsd:int1642/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cMEAP/sf:Region__csf:expr0 xsi:type=xsd:int7/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordsrecords xsi:type=sf:sObjectsf:typeAggregateResult/sf:typesf:Id xsi:nil=true/sf:Idsf:Region__cROW/sf:Region__csf:expr0 xsi:type=xsd:int2011/sf:expr0sf:RecordDate2015-08-05/sf:RecordDate/recordssize6/size/result/queryResponse/soapenv:Body/soapenv:Envelope Unexpected error sending message back org.apache.axis2.AxisFault: Unable to determine wsa:Action for outbound message at org.apache.axis2.handlers.addressing.AddressingOutHandler$WSAHeaderWriter.processWSAAction(AddressingOutHandler.java:311) at org.apache.axis2.handlers.addressing.AddressingOutHandler$WSAHeaderWriter.writeHeaders(AddressingOutHandler.java:228) at org.apache.axis2.handlers.addressing.AddressingOutHandler.doInvoke(AddressingOutHandler.java:134) at org.apache.axis2.handlers.AbstractTemplatedHandler.invoke(AbstractTemplatedHandler.java:44) at org.apache.axis2.engine.Phase.invokeHandler(Phase.java:340) at org.apache.axis2.engine.Phase.invoke(Phase.java:313) at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:261) at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:426) at org.apache.synapse.core.axis2.Axis2Sender.sendBack(Axis2Sender.java:163) at org.apache.synapse.mediators.builtin.RespondMediator.mediate
[Dev] java.net.SocketException: Broken pipe -Error while running ESB scheduled task
Hi, i get the following error logs when I am trying to run a scheduled task in the ESB. What could be the reason? What can i do to overcome this? TID: [0] [ESB] [2015-08-04 00:00:36,958] INFO {org.apache.synapse.mediators.builtin.LogMediator} - To: http://www.w3.org/2005/08/addressing/anonymous, WSAction: , SOAPAction: , MessageID: urn:uuid:6cba9ade-1456-42bf-bca9-e0c2110fed2c, Direction: request, STATE = LEADQ {org.apache.synapse.mediators.builtin.LogMediator} TID: [0] [ESB] [2015-08-04 00:00:38,318] ERROR {org.apache.synapse.mediators.db.DBReportMediator} - Error execuring insert statement : INSERT INTO quarterlyleads (Region, count, RecordDate) VALUES (?, ?, ?) against DataSource : jdbc:mysql://localhost:3306/sf {org.apache.synapse.mediators.db.DBReportMediator} com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 62,995,899 milliseconds ago. The last packet sent successfully to the server was 62,995,908 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:534) at com.mysql.jdbc.Util.handleNewInstance(Util.java:408) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3965) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2578) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2826) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2082) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2334) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2262) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2246) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.synapse.mediators.db.DBReportMediator.processStatement(DBReportMediator.java:55) at org.apache.synapse.mediators.db.AbstractDBMediator.mediate(AbstractDBMediator.java:143) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:47) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:131) at org.apache.synapse.mediators.eip.Target.mediate(Target.java:106) at org.apache.synapse.mediators.eip.splitter.IterateMediator.mediate(IterateMediator.java:146) at org.apache.synapse.mediators.AbstractListMediator.mediate(AbstractListMediator.java:77) at org.apache.synapse.mediators.base.SequenceMediator.mediate(SequenceMediator.java:255) at org.apache.synapse.core.axis2.Axis2SynapseEnvironment.mediateFromContinuationStateStack(Axis2SynapseEnvironment.java:556) at org.apache.synapse.core.axis2.Axis2SynapseEnvironment.injectMessage(Axis2SynapseEnvironment.java:198) at org.apache.synapse.core.axis2.SynapseCallbackReceiver.handleMessage(SynapseCallbackReceiver.java:488) at org.apache.synapse.core.axis2.SynapseCallbackReceiver.receive(SynapseCallbackReceiver.java:170) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) at org.apache.synapse.transport.passthru.ClientWorker.run(ClientWorker.java:225) at org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:701) Caused by: java.net.SocketException: Broken pipe at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109) at java.net.SocketOutputStream.write(SocketOutputStream.java:153) at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82) at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3946) ... 29 more TID: [0] [ESB] [2015-08-04 00:00:38,331] ERROR {org.apache.synapse.core.axis2.SynapseCallbackReceiver} - Synapse encountered an exception, No error
[Dev] Get values from javascript or html into jaggery
Hi, I need to get the values of javascript variables or values of html elements into jaggery code. What i am doing is, i am getting values from html elements and i need to send them inside the query in jaggery. That is, in html i have a dropdown as *Year*, i want to pass the value selected. Below is the javascript code with the jaggery code: function DrawGraph(){ var year=document.getElementById(Year).value; % var query = select sum(Best_Case__c) as 'Best' FROM Opp WHERE YEAR(Date__c)=*year* % } How can i do this? Any example? Tutorials? Thanks in advance. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Get values from javascript or html into jaggery
//my code is: where YEAR(Date__c)=*+year+ *AND ... i get the following error: *message* *org.mozilla.javascript.EcmaError: ReferenceError: year is not defined. (/ProductJaggery//PipelineGraph.jag#64)* Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Fri, Jul 10, 2015 at 1:25 PM, Chamalee De Silva chama...@wso2.com wrote: Hi Nashry, You can use the variables you create in JavaScript same in Jaggery code. Becuase Jaggery is all about Javascript. *As a pure Javascript server-side scripting engine, Jaggery combines all the strengths of Javascript with flexibility and freedom at both the development and deployment stages. Most JavaScript webapp development mechanisms restrict developers to a framework-specific structure or patterns, which demand an additional learning curve. By contrast, with Jaggery, any developers who are versed in Javascript have everything they need to get going.* On Fri, Jul 10, 2015 at 1:16 PM, Lakshani Gamage laksh...@wso2.com wrote: Hi Aaquibah, Please follow the link[1]. It'll help to solve your problem. [1] http://blog.lasindu.com/2014/05/how-to-write-wso2-jaggery-application.html Thanks, Lakshani On Fri, Jul 10, 2015 at 1:09 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I need to get the values of javascript variables or values of html elements into jaggery code. What i am doing is, i am getting values from html elements and i need to send them inside the query in jaggery. That is, in html i have a dropdown as *Year*, i want to pass the value selected. Below is the javascript code with the jaggery code: function DrawGraph(){ var year=document.getElementById(Year).value; % var query = select sum(Best_Case__c) as 'Best' FROM Opp WHERE YEAR(Date__c)=*year* % } How can i do this? Any example? Tutorials? Thanks in advance. Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Lakshani Gamage *Software Engineer* Mobile : +94 (0) 71 5478184 %2B94%20%280%29%20773%20451194 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thanks Regards, *Chamalee De Silva* Software Engineer *WS**O2* Inc. .:http://wso2.com lean *.* enterprise *.* middleware Office :- *+94 11 2145345 %2B94%2011%202145345* mobile :- *+94 7 %2B94%2077%2027820391 4315942* ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] how to overcome page reload after postback?
Hi, i am calling a post method in a form. When submitted, a graph should be displayed. When i run the page in a browser, the graph appears and then disappears within seconds. I think after postback the page reloads. How can i overcome this? I am using javascript and jaggery. Thanks in advance Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] how to overcome page reload after postback?
well... i used the following code: form id=yearForm method=POST input type=checkbox name=FullYear id=FullYear value=FullYear onclick=DisableDropdown()Display Full year br Enter Year: input type=text name=Year id=Year value=2015 tab align=right Select Quarter: select id=Quarter option name=Quarter11/option option name=Quarter22/option option name=Quarter33/option option name=Quarter44/option /select br input type=submit name=button id=button value=Generate Graph onClick=DrawGraph() br /form % if(request.getMethod() == POST){ var dyear = request.getParameter(Year); if(!dyear){ response.status = 400; } else{ //query response.status = 200 } } Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Fri, Jul 10, 2015 at 3:40 PM, Lakshani Gamage laksh...@wso2.com wrote: Hi Nashry, How did you send form details to server side? Did you use AJAX or something else? Thanks, Lakshani. On Fri, Jul 10, 2015 at 3:14 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i am calling a post method in a form. When submitted, a graph should be displayed. When i run the page in a browser, the graph appears and then disappears within seconds. I think after postback the page reloads. How can i overcome this? I am using javascript and jaggery. Thanks in advance Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Lakshani Gamage *Software Engineer* Mobile : +94 (0) 71 5478184 %2B94%20%280%29%20773%20451194 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] how to overcome page reload after postback?
Hi Irham, Now it doesnt disappear. but i dont get the value of the variable im retrieving. Any suggestions how i can retrieve form elements into jaggery? Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Fri, Jul 10, 2015 at 4:09 PM, Irham Iqbal iq...@wso2.com wrote: Hi Nashry, I think since you have input type=submit the form is getting submitted change it to input type=button and see whether it's working. Thanks, Iqbal On Fri, Jul 10, 2015 at 4:01 PM, Aaquibah Nashry nas...@wso2.com wrote: well... i used the following code: form id=yearForm method=POST input type=checkbox name=FullYear id=FullYear value=FullYear onclick=DisableDropdown()Display Full year br Enter Year: input type=text name=Year id=Year value=2015 tab align=right Select Quarter: select id=Quarter option name=Quarter11/option option name=Quarter22/option option name=Quarter33/option option name=Quarter44/option /select br input type=submit name=button id=button value=Generate Graph onClick=DrawGraph() br /form % if(request.getMethod() == POST){ var dyear = request.getParameter(Year); if(!dyear){ response.status = 400; } else{ //query response.status = 200 } } Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Fri, Jul 10, 2015 at 3:40 PM, Lakshani Gamage laksh...@wso2.com wrote: Hi Nashry, How did you send form details to server side? Did you use AJAX or something else? Thanks, Lakshani. On Fri, Jul 10, 2015 at 3:14 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i am calling a post method in a form. When submitted, a graph should be displayed. When i run the page in a browser, the graph appears and then disappears within seconds. I think after postback the page reloads. How can i overcome this? I am using javascript and jaggery. Thanks in advance Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Lakshani Gamage *Software Engineer* Mobile : +94 (0) 71 5478184 %2B94%20%280%29%20773%20451194 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Irham Iqbal Software Engineer - Test Automation WSO2, Inc.: http://wso2.com lean. enterprise. middleware phone: +94 777888452 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] using call mediator
Hi, i am trying to get the current currency exchange rate from EUR to USD from a webservice. i used a call mediator as follows: call endpoint address uri= http://www.webservicex.net/CurrencyConvertor.asmx?WSDL/ /endpoint /call I need to send the FromCurrency and the ToCurrency to the webservice and get the rate. How can i do this? Also, how can i store the value returned, in my proxy and then send this value into a class mediator that i have written. class name=mediator.CustomMediator property name=rate value=100/ /class I want to send the rate instead of the value 100 Please help... Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] using call mediator
Any idea about the first part of the question? How do i send the parameters to the webservice using the call mediator? Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Mon, Jun 22, 2015 at 12:25 PM, Aaquibah Nashry nas...@wso2.com wrote: Thanks Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Mon, Jun 22, 2015 at 12:18 PM, Malaka Silva mal...@wso2.com wrote: You can't pass dynamic values for property. However you can store the rate in message context and extract from from message context from class mediator. eg: synCtx.getProperty(key); On Mon, Jun 22, 2015 at 12:11 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i am trying to get the current currency exchange rate from EUR to USD from a webservice. i used a call mediator as follows: call endpoint address uri= http://www.webservicex.net/CurrencyConvertor.asmx?WSDL/ /endpoint /call I need to send the FromCurrency and the ToCurrency to the webservice and get the rate. How can i do this? Also, how can i store the value returned, in my proxy and then send this value into a class mediator that i have written. class name=mediator.CustomMediator property name=rate value=100/ /class I want to send the rate instead of the value 100 Please help... Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Malaka Silva Senior Tech Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware http://www.wso2.com/ http://www.wso2.com/about/team/malaka-silva/ http://wso2.com/about/team/malaka-silva/ Save a tree -Conserve nature Save the world for your future. Print this email only if it is absolutely necessary. ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] using call mediator
Hi Sandapa, I need to call it using the call mediator. I did the following modifications, call endpoint address uri= http://www.webservicex.net/CurrencyConvertor.asmx?WSDL/ /endpoint /call header name=Action value= http://www.webserviceX.NET/ConversionRate/ payloadFactory media-type=xml format m0:ConversionRate xmlns:m0=http://www.webserviceX.NET/; m0:request m0:FromCurrencyEUR/m0:FromCurrency m0:ToCurrencyUSD/m0:ToCurrency /m0:request /m0:ConversionRate /format args/ /payloadFactory log level=full/ in the terminal i get the following when i try the proxy using 'try it' [2015-06-22 14:35:04,184] INFO {SERVICE_LOGGER.SalesForceProxy} - Connection = Login to Salesforce . [2015-06-22 14:35:05,840] INFO {SERVICE_LOGGER.SalesForceProxy} - To: http://www.w3.org/2005/08/addressing/anonymous, WSAction: http://www.webserviceX.NET/ConversionRate, SOAPAction: http://www.webserviceX.NET/ConversionRate, MessageID: urn:uuid:67c0e1d0-ac7d-496a-9cac-7779e7370791, Direction: request, Envelope: ?xml version=1.0 encoding=utf-8?soap:Envelope xmlns:soap= http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd= http://www.w3.org/2001/XMLSchema; xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;soap:Bodym0:ConversionRate xmlns:m0=http://www.webserviceX.NET/ m0:requestm0:FromCurrencyEUR/m0:FromCurrencym0:ToCurrencyUSD/m0:ToCurrency/m0:request/m0:ConversionRate/soap:Body/soap:Envelope Why am i not getting the response from the webservice? Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Mon, Jun 22, 2015 at 2:40 PM, Sandapa Handakumbura sand...@wso2.com wrote: Hi Aaquibah, FromCurrency and ToCurrency should be sent in the request. So you can simply invoke the service using a tool like SoapUI. Did you try that option? ​ Regards, Sandapa On Mon, Jun 22, 2015 at 12:11 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i am trying to get the current currency exchange rate from EUR to USD from a webservice. i used a call mediator as follows: call endpoint address uri= http://www.webservicex.net/CurrencyConvertor.asmx?WSDL/ /endpoint /call I need to send the FromCurrency and the ToCurrency to the webservice and get the rate. How can i do this? Also, how can i store the value returned, in my proxy and then send this value into a class mediator that i have written. class name=mediator.CustomMediator property name=rate value=100/ /class I want to send the rate instead of the value 100 Please help... Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Sandapa Handakumbura Associate Technical Lead WSO2.Inc. ; http://wso2.com/ M : +94777115866 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] using call mediator
well..this is my task... i have written a proxy i need to call a webservice ( http://www.webservicex.net/CurrencyConvertor.asmx?WSDL) and get the return value (the currency exchange rate) and pass that value to a class mediator. How could this be done? Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Mon, Jun 22, 2015 at 3:08 PM, Sandapa Handakumbura sand...@wso2.com wrote: If you can tell me the exact requirement, I can help you with the config. Using the Payload factory mediator after the Call mediator will not make any difference for the first web service call. What is the request that you're sending to the proxy service? Isn't it something like this? soapenv:Envelope xmlns:soapenv=http://schemas.xmlsoap.org/soap/envelope/; xmlns:web=http://www.webserviceX.NET/; soapenv:Header/ soapenv:Body web:ConversionRate web:FromCurrencyAUD/web:FromCurrency web:ToCurrencyLKR/web:ToCurrency /web:ConversionRate /soapenv:Body /soapenv:Envelope If the request has required information Call mediator can send it to the web service and get the correct response. Regards, Sandapa On Mon, Jun 22, 2015 at 2:54 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi Sandapa, I need to call it using the call mediator. I did the following modifications, call endpoint address uri= http://www.webservicex.net/CurrencyConvertor.asmx?WSDL/ /endpoint /call header name=Action value= http://www.webserviceX.NET/ConversionRate/ payloadFactory media-type=xml format m0:ConversionRate xmlns:m0=http://www.webserviceX.NET/; m0:request m0:FromCurrencyEUR/m0:FromCurrency m0:ToCurrencyUSD/m0:ToCurrency /m0:request /m0:ConversionRate /format args/ /payloadFactory log level=full/ in the terminal i get the following when i try the proxy using 'try it' [2015-06-22 14:35:04,184] INFO {SERVICE_LOGGER.SalesForceProxy} - Connection = Login to Salesforce . [2015-06-22 14:35:05,840] INFO {SERVICE_LOGGER.SalesForceProxy} - To: http://www.w3.org/2005/08/addressing/anonymous, WSAction: http://www.webserviceX.NET/ConversionRate, SOAPAction: http://www.webserviceX.NET/ConversionRate, MessageID: urn:uuid:67c0e1d0-ac7d-496a-9cac-7779e7370791, Direction: request, Envelope: ?xml version=1.0 encoding=utf-8?soap:Envelope xmlns:soap= http://schemas.xmlsoap.org/soap/envelope/; xmlns:xsd= http://www.w3.org/2001/XMLSchema; xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;soap:Bodym0:ConversionRate xmlns:m0=http://www.webserviceX.NET/ m0:requestm0:FromCurrencyEUR/m0:FromCurrencym0:ToCurrencyUSD/m0:ToCurrency/m0:request/m0:ConversionRate/soap:Body/soap:Envelope Why am i not getting the response from the webservice? Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com On Mon, Jun 22, 2015 at 2:40 PM, Sandapa Handakumbura sand...@wso2.com wrote: Hi Aaquibah, FromCurrency and ToCurrency should be sent in the request. So you can simply invoke the service using a tool like SoapUI. Did you try that option? ​ Regards, Sandapa On Mon, Jun 22, 2015 at 12:11 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i am trying to get the current currency exchange rate from EUR to USD from a webservice. i used a call mediator as follows: call endpoint address uri= http://www.webservicex.net/CurrencyConvertor.asmx?WSDL/ /endpoint /call I need to send the FromCurrency and the ToCurrency to the webservice and get the rate. How can i do this? Also, how can i store the value returned, in my proxy and then send this value into a class mediator that i have written. class name=mediator.CustomMediator property name=rate value=100/ /class I want to send the rate instead of the value 100 Please help... Thanks and Regards, M.R.Aaquibah Nashry *Intern, Engineering**| **WSO2, Inc.* Mobile : +94 773946123 Tel : +94 112662541 Email : nas...@wso2.com nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Sandapa Handakumbura Associate Technical Lead WSO2.Inc. ; http://wso2.com/ M : +94777115866 -- Sandapa Handakumbura Associate Technical Lead WSO2.Inc. ; http://wso2.com/ M : +94777115866 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] java.lang.NullPointerException when importing data from salesforce to mysql database
Hi, I am trying to import data from salesforce and save it in a mysql database. I have written a proxy and a dataservice for this. When there are no null values in the data to be imported, i am able to save the data in mysql. But when the data has null values, i get this: ERROR {org.wso2.carbon.dataservices.core.description.query.SQLQuery} - java.lang.NullPointerException at org.wso2.carbon.dataservices.core.DBUtils.getDate(DBUtils.java:444) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.setDateValue(SQLQuery.java:1869) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:1638) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:1588) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processPreNormalQuery(SQLQuery.java:806) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runPreQuery(SQLQuery.java:2301) at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:275) at org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:188) at org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:61) at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:474) at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:96) at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:107) at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.executeInOnly(DSOMDataSource.java:80) at org.wso2.carbon.dataservices.core.dispatch.SingleDataServiceRequest.processSingleRequest(SingleDataServiceRequest.java:116) at org.wso2.carbon.dataservices.core.dispatch.SingleDataServiceRequest.processRequest(SingleDataServiceRequest.java:67) at org.wso2.carbon.dataservices.core.dispatch.DataServiceRequest.dispatch(DataServiceRequest.java:282) at org.wso2.carbon.dataservices.core.dispatch.BatchDataServiceRequest.processRequest(BatchDataServiceRequest.java:102) at org.wso2.carbon.dataservices.core.dispatch.DataServiceRequest.dispatch(DataServiceRequest.java:282) at org.wso2.carbon.dataservices.core.DataServiceProcessor.dispatch(DataServiceProcessor.java:41) at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:48) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) at org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:411) at org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) at org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) [2015-06-15 10:13:48,269] ERROR {org.wso2.carbon.dataservices.core.engine.DataService} - DS Fault Message: Error in 'SQLQuery.processPreNormalQuery': null DS Code: DATABASE_ERROR Is there a specific way to handle this? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] java.lang.NullPointerException when importing data from salesforce to mysql database
when i take off the columns with date type, i get: ERROR {org.wso2.carbon.dataservices.core.engine.DataService} - DS Fault Message: Error in 'SQLQuery.processPreNormalQuery': empty String DS Code: DATABASE_ERROR M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 15, 2015 at 10:37 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am trying to import data from salesforce and save it in a mysql database. I have written a proxy and a dataservice for this. When there are no null values in the data to be imported, i am able to save the data in mysql. But when the data has null values, i get this: ERROR {org.wso2.carbon.dataservices.core.description.query.SQLQuery} - java.lang.NullPointerException at org.wso2.carbon.dataservices.core.DBUtils.getDate(DBUtils.java:444) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.setDateValue(SQLQuery.java:1869) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.setParamInPreparedStatement(SQLQuery.java:1638) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:1588) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processPreNormalQuery(SQLQuery.java:806) at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runPreQuery(SQLQuery.java:2301) at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:275) at org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:188) at org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89) at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:61) at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:474) at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:96) at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:107) at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.executeInOnly(DSOMDataSource.java:80) at org.wso2.carbon.dataservices.core.dispatch.SingleDataServiceRequest.processSingleRequest(SingleDataServiceRequest.java:116) at org.wso2.carbon.dataservices.core.dispatch.SingleDataServiceRequest.processRequest(SingleDataServiceRequest.java:67) at org.wso2.carbon.dataservices.core.dispatch.DataServiceRequest.dispatch(DataServiceRequest.java:282) at org.wso2.carbon.dataservices.core.dispatch.BatchDataServiceRequest.processRequest(BatchDataServiceRequest.java:102) at org.wso2.carbon.dataservices.core.dispatch.DataServiceRequest.dispatch(DataServiceRequest.java:282) at org.wso2.carbon.dataservices.core.DataServiceProcessor.dispatch(DataServiceProcessor.java:41) at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:48) at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) at org.apache.synapse.transport.passthru.ServerWorker.processEntityEnclosingRequest(ServerWorker.java:411) at org.apache.synapse.transport.passthru.ServerWorker.run(ServerWorker.java:183) at org.apache.axis2.transport.base.threads.NativeWorkerPool$1.run(NativeWorkerPool.java:172) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) [2015-06-15 10:13:48,269] ERROR {org.wso2.carbon.dataservices.core.engine.DataService} - DS Fault Message: Error in 'SQLQuery.processPreNormalQuery': null DS Code: DATABASE_ERROR Is there a specific way to handle this? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error when trying to run proxy service
Hi malaka, yes that was the problem. thanks. M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 12:10 PM, Malaka Silva mal...@wso2.com wrote: you need to append secutitytoken with the password. from doc, Connecting to Salesforce To use the Salesforce connector, add the salesforce.init element in your configuration before any other Salesforce connector operations. This configuration authenticates with Salesforce by configuring the user credentials and login URL. The password is a combination of the user password plus the security token provided by Salesforce. For example, if the user's password is ABCD, and the security token is 1234, enter ABCD1234 as the password. Users can obtain their security token by changing their password or resetting their security token in the Salesforce user interface, at which point Salesforce sends a new security token to the email address on the user's Salesforce record. *init* salesforce.init usernamex...@abc.com/username passwordx/password loginUrlhttps://login.salesforce.com/services/Soap/u/27.0/loginUrl /salesforce.init The response of this operation is attached to the message body and is used for subsequent Salesforce operations. The session ID is saved to the propertysalesforce.sessionId, and the server URL is saved to salesforce.serviceUrl. If the given login details are invalid, the specified fault sequence will be triggered On Fri, Jun 12, 2015 at 11:55 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi, the problem was with the authentication to salesforce. Thanks, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 11:36 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi Kavith, the data is not written to the database at all... when i save my data service, i get this on the esb log, [2015-06-12 11:28:38,441] WARN {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - Failed Administrator login attempt 'admin[-1234]' at [2015-06-12 11:28:38,441+0530] from IP address 10.100.4.35 [2015-06-12 11:28:38,442] WARN {org.wso2.carbon.server.admin.module.handler.AuthenticationHandler} - Illegal access attempt at [2015-06-12 11:28:38,0442] from IP address 10.100.4.35 while trying to authenticate access to service LoggedUserInfoAdmin [2015-06-12 11:28:40,772] INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logged in at [2015-06-12 11:28:40,772+0530] from IP address 10.100.4.35 [2015-06-12 11:29:00,534] INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 service: mysql {super-tenant} when i save my proxy, ilding Axis service for Proxy service : query [2015-06-12 11:30:11,453] INFO {SERVICE_LOGGER.query} - Adding service query to the Axis2 configuration [2015-06-12 11:30:11,458] INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 service: query {super-tenant} [2015-06-12 11:30:11,521] INFO {SERVICE_LOGGER.query} - Successfully created the Axis2 service for Proxy service : query when i try the service, NFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:34:17,895] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null these are the logs i get... M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 11:22 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Can you see this data written into the database properly? Is it just the case that you get a read time out on tryit tool? Please attach the complete log of ESB for this scenario. Thanks. On Fri, Jun 12, 2015 at 11:06 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi Kavith, i got the following: [2015-06-12 11:05:02,198] INFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:05:03,435] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 10:59 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Do you see any error logs in ESB side? Thanks. On Fri, Jun 12, 2015 at 10:52 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I followed the stepsin this link to get data from salesforce and write to mysql database : http://wso2.com/library/articles/2014/02/cloud-to-rdbms-using-wso2-esb/ When i try the service, i get this error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Read timed out/TryitProxyError Any ideas to solve this??? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas
Re: [Dev] Error when trying to run proxy service
Hi Kavith, the data is not written to the database at all... when i save my data service, i get this on the esb log, [2015-06-12 11:28:38,441] WARN {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - Failed Administrator login attempt 'admin[-1234]' at [2015-06-12 11:28:38,441+0530] from IP address 10.100.4.35 [2015-06-12 11:28:38,442] WARN {org.wso2.carbon.server.admin.module.handler.AuthenticationHandler} - Illegal access attempt at [2015-06-12 11:28:38,0442] from IP address 10.100.4.35 while trying to authenticate access to service LoggedUserInfoAdmin [2015-06-12 11:28:40,772] INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logged in at [2015-06-12 11:28:40,772+0530] from IP address 10.100.4.35 [2015-06-12 11:29:00,534] INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 service: mysql {super-tenant} when i save my proxy, ilding Axis service for Proxy service : query [2015-06-12 11:30:11,453] INFO {SERVICE_LOGGER.query} - Adding service query to the Axis2 configuration [2015-06-12 11:30:11,458] INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 service: query {super-tenant} [2015-06-12 11:30:11,521] INFO {SERVICE_LOGGER.query} - Successfully created the Axis2 service for Proxy service : query when i try the service, NFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:34:17,895] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null these are the logs i get... M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 11:22 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Can you see this data written into the database properly? Is it just the case that you get a read time out on tryit tool? Please attach the complete log of ESB for this scenario. Thanks. On Fri, Jun 12, 2015 at 11:06 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi Kavith, i got the following: [2015-06-12 11:05:02,198] INFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:05:03,435] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 10:59 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Do you see any error logs in ESB side? Thanks. On Fri, Jun 12, 2015 at 10:52 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I followed the stepsin this link to get data from salesforce and write to mysql database : http://wso2.com/library/articles/2014/02/cloud-to-rdbms-using-wso2-esb/ When i try the service, i get this error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Read timed out/TryitProxyError Any ideas to solve this??? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Kavith Lokuhewage* Software Engineer WSO2 Inc. - http://wso2.com lean . enterprise . middleware Mobile - +9477-9-145-123 | +9471-455-6-401 Linkedin http://www.linkedin.com/pub/kavith-lokuhewage/49/473/419 Twitter https://twitter.com/KavithThiranga -- *Kavith Lokuhewage* Software Engineer WSO2 Inc. - http://wso2.com lean . enterprise . middleware Mobile - +9477-9-145-123 | +9471-455-6-401 Linkedin http://www.linkedin.com/pub/kavith-lokuhewage/49/473/419 Twitter https://twitter.com/KavithThiranga ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error when trying to run proxy service
Hi, the problem was with the authentication to salesforce. Thanks, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 11:36 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi Kavith, the data is not written to the database at all... when i save my data service, i get this on the esb log, [2015-06-12 11:28:38,441] WARN {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - Failed Administrator login attempt 'admin[-1234]' at [2015-06-12 11:28:38,441+0530] from IP address 10.100.4.35 [2015-06-12 11:28:38,442] WARN {org.wso2.carbon.server.admin.module.handler.AuthenticationHandler} - Illegal access attempt at [2015-06-12 11:28:38,0442] from IP address 10.100.4.35 while trying to authenticate access to service LoggedUserInfoAdmin [2015-06-12 11:28:40,772] INFO {org.wso2.carbon.core.services.util.CarbonAuthenticationUtil} - 'admin@carbon.super [-1234]' logged in at [2015-06-12 11:28:40,772+0530] from IP address 10.100.4.35 [2015-06-12 11:29:00,534] INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 service: mysql {super-tenant} when i save my proxy, ilding Axis service for Proxy service : query [2015-06-12 11:30:11,453] INFO {SERVICE_LOGGER.query} - Adding service query to the Axis2 configuration [2015-06-12 11:30:11,458] INFO {org.wso2.carbon.core.deployment.DeploymentInterceptor} - Deploying Axis2 service: query {super-tenant} [2015-06-12 11:30:11,521] INFO {SERVICE_LOGGER.query} - Successfully created the Axis2 service for Proxy service : query when i try the service, NFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:34:17,895] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null these are the logs i get... M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 11:22 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Can you see this data written into the database properly? Is it just the case that you get a read time out on tryit tool? Please attach the complete log of ESB for this scenario. Thanks. On Fri, Jun 12, 2015 at 11:06 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi Kavith, i got the following: [2015-06-12 11:05:02,198] INFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:05:03,435] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 10:59 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Do you see any error logs in ESB side? Thanks. On Fri, Jun 12, 2015 at 10:52 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I followed the stepsin this link to get data from salesforce and write to mysql database : http://wso2.com/library/articles/2014/02/cloud-to-rdbms-using-wso2-esb/ When i try the service, i get this error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Read timed out/TryitProxyError Any ideas to solve this??? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Kavith Lokuhewage* Software Engineer WSO2 Inc. - http://wso2.com lean . enterprise . middleware Mobile - +9477-9-145-123 | +9471-455-6-401 Linkedin http://www.linkedin.com/pub/kavith-lokuhewage/49/473/419 Twitter https://twitter.com/KavithThiranga -- *Kavith Lokuhewage* Software Engineer WSO2 Inc. - http://wso2.com lean . enterprise . middleware Mobile - +9477-9-145-123 | +9471-455-6-401 Linkedin http://www.linkedin.com/pub/kavith-lokuhewage/49/473/419 Twitter https://twitter.com/KavithThiranga ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] How to write proxy to get data from salesforce and write to database
Hi, I'm trying to get data from salesforce and save it to a mysql database. i have to use a proxy. I'm new to these concepts. Is there anyone who can help me? Any blogs articles, etc...? Thanks, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] Error while trying proxy service
Hi, I created a proxy. When i use the 'try it' option from the management console, i get the following error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Transport error: 411 Error: Length Required/TryitProxyError What could be the reason for this? I created a pass through proxy, gave the target url as: http://www.w3schools.com/webservices/tempconvert.asmx?WSDL This is my proxy: ?xml version=1.0 encoding=UTF-8? proxy xmlns=http://ws.apache.org/ns/synapse; name=passthroughtest transports=https,http statistics=disable trace=disable startOnLoad=true target outSequence send/ /outSequence endpoint address uri=http://www.w3schools.com/webservices/tempconvert.asmx / /endpoint /target publishWSDL uri= http://www.w3schools.com/webservices/tempconvert.asmx?WSDL/ description/ /proxy Thanks in advance M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error while trying proxy service
i had already tried that. Still no use. M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Thu, Jun 11, 2015 at 4:31 PM, Thusitha Thilina Dayaratne thusit...@wso2.com wrote: Hi, According to the[1] it check for the content length header. Add property name=DISABLE_CHUNKING scope=axis2 value=true/ as it suggest to your proxy [1] - http://stackoverflow.com/questions/20489419/wso2-esb-proxy-service-error-transport-error-411-error-length-required Thanks On Thu, Jun 11, 2015 at 3:59 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I created a proxy. When i use the 'try it' option from the management console, i get the following error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Transport error: 411 Error: Length Required/TryitProxyError What could be the reason for this? I created a pass through proxy, gave the target url as: http://www.w3schools.com/webservices/tempconvert.asmx?WSDL This is my proxy: ?xml version=1.0 encoding=UTF-8? proxy xmlns=http://ws.apache.org/ns/synapse; name=passthroughtest transports=https,http statistics=disable trace=disable startOnLoad=true target outSequence send/ /outSequence endpoint address uri= http://www.w3schools.com/webservices/tempconvert.asmx/ /endpoint /target publishWSDL uri= http://www.w3schools.com/webservices/tempconvert.asmx?WSDL/ description/ /proxy Thanks in advance M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thusitha Dayaratne Software Engineer WSO2 Inc. - lean . enterprise . middleware | wso2.com Mobile +94712756809 Blog alokayasoya.blogspot.com Abouthttp://about.me/thusithathilina ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error when trying to run proxy service
Hi Kavith, i got the following: [2015-06-12 11:05:02,198] INFO {SERVICE_LOGGER.query} - Connection = Login to Salesforce . [2015-06-12 11:05:03,435] WARN {SERVICE_LOGGER} - ERROR_CODE : null ERROR_MESSAGE : null M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 12, 2015 at 10:59 AM, Kavith Lokuhewage kav...@wso2.com wrote: Hi Aaquibah, Do you see any error logs in ESB side? Thanks. On Fri, Jun 12, 2015 at 10:52 AM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I followed the stepsin this link to get data from salesforce and write to mysql database : http://wso2.com/library/articles/2014/02/cloud-to-rdbms-using-wso2-esb/ When i try the service, i get this error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Read timed out/TryitProxyError Any ideas to solve this??? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Kavith Lokuhewage* Software Engineer WSO2 Inc. - http://wso2.com lean . enterprise . middleware Mobile - +9477-9-145-123 | +9471-455-6-401 Linkedin http://www.linkedin.com/pub/kavith-lokuhewage/49/473/419 Twitter https://twitter.com/KavithThiranga ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] Error when trying to run proxy service
Hi, I followed the stepsin this link to get data from salesforce and write to mysql database : http://wso2.com/library/articles/2014/02/cloud-to-rdbms-using-wso2-esb/ When i try the service, i get this error: TryitProxyError h:status=SOAP envelope error xmlns:h= http://wso2.org/ns/TryitProxy;org.apache.axis2.AxisFault: Read timed out/TryitProxyError Any ideas to solve this??? Thanks in advance, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] How to run 2 servers at once using different port numbers?
Thank you M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 5, 2015 at 5:39 PM, Chamalee De Silva chama...@wso2.com wrote: Hi, Adding more, To change the port offset in Jaggery server you have to go the following location, which is bit different from the other WSO2 products. *PRODUCT_HOME/carbon/repository/conf/carbon.xml* On Fri, Jun 5, 2015 at 5:32 PM, Shabir Mohamed sha...@wso2.com wrote: Hi Aaquibah, If you will be working with such scenarios more often, then a more persistent way is to change the *port offset *in the *carbon.xml* file. This way you'll not need to do put in the *-DportOffset *flag all the time. The *carbon.xml *file is the main configurations file found inside every WSO2 carbon based product. It's at: *PRODUCT_HOME/repository/conf/carbon.xml* *Ports* *!-- Ports offset. This entry will set the value of the ports defined below to* * the define value + Offset.* * e.g. Offset=2 and HTTPS port=9443 will set the effective HTTPS port to 9445* * --* *Offset0/Offset* * * Regards - *Shabir Mohamed* *Software Engineer* WSO2 Inc.; http://wso2.com Email: sha...@wso2.com ayy...@wso2.com Mobile: +94 77 3516019 | +94 71 6583393 On Fri, Jun 5, 2015 at 5:19 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi Kalpa, It works. Thanks M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 5, 2015 at 5:16 PM, Kalpa Welivitigoda kal...@wso2.com wrote: Hi Nashry, Try, sh wso2server.sh -DportOffset=1 On Fri, Jun 5, 2015 at 5:12 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am trying to run the esb and jaggery servers at once. I tried it as follows: i first ran the jaggery server. Then used: sh wso2server.sh -D offset key=1 But it doesn't work. Can anyone help me on this? I am using Ubuntu. Thanks, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thanks Regards, *Chamalee De Silva* Software Engineer *WS**O2* Inc. .:http://wso2.com lean *.* enterprise *.* middleware Office :- *+94 11 2145345 %2B94%2011%202145345* mobile :- *+94 7 %2B94%2077%2027820391 1540738* ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
[Dev] How to run 2 servers at once using different port numbers?
Hi, I am trying to run the esb and jaggery servers at once. I tried it as follows: i first ran the jaggery server. Then used: sh wso2server.sh -D offset key=1 But it doesn't work. Can anyone help me on this? I am using Ubuntu. Thanks, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] How to run 2 servers at once using different port numbers?
Hi Kalpa, It works. Thanks M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Fri, Jun 5, 2015 at 5:16 PM, Kalpa Welivitigoda kal...@wso2.com wrote: Hi Nashry, Try, sh wso2server.sh -DportOffset=1 On Fri, Jun 5, 2015 at 5:12 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, I am trying to run the esb and jaggery servers at once. I tried it as follows: i first ran the jaggery server. Then used: sh wso2server.sh -D offset key=1 But it doesn't work. Can anyone help me on this? I am using Ubuntu. Thanks, M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error while running the Application server
i unset the CARBON_HOME variable and ran the AS as usual, and it still works. M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 8:16 PM, Sachith Withana sach...@wso2.com wrote: The problem might be due to working inside the /usr/ directory. ( It's kinda odd to see someone's user home being inside the /usr directory) Try this if you can, -first unset the CARBON_HOME if you have set it already -then try running AS from inside the home directory ex: /home/nashry/software/wso2as-5.2.1 This MIGHT be occurring due to an permission issue. On Mon, Jun 1, 2015 at 4:34 PM, Nirmal Fernando nir...@wso2.com wrote: hmm... it's strange that it fails. May be you can investigate by adding few echos to the wso2server.sh. On Mon, Jun 1, 2015 at 4:26 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, im using Ubuntu 14.04 LTS 64 bit M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 1:38 PM, Nirmal Fernando nir...@wso2.com wrote: What's your OS and version? Good that manual setting worked, but we need to figure out why automatic recognition failed and possibly fix it. On Mon, Jun 1, 2015 at 1:10 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, setting the CARBON_HOME manually worked. Thanks everyone M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 12:26 PM, Sachith Withana sach...@wso2.com wrote: If you want to run the AS try setting the $CARBON_HOME manually. Ex: export $CARBON_HOME= /usr/nashry/home/SOFTWARES/wso2as-5.2.1 It seems the script can't figure out the exact CARBON_HOME to be set. On Mon, Jun 1, 2015 at 12:20 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, Make sure that there is tomcat-juli-7.0.59.jar inside AS_HOME/bin directory. Thanks, Chathura. On Mon, Jun 1, 2015 at 12:05 PM, Shashika Karunatilaka shashi...@wso2.com wrote: HI, Can you try running using java 1.6 On Mon, Jun 1, 2015 at 12:02 PM, Thusitha Thilina Dayaratne thusit...@wso2.com wrote: Hi, Are you getting this in a fresh pack? Thanks /Thusitha On Mon, Jun 1, 2015 at 12:01 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i get the following error when i try to run the application server. Can anyone help me with this? JAVA_HOME environment variable is set to /usr/lib/jvm/jdk1.7.0_79 CARBON_HOME environment variable is set to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 wso2server.sh: 260: cd: can't cd to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 Could not load Logmanager org.apache.juli.ClassLoaderLogManager java.lang.ClassNotFoundException: org.apache.juli.ClassLoaderLogManager at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.util.logging.LogManager$1.run(LogManager.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.util.logging.LogManager.clinit(LogManager.java:181) at java.util.logging.Logger.demandLogger(Logger.java:339) at java.util.logging.Logger.getLogger(Logger.java:393) at com.sun.jmx.remote.util.ClassLogger.init(ClassLogger.java:55) at sun.management.jmxremote.ConnectorBootstrap.clinit(ConnectorBootstrap.java:823) at sun.management.Agent.startLocalManagementAgent(Agent.java:144) at sun.management.Agent.startAgent(Agent.java:264) at sun.management.Agent.startAgent(Agent.java:456) Error: Could not find or load main class org.wso2.carbon.bootstrap.Bootstrap M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thusitha Dayaratne Software Engineer WSO2 Inc. - lean . enterprise . middleware | wso2.com Mobile +94712756809 Blog alokayasoya.blogspot.com Abouthttp://about.me/thusithathilina ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Shashika Prabath Karunatilaka, Software Engineer, WSO2, Inc: http://wso2.com/ mobile : +94 77 7487792 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Chathura Priyankara Software Engineer | WSO2 Inc. Mobile : +94718795340 Blog : www.codeoncloud.blogspot.com
Re: [Dev] Error while running the Application server
Hi, Ya. That was the problem as i understand. Thanks M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Tue, Jun 2, 2015 at 7:36 PM, Thusitha Thilina Dayaratne thusit...@wso2.com wrote: Hi, When the server starts it is setting the CARBON_HOME value. So even if you unset the CARBON_HOME value before the server starts, it will not affect the server starting process. The interesting thing is how the CARBON_HOME was set to some other place(/usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 as you mentioned in the mail) in the first time. If you able to reproduce the same scenario please update this thread. Thanks /Thusitha On Tue, Jun 2, 2015 at 7:23 PM, Aaquibah Nashry nas...@wso2.com wrote: i unset the CARBON_HOME variable and ran the AS as usual, and it still works. M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 8:16 PM, Sachith Withana sach...@wso2.com wrote: The problem might be due to working inside the /usr/ directory. ( It's kinda odd to see someone's user home being inside the /usr directory) Try this if you can, -first unset the CARBON_HOME if you have set it already -then try running AS from inside the home directory ex: /home/nashry/software/wso2as-5.2.1 This MIGHT be occurring due to an permission issue. On Mon, Jun 1, 2015 at 4:34 PM, Nirmal Fernando nir...@wso2.com wrote: hmm... it's strange that it fails. May be you can investigate by adding few echos to the wso2server.sh. On Mon, Jun 1, 2015 at 4:26 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, im using Ubuntu 14.04 LTS 64 bit M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 1:38 PM, Nirmal Fernando nir...@wso2.com wrote: What's your OS and version? Good that manual setting worked, but we need to figure out why automatic recognition failed and possibly fix it. On Mon, Jun 1, 2015 at 1:10 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, setting the CARBON_HOME manually worked. Thanks everyone M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 12:26 PM, Sachith Withana sach...@wso2.com wrote: If you want to run the AS try setting the $CARBON_HOME manually. Ex: export $CARBON_HOME= /usr/nashry/home/SOFTWARES/wso2as-5.2.1 It seems the script can't figure out the exact CARBON_HOME to be set. On Mon, Jun 1, 2015 at 12:20 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, Make sure that there is tomcat-juli-7.0.59.jar inside AS_HOME/bin directory. Thanks, Chathura. On Mon, Jun 1, 2015 at 12:05 PM, Shashika Karunatilaka shashi...@wso2.com wrote: HI, Can you try running using java 1.6 On Mon, Jun 1, 2015 at 12:02 PM, Thusitha Thilina Dayaratne thusit...@wso2.com wrote: Hi, Are you getting this in a fresh pack? Thanks /Thusitha On Mon, Jun 1, 2015 at 12:01 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i get the following error when i try to run the application server. Can anyone help me with this? JAVA_HOME environment variable is set to /usr/lib/jvm/jdk1.7.0_79 CARBON_HOME environment variable is set to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 wso2server.sh: 260: cd: can't cd to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 Could not load Logmanager org.apache.juli.ClassLoaderLogManager java.lang.ClassNotFoundException: org.apache.juli.ClassLoaderLogManager at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.util.logging.LogManager$1.run(LogManager.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.util.logging.LogManager.clinit(LogManager.java:181) at java.util.logging.Logger.demandLogger(Logger.java:339) at java.util.logging.Logger.getLogger(Logger.java:393) at com.sun.jmx.remote.util.ClassLogger.init(ClassLogger.java:55) at sun.management.jmxremote.ConnectorBootstrap.clinit(ConnectorBootstrap.java:823) at sun.management.Agent.startLocalManagementAgent(Agent.java:144) at sun.management.Agent.startAgent(Agent.java:264) at sun.management.Agent.startAgent(Agent.java:456) Error: Could not find or load main class org.wso2.carbon.bootstrap.Bootstrap M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com
[Dev] Error while running the Application server
Hi, i get the following error when i try to run the application server. Can anyone help me with this? JAVA_HOME environment variable is set to /usr/lib/jvm/jdk1.7.0_79 CARBON_HOME environment variable is set to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 wso2server.sh: 260: cd: can't cd to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 Could not load Logmanager org.apache.juli.ClassLoaderLogManager java.lang.ClassNotFoundException: org.apache.juli.ClassLoaderLogManager at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.util.logging.LogManager$1.run(LogManager.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.util.logging.LogManager.clinit(LogManager.java:181) at java.util.logging.Logger.demandLogger(Logger.java:339) at java.util.logging.Logger.getLogger(Logger.java:393) at com.sun.jmx.remote.util.ClassLogger.init(ClassLogger.java:55) at sun.management.jmxremote.ConnectorBootstrap.clinit(ConnectorBootstrap.java:823) at sun.management.Agent.startLocalManagementAgent(Agent.java:144) at sun.management.Agent.startAgent(Agent.java:264) at sun.management.Agent.startAgent(Agent.java:456) Error: Could not find or load main class org.wso2.carbon.bootstrap.Bootstrap M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error while running the Application server
Hi, setting the CARBON_HOME manually worked. Thanks everyone M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 12:26 PM, Sachith Withana sach...@wso2.com wrote: If you want to run the AS try setting the $CARBON_HOME manually. Ex: export $CARBON_HOME= /usr/nashry/home/SOFTWARES/wso2as-5.2.1 It seems the script can't figure out the exact CARBON_HOME to be set. On Mon, Jun 1, 2015 at 12:20 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, Make sure that there is tomcat-juli-7.0.59.jar inside AS_HOME/bin directory. Thanks, Chathura. On Mon, Jun 1, 2015 at 12:05 PM, Shashika Karunatilaka shashi...@wso2.com wrote: HI, Can you try running using java 1.6 On Mon, Jun 1, 2015 at 12:02 PM, Thusitha Thilina Dayaratne thusit...@wso2.com wrote: Hi, Are you getting this in a fresh pack? Thanks /Thusitha On Mon, Jun 1, 2015 at 12:01 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i get the following error when i try to run the application server. Can anyone help me with this? JAVA_HOME environment variable is set to /usr/lib/jvm/jdk1.7.0_79 CARBON_HOME environment variable is set to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 wso2server.sh: 260: cd: can't cd to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 Could not load Logmanager org.apache.juli.ClassLoaderLogManager java.lang.ClassNotFoundException: org.apache.juli.ClassLoaderLogManager at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.util.logging.LogManager$1.run(LogManager.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.util.logging.LogManager.clinit(LogManager.java:181) at java.util.logging.Logger.demandLogger(Logger.java:339) at java.util.logging.Logger.getLogger(Logger.java:393) at com.sun.jmx.remote.util.ClassLogger.init(ClassLogger.java:55) at sun.management.jmxremote.ConnectorBootstrap.clinit(ConnectorBootstrap.java:823) at sun.management.Agent.startLocalManagementAgent(Agent.java:144) at sun.management.Agent.startAgent(Agent.java:264) at sun.management.Agent.startAgent(Agent.java:456) Error: Could not find or load main class org.wso2.carbon.bootstrap.Bootstrap M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thusitha Dayaratne Software Engineer WSO2 Inc. - lean . enterprise . middleware | wso2.com Mobile +94712756809 Blog alokayasoya.blogspot.com Abouthttp://about.me/thusithathilina ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Shashika Prabath Karunatilaka, Software Engineer, WSO2, Inc: http://wso2.com/ mobile : +94 77 7487792 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Chathura Priyankara Software Engineer | WSO2 Inc. Mobile : +94718795340 Blog : www.codeoncloud.blogspot.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Sachith Withana Software Engineer; WSO2 Inc.; http://wso2.com E-mail: sachith AT wso2.com M: +94715518127 Linked-In: http://goog_416592669 https://lk.linkedin.com/in/sachithwithana ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error while running the Application server
Hi, im using Ubuntu 14.04 LTS 64 bit M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 1:38 PM, Nirmal Fernando nir...@wso2.com wrote: What's your OS and version? Good that manual setting worked, but we need to figure out why automatic recognition failed and possibly fix it. On Mon, Jun 1, 2015 at 1:10 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, setting the CARBON_HOME manually worked. Thanks everyone M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com On Mon, Jun 1, 2015 at 12:26 PM, Sachith Withana sach...@wso2.com wrote: If you want to run the AS try setting the $CARBON_HOME manually. Ex: export $CARBON_HOME= /usr/nashry/home/SOFTWARES/wso2as-5.2.1 It seems the script can't figure out the exact CARBON_HOME to be set. On Mon, Jun 1, 2015 at 12:20 PM, Chathura Priyankara chathu...@wso2.com wrote: Hi, Make sure that there is tomcat-juli-7.0.59.jar inside AS_HOME/bin directory. Thanks, Chathura. On Mon, Jun 1, 2015 at 12:05 PM, Shashika Karunatilaka shashi...@wso2.com wrote: HI, Can you try running using java 1.6 On Mon, Jun 1, 2015 at 12:02 PM, Thusitha Thilina Dayaratne thusit...@wso2.com wrote: Hi, Are you getting this in a fresh pack? Thanks /Thusitha On Mon, Jun 1, 2015 at 12:01 PM, Aaquibah Nashry nas...@wso2.com wrote: Hi, i get the following error when i try to run the application server. Can anyone help me with this? JAVA_HOME environment variable is set to /usr/lib/jvm/jdk1.7.0_79 CARBON_HOME environment variable is set to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 wso2server.sh: 260: cd: can't cd to /usr/nashry/home/SOFTWARES/org.wso2.carbon.server-4.2.0 Could not load Logmanager org.apache.juli.ClassLoaderLogManager java.lang.ClassNotFoundException: org.apache.juli.ClassLoaderLogManager at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.util.logging.LogManager$1.run(LogManager.java:191) at java.security.AccessController.doPrivileged(Native Method) at java.util.logging.LogManager.clinit(LogManager.java:181) at java.util.logging.Logger.demandLogger(Logger.java:339) at java.util.logging.Logger.getLogger(Logger.java:393) at com.sun.jmx.remote.util.ClassLogger.init(ClassLogger.java:55) at sun.management.jmxremote.ConnectorBootstrap.clinit(ConnectorBootstrap.java:823) at sun.management.Agent.startLocalManagementAgent(Agent.java:144) at sun.management.Agent.startAgent(Agent.java:264) at sun.management.Agent.startAgent(Agent.java:456) Error: Could not find or load main class org.wso2.carbon.bootstrap.Bootstrap M.R.Aaquibah Nashry *Intern, Engineering* Mobile : +94 773946123 Tel : +94 112662541 nas...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thusitha Dayaratne Software Engineer WSO2 Inc. - lean . enterprise . middleware | wso2.com Mobile +94712756809 Blog alokayasoya.blogspot.com Abouthttp://about.me/thusithathilina ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Shashika Prabath Karunatilaka, Software Engineer, WSO2, Inc: http://wso2.com/ mobile : +94 77 7487792 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Chathura Priyankara Software Engineer | WSO2 Inc. Mobile : +94718795340 Blog : www.codeoncloud.blogspot.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Sachith Withana Software Engineer; WSO2 Inc.; http://wso2.com E-mail: sachith AT wso2.com M: +94715518127 Linked-In: http://goog_416592669 https://lk.linkedin.com/in/sachithwithana ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Thanks regards, Nirmal Associate Technical Lead - Data Technologies Team, WSO2 Inc. Mobile: +94715779733 Blog: http://nirmalfdo.blogspot.com/ ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev