Discuss.FOLIO.org is no longer used. This is a static snapshot of the website as of February 14, 2023.

Tenant operation failed for module mod-finance-storage-8.1.6: SQL error

ataliques
15 Sep '22

Hello,

I am getting below error after running following command, can any one please assist.

curl -w ‘\n’ -D - -X POST -H “Content-type: application/json” -d @$HOME/platform-complete/install.json http://localhost:9130/_/proxy/tenants/diku/install?deploy=false&preRelease=false&tenantParameters=loadReference%3Dfalse
HTTP/1.1 100 Continue

HTTP/1.1 500 Internal Server Error
Content-Type: text/plain
content-length: 1944

Tenant operation failed for module mod-finance-storage-8.1.6: SQL error
INSERT INTO diku_mod_finance_storage.transaction SELECT public.uuid_generate_v5(public.uuid_nil(), concat(‘PPCM1’, fdi.il->>‘id’, invoices.id, vouchers.id, budget.id, fy.id)), jsonb_strip_nulls(jsonb_build_object(‘transactionType’, ‘Pending payment’, ‘fromFundId’, fd->>‘fundId’, ‘amount’, fdi.amount*(vouchers.jsonb->>‘exchangeRate’)::decimal, ‘source’, ‘Invoice’, ‘sourceInvoiceId’, invoices.id, ‘sourceInvoiceLineId’, fdi.il->>‘id’, ‘fiscalYearId’, budget.fiscalYearId, ‘currency’, fy.jsonb->>‘currency’, ‘awaitingPayment’, CASE WHEN fdi.fd ?‘encumbrance’ THEN jsonb_build_object(‘encumbranceId’, fdi.fd->>‘encumbrance’, ‘releaseEncumbrance’, fdi.il->>‘releaseEncumbrance’) ELSE null END)) FROM (SELECT fd, (CASE WHEN fd->>‘distributionType’=‘amount’ THEN (fd->>‘value’)::decimal ELSE ((i.jsonb->>‘total’)::decimal*(fd->>‘value’)::decimal)/100 END) AS amount, i.jsonb AS il FROM diku_mod_invoice_storage.invoice_lines AS i, jsonb_array_elements(i.jsonb->‘fundDistributions’) AS fd) AS fdi LEFT JOIN diku_mod_invoice_storage.invoices AS invoices ON invoices.id::text = fdi.il->>‘invoiceId’ LEFT JOIN diku_mod_invoice_storage.vouchers AS vouchers ON invoices.id=vouchers.invoiceId LEFT JOIN diku_mod_finance_storage.budget AS budget ON budget.fundId::text = fdi.fd->>‘fundId’ LEFT JOIN diku_mod_finance_storage.fiscal_year AS fy ON fy.id=budget.fiscalYearId WHERE invoices.jsonb->>‘status’ = ‘Approved’ AND budget.jsonb->>‘budgetStatus’=‘Active’;