Automic Workload Automation

Expand all | Collapse all

How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

  • 1.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 03-29-2018 11:24 AM
    Hello All,

    I've been trying to include values from a promptset (timestamp) in a VARA.SEC.SQLI object. However, the Bind parameter isn't working and I'm getting the error mentioned below:

    U00029106 UCUDB: The number of bind parameters does not match. Expected '1', actual '0'.

    Please advise..

    Thanks in advance!


  • 2.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 04-03-2018 02:16 PM
    Hi Narasimha!

    I would recommend opening a case with Support to provide us additional details. I've done some quick testing and determined we would need to look at your configuration to help troubleshoot that error message. Apologies we weren't able to provide a quicker answer via Community!


  • 3.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 04-04-2018 03:34 AM
    Hi

    there seems to be a dependence WHERE the bind parameter is placed.

    For example - working:
    select EH_NAME , EH_OTYPE, EH_STATUS , EH_STARTTIME from EH
    where EH_CLIENT = ?

    NOT working:
    select EH_NAME , ?, EH_STATUS , EH_STARTTIME from EH
    where EH_CLIENT = &$CLIENT#

    Database-error in SQLI-variable: 'U00003590 UCUDB - DB error:
    'OCIStmtExecute', 'ERROR   ', '', 'ORA-00911: invalid character''

    so which SQL select do you want to execute?

    cheers, Wolfgang


  • 4.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 04-04-2018 09:12 AM
      |   view attached
    Hello Wolfgang, Thanks for your answer. However, I have doubt with the query.
    I'm actually trying pull certain data from Automic DB with a particular time frame. I want the time frame to be dynamic. Hence, using Promptset to take the values from the user. Now, I'm trying to include the input from the promptset to VARA.SQLI or VARA.SEC.SQLI. Please refer to the screenshot.


  • 5.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 04-04-2018 09:27 AM
    Hi

    as I see from the screenshot, you should include a Key when using the curly brackets notation - usually {VARAOBJECT,KEY,[optional: column]}

    cheers, Wolfgang


  • 6.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 04-04-2018 09:34 AM
    One more finding: Field EH_IDNR des not exist in Db - its called EH_AH_IDNR :-)

    here is a working example for a VARA.SQLI object:

    select EH_NAME , EH_AH_IDNR, EH_STATUS , EH_STARTTIME, EH_HOSTdst from EH
    where eh_starttime <= to_date('&$PHYS_DATE_YYYY_MM_DD_d# &$PHYS_TIME_HH_MM_SS#','YYYY-MM-DD HH24:MI:SS')
    and EH_STATUS = 1900
    and EH_CLIENT = &$CLIENT#


    cheers, Wolfgang





  • 7.  How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

    Posted 04-04-2018 11:03 AM
    Thanks for the assistance Wolfgang! I was under the impression Narasimha was attempting to pull values directly from a promptset into the VARA.SEC.SQLI variable but I see from the screenshot the data is pulling simply from another VARA object. I'll continue to check on this thread if there is anything additional I can assist with :)