jaybodra
New Contributor III
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: BUG OR ERROR : Date UTC Method
@virender.prajapati I have seen this happening to me in MySQL. I used toLocalDateTimeString() function before inserting it into the DB and worked fine. You can try this in your mapper, Date.UTC(Date.now().minusMonths(1).getFullYear(),Date.now().minusMonths(1).getMonth(),0).toLocaleDateTimeString({“format”: “yyyy-MM-dd HH:mm:ss”,“timeZone”:“UTC”}) You can also look into oracle jdbc url properties4.1KViews0likes3CommentsRe: Create array using script snap
You need to define arraylist. I often get confused between datatypes when using python on SnapLogic which is jython. I am assuming javascript is also using JSR engine which is different than traditional javascript. If it is possible I would highly recommend using python script instead of JavaScript. // Ensure compatibility with both JDK 7 and 8 JSR-223 Script Engines try { load(“nashorn:mozilla_compat.js”); } catch(e) { } // Import the interface required by the Script snap. importPackage(com.snaplogic.scripting.language); // Import the Java utility classes. importPackage(java.util); /** Create an object that implements the methods defined by the “ScriptHook” interface. We’ll be passing this object to the constructor for the ScriptHook interface. / var impl = { / These variables (input, output, error, log) are defined by the ExecuteScript snap when evaluating this script. */ input : input, output : output, error : error, log : log, /** The “execute()” method is called once when the pipeline is started and allowed to process its inputs or just send data to its outputs. Exceptions are automatically caught and sent to the error view. */ execute : function () { this.log.info(“Executing Transform Script”); while (this.input.hasNext()) { try{ // Read the next document, wrap it in a map and write out the wrapper var doc = this.input.next(); var wrapper = new java.util.HashMap(); var out = new java.util.ArrayList(); out.add(‘a’) out.add(‘b’) this.output.write(doc, out); this.log.info(“Transform Script finished”); } catch(err) { var wrapper = new java.util.HashMap(); wrapper.put("errorMsg", err); this.log.error(err); this.error.write(wrapper); } } } }; /** The Script Snap will look for a ScriptHook object in the “hook” variable. The snap will then call the hook’s “execute” method. */ var hook = new com.snaplogic.scripting.language.ScriptHook(impl); Happy coding!3.6KViews1like1CommentRe: Snaplex Node Freezing with High Memory
Had similar issue and the node use to restart cause it would crash (Ran out of memory). I have a ticket for this issue. I would be glad if snaplogic is able to free up memory on its own. (Tried to do it with jython script which didnt work either)890Views0likes0Comments