Getting an error during pdm_publish: AHD04748: orclbuild failed for table z_xxx.

Document ID : KB000048265
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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

Solution:

Background:

  • 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.