Webhooks not working

[JuiceyBrucey]

Trying to create a new demo database so I can test it with the webhooks subscriber plugin, but not having any luck.
I am assuming I must copy the current JIWA database and rename it. Ordinarily this would be a no brainer in MySQL, but I am struggling with doing this in JIWA or MS SQL Server Management Studio version 18.2.
There is a copy feature in non express version of this program, but not in mine as I am express.
I have looked at lots of tutorials on how to do this but keep hitting brick walls.
can you suggest a simple way of doing this?
Thank you

[SBarnes]

At the login screen click the databases button and choose the first option in the wizard

[JuiceyBrucey]

almost got there but got this error when the wizard was creating the database:
"restore database from BACPAC file: could not import package"
Tried to look this error up, but found nothing that is specific to this issue.
Any ideas?
Thank you

[JuiceyBrucey]

I tried making a bacpac file but got this message:
TITLE: Microsoft SQL Server Management Studio
------------------------------

One or more unsupported elements were found in the schema used as part of a data package.
Error SQL46010: View: [dbo].[v_SY_WebhookSubscriber_Messages] contains a statement that is not supported on Microsoft Azure SQL Database v12. The specific error is: Incorrect syntax near URL.
Error SQL46010: View: [dbo].[v_SY_WebhookSubscriber_MessageResponses] contains a statement that is not supported on Microsoft Azure SQL Database v12. The specific error is: Incorrect syntax near URL.
(Microsoft.SqlServer.Dac)

------------------------------
BUTTONS:

OK
------------------------------

[Mike.Sheen]

almost got there but got this error when the wizard was creating the database:
"restore database from BACPAC file: could not import package"
Tried to look this error up, but found nothing that is specific to this issue.
Any ideas?
Thank you

What version of SQL Server are you using, and what Jiwa SR level have you got? I'd be wanting to make sure you have Jiwa 7.2.1 SR15 installed, and make sure your SQL Server version is later than 2012.

[Mike.Sheen]

I tried making a bacpac file but got this message:

Don't do that. You don't need to make a bacpac... you're going off piste.

[JuiceyBrucey]

SQL Server Management Studio 15.0.18142.0
Microsoft Analysis Services Client Tools 15.0.1389.0
Microsoft Data Access Components (MDAC) 10.0.19041.2913
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.11.19041.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.19044

Jiwa Financials
===============
Application Version : 7.2.1.0
Database Version : 7.2.1
SQL Version : 15.0.2000.5
SQL Version String : Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Sep 24 2019 13:48:23
Copyright (C) 2019 Microsoft Corporation
Express Edition (64-bit) on Windows 10 Pro 10.0 <X64> (Build 19044: )

Not sure how to find the service release, sorry.

[Scott.Pearce]

Not sure how to find the service release, sorry.

If you have a Jiwa SR installed for 7.2.1 you will see an entry in:

Control Panel -> Program and Features -> View Installed Updates

If no such entry exists, you have 7.2.1 with no Service Release installed.

I suspect your problem is that you need to install 7.2.1 SR 15, available from https://support.jiwa.com.au/Home/Downloads

[JuiceyBrucey]

Hi, Thanks for reply.
So the SR 15 was not present. I downloaded and installed it.
I had some issues afterwards with this error on restart:
System.MissingMethodException: Method not found: 'Void JiwaFinancials.Jiwa.JiwaApplication.Manager.LogEvent(System.String, System.Diagnostics.EventLogEntryType, Int32, Int16)

I deleted the contents of C:\ProgramData\Jiwa Financials\Jiwa 7 then restarted the API. The problem went away.
But I still cannot see any subscribers added in the SY_WebhookSubscriber table.
The API still returns:
array(2) {
["Results"]=>
array(0) {
}
["Meta"]=>
array(0) {
}
}

Do you want me to do the whole subscriber process in postman and send all the raw headers?
Anything else you can think of?
Thank you

[Scott.Pearce]

OK. What version is the REST API plugin in Jiwa?

Edit: Get the REST API plugin that ships with SR15. After installing SR15, extract the latest REST API Plugin from the RESTAPI.zip file in the Jiwa installation folder. Import plugin. Restart service.