8 Replies Latest reply on Jun 12, 2015 11:30 AM by Steven Hawkins

    Error Connecting to VDB from Squirrel SQL

    Morgan Kisienya Newbie

      Hi,

       

      I am getting the error below connecting to a VDB from squirrel SQL. Kindly help....

       

      java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.lang.reflect.UndeclaredThrowableException

        at java.util.concurrent.FutureTask.report(FutureTask.java:122)

        at java.util.concurrent.FutureTask.get(FutureTask.java:202)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

        at java.util.concurrent.FutureTask.run(FutureTask.java:262)

        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)

      Caused by: java.lang.RuntimeException: java.lang.reflect.UndeclaredThrowableException

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:175)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)

        ... 5 more

      Caused by: java.lang.reflect.UndeclaredThrowableException

        at com.sun.proxy.$Proxy7.logon(Unknown Source)

        at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:180)

        at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:128)

        at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)

        at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:306)

        at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

        at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

        at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

        at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)

        at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)

        ... 7 more

      Caused by: org.teiid.client.security.TeiidSecurityException: TEIID40045 Remote org.teiid.client.security.LogonException: TEIID40045 Invalid VDB version "vdb" - must be a positive integer.

        at org.teiid.services.SessionServiceImpl.getAuthenticationType(SessionServiceImpl.java:479)

        at org.teiid.transport.LogonImpl.logon(LogonImpl.java:75)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

        at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)

        at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:207)

        at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:193)

        at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211)

        at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88)

        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)

        at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787)

        at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142)

        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)

        at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787)

        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)

        at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)

        at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)

        at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)

        at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)

        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)

        at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:555)

        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)

        at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)

        at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)

        at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:107)

        at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312)

        at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:88)

        at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)

        at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)

        at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)

        ... 3 more

      Caused by: org.teiid.client.security.TeiidSecurityException: TEIID40045 Remote org.teiid.dqp.service.SessionServiceException: TEIID40045 Invalid VDB version "vdb" - must be a positive integer.

        at org.teiid.services.SessionServiceImpl.getActiveVDB(SessionServiceImpl.java:266)

        at org.teiid.services.SessionServiceImpl.getAuthenticationType(SessionServiceImpl.java:477)

        ... 35 more

      Caused by: java.lang.NumberFormatException: Remote java.lang.NumberFormatException: For input string: "vdb"

        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

        at java.lang.Integer.parseInt(Integer.java:492)

        at java.lang.Integer.parseInt(Integer.java:527)

        at org.teiid.services.SessionServiceImpl.getActiveVDB(SessionServiceImpl.java:263)

        ... 36 more

        • 1. Re: Error Connecting to VDB from Squirrel SQL
          Steven Hawkins Master

          In the vdb.xml the version attribute has a non-positive integer value.  You will need to update that value and redeploy.

          • 2. Re: Error Connecting to VDB from Squirrel SQL
            Morgan Kisienya Newbie

            Hi Steven,

             

            Thanks for the reply.

             

            Below is my VDB.xml Which version attribute are you referring to?

             

            <?xml version="1.0" encoding="ASCII"?>

            <xmi:XMI xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:diagram="http://www.metamatrix.com/metamodels/Diagram" xmlns:mmcore="http://www.metamatrix.com/metamodels/Core" xmlns:relational="http://www.metamatrix.com/metamodels/Relational" xmlns:transformation="http://www.metamatrix.com/metamodels/Transformation">

              <mmcore:ModelAnnotation xmi:uuid="mmuuid:d8c5fbb2-1655-4f6a-80ac-6c3979150859" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational" modelType="VIRTUAL" ProducerName="Teiid Designer" ProducerVersion="8.3.3.Final-v20140613-1202-B88">

                <modelImports xmi:uuid="mmuuid:0237ee9a-43c5-482e-929c-4bf458256807" name="XMLSchema" modelLocation="http://www.w3.org/2001/XMLSchema" modelType="TYPE" primaryMetamodelUri="http://www.eclipse.org/xsd/2002/XSD"/>

                <modelImports xmi:uuid="mmuuid:48ca6317-8221-4d79-b9a3-890d21ee5aec" name="iCare_ProgNotes_ViewModel" modelLocation="../iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi" uuid="mmuuid:db6fc2e2-dec4-4b11-90a7-7ddf0e3e464b" modelType="VIRTUAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>

                <modelImports xmi:uuid="mmuuid:f4452be4-002f-4407-8d3b-f3c69ab0cc14" name="P5_Model_ltcperson" modelLocation="../P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi" uuid="mmuuid:264bc667-85c7-44a8-ae7f-3752a61808d8" modelType="PHYSICAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>

                <modelImports xmi:uuid="mmuuid:d3974b17-aee7-4273-a7c9-fa3b73e8b413" name="P5_Model_proc_prognotes" modelLocation="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi" uuid="mmuuid:35c361ac-97a5-4b36-ad51-daf87ba3b258" modelType="PHYSICAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>

                <modelImports xmi:uuid="mmuuid:252d9d6b-ce28-423b-ba62-4ded71cc93d0" name="P5_Model_ltcpersonnotes" modelLocation="../P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi" uuid="mmuuid:9ca19ed1-8573-4523-a093-90067ba0b4ef" modelType="PHYSICAL" primaryMetamodelUri="http://www.metamatrix.com/metamodels/Relational"/>

              </mmcore:ModelAnnotation>

              <diagram:DiagramContainer xmi:uuid="mmuuid:c13a9e18-2707-4a8d-a42d-f5b4080568e4">

                <diagram xmi:uuid="mmuuid:d7f89771-e230-4305-a8d1-58e7c4eb1b56" type="packageDiagramType" target="mmuuid/d8c5fbb2-1655-4f6a-80ac-6c3979150859">

                  <diagramEntity xmi:uuid="mmuuid:0aca0a89-8b4a-4794-b274-fd6f07684a5d" modelObject="mmuuid/d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0" xPosition="20" yPosition="20"/>

                </diagram>

              </diagram:DiagramContainer>

              <mmcore:AnnotationContainer xmi:uuid="mmuuid:4d550e40-a1a2-45a5-b148-4b089976faef">

                <annotations xmi:uuid="mmuuid:2bad23d9-106c-44f4-8cfa-961e16392834" annotatedObject="mmuuid/d8c5fbb2-1655-4f6a-80ac-6c3979150859">

                  <tags xmi:uuid="mmuuid:ef14e5f8-a3c0-4868-ac86-29dbc92ed2f9" key="modelExtensionDefinition:relational" value="relational"/>

                  <tags xmi:uuid="mmuuid:4f2024cf-349f-4230-afd0-9ab697ae1838" key="modelExtensionDefinition:REST" value="REST"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:17238e8d-1d17-4897-a34b-ab083c931872" annotatedObject="mmuuid/ef14e5f8-a3c0-4868-ac86-29dbc92ed2f9">

                  <tags xmi:uuid="mmuuid:e8ec70bf-7f4e-4880-8997-b15c6e2fc5ab" key="metamodel" value="http://www.metamatrix.com/metamodels/Relational"/>

                  <tags xmi:uuid="mmuuid:c7f85e63-96ef-416f-ac17-4e0b2314b0f5" key="namespacePrefix" value="relational"/>

                  <tags xmi:uuid="mmuuid:9ef95121-1128-4726-9299-942c4c2c26e0" key="namespaceUri" value="http://www.teiid.org/ext/relational/2012"/>

                  <tags xmi:uuid="mmuuid:51ffe67c-516a-4c76-b6d2-611881b18728" key="version" value="3"/>

                  <tags xmi:uuid="mmuuid:9a9eca80-0ef6-4ab2-a10d-cf76abb8f006" key="description" value="Relational metamodel extension properties"/>

                  <tags xmi:uuid="mmuuid:7a40c627-a940-445e-a38c-61297909b1f1" key="modelTypes" value=""/>

                  <tags xmi:uuid="mmuuid:d2f5756d-3cb4-44b2-8f5c-1b26ec3b9b36" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.ForeignKeyImpl" value="org.teiid.designer.metamodels.relational.impl.ForeignKeyImpl"/>

                  <tags xmi:uuid="mmuuid:d3273b3b-f591-4578-a474-d03c5ad20ec6" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.ProcedureImpl" value="org.teiid.designer.metamodels.relational.impl.ProcedureImpl"/>

                  <tags xmi:uuid="mmuuid:bcb0b9a6-b001-4b1b-921d-7fb22426afaa" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.BaseTableImpl" value="org.teiid.designer.metamodels.relational.impl.BaseTableImpl"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:9d492b15-0a63-4f9e-bc47-135f530dfd2c" annotatedObject="mmuuid/7a40c627-a940-445e-a38c-61297909b1f1">

                  <tags xmi:uuid="mmuuid:eae892b7-ab1a-42df-9ffb-fbdbe51b66f0" key="VIRTUAL" value=""/>

                  <tags xmi:uuid="mmuuid:1a84f61b-080d-4151-afa9-d2d0fa56f1a8" key="PHYSICAL" value=""/>

                </annotations>

                <annotations xmi:uuid="mmuuid:33d0762a-01fa-446b-b88e-26f755a25ab5" annotatedObject="mmuuid/d2f5756d-3cb4-44b2-8f5c-1b26ec3b9b36">

                  <tags xmi:uuid="mmuuid:2474579c-88fc-4f36-9cad-e308f0fbfc4c" key="propertyDefinition:allow-join" value="allow-join"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:63143930-4be3-443e-9fe9-e05e63ff09ca" annotatedObject="mmuuid/2474579c-88fc-4f36-9cad-e308f0fbfc4c">

                  <tags xmi:uuid="mmuuid:14941f52-d6b4-46af-a046-e62c9edc42f2" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:3cfd0aa7-1bba-4f70-a95e-7545a4d97301" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:70493fd6-3c13-46d0-8e93-b5ee603ae807" key="defaultValue" value="true"/>

                  <tags xmi:uuid="mmuuid:5f2b0a5c-f3a5-4206-976c-3c5c5ec8d502" key="id" value="allow-join"/>

                  <tags xmi:uuid="mmuuid:47d9f973-de75-460e-b711-1bf1356e691a" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:4fa8088a-f5e0-4891-800e-5f5ea94d2e6b" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:b2f9a710-5d71-44f3-9b2b-d04576bf4976" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:1a9f71ba-4af0-459e-aa83-2b280bfcbc4b" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:1f19c38c-d27e-4399-a417-51da91ef0774" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:9149363e-9fc8-44cd-b4eb-3c45eb61d0f7" annotatedObject="mmuuid/3cfd0aa7-1bba-4f70-a95e-7545a4d97301">

                  <tags xmi:uuid="mmuuid:f1797b8e-afeb-495e-8c59-3633955cece9" key="en" value="Allow Join"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:d359c04e-750c-4069-9e85-ba99d1e80650" annotatedObject="mmuuid/d3273b3b-f591-4578-a474-d03c5ad20ec6">

                  <tags xmi:uuid="mmuuid:1f5d5393-4d13-4352-b5cc-5189938d6d8c" key="propertyDefinition:deterministic" value="deterministic"/>

                  <tags xmi:uuid="mmuuid:3307a437-e948-4b38-9efe-ce97ae2726f1" key="propertyDefinition:native-query" value="native-query"/>

                  <tags xmi:uuid="mmuuid:6e10f31c-adb0-473f-a588-f3cc37d28389" key="propertyDefinition:non-prepared" value="non-prepared"/>

                  <tags xmi:uuid="mmuuid:1a293869-7d00-425c-a5ef-012240bd1f9f" key="propertyDefinition:aggregate" value="aggregate"/>

                  <tags xmi:uuid="mmuuid:d35439d0-d790-4ebd-a021-1d0446b2e962" key="propertyDefinition:analytic" value="analytic"/>

                  <tags xmi:uuid="mmuuid:84f07c7c-316d-4c75-8cde-47c424d69335" key="propertyDefinition:allows-orderby" value="allows-orderby"/>

                  <tags xmi:uuid="mmuuid:f72bc9fd-bf5c-46f4-96c4-97f3383d0d34" key="propertyDefinition:uses-distinct-rows" value="uses-distinct-rows"/>

                  <tags xmi:uuid="mmuuid:73dc1c39-f1d8-4ff4-b132-1fbe5a5d8636" key="propertyDefinition:allows-distinct" value="allows-distinct"/>

                  <tags xmi:uuid="mmuuid:eb20dd8a-ab25-46c3-a6c9-dc640e16a684" key="propertyDefinition:decomposable" value="decomposable"/>

                  <tags xmi:uuid="mmuuid:c6eb9148-8cc1-48a5-9110-cf7fb642e715" key="propertyDefinition:varargs" value="varargs"/>

                  <tags xmi:uuid="mmuuid:4605c0c3-58f7-4852-b2f9-4fcaf337c422" key="propertyDefinition:null-on-null" value="null-on-null"/>

                  <tags xmi:uuid="mmuuid:e348cee2-3198-4d1d-9b87-9b9dcc1133e2" key="propertyDefinition:function-category" value="function-category"/>

                  <tags xmi:uuid="mmuuid:21e4e8fa-42e3-4076-8f24-f4217957c3b6" key="propertyDefinition:java-class" value="java-class"/>

                  <tags xmi:uuid="mmuuid:10b41a7a-eacc-4365-b5a4-72cc335d59b9" key="propertyDefinition:java-method" value="java-method"/>

                  <tags xmi:uuid="mmuuid:f1d002b7-ecca-4271-8d5c-d2fcd17d132d" key="propertyDefinition:udfJarPath" value="udfJarPath"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:1ef0e33a-2408-4a97-9655-b08e0b90a0d2" annotatedObject="mmuuid/1f5d5393-4d13-4352-b5cc-5189938d6d8c">

                  <tags xmi:uuid="mmuuid:b639454f-5154-462e-a005-a17eeb5f09dd" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:4ae29d5d-c9fd-4495-8595-a217e2b7daa5" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:a031ea87-0f1e-45f7-ac9a-291ccb764fd4" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:e6053aed-99bb-4546-997d-a133c0fe0e38" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:a4dc6ffe-eeda-4de5-8ad0-268c919d6fee" key="id" value="deterministic"/>

                  <tags xmi:uuid="mmuuid:9dec61fc-e0bc-4e84-abd4-e3e1085faf69" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:79d97b8a-5201-4d0b-88b1-6a7927fea401" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:ce31257a-c08b-4615-87f1-8e2676d29414" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:fb025d32-693e-4e1a-b5a9-a1c111d94caa" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:86081427-cb28-4acd-b9a9-be609ccb8a47" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:dd08f074-7dc8-4eec-9182-aca3c1d4f4ee" annotatedObject="mmuuid/4ae29d5d-c9fd-4495-8595-a217e2b7daa5">

                  <tags xmi:uuid="mmuuid:117e31c9-0a64-401d-9d15-566082801123" key="en" value="Deterministic"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:b9efce6b-62be-404d-8319-5f30145fec83" annotatedObject="mmuuid/e6053aed-99bb-4546-997d-a133c0fe0e38">

                  <tags xmi:uuid="mmuuid:87ef9490-72bd-4851-9182-e125c626def4" key="en" value="Specifies that the source function will always return the same result for a specific input value"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:d8c11a83-5727-4ded-9610-95d75d019c6e" annotatedObject="mmuuid/3307a437-e948-4b38-9efe-ce97ae2726f1">

                  <tags xmi:uuid="mmuuid:2ecb0ba4-e8f1-4e08-8ceb-cc671b214038" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:34d76b9b-58f9-4cfd-b4b0-0996f3a90e05" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:02c51407-39fa-4191-b560-719ca2daff7a" key="id" value="native-query"/>

                  <tags xmi:uuid="mmuuid:24c7b0f1-5042-440e-a675-0fc421372bc8" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:b3c71e95-4260-461e-a7e3-d96ba6b41617" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:e964dbba-d219-485a-b758-e141dfea5d77" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:38507c87-33b4-4735-af0c-f09ae9e91b04" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:e3a4580d-5523-4d91-97c8-444c930589a9" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:5e34e929-ff35-4bdd-a55d-fd5cb59b22d3" annotatedObject="mmuuid/34d76b9b-58f9-4cfd-b4b0-0996f3a90e05">

                  <tags xmi:uuid="mmuuid:67e3984e-91e9-4dd3-bb4f-4ad9cea70847" key="en" value="Native Query"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:2cfea74e-c515-4afe-8087-19206b61dfc8" annotatedObject="mmuuid/6e10f31c-adb0-473f-a588-f3cc37d28389">

                  <tags xmi:uuid="mmuuid:28c1a05b-e7ec-4a0d-afc4-d9590e1d8ae1" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:c89ca2c2-f678-40de-9a3a-5739e22afe05" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:8f0e1026-36ba-494d-a7d1-68aa14afa0eb" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:e5a29588-e088-4906-9147-30db5c533b8b" key="id" value="non-prepared"/>

                  <tags xmi:uuid="mmuuid:2725f491-f756-4973-b9c5-e2585aabbaef" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:8af93117-164f-4394-ae31-2a153330ca30" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:282bdc3a-8e5f-4cbe-8bd8-b1c8793ce0dc" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:3c5ab6c2-cc3b-4b96-a145-edd410c5bef8" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:6ad4d15c-c0e1-4b53-82a1-e3ccc984a86d" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:04cab9ad-f3f1-48ac-a9df-e94d9c25cc0e" annotatedObject="mmuuid/c89ca2c2-f678-40de-9a3a-5739e22afe05">

                  <tags xmi:uuid="mmuuid:d563f522-108c-4690-95e7-eb7875e3179e" key="en" value="Non-Prepared"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:068076bb-d97f-401e-9bbd-65fd5b56be5d" annotatedObject="mmuuid/1a293869-7d00-425c-a5ef-012240bd1f9f">

                  <tags xmi:uuid="mmuuid:6dd6fcd7-3748-4bbd-84d5-3ab704ce807d" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:3c0d913d-4684-4754-a6c9-95b767d00df3" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:6b962128-3cc8-4f06-9e02-d0086bfb46ca" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:a306e928-94a6-47fa-9142-cc2251c5f7bb" key="id" value="aggregate"/>

                  <tags xmi:uuid="mmuuid:56d2d1a9-dbd8-4fbd-9ed8-3692685a037b" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:907e5360-b538-4eab-bac1-5bdfdb164e0b" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:24a48ccf-5fb4-4d25-92a4-fd5265e809e5" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:94d29e0f-c042-4f50-89cf-bf25f07a6050" key="required" value="true"/>

                  <tags xmi:uuid="mmuuid:ab063862-56bb-4c76-bf08-39ffe7866c7a" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:a944ae38-4af6-4147-bf7b-aae12446d672" annotatedObject="mmuuid/3c0d913d-4684-4754-a6c9-95b767d00df3">

                  <tags xmi:uuid="mmuuid:07600980-b375-43dc-8716-ba993c7105f5" key="en" value="Aggregate"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:1a4b4b08-1dcf-425a-a933-7b8c17d950a6" annotatedObject="mmuuid/d35439d0-d790-4ebd-a021-1d0446b2e962">

                  <tags xmi:uuid="mmuuid:719eadda-9eeb-4e2a-91a1-13fa4a019b06" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:899c89cb-1266-4882-bc94-7a26f58711ca" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:3b9cce2a-0b4b-498e-8a51-40abdf8a7dbc" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:be0366a8-4ed8-4802-8c0e-2164f5a5f95e" key="id" value="analytic"/>

                  <tags xmi:uuid="mmuuid:c405f3c8-f3d0-47b2-a224-0f961bda8b7b" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:73e9738c-09a8-4e9a-9b14-4a2b4f7a32b3" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:82cc726e-35fb-4db9-86e0-15cb85f2e043" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:d8042eff-376a-4182-b404-8c550c4f85ff" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:9976b0df-a0a4-4c65-b0e3-8731cfae2565" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:0059d25a-121a-4106-8838-ebe81e6b602f" annotatedObject="mmuuid/899c89cb-1266-4882-bc94-7a26f58711ca">

                  <tags xmi:uuid="mmuuid:b43285e3-f08c-4988-bf06-79db26c0d9e4" key="en" value="Analytic"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:e00fd73c-2165-4ad6-8845-3e19beb65cb2" annotatedObject="mmuuid/84f07c7c-316d-4c75-8cde-47c424d69335">

                  <tags xmi:uuid="mmuuid:27844456-8a1f-4b98-b262-107732f11b55" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:f49b7ec7-174b-42f3-919a-3e4f1a99efc8" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:3e96741f-0b00-4bc8-9b6d-aaf0870c348f" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:6bb94019-7c5a-4e65-99b7-f8d6490dfe80" key="id" value="allows-orderby"/>

                  <tags xmi:uuid="mmuuid:20b7fbc3-27d2-4ac0-ae3c-52bf42bfb4bb" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:274d34cf-d6c6-4349-904c-38f57e827596" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:99e18e52-0cf4-4ce9-8fe7-32ec013715cb" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:3aea1146-6dc1-4451-916e-556c2523f0e8" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:38fcb146-ba5a-421a-98b7-b232b31d0df8" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:0a1e544a-5cb0-46ef-bc9e-2fe46d651bc7" annotatedObject="mmuuid/f49b7ec7-174b-42f3-919a-3e4f1a99efc8">

                  <tags xmi:uuid="mmuuid:570c3585-136e-423f-bdd8-b8e1bfe33647" key="en" value="Allows Order-by"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:844fb866-4070-4f42-87cf-b9be3668943e" annotatedObject="mmuuid/f72bc9fd-bf5c-46f4-96c4-97f3383d0d34">

                  <tags xmi:uuid="mmuuid:f5094a02-6523-4266-86e5-0e16820e4bcf" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:05c43bbc-730b-4bbe-9501-9393ed8d43c7" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:733d495c-cb01-437d-95f2-4614a141bd18" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:ba1834c2-49b6-409b-9fff-0ec350b647b1" key="id" value="uses-distinct-rows"/>

                  <tags xmi:uuid="mmuuid:d2fe56ee-8dea-44b3-a57a-fbf175ed9d2b" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:2f66d786-239a-445d-ac7a-7a49218c2960" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:e0d0d28d-04f0-4169-a432-e0a24a1fad17" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:5fdd2c87-c810-4123-9da7-2dc4249b171c" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:10f6956f-1cb9-41fe-98c6-635f63a45c56" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:60ad3732-5c31-4730-88a4-1c1bb0b22466" annotatedObject="mmuuid/05c43bbc-730b-4bbe-9501-9393ed8d43c7">

                  <tags xmi:uuid="mmuuid:b04da4a7-18e9-4937-9c3c-70a3a266f2c0" key="en" value="Uses Distinct Rows"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:4d754f9f-2431-49b9-90c7-3ac9b6ed3fb7" annotatedObject="mmuuid/73dc1c39-f1d8-4ff4-b132-1fbe5a5d8636">

                  <tags xmi:uuid="mmuuid:3d32abf7-c4d1-4faf-954c-41731a1e5fec" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:a21d2f11-d3ca-4fd0-b6ec-2b3ab459cfe8" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:57d1603e-e131-4e93-ade9-2a48805c569f" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:c4ff8227-dfe1-4a1b-8fd9-f398bbfe3e3e" key="id" value="allows-distinct"/>

                  <tags xmi:uuid="mmuuid:45a7e8a9-6241-4554-94bf-afe9f461eae2" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:e65e5710-8618-4c54-9bf0-7b9f518fda5c" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:32eb6cc2-cef7-40e0-8357-644d00c3630d" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:b010d3e1-d468-4129-92e4-b7e4ee6e6752" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:1cda46c5-9836-4c3f-a42c-fa6a8d178e33" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:d7f07f4b-13ba-4b19-a4e3-43f82e27c625" annotatedObject="mmuuid/a21d2f11-d3ca-4fd0-b6ec-2b3ab459cfe8">

                  <tags xmi:uuid="mmuuid:112eb767-cc8b-46a7-9d0e-c9446b238e6d" key="en" value="Allows Distinct"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:6312c31f-eb2c-4f1d-be09-63dc57f29f7c" annotatedObject="mmuuid/eb20dd8a-ab25-46c3-a6c9-dc640e16a684">

                  <tags xmi:uuid="mmuuid:f327b369-e121-42a6-b822-39e9b58bc981" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:7629c9c2-f8c4-42a9-b895-b3800781a978" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:5b6c9ff0-b803-4765-af53-ee946ee84e60" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:82f2dea6-b2a3-4427-b180-39a62311f1b4" key="id" value="decomposable"/>

                  <tags xmi:uuid="mmuuid:f92b372e-a7f1-4cf6-8c82-a6f406424409" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:f6b4f63c-2df2-499e-8559-3156818bc5fc" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:0fd0af9f-2c3c-49e8-a6c6-6825a599229c" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:d3847221-a027-4c45-bd39-55bc7cff005a" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:520afd08-b969-45d7-906a-c08c0655c153" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:c6e8719f-806f-4868-b29e-c453be0cce39" annotatedObject="mmuuid/7629c9c2-f8c4-42a9-b895-b3800781a978">

                  <tags xmi:uuid="mmuuid:fe96bd2e-756e-41a1-84ab-6dcb44a5fb30" key="en" value="Decomposable"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:eb5b2a1c-1f3a-4b4f-8d92-6f1e0027b1cf" annotatedObject="mmuuid/c6eb9148-8cc1-48a5-9110-cf7fb642e715">

                  <tags xmi:uuid="mmuuid:e8b1b8cf-664f-4241-bc58-7b2f392274b9" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:57ba7488-bb53-4539-8ea3-0da5684a4f1e" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:92242145-6555-486f-9488-3f13283b1201" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:fb9060f0-5198-4182-a4b2-74b53b9e8f06" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:4df163ed-e7d5-48bf-ac4d-5b6a1af7c613" key="id" value="varargs"/>

                  <tags xmi:uuid="mmuuid:891f5279-c994-494c-a1ce-e9862623dc95" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:95744c50-89e4-4661-a8e6-d85940332149" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:d8bdd02e-a8e7-4c76-86f7-7c62cf0f9f21" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:a16acf81-e62a-460a-8b82-c3d537837841" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:470d9360-d45b-43d5-b67b-9a55e73d3e87" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:43264bea-4fb5-4a2b-bd6f-ab1da4127686" annotatedObject="mmuuid/57ba7488-bb53-4539-8ea3-0da5684a4f1e">

                  <tags xmi:uuid="mmuuid:13b4a58f-080d-4d55-bcec-b9d3efb082dc" key="en_US" value="Variable Arguments"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:881901a1-6925-4ffa-bfa1-8fee924b59b8" annotatedObject="mmuuid/fb9060f0-5198-4182-a4b2-74b53b9e8f06">

                  <tags xmi:uuid="mmuuid:9d23e5b8-1af5-434e-a457-ff2d6cf7d802" key="en_US" value="Indicates that the last arg may be repeated a variable number of times."/>

                </annotations>

                <annotations xmi:uuid="mmuuid:7061cc88-b523-4920-bde8-86ec208b2d73" annotatedObject="mmuuid/4605c0c3-58f7-4852-b2f9-4fcaf337c422">

                  <tags xmi:uuid="mmuuid:3dd32fc5-6bef-4d74-b033-40d9f0407b5e" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:cde3295e-8643-4d3c-8e0d-9423b6b44c1a" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:2adae86a-3bff-49d9-9dc8-67467dbd9b81" key="defaultValue" value="false"/>

                  <tags xmi:uuid="mmuuid:70b1861c-4353-4cf6-8b2e-087b6b24a2b6" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:5f45be9f-9eff-400f-941f-32eb10512261" key="id" value="null-on-null"/>

                  <tags xmi:uuid="mmuuid:f94c2e93-9cb7-4d11-8dce-f704333e5593" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:7ed491ee-0a88-446d-92ef-805f745da9a9" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:fea9eb87-6228-48ea-a20f-82dc67ca61f0" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:795165ea-f1c4-4135-b3c1-5da0710fb611" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:468066bb-371a-4b26-ab34-396df9dc1aab" key="runtimeType" value="boolean"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:c2c9e607-89f3-43ee-b802-8264b202de80" annotatedObject="mmuuid/cde3295e-8643-4d3c-8e0d-9423b6b44c1a">

                  <tags xmi:uuid="mmuuid:94adb86f-fdba-46d7-b3ce-527462439374" key="en_US" value="Returns null on null"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:5df2d987-2ee3-403e-a1bd-8dee07801641" annotatedObject="mmuuid/70b1861c-4353-4cf6-8b2e-087b6b24a2b6">

                  <tags xmi:uuid="mmuuid:b76cf1bf-58e1-4c3c-a888-ea8a90f5f63d" key="en_US" value="indicates that the function will return null."/>

                </annotations>

                <annotations xmi:uuid="mmuuid:2a9a8721-2f38-4078-b8df-13490d6f5536" annotatedObject="mmuuid/e348cee2-3198-4d1d-9b87-9b9dcc1133e2">

                  <tags xmi:uuid="mmuuid:6668a01b-01f6-42c4-9f0c-1210be332151" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:0e2831a0-9cf6-476e-b9a4-2dbaf57ab3c7" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:6ef70fc4-955c-40c7-96ae-97a6bff5925f" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:e237c25a-5dd2-4fc1-9848-2c8441baa7ce" key="id" value="function-category"/>

                  <tags xmi:uuid="mmuuid:ab8a04d5-375f-43b8-a68e-fe95fad71279" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:abdae0c4-21cc-499d-94c3-aeec434b03f9" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:77f4af93-4986-43b3-8817-e43b3c271be0" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:63ac5e77-7c9b-4a2b-915e-32ee2f952f2f" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:e0fe7135-d485-4337-b607-46fade564d9c" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:70b532ed-f92f-4381-b2ed-0cff241bddd9" annotatedObject="mmuuid/0e2831a0-9cf6-476e-b9a4-2dbaf57ab3c7">

                  <tags xmi:uuid="mmuuid:e85434fa-cf44-4be5-a256-251e81faff54" key="en_US" value="Function Category"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:d7e29b31-b56e-4ac1-b28b-8cf0dd6b262d" annotatedObject="mmuuid/6ef70fc4-955c-40c7-96ae-97a6bff5925f">

                  <tags xmi:uuid="mmuuid:3677cb53-1d7c-4de1-8fff-fe523172a9b6" key="en_US" value="The category for function procedures"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:5f703f6e-bb3e-492d-bfb7-4f8d80cd7e1a" annotatedObject="mmuuid/21e4e8fa-42e3-4076-8f24-f4217957c3b6">

                  <tags xmi:uuid="mmuuid:855deee6-ecdf-42a8-9abf-da62e0348d32" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:3619346a-c0bb-4cb7-af87-224658218efd" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:2e6d6e80-fb02-4fcf-ae78-f4d1d991d91f" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:1de651c3-e827-4074-9515-b2166cc31967" key="id" value="java-class"/>

                  <tags xmi:uuid="mmuuid:52477f91-07c6-46b0-b68f-98e432bd5055" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:cdedb5cd-5a8a-405a-ba87-bf9719bc58f6" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:6da00efe-8bd7-4342-9645-c48b1ceeb97b" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:83fa7247-00cb-4b8c-b840-a1a93df41161" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:37e29e1a-5bb9-4267-ad7b-be0b4675b4ec" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:eb19f8f4-1b3b-4724-94f9-4c07689d3cca" annotatedObject="mmuuid/3619346a-c0bb-4cb7-af87-224658218efd">

                  <tags xmi:uuid="mmuuid:e1f0e7f7-4188-45d6-b01d-e3a8bef5126a" key="en_US" value="Java Class"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:c8068572-4e42-4ba9-aa78-38652c53f941" annotatedObject="mmuuid/2e6d6e80-fb02-4fcf-ae78-f4d1d991d91f">

                  <tags xmi:uuid="mmuuid:bf2dec40-86de-4bb2-9687-c0b4298cd749" key="en_US" value="The java class containing the user defined function"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:fabe64bd-07ab-47af-ab41-efa0a288fddf" annotatedObject="mmuuid/10b41a7a-eacc-4365-b5a4-72cc335d59b9">

                  <tags xmi:uuid="mmuuid:c81a01ef-2e1a-4f42-9b66-6592438782bf" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:adb46905-3a30-439d-8bd9-1fa1770a5191" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:c405e984-dc30-4d6e-9c2d-d2847f75d017" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:d750ef87-b724-4a43-bdd8-c2e27640f65a" key="id" value="java-method"/>

                  <tags xmi:uuid="mmuuid:ac2d1c77-2010-4870-9e81-e0930f927be7" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:8c21070f-7b52-4dbe-a4bf-60a245c4cf28" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:f1489c42-c64c-46d8-9028-ffe851420c71" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:71e2d3ef-8a6d-40a9-af43-c59bf73dd1e2" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:287ab983-0e37-4fb4-90ec-43250b01c357" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:6c70ea56-8169-4e85-9ebf-d3af7e292cf0" annotatedObject="mmuuid/adb46905-3a30-439d-8bd9-1fa1770a5191">

                  <tags xmi:uuid="mmuuid:05b1503a-eb97-4ee1-a3f4-2cc568715351" key="en_US" value="Java Method"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:92c2484b-f9a6-4f3e-87cf-9d90704d1059" annotatedObject="mmuuid/c405e984-dc30-4d6e-9c2d-d2847f75d017">

                  <tags xmi:uuid="mmuuid:074aa5d2-97d6-44b1-a39c-f96ab0c2166b" key="en_US" value="The java method defining the user defined function"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:83a3f22e-7388-4b44-a80e-c30a6d9c6eec" annotatedObject="mmuuid/f1d002b7-ecca-4271-8d5c-d2fcd17d132d">

                  <tags xmi:uuid="mmuuid:d8b8a0bf-572f-46ea-b7fc-49ad99709dc0" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:7c5d66fc-2d9d-4d17-a084-4f895d171a2c" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:21e1cccf-3dc9-473a-affa-58e39b3ab56f" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:affd1082-64c7-4925-bc7d-3c70cb7c51a7" key="id" value="udfJarPath"/>

                  <tags xmi:uuid="mmuuid:aecdac08-44b2-4fcb-97c5-df099c65b69d" key="index" value="false"/>

                  <tags xmi:uuid="mmuuid:f748eee8-3d34-4a8a-8cba-6340a70cb51f" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:8a9aee81-426c-4c32-bd24-aedb988bbc0f" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:d81f8b25-f685-4d77-9092-c1560af7c99c" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:cead48da-7436-49c4-b426-484a1a3d2744" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:61703543-d53b-405c-9657-ea14c62d6033" annotatedObject="mmuuid/7c5d66fc-2d9d-4d17-a084-4f895d171a2c">

                  <tags xmi:uuid="mmuuid:de629946-1b9f-40f3-ab37-dd7ff8c925c5" key="en" value="UDF Jar Path"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:63888f4e-245c-4ed9-bfe3-9ecac555cb83" annotatedObject="mmuuid/21e1cccf-3dc9-473a-affa-58e39b3ab56f">

                  <tags xmi:uuid="mmuuid:8e7aac01-4c83-4523-8de9-ad8d25577b71" key="en_US" value="The project-relative path where the UDF jar is located"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:f892910e-1357-44ea-984a-3484b95e8421" annotatedObject="mmuuid/bcb0b9a6-b001-4b1b-921d-7fb22426afaa">

                  <tags xmi:uuid="mmuuid:49e431ba-65b5-4636-88b6-a8ad4ecfbc6a" key="propertyDefinition:native-query" value="native-query"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:6d0e17c4-955f-4249-a6f8-f086b45ae261" annotatedObject="mmuuid/49e431ba-65b5-4636-88b6-a8ad4ecfbc6a">

                  <tags xmi:uuid="mmuuid:4b994465-285c-419d-bb03-83276e20b5e8" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:1be3a3c5-85e8-404b-b319-b23965442ea0" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:8b2b1ec2-0553-488a-9f9d-710e39b124ed" key="id" value="native-query"/>

                  <tags xmi:uuid="mmuuid:51844811-82ab-4237-9470-4c12acdd729b" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:f77897f1-4661-4748-9d7f-cc65d8f2db33" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:9e3fa054-d002-4b25-8ef4-340eb9cc3de0" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:95be8ac8-9f0a-4209-bb23-c50e6853ab3e" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:3958a5d9-41c5-483c-a66d-e770796232aa" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:a690bb8b-ba85-4046-9da4-cd8efd4441e3" annotatedObject="mmuuid/1be3a3c5-85e8-404b-b319-b23965442ea0">

                  <tags xmi:uuid="mmuuid:77244d44-4f3c-497c-937f-5e9e0225d523" key="en" value="Native Query"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:7967d0b1-7b1f-4f76-9e07-4334f119d780" annotatedObject="mmuuid/4f2024cf-349f-4230-afd0-9ab697ae1838">

                  <tags xmi:uuid="mmuuid:24e65ec7-6cea-454f-9c14-225ad85734df" key="metamodel" value="http://www.metamatrix.com/metamodels/Relational"/>

                  <tags xmi:uuid="mmuuid:95cb9203-8c9e-4add-860a-6efd91b7e4fc" key="namespacePrefix" value="REST"/>

                  <tags xmi:uuid="mmuuid:d06a82a9-f94e-4485-9f2b-f389173bf40f" key="namespaceUri" value="http://teiid.org/rest"/>

                  <tags xmi:uuid="mmuuid:47766fff-55ba-4996-b901-9e88bba34ea8" key="version" value="1"/>

                  <tags xmi:uuid="mmuuid:23eeb307-188d-4607-8a8d-3ceaa0bd9708" key="description" value="REST extended virtual procedure properties"/>

                  <tags xmi:uuid="mmuuid:7959e5a2-430f-44f9-be02-de11a407a6a0" key="modelTypes" value=""/>

                  <tags xmi:uuid="mmuuid:1a9201dd-1bb6-4540-9412-14ae74152853" key="extendedMetaclass:org.teiid.designer.metamodels.relational.impl.ProcedureImpl" value="org.teiid.designer.metamodels.relational.impl.ProcedureImpl"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:7ecf7df8-44f8-4760-9bbf-bba077656277" annotatedObject="mmuuid/7959e5a2-430f-44f9-be02-de11a407a6a0">

                  <tags xmi:uuid="mmuuid:84510432-2131-4582-96d4-cb4b395f54c2" key="VIRTUAL" value=""/>

                </annotations>

                <annotations xmi:uuid="mmuuid:071de3a2-f36e-414c-b222-a39a8f7b82c3" annotatedObject="mmuuid/1a9201dd-1bb6-4540-9412-14ae74152853">

                  <tags xmi:uuid="mmuuid:6165de55-3b1a-4c67-b0f5-177ccb79bb3b" key="propertyDefinition:charset" value="charset"/>

                  <tags xmi:uuid="mmuuid:f04cf263-11f2-4bad-821d-12ab376ee8c9" key="propertyDefinition:headers" value="headers"/>

                  <tags xmi:uuid="mmuuid:2d3e8587-22b3-4eff-9024-54ad0e20af85" key="propertyDefinition:METHOD" value="METHOD"/>

                  <tags xmi:uuid="mmuuid:4e94c7b7-888c-4c6d-817a-dfc4144d410a" key="propertyDefinition:URI" value="URI"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:bc9b0c33-596e-47d0-bbfa-c0b392be5cd3" annotatedObject="mmuuid/6165de55-3b1a-4c67-b0f5-177ccb79bb3b">

                  <tags xmi:uuid="mmuuid:12591df9-b374-49db-a6df-bf734a28b8ef" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:33a73d2c-3cc6-4058-a739-b1580b294a6d" key="allowedValues" value=""/>

                  <tags xmi:uuid="mmuuid:5f010cbf-d57c-472d-9e5f-e82a8ad01f5d" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:66b42ccc-f17a-4ef0-93e7-a70ed5101ae2" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:fe8f9418-3440-4022-890a-e44c5e38d10e" key="id" value="charset"/>

                  <tags xmi:uuid="mmuuid:aeacf490-399f-4a8f-8940-6cccf00a6588" key="index" value="false"/>

                  <tags xmi:uuid="mmuuid:2ac788de-c50e-4ce4-a242-8b044badd33e" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:cb86a017-f659-4127-9dd5-ce7a53e55061" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:9380d2cd-a2ed-458e-8883-3d3a7492a46a" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:b2db0222-529b-4897-90cd-59e650a2db99" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:88aeacff-6b90-4244-bf9f-00305a40bb54" annotatedObject="mmuuid/33a73d2c-3cc6-4058-a739-b1580b294a6d">

                  <tags xmi:uuid="mmuuid:dd495116-ad34-41f2-8426-2153be3e7519" key="UTF-8" value=""/>

                  <tags xmi:uuid="mmuuid:7e5cc02d-2472-42ce-b806-b3c20b235c66" key="US-ASCII" value=""/>

                </annotations>

                <annotations xmi:uuid="mmuuid:708b6879-6c09-48da-ab94-02e04b348f2c" annotatedObject="mmuuid/5f010cbf-d57c-472d-9e5f-e82a8ad01f5d">

                  <tags xmi:uuid="mmuuid:0a429cc4-3551-4f3f-8402-bf98cf3a3d41" key="en_US" value="CHARSET"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:069ecdb0-3870-4489-bfb4-b009920dff93" annotatedObject="mmuuid/66b42ccc-f17a-4ef0-93e7-a70ed5101ae2">

                  <tags xmi:uuid="mmuuid:82b8a7d1-ff3a-4d94-8efc-b9aff6fd1b61" key="en_US" value="Optional property for procedures that return a Blob with content type that is text-based. This character set to used to convert the data. "/>

                </annotations>

                <annotations xmi:uuid="mmuuid:e9711b98-7add-4781-98a6-d189d7986de8" annotatedObject="mmuuid/f04cf263-11f2-4bad-821d-12ab376ee8c9">

                  <tags xmi:uuid="mmuuid:3127cc68-1865-4dd4-b75e-74e235b02520" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:2f9c42b5-78a5-429f-82f9-c70a8b422afb" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:27a034fc-e62b-4f37-a8c5-ab6e0a9af35f" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:9ea62a56-74f6-46b4-b462-f97cef774b75" key="id" value="headers"/>

                  <tags xmi:uuid="mmuuid:30c4e030-91dc-48e8-9200-5af4a8318dfe" key="index" value="false"/>

                  <tags xmi:uuid="mmuuid:b971b837-d052-4567-869b-aa457ae8a28d" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:2f9235e0-707f-4b88-a954-ea58ae4f6571" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:bbae62a5-e44c-4197-9a68-31f1b23e1e93" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:87bcdddf-ff2a-4047-9876-249e59f1517f" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:d9a469e9-58ab-4085-aa79-2577b31a4e72" annotatedObject="mmuuid/2f9c42b5-78a5-429f-82f9-c70a8b422afb">

                  <tags xmi:uuid="mmuuid:949c160a-0bab-4715-9dcb-f1c80f53af92" key="en_US" value="HEADERS"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:dca35678-24d4-47ff-8d98-bcd7468c37eb" annotatedObject="mmuuid/27a034fc-e62b-4f37-a8c5-ab6e0a9af35f">

                  <tags xmi:uuid="mmuuid:5dbe4152-1afe-4dd8-969d-858b67768634" key="en_US" value="Semi-colon delimited list of HTTP Header parameters to pass into the REST service operation. Ex. header1;header2;etc. These value will be passed into the procedure first."/>

                </annotations>

                <annotations xmi:uuid="mmuuid:8dd701f5-6389-41ff-b100-8c3e4aad2574" annotatedObject="mmuuid/2d3e8587-22b3-4eff-9024-54ad0e20af85">

                  <tags xmi:uuid="mmuuid:4ea8ef0d-112c-484b-b103-14f285c99a1f" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:3419c1cd-eedb-47d1-a29d-8749451d3b41" key="allowedValues" value=""/>

                  <tags xmi:uuid="mmuuid:2ef20d81-2b62-4833-8601-57150c6e2d65" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:41875af3-e456-4900-81d5-5177e2d44a1f" key="defaultValue" value=" "/>

                  <tags xmi:uuid="mmuuid:2e54a763-40f5-404e-9b79-a1d0b2d85b95" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:97d52e02-dcdb-45bd-84c3-ea44213c592f" key="id" value="METHOD"/>

                  <tags xmi:uuid="mmuuid:88802c28-3b54-40c6-a339-526c786c67a2" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:9fff653b-c8ab-4519-bf00-d685bfc07c4d" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:288e3e08-40f7-42d5-adfa-d8a2161420b8" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:b0b52a83-927e-4c52-988a-8072bc13576c" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:cef3ffab-ca83-46b4-b028-84e06d6a8235" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:74c532c9-92e7-4193-affc-ca24ec426f92" annotatedObject="mmuuid/3419c1cd-eedb-47d1-a29d-8749451d3b41">

                  <tags xmi:uuid="mmuuid:afd7410b-a8f9-4e52-a0e8-7f2ef410db36" key="POST" value=""/>

                  <tags xmi:uuid="mmuuid:f3368dd6-ffbd-4bad-8aae-03a49396fba6" key=" " value=""/>

                  <tags xmi:uuid="mmuuid:1f04990e-96f1-4480-9f71-aa2053a32e0b" key="GET" value=""/>

                  <tags xmi:uuid="mmuuid:b208ee48-a870-4030-99b7-405b4d9e297a" key="DELETE" value=""/>

                  <tags xmi:uuid="mmuuid:04e21866-27d1-4dce-97c8-1752397765e0" key="PUT" value=""/>

                </annotations>

                <annotations xmi:uuid="mmuuid:644fed81-7224-4254-b1af-c493a5a9ef30" annotatedObject="mmuuid/2ef20d81-2b62-4833-8601-57150c6e2d65">

                  <tags xmi:uuid="mmuuid:6b921702-262d-488f-a77b-038c6faa9c3f" key="en_US" value="Rest Method"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:d777e494-3b10-4a83-a666-7dd97efb187c" annotatedObject="mmuuid/2e54a763-40f5-404e-9b79-a1d0b2d85b95">

                  <tags xmi:uuid="mmuuid:587d9b18-5c05-4bf0-a11d-dad78ddc3a25" key="en_US" value="The REST method to map this procedure to. Supported methods are&#xa;&#x9;&#x9;&#x9;&#x9;GET/PUT/POST/DELETE."/>

                </annotations>

                <annotations xmi:uuid="mmuuid:b7f3a9e7-cd2e-44d4-ba47-adbc2550548a" annotatedObject="mmuuid/4e94c7b7-888c-4c6d-817a-dfc4144d410a">

                  <tags xmi:uuid="mmuuid:4d64796a-7fc0-46a1-b6f8-e77d31012a26" key="advanced" value="false"/>

                  <tags xmi:uuid="mmuuid:b8ef1ddd-2795-4211-82bf-a9e1f36ca4e6" key="displayName" value=""/>

                  <tags xmi:uuid="mmuuid:c7a1d185-1322-41d8-b0c8-2efea8e66a2f" key="description" value=""/>

                  <tags xmi:uuid="mmuuid:890955fc-e3d5-431b-a17a-b609e13b4a88" key="id" value="URI"/>

                  <tags xmi:uuid="mmuuid:3a1bc563-cf68-4e04-84ea-1c053f90c544" key="index" value="true"/>

                  <tags xmi:uuid="mmuuid:85c55ae1-bceb-449e-ac82-242ffbba9157" key="modifiable" value="true"/>

                  <tags xmi:uuid="mmuuid:0b677681-e366-401c-b044-08d7eeb33f28" key="masked" value="false"/>

                  <tags xmi:uuid="mmuuid:5690ac0e-9dbd-4a61-b2ae-cbef400370bc" key="required" value="false"/>

                  <tags xmi:uuid="mmuuid:5f1f54ea-adf2-4657-a8d3-36eb06d461cd" key="runtimeType" value="string"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:4d6a52b6-0f82-41c3-8894-fa51c90a76b8" annotatedObject="mmuuid/b8ef1ddd-2795-4211-82bf-a9e1f36ca4e6">

                  <tags xmi:uuid="mmuuid:8ba4ca1e-0b54-4733-8cef-52f5da6a1ac7" key="en_US" value="URI"/>

                </annotations>

                <annotations xmi:uuid="mmuuid:9f3198d2-a96a-4a2b-a6f2-ab4c1463a3eb" annotatedObject="mmuuid/c7a1d185-1322-41d8-b0c8-2efea8e66a2f">

                  <tags xmi:uuid="mmuuid:4f6fb91b-ac14-4dda-82af-1a423d473382" key="en_US" value="The relative URI to map this procedure to."/>

                </annotations>

              </mmcore:AnnotationContainer>

              <relational:Procedure xmi:uuid="mmuuid:d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0" name="iCare_P5_ProgNt_Proc">

                <parameters xmi:uuid="mmuuid:f411bf30-06e1-450f-aa85-0b74289ea490" name="ProcProgNoteID" direction="OUT" length="4000" nullable="NULLABLE" radix="0">

                  <type href="http://www.w3.org/2001/XMLSchema#int"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:a319ea77-59c9-4138-b93e-52ea62021af9" name="UserID_by" direction="OUT" length="4000" nullable="NULLABLE" radix="0">

                  <type href="http://www.w3.org/2001/XMLSchema#string"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:cf5f7760-5912-4a9a-98ec-a2261a3a7aab" name="notetext" direction="OUT" length="90000" nullable="NULLABLE" radix="0">

                  <type href="http://www.w3.org/2001/XMLSchema#string"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:7eeae5ce-31c3-4c72-ac88-dfb7abf63a96" name="datecreated" direction="OUT" length="4000" nullable="NULLABLE" radix="0">

                  <type href="http://www.w3.org/2001/XMLSchema#string"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:496c4612-72df-415f-84a6-076960fe5e0b" name="admittedto" direction="OUT" length="4000" nullable="NULLABLE" radix="0">

                  <type href="http://www.w3.org/2001/XMLSchema#string"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:7e46adb9-6ba8-4ac1-98a7-b1ec59720213" name="issystem" direction="OUT" nullable="NULLABLE">

                  <type href="http://www.w3.org/2001/XMLSchema#boolean"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:9bd4cd57-2d0b-4a16-9bbe-e47b280c71be" name="NoteID" direction="OUT" nullable="NULLABLE">

                  <type href="http://www.w3.org/2001/XMLSchema#int"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:296928ca-1919-4ec3-9779-a5ac84bf121b" name="CategoryID" direction="OUT" nullable="NULLABLE">

                  <type href="http://www.w3.org/2001/XMLSchema#int"/>

                </parameters>

                <parameters xmi:uuid="mmuuid:e56dd34f-2b3e-41df-a304-be6afeac3124" name="ReasonDel" direction="OUT" nullable="NULLABLE">

                  <type href="http://www.w3.org/2001/XMLSchema#string"/>

                </parameters>

              </relational:Procedure>

              <transformation:TransformationContainer xmi:uuid="mmuuid:dad243f6-0f9e-40ff-a7c1-cf16c5cf6d20">

                <transformationMappings xsi:type="transformation:SqlTransformationMappingRoot" xmi:uuid="mmuuid:f3350416-9d81-49a8-8c2a-c32180dce039" outputs="mmuuid/d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0" target="mmuuid/d3a847c2-36d6-4d8f-82ed-2a49ec5b50a0">

                  <helper xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:09e3a56e-9b4b-4358-9638-729b8ce0e48f">

                    <nested xsi:type="transformation:SqlTransformation" xmi:uuid="mmuuid:aa665159-3a41-40e2-8182-c2facd18668f" selectSql="CREATE VIRTUAL PROCEDURE&#xa;BEGIN&#xa;&#x9;LOOP ON (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl) AS @ProgNoteID&#xa;&#x9;BEGIN&#xa;&#x9;&#x9;IF(@ProgNoteID.ProgNoteID > 0)&#xa;&#x9;&#x9;BEGIN&#xa;&#x9;&#x9;&#x9;DECLARE string VARIABLES.@Namefirst = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.NameFirst FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);&#xa;&#x9;&#x9;&#x9;DECLARE string VARIABLES.@NameLast = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.NameLast FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);&#xa;&#x9;&#x9;&#x9;DECLARE string VARIABLES.@MedicareNumber = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.MedicareNumber FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);&#xa;&#x9;&#x9;&#x9;DECLARE string VARIABLES.@ReasonDeleted = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ReasonDeleted FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);&#xa;&#x9;&#x9;&#x9;DECLARE integer VARIABLES.@ltcPersonID = (SELECT P5_Model_ltcperson.ltcperson.ltcPersonID FROM P5_Model_ltcperson.ltcperson WHERE (P5_Model_ltcperson.ltcperson.FirstName = VARIABLES.@Namefirst) AND ((P5_Model_ltcperson.ltcperson.LastName = VARIABLES.@NameLast) AND (P5_Model_ltcperson.ltcperson.medicarenumber = VARIABLES.@MedicareNumber)));&#xa;&#x9;&#x9;&#x9;iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.ProcProgNoteID = VARIABLES.@ltcPersonID;&#xa;&#x9;&#x9;&#x9;iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.ReasonDel = VARIABLES.@ReasonDeleted;&#xa;&#x9;&#x9;&#x9;iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.notetext = (SELECT iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.Note FROM iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl WHERE iCare_ProgNotes_ViewModel.iCare_ProgNotes_Tbl.ProgNoteID = @ProgNoteID.ProgNoteID);&#xa;&#x9;&#x9;&#x9;DECLARE string VARIABLES.@Notetext = iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.notetext;&#xa;&#x9;&#x9;&#x9;DECLARE integer VARIABLES.@userid = 1;&#xa;&#x9;&#x9;&#x9;DECLARE integer VARIABLES.@categoryid = 50;&#xa;&#x9;&#x9;&#x9;DECLARE integer VARIABLES.@notestatusid = 1;&#xa;&#x9;&#x9;&#x9;IF((VARIABLES.@ltcPersonID IS NOT NULL) AND (VARIABLES.@ReasonDeleted IS NULL) AND (VARIABLES.@Notetext IS NOT NULL))&#xa;&#x9;&#x9;&#x9;BEGIN&#xa;&#x9;&#x9;&#x9;&#x9;EXEC P5_Model_proc_prognotes.proc_progressnotes_create(VARIABLES.@ltcPersonID, VARIABLES.@userid, VARIABLES.@categoryid, VARIABLES.@notestatusid, VARIABLES.@Notetext);&#xa;&#x9;&#x9;&#x9;END&#xa;&#x9;&#x9;&#x9;ELSE&#xa;&#x9;&#x9;&#x9;BEGIN&#xa;&#x9;&#x9;&#x9;&#x9;IF((VARIABLES.@ltcPersonID IS NOT NULL) AND (VARIABLES.@ReasonDeleted IS NOT NULL) AND (VARIABLES.@Notetext IS NOT NULL))&#xa;&#x9;&#x9;&#x9;&#x9;BEGIN&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;EXEC P5_Model_proc_prognotes.proc_progressnotes_create(VARIABLES.@ltcPersonID, VARIABLES.@userid, VARIABLES.@categoryid, VARIABLES.@notestatusid, VARIABLES.@Notetext);&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.NoteID = (SELECT MAX(P5_Model_ltcpersonnotes.ltcpersonnotes.NoteID) FROM ltcpersonnotes);&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;DECLARE integer VARIABLES.@NoteID = iCare_P5_ProgNt_Union_Model.iCare_P5_ProgNt_Proc.NoteID;&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;EXEC P5_Model_proc_prognotes.proc_progressnotes_markaserror(VARIABLES.@NoteID, VARIABLES.@userid, VARIABLES.@ReasonDeleted);&#xa;&#x9;&#x9;&#x9;&#x9;END&#xa;&#x9;&#x9;&#x9;&#x9;ELSE&#xa;&#x9;&#x9;&#x9;&#x9;BEGIN&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;RAISE SQLWARNING SQLEXCEPTION 'Patient names returned NULL or INVALID ProgNoteID';&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;RAISE SQLWARNING SQLEXCEPTION VARIABLES.@Namefirst;&#xa;&#x9;&#x9;&#x9;&#x9;&#x9;RAISE SQLWARNING SQLEXCEPTION VARIABLES.@NameLast;&#xa;&#x9;&#x9;&#x9;&#x9;END&#xa;&#x9;&#x9;&#x9;END&#xa;&#x9;&#x9;END&#xa;&#x9;END&#xa;END"/>

                    <aliases xmi:uuid="mmuuid:37eaf2a6-0c69-41ac-8b5e-d734058fe5f6" alias="proc_progressnotes_markaserror">

                      <aliasedObject href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/02bb2f8a-0957-46c4-9277-33a2c531acdd"/>

                    </aliases>

                    <aliases xmi:uuid="mmuuid:ab8a3e84-15c0-4f6a-ab6e-481f0388af98" alias="ltcperson">

                      <aliasedObject href="../P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi#mmuuid/407ffa5e-87a0-424c-a8ba-021fb22b8e87"/>

                    </aliases>

                    <aliases xmi:uuid="mmuuid:43b50b6c-acd2-4a28-98e8-e3218268138d" alias="iCare_ProgNotes_Tbl">

                      <aliasedObject href="../iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi#mmuuid/2bebcebc-bff9-4b6e-b49b-9bb8f66582e7"/>

                    </aliases>

                    <aliases xmi:uuid="mmuuid:af8e8fd5-b3d3-43e5-adf0-3babcc172fdb" alias="proc_progressnotes_create">

                      <aliasedObject href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/6b7dc0d5-b90f-49e0-b883-ecfa89467af7"/>

                    </aliases>

                    <aliases xmi:uuid="mmuuid:dd1a7f94-a06a-47d7-bbf9-9b08eb4edddb" alias="ltcpersonnotes">

                      <aliasedObject href="../P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi#mmuuid/166548af-07e4-4773-8bd6-2b75220e66d4"/>

                    </aliases>

                  </helper>

                  <inputs href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/02bb2f8a-0957-46c4-9277-33a2c531acdd"/>

                  <inputs href="../P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi#mmuuid/407ffa5e-87a0-424c-a8ba-021fb22b8e87"/>

                  <inputs href="../iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi#mmuuid/2bebcebc-bff9-4b6e-b49b-9bb8f66582e7"/>

                  <inputs href="../P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi#mmuuid/6b7dc0d5-b90f-49e0-b883-ecfa89467af7"/>

                  <inputs href="../P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi#mmuuid/166548af-07e4-4773-8bd6-2b75220e66d4"/>

                </transformationMappings>

              </transformation:TransformationContainer>

            </xmi:XMI>

            • 3. Re: Error Connecting to VDB from Squirrel SQL
              Steven Hawkins Master

              That is a designer .xmi file defining a model.  It is not a deployment artifact for Teiid.  The vdb will either be a zip file containing a vdb.xml file or just the vdb xml file.  The vdb.xml will look like VDB Definition - Teiid 8.11 (draft) - Project Documentation Editor

              • 4. Re: Error Connecting to VDB from Squirrel SQL
                Ramesh Reddy Master

                What is JDBC URL you are connecting with? Make sure it is in the form "jdbc:teiid:<vdbname>@mm://<host>:31000"

                 

                BTW, the above is Designer model file, however your open the VDB file, you will find a vdb.xml file under META-INF directory, that is what Steve is asking for, and that has a invalid version identifier.

                • 5. Re: Error Connecting to VDB from Squirrel SQL
                  Morgan Kisienya Newbie

                  Much appreciated Ramesh and Steven

                   

                  I have gotten the xml file.

                   

                  Hope I am not wrong but, the version attribute is already a "positive integer" i.e. 1

                   

                  <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

                  <vdb name="iCare_P5_ProgNt_Union_VDB" version="1">

                      <property name="preview" value="false"/>

                      <property name="validationDateTime" value="Wed Jun 10 17:59:56 EAT 2015"/>

                      <property name="validationVersion" value="8.8.0.Final"/>

                      <model name="iCare_Patient_ViewModel" type="VIRTUAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/Resident_Tbl/iCare_Patient_ViewModel.xmi">

                          <property name="checksum" value="1078596014"/>

                          <property name="indexName" value="4270417440.INDEX"/>

                          <property name="modelUuid" value="mmuuid:86abdf5a-e4fd-4c84-a115-415a8401a679"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/Resident_Tbl/iCare_Patient_SourceModel.xmi"/>

                      </model>

                      <model name="P5_Model_ltcpersonnotes" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi">

                          <property name="checksum" value="2593838484"/>

                          <property name="indexName" value="1049864068.INDEX"/>

                          <property name="modelUuid" value="mmuuid:04ffeb86-4fad-4bf1-95ec-1b62c0de53b8"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="P5_Model_ltcpersonnotes" connection-jndi-name="P5_Model_ltcpersonnotes" translator-name="mysql5"/>

                      </model>

                      <model name="P5_Model_proc_prognotes" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi">

                          <property name="checksum" value="560480586"/>

                          <property name="indexName" value="736009277.INDEX"/>

                          <property name="modelUuid" value="mmuuid:0d4062a2-fe6b-4abe-854b-056c0cb3b4cf"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="P5_Model_proc_prognotes" connection-jndi-name="P5_Model_proc_prognotes" translator-name="mysql5"/>

                      </model>

                      <model name="P5_Model_ltcperson" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi">

                          <property name="checksum" value="2795991440"/>

                          <property name="indexName" value="3795768331.INDEX"/>

                          <property name="modelUuid" value="mmuuid:b296e55f-2fcd-40b7-91dc-4b17ecdb205b"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="P5_Model_ltcperson" connection-jndi-name="P5_Model_ltcperson" translator-name="mysql5"/>

                      </model>

                      <model name="iCare_Patient_SourceModel" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/Resident_Tbl/iCare_Patient_SourceModel.xmi">

                          <property name="checksum" value="1085949161"/>

                          <property name="indexName" value="1430708344.INDEX"/>

                          <property name="modelUuid" value="mmuuid:42180519-48a9-4d95-bbd4-a6ad7a9dfe81"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="iCare_Patient_SourceModel" connection-jndi-name="iCare_Patient_SourceModel" translator-name="file"/>

                      </model>

                      <model name="iCare_P5_PNote_Add_SourceModel" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotesAdded/iCare_P5_PNote_Add_SourceModel.xmi">

                          <property name="checksum" value="3110200720"/>

                          <property name="indexName" value="1783072911.INDEX"/>

                          <property name="modelUuid" value="mmuuid:85080096-665b-4fb8-b231-7d255d873796"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="iCare_P5_PNote_Add_SourceModel" connection-jndi-name="iCare_P5_PNote_Add_SourceModel" translator-name="file"/>

                      </model>

                      <model name="iCare_P5_PNote_Add_ViewModel" type="VIRTUAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotesAdded/iCare_P5_PNote_Add_ViewModel.xmi">

                          <property name="checksum" value="1251528267"/>

                          <property name="indexName" value="2602432476.INDEX"/>

                          <property name="modelUuid" value="mmuuid:05bd1397-58f7-47e7-ba3f-3dd18c18c863"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotesAdded/iCare_P5_PNote_Add_SourceModel.xmi"/>

                      </model>

                      <model name="P5_Model_proc_resident" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_resident.xmi">

                          <property name="checksum" value="1795204923"/>

                          <property name="indexName" value="3364272145.INDEX"/>

                          <property name="modelUuid" value="mmuuid:d78b784f-76d6-48ea-b068-98927e8aa64c"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="P5_Model_proc_resident" connection-jndi-name="P5_Model_proc_resident" translator-name="mysql5"/>

                      </model>

                      <model name="iCare_ProgNotes_SourceModel" type="PHYSICAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_SourceModel.xmi">

                          <property name="checksum" value="657344748"/>

                          <property name="indexName" value="34421922.INDEX"/>

                          <property name="modelUuid" value="mmuuid:2e95eecc-68b3-4dd6-b8a2-4961d4369b48"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <source name="iCare_ProgNotes_SourceModel" connection-jndi-name="iCare_ProgNotes_SourceModel" translator-name="file"/>

                      </model>

                      <model name="iCare_ProgNotes_ViewModel" type="VIRTUAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi">

                          <property name="checksum" value="4091287046"/>

                          <property name="indexName" value="1309781463.INDEX"/>

                          <property name="modelUuid" value="mmuuid:d58d6956-7f40-432d-9f83-96bc3b3ea71a"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_SourceModel.xmi"/>

                      </model>

                      <model name="iCare_P5_ProgNt_Union_Model" type="VIRTUAL" visible="true" path="/iCare_P5_IMPORTS_PROGNOTES_v1/UNION_MODEL/iCare_P5_ProgNt_Union_Model.xmi">

                          <property name="checksum" value="3465254135"/>

                          <property name="indexName" value="2050428938.INDEX"/>

                          <property name="modelUuid" value="mmuuid:d8c5fbb2-1655-4f6a-80ac-6c3979150859"/>

                          <property name="modelClass" value="Relational"/>

                          <property name="builtIn" value="false"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_PROCEDURES/P5_Model_proc_prognotes.xmi"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_TABLES/P5_ltcperson/P5_Model_ltcperson.xmi"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_ViewModel.xmi"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/iCare_IMPORTS/ProgressNotes/iCare_ProgNotes_SourceModel.xmi"/>

                          <property name="imports" value="/iCare_P5_IMPORTS_PROGNOTES_v1/P5_IMPORTS/P5_TABLES/P5_ltcpersonnotes/P5_Model_ltcpersonnotes.xmi"/>

                      </model>

                  </vdb>

                  • 6. Re: Error Connecting to VDB from Squirrel SQL
                    Ramesh Reddy Master

                    The JDBC URL you are using in the SQuirreL?

                    • 7. Re: Error Connecting to VDB from Squirrel SQL
                      Morgan Kisienya Newbie

                      I am using

                      jdbc:teiid:iCare_P5_ProgNt_Union_VDB@mm://localhost:31000

                      • 8. Re: Error Connecting to VDB from Squirrel SQL
                        Steven Hawkins Master

                        Do you have squirrel setting properties for the connection?  As it does appear this exception should only happen if the client passes in a version value using either the version or the VirtualDatabaseVersion properties.