Hi, We are using a custom application to fill timesheet. When I try to retrieve data for current month I first run Prepare_Week__ procedure (I don’t have any clue of what this function is doing has there is NOT documentation on it) and then I retrieve work string PREPAREWEEK_QUERY = "&AO.Timman_Job_Trans_API.Prepare_Week__(:COMPANY_ID, :EMP_ID, :WEEK_START, :WEEK_END, 0, :SESSION_ID);";FndPLSQLCommand cmdPrepW = new FndPLSQLCommand(_connection, PREPAREWEEK_QUERY);// [...]prepareWeekCollection.Add(cmdPrepW);FndPLSQLSelectCommand cmdSelect= new FndPLSQLSelectCommand(_connection, GET_WORK_QUERY);// [...]workCollection.Add(cmdSelect);The connection is still the same, those lines are in loop for each week in a month.I created two FndPLSQLCommandCollection variable, one for prepareWeek and the other for the select command. Once the collections are full I Invoke prepareWeekCollection and the other one. I get an error on the work collection :Ifs.Fnd.FndTransactionIdMismatchException : 'Th
Hi, We are facing some randoms issues in our app which uses Java Access Provider. We wonder if we are using it correctly. To make it short, when a user logged in it will create a server object :Server server = new Server();server.setConnectionString(ifsProperties.getConnectionString());server.setLocale("fr-FR");server.setCredentials(username, password);Then we put this server in a server map associated with the username. So each user have his own server object stored in the Map. When a request is made we retrieve the corresponding server in the list and use it for our request :Server server = ifsServerPool.getServer(username);if(server == null) { // [...]}PlsqlSelectCommand cmd = new PlsqlSelectCommand(server, String.format( "SELECT * FROM &AO.activity_short_name_company_pa WHERE 1=1 %s ORDER BY SHORT_NAME OFFSET :OFFSET ROWS FETCH NEXT :LIMIT ROWS ONLY", searchStmt));Record params = cmd.getBindVariables();params.add("OFFSET", String.valueOf(offset));param
Hi, We set up an application with a Java backend (using Java Access Provider), front in JS/PHP, requests are sent via ajax and we noticed some curious things :When a single user login, (all ajax requests are async), the application will sometimes throw an bad credentials (comming from IFS Web logic) when user making an action (saving, loading, ...). When a single user login, (all ajax [for testing] requests are sync), the application won’t throw any bad credentials (comming from IFS Web logic) when user making an action (saving, loading, ...). When two users use the app at the same time (async and sync requests) one of the user will have a bad credentials (comming from IFS Web logic) .We are 99% sure that those errors are due to a concurrency in Oracle or WebLogic. The error occurs when multiple users are making the same request. The problem is weird because IFS should handle multiple connections (hopefuly) We checked the value of Server variable passed to all request made : it’s the
Hi,Is there any tutorial about How to properly login user with IFS in java?Because I am facing really stranges problems and I wonder if it because I use IFS connection badly. The doc is really poor and I can’t find any example…Login function (POST /login) that returns a JWT tokenUsernamePasswordAuthenticationToken authenticationToken = new UsernamePasswordAuthenticationToken( loginVM.getUsername(), loginVM.getPassword());try { Authentication authentication = this.authenticationManager.authenticate(authenticationToken); SecurityContextHolder.getContext().setAuthentication(authentication); long tokenValidityInMilliseconds = 0; tokenValidityInMilliseconds = 1000 * ifsProperties.getSecurity().getJwt().getTokenValidityInSeconds(); System.out.println("Token validity: " + tokenValidityInMilliseconds); // Remove the token from the pool after expiration serverPool.removeServerAfter(authentication.getName(), tokenValidityInMilliseconds); String jwt = tokenProvider.createToken(authentication, fa
Hi, I have a web API in C# using Fnd library to use IFS. Sometime I get an error that in thrown when executing a query. For example :FndPLSQLSelectCommand cmd = new FndPLSQLSelectCommand(Connection, query); FndDataTable table = cmd.ExecuteReader(); // <-- Error thrown hereThe error thrown is :Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application. at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Ifs.Fnd.Windows.Forms.FndMessageBox.Show(String message, String title, MessageBoxButtons buttons, FndMessageBoxIconEx icon, MessageBoxDefaultButton defaultButton, FndMessageBoxDetails messageDetails, String checkBoxMessage, Boolean& checkedValue, Int32 timeout) at Ifs.Fnd.FndException.Show(Form ownerForm) at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, O
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.