The TouchApps server itself is set up and works for other instances. I’m deploying it for another instance.
First, I ran the “PrepareTAS.sql” job. It ran with no errors. I checked that the user accounts and table spaces were set up.
Then, I ran the “IFS Touch Apps Server Installation Package 1.15.1.672”. I check along the way to ensure that every connection works and that App Server can be pinged.
It errors out at the Install step. This is the error in the log.
CREATE TABLE "APP_SERVER_SESSION_TAB"("CLOUD_INSTALLATION_ID" NVARCHAR2(100) NOT NULL,"BASE_URL" NVARCHAR2(100) NULL,"AUTH_TOKEN" NVARCHAR2(50) NULL,"STARTED_UTC" TIMESTAMP NULL,"STARTING_UTC" TIMESTAMP NOT NULL) <Oracle.ManagedDataAccess.Client.OracleException><Message>ORA-01031: insufficient privileges</Message></Oracle.ManagedDataAccess.Client.OracleException>
DateTime=2021-12-23T14:09:20.9374551Z
If I log directly into the database via SQL Developer as IFSTAS, it allows me to create the table in the IFSTAS schema.
There’s no way to tell what UserID is being referenced above. Is it not IFSTAS? The table is supposed to be under the IFSTAS schema, so it seems logical that it’s the IFSTAS user, but who knows. Has anyone had a similar issue? Any thoughts?