Maximo Open Forum

 View Only

 Invalid filegroup 'MAXDATA' specified, during Manage 9.0.5 Playbook installation

Jump to  Best Answer
  • Maximo Application Suite
Alexei Lopez's profile image
Alexei Lopez posted 12-18-2024 16:15

Hello,

I'm facing this issue during Manage 9.0.5 installation, I'm following the   MAS DevOps Ansible Collection using Manage playbook installation usinf an external sql Database ,

export MAS_INSTANCE_ID=inst1
export MAS_CONFIG_DIR=~/masconfig
export IBM_ENTITLEMENT_KEY=xxx
 
export CONFIGURE_EXTERNAL_DB=true
export DB_INSTANCE_ID=maxdbxx
export MAS_JDBC_USER=maximo
export MAS_JDBC_PASSWORD=xxx
export MAS_JDBC_URL=xxx
 
export MAS_APP_SETTINGS_DB_SCHEMA=maximo
export MAS_APP_SETTINGS_TABLESPACE=maxdata
export MAS_APP_SETTINGS_INDEXSPACE=maxindex

unfortunately i get this error during the maxinst process

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid filegroup 'MAXDATA' specified.
2188at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261)
2189at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1752)
2190at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:946)
2191at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:840)
2192at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7739)
2193at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4384)
2194at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:293)
2195at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:263)
2196at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:813)
2197at psdi.configure.Maxinst.doSql(Maxinst.java:2370)
2198at psdi.configure.Maxinst.doOneUnlcvtLine(Maxinst.java:636)
2199at psdi.configure.Maxinst.doUnlcvtSql(Maxinst.java:499)
2200at psdi.configure.Maxinst.process(Maxinst.java:414)
2201at psdi.configure.Maxinst.main(Maxinst.java:2847)
2202Invalid filegroup 'MAXDATA' specified. Wed Dec 18 20:58:50 GMT 2024
2203Invalid filegroup 'MAXDATA' specified. Wed Dec 18 20:58:50 GMT 2024
2204BMXAA6819I - Maxinst completed with errors. Wed Dec 18 20:58:50 GMT 2024
I've created a MAXDATA file group manually on the DB and then I get this other message and I can see that tables are being rated but then I got this message:
The filegroup "MAXDATA" has no files assigned to it, 
Have any one experienced this issue? 
Steven Shull's profile image
Steven Shull  Best Answer

For SQL Server, you should be using PRIMARY for the TABLESPACE & INDEXSPACE. Those are really for Oracle/DB2 systems. 

Alexei Lopez's profile image
Alexei Lopez

Thanks Steven Shull, after setting up to Primary I was able to complete the Manage Installation