Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions REPLACEMAP and CR/LF char(10).... https://community.denodo.com/answers/question/details?questionId=906Qj00000LgPZ2IAN&title=REPLACEMAP+and+CR%2FLF+char%2810%29.... Hi Denodo Team, i want to Replace CR and LF in some columns. With Replace this is no Problem and working fine. ``` REPLACE(REPLACE(column1, char(10), ''), char(13),'') ``` But for future use i want a MAP for this. ``` CREATE MAP simple forbidden_chars ( 'char(10)' = '' 'char(13)' = '' ); ``` this is not working. how can I do this with a map ? And how can i Change a map ? Do i have to drop it first ? Thu, 31 Oct 2024 15:02:23 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LgPZ2IAN&title=REPLACEMAP+and+CR%2FLF+char%2810%29.... 2024-10-31T15:02:23Z Certified Developer Professional Question https://community.denodo.com/answers/question/details?questionId=906Qj00000LUcDRIA1&title=Certified+Developer+Professional+Question Hi, I'm interested in taking all the training courses for the Certified Developer Professional. But looks like the training courses listed above have some for Denodo 9.0 and some for 8.0. Wondering if someone could help understand the approach of taking the courses(if those are going to change soon etc.) Thanks! Mon, 28 Oct 2024 21:10:42 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LUcDRIA1&title=Certified+Developer+Professional+Question 2024-10-28T21:10:42Z Unable to login https://community.denodo.com/answers/question/details?questionId=906Qj00000LKT1lIAH&title=Unable+to+login I have just installed express version of denodo. I don't remeber about User Name. I got secuirtycode via email and then entered password. Now it is asking user name. I am typing my email ID as User name but is giving an error. Invalid user / Password. Please advice. Fri, 25 Oct 2024 07:51:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LKT1lIAH&title=Unable+to+login 2024-10-25T07:51:05Z Connectivity Issues with Denodo 8 (Design Studio) https://community.denodo.com/answers/question/details?questionId=906Qj00000LIZOEIA5&title=Connectivity+Issues+with+Denodo+8+%28Design+Studio%29 Hi everyone, I am accessing Denodo 8 (Design Studio) through the browser, and I often have to refresh the page to continue using it. It seems that somehow the browser loses connectivity with the server, but this does not happen in the Control Center. I suspect it might be related to the server or a specific configuration. Has anyone experienced this problem? Itā??s really frustrating to have to refresh the browser practically every minute. This issue occurs in Chrome, Edge, and Brave. I would appreciate any help you can provide. Thank you! Best regards, Elias Thu, 24 Oct 2024 19:27:23 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LIZOEIA5&title=Connectivity+Issues+with+Denodo+8+%28Design+Studio%29 2024-10-24T19:27:23Z Error installing Denodo 9 (Linux) https://community.denodo.com/answers/question/details?questionId=906Qj00000LIihdIAD&title=Error+installing+Denodo+9+%28Linux%29 Hi, Iā??m trying to install Denodo 9 (Solution Manager) on Linux, and Iā??m encountering the following error: ``` /opt/denodo9/denodo-install-solutionmanager-9$ ./install.sh Exception in thread "main" java.lang.UnsatisfiedLinkError: /opt/denodo9/denodo-install-solutionmanager-9/jre/lib/libawt_xawt.so: libXrender.so.1: cannot open shared object file: No such file or directory at java.base/jdk.internal.loader.NativeLibraries.load(Native Method) at java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174) at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2394) at java.base/java.lang.Runtime.load0(Runtime.java:755) at java.base/java.lang.System.load(System.java:1957) at java.base/jdk.internal.loader.NativeLibraries.load(Native Method) at java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174) at java.base/jdk.internal.loader.NativeLibraries.findFromPaths(NativeLibraries.java:315) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:285) at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2403) at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:818) at java.base/java.lang.System.loadLibrary(System.java:1993) at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1388) at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1386) at java.base/java.security.AccessController.doPrivileged(AccessController.java:318) at java.desktop/java.awt.Toolkit.loadLibraries(Toolkit.java:1385) at java.desktop/java.awt.Toolkit.initStatic(Toolkit.java:1423) at java.desktop/java.awt.Toolkit.<clinit>(Toolkit.java:1397) at java.desktop/java.awt.Component.<clinit>(Component.java:624) at com.izforge.izpack.installer.Installer.main(Unknown Source) ``` Has anyone faced this error? Any assistance would be greatly appreciated. Thank you! Best regards, Elias Thu, 24 Oct 2024 19:22:44 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LIihdIAD&title=Error+installing+Denodo+9+%28Linux%29 2024-10-24T19:22:44Z Denodo to MQ https://community.denodo.com/answers/question/details?questionId=906Qj00000LHyQHIA1&title=Denodo+to+MQ Hi could you guide me through the most effective way to connect Denodo to IBM MQ Thu, 24 Oct 2024 16:35:16 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LHyQHIA1&title=Denodo+to+MQ 2024-10-24T16:35:16Z How to find the second occurrence of a character in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000LGJllIAH&title=How+to+find+the+second+occurrence+of+a+character+in+Denodo Can someone please help me find the third occurrence of a character in Denodo? for example; '\\test\dir1\". Need to find the position of the "\" after test? Thu, 24 Oct 2024 08:09:27 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LGJllIAH&title=How+to+find+the+second+occurrence+of+a+character+in+Denodo 2024-10-24T08:09:27Z Denodo on ARM64 win10 / win11 https://community.denodo.com/answers/question/details?questionId=906Qj00000LFvczIAD&title=Denodo+on+ARM64+win10+%2F+win11 I am considering purchasing a MacBook Pro 16'' with the M3 Max chip for personal use. However, since M-series chips only support ARM versions of Windows 10/11 on VMware or UTM, I would like to know if Denodo platforms are compatible with ARM Windows 10/11. Are there any known issues or bugs? Thu, 24 Oct 2024 03:45:54 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000LFvczIAD&title=Denodo+on+ARM64+win10+%2F+win11 2024-10-24T03:45:54Z VQL Query to Cache view - is there an include all rows command https://community.denodo.com/answers/question/details?questionId=906Qj00000KuyXRIAZ&title=VQL+Query+to+Cache+view+-+is+there+an+include+all+rows+command For the VQL statement to cache view1 below, if this query is executed in a query window and the checkbox to "Retrieve all rows" is not selected, the query will cache only the number of records listed in "Limit displayed rows:" SELECT * FROM view1 CONTEXT ('cache_preload'='true', 'cache_wait_for_load'='true', 'cache_return_query_results'='false', 'cache_invalidate'='all_rows'); Is there a query parameter that I can include to override the limit set in the UI and just cache all rows, as if I had checked "Retrieve all rows" Thu, 17 Oct 2024 21:16:18 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KuyXRIAZ&title=VQL+Query+to+Cache+view+-+is+there+an+include+all+rows+command 2024-10-17T21:16:18Z Case Sensitive - strange behaviour https://community.denodo.com/answers/question/details?questionId=906Qj00000KnTa3IAF&title=Case+Sensitive+-+strange+behaviour Hi, I have two tables A & B, each from different sources. Both data sources are SQL Server 2019 I group the records from table A and join to table B, then search on forename. For some reason Denodo switches into a case sensitive mode at this point. If I remove the GROUP BY, then case sensitivity is removed. Running the same in SQL Server using Linked Servers also has no case sensitivity issue. Running individually for each table - no case sensitivity issue. It's only when both the JOIN and GROUP BY clause are added that the issue appears. Any suggestions please? Thank you. Wed, 16 Oct 2024 14:06:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000KnTa3IAF&title=Case+Sensitive+-+strange+behaviour 2024-10-16T14:06:59Z