hello,

Im trying to generate tables for IS but I faced an issue from the Configurator UI (table or view doesnt exist)

after some digging, I found that the scrip runs need to find the “WEBMINDEX” tablespace, and if not the scripts created one, same for the “WEBMDATA” tablespace, so should I try to create those tablespaces manually or there’s some workaround we can apply
the DB user has all privilege

31008×828 41.5 KB

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/71a36a453249ba6d42251a391f95e144c73fd709_2_690x750.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/71a36a453249ba6d42251a391f95e144c73fd709.png 2x" data-dominant-color="EEF3F7">

4879×954 26.6 KB

if you have any ideas please share them with me, thank you.

There is an option on the UI (unchecked and greyed out by default) to create the TS, if you have a database user with the right privileges.

Follow the instructions in the “webMethods Database Configuration” guide that you can find on the documentation site, for creating a TS.

Documentation - https://documentation.softwareag.com/

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/00dbf88622b621e5c2d132e82ce82f0e2802ff75_2_337x750.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/00dbf88622b621e5c2d132e82ce82f0e2802ff75_2_450x1000.jpeg 2x" data-dominant-color="D5D5D5">

Screenshot_2023-02-17-17-43-36-359_com.adobe.reader1080×2400 193 KB

KM

Solved for me, I used a system user to create the tablespace instead of webmuser (regardless of that webmuser already has all privileges)

https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/c1519faa2c2fbf736cff20eeaa9f74c5bf065d64_2_729x750.png 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files/c1519faa2c2fbf736cff20eeaa9f74c5bf065d64.png 2x" data-dominant-color="E1E7EC">

5886×910 27.5 KB