Skip to main content
srenj0001
Participating Frequently
February 3, 2022
Solved

Database scripts not included when exporting package

  • February 3, 2022
  • 3 replies
  • 0 views

I have made an application package, containing changes that require a couple of database tables to be modified: Some columns are removed, one is added and one is renamed.

To this end, I have created three text files with suffix .sql. They contain SQL code, copied from MariaDB, which has a "Preview SQL" button.

I add these script files to the package, like this:

The problem is, that when I export the package, I get this message:

What is the point of having a "database scripts" section in packages, if the scripts are omitted from the exported package??

For your information, the SQL files look like this (first file shown):

ALTER TABLE `sxdatahp1` DROP `storedebitorer`;
ALTER TABLE `sxdatahp1` DROP `abnekravdebitor`;
ALTER TABLE `sxdatahp1` DROP `abnekravkoeretoej`;
ALTER TABLE `sxdatahp1` DROP `kravudligningsbilag`;
ALTER TABLE `sxdatahp1` DROP `refusionudligningsbilag`;

ALTER TABLE `sxdatahp2` DROP `storedebitorer`;
ALTER TABLE `sxdatahp2` DROP `abnekravdebitor`;
ALTER TABLE `sxdatahp2` DROP `abnekravkoeretoej`;
ALTER TABLE `sxdatahp2` DROP `kravudligningsbilag`;
ALTER TABLE `sxdatahp2` DROP `refusionudligningsbilag`;

We use version 21.4 of Appian:

Regards

Søren Juul

BPM Developer

Udviklings- og Forenklingsstyrelsen, SKAT (the danish Tax Authority)

soeren.juul@ufst.dk

Best answer by vinayp0002

Yes, you can raise this issue.

Meanwhile, you can go to admin console  if you have access and you can find Infrastructure under devops section where you can add environments for direct deployments.

3 replies

vinayp0002
February 4, 2022

Hello [mention:149194ea020141a19cd52893d78624c7:e9ed411860ed4f2ba0265705b8793d05],

I believe that would work when you try to deploy through Compare and deploy functionality.

If you are trying to do that manually by export and import package as you do.

srenj0001
srenj0001Author
Participating Frequently
February 8, 2022

Hi Vinay

Thank you for your suggestion. I guess it will work, only problem is that our DEV/TEST/PROD environments are not connected.
I will raise this issue with our DevOps department, to get the environments properly connected.

vinayp0002
February 8, 2022

Yes, you can raise this issue.

Meanwhile, you can go to admin console  if you have access and you can find Infrastructure under devops section where you can add environments for direct deployments.