Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escape special characters +-&|!(){}[]^"~*?:\ - e.g. \+ \* \!
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
 
Answered
Loan-Payments example not working

Hi,

I'm trying to get the Loan-Payments example extension working in my sandbox. I'm getting the following error when attempting to load it in the dashboard.

q2_sdk.hq.exceptions.MissingStoredProcError: Stored Procedure wdg_LoanPaymentProductIdToPaymentType_Get not installed in the database

Is that stored procedure something specific to that extension that didn't get installed or is that something that's part of Q2 by default?

0
Posted 4 years ago
pic
⠿More
David Maksimov
54 × 3
Report
Votes Newest

Answers 2

That example extension unfortunately will not run out of the box. The stored procedure in question is basically used to get configurations for different product types. So you can implement a config via the self.wedge_address_configs property.

Feel free to submit a Support ticket on the developer portal and we can help you get up and running.

0
Posted 4 years ago
pic
⠿More
Mark Ostroth
309 × 5 Administrator
Report

It appears that the dbplan did not get run. It is possible that it is either not picking up everything quite correctly, or you just need to run q2 run_db_plan.

0
Posted 4 years ago
pic
⠿More
Trey Teter
124 × 2 Administrator
0

I tried running q2 run_db_plan but I'm still getting the same error.

— David Maksimov   4 years ago
0

Are you getting an error when you run q2 run_db_plan. I have been trying to figure out what exactly you are doing wrong.

— Trey Teter   4 years ago
0

Everything is fine when I run q2 run_db_plan and go through all the setup. The error shows up when I run q2 run and try to load the extension in the sandbox dashboard

— David Maksimov   4 years ago
0

Hmm, the error specifically says that the Stored Procedure isn't installed in the database. That doesn't get installed by default. So either the dbplan is missing something or the CLI command you are running isn't picking it up properly.

— Trey Teter   4 years ago
0

It looks like it might be missing altogether.

— Trey Teter   4 years ago
Show more results postcomments
Report
Write your answer
108 Views
2 Answers
4 years ago
4 years ago
Tags
Answered question