During creation of a table, we're getting an error message:
Creating new tables...
Creating table z_xxx...
Can't spawn "cmd.exe": Inappropriate I/O control operation at .\pdm_publish.pl
line 255, <ALTERTBL> line 1.
AHD04748:orclbuild failed for table z_xxx
- NX.env has got MDB_DATA and MDB_INDEX as the tablespace names.
- In checking the Oracle MDB schema with a SQL like: select tablespace_name from dba_tablespaces; we get output like: MDBADMIN_DATA_m1_01 and MDBADMIN_INDEX_m1_01.
Fix is to ensure that the tablespace names match, so the recommended approach is to do a pdm-configure, un-select REMOTE DATABASE OPTION so as to put the correct tablespace names AND then CHECK ON the remote database option back again and continue further. Once pdm_configure saves the options properly, thenpdm_publish would work fine as well.
Another option is to make sure the correct values for NX_MDB_DATA and NX_MDB_INDEX are set and run pdm_publish.