1Reply
Help with Database set up and Datastore Extension
Posted on December 9, 2016 10:27 AM by n/ALatest Reply on December 9, 2016 2:07 PM by UrsHi, I have read the documentation of the Datastore Extension but I can't find this Datastore Extension on the platform. It might be my platform hasn't it, right? I have access to a MySQL DataSource. In the application I am trying to design a user can register or ...
1Reply
Integration links and Kerberos
Posted on October 19, 2016 4:14 PM by Michaël DegenLatest Reply on October 20, 2016 9:47 AM by Brett CrawleyHello, I have a problem with Integration links and Kerberos. We use Kerberos for the authentication. I have created an integration links that call a Soap webservice. This Soap webservice use the Preemptive Authentication => Method Executor => SPNegoMethodExecutor. If I use ...
1Reply
Connection Pool Exhausted
Posted on October 19, 2016 12:14 PM by n/ALatest Reply on October 21, 2016 2:32 PM by CateHi, We sometimes (about every two weeks) run into the problem that there are too many open connections to the datasource, so any new process that tries to execute an sql statement fails because he can't get another connection. Our DB Connection Pool limit is 150 connections.
2Replies
Integration Link Process Message Queue
Posted on October 17, 2016 7:34 PM by n/ALatest Reply on October 18, 2016 11:38 PM by n/AHello, I'm having trouble extracting the message body from a message queue with an Integration Link. I've tried pulling from $in(org.apache.camel.Message) and $message(WorkflowMessage) variables, but body is empty for all of the messages. The queue is populated from a source Integration Link and messages do exist. ...
3Replies
Process Start Event Message Filtering
Posted on October 11, 2016 11:53 PM by n/ALatest Reply on October 13, 2016 11:31 AM by n/AHello, I have a Process Start Event Message listening on a Message Queue and every message that is read from queue is creating a Process Instance ID. Is there an easy way to filter the messages so that only a certain set of messages creates a Process Instance ...
5Replies
CSV File - Integration Link - Directory Scanner - Splitter - Message Queue - Process
Posted on September 1, 2016 6:23 PM by n/ALatest Reply on September 2, 2016 9:46 PM by Lorenzo GironiHello, I could use some help with a solution where I can upload a CSV file with multiple records and each record will kick off a the same Process. I'm using Appway 6.2.12 and I'm unable to get this solution working end to end. I ...
1Reply
Error launching a process
Posted on July 27, 2016 11:48 AM by n/ALatest Reply on July 28, 2016 7:55 AM by UrsClients are unable to launch any process from their application though the processes work as expected in Appway Studio. The log file shows the following error, org.jabsorb.JSONRPCServlet > Using global bridge. org.jabsorb.JSONRPCServlet > receive: {id:6833,method:"mod_NodeInspector.getNodeStates",params:["newest", 60000]} org.jabsorb.JSONRPCServlet > receive: { "id": 6833, "method": "mod_NodeInspector.getNodeStates",
3Replies
Catalog cache always deleted after 20 minutes
Posted on June 23, 2016 1:25 PM by n/ALatest Reply on June 24, 2016 9:56 PM by MauHello, I have an issue with the catalog cache, the thing is that even if I set a retention expression for 1 day (like below), the cluster cache is deleted after 20 minutes. If I set the cache to be deleted to a value smaller that 20 minutes ...
2Replies
Authorization header missing in SOAP calls
Posted on June 16, 2016 9:00 AM by n/ALatest Reply on June 17, 2016 3:08 PM by UrsWe have an issue accessing SOAP WebServices that are secured with HTTP/Basic authentication. We use WebServices extension 2.2.24. In our basic setup we have an Appway Server and a middleware server providing a SOAP WebService used by Appway. In the Integration Link, the default URL for the SOAP service ...
3Replies
Docusign Integration from Appway
Posted on February 19, 2016 10:43 PM by n/ALatest Reply on April 8, 2016 8:34 PM by n/AHello, Could you please share any details for docusign integration from appway. We have one functionality where we need to send document for eSignature to client using docusign. Thanks for Help.
4RepliesSOLVED
Execution time of webservice calls
Posted on February 4, 2016 12:17 PM by Michaël DegenLatest Reply on February 12, 2016 9:32 AM by Michaël DegenHello, I would like to know if there is an extension or something else that we can use to see execution times of webservices calls. In console => Integration links, we can see the number of invocations and exceptions but there is nothing about execution times. Before creating something, ...
2Replies
Appway as REST Provider
Posted on January 12, 2016 2:43 PM by n/ALatest Reply on February 19, 2016 3:01 PM by CateAre there some best practices to use Appway as REST provider? As the documentation says Appway supports with the Webservice extension only REST as a client, are there ways prefered ways to run Appway as REST provider?
2RepliesSOLVED
Best Practices For REST Integration
Posted on December 14, 2015 3:58 PM by Imran BrownLatest Reply on December 21, 2015 3:05 PM by Imran BrownWhat are the best practices for REST integration?
- Currently you can use TranslateTo and TranslateFrom to convert JSON to Appway Business Object and the reverse. However one of the biggest drawback to this solution is that, if anything changes, TranslateFrom will fail. Which means any change in the
5RepliesSOLVED
Unknown column 'awop' in 'field list' using MySQL
Posted on November 26, 2015 10:15 AM by n/ALatest Reply on January 13, 2016 10:06 PM by Brett CrawleyHi if I try to store a Dataclass into a MySQL DB I receive sometimes the error message: Unknown column 'awop' in 'field list'. Caused by: com.nm.sdk.NmEvaluatorException: Could not save structure to datasource 'bank'. java.sql.SQLException: Unknown column 'awop' in 'field list' Query: INSERT INTO "person"("awid", While the error message ...
2RepliesSOLVED
Problem with HTTPGET() and HTTPPOST() functions
Posted on November 25, 2015 3:42 PM by Jean Jacques BodoLatest Reply on December 2, 2015 9:29 AM by Jean Jacques BodoHello, We are currently experiencing problems with HTTPGET() and HTTPOST() functions to read and send files to server through HTTPS: We always get the 404 file not found error. Here are the errors reported on the server side. HTTPGET() [msg "Request Missing an Accept ...
5Replies
Database setup - MySQL error message 1071
Posted on November 24, 2015 10:24 AM by n/ALatest Reply on November 25, 2015 4:04 PM by n/AHello I am using 6.2.9 and trying to setup MySQL DB, (following System Installation (Appway 6), section 4.2.1). When I run the ddl for Mysql I get the following error message. What is the significance of ...
12Replies
Secure WebService
Posted on November 23, 2015 9:46 AM by n/ALatest Reply on October 20, 2016 9:45 AM by Brett CrawleyI need to access a SOAP WebService that is secured. I could not really find this information in the documentation. 1) One way would be to secure the WS using WS-Security (WSS). However, this requires setting complex SOAP headers. WSDL does not necessarily contain any reference to ...
2Replies
DataStore extension generates invalid queries for MySQL
Posted on October 22, 2015 5:37 PM by n/ALatest Reply on October 22, 2015 7:38 PM by n/AHi I'm having troubles setting up the DataStore extension with MySQL 5.6. The extension has trouble executing any query on MySQL, since it does not seem to generate MySQL compatible queries. For example, if I try to sync all dataclasses, for each dataclass I get this error:
5RepliesSOLVED
Exception handling with Event Message Pattern
Posted on October 21, 2015 7:44 AM by n/ALatest Reply on October 22, 2015 8:19 AM by n/AHi there, As the event message pattern asynchronously gets called, when we call the link we're not expecting a response immediately. In the event that the integration link throws an exception, in Appway this appears to be logged and then only visible if you go into the console and ...
4Replies
Inserting binary documents in a (oracle) blob field
Posted on October 15, 2015 5:05 PM by Ingo GuthmannLatest Reply on October 19, 2015 8:58 AM by Ingo GuthmannHello I have to store a file (pdf or txt or …) in a cblob field of an oracle db. How i have to build the sql-statement? First try: Code: SqlQueryStatement $sqlQueryStatement := new SqlQueryStatement; Indexed Any $values := new Indexed Any; String $data := ReadBinaryData('work\\tmp\\uploads' & $file);
3RepliesSOLVED
Consumation of Workflow Message
Posted on September 3, 2015 10:02 PM by RogerLatest Reply on September 4, 2015 5:49 PM by StephanHi, We currently implement a mechanism where an extension puts a message into a workflow queue for a specific process (recipient prcs id set) and we saw the following behavior: If message gets sent form the ISE it is consumed right away but if the message is coming ...
4Replies
How can I send a file to Appway using webservice?
Posted on August 25, 2015 8:32 AM by Jean Jacques BodoLatest Reply on October 1, 2015 3:54 PM by Thomas SuterHello, Is it possible to send files to Appway (from a third party system) using webservice? If so how can it be achieved?
2Replies
How can i insert a date into oracle db (data-type of oracle-field = DATE)?
Posted on July 6, 2015 8:53 AM by Ingo GuthmannLatest Reply on July 7, 2015 8:31 AM by Ingo GuthmannIf i try to insert a date as attribute with SqlQuery (SqlQueryStatement) in an oracle db, i get the error: java.sql.SQLException: Invalid column type Using a String or long instead of date i also get errors ("a non-numeric character was found where a numeric was expected" and "inconsistent datatypes: ...
1Reply
Catch soap time out
Posted on June 5, 2015 4:43 PM by Simon VerhoevenLatest Reply on June 16, 2015 9:46 AM by Brett CrawleyHi I have a web service which searches for trusts (clients). If the users search term is too broad e.g 'e', '*' or 'trust', the service fails after the preset timeout (specified when importing the wsdl). I would like to display a message to the user that they ...
3Replies
SOAP: Handling abstract types
Posted on June 4, 2015 3:38 PM by n/ALatest Reply on July 14, 2015 9:23 AM by n/AHello, The simplified situation is as follows: @WebService Service1 List<Container> getContainersWithCars() @WebMethod @WebService Service2 List<Container> getContainersWithPlanes() @WebMethod @XmlType(name = "Container") Container Vehicle vehicle; ... @XmlType(name = "Vehicle") @XmlSeeAlso({ Car.class, Plane.class }) Vehicle[abstract] Integer weight; String colour; ... @XmlType(name = "Car") Car[extends Vehicle]
2Replies
Integration Links not starting automatically after server restart
Posted on May 22, 2015 2:17 PM by n/ALatest Reply on May 29, 2015 9:41 AM by n/AHi, After a restart of the Appway (6.2.2) server, all integration links were in status "inactive". In the content configuration, the property nm.integrationlink.autoStartCommitted = true is set. According to my understanding, this should start all integration links automatically. If not, how do I ensure that the ...
2RepliesSOLVED
Import to Catalog from .csv id column
Posted on May 5, 2015 10:19 AM by n/ALatest Reply on May 5, 2015 10:52 AM by n/AHi all, I have a small problem. When I try to update a catalog from a .csv file, it reports me that the existing catalog does not know the id column (it has the id column of course). Our workaround is to add missing columns, remove existing id column ...
1Reply
Exception in the REST client when receiving a 404 code
Posted on March 27, 2015 8:18 AM by Sebastien VallonLatest Reply on March 30, 2015 2:11 PM by Thomas SuterHi! I have questions regarding the REST client in Appway. At our customer, we are calling this REST webservice, which in certain cases (‚user not found‘) is responding via a 404 response code. But the REST client in the Integration Link in Appway is getting an Exception in ...
3Replies
How to access custom exceptions returned by WebService
Posted on February 11, 2015 11:11 AM by n/ALatest Reply on February 11, 2015 5:53 PM by Brett CrawleyHello, I have a WebService which throws a custom ValidationException. This exception wraps information (essentially a list of validation results) that needs to be displayed to the user. I cannot find a way to access this custom ValidationException from Appway. Any ideas or suggestions?
1Reply
Calling an Oracle Store Procedure
Posted on December 22, 2014 5:30 PM by n/ALatest Reply on December 31, 2014 2:19 PM by Thomas SuterHi, I have defined on Oracle the next store procedure: create or replace PROCEDURE GetRelation ( NumRelation IN VARCHAR2, DesRelation OUT VARCHAR2 ) AS BEGIN SELECT des_port into DesRelation from po_portafoglio ...
2Replies
Calling several integration links simultaneously
Posted on December 4, 2014 4:54 PM by n/ALatest Reply on December 15, 2014 12:54 PM by Falk LademannI want to call several webservices simultaneously to perform a global search on a couple of data sources. As soon as one of the webservices returns results, the screen (typically a table in an ajax update area) should be updated immediately. Also the user should be able to access the ...
1ReplySOLVED
External HTML
Posted on November 6, 2014 7:34 AM by n/ALatest Reply on November 6, 2014 9:36 AM by n/AWould like to know how to pull the external HTML in the Process as a screen? Thanks Salil
1ReplySOLVED
Connecting to the database without the data store extension
Posted on May 8, 2014 7:25 AM by n/ALatest Reply on May 8, 2014 8:36 AM by UrsHi, Is there any way we can insert , update or fetch records from th DB without using the database extension? Is so, please help me with a sample script for the same. Thanks in Advance.
1ReplySOLVED
Can CallOracleProcedure map more than one OUT parameter?
Posted on April 17, 2014 10:43 PM by n/ALatest Reply on April 18, 2014 9:51 AM by n/ATrying to call a stored procedure and would like to get back a cursor and a varchar2 value. For example: The code above only returns the currsor but it does not assign it to the variables. The stored procedure does return 2 OUT variables, one cursor and ...
5RepliesSOLVED
Adding a jar file and consuming in BPM process application.
Posted on April 9, 2014 7:33 AM by n/ALatest Reply on April 10, 2014 10:59 AM by n/AHi, I have some scanned jpg/png/gif images. Now these images have text on them, i need to read these text data. For this I made use of Tess4j ( an OCR tool to extract text from jpg/gif/png ). I have created a java utility project and ...
5RepliesSOLVED
Creating a new data class and map it with table in the database.
Posted on March 20, 2014 6:49 AM by n/ALatest Reply on May 12, 2014 3:39 PM by n/AHi, I have 3 querries. 1) I have a been successful in fetching data from the database (MySql) for the person table. When i tried to insert a row in that table using SaveDataEntity, i am getting some SQL exceptions. Which says that there is syntax ...
1ReplySOLVED
Runtime Database: Update a Boolean Value
Posted on December 23, 2013 2:29 PM by n/ALatest Reply on January 6, 2014 9:02 AM by Thomas SuterI'd like to update a boolean value which is a property in a large object $o. For performance reasons, I'd rather not load $o into memory to do that. I can of course use a query to find the row in the Values table which stores the Boolean. But ...
3RepliesSOLVED
XML Data Binding
Posted on December 10, 2013 11:04 AM by n/ALatest Reply on December 11, 2013 12:08 PM by PelleIs there any support from Appway for XML data binding? Possibilities to generate data classes based on XML schemas and to map XML documents from and to data class objects?
2RepliesSOLVED
INSERT with SELECT
Posted on October 31, 2013 11:13 AM by n/ALatest Reply on November 1, 2013 10:13 AM by n/AI have the problem that the following query does not work when executed with the SqlQuery function, while it works fine when run from another SQL client such as Oracle SQL Developer or SQuirreL. The returned error is which means ...
1ReplySOLVED
How to reset Integration Link Statistics (in the console)
Posted on October 14, 2013 10:13 AM by RogerLatest Reply on October 14, 2013 11:35 AM by Thomas SuterAnswer: - Only by restarting Appway. Question to Thomas: - Is it possible to add a button with which the statistics could be cleared?
6RepliesSOLVED
How to Download / Extract Data Fields into Excel (or any other program)?
Posted on June 27, 2013 6:03 PM by n/ALatest Reply on July 22, 2013 2:02 PM by Thomas SuterHow do we download or extract data fields from an existing Data Class business object into Excel, for example? Purpose for this is to not have someone manually retype every database field that's on every screen in a workflow. Thanks!
18RepliesSOLVED
How to upload a CSV to get Records back?
Posted on May 27, 2013 5:48 PM by n/ALatest Reply on May 29, 2013 5:24 PM by n/ADear all! I have a CSV I wanna upload in a process (as the Appway Studio can do). But I don't want the user to go into the Studio. How can I upload this? I found the function "LOADFROMCSV('Record', $uploadFile.filePath, ',')", but it does not recorgnize 'Record' ...
4RepliesSOLVED
3RepliesSOLVED
How to set SOAP Headers
Posted on March 26, 2013 5:04 PM by n/ALatest Reply on July 31, 2015 4:54 PM by Brett CrawleyIs it possible to set a SOAP Header be set when using a CLIENT dataclass generated by the SOAP Extension? If so, how can it be achieved? Assumption: SOAP Extension version 2.0.2.3