You seem to be getting the directory name for your Confluence from a select. I would advise you to first run the select without the insert and see if it returns something. Also, you need to add a space after 'select'.
If it returns something, you can simply replace the select by the directory_id. For what your error says, it seems to me that your select does not return anything, that is why it is saying it cannot be null. You can run the following select that will show you the available directories:
select * from cwd_directory;
This is basically the same select with not conditions, so it will show everything. From them you find the confluence directory to use in your insert.
* Run select id from cwd_directory where directory_name='Confluence Internal Directory'
** Does it return something? If not, this is the problem
* Run select * from cwd_directory;
* Select one directory id from the list
* Run your select replacing the select by the chosen directory id.
I hope it was helpful.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Community, Jessica here from the Confluence Product Marketing team! July’s community challenge is all about sharing pictures — and as an extension of our first post on what ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs